[Home] [Help]
7: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
8: PO_LOG.get_package_base('PO_DOCUMENT_TOTALS_PVT');
9:
10: -- Shipment type constants
11: C_ship_type_STANDARD CONSTANT
12: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
13: := PO_CORE_S.g_ship_type_STANDARD;
14: C_ship_type_PLANNED CONSTANT
15: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
9:
10: -- Shipment type constants
11: C_ship_type_STANDARD CONSTANT
12: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
13: := PO_CORE_S.g_ship_type_STANDARD;
14: C_ship_type_PLANNED CONSTANT
15: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
16: := PO_CORE_S.g_ship_type_PLANNED;
17: C_ship_type_SCHEDULED CONSTANT
141: -- None
142: --Function:
143: -- Based on given doc level and id, calculates the total amount ordered
144: -- for that entity
145: -- The API supports only Standard POs (both non-CWP and CWP)
146: --Parameters:
147: --IN:
148: --p_doc_level
149: -- The type of ids that are being passed. Use g_doc_level_<>
464: -- Calculates the Approved Amount for a given PO Line.
465: -- For a Complex Work PO, Approved Amount is the amount of work
466: -- confirmed against the UI-visible Pay Items of the line.
467: -- For a non-Complex Work PO, Approved Amount is always 0.
468: -- The API supports only Standard PO document types.
469: --Parameters:
470: --IN:
471: --p_line_id
472: -- The ID of the line for which to calculate the approved amount
617: -- Calculates the Approved Amount for a given PO Header.
618: -- For a Complex Work PO, Approved Amount is the amount of work
619: -- confirmed against the UI-visible Pay Items of the PO lines.
620: -- For a non-Complex Work PO, Approved Amount is always 0.
621: -- The API supports only Standard PO document types.
622: --Parameters:
623: --IN:
624: --p_line_id
625: -- The ID of the SPO Header for which to calculate the approved amount
771: -- For a Financing Complex Work PO, the Delivered Amount
772: -- is the amount of work confirmed against the final delivery
773: -- of the item.
774: -- For a non-CWP PO or an Actuals CWP PO, the Delivered Amount
775: -- is the amount of work confirmed against all the STANDARD
776: -- type shipments/pay items.
777: -- The API supports only the SPO document type.
778: --Parameters:
779: --IN:
845: FROM po_line_locations_all poll
846: , po_distributions_all pod
847: WHERE poll.po_line_id = p_line_id
848: AND pod.line_location_id = poll.line_location_id
849: AND pod.distribution_type = 'STANDARD'
850: ;
851: EXCEPTION
852: WHEN NO_DATA_FOUND THEN
853: IF PO_LOG.d_stmt THEN
872: FROM po_line_locations_archive_all poll
873: , po_distributions_archive_all pod
874: WHERE poll.po_line_id = p_line_id
875: AND pod.line_location_id = poll.line_location_id
876: AND pod.distribution_type = 'STANDARD'
877: AND ( (p_doc_revision_num IS NULL
878: AND poll.latest_external_flag = 'Y'
879: AND pod.latest_external_flag = 'Y')
880: OR (p_doc_revision_num IS NOT NULL
938: -- For a Financing Complex Work PO, the Delivered Amount
939: -- is the amount of work confirmed against the final delivery
940: -- of the items.
941: -- For a non-CWP PO or an Actuals CWP PO, the Delivered Amount
942: -- is the amount of work confirmed against all the STANDARD
943: -- type shipments/pay items.
944: -- The API supports only the SPO document type.
945: --Parameters:
946: --IN:
1012: FROM po_line_locations_all poll
1013: , po_distributions_all pod
1014: WHERE poll.po_header_id = p_header_id
1015: AND pod.line_location_id = poll.line_location_id
1016: AND pod.distribution_type = 'STANDARD'
1017: ;
1018: EXCEPTION
1019: WHEN NO_DATA_FOUND THEN
1020: IF PO_LOG.d_stmt THEN
1039: FROM po_line_locations_archive_all poll
1040: , po_distributions_archive_all pod
1041: WHERE poll.po_header_id = p_header_id
1042: AND pod.line_location_id = poll.line_location_id
1043: AND pod.distribution_type = 'STANDARD'
1044: AND ( (p_doc_revision_num IS NULL
1045: AND poll.latest_external_flag = 'Y'
1046: AND pod.latest_external_flag = 'Y')
1047: OR (p_doc_revision_num IS NOT NULL
1101: --Locks:
1102: -- None
1103: --Function:
1104: -- Calculates the Billed Amount for a given PO Line.
1105: -- Billed Amount is calculated based on the Standard Invoices
1106: -- against the PO Line. Prepayment Invoices are not included
1107: -- in the Billed Amount.
1108: -- The API supports only the SPO document type.
1109: --Parameters:
1168: SELECT SUM(nvl(amount_billed,0))
1169: INTO l_return_val
1170: FROM po_line_locations_all poll
1171: WHERE poll.po_line_id = p_line_id
1172: AND poll.shipment_type = 'STANDARD'
1173: ;
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: IF PO_LOG.d_stmt THEN
1187: SELECT SUM(nvl(amount_billed,0))
1188: INTO l_return_val
1189: FROM po_line_locations_archive_all poll
1190: WHERE poll.po_line_id = p_line_id
1191: AND poll.shipment_type='STANDARD'
1192: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1193: OR (p_doc_revision_num IS NOT NULL
1194: AND poll.revision_num =
1195: (SELECT max(POLL2.revision_num)
1242: --Locks:
1243: -- None
1244: --Function:
1245: -- Calculates the Billed Amount for a given PO Header.
1246: -- Billed Amount is calculated based on the Standard Invoices
1247: -- against the PO Line. Prepayment Invoices are not included
1248: -- in the Billed Amount.
1249: -- The API supports only the SPO document type.
1250: --Parameters:
1310: SELECT SUM(nvl(amount_billed,0))
1311: INTO l_return_val
1312: FROM po_line_locations_all poll
1313: WHERE poll.po_header_id = p_header_id
1314: AND poll.shipment_type = 'STANDARD'
1315: ;
1316: EXCEPTION
1317: WHEN NO_DATA_FOUND THEN
1318: IF PO_LOG.d_stmt THEN
1329: SELECT SUM(nvl(amount_billed,0))
1330: INTO l_return_val
1331: FROM po_line_locations_archive_all poll
1332: WHERE poll.po_header_id = p_header_id
1333: AND poll.shipment_type='STANDARD'
1334: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1335: OR (p_doc_revision_num IS NOT NULL
1336: AND poll.revision_num =
1337: (SELECT max(POLL2.revision_num)
1385: -- None
1386: --Function:
1387: -- Calculates the Financed Amount for a given PO Line.
1388: -- Financed Amount is calculated based on the Prepayment Invoices
1389: -- against the PO Line. Standard Invoices are not included
1390: -- in the Financed Amount.
1391: -- The API supports only the SPO document type.
1392: --Parameters:
1393: --IN:
1526: -- None
1527: --Function:
1528: -- Calculates the Financed Amount for a given PO Header.
1529: -- Financed Amount is calculated based on the Prepayment Invoices
1530: -- against the PO Header. Standard Invoices are not included
1531: -- in the Financed Amount.
1532: -- The API supports only the SPO document type.
1533: --Parameters:
1534: --IN:
2010: - nvl(retainage_released_amount,0))
2011: INTO l_return_val
2012: FROM po_line_locations_all poll
2013: WHERE poll.po_line_id = p_line_id
2014: AND poll.shipment_type = 'STANDARD'
2015: ;
2016: EXCEPTION
2017: WHEN NO_DATA_FOUND THEN
2018: IF PO_LOG.d_stmt THEN
2030: - nvl(retainage_released_amount,0))
2031: INTO l_return_val
2032: FROM po_line_locations_archive_all poll
2033: WHERE poll.po_line_id = p_line_id
2034: AND poll.shipment_type='STANDARD'
2035: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2036: OR (p_doc_revision_num IS NOT NULL
2037: AND poll.revision_num =
2038: (SELECT max(POLL2.revision_num)
2152: - nvl(retainage_released_amount,0))
2153: INTO l_return_val
2154: FROM po_line_locations_all poll
2155: WHERE poll.po_header_id = p_header_id
2156: AND poll.shipment_type = 'STANDARD'
2157: ;
2158: EXCEPTION
2159: WHEN NO_DATA_FOUND THEN
2160: IF PO_LOG.d_stmt THEN
2172: - nvl(retainage_released_amount,0))
2173: INTO l_return_val
2174: FROM po_line_locations_archive_all poll
2175: WHERE poll.po_header_id = p_header_id
2176: AND poll.shipment_type='STANDARD'
2177: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2178: OR (p_doc_revision_num IS NOT NULL
2179: AND poll.revision_num =
2180: (SELECT max(POLL2.revision_num)
2282: SELECT SUM(poll.quantity)
2283: INTO l_return_val
2284: FROM po_line_locations_all poll
2285: WHERE poll.po_line_id = p_line_id
2286: AND poll.shipment_type = 'STANDARD'
2287: ;
2288: EXCEPTION
2289: WHEN NO_DATA_FOUND THEN
2290: IF PO_LOG.d_stmt THEN
2391: *poll.price_override),l_precision) ) )) --Bug5391045
2392: INTO l_return_val
2393: FROM po_line_locations_all poll
2394: WHERE poll.po_line_id = p_line_id
2395: AND poll.shipment_type = 'STANDARD'
2396: ;
2397: EXCEPTION
2398: WHEN NO_DATA_FOUND THEN
2399: IF PO_LOG.d_stmt THEN
2721: -- PO
2722: -- RELEASE
2723: --p_doc_subtype
2724: -- Document type. Use the g_doc_type_<> variables, where <> is:
2725: -- STANDARD
2726: -- PLANNED
2727: -- BLANKET
2728: -- SCHEDULED
2729: --p_doc_level
2893: -- PO
2894: -- RELEASE
2895: --p_doc_subtype
2896: -- Document type. Use the g_doc_type_<> variables, where <> is:
2897: -- STANDARD
2898: -- PLANNED
2899: -- BLANKET
2900: -- SCHEDULED
2901: --p_doc_level
3070: -- PO
3071: -- RELEASE
3072: --p_doc_subtype
3073: -- Document type. Use the g_doc_type_<> variables, where <> is:
3074: -- STANDARD
3075: -- PLANNED
3076: -- BLANKET
3077: -- SCHEDULED
3078: --p_doc_level