APPS.PO_ACKNOWLEDGE_PO_PVT dependencies on PO_RELEASES_ALL

Line 205: from PO_RELEASES_ALL

201: select nvl(acceptance_required_flag, 'N'),
202: nvl(change_requested_by, ' ')
203: into l_acceptance_required_flag,
204: l_change_requested_by
205: from PO_RELEASES_ALL
206: where po_release_id = p_po_release_id;
207:
208: /* Get if there is any shipment acknowledged. */
209: OPEN l_rel_ship_ack_exists_csr;

Line 518: update PO_RELEASES_ALL

514: -- End of Bug 2850566
515:
516: /* reset the header-level acceptance_required_flag. */
517: IF (p_po_release_id is not null) THEN
518: update PO_RELEASES_ALL
519: set acceptance_required_flag = 'N',
520: acceptance_due_date = ''
521: where po_release_id = p_po_release_id;
522:

Line 641: from PO_RELEASES_all

637: l_accp_reqd_flag,
638: l_auth_status,
639: l_revision_num,
640: l_changed_by
641: from PO_RELEASES_all
642: where po_release_id = p_po_release_id;
643:
644: ELSE
645: select nvl(cancel_flag, 'N'),

Line 832: FROM PO_RELEASES_ALL POR

828:
829: IF (p_po_release_id is not null) THEN
830: SELECT POR.revision_num, authorization_status
831: INTO l_revision_num, l_authorization_status
832: FROM PO_RELEASES_ALL POR
833: WHERE POR.po_release_id = p_po_release_id;
834:
835: ELSIF (p_po_header_id is not null) THEN
836: SELECT POH.revision_num, authorization_status

Line 862: PO_RELEASES_ALL POR

858:
859: select PCR.action_type
860: into l_action_type
861: from PO_CHANGE_REQUESTS PCR,
862: PO_RELEASES_ALL POR
863: where pcr.document_line_location_id = P_line_location_id
864: and pcr.po_release_id = p_po_release_id
865: and por.po_release_id = p_po_release_id
866: and por.change_requested_by = 'SUPPLIER'

Line 936: from PO_RELEASES_ALL

932:
933: IF (p_po_release_id is not null) THEN
934: select nvl(acceptance_required_flag, 'N')
935: into l_acceptance_required_flag
936: from PO_RELEASES_ALL
937: where po_release_id = p_po_release_id
938: and revision_num = l_revision_num;
939:
940: IF (l_acceptance_required_flag in ('D','Y')) THEN

Line 1276: from po_releases_all

1272: /* Copy the previous revision shipment-level acknowledgement. */
1273: If (p_po_release_id is not null) THEN
1274: select agent_id
1275: into l_buyer_id
1276: from po_releases_all
1277: where po_release_id = p_po_release_id;
1278:
1279:
1280: -- Bug 2850566 RBAIRRAJ

Line 1526: From PO_CHANGE_REQUESTS pcr, po_releases_all por

1522: And pa.revision_num = p_revision_num
1523: And pa.po_line_location_id = PLL.line_location_id )
1524: And not exists (
1525: select 1
1526: From PO_CHANGE_REQUESTS pcr, po_releases_all por
1527: WHERE por.po_release_id = p_po_release_id
1528: and por.change_requested_by = 'SUPPLIER'
1529: and pcr.po_release_id = p_po_release_id
1530: AND PCR.document_revision_num = p_revision_num

Line 1717: FROM PO_RELEASES_ALL

1713: INTO l_buyer_id,
1714: l_revision_num,
1715: l_accp_required_flag,
1716: l_change_requested_by
1717: FROM PO_RELEASES_ALL
1718: WHERE po_release_id = p_po_release_id;
1719:
1720: ELSIF (p_po_header_id is not null) THEN
1721: SELECT agent_id,