DBA Data[Home] [Help]

APPS.PO_REQS_CONTROL_SV dependencies on PO_ACTION_HISTORY

Line 301: X_req_action_history_code PO_ACTION_HISTORY.action_code%TYPE := NULL;

297:
298:
299: X_progress VARCHAR2(3) := NULL;
300: X_req_header_auth_status PO_REQUISITION_HEADERS.authorization_status%TYPE := NULL;
301: X_req_action_history_code PO_ACTION_HISTORY.action_code%TYPE := NULL;
302: X_supply_action VARCHAR2(50) := NULL;
303: X_supply_id NUMBER;
304: X_req_header_auth_status_dsp VARCHAR2(80);
305: x_item_type varchar2(8);

Line 394: DELETE FROM PO_ACTION_HISTORY

390: -- If the action is cancel then delete the rows where action_code is null
391: -- and insert a row with action_code CANCEL.
392: IF X_req_action_history_code = 'CANCEL' THEN
393:
394: DELETE FROM PO_ACTION_HISTORY
395: WHERE object_id = X_req_header_id
396: AND object_type_code = X_req_doc_type
397: AND action_code IS NULL;
398: