APPS.MSC_CL_PURGE_STAGING dependencies on FND_PROFILE

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

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

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

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

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

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

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

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

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

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