DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on PO_TBL_NUMBER

Line 3015: p_doc_id_tbl => po_tbl_number(p_po_header_id)

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)

Line 3018: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)

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:

Line 3224: p_doc_id_tbl => po_tbl_number(p_draft_id)

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)

Line 3227: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)

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

Line 3234: p_doc_id_tbl => po_tbl_number(p_po_header_id)

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)

Line 3237: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)

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;