APPS.MSC_CL_BOM_ODS_LOAD dependencies on FND_PROFILE

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

1602: lv_sql_ins VARCHAR2(6000);
1603:
1604: lb_FetchComplete Boolean;
1605: lb_refresh_failed Boolean:= FALSE;
1606: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
1607:
1608: TYPE CharTblTyp IS TABLE OF VARCHAR2(30);
1609: TYPE CharTblTyp1 IS TABLE OF VARCHAR2(300);
1610: TYPE NumTblTyp IS TABLE OF NUMBER;

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

1987: lv_sql_ins vARCHAR2(6000);
1988:
1989: lb_FetchComplete Boolean;
1990: lb_refresh_failed Boolean:= FALSE;
1991: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
1992:
1993:
1994: TYPE CharTblTyp IS TABLE OF VARCHAR2(30);
1995: TYPE NumTblTyp IS TABLE OF NUMBER;

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

2765:
2766: p_instance_id := MSC_CL_COLLECTION.v_instance_id;
2767: p_table_name := 'MSC_DEPARTMENT_RESOURCES';
2768:
2769: lv_pbs:= TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2770:
2771: lv_sql_stmt:= 'SELECT COUNT(*)'
2772: ||' FROM '||p_table_name||' mdr, msc_trading_partners mtp'
2773: ||' WHERE mdr.SR_INSTANCE_ID= :p_instance_id'