APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on ICX_CAT_BUILD_CTX_SQL_PVT

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

870: RAISE;
871: END populateOnlineReqTemplates;
872:
873: PROCEDURE buildCtxSqlForRTs
874: ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type ,
875: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
876: )
877: IS
878: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForRTs';

Line 875: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type

871: END populateOnlineReqTemplates;
872:
873: PROCEDURE buildCtxSqlForRTs
874: ( p_special_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type ,
875: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
876: )
877: IS
878: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForRTs';
879: l_err_loc PLS_INTEGER;

Line 890: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo

886: 'about to call buildmetadatinfo');
887: END IF;
888:
889: l_err_loc := 200;
890: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
891: (0, g_special_metadata_tbl, g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl);
892:
893: l_err_loc := 300;
894: ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed := TRUE;

Line 906: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

902: 'about to call buildctxsql');
903: END IF;
904:
905: l_err_loc := 500;
906: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
907: (0, ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const, 'NOTROWID', g_special_metadata_tbl,
908: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
909: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
910: