DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_CHANGEORDERWF_PVT

Line 9726: --to set the release id to pass it to PO_CHANGEORDERWF_PVT.NotifySupAllChgRpdWF

9722:
9723: x_progress := '003';
9724:
9725: --For Release the document_header_id will be null.Hence query the po_release_id
9726: --to set the release id to pass it to PO_CHANGEORDERWF_PVT.NotifySupAllChgRpdWF
9727: SELECT document_header_id, document_revision_num, document_type, po_release_id
9728: INTO l_document_header_id, l_document_revision_num, l_document_type, l_release_id
9729: FROM po_change_requests
9730: WHERE change_request_group_id = l_po_request_group_id

Line 9736: PO_CHANGEORDERWF_PVT.NotifySupAllChgRpdWF

9732:
9733: x_progress := '004';
9734:
9735: -- Send rejection notification to suppliers
9736: PO_CHANGEORDERWF_PVT.NotifySupAllChgRpdWF
9737: ( p_header_id => l_document_header_id,
9738: p_release_id => l_release_id,
9739: p_revision_num => l_document_revision_num,
9740: p_chg_req_grp_id => l_po_request_group_id );