APPS.POR_UTIL_PKG dependencies on PO_ACTION_HISTORY

Line 210: from po_action_history

206: CURSOR c_hist is
207: select sequence_num,
208: action_code,
209: employee_id
210: from po_action_history
211: where object_id = p_req_header_id
212: and object_type_code = 'REQUISITION'
213: order by sequence_num desc;
214:

Line 216: l_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;

212: and object_type_code = 'REQUISITION'
213: order by sequence_num desc;
214:
215: l_seq NUMBER;
216: l_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;
217: l_emp_id NUMBER;
218:
219: l_approver_id NUMBER := -1;
220:

Line 2055: l_pending_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;

2051: l_item_key VARCHAR2(240);
2052: l_activity_status VARCHAR2(8);
2053: l_progress VARCHAR2(4) := '000';
2054:
2055: l_pending_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;
2056: l_doc_sub_type PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2057: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2058:
2059: -- Logging Infra

Line 2057: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;

2053: l_progress VARCHAR2(4) := '000';
2054:
2055: l_pending_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;
2056: l_doc_sub_type PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2057: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2058:
2059: -- Logging Infra
2060: l_procedure_name CONSTANT VARCHAR2(30) := 'withdraw_req';
2061: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2065: FROM PO_ACTION_HISTORY

2061: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2062:
2063: CURSOR action_cursor IS
2064: SELECT action_code, employee_id
2065: FROM PO_ACTION_HISTORY
2066: WHERE object_type_code = 'REQUISITION'
2067: AND object_id = p_headerId
2068: ORDER BY sequence_num desc;
2069: