DBA Data[Home] [Help]

PACKAGE: APPS.FII_FIN_CAT_MAINTAIN_PKG

Source


1 PACKAGE FII_FIN_CAT_MAINTAIN_PKG AUTHID CURRENT_USER AS
2 /* $Header: FIIFICMS.pls 115.2 2003/08/22 00:39:50 phu noship $  */
3 
4 -- *******************************************************************
5 -- Package level variables
6 -- *******************************************************************
7 
8  FINDIM_VS_ID		NUMBER		:= NULL;
9  FIIDIM_Debug		BOOLEAN		:= FALSE;
10  FII_User_Id		NUMBER		:= NULL;
11  FII_Login_Id		NUMBER		:= NULL;
12  FII_Req_Id		NUMBER		:= NULL;
13  FINDIM_PARENT_FLEX_ID 	NUMBER(15)	:= NULL;
14  FINDIM_PARENT_VSET_ID 	NUMBER(15)	:= NULL;
15  FINDIM_PARENT_NODE     VARCHAR2(150)   := NULL;
16  FINDIM_imm_Child       VARCHAR2(150)   := NULL;
17  FINDIM_imm_Child_ID	NUMBER(15)	:= NULL;
18  FINDIM_fatal_err	EXCEPTION;
19  FINDIM_MULT_PAR_err    EXCEPTION;
20  FINDIM_Invalid_FC_ASG_err EXCEPTION;
21  FINDIM_NOT_ENABLED     EXCEPTION;
22  FINDIM_NO_FC_TYPE_ASGN EXCEPTION;
23  FINDIM_next_is_leaf    VARCHAR2(1)     := NULL;
24 
25 -- ************************************************************************
26 -- Procedure
27 --   Init_Load          This is the main procedure of FC dimension maintenance
28 --                      program (initial load).
29 --                      It will take in all parameters, initialize all necessary
30 --                      variables and start calling the appropriate routines.
31 -- Arguments
32 --   errbuf		Standard error buffer
33 --   retcode 		Standard return code
34 
35   PROCEDURE Init_Load (errbuf		OUT	NOCOPY VARCHAR2,
36 		       retcode		OUT	NOCOPY VARCHAR2);
37 
38 -- ************************************************************************
39 -- Procedure
40 --   Incre_Update       This is the main procedure of FC dimension maintenance
41 --                      program (incremental update).
42 --                      It will take in all parameters, initialize all necessary
43 --                      variables and start calling the appropriate routines.
44 -- Arguments
45 --   errbuf		Standard error buffer
46 --   retcode 		Standard return code
47 
48   PROCEDURE Incre_Update (errbuf   OUT  NOCOPY  VARCHAR2,
49 		          retcode  OUT  NOCOPY  VARCHAR2);
50 
51 END FII_FIN_CAT_MAINTAIN_PKG;