[Home] [Help]
PACKAGE: APPS.FII_UDD1_MAINTAIN_PKG
Source
1 PACKAGE FII_UDD1_MAINTAIN_PKG AS
2 /* $Header: FIIU1CMS.pls 120.1 2005/10/30 05:05:37 appldev noship $ */
3
4 -- *******************************************************************
5 -- Package level variables
6 -- *******************************************************************
7
8 UDIM1_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 UDIM1_PARENT_FLEX_ID NUMBER(15) := NULL;
14 UDIM1_PARENT_VSET_ID NUMBER(15) := NULL;
15 UDIM1_PARENT_NODE VARCHAR2(150) := NULL;
16 UDIM1_imm_Child VARCHAR2(150) := NULL;
17 UDIM1_imm_Child_ID NUMBER(15) := NULL;
18 UDIM1_fatal_err EXCEPTION;
19 UDIM1_MULT_PAR_err EXCEPTION;
20 UDIM1_NOT_ENABLED EXCEPTION;
21 UDIM1_next_is_leaf VARCHAR2(1) := NULL;
22
23 -- ************************************************************************
24 -- Procedure
25 -- Init_Load This is the main procedure of User Defined dimension1
26 -- maintenance 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 User Defined dimension1
39 -- maintenance 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_UDD1_MAINTAIN_PKG;