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_SUM_DTL

Line 91: delete from ams_tcop_channel_sum_dtl

87: where enabled_flag = 'Y'
88: and list_header_id = p_list_header_id);
89:
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

Line 504: -- Set Values for AMS_TCOP_CHANNEL_SUM_DTL

500: l_chnl_sum_id_list(j) := l_chnl_sum_id;
501:
502: END IF;
503:
504: -- Set Values for AMS_TCOP_CHANNEL_SUM_DTL
505: k := l_chnl_sum_dtl_id_list.count + 1;
506:
507: -- Set the sequence value for channel_sum_dtl_id
508: OPEN C_GET_CHNL_SUM_DTL_NEXT_SEQ;

Line 512: -- Set values for bulk loading of AMS_TCOP_CHANNEL_SUM_DTL

508: OPEN C_GET_CHNL_SUM_DTL_NEXT_SEQ;
509: FETCH C_GET_CHNL_SUM_DTL_NEXT_SEQ INTO l_sequence_id;
510: CLOSE C_GET_CHNL_SUM_DTL_NEXT_SEQ;
511:
512: -- Set values for bulk loading of AMS_TCOP_CHANNEL_SUM_DTL
513: l_chnl_sum_dtl_id_list(k) := l_sequence_id;
514: l_chnl_sum_id_list_for_dtl(k) := l_chnl_sum_id;
515:
516: -- Set the last party id and media id

Line 558: /* Bulk Upload AMS_TCOP_CHANNEL_SUM_DTL */

554: FND_GLOBAL.USER_ID,
555: FND_GLOBAL.USER_ID
556: );
557:
558: /* Bulk Upload AMS_TCOP_CHANNEL_SUM_DTL */
559: FORALL i in l_chnl_sum_dtl_id_list.FIRST .. l_chnl_sum_dtl_id_list.LAST
560: INSERT INTO
561: AMS_TCOP_CHANNEL_SUM_DTL
562: (

Line 561: AMS_TCOP_CHANNEL_SUM_DTL

557:
558: /* Bulk Upload AMS_TCOP_CHANNEL_SUM_DTL */
559: FORALL i in l_chnl_sum_dtl_id_list.FIRST .. l_chnl_sum_dtl_id_list.LAST
560: INSERT INTO
561: AMS_TCOP_CHANNEL_SUM_DTL
562: (
563: CHANNEL_SUM_DTL_ID,
564: CHANNEL_SUMMARY_ID,
565: SCHEDULE_ID,

Line 1077: -- of table AMS_TCOP_CHANNEL_SUM_DTL

1073: l_list_count := l_existing_party_id_list.count;
1074: IF (l_list_count > 0) THEN
1075: -- There are some existing parties in the channel summarization tables
1076: -- Create an array of sequence ids to populate CHANNEL_SUM_DTL_ID column
1077: -- of table AMS_TCOP_CHANNEL_SUM_DTL
1078:
1079: write_debug_message(LOG_LEVEL_EVENT,
1080: PROCEDURE_NAME,
1081: 'PARTIES_EXIST_IN_CHANNEL_SUMMARY',

Line 1130: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'

1126:
1127: write_debug_message(LOG_LEVEL_EVENT,
1128: PROCEDURE_NAME,
1129: 'BEFORE_BULK_INSERT_CHANNEL_SUM_DTL_L1',
1130: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'
1131: );
1132:
1133: -- Bulk Insert into AMS_TCOP_CHANNEL_SUM_DTL
1134: FORALL i in l_chnl_sum_detail_seq_id_list.FIRST .. l_chnl_sum_detail_seq_id_list.LAST

Line 1133: -- Bulk Insert into AMS_TCOP_CHANNEL_SUM_DTL

1129: 'BEFORE_BULK_INSERT_CHANNEL_SUM_DTL_L1',
1130: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'
1131: );
1132:
1133: -- Bulk Insert into AMS_TCOP_CHANNEL_SUM_DTL
1134: FORALL i in l_chnl_sum_detail_seq_id_list.FIRST .. l_chnl_sum_detail_seq_id_list.LAST
1135: INSERT INTO
1136: AMS_TCOP_CHANNEL_SUM_DTL
1137: (

Line 1136: AMS_TCOP_CHANNEL_SUM_DTL

1132:
1133: -- Bulk Insert into AMS_TCOP_CHANNEL_SUM_DTL
1134: FORALL i in l_chnl_sum_detail_seq_id_list.FIRST .. l_chnl_sum_detail_seq_id_list.LAST
1135: INSERT INTO
1136: AMS_TCOP_CHANNEL_SUM_DTL
1137: (
1138: CHANNEL_SUM_DTL_ID,
1139: CHANNEL_SUMMARY_ID,
1140: SCHEDULE_ID,

Line 1162: 'After Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'

1158:
1159: write_debug_message(LOG_LEVEL_EVENT,
1160: PROCEDURE_NAME,
1161: 'AFTER_BULK_INSERT_CHANNEL_SUM_DTL_L2',
1162: 'After Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'
1163: );
1164:
1165: write_debug_message(LOG_LEVEL_EVENT,
1166: PROCEDURE_NAME,

Line 1317: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'

1313:
1314: write_debug_message(LOG_LEVEL_EVENT,
1315: PROCEDURE_NAME,
1316: 'BEFORE_BULK_INSERT_CHANNEL_SUM_DTL_L2',
1317: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'
1318: );
1319:
1320: -- BULK INSERT INTO AMS_TCOP_CHANNEL_SUM_DTL
1321: FORALL i in l_sum_detail_seq_id_list.FIRST .. l_sum_detail_seq_id_list.LAST

Line 1320: -- BULK INSERT INTO AMS_TCOP_CHANNEL_SUM_DTL

1316: 'BEFORE_BULK_INSERT_CHANNEL_SUM_DTL_L2',
1317: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'
1318: );
1319:
1320: -- BULK INSERT INTO AMS_TCOP_CHANNEL_SUM_DTL
1321: FORALL i in l_sum_detail_seq_id_list.FIRST .. l_sum_detail_seq_id_list.LAST
1322: INSERT INTO
1323: AMS_TCOP_CHANNEL_SUM_DTL
1324: (

Line 1323: AMS_TCOP_CHANNEL_SUM_DTL

1319:
1320: -- BULK INSERT INTO AMS_TCOP_CHANNEL_SUM_DTL
1321: FORALL i in l_sum_detail_seq_id_list.FIRST .. l_sum_detail_seq_id_list.LAST
1322: INSERT INTO
1323: AMS_TCOP_CHANNEL_SUM_DTL
1324: (
1325: CHANNEL_SUM_DTL_ID,
1326: CHANNEL_SUMMARY_ID,
1327: SCHEDULE_ID,

Line 1349: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'

1345:
1346: write_debug_message(LOG_LEVEL_EVENT,
1347: PROCEDURE_NAME,
1348: 'BEFORE_BULK_INSERT_CHANNEL_SUM_DTL_L2',
1349: 'Before Bulk Insert of AMS_TCOP_CHANNEL_SUM_DTL to populate the schedule information'
1350: );
1351:
1352:
1353: END IF;