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.PSP_ENC_PRE_PROCESS dependencies on FND_DATE

Line 170: hr_utility.trace('l_max_pay_date: ' || fnd_date.date_to_canonical(l_max_pay_date));

166:
167:
168:
169: -- Introduced the following for bug fix 3434626
170: hr_utility.trace('l_max_pay_date: ' || fnd_date.date_to_canonical(l_max_pay_date));
171:
172: l_proc_step := 30;
173: -- End of bug fix 3434626
174:

Line 323: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));

319: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
320: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
321: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
322: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
323: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));
324:
325: l_proc_step := 10; -- Introduced for bug fix 3434626
326: -- End of bug fix 3434626
327:

Line 354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||

350: ' r_global_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_project_id(i)) ||
351: ' r_global_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_award_id(i)) ||
352: ' r_global_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_task_id(i)) ||
353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(i)) ||
354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||
355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||
356: ' r_global_control_rec.r_expenditure_type(i): ' || r_global_control_rec.r_expenditure_type(i) ||
357: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
358: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||

Line 355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||

351: ' r_global_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_award_id(i)) ||
352: ' r_global_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_task_id(i)) ||
353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(i)) ||
354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||
355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||
356: ' r_global_control_rec.r_expenditure_type(i): ' || r_global_control_rec.r_expenditure_type(i) ||
357: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
358: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
359: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||

Line 386: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384:
385: -- Introduced for bug fix 3434626
386: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
387: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
388: l_proc_step := 30;
389: -- End of bug fix 3434626
390:

Line 387: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));

383: END IF;
384:
385: -- Introduced for bug fix 3434626
386: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
387: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
388: l_proc_step := 30;
389: -- End of bug fix 3434626
390:
391: l_prev_project_id := r_global_control_rec.r_project_id(i);

Line 553: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));

549: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
550: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
551: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
552: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
553: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));
554:
555: l_proc_step := 10; -- Introduced for bug fix 3434626
556: -- End of bug fix 3434626
557:

Line 586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||

582: ' r_schedule_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_project_id(i)) ||
583: ' r_schedule_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_award_id(i)) ||
584: ' r_schedule_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_task_id(i)) ||
585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(i)) ||
586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||
587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||
588: ' r_schedule_control_rec.r_expenditure_type(i): ' || r_schedule_control_rec.r_expenditure_type(i) ||
589: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
590: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||

Line 587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||

583: ' r_schedule_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_award_id(i)) ||
584: ' r_schedule_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_task_id(i)) ||
585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(i)) ||
586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||
587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||
588: ' r_schedule_control_rec.r_expenditure_type(i): ' || r_schedule_control_rec.r_expenditure_type(i) ||
589: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
590: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
591: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||

Line 621: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: -- Introduced for bug fix 3434626
621: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
622: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
623: l_proc_step := 30;
624: -- End of bug fix 3434626
625:

Line 622: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));

618: END IF;
619:
620: -- Introduced for bug fix 3434626
621: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
622: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
623: l_proc_step := 30;
624: -- End of bug fix 3434626
625:
626: l_prev_project_id := r_schedule_control_rec.r_project_id(i);

Line 802: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));

798: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
799: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
800: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
801: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
802: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));
803:
804: l_proc_step := 10; -- Introduced for bug fix 3434626
805: -- End of bug fix 3434626
806:

Line 832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||

828: ' r_ls_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_project_id(i)) ||
829: ' r_ls_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_award_id(i)) ||
830: ' r_ls_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_task_id(i)) ||
831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(i)) ||
832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||
833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||
834: ' r_ls_control_rec.r_expenditure_type(i): ' || r_ls_control_rec.r_expenditure_type(i) ||
835: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
836: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||

Line 833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||

829: ' r_ls_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_award_id(i)) ||
830: ' r_ls_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_task_id(i)) ||
831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(i)) ||
832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||
833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||
834: ' r_ls_control_rec.r_expenditure_type(i): ' || r_ls_control_rec.r_expenditure_type(i) ||
835: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
836: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
837: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||

