APPS.MRP_REPPERIODS_PUB dependencies on MRP_CALENDAR

Line 37: mrp_calendar.select_calendar_defaults(

33: FROM mrp_parameters
34: WHERE organization_id = arg_org_id;
35:
36: -- Select the calendar code and exception set id for this org
37: mrp_calendar.select_calendar_defaults(
38: arg_org_id,
39: var_calendar_code,
40: var_exception_set_id);
41:

Line 58: var_end_date1 := mrp_calendar.date_offset(

54:
55: -- Calculate the end date for each bucket
56: IF param.period_type = WORKDATE_PERIODS THEN
57: -- Set the end dates according to workdates
58: var_end_date1 := mrp_calendar.date_offset(
59: arg_org_id,
60: BUCKET_TYPE,
61: param.repetitive_anchor_date,
62: param.repetitive_horizon1);

Line 64: var_end_date2 := mrp_calendar.date_offset(

60: BUCKET_TYPE,
61: param.repetitive_anchor_date,
62: param.repetitive_horizon1);
63:
64: var_end_date2 := mrp_calendar.date_offset(
65: arg_org_id,
66: BUCKET_TYPE,
67: var_end_date1,
68: param.repetitive_horizon2);

Line 70: var_last_date1 := mrp_calendar.date_offset(

66: BUCKET_TYPE,
67: var_end_date1,
68: param.repetitive_horizon2);
69:
70: var_last_date1 := mrp_calendar.date_offset(
71: arg_org_id,
72: BUCKET_TYPE,
73: var_max_date,
74: -1 * param.repetitive_bucket_size1);

Line 76: var_last_date2 := mrp_calendar.date_offset(

72: BUCKET_TYPE,
73: var_max_date,
74: -1 * param.repetitive_bucket_size1);
75:
76: var_last_date2 := mrp_calendar.date_offset(
77: arg_org_id,
78: BUCKET_TYPE,
79: var_max_date,
80: -1 * param.repetitive_bucket_size2);

Line 82: var_last_date3 := mrp_calendar.date_offset(

78: BUCKET_TYPE,
79: var_max_date,
80: -1 * param.repetitive_bucket_size2);
81:
82: var_last_date3 := mrp_calendar.date_offset(
83: arg_org_id,
84: BUCKET_TYPE,
85: var_max_date,
86: -1 * param.repetitive_bucket_size3);

Line 150: var_curr_date := mrp_calendar.date_offset(

146: -- If that brings you to the next bucket type, then shift the
147: -- variable var_curr_bucket
148: IF var_curr_bucket = 1 THEN -- First bucket
149: IF param.period_type = WORKDATE_PERIODS THEN
150: var_curr_date := mrp_calendar.date_offset(
151: arg_org_id,
152: BUCKET_TYPE,
153: var_curr_date,
154: param.repetitive_bucket_size1);

Line 164: var_curr_date := mrp_calendar.date_offset(

160: var_curr_bucket := 2;
161: END IF;
162: ELSIF var_curr_bucket = 2 THEN -- Second bucket
163: IF param.period_type = WORKDATE_PERIODS THEN
164: var_curr_date := mrp_calendar.date_offset(
165: arg_org_id,
166: BUCKET_TYPE,
167: var_curr_date,
168: param.repetitive_bucket_size2);

Line 178: var_curr_date := mrp_calendar.date_offset(

174: var_curr_bucket := 3;
175: END IF;
176: ELSE
177: IF param.period_type = WORKDATE_PERIODS THEN
178: var_curr_date := mrp_calendar.date_offset(
179: arg_org_id,
180: BUCKET_TYPE,
181: var_curr_date,
182: param.repetitive_bucket_size3);