506:
507: CURSOR C_GET_RULE_DTLS(p_schedule_id NUMBER)
508: IS
509: SELECT rule_id,rule_type
510: FROM ams_tcop_fr_rules_setup rule,
511: ams_campaign_schedules_b schedule,
512: ams_tcop_fr_periods_b period
513: WHERE rule.ENABLED_FLAG = 'Y'
514: AND (rule.CHANNEL_ID is null
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
531: FROM ams_tcop_fr_rules_setup
532: WHERE rule_id =p_rule_id);
533:
534: CURSOR c_Get_Global_Fatigue_list2(p_list_header_id number,
535: p_rule_id number,
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
546: FROM ams_tcop_fr_rules_setup
547: WHERE rule_id =p_rule_id)
548: AND list.party_id not in
549: (SELECT column_value
550: FROM TABLE(CAST(p_already_fatigued_list as JTF_NUMBER_TABLE))
562: AND summary.PARTY_ID = list.PARTY_ID
563: AND list.ENABLED_FLAG = 'Y'
564: AND summary.media_id = p_media_id
565: AND summary.total_contacts >= (SELECT max_contact_allowed
566: FROM ams_tcop_fr_rules_setup
567: WHERE rule_id =p_rule_id);
568:
569: -- Get the list of parties already over contacted by the channel specific rule
570: -- But don't consider the list of parties already fatigued by another rule
581: AND summary.PARTY_ID = list.PARTY_ID
582: AND list.ENABLED_FLAG = 'Y'
583: AND summary.media_id = p_media_id
584: AND summary.total_contacts >= (SELECT max_contact_allowed
585: FROM ams_tcop_fr_rules_setup
586: WHERE rule_id =p_rule_id)
587: AND list.party_id not in
588: (SELECT column_value
589: FROM TABLE(CAST(p_already_fatigued_list as JTF_NUMBER_TABLE))
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
604: FROM ams_tcop_fr_rules_setup
605: WHERE rule_id = p_rule_id)
606: AND summary.CONTACT_SUMMARY_ID = sum_dtl.CONTACT_SUMMARY_ID;
607: **/
608: