eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_HCIA_ARCHIVE dependencies on FND_DATE

Line 115: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);

111: FETCH csr_parameter_info INTO lr_parameter_info;
112: CLOSE csr_parameter_info;
113: p_legal_employer_id := lr_parameter_info.legal;
114: p_request_for_all_or_not := lr_parameter_info.request_for;
115: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
116: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
117: p_effective_date := lr_parameter_info.effective_date;
118: p_business_group_id := lr_parameter_info.bg_id;
119:

Line 116: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);

112: CLOSE csr_parameter_info;
113: p_legal_employer_id := lr_parameter_info.legal;
114: p_request_for_all_or_not := lr_parameter_info.request_for;
115: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
116: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
117: p_effective_date := lr_parameter_info.effective_date;
118: p_business_group_id := lr_parameter_info.bg_id;
119:
120: IF g_debug THEN

Line 282: p_action_information5 => fnd_date.date_to_canonical (g_start_date),

278: p_action_information1 => 'PYSEHCIA',
279: p_action_information2 => hr_general.decode_lookup ('SE_TAX_CARD_REQUEST_LEVEL', g_request_for),
280: p_action_information3 => g_legal_employer_id,
281: p_action_information4 => l_legal_employer_details.legal_employer_name,
282: p_action_information5 => fnd_date.date_to_canonical (g_start_date),
283: p_action_information6 => fnd_date.date_to_canonical (g_end_date),
284: p_action_information7 => NULL,
285: p_action_information8 => NULL,
286: p_action_information9 => NULL,

Line 283: p_action_information6 => fnd_date.date_to_canonical (g_end_date),

279: p_action_information2 => hr_general.decode_lookup ('SE_TAX_CARD_REQUEST_LEVEL', g_request_for),
280: p_action_information3 => g_legal_employer_id,
281: p_action_information4 => l_legal_employer_details.legal_employer_name,
282: p_action_information5 => fnd_date.date_to_canonical (g_start_date),
283: p_action_information6 => fnd_date.date_to_canonical (g_end_date),
284: p_action_information7 => NULL,
285: p_action_information8 => NULL,
286: p_action_information9 => NULL,
287: p_action_information10 => NULL

Line 324: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),

320: p_action_information2 => 'LE',
321: p_action_information3 => g_legal_employer_id,
322: p_action_information4 => l_legal_employer_details.legal_employer_name,
323: p_action_information5 => l_legal_employer_details.org_number,
324: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),
325: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),
326: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),
327: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),
328: p_action_information10 => fnd_number.number_to_canonical (l_curr_avg_men_count),

Line 325: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),

321: p_action_information3 => g_legal_employer_id,
322: p_action_information4 => l_legal_employer_details.legal_employer_name,
323: p_action_information5 => l_legal_employer_details.org_number,
324: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),
325: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),
326: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),
327: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),
328: p_action_information10 => fnd_number.number_to_canonical (l_curr_avg_men_count),
329: p_action_information11 => fnd_number.number_to_canonical (l_curr_avg_women_count),

Line 326: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),

322: p_action_information4 => l_legal_employer_details.legal_employer_name,
323: p_action_information5 => l_legal_employer_details.org_number,
324: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),
325: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),
326: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),
327: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),
328: p_action_information10 => fnd_number.number_to_canonical (l_curr_avg_men_count),
329: p_action_information11 => fnd_number.number_to_canonical (l_curr_avg_women_count),
330: p_action_information12 => fnd_number.number_to_canonical (l_prev_avg_men_count),

Line 327: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),

323: p_action_information5 => l_legal_employer_details.org_number,
324: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),
325: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),
326: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),
327: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),
328: p_action_information10 => fnd_number.number_to_canonical (l_curr_avg_men_count),
329: p_action_information11 => fnd_number.number_to_canonical (l_curr_avg_women_count),
330: p_action_information12 => fnd_number.number_to_canonical (l_prev_avg_men_count),
331: p_action_information13 => fnd_number.number_to_canonical (l_prev_avg_women_count)

Line 388: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),

384: p_action_information2 => 'LE',
385: p_action_information3 => rec_legal_employer_details.legal_id,
386: p_action_information4 => rec_legal_employer_details.legal_employer_name,
387: p_action_information5 => rec_legal_employer_details.org_number,
388: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),
389: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),
390: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),
391: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),
392: p_action_information10 => fnd_number.number_to_canonical (l_curr_avg_men_count),

Line 389: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),

385: p_action_information3 => rec_legal_employer_details.legal_id,
386: p_action_information4 => rec_legal_employer_details.legal_employer_name,
387: p_action_information5 => rec_legal_employer_details.org_number,
388: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),
389: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),
390: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),
391: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),
392: p_action_information10 => fnd_number.number_to_canonical (l_curr_avg_men_count),
393: p_action_information11 => fnd_number.number_to_canonical (l_curr_avg_women_count),

Line 390: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),

386: p_action_information4 => rec_legal_employer_details.legal_employer_name,
387: p_action_information5 => rec_legal_employer_details.org_number,
388: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),
389: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),
390: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),
391: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),
392: p_action_information10 => fnd_number.number_to_canonical (l_curr_avg_men_count),
393: p_action_information11 => fnd_number.number_to_canonical (l_curr_avg_women_count),
394: p_action_information12 => fnd_number.number_to_canonical (l_prev_avg_men_count),

Line 391: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),

387: p_action_information5 => rec_legal_employer_details.org_number,
388: p_action_information6 => fnd_date.date_to_canonical (l_current_start_date),
389: p_action_information7 => fnd_date.date_to_canonical (l_current_end_date),
390: p_action_information8 => fnd_date.date_to_canonical (l_previous_start_date),
391: p_action_information9 => fnd_date.date_to_canonical (l_previous_end_date),
392: p_action_information10 => fnd_number.number_to_canonical (l_curr_avg_men_count),
393: p_action_information11 => fnd_number.number_to_canonical (l_curr_avg_women_count),
394: p_action_information12 => fnd_number.number_to_canonical (l_prev_avg_men_count),
395: p_action_information13 => fnd_number.number_to_canonical (l_prev_avg_women_count)