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 481: select nvl(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), tp.calendar_code),

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

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

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

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

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

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

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

Line 2011: lv_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

2007:
2008: LOG_MESSAGE('Begin Snapshot: Auto Release Forecast Metrics ');
2009:
2010: --Fetch the profile values
2011: lv_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
2012: lv_parallel_run := fnd_profile.value('MSC_PARALLEL_PLAN_RUN');
2013: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', lv_dummy1, lv_dummy2, lv_msc_schema);
2014:
2015: -- If share partitions or parallel run, use the delete coomand

Line 2012: lv_parallel_run := fnd_profile.value('MSC_PARALLEL_PLAN_RUN');

2008: LOG_MESSAGE('Begin Snapshot: Auto Release Forecast Metrics ');
2009:
2010: --Fetch the profile values
2011: lv_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
2012: lv_parallel_run := fnd_profile.value('MSC_PARALLEL_PLAN_RUN');
2013: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', lv_dummy1, lv_dummy2, lv_msc_schema);
2014:
2015: -- If share partitions or parallel run, use the delete coomand
2016: -- Else use the truncate partition

Line 2102: nvl(TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

2098: lb_sr_category_id NumTblTyp;
2099: lb_sr_instance_id NumTblTyp;
2100:
2101: ln_rows_to_fetch Number :=
2102: nvl(TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
2103: lv_plan_partition_exists Number := 0;
2104:
2105: CURSOR items_category_update
2106: IS

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

2215: lb_planner_code Char3TblTyp;
2216: lb_plng_excp_set Char3TblTyp;
2217: lb_revision Char4TblTyp;
2218:
2219: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
2220: lv_plan_partition_exists Number := 0;
2221:
2222: CURSOR items_for_update
2223: IS