[Home] [Help]
PACKAGE: APPS.FII_LOB_MAINTAIN_PKG
Source
1 PACKAGE FII_LOB_MAINTAIN_PKG AUTHID CURRENT_USER AS
2 /* $Header: FIILBCMS.pls 115.2 2003/08/22 00:25:23 phu noship $ */
3
4 -- *******************************************************************
5 -- Package level variables
6 -- *******************************************************************
7
8 LOBDIM_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 LOBDIM_PARENT_FLEX_ID NUMBER(15) := NULL;
14 LOBDIM_PARENT_VSET_ID NUMBER(15) := NULL;
15 LOBDIM_PARENT_NODE VARCHAR2(150) := NULL;
16 LOBDIM_imm_Child VARCHAR2(150) := NULL;
17 LOBDIM_imm_Child_ID NUMBER(15) := NULL;
18 LOBDIM_fatal_err EXCEPTION;
19 LOBDIM_MULT_PAR_err EXCEPTION;
20 LOBDIM_NOT_ENABLED EXCEPTION;
21 LOBDIM_next_is_leaf VARCHAR2(1) := NULL;
22
23 -- ************************************************************************
24 -- Procedure
25 -- Init_Load This is the main procedure of LOB dimension maintenance
26 -- program (initial load).
27 -- It will take in all parameters, initialize all necessary
28 -- variables and start calling the appropriate routines.
29 -- Arguments
30 -- errbuf Standard error buffer
31 -- retcode Standard return code
32
33 PROCEDURE Init_Load (errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY VARCHAR2);
35
36 -- ************************************************************************
37 -- Procedure
38 -- Incre_Update This is the main procedure of LOB dimension maintenance
39 -- program (incremental update).
40 -- It will take in all parameters, initialize all necessary
41 -- variables and start calling the appropriate routines.
42 -- Arguments
43 -- errbuf Standard error buffer
44 -- retcode Standard return code
45
46 PROCEDURE Incre_Update (errbuf OUT NOCOPY VARCHAR2,
47 retcode OUT NOCOPY VARCHAR2);
48
49 END FII_LOB_MAINTAIN_PKG;