[Home] [Help]
626: hr_utility.set_location('Leaving: '||l_proc,10);
627: --
628: end pop_ben_per_cm_f;
629: --
630: procedure pop_ben_per_cm_trgr_f(p_per_cm_id in number,
631: p_cm_trgr_id in number,
632: p_business_group_id in number,
633: p_effective_date in date,
634: p_per_cm_trgr_id out nocopy number) is
632: p_business_group_id in number,
633: p_effective_date in date,
634: p_per_cm_trgr_id out nocopy number) is
635: --
636: l_proc varchar2(80) := g_package||'pop_ben_per_cm_trgr_f';
637: --
638: -- Output variables
639: --
640: l_object_version_number number;
642: l_effective_end_date date;
643: --
644: cursor c_per_cm_trgr is
645: select null
646: from ben_per_cm_trgr_f pcr
647: where pcr.cm_trgr_id = p_cm_trgr_id
648: and pcr.per_cm_id = p_per_cm_id
649: and pcr.business_group_id = p_business_group_id
650: and ben_generate_communications.g_comm_start_date
708: close c_per_cm_trgr;
709: --
710: hr_utility.set_location('Leaving: '||l_proc,10);
711: --
712: end pop_ben_per_cm_trgr_f;
713: --
714: procedure pop_ben_per_cm_prvdd_f(p_per_cm_id in number,
715: p_effective_date in date,
716: p_rqstd_flag in varchar2,
948: begin
949: --
950: hr_utility.set_location('Entering: '||l_proc,10);
951: --
952: pop_ben_per_cm_trgr_f
953: (p_per_cm_id => p_per_cm_id,
954: p_cm_trgr_id => p_cm_trgr_id,
955: p_business_group_id => p_business_group_id,
956: p_effective_date => p_effective_date,
4743: -- 4b. Populate ben_per_cm_f
4744: -- 4b. Populate ben_per_cm_prvdd_f
4745: -- 6. If whnvr_trgrd_flag = 'N' then join to cm_typ_usg_f
4746: -- 7. If rule exists or no rule and a usage exists
4747: -- 6a. Populate ben_per_cm_trgr_f
4748: -- 6b. Populate ben_per_cm_usg_f
4749: -- 6c. Populate ben_per_cm_f
4750: -- 6d. Populate ben_per_cm_prvdd_f
4751: -- 8. Go to 2.