Line 866: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864:
865: -- Introduced for bug fix 3434626
866: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
867: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
868: l_proc_step := 30;
869: -- End of bug fix 3434626
870:

Line 867: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));

863: END IF;
864:
865: -- Introduced for bug fix 3434626
866: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
867: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
868: l_proc_step := 30;
869: -- End of bug fix 3434626
870:
871: l_prev_project_id := r_ls_control_rec.r_project_id(i);

Line 1027: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));

1023: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
1024: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1025: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1026: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
1027: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));
1028:
1029: l_proc_step := 10; -- Introduced for bug fix 3434626
1030: -- End of bug fix 3434626
1031:

Line 1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||

1053: ' r_susp_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_project_id(i)) ||
1054: ' r_susp_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_award_id(i)) ||
1055: ' r_susp_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_task_id(i)) ||
1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(i)) ||
1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||
1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||
1059: ' r_susp_control_rec.r_expenditure_type(i): ' || r_susp_control_rec.r_expenditure_type(i) ||
1060: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
1061: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||

Line 1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||

1054: ' r_susp_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_award_id(i)) ||
1055: ' r_susp_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_task_id(i)) ||
1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(i)) ||
1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||
1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||
1059: ' r_susp_control_rec.r_expenditure_type(i): ' || r_susp_control_rec.r_expenditure_type(i) ||
1060: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
1061: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
1062: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||

Line 1091: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: -- Introduced for bug fix 3434626
1091: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
1092: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
1093: l_proc_step := 30;
1094: -- End of bug fix 3434626
1095:

Line 1092: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));

1088: END IF;
1089:
1090: -- Introduced for bug fix 3434626
1091: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
1092: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
1093: l_proc_step := 30;
1094: -- End of bug fix 3434626
1095:
1096: l_prev_project_id := r_susp_control_rec.r_project_id(i);

Line 1207: l_proj_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');

1203: p_start_date OUT NOCOPY DATE,
1204: p_end_date OUT NOCOPY DATE,
1205: p_return_status OUT NOCOPY VARCHAR2)
1206: IS
1207: l_proj_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1208: l_proj_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1209: l_task_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');

Line 1208: l_proj_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');

1204: p_end_date OUT NOCOPY DATE,
1205: p_return_status OUT NOCOPY VARCHAR2)
1206: IS
1207: l_proj_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1208: l_proj_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1209: l_task_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');

Line 1209: l_task_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');

1205: p_return_status OUT NOCOPY VARCHAR2)
1206: IS
1207: l_proj_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1208: l_proj_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1209: l_task_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');

Line 1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');

1206: IS
1207: l_proj_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1208: l_proj_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1209: l_task_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1214: l_exp_type_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');

Line 1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');

1207: l_proj_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1208: l_proj_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1209: l_task_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1214: l_exp_type_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1215: l_exp_org_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');

Line 1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');

1208: l_proj_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1209: l_task_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1214: l_exp_type_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1215: l_exp_org_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1216: l_exp_org_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');

Line 1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');

1209: l_task_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1214: l_exp_type_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1215: l_exp_org_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1216: l_exp_org_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1217: l_allowable_schedule_id NUMBER(15);

Line 1214: l_exp_type_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');

1210: l_task_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1214: l_exp_type_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1215: l_exp_org_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1216: l_exp_org_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1217: l_allowable_schedule_id NUMBER(15);
1218: l_proj_status_code VARCHAR2(30);

Line 1215: l_exp_org_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');

1211: l_award_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1214: l_exp_type_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1215: l_exp_org_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1216: l_exp_org_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1217: l_allowable_schedule_id NUMBER(15);
1218: l_proj_status_code VARCHAR2(30);
1219: l_enabled_flag VARCHAR2(1);

Line 1216: l_exp_org_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');

1212: l_award_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1213: l_exp_type_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1214: l_exp_type_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1215: l_exp_org_start_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
1216: l_exp_org_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
1217: l_allowable_schedule_id NUMBER(15);
1218: l_proj_status_code VARCHAR2(30);
1219: l_enabled_flag VARCHAR2(1);
1220: l_enc_cr_date DATE;

Line 1298: ' p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1294: ' p_task_id: ' || fnd_number.number_to_canonical(p_task_id) ||
1295: ' p_expenditure_organization_id: ' || fnd_number.number_to_canonical(p_expenditure_organization_id) ||
1296: ' p_expenditure_type: ' || p_expenditure_type ||
1297: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1298: ' p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1299: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1300:
1301: l_proc_step := 10;
1302: -- End of bug fix 3434626

Line 1299: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

1295: ' p_expenditure_organization_id: ' || fnd_number.number_to_canonical(p_expenditure_organization_id) ||
1296: ' p_expenditure_type: ' || p_expenditure_type ||
1297: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1298: ' p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1299: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1300:
1301: l_proc_step := 10;
1302: -- End of bug fix 3434626
1303:

Line 1309: p_start_date := fnd_date.canonical_to_date('1800/01/01');

1305: OPEN project_info_cur ;
1306: FETCH project_info_cur into l_proj_status_code,
1307: l_proj_start_date,l_proj_end_date,l_task_start_date,l_task_end_date;
1308: IF project_info_cur%NOTFOUND THEN
1309: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1310: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1311: CLOSE project_info_cur;
1312: -- Introduced the following for bug fix 3434626
1313: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

Line 1310: p_end_date := fnd_date.canonical_to_date('1800/01/31');

1306: FETCH project_info_cur into l_proj_status_code,
1307: l_proj_start_date,l_proj_end_date,l_task_start_date,l_task_end_date;
1308: IF project_info_cur%NOTFOUND THEN
1309: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1310: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1311: CLOSE project_info_cur;
1312: -- Introduced the following for bug fix 3434626
1313: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1314: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

Line 1313: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1309: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1310: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1311: CLOSE project_info_cur;
1312: -- Introduced the following for bug fix 3434626
1313: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1314: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1315:
1316: l_proc_step := 20;
1317: -- End of bug fix 3434626

Line 1314: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

1310: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1311: CLOSE project_info_cur;
1312: -- Introduced the following for bug fix 3434626
1313: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1314: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1315:
1316: l_proc_step := 20;
1317: -- End of bug fix 3434626
1318:

Line 1331: p_start_date := fnd_date.canonical_to_date('1800/01/01');

1327: /*Validation for enabled_flag */
1328: OPEN project_status_csr;
1329: FETCH project_status_csr INTO l_enabled_flag;
1330: IF (project_status_csr %NOTFOUND) OR (l_enabled_flag = 'N') THEN
1331: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1332: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1333: CLOSE project_status_csr;
1334: -- Introduced the following for bug fix 3434626
1335: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

Line 1332: p_end_date := fnd_date.canonical_to_date('1800/01/31');

1328: OPEN project_status_csr;
1329: FETCH project_status_csr INTO l_enabled_flag;
1330: IF (project_status_csr %NOTFOUND) OR (l_enabled_flag = 'N') THEN
1331: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1332: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1333: CLOSE project_status_csr;
1334: -- Introduced the following for bug fix 3434626
1335: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1336: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

Line 1335: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1331: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1332: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1333: CLOSE project_status_csr;
1334: -- Introduced the following for bug fix 3434626
1335: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1336: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1337:
1338: l_proc_step := 40;
1339: -- End of bug fix 3434626

Line 1336: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

1332: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1333: CLOSE project_status_csr;
1334: -- Introduced the following for bug fix 3434626
1335: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1336: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1337:
1338: l_proc_step := 40;
1339: -- End of bug fix 3434626
1340:

Line 1352: p_start_date := fnd_date.canonical_to_date('1800/01/01');

1348:
1349: OPEN award_info_cur;
1350: FETCH award_info_cur into l_award_start_date,l_award_end_date,l_allowable_schedule_id;
1351: IF award_info_cur%NOTFOUND then
1352: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1353: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1354: CLOSE award_info_cur;
1355: -- Introduced the following for bug fix 3434626
1356: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

Line 1353: p_end_date := fnd_date.canonical_to_date('1800/01/31');

1349: OPEN award_info_cur;
1350: FETCH award_info_cur into l_award_start_date,l_award_end_date,l_allowable_schedule_id;
1351: IF award_info_cur%NOTFOUND then
1352: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1353: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1354: CLOSE award_info_cur;
1355: -- Introduced the following for bug fix 3434626
1356: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1357: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

Line 1356: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1352: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1353: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1354: CLOSE award_info_cur;
1355: -- Introduced the following for bug fix 3434626
1356: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1357: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1358:
1359: l_proc_step := 60;
1360: -- End of bug fix 3434626

Line 1357: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

1353: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1354: CLOSE award_info_cur;
1355: -- Introduced the following for bug fix 3434626
1356: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1357: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1358:
1359: l_proc_step := 60;
1360: -- End of bug fix 3434626
1361:

Line 1373: p_start_date := fnd_date.canonical_to_date('1800/01/01');

1369:
1370: OPEN expenditure_type_info_cur;
1371: FETCH expenditure_type_info_cur into l_exp_type_start_date,l_exp_type_end_date;
1372: IF expenditure_type_info_cur %NOTFOUND THEN
1373: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1374: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1375: CLOSE expenditure_type_info_cur;
1376: RETURN;
1377: -- Introduced the following for bug fix 3434626

Line 1374: p_end_date := fnd_date.canonical_to_date('1800/01/31');

1370: OPEN expenditure_type_info_cur;
1371: FETCH expenditure_type_info_cur into l_exp_type_start_date,l_exp_type_end_date;
1372: IF expenditure_type_info_cur %NOTFOUND THEN
1373: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1374: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1375: CLOSE expenditure_type_info_cur;
1376: RETURN;
1377: -- Introduced the following for bug fix 3434626
1378: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

Line 1378: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1374: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1375: CLOSE expenditure_type_info_cur;
1376: RETURN;
1377: -- Introduced the following for bug fix 3434626
1378: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1379: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1380:
1381: l_proc_step := 80;
1382: -- End of bug fix 3434626

Line 1379: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

1375: CLOSE expenditure_type_info_cur;
1376: RETURN;
1377: -- Introduced the following for bug fix 3434626
1378: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1379: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1380:
1381: l_proc_step := 80;
1382: -- End of bug fix 3434626
1383:

Line 1394: p_start_date := fnd_date.canonical_to_date('1800/01/01');

1390:
1391: OPEN exp_org_cur;
1392: FETCH exp_org_cur into l_exp_org_start_date,l_exp_org_end_date;
1393: IF exp_org_cur% NOTFOUND THEN
1394: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1395: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1396: CLOSE exp_org_cur;
1397: -- Introduced the following for bug fix 3434626
1398: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

Line 1395: p_end_date := fnd_date.canonical_to_date('1800/01/31');

1391: OPEN exp_org_cur;
1392: FETCH exp_org_cur into l_exp_org_start_date,l_exp_org_end_date;
1393: IF exp_org_cur% NOTFOUND THEN
1394: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1395: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1396: CLOSE exp_org_cur;
1397: -- Introduced the following for bug fix 3434626
1398: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1399: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

Line 1398: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1394: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1395: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1396: CLOSE exp_org_cur;
1397: -- Introduced the following for bug fix 3434626
1398: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1399: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1400:
1401: l_proc_step := 100;
1402: -- End of bug fix 3434626

Line 1399: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

1395: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1396: CLOSE exp_org_cur;
1397: -- Introduced the following for bug fix 3434626
1398: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1399: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1400:
1401: l_proc_step := 100;
1402: -- End of bug fix 3434626
1403:

Line 1420: l_labor_enc_start_date := NVL(l_labor_enc_start_date, fnd_date.canonical_to_date('1800/01/01'));

