APPS.ICX_CAT_POPULATE_MI_PVT dependencies on ICX_CAT_BUILD_CTX_SQL_PVT

Line 1637: ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type,

1633: RAISE;
1634: END populateCategoryItems;
1635:
1636: PROCEDURE buildCtxSqlForMIs
1637: ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type,
1638: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
1639: )
1640: IS
1641: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForMIs';

Line 1638: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type

1634: END populateCategoryItems;
1635:
1636: PROCEDURE buildCtxSqlForMIs
1637: ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type,
1638: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
1639: )
1640: IS
1641: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForMIs';
1642: l_err_loc PLS_INTEGER;

Line 1653: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo

1649: 'about to call buildmetadatinfo');
1650: END IF;
1651:
1652: l_err_loc := 200;
1653: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
1654: (0, g_special_metadata_tbl, g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl);
1655: l_err_loc := 300;
1656: ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed := TRUE;
1657: END IF;

Line 1667: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

1663: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1664: 'about to call buildctxsql');
1665: END IF;
1666: l_err_loc := 500;
1667: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1668: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'NOTROWID', g_special_metadata_tbl,
1669: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
1670: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
1671: l_err_loc := 600;