APPS.POR_UTIL_PKG dependencies on PO_ACTION_HISTORY

Line 220: from po_action_history

216: CURSOR c_hist is
217: select sequence_num,
218: action_code,
219: employee_id
220: from po_action_history
221: where object_id = p_req_header_id
222: and object_type_code = 'REQUISITION'
223: order by sequence_num desc;
224:

Line 226: l_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;

222: and object_type_code = 'REQUISITION'
223: order by sequence_num desc;
224:
225: l_seq NUMBER;
226: l_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;
227: l_emp_id NUMBER;
228:
229: l_approver_id NUMBER := -1;
230:

Line 1510: select SEQUENCE_NUM,EMPLOYEE_ID from po_action_history

1506:
1507:
1508: select EMPLOYEE_ID into p_approver_id
1509: from (
1510: select SEQUENCE_NUM,EMPLOYEE_ID from po_action_history
1511: where object_id = req_Header_Id
1512: and OBJECT_TYPE_CODE='REQUISITION'
1513: and OBJECT_SUB_TYPE_CODE='PURCHASE'
1514: and ACTION_CODE='NO ACTION'

Line 2387: l_pending_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;

2383: l_item_key VARCHAR2(240);
2384: l_activity_status VARCHAR2(8);
2385: l_progress VARCHAR2(4) := '000';
2386:
2387: l_pending_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;
2388: l_doc_sub_type PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2389: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2390:
2391: -- Logging Infra

Line 2389: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;

2385: l_progress VARCHAR2(4) := '000';
2386:
2387: l_pending_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;
2388: l_doc_sub_type PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2389: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2390:
2391: -- Logging Infra
2392: l_procedure_name CONSTANT VARCHAR2(30) := 'withdraw_req';
2393: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2397: FROM PO_ACTION_HISTORY

2393: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2394:
2395: CURSOR action_cursor IS
2396: SELECT action_code, employee_id
2397: FROM PO_ACTION_HISTORY
2398: WHERE object_type_code = 'REQUISITION'
2399: AND object_id = p_headerId
2400: ORDER BY sequence_num desc;
2401: