APPS.IEC_SUBSET_PVT dependencies on IEC_O_TRANSITION_SUBSETS

Line 1200: from iec_o_transition_subsets

1196: , orig_itm_cc_tz_id
1197: , new_itm_cc_tz_id
1198: , call_Attempts
1199: , count(*) NUM_ENTRIES
1200: from iec_o_transition_subsets
1201: where (record_out_Flag = 'N' OR record_out_flag = 'R')
1202: -- and new_subset_id <> orig_subset_id
1203: and list_id = P_TARGET_GROUP_ID
1204: group by orig_subset_id

Line 1230: 'FROM IEC_O_TRANSITION_SUBSETS C ' ||

1226: 'SET A.SUBSET_ID = :newSubset ' ||
1227: ', A.ITM_CC_TZ_ID = :newCallZone ' ||
1228: ', A.PULLED_SUBSET_ID = NULL ' ||
1229: 'WHERE A.LIST_ENTRY_ID IN (SELECT C.LIST_ENTRY_ID ' ||
1230: 'FROM IEC_O_TRANSITION_SUBSETS C ' ||
1231: 'WHERE C.LIST_ID = :listID ' ||
1232: 'AND C.NEW_SUBSET_ID = :newSubset ' ||
1233: 'AND C.ORIG_SUBSET_ID = :origSubset ' ||
1234: 'AND C.NEW_ITM_CC_TZ_ID = :newCall ' ||

Line 1290: 'FROM IEC_O_TRANSITION_SUBSETS H ' ||

1286: ' WHERE G.PHONE_INDEX = 6 ' ||
1287: ' AND G.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1288: ' AND G.LIST_ID = A.LIST_HEADER_ID ) ' ||
1289: 'WHERE A.LIST_ENTRY_ID IN (SELECT H.LIST_ENTRY_ID ' ||
1290: 'FROM IEC_O_TRANSITION_SUBSETS H ' ||
1291: 'WHERE H.LIST_ID = :listID ' ||
1292: 'AND H.NEW_SUBSET_ID = :newSubset ' ||
1293: 'AND H.ORIG_SUBSET_ID = :origSubset ' ||
1294: 'AND H.NEW_ITM_CC_TZ_ID = :newCall ' ||

Line 2110: EXECUTE IMMEDIATE 'DELETE FROM iec_o_transition_subsets ' ||

2106: -- to this target group. If we only allow one subset transition
2107: -- at a time, then we could truncate the table.
2108: ----------------------------------------------------------------
2109: BEGIN
2110: EXECUTE IMMEDIATE 'DELETE FROM iec_o_transition_subsets ' ||
2111: 'WHERE list_id = :1 '
2112: USING P_TARGET_GROUP_ID;
2113: EXCEPTION
2114: WHEN OTHERS THEN

Line 2124: EXECUTE IMMEDIATE 'INSERT INTO IEC_O_TRANSITION_SUBSETS ' ||

2120: -- batch. First we pull entries that are not checked out into
2121: -- the transition table. Ones that are checked out will be
2122: -- transitioned when they are checked back in.
2123: ----------------------------------------------------------------
2124: EXECUTE IMMEDIATE 'INSERT INTO IEC_O_TRANSITION_SUBSETS ' ||
2125: '( LIST_ID ' ||
2126: ', LIST_ENTRY_ID ' ||
2127: ', ORIG_SUBSET_ID ' ||
2128: ', NEW_SUBSET_ID ' ||

Line 2308: EXECUTE IMMEDIATE 'UPDATE IEC_O_TRANSITION_SUBSETS A SET A.NEW_ITM_CC_TZ_ID = ' ||

2304: ----------------------------------------------------------------
2305: -- Updating the transition entries table with the
2306: -- new current callable zone cross reference id.
2307: ----------------------------------------------------------------
2308: EXECUTE IMMEDIATE 'UPDATE IEC_O_TRANSITION_SUBSETS A SET A.NEW_ITM_CC_TZ_ID = ' ||
2309: ' (SELECT D.ITM_CC_TZ_ID ' ||
2310: ' FROM IEC_G_RETURN_ENTRIES B, IEC_G_MKTG_ITEM_CC_TZS C, IEC_G_MKTG_ITEM_CC_TZS D ' ||
2311: ' WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID AND A.LIST_ID = B.LIST_HEADER_ID ' ||
2312: ' AND B.LIST_HEADER_ID = C.LIST_HEADER_ID AND B.ITM_CC_TZ_ID = C.ITM_CC_TZ_ID' ||

Line 2699: ', IEC_O_TRANSITION_SUBSETS h ' ||

2695: ', iec_g_mktg_item_cc_Tzs d ' ||
2696: ', iec_g_mktg_item_cc_Tzs e ' ||
2697: ', iec_g_mktg_item_cc_Tzs f ' ||
2698: ', iec_g_mktg_item_cc_Tzs g ' ||
2699: ', IEC_O_TRANSITION_SUBSETS h ' ||
2700: 'where h.list_id = :listID ' ||
2701: 'and h.list_id = a.list_header_id ' ||
2702: 'and h.list_entry_id = a.list_entry_id ' ||
2703: 'and a.reason_code_S1 = b.itm_cc_tz_id(+) ' ||