DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on MTL_SUPPLY

Line 4191: -- Function : Deletes MTL_SUPPLY record when a requisition line is deleted

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

Line 4263: -- Function : Deletes MTL_SUPPLY record when a requisition line is deleted

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:

Line 4276: -- Delete From MTL_SUPPLY

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';

Line 4277: delete FROM mtl_supply where REQ_HEADER_ID = p_req_header_id AND REQ_LINE_ID=p_req_line_id;

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;