DBA Data[Home] [Help]

APPS.PSP_TEMPLATE_SELECTION dependencies on FND_DATE

Line 39: l_psp_effort_start:= trunc(fnd_date.canonical_to_date(get_parameter_value('START_DATE', param_string)));

35: --fnd_file.put_line(fnd_file.log,'TEMPLATE_ID ===='||l_psp_template_id);
36: --fnd_file.put_line(fnd_file.log,'Return String '||get_parameter_value('START_DATE', param_string));
37:
38:
39: l_psp_effort_start:= trunc(fnd_date.canonical_to_date(get_parameter_value('START_DATE', param_string)));
40: --fnd_file.put_line(fnd_file.log,'start_date ===='||l_psp_effort_start);
41:
42: l_psp_effort_end:= trunc(fnd_date.canonical_to_date(get_parameter_value('END_DATE', param_string)));
43: --fnd_file.put_line(fnd_file.log,'end date ===='||l_psp_effort_end);

Line 42: l_psp_effort_end:= trunc(fnd_date.canonical_to_date(get_parameter_value('END_DATE', param_string)));

38:
39: l_psp_effort_start:= trunc(fnd_date.canonical_to_date(get_parameter_value('START_DATE', param_string)));
40: --fnd_file.put_line(fnd_file.log,'start_date ===='||l_psp_effort_start);
41:
42: l_psp_effort_end:= trunc(fnd_date.canonical_to_date(get_parameter_value('END_DATE', param_string)));
43: --fnd_file.put_line(fnd_file.log,'end date ===='||l_psp_effort_end);
44:
45: l_psp_report_layout := get_parameter_value('REPORT_LAYOUT', param_string);
46: l_psp_sort_option1 := get_parameter_value('FIRST_SORT', param_string);

Line 3520: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_start_date(k));

3516:
3517: hr_utility.trace( ' Input 2 :REQUEST_ID = '||l_inputs(l_in_cnt).value);
3518:
3519: ELSIF l_inputs(l_in_cnt).name='START_DATE' THEN
3520: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_start_date(k));
3521: hr_utility.trace( ' Input 3 :START_DATE = '||l_inputs(l_in_cnt).value);
3522:
3523: ELSIF l_inputs(l_in_cnt).name='END_DATE' THEN
3524: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_end_date(k));

Line 3524: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_end_date(k));

3520: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_start_date(k));
3521: hr_utility.trace( ' Input 3 :START_DATE = '||l_inputs(l_in_cnt).value);
3522:
3523: ELSIF l_inputs(l_in_cnt).name='END_DATE' THEN
3524: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_end_date(k));
3525: hr_utility.trace( ' Input 4 :END_DATE= '||l_inputs(l_in_cnt).value);
3526:
3527: ELSIF l_inputs(l_in_cnt).name ='ASSIGNMENT_ID' THEN
3528: l_inputs(l_in_cnt).value := fnd_number.number_to_canonical(r_ls_criteria_rec.l_assignment_id(k));