1416: p_expenditure_organization_id,
1417: p_payroll_id,
1418: l_labor_enc_start_date,
1419: l_labor_enc_end_date);
1420: l_labor_enc_start_date := NVL(l_labor_enc_start_date, fnd_date.canonical_to_date('1800/01/01'));
1421: l_labor_enc_end_date := NVL(l_labor_enc_end_date, fnd_date.canonical_to_date('4712/12/31'));
1422: hr_utility.trace('l_labor_enc_start_date: ' || fnd_date.date_to_canonical(l_labor_enc_start_date) ||
1423: ' l_labor_enc_end_date: ' || fnd_date.date_to_canonical(l_labor_enc_end_date));
1424:

Line 1421: l_labor_enc_end_date := NVL(l_labor_enc_end_date, fnd_date.canonical_to_date('4712/12/31'));

1417: p_payroll_id,
1418: l_labor_enc_start_date,
1419: l_labor_enc_end_date);
1420: l_labor_enc_start_date := NVL(l_labor_enc_start_date, fnd_date.canonical_to_date('1800/01/01'));
1421: l_labor_enc_end_date := NVL(l_labor_enc_end_date, fnd_date.canonical_to_date('4712/12/31'));
1422: hr_utility.trace('l_labor_enc_start_date: ' || fnd_date.date_to_canonical(l_labor_enc_start_date) ||
1423: ' l_labor_enc_end_date: ' || fnd_date.date_to_canonical(l_labor_enc_end_date));
1424:
1425: p_end_date := LEAST (l_proj_end_date,

Line 1422: hr_utility.trace('l_labor_enc_start_date: ' || fnd_date.date_to_canonical(l_labor_enc_start_date) ||

1418: l_labor_enc_start_date,
1419: l_labor_enc_end_date);
1420: l_labor_enc_start_date := NVL(l_labor_enc_start_date, fnd_date.canonical_to_date('1800/01/01'));
1421: l_labor_enc_end_date := NVL(l_labor_enc_end_date, fnd_date.canonical_to_date('4712/12/31'));
1422: hr_utility.trace('l_labor_enc_start_date: ' || fnd_date.date_to_canonical(l_labor_enc_start_date) ||
1423: ' l_labor_enc_end_date: ' || fnd_date.date_to_canonical(l_labor_enc_end_date));
1424:
1425: p_end_date := LEAST (l_proj_end_date,
1426: l_task_end_date,

Line 1423: ' l_labor_enc_end_date: ' || fnd_date.date_to_canonical(l_labor_enc_end_date));

1419: l_labor_enc_end_date);
1420: l_labor_enc_start_date := NVL(l_labor_enc_start_date, fnd_date.canonical_to_date('1800/01/01'));
1421: l_labor_enc_end_date := NVL(l_labor_enc_end_date, fnd_date.canonical_to_date('4712/12/31'));
1422: hr_utility.trace('l_labor_enc_start_date: ' || fnd_date.date_to_canonical(l_labor_enc_start_date) ||
1423: ' l_labor_enc_end_date: ' || fnd_date.date_to_canonical(l_labor_enc_end_date));
1424:
1425: p_end_date := LEAST (l_proj_end_date,
1426: l_task_end_date,
1427: l_award_end_date,

Line 1439: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1435: l_exp_org_start_date,
1436: l_labor_enc_start_date);
1437:
1438: -- Introduced the following for bug fix 3434626
1439: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1440: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1441:
1442: l_proc_step := 120;
1443: -- End of bug fix 3434626

Line 1440: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

1436: l_labor_enc_start_date);
1437:
1438: -- Introduced the following for bug fix 3434626
1439: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1440: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1441:
1442: l_proc_step := 120;
1443: -- End of bug fix 3434626
1444:

Line 1523: hr_utility.trace('l_enc_cr_date: ' || fnd_date.date_to_canonical(l_enc_cr_date));

1519: FETCH max_create_dt_cur INTO l_enc_cr_date;
1520: CLOSE max_create_dt_cur;
1521:
1522: -- Introduced the following for bug fix 3434626
1523: hr_utility.trace('l_enc_cr_date: ' || fnd_date.date_to_canonical(l_enc_cr_date));
1524:
1525: l_proc_step := 20;
1526: -- End of bug fix 3434626
1527: