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 AMS_LIST_ENTRIES

Line 4214: Log_MissingSourceTypeColumns(p_list_id, p_source_type_view, Get_SourceType(p_list_id), 'UPDATE_AMS_LIST_ENTRIES', 'UPDATE_LIST_ENTRIES');

4210: WHEN OTHERS THEN
4211:
4212: IF SQLCODE = -904 THEN
4213:
4214: Log_MissingSourceTypeColumns(p_list_id, p_source_type_view, Get_SourceType(p_list_id), 'UPDATE_AMS_LIST_ENTRIES', 'UPDATE_LIST_ENTRIES');
4215:
4216: RAISE fnd_api.g_exc_unexpected_error;
4217:
4218: ELSE

Line 7858: -- Prevents overwriting data in AMS_LIST_ENTRIES for invalid contact points

7854: -- Copy In Out Parameters into local variables
7855:
7856: -- Contact Point Paramater will not be updated unless contact point is valid
7857:
7858: -- Prevents overwriting data in AMS_LIST_ENTRIES for invalid contact points
7859:
7860: l_contact_point := x_contact_point;
7861:
7862:

Line 8470: -- AMS_LIST_ENTRIES

8466:
8467:
8468: -- Look for records that have been deleted from
8469:
8470: -- AMS_LIST_ENTRIES
8471:
8472: EXECUTE IMMEDIATE
8473:
8474: 'BEGIN

Line 8486: FROM AMS_LIST_ENTRIES

8482: WHERE A.LIST_HEADER_ID = :list_id
8483:
8484: AND NOT EXISTS (SELECT LIST_ENTRY_ID
8485:
8486: FROM AMS_LIST_ENTRIES
8487:
8488: WHERE A.LIST_HEADER_ID = LIST_HEADER_ID
8489:
8490: AND A.LIST_ENTRY_ID = LIST_ENTRY_ID

Line 8550: FROM AMS_LIST_ENTRIES

8546: AND LIST_ENTRY_ID NOT IN
8547:
8548: (SELECT LIST_ENTRY_ID
8549:
8550: FROM AMS_LIST_ENTRIES
8551:
8552: WHERE LIST_HEADER_ID = :list_id
8553:
8554: AND ENABLED_FLAG = ''Y'')'

Line 10568: FROM AMS_LIST_ENTRIES

10564: SELECT LIST_ENTRY_SOURCE_SYSTEM_TYPE, COUNT(*)
10565:
10566: BULK COLLECT INTO l_source_type_col, l_source_type_count_col
10567:
10568: FROM AMS_LIST_ENTRIES
10569:
10570: WHERE LIST_HEADER_ID = p_list_id
10571:
10572: GROUP BY LIST_ENTRY_SOURCE_SYSTEM_TYPE;

Line 11250: FROM AMS_LIST_ENTRIES

11246: , l_listentry_rec.COL292, l_listentry_rec.COL293, l_listentry_rec.COL294, l_listentry_rec.COL295, l_listentry_rec.COL296, l_listentry_rec.COL297, l_listentry_rec.COL298
11247:
11248: , l_listentry_rec.COL299, l_listentry_rec.COL300
11249:
11250: FROM AMS_LIST_ENTRIES
11251:
11252: WHERE LIST_HEADER_ID = p_from_list_id_col(i) AND LIST_ENTRY_ID = p_from_list_entry_id_col(i);
11253:
11254: l_listentry_rec.list_header_id := p_to_list_id;

Line 11276: 'SELECT AMS_LIST_ENTRIES_S.NEXTVAL FROM DUAL'

11272: LOOP
11273:
11274: EXECUTE IMMEDIATE
11275:
11276: 'SELECT AMS_LIST_ENTRIES_S.NEXTVAL FROM DUAL'
11277:
11278: INTO x_to_list_entry_id_col(i);
11279:
11280: END LOOP;

Line 11290: INSERT INTO AMS_LIST_ENTRIES

11286: 'BEGIN
11287:
11288: FORALL i IN :first .. :last
11289:
11290: INSERT INTO AMS_LIST_ENTRIES
11291:
11292: ( LIST_ENTRY_ID, LIST_HEADER_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER
11293:
11294: , LIST_SELECT_ACTION_ID, ARC_LIST_SELECT_ACTION_FROM, LIST_SELECT_ACTION_FROM_NAME, SOURCE_CODE, ARC_LIST_USED_BY_SOURCE, SOURCE_CODE_FOR_ID

Line 11400: FROM AMS_LIST_ENTRIES

11396: , COL275, COL276, COL277, COL278, COL279, COL280, COL281, COL282, COL283, COL284, COL285, COL286, COL287, COL288, COL289, COL290
11397:
11398: , COL291, COL292, COL293, COL294, COL295, COL296, COL297, COL298, COL299, COL300
11399:
11400: FROM AMS_LIST_ENTRIES
11401:
11402: WHERE LIST_HEADER_ID = :list_id_col(i) AND LIST_ENTRY_ID = :list_entry_id_col(i));
11403:
11404: END;'

Line 11624: FROM AMS_LIST_ENTRIES

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
11623:
11624: FROM AMS_LIST_ENTRIES
11625:
11626: WHERE A.LIST_HEADER_ID = LIST_HEADER_ID
11627:
11628: AND A.LIST_ENTRY_ID = LIST_ENTRY_ID

Line 11630: AND PARTY_ID NOT IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = :to_list_id));

11626: WHERE A.LIST_HEADER_ID = LIST_HEADER_ID
11627:
11628: AND A.LIST_ENTRY_ID = LIST_ENTRY_ID
11629:
11630: AND PARTY_ID NOT IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = :to_list_id));
11631:
11632: END;'
11633:
11634: USING OUT l_temp_returns_id_col

Line 12125: FROM AMS_LIST_ENTRIES A, AMS_LIST_ENTRIES B

12121: , A.COL275, A.COL276, A.COL277, A.COL278, A.COL279, A.COL280, A.COL281, A.COL282, A.COL283, A.COL284, A.COL285, A.COL286, A.COL287, A.COL288, A.COL289, A.COL290
12122:
12123: , A.COL291, A.COL292, A.COL293, A.COL294, A.COL295, A.COL296, A.COL297, A.COL298, A.COL299, A.COL300, A.NEWLY_UPDATED_FLAG
12124:
12125: FROM AMS_LIST_ENTRIES A, AMS_LIST_ENTRIES B
12126:
12127: WHERE A.LIST_HEADER_ID = p_from_list_id AND B.LIST_HEADER_ID = p_to_list_id AND A.PARTY_ID = B.PARTY_ID AND A.ENABLED_FLAG = 'Y' AND B.ENABLED_FLAG = 'Y';
12128:
12129: l_api_version CONSTANT NUMBER := 1.0;

Line 12138: -- Update duplicate records in ams list entries

12134: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
12135: BEGIN
12136: l_init_msg_list :=FND_API.G_TRUE;
12137:
12138: -- Update duplicate records in ams list entries
12139:
12140: -- From Source List to Destination List
12141: FOR v_listentryrec IN c_listentryrec LOOP
12142: l_to_list_entry_id_col(l_num) := v_listentryrec.list_entry_id;

Line 12533: UPDATE AMS_LIST_ENTRIES

12529: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12530: Log_msg('AMS_LISTENTRY_PUB.update_listentry', l_msg_data);
12531: END IF;
12532:
12533: UPDATE AMS_LIST_ENTRIES
12534: SET NEWLY_UPDATED_FLAG = v_listentryrec.NEWLY_UPDATED_FLAG
12535: WHERE LIST_ENTRY_ID = v_listentryrec.list_entry_id
12536: AND LIST_HEADER_ID= v_listentryrec.list_header_id;
12537:

Line 12544: UPDATE AMS_LIST_ENTRIES A

12540:
12541: END LOOP;
12542:
12543: /*
12544: UPDATE AMS_LIST_ENTRIES A
12545:
12546: SET ( LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER
12547:
12548: , LIST_SELECT_ACTION_ID, ARC_LIST_SELECT_ACTION_FROM, LIST_SELECT_ACTION_FROM_NAME, SOURCE_CODE, ARC_LIST_USED_BY_SOURCE, SOURCE_CODE_FOR_ID

Line 12654: FROM AMS_LIST_ENTRIES

12650: , COL275, COL276, COL277, COL278, COL279, COL280, COL281, COL282, COL283, COL284, COL285, COL286, COL287, COL288, COL289, COL290
12651:
12652: , COL291, COL292, COL293, COL294, COL295, COL296, COL297, COL298, COL299, COL300, NEWLY_UPDATED_FLAG
12653:
12654: FROM AMS_LIST_ENTRIES
12655:
12656: WHERE LIST_HEADER_ID = p_from_list_id AND PARTY_ID = A.PARTY_ID AND ENABLED_FLAG = 'Y')
12657:
12658: WHERE LIST_HEADER_ID = p_to_list_id

Line 12664: FROM AMS_LIST_ENTRIES

12660: AND ENABLED_FLAG = 'Y'
12661:
12662: AND PARTY_ID IN (SELECT PARTY_ID
12663:
12664: FROM AMS_LIST_ENTRIES
12665:
12666: WHERE LIST_HEADER_ID = p_from_list_id
12667:
12668: AND ENABLED_FLAG = 'Y')

Line 12691: FROM AMS_LIST_ENTRIES

12687: WHERE LIST_HEADER_ID = p_from_list_id
12688:
12689: AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
12690:
12691: FROM AMS_LIST_ENTRIES
12692:
12693: WHERE LIST_HEADER_ID = p_from_list_id
12694:
12695: AND ENABLED_FLAG = 'Y'

Line 12699: FROM AMS_LIST_ENTRIES

12695: AND ENABLED_FLAG = 'Y'
12696:
12697: AND PARTY_ID IN (SELECT PARTY_ID
12698:
12699: FROM AMS_LIST_ENTRIES
12700:
12701: WHERE LIST_HEADER_ID = p_to_list_id
12702:
12703: AND ENABLED_FLAG = 'Y'));

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 12803: AND B.PARTY_ID IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = p_to_list_id);

12799: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
12800:
12801: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_from_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
12802:
12803: AND B.PARTY_ID IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = p_to_list_id);
12804:
12805:
12806:
12807: IF l_from_returns_id_col IS NOT NULL AND l_from_returns_id_col.COUNT > 0 THEN

Line 13099: FROM AMS_LIST_ENTRIES

13095: WHERE B.LIST_HEADER_ID = src_list_id
13096:
13097: AND B.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
13098:
13099: FROM AMS_LIST_ENTRIES
13100:
13101: WHERE B.LIST_HEADER_ID = LIST_HEADER_ID
13102:
13103: AND B.LIST_ENTRY_ID = LIST_ENTRY_ID

Line 13107: FROM AMS_LIST_ENTRIES

13103: AND B.LIST_ENTRY_ID = LIST_ENTRY_ID
13104:
13105: AND PARTY_ID NOT IN (SELECT PARTY_ID
13106:
13107: FROM AMS_LIST_ENTRIES
13108:
13109: WHERE LIST_HEADER_ID = dest_list_id));
13110:
13111:

Line 13511: FROM AMS_LIST_ENTRIES

13507: WHERE B.LIST_HEADER_ID = from_list_id
13508:
13509: AND B.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
13510:
13511: FROM AMS_LIST_ENTRIES
13512:
13513: WHERE B.LIST_HEADER_ID = LIST_HEADER_ID
13514:
13515: AND B.LIST_ENTRY_ID = LIST_ENTRY_ID

Line 13519: FROM AMS_LIST_ENTRIES

13515: AND B.LIST_ENTRY_ID = LIST_ENTRY_ID
13516:
13517: AND PARTY_ID NOT IN (SELECT PARTY_ID
13518:
13519: FROM AMS_LIST_ENTRIES
13520:
13521: WHERE LIST_HEADER_ID = p_to_list_id));
13522:
13523:

Line 14244: 'SELECT AMS_LIST_ENTRIES_S.NEXTVAL FROM DUAL'

14240:
14241: /*
14242: EXECUTE IMMEDIATE
14243:
14244: 'SELECT AMS_LIST_ENTRIES_S.NEXTVAL FROM DUAL'
14245:
14246: INTO x_list_entry_id;
14247:
14248:

Line 14252: 'INSERT INTO AMS_LIST_ENTRIES

14248:
14249:
14250: EXECUTE IMMEDIATE
14251:
14252: 'INSERT INTO AMS_LIST_ENTRIES
14253:
14254: ( LIST_ENTRY_ID
14255:
14256: , LIST_HEADER_ID

Line 14630: -- into AMS_LIST_ENTRIES with one contact point, and to

14626:
14627:
14628: -- Verify the parameters necessary to insert a record
14629:
14630: -- into AMS_LIST_ENTRIES with one contact point, and to
14631:
14632: -- validate the record
14633:
14634: PROCEDURE Verify_AllRequiredColumns

Line 14826: -- into AMS_LIST_ENTRIES with one contact point

14822:
14823:
14824: -- Verify only the parameters necessary to insert a record
14825:
14826: -- into AMS_LIST_ENTRIES with one contact point
14827:
14828: PROCEDURE Verify_MinRequiredColumns
14829:
14830: ( p_col_names IN SYSTEM.varchar_tbl_type

Line 14936: -- Check for minimum columns required for insert into AMS_LIST_ENTRIES

14932: x_failure_code := NULL;
14933:
14934:
14935:
14936: -- Check for minimum columns required for insert into AMS_LIST_ENTRIES
14937:
14938: Verify_MinRequiredColumns( p_column_name
14939:
14940: , p_column_value

Line 14964: FROM AMS_LIST_ENTRIES

14960: EXECUTE IMMEDIATE
14961:
14962: 'SELECT COUNT(*)
14963:
14964: FROM AMS_LIST_ENTRIES
14965:
14966: WHERE LIST_HEADER_ID = :list_id
14967:
14968: AND PARTY_ID = :party_id'

Line 15002: -- Create record in AMS_LIST_ENTRIES

14998: END IF;
14999:
15000:
15001:
15002: -- Create record in AMS_LIST_ENTRIES
15003:
15004: Insert_AmsListEntries( p_list_id
15005:
15006: , Get_SourceType(p_list_id)

Line 15020: -- Update record details in AMS_LIST_ENTRIES using Source Type Views

15016: );
15017:
15018:
15019:
15020: -- Update record details in AMS_LIST_ENTRIES using Source Type Views
15021:
15022: Update_AmsListEntries( p_list_id
15023:
15024: , x_list_entry_id

Line 15272: -- enough parameters to insert the record into AMS_LIST_ENTRIES since

15268: -- since validation rules are not used in to validate this record.
15269:
15270: -- In batch mode, we do not require all parameters - we only require
15271:
15272: -- enough parameters to insert the record into AMS_LIST_ENTRIES since
15273:
15274: -- it doesn't matter if the record fails validation.
15275:
15276: IF p_interactive_mode THEN

Line 15300: -- Create the new entry in AMS_LIST_ENTRIES

15296: END IF;
15297:
15298:
15299:
15300: -- Create the new entry in AMS_LIST_ENTRIES
15301:
15302: Create_NewEntry( p_list_id
15303:
15304: , p_column_name

Line 15318: -- Must rollback if unable to insert entry into AMS_LIST_ENTRIES

15314: );
15315:
15316:
15317:
15318: -- Must rollback if unable to insert entry into AMS_LIST_ENTRIES
15319:
15320: -- Possible reasons include missing parameters, or duplicate party id
15321:
15322: IF x_failure_code IS NOT NULL THEN

Line 15740: -- Update AMS_LIST_ENTRIES contact point

15736: END IF;
15737:
15738:
15739:
15740: -- Update AMS_LIST_ENTRIES contact point
15741:
15742: BEGIN
15743:
15744: l_source_type_view := Get_SourceTypeView(p_list_id);

Line 15776: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'Update_ContactPoint', 'UPDATE_AMS_LIST_ENTRIES');

15772: WHEN OTHERS THEN
15773:
15774: IF SQLCODE = -904 THEN
15775:
15776: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'Update_ContactPoint', 'UPDATE_AMS_LIST_ENTRIES');
15777:
15778: RAISE fnd_api.g_exc_unexpected_error;
15779:
15780: ELSE

Line 15784: , 'UPDATE_AMS_LIST_ENTRIES'

15780: ELSE
15781:
15782: Log( 'Update_ContactPoint'
15783:
15784: , 'UPDATE_AMS_LIST_ENTRIES'
15785:
15786: , SQLERRM
15787:
15788: );

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