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)
3020: , p_employee_id => p_employee_id -- bug3738420
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)
3020: , p_employee_id => p_employee_id -- bug3738420
3021: );
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:
3023: -- Bug 3602512 START
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)
3229: , p_employee_id => p_employee_id -- bug3738420
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)
3229: , p_employee_id => p_employee_id -- bug3738420
3230: );
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
3232:
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)
3239: , p_employee_id => p_employee_id -- bug3738420
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)
3239: , p_employee_id => p_employee_id -- bug3738420
3240: );
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;
3242: commit; --bug9924585