[Home] [Help]
PACKAGE: APPS.ICX_CAT_POPULATE_PODOCS_PVT
Source
1 PACKAGE ICX_CAT_POPULATE_PODOCS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ICXVPPDS.pls 120.3 2006/06/21 19:14:12 sbgeorge noship $*/
3
4 g_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
5 g_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
6 g_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
7 g_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
8 g_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
9 g_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
10 g_metadataTblFormed BOOLEAN := FALSE;
11 g_CtxSqlForPODocsFormed BOOLEAN := FALSE;
12
13 PROCEDURE populateBPAs
14 ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
15 p_current_mode IN VARCHAR2
16 );
17
18 PROCEDURE populateGBPAs
19 ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
20 p_current_mode IN VARCHAR2
21 );
22
23 PROCEDURE populateOnlineBlankets
24 ( p_key IN NUMBER
25 );
26
27 PROCEDURE populateOnlineOrgAssgnmnts
28 ( p_key IN NUMBER
29 );
30
31 PROCEDURE populateBPAandQuotes
32 ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
33 p_current_mode IN VARCHAR2
34 );
35
36 PROCEDURE upgradeR12PODocs
37 ( p_upgrade_last_run_date IN DATE ,
38 p_start_rowid IN ROWID ,
39 p_end_rowid IN ROWID
40 );
41
42 PROCEDURE populateQuotes
43 ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
44 p_current_mode IN VARCHAR2
45 );
46
47 PROCEDURE populateOnlineQuotes
48 ( p_key IN NUMBER
49 );
50
51 PROCEDURE buildCtxSqlForPODocs
52 ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type ,
53 p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
54 );
55
56 END ICX_CAT_POPULATE_PODOCS_PVT;