DBA Data[Home] [Help]

APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on CSP_REPAIR_PO_GRP

Line 81: CSP_REPAIR_PO_GRP.create_csp_index(lv_sql_stmt,'CSP_REPAIR_PO_HEADERS_N1');

77: || 'INVENTORY_ITEM_ID) TABLESPACE '
78: ||lv_index_tablespace;
79: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);
80: BEGIN
81: CSP_REPAIR_PO_GRP.create_csp_index(lv_sql_stmt,'CSP_REPAIR_PO_HEADERS_N1');
82: lv_status :=1 ;
83: EXCEPTION
84: WHEN OTHERS THEN
85: IF SQLCODE IN (-01408) THEN

Line 103: CSP_REPAIR_PO_GRP.create_csp_index(lv_sql_stmt,'CSP_REPAIR_PO_HEADERS_N2');

99: || '( purchase_order_header_id) TABLESPACE '
100: ||lv_index_tablespace;
101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);
102: BEGIN
103: CSP_REPAIR_PO_GRP.create_csp_index(lv_sql_stmt,'CSP_REPAIR_PO_HEADERS_N2');
104: lv_status :=1 ;
105: EXCEPTION
106: WHEN OTHERS THEN
107: IF SQLCODE IN (-01408) THEN

Line 125: CSP_REPAIR_PO_GRP.create_csp_index(lv_sql_stmt,'CSP_REPAIR_PO_HEADERS_N3');

121: || '( requisition_line_id ) TABLESPACE '
122: ||lv_index_tablespace;
123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);
124: BEGIN
125: CSP_REPAIR_PO_GRP.create_csp_index(lv_sql_stmt,'CSP_REPAIR_PO_HEADERS_N3');
126: lv_status :=1 ;
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF SQLCODE IN (-01408) THEN