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_PREVIEW dependencies on JTF_NUMBER_TABLE

Line 25: G_PARTY_TGROUP_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

21:
22: -- Declare some of the Global Variables
23:
24: -- Nested Tables
25: G_PARTY_TGROUP_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
26: G_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
27: G_FATIGUE_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
28: G_FATIGUE_BY_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
29: G_FATIGUE_BY_SCHEDULE_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 26: G_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

22: -- Declare some of the Global Variables
23:
24: -- Nested Tables
25: G_PARTY_TGROUP_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
26: G_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
27: G_FATIGUE_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
28: G_FATIGUE_BY_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
29: G_FATIGUE_BY_SCHEDULE_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
30:

Line 27: G_FATIGUE_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

23:
24: -- Nested Tables
25: G_PARTY_TGROUP_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
26: G_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
27: G_FATIGUE_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
28: G_FATIGUE_BY_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
29: G_FATIGUE_BY_SCHEDULE_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
30:
31: -- Index By Tables

Line 28: G_FATIGUE_BY_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

24: -- Nested Tables
25: G_PARTY_TGROUP_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
26: G_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
27: G_FATIGUE_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
28: G_FATIGUE_BY_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
29: G_FATIGUE_BY_SCHEDULE_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
30:
31: -- Index By Tables
32: G_PRVW_DATE_LIST DATE_TABLE;

Line 29: G_FATIGUE_BY_SCHEDULE_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

25: G_PARTY_TGROUP_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
26: G_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
27: G_FATIGUE_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
28: G_FATIGUE_BY_PARTY_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
29: G_FATIGUE_BY_SCHEDULE_LIST JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
30:
31: -- Index By Tables
32: G_PRVW_DATE_LIST DATE_TABLE;
33:

Line 224: PROCEDURE APPEND_GLOBAL_FATIGUE_LIST(p_fatigue_party_list JTF_NUMBER_TABLE,

220: --
221: -- Purpose
222: -- Append the given list to the global list
223: --
224: PROCEDURE APPEND_GLOBAL_FATIGUE_LIST(p_fatigue_party_list JTF_NUMBER_TABLE,
225: p_fatigue_by_party_list JTF_NUMBER_TABLE,
226: p_fatigue_by_schedule_list JTF_NUMBER_TABLE
227: )
228: IS

Line 225: p_fatigue_by_party_list JTF_NUMBER_TABLE,

221: -- Purpose
222: -- Append the given list to the global list
223: --
224: PROCEDURE APPEND_GLOBAL_FATIGUE_LIST(p_fatigue_party_list JTF_NUMBER_TABLE,
225: p_fatigue_by_party_list JTF_NUMBER_TABLE,
226: p_fatigue_by_schedule_list JTF_NUMBER_TABLE
227: )
228: IS
229:

Line 226: p_fatigue_by_schedule_list JTF_NUMBER_TABLE

222: -- Append the given list to the global list
223: --
224: PROCEDURE APPEND_GLOBAL_FATIGUE_LIST(p_fatigue_party_list JTF_NUMBER_TABLE,
225: p_fatigue_by_party_list JTF_NUMBER_TABLE,
226: p_fatigue_by_schedule_list JTF_NUMBER_TABLE
227: )
228: IS
229:
230: l_global_count NUMBER;

Line 337: PROCEDURE DELETE_FROM_LIST(p_delete_from_list IN OUT NOCOPY jtf_number_table,

333: -- DELETE_FROM_LIST
334: --
335: -- Purpose
336: -- Now, simulate future contact. Basically as if the overlapping
337: PROCEDURE DELETE_FROM_LIST(p_delete_from_list IN OUT NOCOPY jtf_number_table,
338: p_delete_list IN jtf_number_table
339: )
340: IS
341:

Line 338: p_delete_list IN jtf_number_table

334: --
335: -- Purpose
336: -- Now, simulate future contact. Basically as if the overlapping
337: PROCEDURE DELETE_FROM_LIST(p_delete_from_list IN OUT NOCOPY jtf_number_table,
338: p_delete_list IN jtf_number_table
339: )
340: IS
341:
342: l_temp_list jtf_number_table := jtf_number_table();

Line 342: l_temp_list jtf_number_table := jtf_number_table();

338: p_delete_list IN jtf_number_table
339: )
340: IS
341:
342: l_temp_list jtf_number_table := jtf_number_table();
343: l_temp_idx NUMBER;
344: l_temp_num NUMBER;
345:
346: BEGIN

Line 492: p_contact_party_list JTF_NUMBER_TABLE

488: ORDER BY (rule.MAX_CONTACT_ALLOWED * period.NO_OF_DAYS);
489:
490: CURSOR C_GET_GLOBAL_FATIGUE_LIST(p_no_of_days NUMBER,
491: p_preview_date Date,
492: p_contact_party_list JTF_NUMBER_TABLE
493: )
494: IS
495: SELECT /*+ leading(party_list) +*/
496: CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)

