APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_ACTION_HISTORY

Line 2954: -- PO_ACTION_HISTORY

2950: --Name: create_enc_action_history
2951: --Pre-reqs:
2952: -- Encumbrance action completed successfully.
2953: --Modifies:
2954: -- PO_ACTION_HISTORY
2955: --Locks:
2956: -- None.
2957: --Function:
2958: -- This procedure calls the Action History routine, which

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

2955: --Locks:
2956: -- None.
2957: --Function:
2958: -- This procedure calls the Action History routine, which
2959: -- inserts/updates the po_action_history with the action
2960: -- passed to this procedure.
2961: --Parameters:
2962: --IN:
2963: --p_doc_type

Line 3003: l_record_action PO_ACTION_HISTORY.action_code%TYPE;

2999: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ENC_ACTION_HISTORY';
3000: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
3001: l_progress VARCHAR2(3) := '000';
3002:
3003: l_record_action PO_ACTION_HISTORY.action_code%TYPE;
3004:
3005: l_gt_key NUMBER;
3006: l_debug_rowid_tbl po_tbl_varchar2000;
3007: l_debug_column_tbl po_tbl_varchar30;

Line 3178: FROM PO_ACTION_HISTORY POAH

3174:
3175: UPDATE PO_SESSION_GT SCRATCH
3176: SET char3 =
3177: ( SELECT 'Y'
3178: FROM PO_ACTION_HISTORY POAH
3179: WHERE POAH.object_type_code = p_doc_type
3180: AND POAH.object_id = SCRATCH.num1
3181: AND POAH.action_code IS NULL
3182: AND POAH.employee_id = p_employee_id

Line 3337: PO_ACTION_HISTORY_SV.update_action_history(

3333: l_update_doc_type_tbl.EXTEND(l_update_count-1, 1);
3334:
3335: l_progress := '330';
3336:
3337: PO_ACTION_HISTORY_SV.update_action_history(
3338: p_doc_id_tbl => l_update_doc_id_tbl
3339: , p_doc_type_tbl => l_update_doc_type_tbl
3340: , p_action_code => l_record_action
3341: , p_employee_id => p_employee_id

Line 3363: PO_ACTION_HISTORY_SV.insert_action_history(

3359: l_insert_doc_type_tbl.EXTEND(l_insert_count-1, 1);
3360:
3361: l_progress := '420';
3362:
3363: PO_ACTION_HISTORY_SV.insert_action_history(
3364: p_doc_id_tbl => l_insert_doc_id_tbl
3365: , p_doc_type_tbl => l_insert_doc_type_tbl
3366: , p_doc_subtype_tbl => l_insert_doc_subtype_tbl
3367: , p_doc_revision_num_tbl => l_insert_rev_num_tbl