APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on ICX_CAT_BUILD_CTX_SQL_PVT

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

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

Line 878: p_regular_ctx_sql_tbl IN OUT NOCOPY ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type

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

Line 893: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo

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

Line 909: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

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