[Home] [Help]
40: /* Bug#2567391 : Replaced the following call which gets the release header
41: total with the above call to handle the rounding problem in running
42: total implementation. Commenting the following call
43: X_rel_total :=
44: po_line_locations_pkg_s3.select_summary(X_release_id); */
45:
46:
47: --
48: PO_CORE_S.should_display_reserved(
63: INTO X_ship_via_lookup_code
64: FROM po_headers
65: WHERE po_header_id = X_po_header_id;
66:
67: X_ship_num := po_line_locations_pkg_s3.get_max_shipment_num(NULL,
68: X_release_id,
69: X_release_type);
70:
71: --< Bug 3378554 Start >
203:
204: select pll.po_release_id, pll.line_location_id
205: into X_po_release_id_record.po_release_id ,
206: X_po_release_id_record.po_line_location_id
207: from po_line_locations pll, po_releases pr where
208: pll.po_line_id = nvl(X_po_release_id_record.po_line_id,pll.po_line_id) and --1830177
209: pll.po_release_id = pr.po_release_id and
210: pr.po_header_id = X_po_release_id_record.po_header_id and
211: pr.release_num = X_po_release_id_record.release_num and
252: IF X_po_release_id_record.shipment_num IS NULL AND
253: X_po_release_id_record.release_num IS NOT NULL THEN
254:
255: select count(*) into v_count
256: from po_line_locations pll, po_releases pr where
257: pll.po_line_id = nvl(X_po_release_id_record.po_line_id,pll.po_line_id) and --1830177
258: pll.po_release_id = pr.po_release_id and
259: pr.po_header_id = X_po_release_id_record.po_header_id and
260: pr.release_num = X_po_release_id_record.release_num;
264: select pll.po_release_id, pll.line_location_id, pll.shipment_num
265: into X_po_release_id_record.po_release_id ,
266: X_po_release_id_record.po_line_location_id,
267: X_po_release_id_record.shipment_num
268: from po_line_locations pll, po_releases pr where
269: pll.po_line_id = nvl(X_po_release_id_record.po_line_id,pll.po_line_id) and --1830177
270: pll.po_release_id = pr.po_release_id and
271: pr.po_header_id = X_po_release_id_record.po_header_id and
272: pr.release_num = X_po_release_id_record.release_num;
274: ELSIF v_count > 1 then
275:
276: select distinct pll.po_release_id
277: into X_po_release_id_record.po_release_id
278: from po_line_locations pll, po_releases pr where
279: pll.po_line_id = nvl(X_po_release_id_record.po_line_id,pll.po_line_id) and--1830177
280: pll.po_release_id = pr.po_release_id and
281: pr.po_header_id = X_po_release_id_record.po_header_id and
282: pr.release_num = X_po_release_id_record.release_num;
307: IF X_po_release_id_record.shipment_num IS NOT NULL AND
308: X_po_release_id_record.release_num IS NULL THEN
309:
310: select count(*) into v_count
311: from po_line_locations pll
312: where
313: pll.po_line_id = X_po_release_id_record.po_line_id and
314: pll.shipment_num = X_po_release_id_record.shipment_num;
315:
317:
318: select pll.po_release_id, pll.line_location_id
319: into X_po_release_id_record.po_release_id ,
320: X_po_release_id_record.po_line_location_id
321: from po_line_locations pll
322: where
323: pll.po_line_id = X_po_release_id_record.po_line_id and
324: pll.shipment_num = X_po_release_id_record.shipment_num;
325:
343: IF X_po_release_id_record.shipment_num IS NULL AND
344: X_po_release_id_record.release_num IS NULL THEN
345:
346: select count(*) into v_count
347: from po_line_locations pll
348: where
349: pll.po_line_id = X_po_release_id_record.po_line_id
350: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
351: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
357: select pll.po_release_id, pll.line_location_id, pll.shipment_num
358: into X_po_release_id_record.po_release_id ,
359: X_po_release_id_record.po_line_location_id,
360: X_po_release_id_record.shipment_num
361: from po_line_locations pll
362: where
363: pll.po_line_id = X_po_release_id_record.po_line_id
364: and NVL(pll.APPROVED_FLAG,'N') = 'Y' -- bug 610238 should include the same clause as above
365: and NVL(pll.CANCEL_FLAG, 'N') = 'N'