[Home] [Help]
46: ,p_lf_evt_oper_cd in varchar2
47: ,p_name in varchar2)
48: return number is
49: l_proc varchar2(72) := g_package||'create_life_event';
50: l_start_of_time DATE:= pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
51: l_ler_id number;
52: l_effective_start_date date;
53: l_effective_end_date date;
54: l_object_version_number number;
76: ,p_copy_entity_txn_id in number
77: ,p_name in varchar2)
78: return number is
79: l_proc varchar2(72) := g_package||'create_plan_type';
80: l_start_of_time DATE:= pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
81: l_pl_typ_id number;
82: l_effective_start_date date;
83: l_effective_end_date date;
84: l_object_version_number number;
112: l_ler_id number;
113: l_ler_name varchar2(240);
114: l_pt_id number;
115: l_pt_name varchar2(240);
116: l_start_of_time DATE:= pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
117: l_effective_start_date date ;
118: l_le_pt_name varchar2(80) ;
119: l_prog_le_created_flag varchar2(1) :='N' ;
120: l_sync_le_created_flag varchar2(1) :='N' ;
828: l_grd_payrate_id := get_payrate(p_frequency => p_gl_frequency,
829: p_business_group_id => p_business_group_id);
830: if l_grd_payrate_id is null then
831: hr_utility.set_location('create grd payrate',20);
832: pqh_gsp_utility.create_pay_rate
833: (p_business_group_id => p_business_group_id,
834: p_ldr_period_code => p_gl_frequency,
835: p_rate_id => l_grd_payrate_id,
836: p_ovn => l_ovn);
856: l_scl_payrate_id := get_payrate(p_scale_id => i.information1,
857: p_business_group_id => p_business_group_id);
858: if l_scl_payrate_id is null then
859: hr_utility.set_location('create scl payrate',20);
860: pqh_gsp_utility.create_pay_rate
861: (p_business_group_id => p_business_group_id,
862: p_scale_id => i.information1,
863: p_rate_name => i.information98,
864: p_rate_id => l_scl_payrate_id,