APPS.CZ_ATP_UTIL dependencies on MTL_GROUP_ATPS_VIEW

Line 14: rec_mgav mtl_group_atps_view%rowtype;

10: p_error_message OUT NOCOPY VARCHAR2,
11: p_sequence_number IN NUMBER,
12: p_atp_rule_id IN NUMBER DEFAULT NULL) IS
13:
14: rec_mgav mtl_group_atps_view%rowtype;
15: p_process_flag NUMBER := 1;
16: atp_lead_time NUMBER := NULL;
17: demand_class VARCHAR2(30) := NULL;
18: atp_group_id_exc EXCEPTION;

Line 112: INSERT INTO MTL_GROUP_ATPS_VIEW

108:
109: --dbms_output.put_line ('Calendar org id: ' ||
110: -- to_char (rec_mgav.atp_calendar_organization_id) );
111:
112: INSERT INTO MTL_GROUP_ATPS_VIEW
113: (ATP_GROUP_ID,
114: ORGANIZATION_ID,
115: INVENTORY_ITEM_ID,
116: LAST_UPDATE_DATE,

Line 269: MTL_GROUP_ATPS_VIEW

265: error_code,
266: group_available_date,
267: p_earliest_atp_date
268: from
269: MTL_GROUP_ATPS_VIEW
270: where
271: ATP_GROUP_ID = p_atp_group_id and
272: n_column2 = p_sequence_number;
273:

Line 292: DELETE FROM mtl_group_atps_view WHERE atp_group_id = p_atp_group_id

288: END IF;
289: END IF;
290:
291: -- delete record
292: DELETE FROM mtl_group_atps_view WHERE atp_group_id = p_atp_group_id
293: AND n_column2 = p_sequence_number;
294:
295: -- need to commit here
296: commit;