4187:
4188: -- API Name :get_gbpa_data_for_bulkload
4189: -- Type : Public
4190: -- Pre-reqs : None
4191: -- Function : Deletes MTL_SUPPLY record when a requisition line is deleted
4192: -- from iProcurement.
4193: -- Parameters : p_req_header_id IN NUMBER
4194: -- xUpdate_sourcing_rules_flag IN NUMBER
4195: -- xAuto_sourcing_rules_flag IN NUMBER
4259:
4260: -- API Name : delete_supply
4261: -- Type : Public
4262: -- Pre-reqs : None
4263: -- Function : Deletes MTL_SUPPLY record when a requisition line is deleted
4264: -- from iProcurement.
4265: -- Parameters : p_req_header_id IN NUMBER
4266: -- p_req_line_id IN NUMBER
4267:
4272:
4273: BEGIN
4274: l_progress := '010';
4275:
4276: -- Delete From MTL_SUPPLY
4277: delete FROM mtl_supply where REQ_HEADER_ID = p_req_header_id AND REQ_LINE_ID=p_req_line_id;
4278:
4279: --Commit the transaction
4280: l_progress := '030';
4273: BEGIN
4274: l_progress := '010';
4275:
4276: -- Delete From MTL_SUPPLY
4277: delete FROM mtl_supply where REQ_HEADER_ID = p_req_header_id AND REQ_LINE_ID=p_req_line_id;
4278:
4279: --Commit the transaction
4280: l_progress := '030';
4281: COMMIT;