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;
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;
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;
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;
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;
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:
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;
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;