APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_CALENDAR

Line 178: FROM msc_calendar_dates cal,

174: -- This cursor selects the dates for the buckets.
175: -- -------------------------------------------------
176: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
177: SELECT cal.calendar_date
178: FROM msc_calendar_dates cal,
179: msc_trading_partners tp
180: WHERE tp.sr_tp_id = G_org_id
181: AND tp.sr_instance_id = G_inst_id
182: AND tp.calendar_exception_set_id = cal.exception_set_id

Line 265: msc_calendar_dates dates

261: gmp_pdr_items_gtmp gpi,
262: msc_trading_partners param,
263: -- msc_system_items msi,
264: msc_supplies rec,
265: msc_calendar_dates dates
266: WHERE /*(arg_res_level = 1
267: OR (arg_res_level = 2
268: AND rec.project_id is NULL)
269: OR (DECODE(arg_res_level,

Line 443: msc_calendar_dates dates

439: FROM -- msc_form_query list,
440: gmp_pdr_items_gtmp gpi,
441: msc_trading_partners param,
442: msc_demands mgr,
443: msc_calendar_dates dates
444: WHERE /*(arg_res_level = 1
445: OR (arg_res_level = 2
446: AND mgr.project_id is NULL)
447: OR (DECODE(arg_res_level,

Line 575: msc_calendar_dates dates

571: FROM --msc_form_query list,
572: gmp_pdr_items_gtmp gpi,
573: msc_trading_partners param,
574: msc_demands mgr,
575: msc_calendar_dates dates
576: WHERE /*(arg_res_level = 1
577: OR (arg_res_level = 2
578: AND mgr.project_id is NULL)
579: OR (DECODE(arg_res_level,

Line 1639: next_week_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,

1635:
1636: IF var_dates(loop_counter) >= G_day_bckt_cutoff_dt AND
1637: var_dates(loop_counter) < G_week_bckt_cutoff_dt THEN
1638: /* sum the txns. maintain the week start date. */
1639: next_week_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,
1640: MSC_CALENDAR.TYPE_WEEKLY_BUCKET, var_dates(loop_counter)+1 );
1641:
1642: IF curr_week_start_date <> next_week_start_date THEN
1643: week_change_flag := TRUE;

Line 1640: MSC_CALENDAR.TYPE_WEEKLY_BUCKET, var_dates(loop_counter)+1 );

1636: IF var_dates(loop_counter) >= G_day_bckt_cutoff_dt AND
1637: var_dates(loop_counter) < G_week_bckt_cutoff_dt THEN
1638: /* sum the txns. maintain the week start date. */
1639: next_week_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,
1640: MSC_CALENDAR.TYPE_WEEKLY_BUCKET, var_dates(loop_counter)+1 );
1641:
1642: IF curr_week_start_date <> next_week_start_date THEN
1643: week_change_flag := TRUE;
1644:

Line 1794: next_period_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,

1790:
1791: IF var_dates(loop_counter) >= G_week_bckt_cutoff_dt AND
1792: var_dates(loop_counter) <= last_date THEN
1793: /* sum the txns. maintain the week start date. */
1794: next_period_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,
1795: MSC_CALENDAR.TYPE_MONTHLY_BUCKET, var_dates(loop_counter)+1 );
1796:
1797: IF curr_period_start_date <> next_period_start_date THEN
1798: period_change_flag := TRUE;

Line 1795: MSC_CALENDAR.TYPE_MONTHLY_BUCKET, var_dates(loop_counter)+1 );

1791: IF var_dates(loop_counter) >= G_week_bckt_cutoff_dt AND
1792: var_dates(loop_counter) <= last_date THEN
1793: /* sum the txns. maintain the week start date. */
1794: next_period_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,
1795: MSC_CALENDAR.TYPE_MONTHLY_BUCKET, var_dates(loop_counter)+1 );
1796:
1797: IF curr_period_start_date <> next_period_start_date THEN
1798: period_change_flag := TRUE;
1799: