APPS.MSC_PURGE_LID dependencies on FND_PROFILE

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

191: OBJECT_NAME => p_table_name);
192:
193: ELSE
194:
195: lv_pbs:= TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
196:
197: IF p_plan_id IS NULL THEN
198:
199: v_sql_stmt := 02;

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

360: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_LID_TABLE:'||p_lid_table);
361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
362:
363: lv_where_str := p_where_str;
364: lv_pbs:= TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
365:
366: v_sql_stmt := 01;
367: lv_sql_stmt := ' SELECT COUNT(*) '
368: ||' FROM '||p_lid_table||' lid'

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

644:
645:
646: -- ===== Switch on/ off debug based on MRP: Debug Profile=====--
647:
648: v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
649:
650:
651: --======= Check the Status of the instance.
652: --======= Delete only if the staging table is empty

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

1771: END;
1772:
1773:
1774:
1775: row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
1776:
1777: --
1778:
1779: -- Generate List of Instances passed --

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

2177: END;
2178:
2179:
2180:
2181: row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2182:
2183: --
2184:
2185: -- Generate List of Instances passed --

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

2297: AND view_application_id = 700
2298:
2299: AND language = userenv('lang')
2300:
2301: AND attribute5 = DECODE(fnd_profile.value('MSC_SHARE_PARTITIONS'),'Y',attribute5,'U') -- Unpartitioned table
2302:
2303: AND a.ATTRIBUTE12 = 'Y' -- Column PLAN_ID Present
2304:
2305: AND NVL(attribute13,'-1')<>'G')