APPS.MSC_CL_OTHER_ODS_LOAD dependencies on FND_PROFILE

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

466: lb_SR_INSTANCE_ID NumTblTyp;
467: lb_category_name CharTblTyp;
468: lb_SR_ASSIGNMENT_INSTANCE_ID NumTblTyp;
469: lb_FetchComplete Boolean;
470: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
471:
472:
473: lv_control_flag NUMBER;
474: lv_msc_tp_coll_window NUMBER;

Line 1461: lv_msc_tp_coll_window:= NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);

1457: IF (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS107) OR (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS110) THEN
1458: lv_msc_tp_coll_window := 0;
1459: ELSE
1460: BEGIN
1461: lv_msc_tp_coll_window:= NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);
1462: EXCEPTION
1463: WHEN OTHERS THEN
1464: lv_msc_tp_coll_window := 0;
1465: END ;

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

1473: -- 4. MSC_REGION_SITES
1474: -- 5. MSC_CARRIER_SERVICES
1475:
1476: SELECT
1477: decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
1478: INTO lv_control_flag
1479: FROM dual;
1480:
1481: /*

Line 5967: v_pbs := TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));

5963: v_pbs number;
5964:
5965: BEGIN
5966:
5967: v_pbs := TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
5968:
5969: Loop
5970: Delete from MSC_CURRENCY_CONVERSIONS
5971: where conv_date > (sysdate + MSC_CL_OTHER_PULL.G_MSC_FUTURE_DAYS) or conv_date < (sysdate - MSC_CL_OTHER_PULL.G_MSC_PAST_DAYS)