APPS.MSC_PURGE_LID dependencies on FND_PROFILE

Line 18: lv_pbs NUMBER := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

14: v_request_id NUMBER;
15: v_prog_appl_id NUMBER;
16: v_program_id NUMBER;
17: v_applsys_schema VARCHAR2(32);
18: lv_pbs NUMBER := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
19:
20: TYPE NmTblTyp IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
21:
22:

Line 635: v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

631:
632:
633: -- ===== Switch on/ off debug based on MRP: Debug Profile=====--
634:
635: v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
636:
637:
638: --======= Check the Status of the instance.
639: --======= Delete only if the staging table is empty

Line 1817: row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));

1813: END;
1814:
1815:
1816:
1817: row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
1818:
1819: --
1820:
1821: -- Generate List of Instances passed --

Line 2223: row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));

2219: END;
2220:
2221:
2222:
2223: row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2224:
2225: --
2226:
2227: -- Generate List of Instances passed --

Line 2343: AND attribute5 = DECODE(fnd_profile.value('MSC_SHARE_PARTITIONS'),'Y',attribute5,'U') -- Unpartitioned table

2339: AND view_application_id = 700
2340:
2341: AND language = userenv('lang')
2342:
2343: AND attribute5 = DECODE(fnd_profile.value('MSC_SHARE_PARTITIONS'),'Y',attribute5,'U') -- Unpartitioned table
2344:
2345: AND a.ATTRIBUTE12 = 'Y' -- Column PLAN_ID Present
2346:
2347: AND NVL(attribute13,'-1')<>'G')