eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SNAPSHOT_PK dependencies on MSC_CALENDAR

Line 167: msc_calendar.next_work_day(-1*p_org_id,

163:
164:
165: IF l_weekly_cutoff_bucket <> 0 THEN
166: p_daily_cutoff_date :=
167: msc_calendar.next_work_day(-1*p_org_id,
168: p_instance_id,
169: msc_calendar.type_weekly_bucket,
170: l_bucket_end_date + 1
171: );

Line 169: msc_calendar.type_weekly_bucket,

165: IF l_weekly_cutoff_bucket <> 0 THEN
166: p_daily_cutoff_date :=
167: msc_calendar.next_work_day(-1*p_org_id,
168: p_instance_id,
169: msc_calendar.type_weekly_bucket,
170: l_bucket_end_date + 1
171: );
172:
173: p_daily_cutoff_date := p_daily_cutoff_date -1;

Line 183: msc_calendar.next_work_day(-1*p_org_id,

179: --LOG_MESSAGE('p_daily_cutoff_date #1 = '||p_daily_cutoff_date||' org '||p_org_id||' inst '||p_instance_id||' l_bucket_end_date '||l_bucket_end_date);
180: END IF;
181: ELSIF l_period_cutoff_bucket <> 0 THEN
182: p_daily_cutoff_date :=
183: msc_calendar.next_work_day(-1*p_org_id,
184: p_instance_id,
185: msc_calendar.type_monthly_bucket,
186: l_bucket_end_date + 1
187: );

Line 185: msc_calendar.type_monthly_bucket,

181: ELSIF l_period_cutoff_bucket <> 0 THEN
182: p_daily_cutoff_date :=
183: msc_calendar.next_work_day(-1*p_org_id,
184: p_instance_id,
185: msc_calendar.type_monthly_bucket,
186: l_bucket_end_date + 1
187: );
188: p_daily_cutoff_date := p_daily_cutoff_date -1;
189: -- The above call gives the period start date after l_bucket_end_date

Line 221: msc_calendar.next_work_day(-1*p_org_id,

217:
218: IF l_period_cutoff_bucket <> 0 THEN
219: -- This needs to be changed to be TYPE_PERIOD_BUCKET instead of months
220: p_weekly_cutoff_date :=
221: msc_calendar.next_work_day(-1*p_org_id,
222: p_instance_id,
223: msc_calendar.type_monthly_bucket,
224: l_bucket_end_date + 1
225: );

Line 223: msc_calendar.type_monthly_bucket,

219: -- This needs to be changed to be TYPE_PERIOD_BUCKET instead of months
220: p_weekly_cutoff_date :=
221: msc_calendar.next_work_day(-1*p_org_id,
222: p_instance_id,
223: msc_calendar.type_monthly_bucket,
224: l_bucket_end_date + 1
225: );
226:
227: p_weekly_cutoff_date := p_weekly_cutoff_date -1;

Line 250: msc_calendar.next_work_day(-1*p_org_id,

246: END IF;
247:
248: FOR j IN 1..l_period_cutoff_bucket loop
249: p_period_cutoff_date :=
250: msc_calendar.next_work_day(-1*p_org_id,
251: p_instance_id,
252: msc_calendar.type_monthly_bucket,
253: l_bucket_end_date + 1
254: );

Line 252: msc_calendar.type_monthly_bucket,

248: FOR j IN 1..l_period_cutoff_bucket loop
249: p_period_cutoff_date :=
250: msc_calendar.next_work_day(-1*p_org_id,
251: p_instance_id,
252: msc_calendar.type_monthly_bucket,
253: l_bucket_end_date + 1
254: );
255: l_bucket_end_date := p_period_cutoff_date;
256: IF mrdebug = TRUE THEN

Line 359: msc_calendar_dates mc

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

Line 375: msc_calendar_dates mc

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

Line 415: from msc_calendar_dates

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;

Line 486: msc_calendar_dates mcd

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

Line 510: MSC_CALENDAR_DATES cal

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

Line 1608: from msc_calendar_dates cal1,

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

Line 1609: msc_calendar_dates cal2

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

Line 1622: msc_calendar_dates cal1,

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

Line 1623: msc_calendar_dates cal2

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

Line 1683: msc_calendar_dates cal1

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

Line 1705: msc_calendar_dates cal1

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