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

Line 2435: --value 2 for calendar_aware parameter means FND_DATE.calendar_aware_alt

2431: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2432: || p_batch_id || ', ';
2433: IF l_eff_date_intf IS NOT NULL THEN
2434: --five lines below changed for calendar internationalization project
2435: --value 2 for calendar_aware parameter means FND_DATE.calendar_aware_alt
2436: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf, 2) || ''' , ' ;
2437: ELSIF l_new_eff_date_intf IS NOT NULL THEN
2438: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_new_eff_date_intf, 2) || ''' , ' ;
2439: ELSE

Line 2436: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf, 2) || ''' , ' ;

2432: || p_batch_id || ', ';
2433: IF l_eff_date_intf IS NOT NULL THEN
2434: --five lines below changed for calendar internationalization project
2435: --value 2 for calendar_aware parameter means FND_DATE.calendar_aware_alt
2436: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf, 2) || ''' , ' ;
2437: ELSIF l_new_eff_date_intf IS NOT NULL THEN
2438: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_new_eff_date_intf, 2) || ''' , ' ;
2439: ELSE
2440: l_eff_sql := l_eff_sql || ' NULL , ' ;

Line 2438: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_new_eff_date_intf, 2) || ''' , ' ;

2434: --five lines below changed for calendar internationalization project
2435: --value 2 for calendar_aware parameter means FND_DATE.calendar_aware_alt
2436: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf, 2) || ''' , ' ;
2437: ELSIF l_new_eff_date_intf IS NOT NULL THEN
2438: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_new_eff_date_intf, 2) || ''' , ' ;
2439: ELSE
2440: l_eff_sql := l_eff_sql || ' NULL , ' ;
2441: END IF;
2442:

Line 2444: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_pdh, 2) || '''';

2440: l_eff_sql := l_eff_sql || ' NULL , ' ;
2441: END IF;
2442:
2443: IF l_eff_date_pdh IS NOT NULL THEN
2444: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_pdh, 2) || '''';
2445: ELSE
2446: l_eff_sql := l_eff_sql || ' NULL ' ;
2447: END IF;
2448: l_eff_sql := l_eff_sql || ' FROM DUAL '

Line 2455: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_intf, 2) || ''', ' ;

2451: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2452: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2453: || p_batch_id || ', ' ;
2454: IF l_dis_date_intf IS NOT NULL THEN
2455: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_intf, 2) || ''', ' ;
2456: ELSE
2457: l_eff_sql := l_eff_sql || ' NULL , ' ;
2458: END IF;
2459: IF l_dis_date_pdh IS NOT NULL THEN

Line 2460: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_pdh, 2) || '''';

2456: ELSE
2457: l_eff_sql := l_eff_sql || ' NULL , ' ;
2458: END IF;
2459: IF l_dis_date_pdh IS NOT NULL THEN
2460: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_pdh, 2) || '''';
2461: ELSE
2462: l_eff_sql := l_eff_sql || ' NULL ';
2463: END IF;
2464: l_eff_sql := l_eff_sql || ' FROM DUAL ';