• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• CAL_ASSESTATO.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

expsigladb.Package.CAL_ASSESTATO.sql Maven / Gradle / Ivy

--------------------------------------------------------
--  DDL for Package CAL_ASSESTATO
--------------------------------------------------------

  CREATE OR REPLACE PACKAGE "CAL_ASSESTATO" IS
FUNCTION ASSESTATO_ENTRATA(
  P_Anno        IN number ,
  P_dip         IN varchar2 ,
  P_CDS         IN varchar2 ,
  P_UO          IN varchar2 ,
  P_CDR         IN varchar2 ,
  P_ELE_VOCE    IN varchar2 ,
  P_LINEA       IN varchar2 ,
  P_PG_VAR      IN varchar2 ,
  P_LIV1        IN varchar2 ,
  P_LIV2        IN varchar2 ,
  P_LIV3        IN varchar2 ,
  P_LIV4        IN varchar2 ,
  P_LIV5        IN varchar2 ,
  P_LIV6        IN varchar2 ,
  P_LIV7        IN varchar2 ,
  P_Stringa     IN varchar2 )
RETURN NUMBER;

FUNCTION ASSESTATO_SPESA(
  P_Anno        IN number ,
  P_dip         IN varchar2 ,
  P_CDS         IN varchar2 ,
  P_UO          IN varchar2 ,
  P_CDR         IN varchar2 ,
  P_ELE_VOCE    IN varchar2 ,
  P_LINEA       IN varchar2 ,
  P_PG_VAR      IN varchar2 ,
  P_LIV1        IN varchar2 ,
  P_LIV2        IN varchar2 ,
  P_LIV3        IN varchar2 ,
  P_LIV4        IN varchar2 ,
  P_LIV5        IN varchar2 ,
  P_LIV6        IN varchar2 ,
  P_LIV7        IN varchar2 ,
  P_Stringa     IN varchar2 )
RETURN NUMBER;

FUNCTION ASSESTATO_SPESA_RES(
  P_Anno        IN number ,
  P_Anno_RES    IN number ,
  P_CDS         IN varchar2 ,
  P_UO          IN varchar2 ,
  P_CDR         IN varchar2 ,
  P_ELE_VOCE    IN varchar2 ,
  P_LINEA       IN varchar2 ,
  P_Stringa     IN varchar2 )
RETURN NUMBER;


END CAL_ASSESTATO;