APPS.MRP_EXCEPTION_SC dependencies on MRP_ITEM_EXCEPTIONS

Line 143: -- to save the current exception summary into mrp_item_exceptions

139: raise_application_error(-20000,sqlerrm||':'||statement);
140: END;
141:
142: ---------------------------------------------------------------------
143: -- to save the current exception summary into mrp_item_exceptions
144: ---------------------------------------------------------------------
145: FUNCTION save_as(org_id number, plan VARCHAR2) RETURN NUMBER IS
146: version_id NUMBER;
147: BEGIN

Line 151: FROM mrp_item_exceptions

147: BEGIN
148:
149: SELECT MAX(NVL(version,0))+1
150: INTO version_id
151: FROM mrp_item_exceptions
152: WHERE compile_designator= plan;
153:
154: INSERT INTO mrp_item_exceptions
155: (exception_type, inventory_item_id, compile_designator,

Line 154: INSERT INTO mrp_item_exceptions

150: INTO version_id
151: FROM mrp_item_exceptions
152: WHERE compile_designator= plan;
153:
154: INSERT INTO mrp_item_exceptions
155: (exception_type, inventory_item_id, compile_designator,
156: organization_id, last_update_date, last_updated_by,
157: creation_date, created_by, last_update_login, display, request_id,
158: program_application_id, program_id,

Line 169: FROM mrp_item_exceptions

165: program_application_id, program_id,
166: program_update_date, updated, status, exception_count, project_Id,
167: task_id, version_id, planning_group,
168: department_id, resource_id, line_id
169: FROM mrp_item_exceptions
170: WHERE version is null
171: AND compile_designator= plan;
172: commit;
173: Return version_id;

Line 177: -- update mrp-item-exceptions and mrp_form_query tables

173: Return version_id;
174: END save_as;
175:
176: ---------------------------------------------------------------------
177: -- update mrp-item-exceptions and mrp_form_query tables
178: ---------------------------------------------------------------------
179: PROCEDURE update_row(p_exception_id number,
180: p_omit_list VARCHAR2,
181: p_row_id VARCHAR2,

Line 189: -- update mrp_item_exceptions by the their rowid (stored as char8 in

185: statement varchar2(2000);
186: rows_processed integer;
187: BEGIN
188:
189: -- update mrp_item_exceptions by the their rowid (stored as char8 in
190: -- mrp_form_query) by applying the criteria on the second insert
191: -- of mrp_form_query
192:
193: statement :=

Line 194: 'update mrp_item_exceptions

190: -- mrp_form_query) by applying the criteria on the second insert
191: -- of mrp_form_query
192:
193: statement :=
194: 'update mrp_item_exceptions
195: set display = 2,
196: last_update_login = :last_update_login,
197: last_updated_by = :last_updated_by,
198: last_update_date = sysdate

Line 219: -- to lock the row in mrp_item_exceptions

215: raise no_data_found;
216:
217: END update_row;
218: ---------------------------------------------------------------------
219: -- to lock the row in mrp_item_exceptions
220: -- if the row is deleted, return 1. if the data is changed, return 2.
221: -- if the row is locked successfully, return 3.
222: ---------------------------------------------------------------------
223: FUNCTION lock_row(p_exception_id number, p_omit_list VARCHAR2)

Line 232: -- lock the row in mrp_item_exceptions by the their rowid (stored as char8 in

228: display_flag NUMBER;
229: counter NUMBER;
230: BEGIN
231:
232: -- lock the row in mrp_item_exceptions by the their rowid (stored as char8 in
233: -- mrp_form_query) by applying the criteria on the second insert
234: -- of mrp_form_query
235:
236: statement :=

Line 238: from mrp_item_exceptions

234: -- of mrp_form_query
235:
236: statement :=
237: 'select display
238: from mrp_item_exceptions
239: where rowid in (
240: select chartorowid(char8)
241: from mrp_form_query
242: where ' ||p_omit_list||