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 1099: , p_action_information10 => fnd_date.date_to_canonical(emp_record(l_counter).l_white_from)

1095: , p_action_information6 => L_CFAR_NUMBER
1096: , p_action_information7 => l_person_number
1097: , p_action_information8 => l_person_name
1098: , p_action_information9 => emp_record(l_counter).l_category
1099: , p_action_information10 => fnd_date.date_to_canonical(emp_record(l_counter).l_white_from)
1100: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(l_counter).l_gross_salary)
1101: , p_action_information12 => emp_record(l_counter).l_termination
1102: , p_action_information13 => emp_record(l_counter).l_job
1103: );*/

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

1129: , p_action_information6 => L_CFAR_NUMBER
1130: , p_action_information7 => l_person_number
1131: , p_action_information8 => l_person_name
1132: , p_action_information9 => emp_record(csr_record).l_category
1133: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1134: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1135: , p_action_information12 => emp_record(csr_record).l_termination
1136: , p_action_information13 => emp_record(csr_record).l_job
1137: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix

Line 1137: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix

1133: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1134: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1135: , p_action_information12 => emp_record(csr_record).l_termination
1136: , p_action_information13 => emp_record(csr_record).l_job
1137: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix
1138: , p_action_information15 => fnd_date.date_to_canonical(l_rep_start_date) -- Bug#9440498 fix
1139: );
1140: emp_record.delete(csr_record);
1141: END LOOP;

Line 1138: , p_action_information15 => fnd_date.date_to_canonical(l_rep_start_date) -- Bug#9440498 fix

1134: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1135: , p_action_information12 => emp_record(csr_record).l_termination
1136: , p_action_information13 => emp_record(csr_record).l_job
1137: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix
1138: , p_action_information15 => fnd_date.date_to_canonical(l_rep_start_date) -- Bug#9440498 fix
1139: );
1140: emp_record.delete(csr_record);
1141: END LOOP;
1142: END IF;

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

1519: , p_action_information6 => L_CFAR_NUMBER
1520: , p_action_information7 => l_person_number
1521: , p_action_information8 => l_person_name
1522: , p_action_information9 => emp_record(csr_record).l_category
1523: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1524: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1525: , p_action_information12 => emp_record(csr_record).l_termination
1526: , p_action_information13 => emp_record(csr_record).l_job
1527: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix

Line 1527: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix

1523: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1524: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1525: , p_action_information12 => emp_record(csr_record).l_termination
1526: , p_action_information13 => emp_record(csr_record).l_job
1527: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix
1528: , p_action_information15 => fnd_date.date_to_canonical(l_rep_start_date) -- Bug#9440498 fix
1529: );
1530: emp_record.delete(csr_record);
1531: END LOOP;

Line 1528: , p_action_information15 => fnd_date.date_to_canonical(l_rep_start_date) -- Bug#9440498 fix

1524: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1525: , p_action_information12 => emp_record(csr_record).l_termination
1526: , p_action_information13 => emp_record(csr_record).l_job
1527: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix
1528: , p_action_information15 => fnd_date.date_to_canonical(l_rep_start_date) -- Bug#9440498 fix
1529: );
1530: emp_record.delete(csr_record);
1531: END LOOP;
1532: END IF;

Line 1945: (fnd_date.canonical_to_date (action_information5)

1941: csr_v_pa_id pay_action_information.action_context_id%TYPE
1942: )
1943: IS
1944: SELECT TO_CHAR
1945: (fnd_date.canonical_to_date (action_information5)
1946: , 'YYYYMMDD'
1947: ) period_from
1948: , TO_CHAR
1949: (fnd_date.canonical_to_date (action_information6)

Line 1949: (fnd_date.canonical_to_date (action_information6)

1945: (fnd_date.canonical_to_date (action_information5)
1946: , 'YYYYMMDD'
1947: ) period_from
1948: , TO_CHAR
1949: (fnd_date.canonical_to_date (action_information6)
1950: , 'YYYYMMDD'
1951: ) period_to
1952: FROM pay_action_information
1953: WHERE action_context_type = 'PA'

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

2410: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2411: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2412:
2413: xml_tab(l_counter).TagName :='WHITE_FROM';
2414: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2415: l_counter:=l_counter+1;
2416: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2417: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2418: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');

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

2413: xml_tab(l_counter).TagName :='WHITE_FROM';
2414: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2415: l_counter:=l_counter+1;
2416: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2417: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2418: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');
2419: --to_char(csr_person.White_Collar,'YYMMDD');
2420: l_counter:=l_counter+1;
2421: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);

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

2414: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2415: l_counter:=l_counter+1;
2416: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2417: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2418: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');
2419: --to_char(csr_person.White_Collar,'YYMMDD');
2420: l_counter:=l_counter+1;
2421: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2422: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/

Line 2448: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.Start_Date);

2444: l_counter:=l_counter+1;
2445:
2446: /* Bug#9440498 fix starts */
2447: xml_tab(l_counter).TagName :='START_DATE';
2448: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.Start_Date);
2449: l_counter:=l_counter+1;
2450:
2451: xml_tab(l_counter).TagName :='START_DT';
2452: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.Start_Date),'YYMMDD');

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

2448: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.Start_Date);
2449: l_counter:=l_counter+1;
2450:
2451: xml_tab(l_counter).TagName :='START_DT';
2452: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.Start_Date),'YYMMDD');
2453: l_counter:=l_counter+1;
2454:
2455: l_end_date := FND_DATE.canonical_to_date(NVL(csr_person.Termination_Date, csr_person.White_Collar));
2456: xml_tab(l_counter).TagName :='END_DATE';

Line 2455: l_end_date := FND_DATE.canonical_to_date(NVL(csr_person.Termination_Date, csr_person.White_Collar));

2451: xml_tab(l_counter).TagName :='START_DT';
2452: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.Start_Date),'YYMMDD');
2453: l_counter:=l_counter+1;
2454:
2455: l_end_date := FND_DATE.canonical_to_date(NVL(csr_person.Termination_Date, csr_person.White_Collar));
2456: xml_tab(l_counter).TagName :='END_DATE';
2457: xml_tab(l_counter).TagValue := l_end_date;
2458: l_counter:=l_counter+1;
2459:

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

2613: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2614: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2615:
2616: xml_tab(l_counter).TagName :='WHITE_FROM';
2617: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2618: l_counter:=l_counter+1;
2619: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2620: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2621: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');

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

2616: xml_tab(l_counter).TagName :='WHITE_FROM';
2617: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2618: l_counter:=l_counter+1;
2619: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2620: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2621: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');
2622: --to_char(csr_person.White_Collar,'YYMMDD');
2623: l_counter:=l_counter+1;
2624: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);

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

2617: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.White_Collar);
2618: l_counter:=l_counter+1;
2619: xml_tab(l_counter).TagName :='WHITE_COL_FROM';
2620: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.White_Collar),'YYMMDD');
2621: --FND_DATE.date_to_displayDT(csr_person.White_Collar,'YYMMDD');-- to_char(FND_DATE.date_to_canonical(csr_person.White_Collar),'YYMMDD');
2622: --to_char(csr_person.White_Collar,'YYMMDD');
2623: l_counter:=l_counter+1;
2624: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2625: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/

Line 2653: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.Start_Date);

2649: l_counter:=l_counter+1;
2650:
2651: /* Bug#9440498 fix starts */
2652: xml_tab(l_counter).TagName :='START_DATE';
2653: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.Start_Date);
2654: l_counter:=l_counter+1;
2655:
2656: xml_tab(l_counter).TagName :='START_DT';
2657: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.Start_Date),'YYMMDD');

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

2653: xml_tab(l_counter).TagValue := FND_DATE.canonical_to_date(csr_person.Start_Date);
2654: l_counter:=l_counter+1;
2655:
2656: xml_tab(l_counter).TagName :='START_DT';
2657: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.Start_Date),'YYMMDD');
2658: l_counter:=l_counter+1;
2659:
2660: l_end_date := FND_DATE.canonical_to_date(NVL(csr_person.Termination_Date, csr_person.White_Collar));
2661: xml_tab(l_counter).TagName :='END_DATE';

Line 2660: l_end_date := FND_DATE.canonical_to_date(NVL(csr_person.Termination_Date, csr_person.White_Collar));

2656: xml_tab(l_counter).TagName :='START_DT';
2657: xml_tab(l_counter).TagValue :=to_char(FND_DATE.canonical_to_date(csr_person.Start_Date),'YYMMDD');
2658: l_counter:=l_counter+1;
2659:
2660: l_end_date := FND_DATE.canonical_to_date(NVL(csr_person.Termination_Date, csr_person.White_Collar));
2661: xml_tab(l_counter).TagName :='END_DATE';
2662: xml_tab(l_counter).TagValue := l_end_date;
2663: l_counter:=l_counter+1;
2664: