APPS.PAY_ZA_COIDA_ARCHIVE dependencies on FND_DATE

Line 119: select fnd_date.canonical_to_date(pai.action_information4) start_date

115: procedure set_globals(p_payroll_action_id number)
116: is
117: cursor csr_coida_payroll_info
118: is
119: select fnd_date.canonical_to_date(pai.action_information4) start_date
120: , fnd_date.canonical_to_date(pai.action_information5) end_date
121: , pai.action_information8 limit1
122: , pai.action_information9 limit2
123: , fnd_date.canonical_to_date(pai.action_information11) split_start_date1

Line 120: , fnd_date.canonical_to_date(pai.action_information5) end_date

116: is
117: cursor csr_coida_payroll_info
118: is
119: select fnd_date.canonical_to_date(pai.action_information4) start_date
120: , fnd_date.canonical_to_date(pai.action_information5) end_date
121: , pai.action_information8 limit1
122: , pai.action_information9 limit2
123: , fnd_date.canonical_to_date(pai.action_information11) split_start_date1
124: , fnd_date.canonical_to_date(pai.action_information12) split_end_date1

Line 123: , fnd_date.canonical_to_date(pai.action_information11) split_start_date1

119: select fnd_date.canonical_to_date(pai.action_information4) start_date
120: , fnd_date.canonical_to_date(pai.action_information5) end_date
121: , pai.action_information8 limit1
122: , pai.action_information9 limit2
123: , fnd_date.canonical_to_date(pai.action_information11) split_start_date1
124: , fnd_date.canonical_to_date(pai.action_information12) split_end_date1
125: , fnd_date.canonical_to_date(pai.action_information13) split_start_date2
126: , fnd_date.canonical_to_date(pai.action_information14) split_end_date2
127: , pai.action_information7 num_of_days

Line 124: , fnd_date.canonical_to_date(pai.action_information12) split_end_date1

120: , fnd_date.canonical_to_date(pai.action_information5) end_date
121: , pai.action_information8 limit1
122: , pai.action_information9 limit2
123: , fnd_date.canonical_to_date(pai.action_information11) split_start_date1
124: , fnd_date.canonical_to_date(pai.action_information12) split_end_date1
125: , fnd_date.canonical_to_date(pai.action_information13) split_start_date2
126: , fnd_date.canonical_to_date(pai.action_information14) split_end_date2
127: , pai.action_information7 num_of_days
128: from pay_action_information pai

Line 125: , fnd_date.canonical_to_date(pai.action_information13) split_start_date2

121: , pai.action_information8 limit1
122: , pai.action_information9 limit2
123: , fnd_date.canonical_to_date(pai.action_information11) split_start_date1
124: , fnd_date.canonical_to_date(pai.action_information12) split_end_date1
125: , fnd_date.canonical_to_date(pai.action_information13) split_start_date2
126: , fnd_date.canonical_to_date(pai.action_information14) split_end_date2
127: , pai.action_information7 num_of_days
128: from pay_action_information pai
129: where action_context_id = p_payroll_action_id

Line 126: , fnd_date.canonical_to_date(pai.action_information14) split_end_date2

122: , pai.action_information9 limit2
123: , fnd_date.canonical_to_date(pai.action_information11) split_start_date1
124: , fnd_date.canonical_to_date(pai.action_information12) split_end_date1
125: , fnd_date.canonical_to_date(pai.action_information13) split_start_date2
126: , fnd_date.canonical_to_date(pai.action_information14) split_end_date2
127: , pai.action_information7 num_of_days
128: from pay_action_information pai
129: where action_context_id = p_payroll_action_id
130: and action_information_category = 'ZA_COID_PAYROLL_INFO';

Line 336: p_action_information4 => fnd_date.date_to_canonical(g_start_period_date),

332: p_action_information_category => 'ZA_COID_PAYROLL_INFO',
333: p_action_information1 => l_payroll_name,
334: p_action_information2 => l_payroll_id,
335: p_action_information3 => l_org_name,
336: p_action_information4 => fnd_date.date_to_canonical(g_start_period_date),
337: p_action_information5 => fnd_date.date_to_canonical(g_end_period_date),
338: p_action_information6 => l_pay_period_display,
339: p_action_information7 => g_num_of_days,
340: p_action_information8 => g_coida_limit1,

