DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on FND_DATE

Line 725: l_serv_oblig_stdt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_start_date);

721: /* Check whether Service Obligation Information is entered for GHR_INCENTIVE Family or Not */
722: l_serv_oblig_code := p_per_service_oblig.service_oblig_type_code;
723: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_start_date,10);
724: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_end_date,10);
725: l_serv_oblig_stdt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_start_date);
726: l_serv_oblig_enddt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_end_date);
727:
728: IF (l_noa_family_code = 'GHR_INCENTIVE' OR
729: (p_pa_request_rec.first_noa_code = '002' AND p_pa_request_rec.second_noa_code IN ('815','816','827'))

Line 726: l_serv_oblig_enddt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_end_date);

722: l_serv_oblig_code := p_per_service_oblig.service_oblig_type_code;
723: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_start_date,10);
724: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_end_date,10);
725: l_serv_oblig_stdt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_start_date);
726: l_serv_oblig_enddt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_end_date);
727:
728: IF (l_noa_family_code = 'GHR_INCENTIVE' OR
729: (p_pa_request_rec.first_noa_code = '002' AND p_pa_request_rec.second_noa_code IN ('815','816','827'))
730: ) THEN

Line 1310: l_review_date := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(cur_repay_sch_rec.review_date));

1306:
1307: FOR cur_repay_sch_rec in cur_repay_sch
1308: LOOP
1309: l_repay_sch := cur_repay_sch_rec.repay_sch;
1310: l_review_date := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(cur_repay_sch_rec.review_date));
1311: END LOOP;
1312:
1313: IF ( p_pa_request_rec.award_amount > 10000 ) then
1314: hr_utility.set_message(8301,'GHR_38862_AMT_EXCEEDS_LIMIT');

Line 1423: l_mddds_specia_pay_nte_date := fnd_date.canonical_to_date(cur_mddds_pay_rec.nte_date);

1419:
1420: FOR cur_mddds_pay_rec in cur_mddds_pay
1421: LOOP
1422: l_mddds_special_pay_amount := cur_mddds_pay_rec.amount;
1423: l_mddds_specia_pay_nte_date := fnd_date.canonical_to_date(cur_mddds_pay_rec.nte_date);
1424: l_premium_pay_ind := cur_mddds_pay_rec.premium_pay_ind;
1425: END LOOP;
1426:
1427: IF l_premium_pay_ind IS NULL THEN