[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:
419: END IF;
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
487: where mp.plan_id = p_plan_id
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
506: l_msc_plan_buckets.bkt_end_date,
507: l_msc_plan_buckets.bucket_type,
508: l_msc_plan_buckets.days_in_bkt
509: FROM
510: MSC_CALENDAR_DATES cal
511: WHERE
512: cal.sr_instance_id = m_sr_instance_id
513: AND cal.calendar_code = m_calendar_code
514: AND cal.exception_set_id = m_cal_exception_set_id
1604: END IF;
1605:
1606: select to_number(to_char(cal2.calendar_date,'J'))
1607: into l_calendar_date
1608: from msc_calendar_dates cal1,
1609: msc_calendar_dates cal2
1610: where cal1.calendar_code = p_calendar_code
1611: and cal1.calendar_date = to_date(l_bkt_end_date3,'J')
1612: and cal1.exception_set_id = -1
1605:
1606: select to_number(to_char(cal2.calendar_date,'J'))
1607: into l_calendar_date
1608: from msc_calendar_dates cal1,
1609: msc_calendar_dates cal2
1610: where cal1.calendar_code = p_calendar_code
1611: and cal1.calendar_date = to_date(l_bkt_end_date3,'J')
1612: and cal1.exception_set_id = -1
1613: and cal1.sr_instance_id = p_ss_instance_id
1618: ELSE
1619: select to_number(to_char(cal2.calendar_date,'J'))
1620: into l_calendar_date
1621: from msc_plan_buckets org_bkt,
1622: msc_calendar_dates cal1,
1623: msc_calendar_dates cal2
1624: where org_bkt.plan_id = p_plan_id
1625: and org_bkt.organization_id = p_owning_org_id
1626: and org_bkt.sr_instance_id = p_owning_instance_id
1619: select to_number(to_char(cal2.calendar_date,'J'))
1620: into l_calendar_date
1621: from msc_plan_buckets org_bkt,
1622: msc_calendar_dates cal1,
1623: msc_calendar_dates cal2
1624: where org_bkt.plan_id = p_plan_id
1625: and org_bkt.organization_id = p_owning_org_id
1626: and org_bkt.sr_instance_id = p_owning_instance_id
1627: and org_bkt.curr_flag = 1
1679: select to_number(to_char(cal1.prior_date,'J'))
1680: into l_calendar_date
1681: from msc_plan_buckets own_org_bkt,
1682: msc_plan_buckets org_bkt,
1683: msc_calendar_dates cal1
1684: where own_org_bkt.plan_id = p_plan_id
1685: and own_org_bkt.organization_id = p_owning_org_id
1686: and own_org_bkt.sr_instance_id = p_owning_instance_id
1687: and own_org_bkt.curr_flag = 1
1701: ELSE
1702: select to_number(to_char(cal1.next_date,'J'))
1703: into l_calendar_date
1704: from msc_plan_buckets org_bkt,
1705: msc_calendar_dates cal1
1706: where org_bkt.plan_id = p_plan_id
1707: and org_bkt.organization_id = p_owning_org_id
1708: and org_bkt.sr_instance_id = p_owning_instance_id
1709: and org_bkt.curr_flag = 1