APPS.MRP_REPORTING_BUCKETS dependencies on MRP_FORM_QUERY

Line 15: var_week_bucket_date mrp_form_query.date1%TYPE;

11: arg_start_date IN DATE,
12: arg_org_id IN NUMBER) IS
13: var_week_counter NUMBER;
14: var_month_counter NUMBER;
15: var_week_bucket_date mrp_form_query.date1%TYPE;
16: var_month_bucket_date mrp_form_query.date1%TYPE;
17: var_month_start_date mrp_form_query.date1%TYPE;
18: var_calendar_code VARCHAR2(10);
19: var_exception_set_id NUMBER;

Line 16: var_month_bucket_date mrp_form_query.date1%TYPE;

12: arg_org_id IN NUMBER) IS
13: var_week_counter NUMBER;
14: var_month_counter NUMBER;
15: var_week_bucket_date mrp_form_query.date1%TYPE;
16: var_month_bucket_date mrp_form_query.date1%TYPE;
17: var_month_start_date mrp_form_query.date1%TYPE;
18: var_calendar_code VARCHAR2(10);
19: var_exception_set_id NUMBER;
20: var_weeks NUMBER;

Line 17: var_month_start_date mrp_form_query.date1%TYPE;

13: var_week_counter NUMBER;
14: var_month_counter NUMBER;
15: var_week_bucket_date mrp_form_query.date1%TYPE;
16: var_month_bucket_date mrp_form_query.date1%TYPE;
17: var_month_start_date mrp_form_query.date1%TYPE;
18: var_calendar_code VARCHAR2(10);
19: var_exception_set_id NUMBER;
20: var_weeks NUMBER;
21: var_periods NUMBER;

Line 88: INSERT INTO mrp_form_query

84: END IF;
85: /*---------------------------------------------------------------------+
86: | Insert a row for each week... |
87: +---------------------------------------------------------------------*/
88: INSERT INTO mrp_form_query
89: (query_id,
90: date1,
91: last_update_date,
92: last_updated_by,

Line 132: INSERT INTO mrp_form_query

128: END IF;
129: /*---------------------------------------------------------------------+
130: | Insert a row for each week... |
131: +---------------------------------------------------------------------*/
132: INSERT INTO mrp_form_query
133: (query_id,
134: date1,
135: last_update_date,
136: last_updated_by,

Line 149: UPDATE mrp_form_query q

145: arg_user_id,
146: -1);
147: END LOOP;
148: CLOSE months_cur;
149: UPDATE mrp_form_query q
150: SET date2 =
151: (SELECT MIN(q2.date1)
152: FROM mrp_form_query q2
153: WHERE q2.query_id = q.query_id

Line 152: FROM mrp_form_query q2

148: CLOSE months_cur;
149: UPDATE mrp_form_query q
150: SET date2 =
151: (SELECT MIN(q2.date1)
152: FROM mrp_form_query q2
153: WHERE q2.query_id = q.query_id
154: AND q2.date1 > q.date1)
155: WHERE q.query_id = arg_query_id;
156:

Line 157: DELETE FROM mrp_form_query

153: WHERE q2.query_id = q.query_id
154: AND q2.date1 > q.date1)
155: WHERE q.query_id = arg_query_id;
156:
157: DELETE FROM mrp_form_query
158: WHERE query_id = arg_query_id
159: AND date2 IS NULL;
160:
161: END mrp_weeks_months;