[Home] [Help]
323: ,pref.CONTACT_TYPE
324: ,pref.MAX_NO_OF_INTERACTIONS
325: ,pref.MAX_NO_OF_INTERACT_UOM_CODE
326: FROM HZ_CONTACT_PREFERENCES pref,
327: ams_list_entries list_entry
328: WHERE list_entry.LIST_HEADER_ID = p_list_header_id
329: AND pref.contact_level_table='HZ_PARTIES'
330: AND pref.contact_level_table_id = list_entry.PARTY_ID
331: AND (pref.CONTACT_TYPE = 'ALL' or pref.CONTACT_TYPE = p_channel)
347: ,pref.CONTACT_TYPE CONTACT_TYPE
348: ,pref.MAX_NO_OF_INTERACTIONS MAX_NO_OF_INTERACTIONS
349: ,pref.MAX_NO_OF_INTERACT_UOM_CODE MAX_NO_OF_INTERACT_UOM_CODE
350: FROM HZ_CONTACT_PREFERENCES pref,
351: ams_list_entries list_entry
352: WHERE list_entry.LIST_HEADER_ID = p_list_header_id
353: AND pref.contact_level_table='HZ_PARTIES'
354: AND pref.contact_level_table_id = list_entry.PARTY_ID
355: AND pref.CONTACT_TYPE = 'ALL'
522: p_rule_id number)
523: IS
524: SELECT list.LIST_ENTRY_ID,summary.party_id
525: FROM ams_tcop_contact_summary summary,
526: ams_list_entries list
527: WHERE list.LIST_HEADER_ID = p_list_header_id
528: AND summary.PARTY_ID = list.PARTY_ID
529: AND list.ENABLED_FLAG = 'Y'
530: AND summary.total_contacts >= (SELECT max_contact_allowed
537: )
538: IS
539: SELECT list.LIST_ENTRY_ID,summary.party_id
540: FROM ams_tcop_contact_summary summary,
541: ams_list_entries list
542: WHERE list.LIST_HEADER_ID = p_list_header_id
543: AND summary.PARTY_ID = list.PARTY_ID
544: AND list.ENABLED_FLAG = 'Y'
545: AND summary.total_contacts >= (SELECT max_contact_allowed
556: )
557: IS
558: SELECT list.LIST_ENTRY_ID,summary.party_id
559: FROM ams_tcop_channel_summary summary,
560: ams_list_entries list
561: WHERE list.LIST_HEADER_ID = p_list_header_id
562: AND summary.PARTY_ID = list.PARTY_ID
563: AND list.ENABLED_FLAG = 'Y'
564: AND summary.media_id = p_media_id
575: )
576: IS
577: SELECT list.LIST_ENTRY_ID,summary.party_id
578: FROM ams_tcop_channel_summary summary,
579: ams_list_entries list
580: WHERE list.LIST_HEADER_ID = p_list_header_id
581: AND summary.PARTY_ID = list.PARTY_ID
582: AND list.ENABLED_FLAG = 'Y'
583: AND summary.media_id = p_media_id
595: p_rule_id number)
596: IS
597: SELECT list.LIST_ENTRY_ID,sum_dtl.SCHEDULE_ID
598: FROM ams_tcop_contact_summary summary,
599: ams_list_entries list,
600: ams_tcop_contact_sum_dtl sum_dtl
601: WHERE list.LIST_HEADER_ID =
602: AND summary.PARTY_ID = list.PARTY_ID
603: AND summary.total_contacts = (SELECT max_contact_allowed
619: IS
620: SELECT /*+ leading(party_list) +*/
621: list.LIST_ENTRY_ID,sum_dtl.SCHEDULE_ID
622: FROM ams_tcop_contact_summary summary,
623: ams_list_entries list,
624: ams_tcop_contact_sum_dtl sum_dtl,
625: (SELECT column_value party_id
626: FROM TABLE(CAST(p_ftg_party_list as JTF_NUMBER_TABLE))
627: ) party_list
646: IS
647: SELECT /*+ leading(party_list) +*/
648: list.LIST_ENTRY_ID,sum_dtl.SCHEDULE_ID
649: FROM ams_tcop_channel_summary summary,
650: ams_list_entries list,
651: ams_tcop_channel_sum_dtl sum_dtl,
652: (SELECT column_value party_id
653: FROM TABLE(CAST(p_ftg_party_list as JTF_NUMBER_TABLE))
654: ) party_list
661: -- Get the List of parties not fatigued and will be contacted
662: CURSOR C_GET_CONTACTED_PARTY (p_list_header_id NUMBER,p_fatigue_party_list JTF_NUMBER_TABLE)
663: IS
664: (SELECT list_entry.PARTY_ID
665: FROM AMS_LIST_ENTRIES list_entry
666: WHERE list_entry.list_header_id = p_list_header_id
667: AND list_entry.ENABLED_FLAG = 'Y')
668: MINUS
669: (SELECT column_value
990: 'AFTER_API_CALL',
991: 'After Calling APPLY_PARTY_OPT_IN_PREFERENCES API'
992: );
993:
994: -- Once the fatigue list is produced, update the AMS_LIST_ENTRIES
995: -- , set the enabled_flag to N,MARKED_AS_FATIGUED_FLAG to Y, update the
996: -- counts in the List Header
997: --
998: IF (G_Fatigue_Entry_List.EXISTS(1)) THEN