3011: -- it from PO_ACCEPTANCES table because the person who is logged in accetpance table may
3012: -- not be the one who performs the action.
3013:
3014: PO_ACTION_HISTORY_SV.insert_action_history(
3015: p_doc_id_tbl => po_tbl_number(p_po_header_id)
3016: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3017: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3018: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)
3019: , p_action_code_tbl => po_tbl_varchar30(p_action_code)
3014: PO_ACTION_HISTORY_SV.insert_action_history(
3015: p_doc_id_tbl => po_tbl_number(p_po_header_id)
3016: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3017: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3018: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)
3019: , p_action_code_tbl => po_tbl_varchar30(p_action_code)
3020: , p_employee_id => p_employee_id -- bug3738420
3021: );
3022:
3220: -- CLM Apprvl. If the document is a modification we need to pass the draft_id as the object_id for inserting into po_action_history table
3221: if p_draft_id <> -1 then
3222:
3223: PO_ACTION_HISTORY_SV.insert_action_history(
3224: p_doc_id_tbl => po_tbl_number(p_draft_id)
3225: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3226: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3227: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)
3228: , p_action_code_tbl => po_tbl_varchar30(p_action_code)
3223: PO_ACTION_HISTORY_SV.insert_action_history(
3224: p_doc_id_tbl => po_tbl_number(p_draft_id)
3225: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3226: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3227: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)
3228: , p_action_code_tbl => po_tbl_varchar30(p_action_code)
3229: , p_employee_id => p_employee_id -- bug3738420
3230: );
3231: else
3230: );
3231: else
3232:
3233: PO_ACTION_HISTORY_SV.insert_action_history(
3234: p_doc_id_tbl => po_tbl_number(p_po_header_id)
3235: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3236: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3237: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)
3238: , p_action_code_tbl => po_tbl_varchar30(p_action_code)
3233: PO_ACTION_HISTORY_SV.insert_action_history(
3234: p_doc_id_tbl => po_tbl_number(p_po_header_id)
3235: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3236: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3237: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)
3238: , p_action_code_tbl => po_tbl_varchar30(p_action_code)
3239: , p_employee_id => p_employee_id -- bug3738420
3240: );
3241: end if;