APPS.ICX_PO_REQS_CANCEL_SV dependencies on MTL_SUPPLY

Line 64: ** 1. Req header: quantity in mtl_supply to 0 for a given req header

60:
61:
62: /*
63: ** Call maintain_supply to set:
64: ** 1. Req header: quantity in mtl_supply to 0 for a given req header
65: ** 2. Req line: quantity in mtl_supply to 0 for a given req line.
66: **
67: ** DEBUG: The maintain_supply used in this server package is
68: ** for testing. It should be moved to the maintain_supply server

Line 65: ** 2. Req line: quantity in mtl_supply to 0 for a given req line.

61:
62: /*
63: ** Call maintain_supply to set:
64: ** 1. Req header: quantity in mtl_supply to 0 for a given req header
65: ** 2. Req line: quantity in mtl_supply to 0 for a given req line.
66: **
67: ** DEBUG: The maintain_supply used in this server package is
68: ** for testing. It should be moved to the maintain_supply server
69: ** package when it is ready.

Line 183: ** Sets the req quantity in mtl_supply to 0 for a given req header.

179: IF X_supply_action = 'Remove_Req_Supply' THEN
180: X_progress := '005';
181:
182: /*
183: ** Sets the req quantity in mtl_supply to 0 for a given req header.
184: */
185:
186: UPDATE MTL_SUPPLY
187: SET quantity = 0,

Line 186: UPDATE MTL_SUPPLY

182: /*
183: ** Sets the req quantity in mtl_supply to 0 for a given req header.
184: */
185:
186: UPDATE MTL_SUPPLY
187: SET quantity = 0,
188: change_flag = 'Y'
189: WHERE supply_type_code = 'REQ'
190: AND req_header_id = X_supply_id;

Line 197: ** Sets the req quantity in mtl_supply to 0 for a given req line.

193: ELSIF X_supply_action = 'Remove_Req_Line_Supply' THEN
194: X_progress := '010';
195:
196: /*
197: ** Sets the req quantity in mtl_supply to 0 for a given req line.
198: */
199:
200: UPDATE mtl_supply
201: SET quantity = 0,

Line 200: UPDATE mtl_supply

196: /*
197: ** Sets the req quantity in mtl_supply to 0 for a given req line.
198: */
199:
200: UPDATE mtl_supply
201: SET quantity = 0,
202: change_flag = 'Y'
203: WHERE supply_type_code = 'REQ'
204: AND req_line_id = X_supply_id;