[Home] [Help]
902:
903: --validate that if the total contribution percentage has been entered
904: -- then it should be atleast equal to the employee contribution percentage
905: IF p_org_information5 IS NOT NULL THEN
906: IF fnd_number.canonical_to_number(nvl(p_org_information5,'0'))
907: < fnd_number.canonical_to_number(nvl(p_org_information4,'0')) THEN
908: hr_utility.set_message(8303,'PQP_230215_PGGM_INV_CONTRIB');
909: hr_utility.raise_error;
910: END IF;
903: --validate that if the total contribution percentage has been entered
904: -- then it should be atleast equal to the employee contribution percentage
905: IF p_org_information5 IS NOT NULL THEN
906: IF fnd_number.canonical_to_number(nvl(p_org_information5,'0'))
907: < fnd_number.canonical_to_number(nvl(p_org_information4,'0')) THEN
908: hr_utility.set_message(8303,'PQP_230215_PGGM_INV_CONTRIB');
909: hr_utility.raise_error;
910: END IF;
911: END IF;
1421: LOOP
1422: hr_utility.set_location('calling get part org',50);
1423: get_participation_org(p_assignment_id => csr_row.assignment_id
1424: ,p_date_earned => csr_row.date_earned
1425: ,p_pension_type_id => fnd_number.canonical_to_number(p_org_information3_o)
1426: ,p_asg_or_org => l_asg_or_org
1427: ,p_org_id => l_org_id
1428: );
1429: IF l_asg_or_org = 1 AND l_org_id = p_organization_id THEN
1620:
1621: --validate that if the total contribution percentage has been entered
1622: -- then it should be atleast equal to the employee contribution percentage
1623: IF p_org_information5 IS NOT NULL THEN
1624: IF fnd_number.canonical_to_number(nvl(p_org_information5,'0'))
1625: < fnd_number.canonical_to_number(nvl(p_org_information4,'0')) THEN
1626: hr_utility.set_message(8303,'PQP_230215_PGGM_INV_CONTRIB');
1627: hr_utility.raise_error;
1628: END IF;
1621: --validate that if the total contribution percentage has been entered
1622: -- then it should be atleast equal to the employee contribution percentage
1623: IF p_org_information5 IS NOT NULL THEN
1624: IF fnd_number.canonical_to_number(nvl(p_org_information5,'0'))
1625: < fnd_number.canonical_to_number(nvl(p_org_information4,'0')) THEN
1626: hr_utility.set_message(8303,'PQP_230215_PGGM_INV_CONTRIB');
1627: hr_utility.raise_error;
1628: END IF;
1629: END IF;
2186: END LOOP;
2187:
2188: -- if the contribution method is PE the value should be between 0 and 999.999
2189: IF nvl(p_aei_information13,'PE') = 'PE' THEN
2190: IF fnd_number.canonical_to_number(nvl(p_aei_information14,'0')) > 999.999 THEN
2191: hr_utility.set_message(8303,'PQP_230052_INV_PERCENT_VALUE');
2192: hr_utility.raise_error;
2193: END IF;
2194: END IF;
2194: END IF;
2195:
2196: -- if the contribution method is PE the value should be between 0 and 999.999
2197: IF nvl(p_aei_information15,'PE') = 'PE' THEN
2198: IF fnd_number.canonical_to_number(nvl(p_aei_information16,'0')) > 999.999 THEN
2199: hr_utility.set_message(8303,'PQP_230052_INV_PERCENT_VALUE');
2200: hr_utility.raise_error;
2201: END IF;
2202: END IF;
2301: --
2302: l_ret_val := get_reporting_date
2303: (p_effective_date => fnd_date.canonical_to_date(to_char(TRUNC(
2304: fnd_date.canonical_to_date(p_aei_information1)),'YYYY/MM')||'/01')
2305: ,p_assignment_id => fnd_number.canonical_to_number(p_assignment_id)
2306: ,p_person_id => l_person_id
2307: ,p_reporting_date => l_abp_rep_date );
2308:
2309: IF p_aei_information22 IS NOT NULL THEN
2537: --
2538: l_ret_val := get_reporting_date
2539: (p_effective_date => fnd_date.canonical_to_date(to_char(TRUNC(
2540: fnd_date.canonical_to_date(p_aei_information1)),'YYYY/MM')||'/01')
2541: ,p_assignment_id => fnd_number.canonical_to_number(p_assignment_id)
2542: ,p_person_id => l_person_id
2543: ,p_reporting_date => l_abp_rep_date );
2544:
2545: --call the procedure to insert rows into the ben_ext_chg_evt_log table
2596: FETCH cur_periods_per_yr INTO l_periods_per_yr;
2597: IF cur_periods_per_yr%FOUND THEN
2598: CLOSE cur_periods_per_yr;
2599: hr_utility.set_location('found period number'||l_periods_per_yr,30);
2600: IF fnd_number.canonical_to_number(p_aei_information2) > l_periods_per_yr THEN
2601: hr_utility.set_message(8303,'PQP_230142_INV_PERIOD_NUMBER');
2602: hr_utility.raise_error;
2603: END IF;
2604: ELSE
2605: CLOSE cur_periods_per_yr;
2606: END IF;
2607:
2608: --validate that the amount entered is > 0
2609: IF fnd_number.canonical_to_number(p_aei_information3) <= 0 THEN
2610: hr_utility.set_message(8303,'PQP_230149_INV_ADDNL_AMT');
2611: hr_utility.raise_error;
2612: END IF;
2613:
3209: END LOOP;
3210:
3211: -- if the contribution method is PE the value should be between 0 and 999.999
3212: IF nvl(p_aei_information13,'PE') = 'PE' THEN
3213: IF fnd_number.canonical_to_number(nvl(p_aei_information14,'0')) > 999.999 THEN
3214: hr_utility.set_message(8303,'PQP_230052_INV_PERCENT_VALUE');
3215: hr_utility.raise_error;
3216: END IF;
3217: END IF;
3217: END IF;
3218:
3219: -- if the contribution method is PE the value should be between 0 and 999.999
3220: IF nvl(p_aei_information15,'PE') = 'PE' THEN
3221: IF fnd_number.canonical_to_number(nvl(p_aei_information16,'0')) > 999.999 THEN
3222: hr_utility.set_message(8303,'PQP_230052_INV_PERCENT_VALUE');
3223: hr_utility.raise_error;
3224: END IF;
3225: END IF;
3366: --
3367: l_ret_val := get_reporting_date
3368: (p_effective_date => fnd_date.canonical_to_date(to_char(TRUNC(
3369: fnd_date.canonical_to_date(p_aei_information1)),'YYYY/MM')||'/01')
3370: ,p_assignment_id => fnd_number.canonical_to_number(p_assignment_id)
3371: ,p_person_id => l_person_id
3372: ,p_reporting_date => l_abp_rep_date );
3373:
3374: IF p_aei_information22 IS NOT NULL THEN
3637: --
3638: l_ret_val := get_reporting_date
3639: (p_effective_date => fnd_date.canonical_to_date(to_char(TRUNC(
3640: fnd_date.canonical_to_date(p_aei_information1)),'YYYY/MM')||'/01')
3641: ,p_assignment_id => fnd_number.canonical_to_number(p_assignment_id)
3642: ,p_person_id => l_person_id
3643: ,p_reporting_date => l_abp_rep_date );
3644:
3645: --Call the procedure to insert the rows in the ben_ext_chg_evt_log table
3703: OPEN cur_periods_per_yr(c_eff_date => l_eff_date);
3704: FETCH cur_periods_per_yr INTO l_periods_per_yr;
3705: IF cur_periods_per_yr%FOUND THEN
3706: CLOSE cur_periods_per_yr;
3707: IF fnd_number.canonical_to_number(p_aei_information2) > l_periods_per_yr THEN
3708: hr_utility.set_message(8303,'PQP_230142_INV_PERIOD_NUMBER');
3709: hr_utility.raise_error;
3710: END IF;
3711: ELSE
3712: CLOSE cur_periods_per_yr;
3713: END IF;
3714:
3715: --validate that the amount entered is > 0
3716: IF fnd_number.canonical_to_number(p_aei_information3) <= 0 THEN
3717: hr_utility.set_message(8303,'PQP_230149_INV_ADDNL_AMT');
3718: hr_utility.raise_error;
3719: END IF;
3720:
3872: ,c_ed_dt IN DATE ) IS
3873: --
3874: -- Rows that start in the current period
3875: --
3876: SELECT fnd_number.canonical_to_number(nvl(aei_information5,'1')) VOP
3877: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3878: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3879: FROM per_assignment_extra_info
3880: WHERE assignment_id = p_assignment_id
3885: UNION
3886: --
3887: -- Rows that end in the current period
3888: --
3889: SELECT fnd_number.canonical_to_number(nvl(aei_information5,'1')) VOP
3890: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3891: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3892: FROM per_assignment_extra_info
3893: WHERE assignment_id = p_assignment_id
3899: --
3900: -- Rows that neither start or end in the current period
3901: -- but the data in the EIT is valid for the current period
3902: --
3903: SELECT fnd_number.canonical_to_number(nvl(aei_information5,'1')) VOP
3904: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3905: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3906: FROM per_assignment_extra_info
3907: WHERE assignment_id = p_assignment_id
3916: ,c_ed_dt IN DATE ) IS
3917: --
3918: -- Rows that start in the current period
3919: --
3920: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3921: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3922: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3923: FROM per_assignment_extra_info aei,
3924: pqp_pension_types_f pty
3923: FROM per_assignment_extra_info aei,
3924: pqp_pension_types_f pty
3925: WHERE assignment_id = p_assignment_id
3926: AND aei_information3 = p_pension_type_id
3927: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)
3928: AND pension_sub_category IN ('PPP' ,'OPNP' ,'OPNP_65'
3929: ,'OPNP_AOW' ,'OPNP_W25','OPNP_W50', 'AAOP'
3930: ,'FPU_B', 'FPU_C', 'FPU_E', 'FPU_R', 'FPU_S', 'FPU_T')
3931: AND c_ed_dt BETWEEN pty.effective_start_date AND NVL(pty.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))
3937: UNION
3938: --
3939: -- Rows that end in the current period
3940: --
3941: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3942: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3943: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3944: FROM per_assignment_extra_info aei,
3945: pqp_pension_types_f pty
3944: FROM per_assignment_extra_info aei,
3945: pqp_pension_types_f pty
3946: WHERE assignment_id = p_assignment_id
3947: AND aei_information3 = p_pension_type_id
3948: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)
3949: AND pension_sub_category in ('PPP' ,'OPNP' ,'OPNP_65'
3950: ,'OPNP_AOW' ,'OPNP_W25','OPNP_W50', 'AAOP'
3951: ,'FPU_B', 'FPU_C', 'FPU_E', 'FPU_R', 'FPU_S', 'FPU_T')
3952: AND c_ed_dt BETWEEN pty.effective_start_date AND NVL(pty.effective_end_date ,to_date('31/12/4712','DD/MM/YYYY'))
3959: --
3960: -- Rows that neither start or end in the current period
3961: -- but the data in the EIT is valid for the current period
3962: --
3963: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3964: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3965: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3966: FROM per_assignment_extra_info aei,
3967: pqp_pension_types_f pty
3966: FROM per_assignment_extra_info aei,
3967: pqp_pension_types_f pty
3968: WHERE assignment_id = p_assignment_id
3969: AND aei_information3 = p_pension_type_id
3970: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)
3971: AND pension_sub_category in ('PPP' ,'OPNP' ,'OPNP_65'
3972: ,'OPNP_AOW' ,'OPNP_W25','OPNP_W50', 'AAOP'
3973: ,'FPU_B', 'FPU_C', 'FPU_E', 'FPU_R', 'FPU_S', 'FPU_T')
3974: AND c_ed_dt BETWEEN pty.effective_start_date and NVL(pty.effective_end_date ,to_date('31/12/4712','DD/MM/YYYY'))
4090:
4091: IF l_vop_num_or IS NOT NULL THEN
4092:
4093: l_vop_num_or := TRUNC(l_vop_num_or/l_days_in_pp,4);
4094: p_vop := fnd_number.number_to_canonical(l_vop_num_or);
4095: RETURN 0;
4096:
4097: ELSIF l_vop_num IS NOT NULL THEN
4098:
4096:
4097: ELSIF l_vop_num IS NOT NULL THEN
4098:
4099: l_vop_num := TRUNC(l_vop_num/l_days_in_pp,4);
4100: p_vop := fnd_number.number_to_canonical(l_vop_num);
4101: RETURN 0;
4102:
4103: ELSIF l_vop_num IS NULL AND l_vop_num_or IS NULL THEN
4104:
4479: l_return_value := NVL(l_return_value,trim(to_char(0,'9')));
4480:
4481: hr_utility.set_location(' l_return_value is '||l_return_value,50);
4482:
4483: p_column_value := fnd_number.canonical_to_number(l_return_value);
4484:
4485: hr_utility.set_location(' p_column_value is '||p_column_value,60);
4486:
4487: END IF;-- subcat check
4645: -- at the assignment level.
4646: --
4647: CURSOR c_get_contribution
4648: (c_org_id IN hr_organization_information.organization_id%TYPE) IS
4649: SELECT fnd_number.canonical_to_number(NVL(hoi.org_information4,'-1'))
4650: ,fnd_number.canonical_to_number(NVL(hoi.org_information5,'-1'))
4651: FROM hr_organization_information hoi
4652: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4653: AND hoi.org_information3 = TO_CHAR(p_pension_type_id)
4646: --
4647: CURSOR c_get_contribution
4648: (c_org_id IN hr_organization_information.organization_id%TYPE) IS
4649: SELECT fnd_number.canonical_to_number(NVL(hoi.org_information4,'-1'))
4650: ,fnd_number.canonical_to_number(NVL(hoi.org_information5,'-1'))
4651: FROM hr_organization_information hoi
4652: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4653: AND hoi.org_information3 = TO_CHAR(p_pension_type_id)
4654: AND hoi.org_information6 = 'Y'
4662: --
4663: CURSOR c_find_org IS
4664: SELECT asg.organization_id
4665: ,asg.payroll_id
4666: ,fnd_number.canonical_to_number(ppf.prl_information1)
4667: FROM per_all_assignments_f asg,
4668: pay_payrolls_f ppf
4669: WHERE asg.assignment_id = p_assignment_id
4670: AND asg.payroll_id = ppf.payroll_id
4677: --
4678: -- Cursor to fetch contribution values from the Pension Type
4679: --
4680: CURSOR c_pt_val IS
4681: SELECT fnd_number.canonical_to_number(nvl(ee_contribution_percent,'0'))
4682: ,fnd_number.canonical_to_number(nvl(er_contribution_percent,'0'))
4683: FROM pqp_pension_types_f
4684: WHERE pension_type_id = p_pension_type_id
4685: AND p_date_earned BETWEEN effective_start_date
4678: -- Cursor to fetch contribution values from the Pension Type
4679: --
4680: CURSOR c_pt_val IS
4681: SELECT fnd_number.canonical_to_number(nvl(ee_contribution_percent,'0'))
4682: ,fnd_number.canonical_to_number(nvl(er_contribution_percent,'0'))
4683: FROM pqp_pension_types_f
4684: WHERE pension_type_id = p_pension_type_id
4685: AND p_date_earned BETWEEN effective_start_date
4686: AND effective_end_date;
4813: -- for a particular ABP Sub Cat/BG combination. If the scheme is created,
4814: -- it returns the valid pension type id for the scheme
4815: --
4816: CURSOR c_abp_schm IS
4817: SELECT fnd_number.canonical_to_number(eei_information2) pty_id
4818: FROM pay_element_type_extra_info pete,
4819: pay_element_types_f pet
4820: WHERE pete.information_type = 'PQP_NL_ABP_DEDUCTION'
4821: AND pete.element_type_id = pet.element_type_id
4937: --
4938: CURSOR c_get_asg_info (c_pty_id IN NUMBER
4939: ,c_date_earned IN DATE) IS
4940: SELECT NVL(paei.aei_information13,'PE'),
4941: fnd_number.canonical_to_number(NVL(paei.aei_information14,'-1'))
4942: ,NVL(paei.aei_information15,'PE'),
4943: fnd_number.canonical_to_number(NVL(paei.aei_information16,'-1'))
4944: FROM per_assignment_extra_info paei
4945: WHERE paei.information_type = 'NL_ABP_PI'
4939: ,c_date_earned IN DATE) IS
4940: SELECT NVL(paei.aei_information13,'PE'),
4941: fnd_number.canonical_to_number(NVL(paei.aei_information14,'-1'))
4942: ,NVL(paei.aei_information15,'PE'),
4943: fnd_number.canonical_to_number(NVL(paei.aei_information16,'-1'))
4944: FROM per_assignment_extra_info paei
4945: WHERE paei.information_type = 'NL_ABP_PI'
4946: AND paei.aei_information_category = 'NL_ABP_PI'
4947: AND paei.assignment_id = p_assignment_id
4944: FROM per_assignment_extra_info paei
4945: WHERE paei.information_type = 'NL_ABP_PI'
4946: AND paei.aei_information_category = 'NL_ABP_PI'
4947: AND paei.assignment_id = p_assignment_id
4948: AND fnd_number.canonical_to_number(NVL(aei_information3,-1)) = c_pty_id
4949: AND c_date_earned between fnd_date.canonical_to_date(paei.aei_information1)
4950: AND fnd_date.canonical_to_date(NVL(paei.aei_information2,
4951: fnd_date.date_to_canonical(hr_api.g_eot)));
4952:
4958: CURSOR c_get_contribution
4959: (c_org_id IN hr_organization_information.organization_id%TYPE
4960: ,c_pt_id IN NUMBER
4961: ,c_date_earned IN DATE) IS
4962: SELECT fnd_number.canonical_to_number(NVL(hoi.org_information4,'-1'))
4963: ,fnd_number.canonical_to_number(NVL(hoi.org_information5,'-1'))
4964: FROM hr_organization_information hoi
4965: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4966: AND hoi.org_information3 = TO_CHAR(c_pt_id)
4959: (c_org_id IN hr_organization_information.organization_id%TYPE
4960: ,c_pt_id IN NUMBER
4961: ,c_date_earned IN DATE) IS
4962: SELECT fnd_number.canonical_to_number(NVL(hoi.org_information4,'-1'))
4963: ,fnd_number.canonical_to_number(NVL(hoi.org_information5,'-1'))
4964: FROM hr_organization_information hoi
4965: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4966: AND hoi.org_information3 = TO_CHAR(c_pt_id)
4967: AND hoi.org_information6 = 'Y'
4984:
4985: CURSOR c_find_org (c_date_earned IN DATE)IS
4986: SELECT asg.organization_id
4987: ,asg.payroll_id
4988: ,fnd_number.canonical_to_number(ppf.prl_information1)
4989: FROM per_all_assignments_f asg,
4990: pay_payrolls_f ppf
4991: WHERE asg.assignment_id = p_assignment_id
4992: AND asg.payroll_id = ppf.payroll_id
4997: AND asg.business_group_id = p_business_group_id;
4998:
4999: CURSOR c_cur_ptp (c_eff_dt IN DATE
5000: ,c_asg_id IN NUMBER) IS
5001: SELECT LEAST(fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')),125) ptp
5002: FROM per_assignments_f asg
5003: ,hr_soft_coding_keyflex target
5004: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
5005: AND asg.assignment_id = c_asg_id
6063: CURSOR c_get_abs_ele_entry(c_effective_date in date
6064: ,c_element_type_id in number
6065: ,c_input_value_id in number
6066: ,c_period_end_date IN DATE ) IS
6067: SELECT fnd_number.canonical_to_number(nvl(screen_entry_value,'0')) perc_value
6068: ,pee.effective_start_date start_date
6069: ,pee.effective_end_date end_date
6070: FROM pay_element_entry_values_f pef,
6071: pay_element_entries_f pee
6526: --found a value for the percentage at this org level
6527: --return from this point
6528: CLOSE c_find_eoy_percent;
6529: hr_utility.set_location('Leaving get_eoy_bonus_percentage',35);
6530: p_eoy_bonus_percentage := fnd_number.canonical_to_number(l_eoy_percent);
6531: RETURN 0;
6532: ELSE
6533: --no value found at this org level,try to traverse up the
6534: --org hierarchy to find a value at the parent levels
6588: FETCH c_find_eoy_percent INTO l_eoy_percent;
6589: IF c_find_eoy_percent%FOUND THEN
6590: hr_utility.set_location('found eoy percent as : '||l_eoy_percent,80);
6591: CLOSE c_find_eoy_percent;
6592: p_eoy_bonus_percentage := fnd_number.canonical_to_number(l_eoy_percent);
6593: l_ret_val := 0;
6594: l_loop_again := 0;
6595: ELSE
6596: CLOSE c_find_eoy_percent;
6665: --
6666: -- Cursor to get the part time perc from the SC KFF
6667: --
6668: CURSOR c_ptp (c_kff_id IN NUMBER) IS
6669: SELECT fnd_number.canonical_to_number(segment29)
6670: FROM hr_soft_coding_keyflex
6671: WHERE soft_coding_keyflex_id = c_kff_id;
6672:
6673: CURSOR c_log_xst( c_kff_id IN NUMBER
6741: -- Get the reporting date
6742: --
6743: l_ret_val := get_reporting_date
6744: (p_effective_date => fnd_date.canonical_to_date(to_char(TRUNC(p_chg_eff_dt),'YYYY/MM')||'/01')
6745: ,p_assignment_id => fnd_number.canonical_to_number(p_prmtr_01)
6746: ,p_person_id => p_person_id
6747: ,p_reporting_date => l_out_rep_dt );
6748:
6749: l_reporting_dt := fnd_date.date_to_canonical(l_out_rep_dt);
6816: -- does not nencessarily mean that there has been a change
6817: -- in part time percentage. It can be because of other changes that
6818: -- have happened to the SC KFF segments.
6819:
6820: OPEN c_ptp(fnd_number.canonical_to_number(p_old_val1));
6821: FETCH c_ptp INTO l_old_ptp;
6822: CLOSE c_ptp;
6823:
6824: OPEN c_ptp(fnd_number.canonical_to_number(p_new_val1));
6820: OPEN c_ptp(fnd_number.canonical_to_number(p_old_val1));
6821: FETCH c_ptp INTO l_old_ptp;
6822: CLOSE c_ptp;
6823:
6824: OPEN c_ptp(fnd_number.canonical_to_number(p_new_val1));
6825: FETCH c_ptp INTO l_new_ptp;
6826: CLOSE c_ptp;
6827:
6828: IF NVL(l_old_ptp,100) <> NVL(l_new_ptp,100) THEN
6834: -- ptp and the surrogate key that replaced it.
6835: --
6836:
6837: OPEN c_log_xst(
6838: c_kff_id => fnd_number.number_to_canonical(p_old_val1)
6839: ,c_st_dt => l_asg_st_dt
6840: ,c_ed_dt => l_asg_ed_dt
6841: ,c_rep_dt => l_reporting_dt
6842: ,c_asg_id => p_prmtr_01);
6847: -- Update the existing log with the changed part time percentages
6848: --
6849: hr_utility.set_location('GAA -- An existing row is found in the logs: ',10 );
6850: UPDATE ben_ext_chg_evt_log
6851: SET new_val1 = fnd_number.number_to_canonical(l_new_ptp)
6852: ,old_val1 = fnd_number.number_to_canonical(l_old_ptp)
6853: ,prmtr_09 = l_reporting_dt
6854: WHERE ext_chg_evt_log_id = l_xst_log_rec.ext_chg_evt_log_id;
6855:
6848: --
6849: hr_utility.set_location('GAA -- An existing row is found in the logs: ',10 );
6850: UPDATE ben_ext_chg_evt_log
6851: SET new_val1 = fnd_number.number_to_canonical(l_new_ptp)
6852: ,old_val1 = fnd_number.number_to_canonical(l_old_ptp)
6853: ,prmtr_09 = l_reporting_dt
6854: WHERE ext_chg_evt_log_id = l_xst_log_rec.ext_chg_evt_log_id;
6855:
6856: ELSIF c_log_xst%NOTFOUND THEN
6878: ,p_business_group_id => p_business_group_id
6879: ,p_object_version_number => l_ovn
6880: ,p_effective_date => TRUNC(p_effective_date)
6881: ,p_chg_actl_dt => p_chg_actl_dt
6882: ,p_new_val1 => fnd_number.number_to_canonical(l_new_ptp)
6883: ,p_new_val2 => NULL
6884: ,p_new_val3 => NULL
6885: ,p_new_val4 => NULL
6886: ,p_new_val5 => NULL
6884: ,p_new_val3 => NULL
6885: ,p_new_val4 => NULL
6886: ,p_new_val5 => NULL
6887: ,p_new_val6 => NULL
6888: ,p_old_val1 => fnd_number.number_to_canonical(l_old_ptp)
6889: ,p_old_val2 => NULL
6890: ,p_old_val3 => NULL
6891: ,p_old_val4 => NULL
6892: ,p_old_val5 => NULL
6924: ,p_business_group_id => p_business_group_id
6925: ,p_object_version_number => l_ovn1
6926: ,p_effective_date => TRUNC(p_effective_date)
6927: ,p_chg_actl_dt => p_chg_actl_dt
6928: ,p_new_val1 => fnd_number.number_to_canonical(l_new_ptp)
6929: ,p_new_val2 => NULL
6930: ,p_new_val3 => NULL
6931: ,p_new_val4 => NULL
6932: ,p_new_val5 => NULL
6930: ,p_new_val3 => NULL
6931: ,p_new_val4 => NULL
6932: ,p_new_val5 => NULL
6933: ,p_new_val6 => NULL
6934: ,p_old_val1 => fnd_number.number_to_canonical(l_old_ptp)
6935: ,p_old_val2 => NULL
6936: ,p_old_val3 => NULL
6937: ,p_old_val4 => NULL
6938: ,p_old_val5 => NULL
7097: ELSIF p_chg_evt_cd = 'COAPP' THEN
7098:
7099: update per_assignment_extra_info
7100: set aei_information22 = NULL
7101: where assignment_extra_info_id = fnd_number.canonical_to_number(p_prmtr_03);
7102:
7103: END IF; -- If the change event code is COSCKFF
7104:
7105:
7133: -- a declerant (hourly EE)
7134: --
7135: CURSOR c_cur_ptp (c_eff_dt IN DATE
7136: ,c_asg_id IN NUMBER) IS
7137: SELECT LEAST(fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')),125) ptp
7138: FROM per_assignments_f asg
7139: ,hr_soft_coding_keyflex target
7140: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
7141: AND asg.assignment_id = c_asg_id
7401: csr_iv.iv_id,
7402: l_time_span_id)
7403: LOOP
7404:
7405: l_addn_ded_basis := nvl(fnd_number.canonical_to_number(csr_basis.basis),0);
7406: l_already_retro_paid := nvl(fnd_number.canonical_to_number(csr_basis.paid),0);
7407:
7408: hr_utility.set_location ('l_addn_ded_basis: ' || l_addn_ded_basis, 2260);
7409: hr_utility.set_location ('l_already_retro_paid: ' || l_already_retro_paid, 2270);
7402: l_time_span_id)
7403: LOOP
7404:
7405: l_addn_ded_basis := nvl(fnd_number.canonical_to_number(csr_basis.basis),0);
7406: l_already_retro_paid := nvl(fnd_number.canonical_to_number(csr_basis.paid),0);
7407:
7408: hr_utility.set_location ('l_addn_ded_basis: ' || l_addn_ded_basis, 2260);
7409: hr_utility.set_location ('l_already_retro_paid: ' || l_already_retro_paid, 2270);
7410: