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