APPS.ICX_CAT_POPULATE_MI_PVT dependencies on ICX_CAT_BUILD_CTX_SQL_PVT

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

1640: RAISE;
1641: END populateCategoryItems;
1642:
1643: PROCEDURE buildCtxSqlForMIs
1644: ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type,
1645: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
1646: )
1647: IS
1648: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForMIs';

Line 1645: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type

1641: END populateCategoryItems;
1642:
1643: PROCEDURE buildCtxSqlForMIs
1644: ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type,
1645: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
1646: )
1647: IS
1648: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForMIs';
1649: l_err_loc PLS_INTEGER;

Line 1660: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo

1656: 'about to call buildmetadatinfo');
1657: END IF;
1658:
1659: l_err_loc := 200;
1660: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
1661: (0, g_special_metadata_tbl, g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl);
1662: l_err_loc := 300;
1663: ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed := TRUE;
1664: END IF;

Line 1674: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

1670: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1671: 'about to call buildctxsql');
1672: END IF;
1673: l_err_loc := 500;
1674: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1675: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'NOTROWID', g_special_metadata_tbl,
1676: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
1677: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
1678: l_err_loc := 600;