DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_CHANGEORDERWF_PVT

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

10109:
10110: x_progress := '003';
10111:
10112: --For Release the document_header_id will be null.Hence query the po_release_id
10113: --to set the release id to pass it to PO_CHANGEORDERWF_PVT.NotifySupAllChgRpdWF
10114: SELECT document_header_id, document_revision_num, document_type, po_release_id
10115: INTO l_document_header_id, l_document_revision_num, l_document_type, l_release_id
10116: FROM po_change_requests
10117: WHERE change_request_group_id = l_po_request_group_id

Line 10123: PO_CHANGEORDERWF_PVT.NotifySupAllChgRpdWF

10119:
10120: x_progress := '004';
10121:
10122: -- Send rejection notification to suppliers
10123: PO_CHANGEORDERWF_PVT.NotifySupAllChgRpdWF
10124: ( p_header_id => l_document_header_id,
10125: p_release_id => l_release_id,
10126: p_revision_num => l_document_revision_num,
10127: p_chg_req_grp_id => l_po_request_group_id );