29:
30: FUNCTION isPoLineApproved(v_po_line_id in Number)
31: RETURN NUMBER as
32: CURSOR getPoLineApproval IS SELECT COUNT(*)
33: FROM po_line_locations_all
34: WHERE po_line_id=v_po_line_id and approved_flag='Y';
35:
36: returnvalue number(10);
37: BEGIN
345: END signOf;
346:
347: /*
348: ** sumPoLineLocs summarizes the quantity*price_override
349: ** from po_line_locations_all for the given po_header_id
350: **
351: ** Taken from Po_Ip_Oagxml_Pkg.
352: */
353: FUNCTION sumPoLineLocs (
356: ) RETURN NUMBER as
357: returnValue NUMBER := 0;
358: CURSOR sumValue IS
359: SELECT sum( quantity * price_override )
360: FROM po_line_locations_all
361: WHERE po_header_id = poHeaderId;
362: CURSOR sumValueRel IS
363: SELECT sum( quantity * price_override )
364: FROM po_line_locations_all
360: FROM po_line_locations_all
361: WHERE po_header_id = poHeaderId;
362: CURSOR sumValueRel IS
363: SELECT sum( quantity * price_override )
364: FROM po_line_locations_all
365: WHERE po_header_id = poHeaderId
366: AND po_release_id = poRelease;
367: BEGIN
368: IF poHeaderId IS NOT NULL THEN