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 4192: Log_MissingSourceTypeColumns(p_list_id, p_source_type_view, Get_SourceType(p_list_id), 'UPDATE_AMS_LIST_ENTRIES', 'UPDATE_LIST_ENTRIES');

4188: WHEN OTHERS THEN
4189:
4190: IF SQLCODE = -904 THEN
4191:
4192: Log_MissingSourceTypeColumns(p_list_id, p_source_type_view, Get_SourceType(p_list_id), 'UPDATE_AMS_LIST_ENTRIES', 'UPDATE_LIST_ENTRIES');
4193:
4194: RAISE fnd_api.g_exc_unexpected_error;
4195:
4196: ELSE

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

7832: -- Copy In Out Parameters into local variables
7833:
7834: -- Contact Point Paramater will not be updated unless contact point is valid
7835:
7836: -- Prevents overwriting data in AMS_LIST_ENTRIES for invalid contact points
7837:
7838: l_contact_point := x_contact_point;
7839:
7840:

Line 8448: -- AMS_LIST_ENTRIES

8444:
8445:
8446: -- Look for records that have been deleted from
8447:
8448: -- AMS_LIST_ENTRIES
8449:
8450: EXECUTE IMMEDIATE
8451:
8452: 'BEGIN

Line 8464: FROM AMS_LIST_ENTRIES

8460: WHERE A.LIST_HEADER_ID = :list_id
8461:
8462: AND NOT EXISTS (SELECT LIST_ENTRY_ID
8463:
8464: FROM AMS_LIST_ENTRIES
8465:
8466: WHERE A.LIST_HEADER_ID = LIST_HEADER_ID
8467:
8468: AND A.LIST_ENTRY_ID = LIST_ENTRY_ID

Line 8528: FROM AMS_LIST_ENTRIES

8524: AND LIST_ENTRY_ID NOT IN
8525:
8526: (SELECT LIST_ENTRY_ID
8527:
8528: FROM AMS_LIST_ENTRIES
8529:
8530: WHERE LIST_HEADER_ID = :list_id
8531:
8532: AND ENABLED_FLAG = ''Y'')'

Line 10546: FROM AMS_LIST_ENTRIES

10542: SELECT LIST_ENTRY_SOURCE_SYSTEM_TYPE, COUNT(*)
10543:
10544: BULK COLLECT INTO l_source_type_col, l_source_type_count_col
10545:
10546: FROM AMS_LIST_ENTRIES
10547:
10548: WHERE LIST_HEADER_ID = p_list_id
10549:
10550: GROUP BY LIST_ENTRY_SOURCE_SYSTEM_TYPE;

Line 11228: FROM AMS_LIST_ENTRIES

11224: , 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
11225:
11226: , l_listentry_rec.COL299, l_listentry_rec.COL300
11227:
11228: FROM AMS_LIST_ENTRIES
11229:
11230: WHERE LIST_HEADER_ID = p_from_list_id_col(i) AND LIST_ENTRY_ID = p_from_list_entry_id_col(i);
11231:
11232: l_listentry_rec.list_header_id := p_to_list_id;

Line 11254: 'SELECT AMS_LIST_ENTRIES_S.NEXTVAL FROM DUAL'

11250: LOOP
11251:
11252: EXECUTE IMMEDIATE
11253:
11254: 'SELECT AMS_LIST_ENTRIES_S.NEXTVAL FROM DUAL'
11255:
11256: INTO x_to_list_entry_id_col(i);
11257:
11258: END LOOP;

Line 11268: INSERT INTO AMS_LIST_ENTRIES

11264: 'BEGIN
11265:
11266: FORALL i IN :first .. :last
11267:
11268: INSERT INTO AMS_LIST_ENTRIES
11269:
11270: ( LIST_ENTRY_ID, LIST_HEADER_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER
11271:
11272: , 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 11378: FROM AMS_LIST_ENTRIES

11374: , COL275, COL276, COL277, COL278, COL279, COL280, COL281, COL282, COL283, COL284, COL285, COL286, COL287, COL288, COL289, COL290
11375:
11376: , COL291, COL292, COL293, COL294, COL295, COL296, COL297, COL298, COL299, COL300
11377:
11378: FROM AMS_LIST_ENTRIES
11379:
11380: WHERE LIST_HEADER_ID = :list_id_col(i) AND LIST_ENTRY_ID = :list_entry_id_col(i));
11381:
11382: END;'

Line 11602: FROM AMS_LIST_ENTRIES

11598: WHERE A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
11599:
11600: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
11601:
11602: FROM AMS_LIST_ENTRIES
11603:
11604: WHERE A.LIST_HEADER_ID = LIST_HEADER_ID
11605:
11606: AND A.LIST_ENTRY_ID = LIST_ENTRY_ID

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

11604: WHERE A.LIST_HEADER_ID = LIST_HEADER_ID
11605:
11606: AND A.LIST_ENTRY_ID = LIST_ENTRY_ID
11607:
11608: AND PARTY_ID NOT IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = :to_list_id));
11609:
11610: END;'
11611:
11612: USING OUT l_temp_returns_id_col