Line 499: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))

495: SELECT /*+ leading(party_list) +*/
496: CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)
497: FROM AMS_TCOP_CONTACTS CONTACT,
498: (SELECT COLUMN_VALUE PARTY_ID
499: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
500: ) party_list
501: WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID
502: AND CONTACT_DATE BETWEEN TRUNC(p_preview_date - p_no_of_days)
503: AND TRUNC(p_preview_date)

Line 509: p_contact_party_list JTF_NUMBER_TABLE

505:
506:
507: CURSOR C_GET_GLBL_SIMULATED_FTG_LIST(p_no_of_days NUMBER,
508: p_preview_date Date,
509: p_contact_party_list JTF_NUMBER_TABLE
510: )
511: IS
512: SELECT /*+ leading(party_list) +*/
513: CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)

Line 516: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))

512: SELECT /*+ leading(party_list) +*/
513: CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)
514: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
515: (SELECT COLUMN_VALUE PARTY_ID
516: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
517: ) party_list
518: WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID
519: AND CONTACT_DATE BETWEEN TRUNC(p_preview_date - p_no_of_days)
520: AND TRUNC(p_preview_date)

Line 526: p_contact_party_list JTF_NUMBER_TABLE

522:
523: CURSOR C_GET_CHANNEL_FATIGUE_LIST(p_activity_id NUMBER,
524: p_no_of_days NUMBER,
525: p_preview_date Date,
526: p_contact_party_list JTF_NUMBER_TABLE
527: )
528: IS
529: SELECT /*+ leading(party_list) +*/
530: CONTACT.PARTY_ID,

Line 534: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))

530: CONTACT.PARTY_ID,
531: COUNT(CONTACT.PARTY_ID)
532: FROM AMS_TCOP_CONTACTS CONTACT,
533: (SELECT COLUMN_VALUE PARTY_ID
534: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
535: ) party_list
536: WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID
537: AND CONTACT.MEDIA_ID = p_activity_id
538: AND CONTACT_DATE BETWEEN TRUNC(p_preview_date - p_no_of_days)

Line 545: p_contact_party_list JTF_NUMBER_TABLE

541:
542: CURSOR C_GET_CHNL_SIMULATED_FTG_LIST(p_activity_id NUMBER,
543: p_no_of_days NUMBER,
544: p_preview_date Date,
545: p_contact_party_list JTF_NUMBER_TABLE
546: )
547: IS
548: SELECT /*+ leading(party_list) +*/
549: CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)

Line 553: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))

549: CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)
550: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
551: AMS_CAMPAIGN_SCHEDULES_B CSCH,
552: (SELECT COLUMN_VALUE PARTY_ID
553: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
554: ) party_list
555: WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID
556: AND CSCH.SCHEDULE_ID = CONTACT.SCHEDULE_ID
557: AND CSCH.ACTIVITY_ID = p_activity_id

Line 562: CURSOR C_CHECK_PARTY_IN_CONTACT_LIST(p_contact_party_list JTF_NUMBER_TABLE

558: AND CONTACT_DATE BETWEEN TRUNC(p_preview_date - p_no_of_days)
559: AND TRUNC(p_preview_date)
560: GROUP BY CONTACT.PARTY_ID;
561:
562: CURSOR C_CHECK_PARTY_IN_CONTACT_LIST(p_contact_party_list JTF_NUMBER_TABLE
563: , p_party_id NUMBER
564: )
565: IS
566: SELECT party_list.party_id

Line 569: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))

565: IS
566: SELECT party_list.party_id
567: FROM
568: (SELECT column_value party_id
569: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
570: ) party_list
571: WHERE party_list.party_id=p_party_id;
572:
573: CURSOR C_GET_NEXT_PRVW_CONTACT

Line 580: l_contact_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

576: FROM DUAL;
577:
578:
579: l_schedule_id_list NUMBER_TABLE;
580: l_contact_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
581: l_schedule_activity_id_list NUMBER_TABLE;
582: l_schedule_start_date_list DATE_TABLE;
583:
584: l_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 584: l_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

580: l_contact_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
581: l_schedule_activity_id_list NUMBER_TABLE;
582: l_schedule_start_date_list DATE_TABLE;
583:
584: l_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
585: l_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_global_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 585: l_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

581: l_schedule_activity_id_list NUMBER_TABLE;
582: l_schedule_start_date_list DATE_TABLE;
583:
584: l_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
585: l_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_global_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
589: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 586: l_global_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

582: l_schedule_start_date_list DATE_TABLE;
583:
584: l_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
585: l_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_global_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
589: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
590: l_temp_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

