PACKAGE: APPS.FII_GL_EXTRACTION_UTIL

Source

1 PACKAGE FII_GL_EXTRACTION_UTIL AS
2 /* $Header: FIIGLXUS.pls 120.1 2005/10/30 05:13:07 appldev noship $ */
3 
4 ----------------------------------------
5 -- procedure load_ccc_mgr
6 --
7 -- Load global temporary table FII_CCC_MGR_GT if it is empty.
8 -- Set p_retcode to 0 for normal termination.
9 -- Set p_retcode to -1 for any exception.
10 ----------------------------------------
11 PROCEDURE LOAD_CCC_MGR(
12 	p_retcode	out nocopy varchar2
13 );
14 
15 ----------------------------------------
16 -- function check_missing_ccc_mgr
17 --
18 -- Call procedure load_ccc_mgr.
19 -- Return the number of ccc_org_id(s) in global temporary table
20 -- FII_CCC_MGR_GT with missing current manager.
21 -- If there is no such ccc_org_id, return 0.
22 -- If there are such ccc_org_id(s), return the number, and print
23 -- details to the concurrent program output file.
24 ----------------------------------------
25 FUNCTION CHECK_MISSING_CCC_MGR RETURN NUMBER;
26 
27 ----------------------------------------
28 -- procedure Get_UNASSIGNED_ID
29 -- Return the Unassigned node id
30 -- and the value set id
31 -- Set p_retcode to -1 for any exception.
32 ----------------------------------------
33 PROCEDURE Get_UNASSIGNED_ID(p_UNASSIGNED_ID out nocopy number, p_UNASSIGNED_VSET_ID out nocopy number,
34     p_retcode out nocopy varchar2
35 );
36 
37 END FII_GL_EXTRACTION_UTIL;