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.AMS_TCOP_SUMMARIZATION_PKG dependencies on AMS_TCOP_CONTACT_SUMMARY

Line 77: from ams_tcop_contact_summary summary,

73:
74: delete from ams_tcop_contact_sum_dtl
75: where contact_summary_id in
76: (select summary.contact_summary_id
77: from ams_tcop_contact_summary summary,
78: ams_list_entries list_entry
79: where list_entry.enabled_flag = 'Y'
80: and list_entry.list_header_id = p_list_header_id
81: and list_entry.party_id = summary.party_id );

Line 83: delete from ams_tcop_contact_summary

79: where list_entry.enabled_flag = 'Y'
80: and list_entry.list_header_id = p_list_header_id
81: and list_entry.party_id = summary.party_id );
82:
83: delete from ams_tcop_contact_summary
84: where party_id in
85: (select party_id
86: from ams_list_entries
87: where enabled_flag = 'Y'

Line 307: -- Populate arrays to do a Bulk insert for AMS_TCOP_CONTACT_SUMMARY

303:
304: -- Get the List of Schedules which contacted them in the time period
305: -- specified in the Global Fatigue Rule
306: IF (l_total_fatigue_contact > 0) THEN
307: -- Populate arrays to do a Bulk insert for AMS_TCOP_CONTACT_SUMMARY
308:
309: -- Initialize Loop Variables
310: l_last_party_id := 0;
311: l_total_contact_count := 0;

Line 356: 'BEFORE BULK UPLOADING AMS_TCOP_CONTACT_SUMMARY',

352: END LOOP;
353:
354: write_debug_message(LOG_LEVEL_EVENT,
355: PROCEDURE_NAME,
356: 'BEFORE BULK UPLOADING AMS_TCOP_CONTACT_SUMMARY',
357: 'Total Number of records to be loaded = '||to_char(l_final_party_id_list.COUNT));
358:
359: -- Do Bulk Insert into AMS_TCOP_CONTACT_SUMMARY
360: FORALL i in l_final_party_id_list.FIRST .. l_final_party_id_list.LAST

Line 359: -- Do Bulk Insert into AMS_TCOP_CONTACT_SUMMARY

355: PROCEDURE_NAME,
356: 'BEFORE BULK UPLOADING AMS_TCOP_CONTACT_SUMMARY',
357: 'Total Number of records to be loaded = '||to_char(l_final_party_id_list.COUNT));
358:
359: -- Do Bulk Insert into AMS_TCOP_CONTACT_SUMMARY
360: FORALL i in l_final_party_id_list.FIRST .. l_final_party_id_list.LAST
361: INSERT INTO
362: AMS_TCOP_CONTACT_SUMMARY
363: (

Line 362: AMS_TCOP_CONTACT_SUMMARY

358:
359: -- Do Bulk Insert into AMS_TCOP_CONTACT_SUMMARY
360: FORALL i in l_final_party_id_list.FIRST .. l_final_party_id_list.LAST
361: INSERT INTO
362: AMS_TCOP_CONTACT_SUMMARY
363: (
364: CONTACT_SUMMARY_ID,
365: RULE_ID,
366: PARTY_ID,

Line 389: 'AFTER BULK UPLOADING AMS_TCOP_CONTACT_SUMMARY',

385: );
386:
387: write_debug_message(LOG_LEVEL_EVENT,
388: PROCEDURE_NAME,
389: 'AFTER BULK UPLOADING AMS_TCOP_CONTACT_SUMMARY',
390: 'BULK UPLOAD COMPLETED SUCCESSFULLY');
391:
392: write_debug_message(LOG_LEVEL_EVENT,
393: PROCEDURE_NAME,

Line 617: -- Verify if new entries need to be created in AMS_TCOP_CONTACT_SUMMARY

613: ,p_channel_rule_id NUMBER
614: )
615:
616: IS
617: -- Verify if new entries need to be created in AMS_TCOP_CONTACT_SUMMARY
618: -- and in AMS_TCOP_CONTACT_SUM_DTL
619: CURSOR C_GET_EXISTING_PARTY (p_party_id_list JTF_NUMBER_TABLE)
620: IS
621: SELECT summary.PARTY_ID,summary.contact_summary_id

Line 622: FROM AMS_TCOP_CONTACT_SUMMARY summary,

618: -- and in AMS_TCOP_CONTACT_SUM_DTL
619: CURSOR C_GET_EXISTING_PARTY (p_party_id_list JTF_NUMBER_TABLE)
620: IS
621: SELECT summary.PARTY_ID,summary.contact_summary_id
622: FROM AMS_TCOP_CONTACT_SUMMARY summary,
623: (SELECT column_value party_id
624: FROM TABLE(CAST(p_party_id_List as JTF_NUMBER_TABLE))
625: ) party_list
626: WHERE summary.party_id=party_list.party_id;

Line 675: -- AMS_TCOP_CONTACT_SUMMARY and in AMS_TCOP_CONTACT_SUM_DTL

671: WHERE summary.party_id=party_list.party_id
672: AND summary.media_id=p_activity_id;
673:
674: -- Get the list of parties which already have a row in
675: -- AMS_TCOP_CONTACT_SUMMARY and in AMS_TCOP_CONTACT_SUM_DTL
676:
677: l_existing_party_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
678: l_new_party_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
679:

Line 735: -- update the AMS_TCOP_CONTACT_SUMMARY

731: 'Executing Cursor C_GET_EXISTING_PARTY'
732: );
733:
734: -- If there is no global contact rule setup then there is no need
735: -- update the AMS_TCOP_CONTACT_SUMMARY
736:
737:
738:
739: -- Get the existing party list from the Global Summarization Tables

