APPS.PO_RELEASES_SV4 dependencies on PO_RELEASES

Line 1: PACKAGE BODY PO_RELEASES_SV4 as

1: PACKAGE BODY PO_RELEASES_SV4 as
2: /* $Header: POXPOR4B.pls 120.1 2006/03/23 04:50:22 amony noship $ */
3:
4:
5: /*===========================================================================

Line 143: FROM po_releases POR

139: X_progress varchar2(3) := '';
140:
141: CURSOR C is
142: SELECT to_number(max(POR.release_num) + 1)
143: FROM po_releases POR
144: WHERE POR.po_header_id = X_po_header_id;
145:
146: BEGIN
147:

Line 207: from po_line_locations pll, po_releases pr where

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

Line 224: from po_releases

220: begin
221:
222: select 1
223: into v_count
224: from po_releases
225: where po_header_id = X_po_release_id_record.po_header_id
226: and release_num = X_po_release_id_record.release_num;
227:
228: exception

Line 256: from po_line_locations pll, po_releases pr where

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;

Line 268: from po_line_locations pll, po_releases pr where

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;

Line 278: from po_line_locations pll, po_releases pr where

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;

Line 457: FROM PO_RELEASES POR

453: ** po header id exists in the database.
454: */
455: CURSOR C is
456: SELECT 'N'
457: FROM PO_RELEASES POR
458: WHERE POR.po_header_id = X_po_header_id
459: AND POR.release_num = X_release_num
460: AND (X_rowid is null OR
461: X_rowid <> POR.rowid);

Line 527: FROM PO_RELEASES POR

523: ** have changed.
524: */
525: CURSOR C is
526: SELECT 'Y'
527: FROM PO_RELEASES POR
528: WHERE POR.po_release_id = X_po_release_id
529: AND ( POR.release_num <> X_release_num
530: OR POR.agent_id <> X_agent_id
531: OR POR.release_date <> X_release_date

Line 593: END PO_RELEASES_SV4;

589: raise;
590: END val_approval_status;
591:
592:
593: END PO_RELEASES_SV4;