Line 12103: FROM AMS_LIST_ENTRIES A, AMS_LIST_ENTRIES B

12099: , 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
12100:
12101: , A.COL291, A.COL292, A.COL293, A.COL294, A.COL295, A.COL296, A.COL297, A.COL298, A.COL299, A.COL300, A.NEWLY_UPDATED_FLAG
12102:
12103: FROM AMS_LIST_ENTRIES A, AMS_LIST_ENTRIES B
12104:
12105: 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';
12106:
12107: l_api_version CONSTANT NUMBER := 1.0;

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

12112: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
12113: BEGIN
12114: l_init_msg_list :=FND_API.G_TRUE;
12115:
12116: -- Update duplicate records in ams list entries
12117:
12118: -- From Source List to Destination List
12119: FOR v_listentryrec IN c_listentryrec LOOP
12120: l_to_list_entry_id_col(l_num) := v_listentryrec.list_entry_id;

Line 12511: UPDATE AMS_LIST_ENTRIES

12507: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12508: Log_msg('AMS_LISTENTRY_PUB.update_listentry', l_msg_data);
12509: END IF;
12510:
12511: UPDATE AMS_LIST_ENTRIES
12512: SET NEWLY_UPDATED_FLAG = v_listentryrec.NEWLY_UPDATED_FLAG
12513: WHERE LIST_ENTRY_ID = v_listentryrec.list_entry_id
12514: AND LIST_HEADER_ID= v_listentryrec.list_header_id;
12515:

Line 12522: UPDATE AMS_LIST_ENTRIES A

12518:
12519: END LOOP;
12520:
12521: /*
12522: UPDATE AMS_LIST_ENTRIES A
12523:
12524: SET ( LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER
12525:
12526: , 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 12632: FROM AMS_LIST_ENTRIES

12628: , COL275, COL276, COL277, COL278, COL279, COL280, COL281, COL282, COL283, COL284, COL285, COL286, COL287, COL288, COL289, COL290
12629:
12630: , COL291, COL292, COL293, COL294, COL295, COL296, COL297, COL298, COL299, COL300, NEWLY_UPDATED_FLAG
12631:
12632: FROM AMS_LIST_ENTRIES
12633:
12634: WHERE LIST_HEADER_ID = p_from_list_id AND PARTY_ID = A.PARTY_ID AND ENABLED_FLAG = 'Y')
12635:
12636: WHERE LIST_HEADER_ID = p_to_list_id

Line 12642: FROM AMS_LIST_ENTRIES

12638: AND ENABLED_FLAG = 'Y'
12639:
12640: AND PARTY_ID IN (SELECT PARTY_ID
12641:
12642: FROM AMS_LIST_ENTRIES
12643:
12644: WHERE LIST_HEADER_ID = p_from_list_id
12645:
12646: AND ENABLED_FLAG = 'Y')

Line 12669: FROM AMS_LIST_ENTRIES

12665: WHERE LIST_HEADER_ID = p_from_list_id
12666:
12667: AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
12668:
12669: FROM AMS_LIST_ENTRIES
12670:
12671: WHERE LIST_HEADER_ID = p_from_list_id
12672:
12673: AND ENABLED_FLAG = 'Y'

Line 12677: FROM AMS_LIST_ENTRIES

12673: AND ENABLED_FLAG = 'Y'
12674:
12675: AND PARTY_ID IN (SELECT PARTY_ID
12676:
12677: FROM AMS_LIST_ENTRIES
12678:
12679: WHERE LIST_HEADER_ID = p_to_list_id
12680:
12681: AND ENABLED_FLAG = 'Y'));

Line 12773: FROM IEC_G_RETURN_ENTRIES A, AMS_LIST_ENTRIES B

12769: SELECT A.RETURNS_ID, A.LIST_HEADER_ID, A.LIST_ENTRY_ID, A.CAMPAIGN_SCHEDULE_ID, B.PARTY_ID
12770:
12771: 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
12772:
12773: FROM IEC_G_RETURN_ENTRIES A, AMS_LIST_ENTRIES B
12774:
12775: WHERE A.LIST_HEADER_ID = B.LIST_HEADER_ID
12776:
12777: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID

Line 12781: AND B.PARTY_ID IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = p_to_list_id);

12777: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
12778:
12779: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_from_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
12780:
12781: AND B.PARTY_ID IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = p_to_list_id);
12782:
12783:
12784:
12785: IF l_from_returns_id_col IS NOT NULL AND l_from_returns_id_col.COUNT > 0 THEN

Line 13077: FROM AMS_LIST_ENTRIES

13073: WHERE B.LIST_HEADER_ID = src_list_id
13074:
13075: AND B.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
13076:
13077: FROM AMS_LIST_ENTRIES
13078:
13079: WHERE B.LIST_HEADER_ID = LIST_HEADER_ID
13080:
13081: AND B.LIST_ENTRY_ID = LIST_ENTRY_ID

Line 13085: FROM AMS_LIST_ENTRIES

13081: AND B.LIST_ENTRY_ID = LIST_ENTRY_ID
13082:
13083: AND PARTY_ID NOT IN (SELECT PARTY_ID
13084:
13085: FROM AMS_LIST_ENTRIES
13086:
13087: WHERE LIST_HEADER_ID = dest_list_id));
13088:
13089:

Line 13489: FROM AMS_LIST_ENTRIES

13485: WHERE B.LIST_HEADER_ID = from_list_id
13486:
13487: AND B.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
13488:
13489: FROM AMS_LIST_ENTRIES
13490:
13491: WHERE B.LIST_HEADER_ID = LIST_HEADER_ID
13492:
13493: AND B.LIST_ENTRY_ID = LIST_ENTRY_ID

Line 13497: FROM AMS_LIST_ENTRIES

13493: AND B.LIST_ENTRY_ID = LIST_ENTRY_ID
13494:
13495: AND PARTY_ID NOT IN (SELECT PARTY_ID
13496:
13497: FROM AMS_LIST_ENTRIES
13498:
13499: WHERE LIST_HEADER_ID = p_to_list_id));
13500:
13501:

Line 14222: 'SELECT AMS_LIST_ENTRIES_S.NEXTVAL FROM DUAL'

14218:
14219: /*
14220: EXECUTE IMMEDIATE
14221:
14222: 'SELECT AMS_LIST_ENTRIES_S.NEXTVAL FROM DUAL'
14223:
14224: INTO x_list_entry_id;
14225:
14226:

Line 14230: 'INSERT INTO AMS_LIST_ENTRIES

14226:
14227:
14228: EXECUTE IMMEDIATE
14229:
14230: 'INSERT INTO AMS_LIST_ENTRIES
14231:
14232: ( LIST_ENTRY_ID
14233:
14234: , LIST_HEADER_ID

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

14604:
14605:
14606: -- Verify the parameters necessary to insert a record
14607:
14608: -- into AMS_LIST_ENTRIES with one contact point, and to
14609:
14610: -- validate the record
14611:
14612: PROCEDURE Verify_AllRequiredColumns

Line 14804: -- into AMS_LIST_ENTRIES with one contact point

14800:
14801:
14802: -- Verify only the parameters necessary to insert a record
14803:
14804: -- into AMS_LIST_ENTRIES with one contact point
14805:
14806: PROCEDURE Verify_MinRequiredColumns
14807:
14808: ( p_col_names IN SYSTEM.varchar_tbl_type

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

14910: x_failure_code := NULL;
14911:
14912:
14913:
14914: -- Check for minimum columns required for insert into AMS_LIST_ENTRIES
14915:
14916: Verify_MinRequiredColumns( p_column_name
14917:
14918: , p_column_value

Line 14942: FROM AMS_LIST_ENTRIES

14938: EXECUTE IMMEDIATE
14939:
14940: 'SELECT COUNT(*)
14941:
14942: FROM AMS_LIST_ENTRIES
14943:
14944: WHERE LIST_HEADER_ID = :list_id
14945:
14946: AND PARTY_ID = :party_id'

Line 14980: -- Create record in AMS_LIST_ENTRIES

14976: END IF;
14977:
14978:
14979:
14980: -- Create record in AMS_LIST_ENTRIES
14981:
14982: Insert_AmsListEntries( p_list_id
14983:
14984: , Get_SourceType(p_list_id)

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

14994: );
14995:
14996:
14997:
14998: -- Update record details in AMS_LIST_ENTRIES using Source Type Views
14999:
15000: Update_AmsListEntries( p_list_id
15001:
15002: , x_list_entry_id

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

15246: -- since validation rules are not used in to validate this record.
15247:
15248: -- In batch mode, we do not require all parameters - we only require
15249:
15250: -- enough parameters to insert the record into AMS_LIST_ENTRIES since
15251:
15252: -- it doesn't matter if the record fails validation.
15253:
15254: IF p_interactive_mode THEN

Line 15278: -- Create the new entry in AMS_LIST_ENTRIES

15274: END IF;
15275:
15276:
15277:
15278: -- Create the new entry in AMS_LIST_ENTRIES
15279:
15280: Create_NewEntry( p_list_id
15281:
15282: , p_column_name

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

15292: );
15293:
15294:
15295:
15296: -- Must rollback if unable to insert entry into AMS_LIST_ENTRIES
15297:
15298: -- Possible reasons include missing parameters, or duplicate party id
15299:
15300: IF x_failure_code IS NOT NULL THEN

Line 15718: -- Update AMS_LIST_ENTRIES contact point

15714: END IF;
15715:
15716:
15717:
15718: -- Update AMS_LIST_ENTRIES contact point
15719:
15720: BEGIN
15721:
15722: l_source_type_view := Get_SourceTypeView(p_list_id);

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

15750: WHEN OTHERS THEN
15751:
15752: IF SQLCODE = -904 THEN
15753:
15754: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'Update_ContactPoint', 'UPDATE_AMS_LIST_ENTRIES');
15755:
15756: RAISE fnd_api.g_exc_unexpected_error;
15757:
15758: ELSE

Line 15762: , 'UPDATE_AMS_LIST_ENTRIES'

15758: ELSE
15759:
15760: Log( 'Update_ContactPoint'
15761:
15762: , 'UPDATE_AMS_LIST_ENTRIES'
15763:
15764: , SQLERRM
15765:
15766: );

Line 16404: -- Update AMS_LIST_ENTRIES and IEC_G_RETURN_ENTRIES

16400: Update_CallableZones(p_list_id);
16401:
16402:
16403:
16404: -- Update AMS_LIST_ENTRIES and IEC_G_RETURN_ENTRIES
16405:
16406: EXECUTE IMMEDIATE
16407:
16408: 'BEGIN