Line 783: 'Bulk update AMS_TCOP_CONTACT_SUMMARY to increment the contact count'

779:
780: write_debug_message(LOG_LEVEL_EVENT,
781: PROCEDURE_NAME,
782: 'BEFORE_BULK_UPDATE_CONTACT_SUMMARY',
783: 'Bulk update AMS_TCOP_CONTACT_SUMMARY to increment the contact count'
784: );
785:
786: -- Bulk Update AMS_TCOP_CONTACT_SUMMARY table
787: FORALL i in l_contact_summary_id_list.FIRST .. l_contact_summary_id_list.LAST

Line 786: -- Bulk Update AMS_TCOP_CONTACT_SUMMARY table

782: 'BEFORE_BULK_UPDATE_CONTACT_SUMMARY',
783: 'Bulk update AMS_TCOP_CONTACT_SUMMARY to increment the contact count'
784: );
785:
786: -- Bulk Update AMS_TCOP_CONTACT_SUMMARY table
787: FORALL i in l_contact_summary_id_list.FIRST .. l_contact_summary_id_list.LAST
788: UPDATE AMS_TCOP_CONTACT_SUMMARY
789: SET TOTAL_CONTACTS = TOTAL_CONTACTS + 1
790: WHERE CONTACT_SUMMARY_ID = l_contact_summary_id_list(i);

Line 788: UPDATE AMS_TCOP_CONTACT_SUMMARY

784: );
785:
786: -- Bulk Update AMS_TCOP_CONTACT_SUMMARY table
787: FORALL i in l_contact_summary_id_list.FIRST .. l_contact_summary_id_list.LAST
788: UPDATE AMS_TCOP_CONTACT_SUMMARY
789: SET TOTAL_CONTACTS = TOTAL_CONTACTS + 1
790: WHERE CONTACT_SUMMARY_ID = l_contact_summary_id_list(i);
791:
792: write_debug_message(LOG_LEVEL_EVENT,

Line 795: 'Bulk update AMS_TCOP_CONTACT_SUMMARY to increment the contact count completed successfully!'

791:
792: write_debug_message(LOG_LEVEL_EVENT,
793: PROCEDURE_NAME,
794: 'AFTER_BULK_UPDATE_CONTACT_SUMMARY',
795: 'Bulk update AMS_TCOP_CONTACT_SUMMARY to increment the contact count completed successfully!'
796: );
797:
798: write_debug_message(LOG_LEVEL_EVENT,
799: PROCEDURE_NAME,

Line 941: 'Bulk Insert the new party ids into the AMS_TCOP_CONTACT_SUMMARY'

937:
938: write_debug_message(LOG_LEVEL_EVENT,
939: PROCEDURE_NAME,
940: 'BEFORE_BULK_INSERT_INTO_CONTACT_SUMMARY',
941: 'Bulk Insert the new party ids into the AMS_TCOP_CONTACT_SUMMARY'
942: );
943:
944: -- BULK INSERT INTO AMS_TCOP_CONTACT_SUMMARY
945: FORALL i in l_new_party_id_list.FIRST .. l_new_party_id_list.LAST

Line 944: -- BULK INSERT INTO AMS_TCOP_CONTACT_SUMMARY

940: 'BEFORE_BULK_INSERT_INTO_CONTACT_SUMMARY',
941: 'Bulk Insert the new party ids into the AMS_TCOP_CONTACT_SUMMARY'
942: );
943:
944: -- BULK INSERT INTO AMS_TCOP_CONTACT_SUMMARY
945: FORALL i in l_new_party_id_list.FIRST .. l_new_party_id_list.LAST
946: INSERT INTO
947: AMS_TCOP_CONTACT_SUMMARY
948: (

Line 947: AMS_TCOP_CONTACT_SUMMARY

943:
944: -- BULK INSERT INTO AMS_TCOP_CONTACT_SUMMARY
945: FORALL i in l_new_party_id_list.FIRST .. l_new_party_id_list.LAST
946: INSERT INTO
947: AMS_TCOP_CONTACT_SUMMARY
948: (
949: CONTACT_SUMMARY_ID,
950: RULE_ID,
951: PARTY_ID,

Line 975: 'Bulk Insertion of the new party ids into the AMS_TCOP_CONTACT_SUMMARY completed successfully'

971:
972: write_debug_message(LOG_LEVEL_EVENT,
973: PROCEDURE_NAME,
974: 'AFTER_BULK_INSERT_INTO_CONTACT_SUMMARY',
975: 'Bulk Insertion of the new party ids into the AMS_TCOP_CONTACT_SUMMARY completed successfully'
976: );
977:
978: write_debug_message(LOG_LEVEL_EVENT,
979: PROCEDURE_NAME,

Line 981: 'Bulk Insertion of the new party ids into the AMS_TCOP_CONTACT_SUMMARY completed successfully'

977:
978: write_debug_message(LOG_LEVEL_EVENT,
979: PROCEDURE_NAME,
980: 'AFTER_BULK_INSERT_INTO_CONTACT_SUMMARY',
981: 'Bulk Insertion of the new party ids into the AMS_TCOP_CONTACT_SUMMARY completed successfully'
982: );
983:
984: write_debug_message(LOG_LEVEL_EVENT,
985: PROCEDURE_NAME,