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

Line 270: RPAD(NVL(fnd_date.date_to_displaydate(p_output_file_record.effective_date),' '),15,' ')||g_column_separator||

266: l_outputstring :=
267: RPAD(NVL(p_output_file_record.status,' '),30,' ')||g_column_separator||
268: RPAD(NVL(p_output_file_record.employee_number,' '),20,' ')||g_column_separator||
269: RPAD(NVL(p_output_file_record.assignment_number,'AsgId:'||p_output_file_record.assignment_id),30,' ')||g_column_separator||
270: RPAD(NVL(fnd_date.date_to_displaydate(p_output_file_record.effective_date),' '),15,' ')||g_column_separator||
271: RPAD(NVL(p_output_file_record.change_in,' '),30,' ')||g_column_separator||
272: RPAD(NVL(TO_CHAR(p_output_file_record.FTE_old_value),' '),20,' ')||g_column_separator||
273: RPAD(NVL(p_output_file_record.change_type,' '),15,' ')||g_column_separator||
274: RPAD(NVL(TO_CHAR(p_output_file_record.FTE_new_value),' '),20,' ')||g_column_separator||

Line 286: RPAD(NVL(fnd_date.date_to_displaydate(p_output_file_record.effective_date, calendar_aware => FND_DATE.calendar_aware_alt),' '),15,' ')||g_column_separator||

282: l_outputstring :=
283: RPAD(NVL(p_output_file_record.status,' '),30,' ')||g_column_separator||
284: RPAD(NVL(p_output_file_record.employee_number,' '),20,' ')||g_column_separator||
285: RPAD(NVL(p_output_file_record.assignment_number,'AsgId:'||p_output_file_record.assignment_id),30,' ')||g_column_separator||
286: RPAD(NVL(fnd_date.date_to_displaydate(p_output_file_record.effective_date, calendar_aware => FND_DATE.calendar_aware_alt),' '),15,' ')||g_column_separator||
287: RPAD(NVL(p_output_file_record.change_in,' '),30,' ')||g_column_separator||
288: RPAD(NVL(TO_CHAR(p_output_file_record.FTE_old_value),' '),20,' ')||g_column_separator||
289: RPAD(NVL(p_output_file_record.change_type,' '),15,' ')||g_column_separator||
290: RPAD(NVL(TO_CHAR(p_output_file_record.FTE_new_value),' '),20,' ')||g_column_separator||

Line 629: fnd_date.date_to_canonical(g_epFd_earliest_possible_date));

625: debug_enter(l_proc_name);
626: debug('p_assignment_id:'||p_assignment_id);
627: debug('g_epFd_assignment_id:'||g_epFd_assignment_id);
628: debug('g_epFd_earliest_possible_date:'||
629: fnd_date.date_to_canonical(g_epFd_earliest_possible_date));
630: IF p_reload_cache = TRUE THEN
631: debug('p_reload_cache:TRUE');
632: END IF;
633: IF p_reload_cache = FALSE THEN

Line 678: fnd_date.date_to_canonical(g_epFd_earliest_possible_date));

674:
675: IF g_debug THEN
676: debug('g_epFd_assignment_id:'||g_epFd_assignment_id);
677: debug('g_epFd_earliest_possible_date:'||
678: fnd_date.date_to_canonical(g_epFd_earliest_possible_date));
679: debug_exit(l_proc_name);
680: END IF;
681:
682: RETURN g_epFd_earliest_possible_date;

Line 955: fnd_date.date_to_canonical(p_calculation_date)

951: IF g_debug THEN
952: debug_enter(l_proc_name);
953: debug('p_assignment_id:'||p_assignment_id);
954: debug('p_calculation_date:'||
955: fnd_date.date_to_canonical(p_calculation_date)
956: );
957: debug('p_fte_value:'||p_fte_value);
958: END IF;
959:

Line 1020: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)

1016: l_effective_fte_row.assignment_budget_value_id);
1017: debug('l_effective_fte_row.object_version_number:'||
1018: l_effective_fte_row.object_version_number);
1019: debug('l_effective_fte_row.effective_start_date:'||
1020: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)
1021: );
1022: debug('l_effective_fte_row.effective_end_date:'||
1023: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)
1024: );

Line 1023: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)

1019: debug('l_effective_fte_row.effective_start_date:'||
1020: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)
1021: );
1022: debug('l_effective_fte_row.effective_end_date:'||
1023: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)
1024: );
1025: debug('l_effective_fte_row.value:'||l_effective_fte_row.value);
1026: END IF;
1027:

Line 1196: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)

1192: l_effective_fte_row.assignment_budget_value_id);
1193: debug('l_effective_fte_row.object_version_number:'||
1194: l_effective_fte_row.object_version_number);
1195: debug('l_effective_fte_row.effective_start_date:'||
1196: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)
1197: );
1198: debug('l_effective_fte_row.effective_end_date:'||
1199: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)
1200: );

Line 1199: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)

1195: debug('l_effective_fte_row.effective_start_date:'||
1196: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)
1197: );
1198: debug('l_effective_fte_row.effective_end_date:'||
1199: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)
1200: );
1201: debug('l_effective_fte_row.value:'||l_effective_fte_row.value);
1202: debug('ROUND(p_fte_value,5):'||ROUND(p_fte_value,5));
1203: debug_exit(l_proc_name);

Line 1329: ,fnd_date.date_to_displaydate(p_effective_date)

1325: fnd_message.set_name('PQP','PQP_230456_FTE_NO_ASG_DETAILS');
1326: /* Corrected and added as a part of Bug#10239082 Starts
1327: fnd_message.set_token
1328: ('EFFECTIVEDATE'
1329: ,fnd_date.date_to_displaydate(p_effective_date)
1330: ); */
1331: fnd_message.set_token
1332: ('EFFECTIVEDATE'
1333: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)

Line 1333: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)

1329: ,fnd_date.date_to_displaydate(p_effective_date)
1330: ); */
1331: fnd_message.set_token
1332: ('EFFECTIVEDATE'
1333: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)
1334: );
1335: /* Corrected and added as a part of Bug#10239082 Ends */
1336: fnd_message.raise_error;
1337: END IF;

Line 1500: ,fnd_date.date_to_displaydate(p_effective_date)

1496: );
1497: /* Corrected and added as a part of Bug#10239082 Starts
1498: fnd_message.set_token
1499: ('EFFECTIVEDATE'
1500: ,fnd_date.date_to_displaydate(p_effective_date)
1501: ); */
1502: fnd_message.set_token
1503: ('EFFECTIVEDATE'
1504: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)

Line 1504: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)

1500: ,fnd_date.date_to_displaydate(p_effective_date)
1501: ); */
1502: fnd_message.set_token
1503: ('EFFECTIVEDATE'
1504: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)
1505: );
1506: /* Corrected and added as a part of Bug#10239082 Ends */
1507: fnd_message.raise_error;
1508: ELSE

Line 1513: ,fnd_date.date_to_displaydate(p_effective_date)

1509: fnd_message.set_name('PQP','PQP_230113_AAT_MISSING_CONTRCT');
1510: /* Corrected and added as a part of Bug#10239082 Starts
1511: fnd_message.set_token
1512: ('EFFECTIVEDATE'
1513: ,fnd_date.date_to_displaydate(p_effective_date)
1514: ); */
1515: fnd_message.set_token
1516: ('EFFECTIVEDATE'
1517: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)

Line 1517: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)

1513: ,fnd_date.date_to_displaydate(p_effective_date)
1514: ); */
1515: fnd_message.set_token
1516: ('EFFECTIVEDATE'
1517: ,fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)
1518: );
1519: /* Corrected and added as a part of Bug#10239082 Ends */
1520: fnd_message.raise_error;
1521: END IF;

Line 1566: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

1562:
1563: IF g_debug THEN
1564: debug_enter(l_proc_name);
1565: debug('p_assignment_id:'||p_assignment_id);
1566: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1567: END IF;
1568:
1569: -- fetch the relevant assignment details normal hours and contract
1570:

Line 1649: fnd_date.date_to_displaydate(p_effective_date)||', '||

1645: IF g_debug THEN
1646: /* Corrected and added as a part of Bug#10239082 Starts
1647: hr_utility.trace(
1648: 'Updated, '||p_assignment_id||', '||
1649: fnd_date.date_to_displaydate(p_effective_date)||', '||
1650: l_FTE_value||', '||
1651: l_assignment_details.normal_hours||', '||
1652: -- l_assignment_details.contract_type||', '||
1653: l_contract_details.annual_hours||', '||

Line 1658: fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)||', '||

1654: l_contract_details.period_divisor
1655: ); */
1656: hr_utility.trace(
1657: 'Updated, '||p_assignment_id||', '||
1658: fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)||', '||
1659: l_FTE_value||', '||
1660: l_assignment_details.normal_hours||', '||
1661: -- l_assignment_details.contract_type||', '||
1662: l_contract_details.annual_hours||', '||

