APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_CALENDAR

Line 183: FROM msc_calendar_dates cal,

179: -- This cursor selects the dates for the buckets.
180: -- -------------------------------------------------
181: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
182: SELECT cal.calendar_date
183: FROM msc_calendar_dates cal,
184: msc_trading_partners tp
185: WHERE tp.sr_tp_id = G_org_id
186: AND tp.sr_instance_id = G_inst_id
187: AND tp.calendar_exception_set_id = cal.exception_set_id

Line 277: msc_calendar_dates dates

273: gmp_pdr_items_gtmp gpi,
274: msc_trading_partners param,
275: -- msc_system_items msi,
276: msc_supplies rec,
277: msc_calendar_dates dates
278: WHERE /*(arg_res_level = 1
279: OR (arg_res_level = 2
280: AND rec.project_id is NULL)
281: OR (DECODE(arg_res_level,

Line 454: msc_calendar_dates dates

450: FROM -- msc_form_query list,
451: gmp_pdr_items_gtmp gpi,
452: msc_trading_partners param,
453: msc_demands mgr,
454: msc_calendar_dates dates
455: WHERE /*(arg_res_level = 1
456: OR (arg_res_level = 2
457: AND mgr.project_id is NULL)
458: OR (DECODE(arg_res_level,

Line 588: msc_calendar_dates dates

584: FROM --msc_form_query list,
585: gmp_pdr_items_gtmp gpi,
586: msc_trading_partners param,
587: msc_demands mgr,
588: msc_calendar_dates dates
589: WHERE /*(arg_res_level = 1
590: OR (arg_res_level = 2
591: AND mgr.project_id is NULL)
592: OR (DECODE(arg_res_level,

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

1663: IF var_dates(loop_counter) >= G_day_bckt_cutoff_dt AND
1664: var_dates(loop_counter) <= G_week_bckt_cutoff_dt THEN
1665: -- var_dates(loop_counter) < G_week_bckt_cutoff_dt THEN Bug: 8447261 Vpedarla
1666: /* sum the txns. maintain the week start date. */
1667: next_week_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,
1668: MSC_CALENDAR.TYPE_WEEKLY_BUCKET, var_dates(loop_counter)+1 );
1669:
1670: IF curr_week_start_date <> next_week_start_date THEN
1671:

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

1664: var_dates(loop_counter) <= G_week_bckt_cutoff_dt THEN
1665: -- var_dates(loop_counter) < G_week_bckt_cutoff_dt THEN Bug: 8447261 Vpedarla
1666: /* sum the txns. maintain the week start date. */
1667: next_week_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,
1668: MSC_CALENDAR.TYPE_WEEKLY_BUCKET, var_dates(loop_counter)+1 );
1669:
1670: IF curr_week_start_date <> next_week_start_date THEN
1671:
1672: -- Bug : 8447261 Vpedarla Added a if condition for the statement

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

1829: IF G_week_bckt_cutoff_dt IS NOT NULL THEN
1830: IF var_dates(loop_counter) >= G_week_bckt_cutoff_dt AND
1831: var_dates(loop_counter) <= last_date THEN
1832: /* sum the txns. maintain the week start date. */
1833: next_period_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,
1834: MSC_CALENDAR.TYPE_MONTHLY_BUCKET, var_dates(loop_counter)+1 );
1835:
1836: IF curr_period_start_date <> next_period_start_date THEN
1837: period_change_flag := TRUE;

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

1830: IF var_dates(loop_counter) >= G_week_bckt_cutoff_dt AND
1831: var_dates(loop_counter) <= last_date THEN
1832: /* sum the txns. maintain the week start date. */
1833: next_period_start_date := msc_calendar.next_work_day (-1*G_org_id, G_inst_id,
1834: MSC_CALENDAR.TYPE_MONTHLY_BUCKET, var_dates(loop_counter)+1 );
1835:
1836: IF curr_period_start_date <> next_period_start_date THEN
1837: period_change_flag := TRUE;
1838: