APPS.PO_INTERFACE_S dependencies on PO_RELEASES_ALL

Line 1029: from po_releases_all --

1025: IF g_document_subtype = 'RELEASE' THEN
1026: l_progress:= '130';
1027: select release_num
1028: into x_release_number
1029: from po_releases_all --
1030: where po_release_id=x_document_id;
1031:
1032: x_document_number := interface.document_num || '-' || to_char(x_release_number);
1033:

Line 1126: update po_releases_all

1122:
1123: ELSIF g_document_subtype = 'RELEASE' THEN
1124:
1125: l_progress:= '170';
1126: update po_releases_all
1127: set authorization_status = 'APPROVED',
1128: approved_date = sysdate,
1129: approved_flag = 'Y'
1130: where po_release_id = x_document_id;

Line 1662: FROM po_releases_all --

1658: l_progress:='130';
1659:
1660: SELECT po_release_id
1661: INTO g_po_release_id
1662: FROM po_releases_all --
1663: WHERE release_num = interface.release_num
1664: AND po_header_id = interface.po_header_id
1665: FOR UPDATE OF approved_flag;
1666:

Line 1691: UPDATE PO_RELEASES_ALL --

1687: p_token => l_progress,
1688: p_message => 'Update PO_Releases Doc subtype is Release');
1689: END IF;
1690:
1691: UPDATE PO_RELEASES_ALL --
1692: SET last_update_date = interface.last_update_date,
1693: last_updated_by = interface.last_updated_by,
1694: last_update_login = interface.last_update_login,
1695: closed_code = 'OPEN',

Line 2164: -- insert it into po_releases_all instead of p_document_creation_method

2160: */
2161: l_progress:='280';
2162:
2163: -- Bug 3599251: Assign value to l_document_creation_method and
2164: -- insert it into po_releases_all instead of p_document_creation_method
2165: -- Bug 3648268 Use lookup code instead of hardcoded value
2166: IF g_interface_source_code = 'CONSUMPTION_ADVICE' THEN
2167: l_document_creation_method := 'CREATE_CONSUMPTION';
2168: END IF;

Line 2176: INSERT INTO po_releases_all --

2172: p_token => l_progress,
2173: p_message => 'Before insert into PO_RELEASES');
2174: END IF;
2175:
2176: INSERT INTO po_releases_all --
2177: (po_release_id,
2178: last_update_date,
2179: last_updated_by,
2180: po_header_id,

Line 2453: from po_releases_all por --

2449: begin
2450: l_progress := '380';
2451: select nvl(max(release_num),0) + 1
2452: into x_release_num
2453: from po_releases_all por --
2454: where por.po_header_id = interface.po_header_id;
2455: /*Bug 1724603
2456: When we are creating a blanket release for the first time then
2457: we end up creating releases with negative release numbers

Line 2467: update po_releases_all --

2463: x_release_num := 1;
2464: end if;
2465:
2466: l_progress := '390';
2467: update po_releases_all --
2468: set release_num = x_release_num
2469: where po_releases_all.po_header_id = interface.po_header_id
2470: and release_num = -g_po_release_id;
2471: exit;

Line 2469: where po_releases_all.po_header_id = interface.po_header_id

2465:
2466: l_progress := '390';
2467: update po_releases_all --
2468: set release_num = x_release_num
2469: where po_releases_all.po_header_id = interface.po_header_id
2470: and release_num = -g_po_release_id;
2471: exit;
2472: exception
2473: when DUP_VAL_ON_INDEX then

Line 5516: po_releases_all por --

5512: l_manual_price_change_flag, --bug 3495772
5513: x_secondary_unit_of_measure
5514: FROM po_line_locations_all poll, --
5515: po_lines_all pol, --
5516: po_releases_all por --
5517: WHERE poll.po_header_id = interface.po_header_id
5518: AND poll.po_line_id = pol.po_line_id
5519: AND poll.shipment_num = interface.shipment_num
5520: AND pol.line_num = interface.line_num

Line 8640: l_shipping_control PO_RELEASES_ALL.shipping_control%TYPE; --

8636: x_requestor_location_id number;
8637: x_location_code varchar2(25);
8638: x_employee_is_buyer boolean;
8639: x_is_emp boolean;
8640: l_shipping_control PO_RELEASES_ALL.shipping_control%TYPE; --
8641:
8642: Cursor C is select pli.rowid,
8643: pli.item_id,
8644: phi.vendor_id,

Line 10526: po_releases_all pr

10522: SELECT nvl(max(poll.shipment_num),0)
10523: INTO x_shipment_num
10524: FROM po_headers_all ph,
10525: po_line_locations_all poll,
10526: po_releases_all pr
10527: WHERE ph.po_header_id = poll.po_header_id
10528: AND ph.segment1 = x_document_num
10529: AND pr.po_header_id = ph.po_header_id
10530: AND pr.release_num = x_release_num

Line 12117: FROM po_releases_all por, --

12113: BEGIN
12114:
12115: SELECT por.po_release_id
12116: INTO g_po_release_id
12117: FROM po_releases_all por, --
12118: po_headers_interface phi
12119: WHERE phi.interface_header_id = x_interface_header_id
12120: AND phi.release_num = por.release_num
12121: AND phi.po_header_id = por.po_header_id

Line 12862: po_releases_all pr --

12858: select nvl(max(shipment_num),0)
12859: into x_shipment_num
12860: from po_headers_all ph, --
12861: po_line_locations_all poll, --
12862: po_releases_all pr --
12863: where ph.po_header_id = poll.po_header_id
12864: and ph.segment1 = x_document_num
12865: and pr.po_header_id = ph.po_header_id
12866: and pr.release_num = x_release_num