[Home] [Help]
355: select min(cal.week_start_date)
356: into l_curr_start_date
357: from msc_cal_week_start_dates cal,
358: msc_trading_partners tp,
359: msc_calendar_dates mc
360: where cal.exception_set_id = tp.calendar_exception_set_id
361: and mc.exception_set_id = tp.calendar_exception_set_id
362: and cal.calendar_code = tp.calendar_code
363: and mc.calendar_code = tp.calendar_code
371: ELSE
372: select min(cal.week_start_date)
373: into l_curr_start_date
374: from msc_cal_week_start_dates cal,
375: msc_calendar_dates mc
376: where cal.exception_set_id = mc.exception_set_id
377: and cal.calendar_code = mc.calendar_code
378: and cal.sr_instance_id = mc.sr_instance_id
379: and cal.week_start_date >= mc.next_date
411:
412: IF (lv_bkt_ref_calendar is not null) then
413: select sr_instance_id
414: into lv_bkt_ref_instance
415: from msc_calendar_dates
416: where calendar_code = lv_bkt_ref_calendar
417: and calendar_date = trunc(sysdate)
418: and exception_set_id = -1;
419:
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
488: where mp.plan_id = p_plan_id
489: and tp.partner_type = 3
490: and tp.sr_instance_id = mp.sr_instance_id
491: and mp.organization_id = tp.sr_tp_id
508: l_msc_plan_buckets.bkt_end_date,
509: l_msc_plan_buckets.bucket_type,
510: l_msc_plan_buckets.days_in_bkt
511: FROM
512: MSC_CALENDAR_DATES cal
513: WHERE
514: cal.sr_instance_id = m_sr_instance_id
515: AND cal.calendar_code = m_calendar_code
516: AND cal.exception_set_id = m_cal_exception_set_id
1630: END IF;
1631:
1632: select to_number(to_char(cal2.calendar_date,'J'))
1633: into l_calendar_date
1634: from msc_calendar_dates cal1,
1635: msc_calendar_dates cal2
1636: where cal1.calendar_code = p_calendar_code
1637: and cal1.calendar_date = to_date(l_bkt_end_date3,'J')
1638: and cal1.exception_set_id = -1
1631:
1632: select to_number(to_char(cal2.calendar_date,'J'))
1633: into l_calendar_date
1634: from msc_calendar_dates cal1,
1635: msc_calendar_dates cal2
1636: where cal1.calendar_code = p_calendar_code
1637: and cal1.calendar_date = to_date(l_bkt_end_date3,'J')
1638: and cal1.exception_set_id = -1
1639: and cal1.sr_instance_id = p_ss_instance_id
1644: ELSE
1645: select to_number(to_char(cal2.calendar_date,'J'))
1646: into l_calendar_date
1647: from msc_plan_buckets org_bkt,
1648: msc_calendar_dates cal1,
1649: msc_calendar_dates cal2
1650: where org_bkt.plan_id = p_plan_id
1651: and org_bkt.organization_id = p_owning_org_id
1652: and org_bkt.sr_instance_id = p_owning_instance_id
1645: select to_number(to_char(cal2.calendar_date,'J'))
1646: into l_calendar_date
1647: from msc_plan_buckets org_bkt,
1648: msc_calendar_dates cal1,
1649: msc_calendar_dates cal2
1650: where org_bkt.plan_id = p_plan_id
1651: and org_bkt.organization_id = p_owning_org_id
1652: and org_bkt.sr_instance_id = p_owning_instance_id
1653: and org_bkt.curr_flag = 1
1705: select to_number(to_char(cal1.prior_date,'J'))
1706: into l_calendar_date
1707: from msc_plan_buckets own_org_bkt,
1708: msc_plan_buckets org_bkt,
1709: msc_calendar_dates cal1
1710: where own_org_bkt.plan_id = p_plan_id
1711: and own_org_bkt.organization_id = p_owning_org_id
1712: and own_org_bkt.sr_instance_id = p_owning_instance_id
1713: and own_org_bkt.curr_flag = 1
1727: ELSE
1728: select to_number(to_char(cal1.next_date,'J'))
1729: into l_calendar_date
1730: from msc_plan_buckets org_bkt,
1731: msc_calendar_dates cal1
1732: where org_bkt.plan_id = p_plan_id
1733: and org_bkt.organization_id = p_owning_org_id
1734: and org_bkt.sr_instance_id = p_owning_instance_id
1735: and org_bkt.curr_flag = 1