583:
584: l_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
585: l_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_global_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
589: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
590: l_temp_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
591: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

584: l_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
585: l_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_global_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
589: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
590: l_temp_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
591: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
592:

Line 589: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

585: l_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_global_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
589: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
590: l_temp_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
591: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
592:
593: l_fatigue_index NUMBER;

Line 590: l_temp_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

586: l_global_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
589: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
590: l_temp_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
591: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
592:
593: l_fatigue_index NUMBER;
594: l_contact_index NUMBER;

Line 591: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

587: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_channel_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
589: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
590: l_temp_contact_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
591: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
592:
593: l_fatigue_index NUMBER;
594: l_contact_index NUMBER;
595: l_global_contact_count NUMBER;

Line 1114: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE)) ) PARTY_LIST

1110: IS
1111: SELECT PARTY_LIST.PARTY_ID
1112: FROM
1113: (SELECT column_value PARTY_ID
1114: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE)) ) PARTY_LIST
1115: WHERE EXISTS
1116: (SELECT PARTY_ID
1117: FROM AMS_TCOP_CONTACTS
1118: WHERE PARTY_ID = PARTY_LIST.PARTY_ID

Line 1128: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))) PARTY_LIST

1124: IS
1125: SELECT PARTY_LIST.PARTY_ID
1126: FROM
1127: (SELECT column_value party_id
1128: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))) PARTY_LIST
1129: WHERE EXISTS
1130: (SELECT PARTY_ID
1131: FROM AMS_TCOP_CONTACTS
1132: WHERE PARTY_ID = PARTY_LIST.PARTY_ID

Line 1143: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))

1139: SELECT /*+ leading(party_list) +*/
1140: CONTACT.PARTY_ID,COUNT(CONTACT.PARTY_ID)
1141: FROM AMS_TCOP_CONTACTS CONTACT,
1142: (SELECT column_value party_id
1143: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
1144: ) party_list
1145: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
1146: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
1147: GROUP BY CONTACT.PARTY_ID;

Line 1155: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))

1151: SELECT /*+ leading(party_list) +*/
1152: CONTACT.PARTY_ID,COUNT(CONTACT.PARTY_ID)
1153: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1154: (SELECT column_value party_id
1155: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
1156: ) party_list
1157: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
1158: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
1159: AND PREVIEW_ID = G_PRVW_REQUEST_ID

Line 1171: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))

1167: CONTACT.PARTY_ID,COUNT(CONTACT.PARTY_ID)
1168: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1169: AMS_CAMPAIGN_SCHEDULES_B CSCH,
1170: (SELECT column_value party_id
1171: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
1172: ) party_list
1173: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
1174: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
1175: AND PREVIEW_ID = G_PRVW_REQUEST_ID

Line 1182: ,p_fatigue_party_list JTF_NUMBER_TABLE

1178: GROUP BY CONTACT.PARTY_ID;
1179:
1180: CURSOR C_GET_GLOBAL_FATIGUE_BY(p_start_date date
1181: ,p_end_date date
1182: ,p_fatigue_party_list JTF_NUMBER_TABLE
1183: )
1184: IS
1185: SELECT /*+ leading(party_list) +*/
1186: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID

Line 1189: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))

1185: SELECT /*+ leading(party_list) +*/
1186: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
1187: FROM AMS_TCOP_CONTACTS CONTACT,
1188: (SELECT column_value party_id
1189: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
1190: ) party_list
1191: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
1192: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;
1193:

Line 1202: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))

1198: CONTACT.PARTY_ID,
1199: COUNT(CONTACT.PARTY_ID)
1200: FROM AMS_TCOP_CONTACTS CONTACT,
1201: (SELECT column_value party_id
1202: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
1203: ) party_list
1204: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
1205: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
1206: AND CONTACT.MEDIA_ID = G_Activity_Id

Line 1211: ,p_fatigue_party_list JTF_NUMBER_TABLE

1207: GROUP BY CONTACT.PARTY_ID;
1208:
1209: CURSOR C_GET_CHANNEL_FATIGUE_BY(p_start_date date
1210: ,p_end_date date
1211: ,p_fatigue_party_list JTF_NUMBER_TABLE
1212: )
1213: IS
1214: SELECT /*+ leading(party_list) +*/
1215: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID

Line 1218: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))

1214: SELECT /*+ leading(party_list) +*/
1215: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
1216: FROM AMS_TCOP_CONTACTS CONTACT,
1217: (SELECT column_value party_id
1218: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
1219: ) party_list
1220: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
1221: AND CONTACT.MEDIA_ID = G_ACTIVITY_ID
1222: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;

Line 1226: ,p_fatigue_party_list JTF_NUMBER_TABLE

