DBA Data[Home] [Help]

APPS.MRP_SCHEDULE dependencies on MRP_CALENDAR

Line 52: var_last_cal_date := mrp_calendar.next_work_day(arg_org_id,

48: BEGIN
49: --
50: -- Get last calendar date
51: --
52: var_last_cal_date := mrp_calendar.next_work_day(arg_org_id,
53: TYPE_DAILY_BUCKET, arg_cutoff_date);
54:
55: --
56: -- Populate MRP_FORM_QUERY

Line 71: var_start_date := mrp_calendar.prev_work_day(arg_org_id,

67: -- SUPPLY for MPS
68: --
69: IF (arg_bucket_type = TYPE_DAILY_BUCKET) THEN
70:
71: var_start_date := mrp_calendar.prev_work_day(arg_org_id,
72: TYPE_DAILY_BUCKET, arg_start_date);
73:
74: --
75: -- Insert schedules in daily bucket

Line 164: var_start_date := mrp_calendar.prev_work_day(arg_org_id,

160:
161:
162: ELSIF (arg_bucket_type = TYPE_WEEKLY_BUCKET) THEN
163:
164: var_start_date := mrp_calendar.prev_work_day(arg_org_id,
165: TYPE_WEEKLY_BUCKET, arg_start_date);
166:
167: --
168: -- Insert schedules in weekly buckets for those weeks that have

Line 309: var_start_date := mrp_calendar.prev_work_day(arg_org_id,

305:
306:
307: ELSIF (arg_bucket_type = TYPE_MONTHLY_BUCKET) THEN
308:
309: var_start_date := mrp_calendar.prev_work_day(arg_org_id,
310: TYPE_MONTHLY_BUCKET, arg_start_date);
311:
312: --
313: -- Insert schedules in periodic buckets for those periods that have