eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEC_SUBSET_PVT dependencies on IEC_G_RETURN_ENTRIES

Line 1225: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES A ' ||

1221: -- calendar and recycling.
1222: ----------------------------------------------------------------
1223: TRACELOG('UPDATING RETURN_ENTRIES ');
1224:
1225: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES A ' ||
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 ' ||

Line 1577: from iec_g_return_entries a

1573: , a.contact_point_index CONTACT_POINT_INDEX
1574: , a.returns_id RETURNS_ID
1575: , a.do_not_use_flag DO_NOT_USE_FLAG
1576: , DECODE(NVL(SUM(B.CALL_ATTEMPT), 0), 0, 0, 1) CALLED_ONCE
1577: from iec_g_return_entries a
1578: , IEC_O_RCY_CALL_HISTORIES B
1579: where a.LIST_HEADER_ID = P_TARGET_GROUP_ID
1580: and a.pulled_subset_id IS NOT NULL
1581: and a.returns_id = b.returns_id(+)

Line 1697: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES SET SUBSET_ID = :subsetId ' ||

1693:
1694: ----------------------------------------------------------------
1695: -- FIRST RESET THE SUBSET AND CURRENT CALL ZONE ON THE LIST.
1696: ----------------------------------------------------------------
1697: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES SET SUBSET_ID = :subsetId ' ||
1698: ', PULLED_SUBSET_ID = NULL, ITM_CC_TZ_ID = :xrefId ' ||
1699: ' WHERE RETURNS_ID = :returnsId'
1700: USING entry_rec.TRANSITION_SUBSET_ID
1701: , l_curr_itm_xref_id

Line 2018: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES A ' ||

2014: IF l_locked_flag = 'Y' THEN
2015: TRACELOG('LOCKED SCHEDULE ' || P_SCHED_ID);
2016:
2017: BEGIN
2018: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES A ' ||
2019: 'SET A.PULLED_SUBSET_ID = :newSubsetId ' ||
2020: 'WHERE A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(:collection AS SYSTEM.NUMBER_TBL_TYPE))) ' ||
2021: 'AND A.RECORD_OUT_FLAG = ''N'' AND A.PULLED_SUBSET_ID IS NULL'
2022: USING P_INTO_SUBSET

Line 2071: OPEN l_checked_entry_cursor FOR 'SELECT RETURNS_ID FROM IEC_G_RETURN_ENTRIES ' ||

2067: -- checked out or we weren't able to get a lock so we have
2068: -- to loop thru the remaining entries and lock them one by one.
2069: ----------------------------------------------------------------
2070:
2071: OPEN l_checked_entry_cursor FOR 'SELECT RETURNS_ID FROM IEC_G_RETURN_ENTRIES ' ||
2072: 'WHERE PULLED_SUBSET_ID IS NULL ' ||
2073: 'AND RETURNS_ID IN (SELECT * FROM TABLE(CAST(:collection AS SYSTEM.NUMBER_TBL_TYPE)))'
2074: USING l_return_tbl;
2075:

Line 2086: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES A ' ||

2082: FETCH l_checked_entry_cursor
2083: INTO l_curr_returns_id;
2084: EXIT WHEN l_checked_entry_cursor%NOTFOUND;
2085:
2086: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES A ' ||
2087: 'SET PULLED_SUBSET_ID = :newSubsetId ' ||
2088: 'WHERE RETURNS_ID = :returnsId ' ||
2089: 'AND PULLED_SUBSET_ID IS NULL'
2090: USING P_INTO_SUBSET

Line 2139: ' FROM IEC_G_RETURN_ENTRIES A, IEC_O_RCY_CALL_HISTORIES B ' ||

2135: ') ' ||
2136: 'SELECT A.LIST_HEADER_ID, A.LIST_ENTRY_ID, A.SUBSET_ID, A.PULLED_SUBSET_ID ' ||
2137: ', A.ITM_CC_TZ_ID, NULL, A.DO_NOT_USE_FLAG, ''N'', A.RETURNS_ID, ' ||
2138: ' DECODE(NVL(SUM(B.CALL_ATTEMPT), 0), 0, 0, 1) ' ||
2139: ' FROM IEC_G_RETURN_ENTRIES A, IEC_O_RCY_CALL_HISTORIES B ' ||
2140: ' WHERE A.SUBSET_ID = :oldSubsetId ' ||
2141: ' AND A.RETURNS_ID = B.RETURNS_ID(+) ' ||
2142: ' AND A.PULLED_SUBSET_ID = :newSubsetId' ||
2143: ' AND A.RECORD_OUT_FLAG = ''N'' GROUP BY ' ||

Line 2310: ' FROM IEC_G_RETURN_ENTRIES B, IEC_G_MKTG_ITEM_CC_TZS C, IEC_G_MKTG_ITEM_CC_TZS D ' ||

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' ||
2313: ' AND D.TERRITORY_CODE = C.TERRITORY_CODE AND D.SUBSET_ID = A.NEW_SUBSET_ID AND ' ||
2314: ' D.TIMEZONE_ID = C.TIMEZONE_ID AND D.LIST_HEADER_ID = C.LIST_HEADER_ID ' ||

