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 2291: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf) || ''' , ' ;

2287: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2288: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2289: || p_batch_id || ', ';
2290: IF l_eff_date_intf IS NOT NULL THEN
2291: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf) || ''' , ' ;
2292: ELSIF l_new_eff_date_intf IS NOT NULL THEN
2293: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_new_eff_date_intf) || ''' , ' ;
2294: ELSE
2295: l_eff_sql := l_eff_sql || ' NULL , ' ;

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

2289: || p_batch_id || ', ';
2290: IF l_eff_date_intf IS NOT NULL THEN
2291: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf) || ''' , ' ;
2292: ELSIF l_new_eff_date_intf IS NOT NULL THEN
2293: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_new_eff_date_intf) || ''' , ' ;
2294: ELSE
2295: l_eff_sql := l_eff_sql || ' NULL , ' ;
2296: END IF;
2297:

Line 2299: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_pdh) || '''';

2295: l_eff_sql := l_eff_sql || ' NULL , ' ;
2296: END IF;
2297:
2298: IF l_eff_date_pdh IS NOT NULL THEN
2299: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_pdh) || '''';
2300: ELSE
2301: l_eff_sql := l_eff_sql || ' NULL ' ;
2302: END IF;
2303: l_eff_sql := l_eff_sql || ' FROM DUAL '

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

2306: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2307: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2308: || p_batch_id || ', ' ;
2309: IF l_dis_date_intf IS NOT NULL THEN
2310: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_intf) || ''', ' ;
2311: ELSE
2312: l_eff_sql := l_eff_sql || ' NULL , ' ;
2313: END IF;
2314: IF l_dis_date_pdh IS NOT NULL THEN

Line 2315: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_pdh) || '''';

2311: ELSE
2312: l_eff_sql := l_eff_sql || ' NULL , ' ;
2313: END IF;
2314: IF l_dis_date_pdh IS NOT NULL THEN
2315: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_pdh) || '''';
2316: ELSE
2317: l_eff_sql := l_eff_sql || ' NULL ';
2318: END IF;
2319: l_eff_sql := l_eff_sql || ' FROM DUAL ';