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_VALIDATE_PVT dependencies on IEC_G_RETURN_ENTRIES

Line 5646: 'UPDATE IEC_G_RETURN_ENTRIES A

5642: BEGIN
5643:
5644: EXECUTE IMMEDIATE
5645:
5646: 'UPDATE IEC_G_RETURN_ENTRIES A
5647:
5648: SET ( A.SUBSET_ID
5649:
5650: , A.DO_NOT_USE_FLAG

Line 5742: 'DELETE IEC_G_RETURN_ENTRIES A

5738: BEGIN
5739:
5740: EXECUTE IMMEDIATE
5741:
5742: 'DELETE IEC_G_RETURN_ENTRIES A
5743:
5744: WHERE A.LIST_HEADER_ID = :list_id
5745:
5746: AND A.LIST_ENTRY_ID IN

Line 5782: 'INSERT INTO IEC_G_RETURN_ENTRIES

5778: BEGIN
5779:
5780: EXECUTE IMMEDIATE
5781:
5782: 'INSERT INTO IEC_G_RETURN_ENTRIES
5783:
5784: ( RETURNS_ID
5785:
5786: , CAMPAIGN_ID

Line 5846: SELECT IEC_G_RETURN_ENTRIES_S.NEXTVAL

5842: , LAST_UPDATE_DATE
5843:
5844: , LAST_UPDATE_LOGIN )
5845:
5846: SELECT IEC_G_RETURN_ENTRIES_S.NEXTVAL
5847:
5848: , :campaign_id
5849:
5850: , :campaign_schedule_id

Line 5912: AND LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_G_RETURN_ENTRIES WHERE LIST_HEADER_ID = :list_id)'

5908: FROM IEC_VAL_ENTRY_CACHE
5909:
5910: WHERE DO_NOT_USE_FLAG = ''N''
5911:
5912: AND LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_G_RETURN_ENTRIES WHERE LIST_HEADER_ID = :list_id)'
5913:
5914: USING p_campaign_id, p_campaign_schedule_id, p_source_type_view, p_list_id, l_user_id, l_login_id, l_login_id, p_list_id;
5915:
5916:

Line 8316: -- Delete specified records in IEC_G_RETURN_ENTRIES

8312: BEGIN
8313:
8314:
8315:
8316: -- Delete specified records in IEC_G_RETURN_ENTRIES
8317:
8318: -- Retrieving information to clean up other tables
8319:
8320: DELETE IEC_G_RETURN_ENTRIES A

Line 8320: DELETE IEC_G_RETURN_ENTRIES A

8316: -- Delete specified records in IEC_G_RETURN_ENTRIES
8317:
8318: -- Retrieving information to clean up other tables
8319:
8320: DELETE IEC_G_RETURN_ENTRIES A
8321:
8322: WHERE A.LIST_HEADER_ID = p_list_id
8323:
8324: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))

Line 8480: FROM IEC_G_RETURN_ENTRIES A

8476: SELECT A.RETURNS_ID
8477:
8478: BULK COLLECT INTO :returns_id_col
8479:
8480: FROM IEC_G_RETURN_ENTRIES A
8481:
8482: WHERE A.LIST_HEADER_ID = :list_id
8483:
8484: AND NOT EXISTS (SELECT LIST_ENTRY_ID

Line 8700: FROM IEC_G_RETURN_ENTRIES A

8696: SELECT A.RETURNS_ID, A.LIST_ENTRY_ID
8697:
8698: BULK COLLECT INTO :returns_id_col, :list_entry_id_col
8699:
8700: FROM IEC_G_RETURN_ENTRIES A
8701:
8702: WHERE A.LIST_HEADER_ID = :list_id
8703:
8704: AND A.DO_NOT_USE_FLAG = ''Y'';

Line 10865: FROM ' || l_source_type_view || ' A, IEC_G_RETURN_ENTRIES B

10861: A.CONTACT_POINT_ID_S5, A.TIME_ZONE_S5, A.PHONE_COUNTRY_CODE_S5, A.PHONE_AREA_CODE_S5, A.PHONE_NUMBER_S5, A.RAW_PHONE_NUMBER_S5, A.REASON_CODE_S5, A.PHONE_LINE_TYPE_S5, NULL,
10862:
10863: A.CONTACT_POINT_ID_S6, A.TIME_ZONE_S6, A.PHONE_COUNTRY_CODE_S6, A.PHONE_AREA_CODE_S6, A.PHONE_NUMBER_S6, A.RAW_PHONE_NUMBER_S6, A.REASON_CODE_S6, A.PHONE_LINE_TYPE_S6, NULL
10864:
10865: FROM ' || l_source_type_view || ' A, IEC_G_RETURN_ENTRIES B
10866:
10867: WHERE A.LIST_HEADER_ID = B.LIST_HEADER_ID(+)
10868:
10869: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID(+)

Line 11506: FROM IEC_G_RETURN_ENTRIES

11502: SELECT RETURNS_ID, LIST_ENTRY_ID, LIST_HEADER_ID, ITM_CC_TZ_ID, DO_NOT_USE_FLAG
11503:
11504: BULK COLLECT INTO :returns_id_col, :list_entry_id_col, :list_id_col, :callable_zone_id_col, :do_not_use_col
11505:
11506: FROM IEC_G_RETURN_ENTRIES
11507:
11508: WHERE RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)));
11509:
11510: END;'

Line 11536: UPDATE IEC_G_RETURN_ENTRIES A

11532: 'BEGIN
11533:
11534: FORALL i IN :first .. :last
11535:
11536: UPDATE IEC_G_RETURN_ENTRIES A
11537:
11538: SET A.DO_NOT_USE_FLAG = ''Y''
11539:
11540: , A.DO_NOT_USE_REASON = 5

Line 11618: FROM IEC_G_RETURN_ENTRIES A

11614: SELECT A.RETURNS_ID
11615:
11616: BULK COLLECT INTO :returns_id_col
11617:
11618: FROM IEC_G_RETURN_ENTRIES A
11619:
11620: WHERE A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
11621:
11622: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID

Line 11750: FROM IEC_G_RETURN_ENTRIES

11746: , 6, ''_S6''
11747:
11748: , ''_S1'')
11749:
11750: FROM IEC_G_RETURN_ENTRIES
11751:
11752: WHERE RETURNS_ID = :returns_id'
11753:
11754: INTO l_callback_flag_col(i)

Line 11776: 'UPDATE IEC_G_RETURN_ENTRIES

11772: LOOP
11773:
11774: EXECUTE IMMEDIATE
11775:
11776: 'UPDATE IEC_G_RETURN_ENTRIES
11777:
11778: SET CALLBACK_FLAG = :callback_flag
11779:
11780: , NEXT_CALL_TIME = :next_call_time

Line 11980: FROM ' || l_source_type_view || ' A, IEC_G_RETURN_ENTRIES B

11976: A.CONTACT_POINT_ID_S5, A.TIME_ZONE_S5, A.PHONE_COUNTRY_CODE_S5, A.PHONE_AREA_CODE_S5, A.PHONE_NUMBER_S5, A.RAW_PHONE_NUMBER_S5, A.REASON_CODE_S5, A.PHONE_LINE_TYPE_S5, NULL,
11977:
11978: A.CONTACT_POINT_ID_S6, A.TIME_ZONE_S6, A.PHONE_COUNTRY_CODE_S6, A.PHONE_AREA_CODE_S6, A.PHONE_NUMBER_S6, A.RAW_PHONE_NUMBER_S6, A.REASON_CODE_S6, A.PHONE_LINE_TYPE_S6, NULL
11979:
11980: FROM ' || l_source_type_view || ' A, IEC_G_RETURN_ENTRIES B
11981:
11982: WHERE A.LIST_HEADER_ID = B.LIST_HEADER_ID(+)
11983:
11984: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID(+)

Line 12685: FROM IEC_G_RETURN_ENTRIES

12681: SELECT RETURNS_ID
12682:
12683: BULK COLLECT INTO l_from_returns_id_col
12684:
12685: FROM IEC_G_RETURN_ENTRIES
12686:
12687: WHERE LIST_HEADER_ID = p_from_list_id
12688:
12689: AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID

Line 12795: FROM IEC_G_RETURN_ENTRIES A, AMS_LIST_ENTRIES B

12791: SELECT A.RETURNS_ID, A.LIST_HEADER_ID, A.LIST_ENTRY_ID, A.CAMPAIGN_SCHEDULE_ID, B.PARTY_ID
12792:
12793: BULK COLLECT INTO l_from_returns_id_col, l_from_list_id_col, l_from_list_entry_id_col, l_from_schedule_id_col, l_party_id_col
12794:
12795: FROM IEC_G_RETURN_ENTRIES A, AMS_LIST_ENTRIES B
12796:
12797: WHERE A.LIST_HEADER_ID = B.LIST_HEADER_ID
12798:
12799: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID

Line 13093: FROM IEC_G_RETURN_ENTRIES B

13089: CURSOR c1(src_list_id NUMBER, dest_list_id NUMBER) IS
13090:
13091: SELECT B.RETURNS_ID
13092:
13093: FROM IEC_G_RETURN_ENTRIES B
13094:
13095: WHERE B.LIST_HEADER_ID = src_list_id
13096:
13097: AND B.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID

Line 13505: FROM IEC_G_RETURN_ENTRIES B

13501: CURSOR c1(from_list_id NUMBER) IS
13502:
13503: SELECT B.RETURNS_ID, B.LIST_ENTRY_ID, B.LIST_HEADER_ID
13504:
13505: FROM IEC_G_RETURN_ENTRIES B
13506:
13507: WHERE B.LIST_HEADER_ID = from_list_id
13508:
13509: AND B.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID

Line 15156: 'UPDATE IEC_G_RETURN_ENTRIES

15152:
15153:
15154: EXECUTE IMMEDIATE
15155:
15156: 'UPDATE IEC_G_RETURN_ENTRIES
15157:
15158: SET CALLBACK_FLAG = ''Y''
15159:
15160: , NEXT_CALL_TIME = :callback_time

Line 16426: -- Update AMS_LIST_ENTRIES and IEC_G_RETURN_ENTRIES

16422: Update_CallableZones(p_list_id);
16423:
16424:
16425:
16426: -- Update AMS_LIST_ENTRIES and IEC_G_RETURN_ENTRIES
16427:
16428: EXECUTE IMMEDIATE
16429:
16430: 'BEGIN

Line 16474: UPDATE IEC_G_RETURN_ENTRIES A

16470: EXECUTE IMMEDIATE
16471:
16472: 'BEGIN
16473:
16474: UPDATE IEC_G_RETURN_ENTRIES A
16475:
16476: SET ( SUBSET_ID
16477:
16478: , ITM_CC_TZ_ID