Line 2346: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM IEC_G_RETURN_ENTRIES WHERE SUBSET_ID = :1 and PULLED_SUBSET_ID IS NOT NULL'

2342: -- Return the number of entries that have yet to be transitioned.
2343: -- For perforamnce reasons we could choose to simply look for
2344: -- the first instead of actually counting.
2345: ----------------------------------------------------------------
2346: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM IEC_G_RETURN_ENTRIES WHERE SUBSET_ID = :1 and PULLED_SUBSET_ID IS NOT NULL'
2347: INTO X_NUM_PENDING
2348: USING P_FROM_SUBSET;
2349:
2350: ----------------------------------------------------------------

Line 2748: ' FROM IEC_G_RETURN_ENTRIES A ' ||

2744: ----------------------------------------------------------------
2745: IF L_USE_CALLABLE_FLAG = TRUE
2746: THEN
2747: l_first_query_entry_sql := 'SELECT A.RETURNS_ID ' ||
2748: ' FROM IEC_G_RETURN_ENTRIES A ' ||
2749: ' WHERE A.SUBSET_ID = :subsetId ' ||
2750: ' AND A.PULLED_SUBSET_ID IS NULL ' ||
2751: ' AND A.ITM_CC_TZ_ID IN ' ||
2752: ' (SELECT ITM_CC_TZ_ID FROM ' ||

Line 2761: ' FROM IEC_G_RETURN_ENTRIES A ' ||

2757: ' AND A.LIST_ENTRY_ID IN (SELECT C.LIST_ENTRY_ID ' ||
2758: ' FROM ' || l_subset_view_name || ' C)';
2759: ELSE
2760: l_first_query_entry_sql := 'SELECT A.RETURNS_ID ' ||
2761: ' FROM IEC_G_RETURN_ENTRIES A ' ||
2762: ' WHERE A.SUBSET_ID = :subsetId ' ||
2763: ' AND A.PULLED_SUBSET_ID IS NULL ' ||
2764: ' AND A.DO_NOT_USE_FLAG = ''N'' ' ||
2765: ' AND A.LIST_ENTRY_ID IN (SELECT C.LIST_ENTRY_ID ' ||

Line 2771: ' FROM IEC_G_RETURN_ENTRIES A ' ||

2767:
2768: END IF;
2769:
2770: l_second_query_entry_sql := 'SELECT A.RETURNS_ID ' ||
2771: ' FROM IEC_G_RETURN_ENTRIES A ' ||
2772: ' WHERE A.SUBSET_ID = :subsetId ' ||
2773: ' AND A.PULLED_SUBSET_ID IS NULL ' ||
2774: ' AND A.LIST_ENTRY_ID IN (SELECT C.LIST_ENTRY_ID ' ||
2775: ' FROM ' || l_subset_view_name || ' C)';

Line 2784: ' FROM IEC_G_RETURN_ENTRIES A ' ||

2780: -- Think about the timing with the L_USE_CALLABLE_FLAG.
2781: ----------------------------------------------------------------
2782: IF L_USE_CALLABLE_FLAG = TRUE THEN
2783: l_first_query_entry_sql := 'SELECT A.RETURNS_ID ' ||
2784: ' FROM IEC_G_RETURN_ENTRIES A ' ||
2785: ' WHERE A.SUBSET_ID = :subsetId ' ||
2786: ' AND A.PULLED_SUBSET_ID IS NULL ' ||
2787: ' AND A.ITM_CC_TZ_ID IN ' ||
2788: ' (SELECT ITM_CC_TZ_ID FROM ' ||

Line 2795: ' FROM IEC_G_RETURN_ENTRIES A ' ||

2791: ' AND B.CALLABLE_FLAG = ''Y'' ' ||
2792: ' AND B.LAST_CALLABLE_TIME > SYSDATE)';
2793: ELSE
2794: l_first_query_entry_sql := 'SELECT A.RETURNS_ID ' ||
2795: ' FROM IEC_G_RETURN_ENTRIES A ' ||
2796: ' WHERE A.SUBSET_ID = :subsetId ' ||
2797: ' AND A.PULLED_SUBSET_ID IS NULL ' ||
2798: ' AND A.DO_NOT_USE_FLAG = ''N'' ';
2799: END IF;

Line 2802: ' FROM IEC_G_RETURN_ENTRIES A ' ||

2798: ' AND A.DO_NOT_USE_FLAG = ''N'' ';
2799: END IF;
2800:
2801: l_second_query_entry_sql := 'SELECT A.RETURNS_ID ' ||
2802: ' FROM IEC_G_RETURN_ENTRIES A ' ||
2803: ' WHERE A.SUBSET_ID = :subsetId ' ||
2804: ' AND A.PULLED_SUBSET_ID IS NULL ';
2805:
2806: END IF;