DBA Data[Home] [Help]

APPS.PAY_FR_MAP_CALC dependencies on FND_DATE

Line 53: , fnd_date.date_to_canonical(g_map_arch.date_earned));

49: , g_map_arch.assignment_id);
50: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'
51: , g_map_arch.assignment_action_id);
52: pay_balance_pkg.set_context('DATE_EARNED'
53: , fnd_date.date_to_canonical(g_map_arch.date_earned));
54: pay_balance_pkg.set_context('BUSINESS_GROUP_ID'
55: , g_map_arch.business_group_id);
56: pay_balance_pkg.set_context('PAYROLL_ID'
57: , g_map_arch.payroll_id);

Line 72: l_inputs(i).value := fnd_date.date_to_canonical(g_map_calc.start_date);

68: hr_utility.set_location('Deduct',30);
69:
70: For i in 1..l_inputs.count Loop
71: IF l_inputs(i).name = 'DEDUCTION_START_DATE' THEN
72: l_inputs(i).value := fnd_date.date_to_canonical(g_map_calc.start_date);
73: ELSIF l_inputs(i).name = 'DEDUCTION_END_DATE' THEN
74: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_calc.end_date);
75: ELSIF l_inputs(i).name = 'ASG_ACTION_START_DATE' THEN
76: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_start_date);

Line 74: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_calc.end_date);

70: For i in 1..l_inputs.count Loop
71: IF l_inputs(i).name = 'DEDUCTION_START_DATE' THEN
72: l_inputs(i).value := fnd_date.date_to_canonical(g_map_calc.start_date);
73: ELSIF l_inputs(i).name = 'DEDUCTION_END_DATE' THEN
74: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_calc.end_date);
75: ELSIF l_inputs(i).name = 'ASG_ACTION_START_DATE' THEN
76: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_start_date);
77: ELSIF l_inputs(i).name = 'ASG_ACTION_END_DATE' THEN
78: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_end_date);

Line 76: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_start_date);

72: l_inputs(i).value := fnd_date.date_to_canonical(g_map_calc.start_date);
73: ELSIF l_inputs(i).name = 'DEDUCTION_END_DATE' THEN
74: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_calc.end_date);
75: ELSIF l_inputs(i).name = 'ASG_ACTION_START_DATE' THEN
76: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_start_date);
77: ELSIF l_inputs(i).name = 'ASG_ACTION_END_DATE' THEN
78: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_end_date);
79: ELSIF l_inputs(i).name = 'REFERENCE_SALARY' THEN
80: l_inputs(i).value:= g_map_arch.ded_ref_salary;

Line 78: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_end_date);

74: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_calc.end_date);
75: ELSIF l_inputs(i).name = 'ASG_ACTION_START_DATE' THEN
76: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_start_date);
77: ELSIF l_inputs(i).name = 'ASG_ACTION_END_DATE' THEN
78: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.action_end_date);
79: ELSIF l_inputs(i).name = 'REFERENCE_SALARY' THEN
80: l_inputs(i).value:= g_map_arch.ded_ref_salary;
81: ELSIF l_inputs(i).name = 'ASSIGNMENT_ID' THEN
82: l_inputs(i).value:= g_map_arch.assignment_id;

Line 84: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.date_earned);

80: l_inputs(i).value:= g_map_arch.ded_ref_salary;
81: ELSIF l_inputs(i).name = 'ASSIGNMENT_ID' THEN
82: l_inputs(i).value:= g_map_arch.assignment_id;
83: ELSIF l_inputs(i).name = 'DATE_EARNED' THEN
84: l_inputs(i).value:= fnd_date.date_to_canonical(g_map_arch.date_earned);
85: ELSIF l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' THEN
86: l_inputs(i).value:= g_map_arch.assignment_action_id;
87: ELSIF l_inputs(i).name = 'BUSINESS_GROUP_ID' THEN
88: l_inputs(i).value:= g_map_arch.business_group_id;

Line 325: hr_utility.set_location('IJSS'|| fnd_date.date_to_canonical(g_map_calc.ijss_gross_start_date),32);

