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_CHANNEL_SUMMARY

Line 94: from ams_tcop_channel_summary summary,

90: -- Delete the records for (party_id,media_id) combination
91: delete from ams_tcop_channel_sum_dtl
92: where channel_summary_id in
93: (select summary.channel_summary_id
94: from ams_tcop_channel_summary summary,
95: ams_list_entries list_entry
96: where list_entry.party_id = summary.party_id
97: and list_entry.list_header_id = p_list_header_id
98: and summary.media_id = p_activity_id

Line 101: delete from ams_tcop_channel_summary

97: and list_entry.list_header_id = p_list_header_id
98: and summary.media_id = p_activity_id
99: and list_entry.enabled_flag = 'Y');
100:
101: delete from ams_tcop_channel_summary
102: where party_id in
103: (select summary.PARTY_ID
104: from ams_tcop_channel_summary summary,
105: ams_list_entries list_entry

Line 104: from ams_tcop_channel_summary summary,

100:
101: delete from ams_tcop_channel_summary
102: where party_id in
103: (select summary.PARTY_ID
104: from ams_tcop_channel_summary summary,
105: ams_list_entries list_entry
106: where list_entry.party_id = summary.party_id
107: and list_entry.list_header_id = p_list_header_id
108: and summary.media_id = p_activity_id

Line 490: -- Initialize the Arrays to do a bulk upload for AMS_TCOP_CHANNEL_SUMMARY

486: l_contact_count_list(j) := l_contact_count_list(j) +1;
487:
488:
489: ELSE
490: -- Initialize the Arrays to do a bulk upload for AMS_TCOP_CHANNEL_SUMMARY
491: j := l_final_party_id_list.count + 1;
492: l_final_party_id_list (j) := l_temp_party_id_list(i);
493: l_contact_count_list(j) := 1; -- the count starts
494:

Line 524: 'BEFORE_BULK_UPLOADING_AMS_TCOP_CHANNEL_SUMMARY',

520: END LOOP;
521:
522: write_debug_message(LOG_LEVEL_EVENT,
523: PROCEDURE_NAME,
524: 'BEFORE_BULK_UPLOADING_AMS_TCOP_CHANNEL_SUMMARY',
525: 'Total number of record uploaded = '||to_char(l_final_party_id_list.count)
526: );
527:
528: /* Bulk Upload AMS_TCOP_CHANNEL_SUMMARY */

Line 528: /* Bulk Upload AMS_TCOP_CHANNEL_SUMMARY */

524: 'BEFORE_BULK_UPLOADING_AMS_TCOP_CHANNEL_SUMMARY',
525: 'Total number of record uploaded = '||to_char(l_final_party_id_list.count)
526: );
527:
528: /* Bulk Upload AMS_TCOP_CHANNEL_SUMMARY */
529: FORALL i in l_final_party_id_list.FIRST .. l_final_party_id_list.LAST
530: INSERT INTO
531: AMS_TCOP_CHANNEL_SUMMARY
532: (

Line 531: AMS_TCOP_CHANNEL_SUMMARY

527:
528: /* Bulk Upload AMS_TCOP_CHANNEL_SUMMARY */
529: FORALL i in l_final_party_id_list.FIRST .. l_final_party_id_list.LAST
530: INSERT INTO
531: AMS_TCOP_CHANNEL_SUMMARY
532: (
533: CHANNEL_SUMMARY_ID,
534: RULE_ID,
535: PARTY_ID,

Line 661: -- Get existing entries from AMS_TCOP_CHANNEL_SUMMARY

657: IS
658: SELECT AMS_TCOP_CHNL_SUM_S.NEXTVAL
659: FROM DUAL;
660:
661: -- Get existing entries from AMS_TCOP_CHANNEL_SUMMARY
662: CURSOR C_GET_EXISTING_PARTY_CHNL (p_party_id_list JTF_NUMBER_TABLE
663: ,p_activity_id NUMBER
664: )
665: IS

Line 667: FROM AMS_TCOP_CHANNEL_SUMMARY summary,

663: ,p_activity_id NUMBER
664: )
665: IS
666: SELECT summary.PARTY_ID,summary.channel_summary_id
667: FROM AMS_TCOP_CHANNEL_SUMMARY summary,
668: (SELECT column_value party_id
669: FROM TABLE(CAST(p_party_id_List as JTF_NUMBER_TABLE))
670: ) party_list
671: WHERE summary.party_id=party_list.party_id

Line 1111: 'Bulk update AMS_TCOP_CHANNEL_SUMMARY to increment the contact count'

1107:
1108: write_debug_message(LOG_LEVEL_EVENT,
1109: PROCEDURE_NAME,
1110: 'BEFORE_BULK_UPDATE_CHANNEL_SUMMARY',
1111: 'Bulk update AMS_TCOP_CHANNEL_SUMMARY to increment the contact count'
1112: );
1113:
1114: -- Bulk Update AMS_TCOP_CHANNEL_SUMMARY table
1115: FORALL i in l_channel_summary_id_list.FIRST .. l_channel_summary_id_list.LAST

Line 1114: -- Bulk Update AMS_TCOP_CHANNEL_SUMMARY table

1110: 'BEFORE_BULK_UPDATE_CHANNEL_SUMMARY',
1111: 'Bulk update AMS_TCOP_CHANNEL_SUMMARY to increment the contact count'
1112: );
1113:
1114: -- Bulk Update AMS_TCOP_CHANNEL_SUMMARY table
1115: FORALL i in l_channel_summary_id_list.FIRST .. l_channel_summary_id_list.LAST
1116: UPDATE AMS_TCOP_CHANNEL_SUMMARY
1117: SET TOTAL_CONTACTS = TOTAL_CONTACTS + 1
1118: WHERE CHANNEL_SUMMARY_ID = l_channel_summary_id_list(i)

Line 1116: UPDATE AMS_TCOP_CHANNEL_SUMMARY

1112: );
1113:
1114: -- Bulk Update AMS_TCOP_CHANNEL_SUMMARY table
1115: FORALL i in l_channel_summary_id_list.FIRST .. l_channel_summary_id_list.LAST
1116: UPDATE AMS_TCOP_CHANNEL_SUMMARY
1117: SET TOTAL_CONTACTS = TOTAL_CONTACTS + 1
1118: WHERE CHANNEL_SUMMARY_ID = l_channel_summary_id_list(i)
1119: AND MEDIA_ID = p_activity_id;
1120:

Line 1124: 'After Bulk update AMS_TCOP_CHANNEL_SUMMARY to increment the contact count'

1120:
1121: write_debug_message(LOG_LEVEL_EVENT,
1122: PROCEDURE_NAME,
1123: 'AFTER_BULK_UPDATE_CHANNEL_SUMMARY',
1124: 'After Bulk update AMS_TCOP_CHANNEL_SUMMARY to increment the contact count'
1125: );
1126:
1127: write_debug_message(LOG_LEVEL_EVENT,
1128: PROCEDURE_NAME,

Line 1278: -- BULK INSERT INTO AMS_TCOP_CHANNEL_SUMMARY

1274: 'BEFORE_BULK_INSERT_CHANNEL_SUM',
1275: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUMMMARY'
1276: );
1277:
1278: -- BULK INSERT INTO AMS_TCOP_CHANNEL_SUMMARY
1279: FORALL i in l_new_party_id_list.FIRST .. l_new_party_id_list.LAST
1280: INSERT INTO
1281: AMS_TCOP_CHANNEL_SUMMARY
1282: (

Line 1281: AMS_TCOP_CHANNEL_SUMMARY

1277:
1278: -- BULK INSERT INTO AMS_TCOP_CHANNEL_SUMMARY
1279: FORALL i in l_new_party_id_list.FIRST .. l_new_party_id_list.LAST
1280: INSERT INTO
1281: AMS_TCOP_CHANNEL_SUMMARY
1282: (
1283: CHANNEL_SUMMARY_ID,
1284: RULE_ID,
1285: PARTY_ID,