DBA Data[Home] [Help]

APPS.ICX_PO_REQS_CANCEL_SV dependencies on PO_REQUISITION_HEADERS

Line 43: X_req_header_auth_status PO_REQUISITION_HEADERS.authorization_status%TYPE := NULL;

39: X_req_control_error_rc IN OUT VARCHAR2) IS
40:
41:
42: X_progress VARCHAR2(3) := NULL;
43: X_req_header_auth_status PO_REQUISITION_HEADERS.authorization_status%TYPE := NULL;
44: X_req_action_history_code PO_ACTION_HISTORY.action_code%TYPE := NULL;
45: X_supply_action VARCHAR2(50) := NULL;
46: X_supply_id NUMBER;
47:

Line 58: FROM PO_REQUISITION_HEADERS

54:
55:
56: SELECT authorization_status
57: INTO X_req_header_auth_status
58: FROM PO_REQUISITION_HEADERS
59: WHERE requisition_header_id = X_req_header_id;
60:
61:
62: /*

Line 111: UPDATE PO_REQUISITION_HEADERS

107: END IF;
108:
109:
110: X_progress := '030';
111: UPDATE PO_REQUISITION_HEADERS
112: SET authorization_status = 'CANCELLED'
113: WHERE requisition_header_id = X_req_header_id;
114:
115: IF X_req_action_history_code IS NOT NULL THEN