Line 337: p_action_information5 => fnd_date.date_to_canonical(g_end_period_date),

333: p_action_information1 => l_payroll_name,
334: p_action_information2 => l_payroll_id,
335: p_action_information3 => l_org_name,
336: p_action_information4 => fnd_date.date_to_canonical(g_start_period_date),
337: p_action_information5 => fnd_date.date_to_canonical(g_end_period_date),
338: p_action_information6 => l_pay_period_display,
339: p_action_information7 => g_num_of_days,
340: p_action_information8 => g_coida_limit1,
341: p_action_information9 => g_coida_limit2,

Line 343: p_action_information11 => fnd_date.date_to_canonical(g_coida_start1),

339: p_action_information7 => g_num_of_days,
340: p_action_information8 => g_coida_limit1,
341: p_action_information9 => g_coida_limit2,
342: p_action_information10 => l_coida_limit_display,
343: p_action_information11 => fnd_date.date_to_canonical(g_coida_start1),
344: p_action_information12 => fnd_date.date_to_canonical(g_coida_end1),
345: p_action_information13 => fnd_date.date_to_canonical(g_coida_start2),
346: p_action_information14 => fnd_date.date_to_canonical(g_coida_end2),
347: p_action_information15 => l_split1,

Line 344: p_action_information12 => fnd_date.date_to_canonical(g_coida_end1),

340: p_action_information8 => g_coida_limit1,
341: p_action_information9 => g_coida_limit2,
342: p_action_information10 => l_coida_limit_display,
343: p_action_information11 => fnd_date.date_to_canonical(g_coida_start1),
344: p_action_information12 => fnd_date.date_to_canonical(g_coida_end1),
345: p_action_information13 => fnd_date.date_to_canonical(g_coida_start2),
346: p_action_information14 => fnd_date.date_to_canonical(g_coida_end2),
347: p_action_information15 => l_split1,
348: p_action_information16 => l_split2,

Line 345: p_action_information13 => fnd_date.date_to_canonical(g_coida_start2),

341: p_action_information9 => g_coida_limit2,
342: p_action_information10 => l_coida_limit_display,
343: p_action_information11 => fnd_date.date_to_canonical(g_coida_start1),
344: p_action_information12 => fnd_date.date_to_canonical(g_coida_end1),
345: p_action_information13 => fnd_date.date_to_canonical(g_coida_start2),
346: p_action_information14 => fnd_date.date_to_canonical(g_coida_end2),
347: p_action_information15 => l_split1,
348: p_action_information16 => l_split2,
349: p_action_information17 => l_num_of_months1,

Line 346: p_action_information14 => fnd_date.date_to_canonical(g_coida_end2),

342: p_action_information10 => l_coida_limit_display,
343: p_action_information11 => fnd_date.date_to_canonical(g_coida_start1),
344: p_action_information12 => fnd_date.date_to_canonical(g_coida_end1),
345: p_action_information13 => fnd_date.date_to_canonical(g_coida_start2),
346: p_action_information14 => fnd_date.date_to_canonical(g_coida_end2),
347: p_action_information15 => l_split1,
348: p_action_information16 => l_split2,
349: p_action_information17 => l_num_of_months1,
350: p_action_information18 => l_num_of_months2

Line 980: , p_action_information10 => fnd_date.date_to_canonical(p_date)

976: , p_action_information7 => l_actual_earnings2
977: , p_action_information8 => p_days_worked
978: , p_action_information11 => l_person_type --Bug 14272272
979: , p_action_information9 => p_asg_type
980: , p_action_information10 => fnd_date.date_to_canonical(p_date)
981: , p_action_information30 => p_person_id
982: , p_assignment_id => p_asg_id
983: );
984: else -- Bug#11938675

Line 1134: , p_action_information4 => fnd_date.date_to_canonical(rec_person_details.hire_date)

1130: , p_action_information_category => 'ZA_COID_EMP_INFO'
1131: , p_action_information1 => rec_person_details.last_name
1132: , p_action_information2 => rec_person_details.emp_no
1133: , p_action_information3 => rec_person_details.type
1134: , p_action_information4 => fnd_date.date_to_canonical(rec_person_details.hire_date)
1135: , p_action_information5 => fnd_date.date_to_canonical(rec_person_details.term_date)
1136: , p_action_information6 => fnd_date.date_to_canonical(rec_person_details.asg_start_date)
1137: , p_action_information7 => fnd_date.date_to_canonical(rec_person_details.asg_end_date)
1138: , p_action_information9 => l_asg_type

Line 1135: , p_action_information5 => fnd_date.date_to_canonical(rec_person_details.term_date)

1131: , p_action_information1 => rec_person_details.last_name
1132: , p_action_information2 => rec_person_details.emp_no
1133: , p_action_information3 => rec_person_details.type
1134: , p_action_information4 => fnd_date.date_to_canonical(rec_person_details.hire_date)
1135: , p_action_information5 => fnd_date.date_to_canonical(rec_person_details.term_date)
1136: , p_action_information6 => fnd_date.date_to_canonical(rec_person_details.asg_start_date)
1137: , p_action_information7 => fnd_date.date_to_canonical(rec_person_details.asg_end_date)
1138: , p_action_information9 => l_asg_type
1139: , p_action_information30 => rec_person_details.person_id

Line 1136: , p_action_information6 => fnd_date.date_to_canonical(rec_person_details.asg_start_date)

1132: , p_action_information2 => rec_person_details.emp_no
1133: , p_action_information3 => rec_person_details.type
1134: , p_action_information4 => fnd_date.date_to_canonical(rec_person_details.hire_date)
1135: , p_action_information5 => fnd_date.date_to_canonical(rec_person_details.term_date)
1136: , p_action_information6 => fnd_date.date_to_canonical(rec_person_details.asg_start_date)
1137: , p_action_information7 => fnd_date.date_to_canonical(rec_person_details.asg_end_date)
1138: , p_action_information9 => l_asg_type
1139: , p_action_information30 => rec_person_details.person_id
1140: , p_assignment_id => rec_person_details.ass_id

Line 1137: , p_action_information7 => fnd_date.date_to_canonical(rec_person_details.asg_end_date)

1133: , p_action_information3 => rec_person_details.type
1134: , p_action_information4 => fnd_date.date_to_canonical(rec_person_details.hire_date)
1135: , p_action_information5 => fnd_date.date_to_canonical(rec_person_details.term_date)
1136: , p_action_information6 => fnd_date.date_to_canonical(rec_person_details.asg_start_date)
1137: , p_action_information7 => fnd_date.date_to_canonical(rec_person_details.asg_end_date)
1138: , p_action_information9 => l_asg_type
1139: , p_action_information30 => rec_person_details.person_id
1140: , p_assignment_id => rec_person_details.ass_id
1141: );

Line 1239: , fnd_date.canonical_to_date(pai.action_information10) pay_adv_date --revisit --need to populate this in archive code

1235: , nvl(sum(pai.action_information3),0) dir_income
1236: , nvl(sum(pai.action_information4),0) cash_comp
1237: , nvl(sum(pai.action_information5),0) tot_income
1238: , pai.action_information1 mon
1239: , fnd_date.canonical_to_date(pai.action_information10) pay_adv_date --revisit --need to populate this in archive code
1240: , pai.action_information8 num_days
1241: from pay_action_information pai
1242: , pay_assignment_actions paa
1243: , pay_action_information pai2

Line 1411: p_action_information10 => fnd_date.date_to_canonical(cum_tab(l_month).pay_adv_dt),

1407: p_action_information6 => cum_tab(l_month).act_earn1,
1408: p_action_information7 => cum_tab(l_month).act_earn2,
1409: p_action_information8 => cum_tab(l_month).num_days,
1410: p_action_information9 => rec_dup_person.asg_type,
1411: p_action_information10 => fnd_date.date_to_canonical(cum_tab(l_month).pay_adv_dt),
1412: p_action_information30 => rec_dup_person.person_id
1413: );
1414:
1415: else