Line 1807: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

1803:
1804: IF g_debug THEN
1805: debug_enter(l_proc_name);
1806: debug('p_assignment_id:'||p_assignment_id);
1807: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1808: IF g_is_concurrent_program_run = TRUE THEN
1809: debug('g_is_concurrent_program_run:TRUE');
1810: END IF;
1811: IF g_is_concurrent_program_run = FALSE THEN

Line 1910: debug('l_effective_date:'||fnd_date.date_to_displaydate(l_effective_date)); */

1906: END IF; -- IF NOT g_is_concurrent_program_run
1907:
1908: IF g_debug THEN
1909: /* Corrected and added as a part of Bug#10239082 Starts
1910: debug('l_effective_date:'||fnd_date.date_to_displaydate(l_effective_date)); */
1911: debug('l_effective_date:'||fnd_date.date_to_displaydate(l_effective_date, calendar_aware => FND_DATE.calendar_aware_alt));
1912: /* Corrected and added as a part of Bug#10239082 Ends */
1913: END IF;
1914:

Line 1911: debug('l_effective_date:'||fnd_date.date_to_displaydate(l_effective_date, calendar_aware => FND_DATE.calendar_aware_alt));

1907:
1908: IF g_debug THEN
1909: /* Corrected and added as a part of Bug#10239082 Starts
1910: debug('l_effective_date:'||fnd_date.date_to_displaydate(l_effective_date)); */
1911: debug('l_effective_date:'||fnd_date.date_to_displaydate(l_effective_date, calendar_aware => FND_DATE.calendar_aware_alt));
1912: /* Corrected and added as a part of Bug#10239082 Ends */
1913: END IF;
1914:
1915: IF l_effective_date IS NOT NULL

Line 2138: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')

2134: /* Corrected and added as a part of Bug#10239082 Starts
2135: fnd_file.put_line
2136: (fnd_file.log
2137: ,'Calculate FTE For Assignments - '||
2138: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2139: ); */
2140: fnd_file.put_line
2141: (fnd_file.log
2142: ,'Calculate FTE For Assignments - '||

Line 2143: fnd_date.date_to_displaydate(SYSDATE, calendar_aware => FND_DATE.calendar_aware_alt)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')

2139: ); */
2140: fnd_file.put_line
2141: (fnd_file.log
2142: ,'Calculate FTE For Assignments - '||
2143: fnd_date.date_to_displaydate(SYSDATE, calendar_aware => FND_DATE.calendar_aware_alt)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2144: );
2145: /* Corrected and added as a part of Bug#10239082 Ends */
2146: -- Set the standard concurrent program out paramters
2147: ERRBUF:= NULL;

Line 2154: l_calculation_date := fnd_date.canonical_to_date(p_calculation_date);

2150: -- In concurrent programs, the date is passed in as a string in canonical format. We must convert this
2151: -- to a date
2152:
2153: --l_calculation_date := to_date(substr(p_calculation_date, 1, 10), 'YYYY/MM/DD');
2154: l_calculation_date := fnd_date.canonical_to_date(p_calculation_date);
2155:
2156: -- as business group id is not passed as a parameter use the fnd_global value
2157: -- this implies that concurrent process must be run from within apps
2158: -- and cannot be run from sql unless an explicit apps initialization is done

Line 2206: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)

2202: );
2203: /* Corrected and added as a part of Bug#10239082 Starts
2204: fnd_file.put_line
2205: (fnd_file.log
2206: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2207: ); */
2208: fnd_file.put_line
2209: (fnd_file.log
2210: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date, calendar_aware => FND_DATE.calendar_aware_alt)

Line 2210: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date, calendar_aware => FND_DATE.calendar_aware_alt)

2206: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2207: ); */
2208: fnd_file.put_line
2209: (fnd_file.log
2210: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date, calendar_aware => FND_DATE.calendar_aware_alt)
2211: );
2212: /* Corrected and added as a part of Bug#10239082 Ends */
2213:
2214: /* if P_Payroll_ID IS NULL AND P_Contract_Type IS NULL then