APPS.MSC_SNAPSHOT_PK dependencies on FND_PROFILE

Line 327: lv_bkt_ref_calendar varchar2(14) := fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR');

323: l_weekly_buckets Number;
324:
325: j NUMBER;
326:
327: lv_bkt_ref_calendar varchar2(14) := fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR');
328: lv_bkt_ref_instance number;
329: BEGIN
330:
331: -- IF mrdebug = TRUE THEN

Line 480: select nvl(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), tp.calendar_code),

476: FROM msc_plans
477: WHERE plan_id = p_plan_id;
478:
479: -- select bucket reference calendar
480: select nvl(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), tp.calendar_code),
481: tp.calendar_exception_set_id ,
482: decode(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), NULL, tp.sr_instance_id, mcd.sr_instance_id)
483: into m_calendar_code , m_cal_exception_set_id , m_sr_instance_id
484: from msc_plans mp,

Line 482: decode(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), NULL, tp.sr_instance_id, mcd.sr_instance_id)

478:
479: -- select bucket reference calendar
480: select nvl(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), tp.calendar_code),
481: tp.calendar_exception_set_id ,
482: decode(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), NULL, tp.sr_instance_id, mcd.sr_instance_id)
483: into m_calendar_code , m_cal_exception_set_id , m_sr_instance_id
484: from msc_plans mp,
485: msc_trading_partners tp,
486: msc_calendar_dates mcd

Line 492: and mcd.calendar_code = nvl(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), tp.calendar_code);

488: and tp.partner_type = 3
489: and tp.sr_instance_id = mp.sr_instance_id
490: and mp.organization_id = tp.sr_tp_id
491: and mcd.calendar_date = trunc(sysdate)
492: and mcd.calendar_code = nvl(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), tp.calendar_code);
493:
494:
495: IF l_daily_cutoff_date IS NOT NULL THEN
496: -- insert the daily time buckets

Line 1124: decode(nvl(fnd_profile.value('MSO_ENABLE_DECISION_RULES'),'N'),

1120: where plan_id = p_plan_id;
1121:
1122: IF lv_p_plan_so = 1 THEN
1123: select decode(optimize_flag,1,1,
1124: decode(nvl(fnd_profile.value('MSO_ENABLE_DECISION_RULES'),'N'),
1125: 'Y',1,'Yes',1,'YES',1,0))
1126: into lv_p_plan_so
1127: from msc_plans
1128: where plan_id = p_plan_id;

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

1901: lb_planner_code Char3TblTyp;
1902: lb_plng_excp_set Char3TblTyp;
1903: lb_revision Char4TblTyp;
1904:
1905: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
1906: lv_plan_partition_exists Number := 0;
1907:
1908: CURSOR items_for_update
1909: IS