APPS.MSC_CL_PURGE_STAGING dependencies on FND_PROFILE

Line 59: v_batch_size := TO_NUMBER(NVL(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'),75000));

55:
56:
57: lv_instance_code := p_instance_code;
58: lv_p_del_rej_rec :=p_del_rej_rec;
59: v_batch_size := TO_NUMBER(NVL(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'),75000));
60:
61:
62: OPEN table_names;
63: LOOP

Line 327: SELECT DECODE(nvl(FND_PROFILE.VALUE('MRP_DEBUG'),'N'),'Y',1,2),

323: ELSE -- IF ( table_names%ROWCOUNT = 0 ) THEN
324:
325:
326: CLOSE table_names;
327: SELECT DECODE(nvl(FND_PROFILE.VALUE('MRP_DEBUG'),'N'),'Y',1,2),
328: DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'No'),'Yes',1,2)
329: INTO v_debug,lv_trunc_profile
330: FROM dual;
331:

Line 328: DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'No'),'Yes',1,2)

324:
325:
326: CLOSE table_names;
327: SELECT DECODE(nvl(FND_PROFILE.VALUE('MRP_DEBUG'),'N'),'Y',1,2),
328: DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'No'),'Yes',1,2)
329: INTO v_debug,lv_trunc_profile
330: FROM dual;
331:
332:

Line 1954: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)

1950:
1951: BEGIN
1952: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'inside purge staging table ');
1953:
1954: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
1955: INTO lv_control_flag
1956: FROM dual;
1957:
1958: IF p_instance_id IS NOT NULL THEN

Line 1965: lv_pbs := nvl(TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')), 2000);

1961: FROM msc_apps_instances
1962: WHERE instance_id= p_instance_id;
1963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'instance_type='||lv_instance_type);
1964: END IF;
1965: lv_pbs := nvl(TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')), 2000);
1966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'before loop');
1967: FOR c_rec IN c_tab_list
1968: LOOP
1969: