PACKAGE: APPS.ICX_CAT_POPULATE_REQTMPL_PVT

Source

1 PACKAGE ICX_CAT_POPULATE_REQTMPL_PVT AUTHID CURRENT_USER AS
2 /* $Header: ICXVPPRS.pls 120.3 2006/06/21 19:13:41 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 populateReqTemplates
14 (       p_reqTemplate_csr       IN              ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type       ,
15         p_current_mode          IN              VARCHAR2
16 );
17 
18 PROCEDURE upgradeR12ReqTemplates
19 (       p_upgrade_last_run_date IN      DATE    ,
20         p_start_rowid           IN      ROWID   ,
21         p_end_rowid             IN      ROWID
22 );
23 
24 PROCEDURE populateOnlineReqTemplates
25 (       p_key                   IN              NUMBER
26 );
27 
28 PROCEDURE buildCtxSqlForRTs
29 (       p_special_ctx_sql_tbl   IN OUT NOCOPY   ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type    ,
30         p_regular_ctx_sql_tbl   IN OUT NOCOPY   ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
31 );
32 
33 END ICX_CAT_POPULATE_REQTMPL_PVT;