APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on FND_PROFILE

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

1689: lv_sql_stmt VARCHAR2(5000);
1690: lv_supply_tbl VARCHAR2(30);
1691: lv_supply_stmt VARCHAR2(5000);
1692: lb_FetchComplete Boolean;
1693: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
1694:
1695:
1696: TYPE CharTblTyp IS TABLE OF VARCHAR2(70);
1697: TYPE NumTblTyp IS TABLE OF NUMBER;

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

2384: PROCEDURE LOAD_SALES_ORDER IS
2385:
2386: lv_tbl VARCHAR2(30);
2387: lv_supply_tbl VARCHAR2(30);
2388: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
2389: lv_exchange_mode NUMBER:= MSC_UTIL.SYS_NO;
2390: lv_sql_stmt VARCHAR2(32767);
2391: lv_sql1_1 VARCHAR2(4000);
2392: lv_sql1_2 VARCHAR2(1000);