1222: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;
1223:
1224: CURSOR C_GET_GLOBAL_PRVW_FTG_BY(p_start_date date
1225: ,p_end_date date
1226: ,p_fatigue_party_list JTF_NUMBER_TABLE
1227: )
1228: IS
1229: SELECT /*+ leading(party_list) +*/
1230: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID

Line 1233: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))

1229: SELECT /*+ leading(party_list) +*/
1230: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
1231: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1232: (SELECT column_value party_id
1233: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
1234: ) party_list
1235: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
1236: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;
1237:

Line 1240: ,p_fatigue_party_list JTF_NUMBER_TABLE

1236: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;
1237:
1238: CURSOR C_GET_CHANNEL_PRVW_FTG_BY(p_start_date date
1239: ,p_end_date date
1240: ,p_fatigue_party_list JTF_NUMBER_TABLE
1241: )
1242: IS
1243: SELECT /*+ leading(party_list) +*/
1244: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID

Line 1248: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))

1244: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
1245: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1246: AMS_CAMPAIGN_SCHEDULES_B CSCH,
1247: (SELECT column_value party_id
1248: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
1249: ) party_list
1250: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
1251: AND CONTACT.SCHEDULE_ID = CSCH.SCHEDULE_ID
1252: AND CSCH.ACTIVITY_ID = G_ACTIVITY_ID

Line 1255: CURSOR C_CHECK_PARTY_IN_CONTACT_LIST(p_contact_party_list JTF_NUMBER_TABLE

1251: AND CONTACT.SCHEDULE_ID = CSCH.SCHEDULE_ID
1252: AND CSCH.ACTIVITY_ID = G_ACTIVITY_ID
1253: AND CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;
1254:
1255: CURSOR C_CHECK_PARTY_IN_CONTACT_LIST(p_contact_party_list JTF_NUMBER_TABLE
1256: ,p_party_id NUMBER
1257: )
1258: IS
1259: SELECT party_list.party_id

Line 1262: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))

1258: IS
1259: SELECT party_list.party_id
1260: FROM
1261: (SELECT column_value party_id
1262: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
1263: ) party_list
1264: WHERE party_list.party_id=p_party_id;
1265:
1266: CURSOR GET_SCHEDULE_FROM_CONTACTS(p_party_id number,

Line 1346: l_global_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1342: l_fatigue_dtl_id NUMBER;
1343: l_ftg_by_id NUMBER;
1344: l_fatigue_count NUMBER;
1345:
1346: l_global_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1347: l_temp_ftg_prvw_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1348: l_temp_prvw_ftg_by_party JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1347: l_temp_ftg_prvw_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1343: l_ftg_by_id NUMBER;
1344: l_fatigue_count NUMBER;
1345:
1346: l_global_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1347: l_temp_ftg_prvw_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1348: l_temp_prvw_ftg_by_party JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1348: l_temp_prvw_ftg_by_party JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1344: l_fatigue_count NUMBER;
1345:
1346: l_global_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1347: l_temp_ftg_prvw_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1348: l_temp_prvw_ftg_by_party JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1345:
1346: l_global_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1347: l_temp_ftg_prvw_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1348: l_temp_prvw_ftg_by_party JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1346: l_global_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1347: l_temp_ftg_prvw_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1348: l_temp_prvw_ftg_by_party JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1347: l_temp_ftg_prvw_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1348: l_temp_prvw_ftg_by_party JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1348: l_temp_prvw_ftg_by_party JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1349: l_temp_prvw_ftg_by_schedule JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1350: l_global_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1351: l_schedule_contact_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1352: l_schedule_prvw_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1360: l_fatigue_detail_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1353: l_temp_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1360: l_fatigue_detail_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1361: l_fatigue_detail_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1354: l_temp_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1360: l_fatigue_detail_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1361: l_fatigue_detail_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1362: l_fatigue_by_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1355: l_channel_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1360: l_fatigue_detail_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1361: l_fatigue_detail_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1362: l_fatigue_by_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1363:

Line 1360: l_fatigue_detail_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1356: l_channel_contact_count_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1360: l_fatigue_detail_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1361: l_fatigue_detail_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1362: l_fatigue_by_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1363:
1364: l_global_rule_val NUMBER := 0;

Line 1361: l_fatigue_detail_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1357: l_temp_fatigue_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1360: l_fatigue_detail_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1361: l_fatigue_detail_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1362: l_fatigue_by_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1363:
1364: l_global_rule_val NUMBER := 0;
1365: l_channnel_rule_val NUMBER :=0;

Line 1362: l_fatigue_by_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1358: l_temp_fatigue_by_party_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1359: l_temp_ftg_by_schedule_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1360: l_fatigue_detail_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1361: l_fatigue_detail_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1362: l_fatigue_by_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1363:
1364: l_global_rule_val NUMBER := 0;
1365: l_channnel_rule_val NUMBER :=0;
1366: BEGIN