APPS.PO_ACKNOWLEDGE_PO_PVT dependencies on PO_RELEASES_ALL

Line 203: from PO_RELEASES_ALL

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

Line 505: update PO_RELEASES_ALL

501: -- End of Bug 2850566
502:
503: /* reset the header-level acceptance_required_flag. */
504: IF (p_po_release_id is not null) THEN
505: update PO_RELEASES_ALL
506: set acceptance_required_flag = 'N',
507: acceptance_due_date = ''
508: where po_release_id = p_po_release_id;
509:

Line 628: from PO_RELEASES_all

624: l_accp_reqd_flag,
625: l_auth_status,
626: l_revision_num,
627: l_changed_by
628: from PO_RELEASES_all
629: where po_release_id = p_po_release_id;
630:
631: ELSE
632: select nvl(cancel_flag, 'N'),

Line 819: FROM PO_RELEASES_ALL POR

815:
816: IF (p_po_release_id is not null) THEN
817: SELECT POR.revision_num, authorization_status
818: INTO l_revision_num, l_authorization_status
819: FROM PO_RELEASES_ALL POR
820: WHERE POR.po_release_id = p_po_release_id;
821:
822: ELSIF (p_po_header_id is not null) THEN
823: SELECT POH.revision_num, authorization_status

Line 849: PO_RELEASES_ALL POR

845:
846: select PCR.action_type
847: into l_action_type
848: from PO_CHANGE_REQUESTS PCR,
849: PO_RELEASES_ALL POR
850: where pcr.document_line_location_id = P_line_location_id
851: and pcr.po_release_id = p_po_release_id
852: and por.po_release_id = p_po_release_id
853: and por.change_requested_by = 'SUPPLIER'

Line 923: from PO_RELEASES_ALL

919:
920: IF (p_po_release_id is not null) THEN
921: select nvl(acceptance_required_flag, 'N')
922: into l_acceptance_required_flag
923: from PO_RELEASES_ALL
924: where po_release_id = p_po_release_id
925: and revision_num = l_revision_num;
926:
927: IF (l_acceptance_required_flag in ('D','Y')) THEN

Line 1263: from po_releases_all

1259: /* Copy the previous revision shipment-level acknowledgement. */
1260: If (p_po_release_id is not null) THEN
1261: select agent_id
1262: into l_buyer_id
1263: from po_releases_all
1264: where po_release_id = p_po_release_id;
1265:
1266:
1267: -- Bug 2850566 RBAIRRAJ

Line 1513: From PO_CHANGE_REQUESTS pcr, po_releases_all por

1509: And pa.revision_num = p_revision_num
1510: And pa.po_line_location_id = PLL.line_location_id )
1511: And not exists (
1512: select 1
1513: From PO_CHANGE_REQUESTS pcr, po_releases_all por
1514: WHERE por.po_release_id = p_po_release_id
1515: and por.change_requested_by = 'SUPPLIER'
1516: and pcr.po_release_id = p_po_release_id
1517: AND PCR.document_revision_num = p_revision_num

Line 1704: FROM PO_RELEASES_ALL

1700: INTO l_buyer_id,
1701: l_revision_num,
1702: l_accp_required_flag,
1703: l_change_requested_by
1704: FROM PO_RELEASES_ALL
1705: WHERE po_release_id = p_po_release_id;
1706:
1707: ELSIF (p_po_header_id is not null) THEN
1708: SELECT agent_id,