APPS.AMS_TCOP_PREVIEW dependencies on AMS_TCOP_CONTACTS

Line 497: FROM AMS_TCOP_CONTACTS CONTACT,

493: )
494: IS
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

Line 532: FROM AMS_TCOP_CONTACTS CONTACT,

528: IS
529: SELECT /*+ leading(party_list) +*/
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

Line 1117: FROM AMS_TCOP_CONTACTS

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
1119: AND CONTACT_DATE BETWEEN p_start_date and p_end_date
1120: );
1121:

Line 1131: FROM AMS_TCOP_CONTACTS

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
1133: AND MEDIA_ID = G_ACTIVITY_ID
1134: AND CONTACT_DATE BETWEEN p_start_date and p_end_date
1135: );

Line 1141: FROM AMS_TCOP_CONTACTS CONTACT,

1137: CURSOR C_GET_GLOBAL_CONTACT_COUNT(p_start_date date,p_end_date date)
1138: IS
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

Line 1187: FROM AMS_TCOP_CONTACTS CONTACT,

1183: )
1184: IS
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

Line 1200: FROM AMS_TCOP_CONTACTS CONTACT,

1196: IS
1197: SELECT /*+ leading(party_list) +*/
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

Line 1216: FROM AMS_TCOP_CONTACTS CONTACT,

1212: )
1213: IS
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

Line 1272: FROM AMS_TCOP_CONTACTS

1268: p_end_date date
1269: )
1270: IS
1271: SELECT SCHEDULE_ID
1272: FROM AMS_TCOP_CONTACTS
1273: WHERE CONTACT_DATE BETWEEN p_start_date and p_end_date
1274: AND PARTY_ID = p_party_id;
1275:
1276: CURSOR GET_CSCH_FROM_CONTACTS_CHNL(p_party_id number,

Line 1282: FROM AMS_TCOP_CONTACTS CONTACT

1278: p_end_date date
1279: )
1280: IS
1281: SELECT CONTACT.SCHEDULE_ID
1282: FROM AMS_TCOP_CONTACTS CONTACT
1283: WHERE CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
1284: AND CONTACT.MEDIA_ID = G_ACTIVITY_ID
1285: AND CONTACT.PARTY_ID = p_party_id;
1286:

Line 1416: -- check if any of these parties exist in AMS_TCOP_CONTACTS

1412: IF (trunc(l_global_fatigue_start_date) <= trunc(sysdate)) THEN
1413: --dbms_output.put_line('Global Fatigue Start Date Is a Past Date');
1414:
1415:
1416: -- check if any of these parties exist in AMS_TCOP_CONTACTS
1417: OPEN C_CHECK_PARTY(l_global_fatigue_start_date,sysdate);
1418: FETCH C_CHECK_PARTY
1419: INTO l_party_id;
1420: CLOSE C_CHECK_PARTY;

Line 1533: -- in AMS_TCOP_CONTACTS and

1529: G_Global_max_contact) THEN
1530: -- this entry is fatigued
1531: -- now, find out the fatigued by
1532: -- it will be a combination of schedules
1533: -- in AMS_TCOP_CONTACTS and
1534: -- AMS_TCOP_PRVW_CONTACTS
1535: OPEN GET_SCHEDULE_FROM_CONTACTS
1536: (l_party_id,
1537: l_global_fatigue_start_date,

Line 1840: -- in AMS_TCOP_CONTACTS and

1836: G_channel_max_contact) THEN
1837: -- this entry is fatigued
1838: -- now, find out the fatigued by
1839: -- it will be a combination of schedules
1840: -- in AMS_TCOP_CONTACTS and
1841: -- AMS_TCOP_PRVW_CONTACTS
1842: OPEN GET_CSCH_FROM_CONTACTS_CHNL
1843: (l_party_id,
1844: l_channel_fatigue_start_date,