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.MSC_CL_BOM_ODS_LOAD dependencies on FND_PROFILE

Line 1587: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

1583: lv_sql_ins VARCHAR2(6000);
1584:
1585: lb_FetchComplete Boolean;
1586: lb_refresh_failed Boolean:= FALSE;
1587: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
1588:
1589: TYPE CharTblTyp IS TABLE OF VARCHAR2(30);
1590: TYPE CharTblTyp1 IS TABLE OF VARCHAR2(300);
1591: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 1972: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

1968: lv_sql_ins vARCHAR2(6000);
1969:
1970: lb_FetchComplete Boolean;
1971: lb_refresh_failed Boolean:= FALSE;
1972: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
1973:
1974:
1975: TYPE CharTblTyp IS TABLE OF VARCHAR2(30);
1976: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 2750: lv_pbs:= TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));

2746:
2747: p_instance_id := MSC_CL_COLLECTION.v_instance_id;
2748: p_table_name := 'MSC_DEPARTMENT_RESOURCES';
2749:
2750: lv_pbs:= TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2751:
2752: lv_sql_stmt:= 'SELECT COUNT(*)'
2753: ||' FROM '||p_table_name||' mdr, msc_trading_partners mtp'
2754: ||' WHERE mdr.SR_INSTANCE_ID= :p_instance_id'