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_FORA dependencies on FND_DATE

Line 139: , /FND_DATE.canonical_to_date(effective_date)/ effective_date, business_group_id bg_id

135: (legislative_parameters
136: , 'YEAR'
137: )
138: ) L_YEAR
139: , /*FND_DATE.canonical_to_date(effective_date)*/ effective_date, business_group_id bg_id
140: FROM pay_payroll_actions
141: WHERE payroll_action_id = p_payroll_action_id;
142:
143: lr_parameter_info csr_parameter_info%ROWTYPE;

Line 1093: , p_action_information10 => fnd_date.date_to_canonical(emp_record(l_counter).l_white_from)

1089: , p_action_information6 => L_CFAR_NUMBER
1090: , p_action_information7 => l_person_number
1091: , p_action_information8 => l_person_name
1092: , p_action_information9 => emp_record(l_counter).l_category
1093: , p_action_information10 => fnd_date.date_to_canonical(emp_record(l_counter).l_white_from)
1094: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(l_counter).l_gross_salary)
1095: , p_action_information12 => emp_record(l_counter).l_termination
1096: , p_action_information13 => emp_record(l_counter).l_job
1097: );*/

Line 1121: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)

1117: , p_action_information6 => L_CFAR_NUMBER
1118: , p_action_information7 => l_person_number
1119: , p_action_information8 => l_person_name
1120: , p_action_information9 => emp_record(csr_record).l_category
1121: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1122: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1123: , p_action_information12 => emp_record(csr_record).l_termination
1124: , p_action_information13 => emp_record(csr_record).l_job
1125: );

Line 1499: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)

1495: , p_action_information6 => L_CFAR_NUMBER
1496: , p_action_information7 => l_person_number
1497: , p_action_information8 => l_person_name
1498: , p_action_information9 => emp_record(csr_record).l_category
1499: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1500: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1501: , p_action_information12 => emp_record(csr_record).l_termination
1502: , p_action_information13 => emp_record(csr_record).l_job
1503: );

Line 1919: (fnd_date.canonical_to_date (action_information5)

1915: csr_v_pa_id pay_action_information.action_context_id%TYPE
1916: )
1917: IS
1918: SELECT TO_CHAR
1919: (fnd_date.canonical_to_date (action_information5)
1920: , 'YYYYMMDD'
1921: ) period_from
1922: , TO_CHAR
1923: (fnd_date.canonical_to_date (action_information6)

Line 1923: (fnd_date.canonical_to_date (action_information6)

1919: (fnd_date.canonical_to_date (action_information5)
1920: , 'YYYYMMDD'
1921: ) period_from
1922: , TO_CHAR
1923: (fnd_date.canonical_to_date (action_information6)
1924: , 'YYYYMMDD'
1925: ) period_to
1926: FROM pay_action_information
1927: WHERE action_context_type = 'PA'

Line 2385: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);

2381: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2382: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2383:
2384: xml_tab(l_counter).TagName :='WHITE_FROM';
2385: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2386: l_counter:=l_counter+1;
2387: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2388: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2389: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');

Line 2388: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');

2384: xml_tab(l_counter).TagName :='WHITE_FROM';
2385: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2386: l_counter:=l_counter+1;
2387: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2388: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2389: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');
2390: --to_char(csr_person.White_Collar,'YYMMDD');
2391: l_counter:=l_counter+1;
2392: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);

Line 2389: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');

2385: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2386: l_counter:=l_counter+1;
2387: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2388: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2389: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');
2390: --to_char(csr_person.White_Collar,'YYMMDD');
2391: l_counter:=l_counter+1;
2392: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2393: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/

Line 2566: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);

2562: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2563: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2564:
2565: xml_tab(l_counter).TagName :='WHITE_FROM';
2566: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2567: l_counter:=l_counter+1;
2568: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2569: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2570: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');

Line 2569: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');

2565: xml_tab(l_counter).TagName :='WHITE_FROM';
2566: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2567: l_counter:=l_counter+1;
2568: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2569: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2570: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');
2571: --to_char(csr_person.White_Collar,'YYMMDD');
2572: l_counter:=l_counter+1;
2573: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);

Line 2570: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');

2566: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2567: l_counter:=l_counter+1;
2568: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2569: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2570: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');
2571: --to_char(csr_person.White_Collar,'YYMMDD');
2572: l_counter:=l_counter+1;
2573: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2574: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/