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 612: fnd_date.date_to_canonical(g_epFd_earliest_possible_date));

608: debug_enter(l_proc_name);
609: debug('p_assignment_id:'||p_assignment_id);
610: debug('g_epFd_assignment_id:'||g_epFd_assignment_id);
611: debug('g_epFd_earliest_possible_date:'||
612: fnd_date.date_to_canonical(g_epFd_earliest_possible_date));
613: IF p_reload_cache = TRUE THEN
614: debug('p_reload_cache:TRUE');
615: END IF;
616: IF p_reload_cache = FALSE THEN

Line 661: fnd_date.date_to_canonical(g_epFd_earliest_possible_date));

657:
658: IF g_debug THEN
659: debug('g_epFd_assignment_id:'||g_epFd_assignment_id);
660: debug('g_epFd_earliest_possible_date:'||
661: fnd_date.date_to_canonical(g_epFd_earliest_possible_date));
662: debug_exit(l_proc_name);
663: END IF;
664:
665: RETURN g_epFd_earliest_possible_date;

Line 938: fnd_date.date_to_canonical(p_calculation_date)

934: IF g_debug THEN
935: debug_enter(l_proc_name);
936: debug('p_assignment_id:'||p_assignment_id);
937: debug('p_calculation_date:'||
938: fnd_date.date_to_canonical(p_calculation_date)
939: );
940: debug('p_fte_value:'||p_fte_value);
941: END IF;
942:

Line 1003: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)

999: l_effective_fte_row.assignment_budget_value_id);
1000: debug('l_effective_fte_row.object_version_number:'||
1001: l_effective_fte_row.object_version_number);
1002: debug('l_effective_fte_row.effective_start_date:'||
1003: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)
1004: );
1005: debug('l_effective_fte_row.effective_end_date:'||
1006: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)
1007: );

Line 1006: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)

1002: debug('l_effective_fte_row.effective_start_date:'||
1003: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)
1004: );
1005: debug('l_effective_fte_row.effective_end_date:'||
1006: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)
1007: );
1008: debug('l_effective_fte_row.value:'||l_effective_fte_row.value);
1009: END IF;
1010:

Line 1179: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)

1175: l_effective_fte_row.assignment_budget_value_id);
1176: debug('l_effective_fte_row.object_version_number:'||
1177: l_effective_fte_row.object_version_number);
1178: debug('l_effective_fte_row.effective_start_date:'||
1179: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)
1180: );
1181: debug('l_effective_fte_row.effective_end_date:'||
1182: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)
1183: );

Line 1182: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)

1178: debug('l_effective_fte_row.effective_start_date:'||
1179: fnd_date.date_to_canonical(l_effective_fte_row.effective_start_date)
1180: );
1181: debug('l_effective_fte_row.effective_end_date:'||
1182: fnd_date.date_to_canonical(l_effective_fte_row.effective_end_date)
1183: );
1184: debug('l_effective_fte_row.value:'||l_effective_fte_row.value);
1185: debug('ROUND(p_fte_value,5):'||ROUND(p_fte_value,5));
1186: debug_exit(l_proc_name);

Line 1311: ,fnd_date.date_to_displaydate(p_effective_date)

1307: THEN
1308: fnd_message.set_name('PQP','PQP_230456_FTE_NO_ASG_DETAILS');
1309: fnd_message.set_token
1310: ('EFFECTIVEDATE'
1311: ,fnd_date.date_to_displaydate(p_effective_date)
1312: );
1313: fnd_message.raise_error;
1314: END IF;
1315: END IF;

Line 1477: ,fnd_date.date_to_displaydate(p_effective_date)

1473: );
1474:
1475: fnd_message.set_token
1476: ('EFFECTIVEDATE'
1477: ,fnd_date.date_to_displaydate(p_effective_date)
1478: );
1479: fnd_message.raise_error;
1480: ELSE
1481: fnd_message.set_name('PQP','PQP_230113_AAT_MISSING_CONTRCT');

Line 1484: ,fnd_date.date_to_displaydate(p_effective_date)

1480: ELSE
1481: fnd_message.set_name('PQP','PQP_230113_AAT_MISSING_CONTRCT');
1482: fnd_message.set_token
1483: ('EFFECTIVEDATE'
1484: ,fnd_date.date_to_displaydate(p_effective_date)
1485: );
1486: fnd_message.raise_error;
1487: END IF;
1488: END IF;

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

1528:
1529: IF g_debug THEN
1530: debug_enter(l_proc_name);
1531: debug('p_assignment_id:'||p_assignment_id);
1532: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1533: END IF;
1534:
1535: -- fetch the relevant assignment details normal hours and contract
1536:

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

1610:
1611: IF g_debug THEN
1612: hr_utility.trace(
1613: 'Updated, '||p_assignment_id||', '||
1614: fnd_date.date_to_displaydate(p_effective_date)||', '||
1615: l_FTE_value||', '||
1616: l_assignment_details.normal_hours||', '||
1617: -- l_assignment_details.contract_type||', '||
1618: l_contract_details.annual_hours||', '||

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

1757:
1758: IF g_debug THEN
1759: debug_enter(l_proc_name);
1760: debug('p_assignment_id:'||p_assignment_id);
1761: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1762: IF g_is_concurrent_program_run = TRUE THEN
1763: debug('g_is_concurrent_program_run:TRUE');
1764: END IF;
1765: IF g_is_concurrent_program_run = FALSE THEN

Line 1863: debug('l_effective_date:'||fnd_date.date_to_displaydate(l_effective_date));

1859:
1860: END IF; -- IF NOT g_is_concurrent_program_run
1861:
1862: IF g_debug THEN
1863: debug('l_effective_date:'||fnd_date.date_to_displaydate(l_effective_date));
1864: END IF;
1865:
1866: IF l_effective_date IS NOT NULL
1867: THEN

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

2084:
2085: fnd_file.put_line
2086: (fnd_file.log
2087: ,'Calculate FTE For Assignments - '||
2088: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2089: );
2090:
2091: -- Set the standard concurrent program out paramters
2092: ERRBUF:= NULL;

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

2095: -- In concurrent programs, the date is passed in as a string in canonical format. We must convert this
2096: -- to a date
2097:
2098: --l_calculation_date := to_date(substr(p_calculation_date, 1, 10), 'YYYY/MM/DD');
2099: l_calculation_date := fnd_date.canonical_to_date(p_calculation_date);
2100:
2101: -- as business group id is not passed as a parameter use the fnd_global value
2102: -- this implies that concurrent process must be run from within apps
2103: -- and cannot be run from sql unless an explicit apps initialization is done

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

2147: );
2148:
2149: fnd_file.put_line
2150: (fnd_file.log
2151: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2152: );
2153:
2154:
2155: /* if P_Payroll_ID IS NULL AND P_Contract_Type IS NULL then