321: if g_map_calc.IJSS_GROSS_END_DATE is not null and g_map_calc.IJSS_GROSS_START_DATE is not null then -- { ijss calc needed
322: g_map_calc.IJSS_GROSS_DAYS := (g_map_calc.IJSS_GROSS_END_DATE - g_map_calc.IJSS_GROSS_START_DATE) +1;
323:
324: hr_utility.set_location('IJSS'|| g_map_calc.ijss_gross_days,32);
325: hr_utility.set_location('IJSS'|| fnd_date.date_to_canonical(g_map_calc.ijss_gross_start_date),32);
326: hr_utility.set_location('IJSS'|| fnd_date.date_to_canonical(g_map_calc.ijss_gross_end_date),32);
327:
328: -- fetch reference salary
329: -- reference period is the 3 calendar months that preceed the start of the maternity

Line 326: hr_utility.set_location('IJSS'|| fnd_date.date_to_canonical(g_map_calc.ijss_gross_end_date),32);

322: g_map_calc.IJSS_GROSS_DAYS := (g_map_calc.IJSS_GROSS_END_DATE - g_map_calc.IJSS_GROSS_START_DATE) +1;
323:
324: hr_utility.set_location('IJSS'|| g_map_calc.ijss_gross_days,32);
325: hr_utility.set_location('IJSS'|| fnd_date.date_to_canonical(g_map_calc.ijss_gross_start_date),32);
326: hr_utility.set_location('IJSS'|| fnd_date.date_to_canonical(g_map_calc.ijss_gross_end_date),32);
327:
328: -- fetch reference salary
329: -- reference period is the 3 calendar months that preceed the start of the maternity
330: l_ref_date := least(g_map_calc.parent_absence_start_date, g_map_calc.birth_date);

Line 557: nvl(fnd_date.canonical_to_date (pabs.abs_information4),

553: where paa.absence_attendance_id = p_absence_attendance_id;
554:
555: cursor c_get_parent_maternity(p_parent_absence_id number) is
556: SELECT pabs.abs_information2 elig_gi,
557: nvl(fnd_date.canonical_to_date (pabs.abs_information4),
558: hr_general.end_of_time) birth_date,
559: fnd_number.canonical_to_number(pabs.abs_information6) births,
560: pabs.abs_information7 estmtd_ijss,
561: pabs.abs_information8 elig_ijss_hours,

Line 680: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date

676: g_map_calc.ESTIMATED_IJSS := abs_rec.abs_information7;
677: g_map_calc.GI_ELIGIBLE := abs_rec.abs_information3;
678: g_map_calc.births := nvl(fnd_number.canonical_to_number
679: (abs_rec.abs_information6),1);
680: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
681: (abs_rec.abs_information4), hr_general.end_of_time) ;
682: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information8;
683: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
684: (abs_rec.abs_information9) ;

Line 723: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date

719: g_map_calc.ESTIMATED_IJSS := abs_rec.abs_information7;
720: g_map_calc.GI_ELIGIBLE := abs_rec.abs_information3;
721: g_map_calc.births := nvl(fnd_number.canonical_to_number
722: (abs_rec.abs_information6),1);
723: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
724: (abs_rec.abs_information4),hr_general.end_of_time);
725: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information8;
726: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
727: (abs_rec.abs_information9) ;

Line 743: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date

739: g_map_calc.ESTIMATED_IJSS := abs_rec.abs_information4;
740: g_map_calc.GI_ELIGIBLE := abs_rec.abs_information2;
741: g_map_calc.births := nvl(fnd_number.canonical_to_number
742: (abs_rec.abs_information3),1);
743: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
744: (abs_rec.abs_information1), hr_general.end_of_time) ;
745: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information5;
746: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
747: (abs_rec.abs_information6) ;

Line 764: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date

760: g_map_calc.ESTIMATED_IJSS := abs_rec.abs_information4;
761: g_map_calc.GI_ELIGIBLE := abs_rec.abs_information2;
762: g_map_calc.births := nvl(fnd_number.canonical_to_number
763: (abs_rec.abs_information3),1);
764: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
765: (abs_rec.abs_information1), hr_general.end_of_time) ;
766: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information5;
767: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
768: (abs_rec.abs_information6) ;