APPS.PO_REQS_CONTROL_SV dependencies on PO_REQUISITION_HEADERS

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

296: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
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);

Line 452: FROM PO_REQUISITION_HEADERS

448: /* po_notifications_sv1.delete_po_notif (x_Req_doc_type,
449: X_req_header_id); */
450: SELECT wf_item_type,wf_item_key
451: INTO x_item_type,x_item_key
452: FROM PO_REQUISITION_HEADERS
453: WHERE requisition_header_id = x_req_header_id;
454:
455: if ((x_item_type is null) and (x_item_key is null)) then
456: po_approval_reminder_sv.cancel_notif (x_req_doc_subtype,