APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_ACTION_HISTORY

Line 2625: -- PO_ACTION_HISTORY

2621: --Name: create_enc_action_history
2622: --Pre-reqs:
2623: -- Encumbrance action completed successfully.
2624: --Modifies:
2625: -- PO_ACTION_HISTORY
2626: --Locks:
2627: -- None.
2628: --Function:
2629: -- This procedure calls the Action History routine, which

Line 2630: -- inserts/updates the po_action_history with the action

2626: --Locks:
2627: -- None.
2628: --Function:
2629: -- This procedure calls the Action History routine, which
2630: -- inserts/updates the po_action_history with the action
2631: -- passed to this procedure.
2632: --Parameters:
2633: --IN:
2634: --p_doc_type

Line 2674: l_record_action PO_ACTION_HISTORY.action_code%TYPE;

2670: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ENC_ACTION_HISTORY';
2671: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
2672: l_progress VARCHAR2(3) := '000';
2673:
2674: l_record_action PO_ACTION_HISTORY.action_code%TYPE;
2675:
2676: l_gt_key NUMBER;
2677: l_debug_rowid_tbl po_tbl_varchar2000;
2678: l_debug_column_tbl po_tbl_varchar30;

Line 2849: FROM PO_ACTION_HISTORY POAH

2845:
2846: UPDATE PO_SESSION_GT SCRATCH
2847: SET char3 =
2848: ( SELECT 'Y'
2849: FROM PO_ACTION_HISTORY POAH
2850: WHERE POAH.object_type_code = p_doc_type
2851: AND POAH.object_id = SCRATCH.num1
2852: AND POAH.action_code IS NULL
2853: )

Line 3007: PO_ACTION_HISTORY_SV.update_action_history(

3003: l_update_doc_type_tbl.EXTEND(l_update_count-1, 1);
3004:
3005: l_progress := '330';
3006:
3007: PO_ACTION_HISTORY_SV.update_action_history(
3008: p_doc_id_tbl => l_update_doc_id_tbl
3009: , p_doc_type_tbl => l_update_doc_type_tbl
3010: , p_action_code => l_record_action
3011: , p_employee_id => p_employee_id

Line 3033: PO_ACTION_HISTORY_SV.insert_action_history(

3029: l_insert_doc_type_tbl.EXTEND(l_insert_count-1, 1);
3030:
3031: l_progress := '420';
3032:
3033: PO_ACTION_HISTORY_SV.insert_action_history(
3034: p_doc_id_tbl => l_insert_doc_id_tbl
3035: , p_doc_type_tbl => l_insert_doc_type_tbl
3036: , p_doc_subtype_tbl => l_insert_doc_subtype_tbl
3037: , p_doc_revision_num_tbl => l_insert_rev_num_tbl