[Home] [Help]
PACKAGE: APPS.ICX_CAT_POPULATE_MI_PVT
Source
1 PACKAGE ICX_CAT_POPULATE_MI_PVT AS
2 /* $Header: ICXVPPMS.pls 120.2 2006/06/21 19:13:08 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_CtxSqlForMIsFormed BOOLEAN := FALSE;
12
13 PROCEDURE populateMIs
14 ( p_masterItem_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
15 p_current_mode IN VARCHAR2
16 );
17
18 PROCEDURE upgradeR12MIs
19 ( p_upgrade_last_run_date IN DATE ,
20 p_start_rowid IN ROWID ,
21 p_end_rowid IN ROWID
22 );
23
24 PROCEDURE populateItemChange
25 ( P_INVENTORY_ITEM_ID IN NUMBER ,
26 P_ORGANIZATION_ID IN NUMBER ,
27 P_REQUEST_ID IN NUMBER ,
28 P_ENTITY_TYPE IN VARCHAR2
29 );
30
31 PROCEDURE populateItemDelete
32 ( P_INVENTORY_ITEM_ID IN NUMBER ,
33 P_ORGANIZATION_ID IN NUMBER
34 );
35
36 PROCEDURE populateItemCatgChange
37 ( P_INVENTORY_ITEM_ID IN NUMBER ,
38 P_ORGANIZATION_ID IN NUMBER ,
39 P_CATEGORY_ID IN NUMBER ,
40 P_REQUEST_ID IN NUMBER ,
41 P_ENTITY_TYPE IN VARCHAR2
42 );
43
44 PROCEDURE populateItemCatgDelete
45 ( P_INVENTORY_ITEM_ID IN NUMBER ,
46 P_ORGANIZATION_ID IN NUMBER
47 );
48
49 PROCEDURE populateCategoryItems
50 ( P_MTL_CATEGORY_ID_TBL IN DBMS_SQL.NUMBER_TABLE
51 );
52
53 PROCEDURE buildCtxSqlForMIs
54 ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type,
55 p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
56 );
57
58 END ICX_CAT_POPULATE_MI_PVT;