eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_TOTALS_PVT dependencies on STANDARD

Line 11: C_ship_type_STANDARD CONSTANT

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

Line 13: := PO_CORE_S.g_ship_type_STANDARD;

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

Line 145: -- The API supports only Standard POs (both non-CWP and CWP)

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: -- : Added draft_id as param, and replaced transaction tables with
147: -- merge views.
148: --Parameters:
149: --IN:

Line 477: -- The API supports only Standard PO document types.

473: -- Calculates the Approved Amount for a given PO Line.
474: -- For a Complex Work PO, Approved Amount is the amount of work
475: -- confirmed against the UI-visible Pay Items of the line.
476: -- For a non-Complex Work PO, Approved Amount is always 0.
477: -- The API supports only Standard PO document types.
478: --Parameters:
479: --IN:
480: --p_line_id
481: -- The ID of the line for which to calculate the approved amount

Line 630: -- The API supports only Standard PO document types.

626: -- Calculates the Approved Amount for a given PO Header.
627: -- For a Complex Work PO, Approved Amount is the amount of work
628: -- confirmed against the UI-visible Pay Items of the PO lines.
629: -- For a non-Complex Work PO, Approved Amount is always 0.
630: -- The API supports only Standard PO document types.
631: --Parameters:
632: --IN:
633: --p_line_id
634: -- The ID of the SPO Header for which to calculate the approved amount

Line 784: -- is the amount of work confirmed against all the STANDARD

780: -- For a Financing Complex Work PO, the Delivered Amount
781: -- is the amount of work confirmed against the final delivery
782: -- of the item.
783: -- For a non-CWP PO or an Actuals CWP PO, the Delivered Amount
784: -- is the amount of work confirmed against all the STANDARD
785: -- type shipments/pay items.
786: -- The API supports only the SPO document type.
787: --Parameters:
788: --IN:

Line 858: AND pod.distribution_type = 'STANDARD'

854: FROM po_line_locations_all poll
855: , po_distributions_all pod
856: WHERE poll.po_line_id = p_line_id
857: AND pod.line_location_id = poll.line_location_id
858: AND pod.distribution_type = 'STANDARD'
859: ;
860: EXCEPTION
861: WHEN NO_DATA_FOUND THEN
862: IF PO_LOG.d_stmt THEN

Line 885: AND pod.distribution_type = 'STANDARD'

881: FROM po_line_locations_archive_all poll
882: , po_distributions_archive_all pod
883: WHERE poll.po_line_id = p_line_id
884: AND pod.line_location_id = poll.line_location_id
885: AND pod.distribution_type = 'STANDARD'
886: AND ( (p_doc_revision_num IS NULL
887: AND poll.latest_external_flag = 'Y'
888: AND pod.latest_external_flag = 'Y')
889: OR (p_doc_revision_num IS NOT NULL

Line 951: -- is the amount of work confirmed against all the STANDARD

947: -- For a Financing Complex Work PO, the Delivered Amount
948: -- is the amount of work confirmed against the final delivery
949: -- of the items.
950: -- For a non-CWP PO or an Actuals CWP PO, the Delivered Amount
951: -- is the amount of work confirmed against all the STANDARD
952: -- type shipments/pay items.
953: -- The API supports only the SPO document type.
954: --Parameters:
955: --IN:

Line 1025: AND pod.distribution_type = 'STANDARD'

1021: FROM po_line_locations_all poll
1022: , po_distributions_all pod
1023: WHERE poll.po_header_id = p_header_id
1024: AND pod.line_location_id = poll.line_location_id
1025: AND pod.distribution_type = 'STANDARD'
1026: ;
1027: EXCEPTION
1028: WHEN NO_DATA_FOUND THEN
1029: IF PO_LOG.d_stmt THEN

Line 1052: AND pod.distribution_type = 'STANDARD'

1048: FROM po_line_locations_archive_all poll
1049: , po_distributions_archive_all pod
1050: WHERE poll.po_header_id = p_header_id
1051: AND pod.line_location_id = poll.line_location_id
1052: AND pod.distribution_type = 'STANDARD'
1053: AND ( (p_doc_revision_num IS NULL
1054: AND poll.latest_external_flag = 'Y'
1055: AND pod.latest_external_flag = 'Y')
1056: OR (p_doc_revision_num IS NOT NULL

Line 1114: -- Billed Amount is calculated based on the Standard Invoices

1110: --Locks:
1111: -- None
1112: --Function:
1113: -- Calculates the Billed Amount for a given PO Line.
1114: -- Billed Amount is calculated based on the Standard Invoices
1115: -- against the PO Line. Prepayment Invoices are not included
1116: -- in the Billed Amount.
1117: -- The API supports only the SPO document type.
1118: --Parameters:

Line 1181: AND poll.shipment_type = 'STANDARD'

1177: SELECT SUM(nvl(amount_billed,0))
1178: INTO l_return_val
1179: FROM po_line_locations_all poll
1180: WHERE poll.po_line_id = p_line_id
1181: AND poll.shipment_type = 'STANDARD'
1182: ;
1183: EXCEPTION
1184: WHEN NO_DATA_FOUND THEN
1185: IF PO_LOG.d_stmt THEN

Line 1200: AND poll.shipment_type='STANDARD'

1196: SELECT SUM(nvl(amount_billed,0))
1197: INTO l_return_val
1198: FROM po_line_locations_archive_all poll
1199: WHERE poll.po_line_id = p_line_id
1200: AND poll.shipment_type='STANDARD'
1201: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1202: OR (p_doc_revision_num IS NOT NULL
1203: AND poll.revision_num =
1204: (SELECT max(POLL2.revision_num)

Line 1255: -- Billed Amount is calculated based on the Standard Invoices

1251: --Locks:
1252: -- None
1253: --Function:
1254: -- Calculates the Billed Amount for a given PO Header.
1255: -- Billed Amount is calculated based on the Standard Invoices
1256: -- against the PO Line. Prepayment Invoices are not included
1257: -- in the Billed Amount.
1258: -- The API supports only the SPO document type.
1259: --Parameters:

Line 1323: AND poll.shipment_type = 'STANDARD'

1319: SELECT SUM(nvl(amount_billed,0))
1320: INTO l_return_val
1321: FROM po_line_locations_all poll
1322: WHERE poll.po_header_id = p_header_id
1323: AND poll.shipment_type = 'STANDARD'
1324: ;
1325: EXCEPTION
1326: WHEN NO_DATA_FOUND THEN
1327: IF PO_LOG.d_stmt THEN

Line 1342: AND poll.shipment_type='STANDARD'

1338: SELECT SUM(nvl(amount_billed,0))
1339: INTO l_return_val
1340: FROM po_line_locations_archive_all poll
1341: WHERE poll.po_header_id = p_header_id
1342: AND poll.shipment_type='STANDARD'
1343: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1344: OR (p_doc_revision_num IS NOT NULL
1345: AND poll.revision_num =
1346: (SELECT max(POLL2.revision_num)

Line 1398: -- against the PO Line. Standard Invoices are not included

1394: -- None
1395: --Function:
1396: -- Calculates the Financed Amount for a given PO Line.
1397: -- Financed Amount is calculated based on the Prepayment Invoices
1398: -- against the PO Line. Standard Invoices are not included
1399: -- in the Financed Amount.
1400: -- The API supports only the SPO document type.
1401: --Parameters:
1402: --IN:

Line 1539: -- against the PO Header. Standard Invoices are not included

1535: -- None
1536: --Function:
1537: -- Calculates the Financed Amount for a given PO Header.
1538: -- Financed Amount is calculated based on the Prepayment Invoices
1539: -- against the PO Header. Standard Invoices are not included
1540: -- in the Financed Amount.
1541: -- The API supports only the SPO document type.
1542: --Parameters:
1543: --IN:

Line 2023: AND poll.shipment_type = 'STANDARD'

2019: - nvl(retainage_released_amount,0))
2020: INTO l_return_val
2021: FROM po_line_locations_all poll
2022: WHERE poll.po_line_id = p_line_id
2023: AND poll.shipment_type = 'STANDARD'
2024: ;
2025: EXCEPTION
2026: WHEN NO_DATA_FOUND THEN
2027: IF PO_LOG.d_stmt THEN

Line 2043: AND poll.shipment_type='STANDARD'

2039: - nvl(retainage_released_amount,0))
2040: INTO l_return_val
2041: FROM po_line_locations_archive_all poll
2042: WHERE poll.po_line_id = p_line_id
2043: AND poll.shipment_type='STANDARD'
2044: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2045: OR (p_doc_revision_num IS NOT NULL
2046: AND poll.revision_num =
2047: (SELECT max(POLL2.revision_num)

Line 2165: AND poll.shipment_type = 'STANDARD'

2161: - nvl(retainage_released_amount,0))
2162: INTO l_return_val
2163: FROM po_line_locations_all poll
2164: WHERE poll.po_header_id = p_header_id
2165: AND poll.shipment_type = 'STANDARD'
2166: ;
2167: EXCEPTION
2168: WHEN NO_DATA_FOUND THEN
2169: IF PO_LOG.d_stmt THEN

Line 2185: AND poll.shipment_type='STANDARD'

2181: - nvl(retainage_released_amount,0))
2182: INTO l_return_val
2183: FROM po_line_locations_archive_all poll
2184: WHERE poll.po_header_id = p_header_id
2185: AND poll.shipment_type='STANDARD'
2186: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2187: OR (p_doc_revision_num IS NOT NULL
2188: AND poll.revision_num =
2189: (SELECT max(POLL2.revision_num)

Line 2298: AND poll.shipment_type = 'STANDARD';

2294: INTO l_return_val
2295: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
2296: WHERE poll.po_line_id = p_line_id
2297: AND poll.draft_id = p_draft_id
2298: AND poll.shipment_type = 'STANDARD';
2299: EXCEPTION
2300: WHEN NO_DATA_FOUND THEN
2301: IF PO_LOG.d_stmt THEN
2302: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

Line 2409: AND poll.shipment_type = 'STANDARD'

2405: INTO l_return_val
2406: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
2407: WHERE poll.po_line_id = p_line_id
2408: AND poll.draft_id = p_draft_id
2409: AND poll.shipment_type = 'STANDARD'
2410: ;
2411: EXCEPTION
2412: WHEN NO_DATA_FOUND THEN
2413: IF PO_LOG.d_stmt THEN

Line 2844: -- STANDARD

2840: -- PO
2841: -- RELEASE
2842: --p_doc_subtype
2843: -- Document type. Use the g_doc_type_<> variables, where <> is:
2844: -- STANDARD
2845: -- PLANNED
2846: -- BLANKET
2847: -- SCHEDULED
2848: --p_doc_level

Line 3016: -- STANDARD

3012: -- PO
3013: -- RELEASE
3014: --p_doc_subtype
3015: -- Document type. Use the g_doc_type_<> variables, where <> is:
3016: -- STANDARD
3017: -- PLANNED
3018: -- BLANKET
3019: -- SCHEDULED
3020: --p_doc_level

Line 3193: -- STANDARD

3189: -- PO
3190: -- RELEASE
3191: --p_doc_subtype
3192: -- Document type. Use the g_doc_type_<> variables, where <> is:
3193: -- STANDARD
3194: -- PLANNED
3195: -- BLANKET
3196: -- SCHEDULED
3197: --p_doc_level

Line 4302: -- The API supports only Standard POs

4298: -- None
4299: --Function:
4300: -- Based on given doc level and id, calculates the total amount ordered
4301: -- for that entity (Excluding Option Lines)
4302: -- The API supports only Standard POs
4303: --Parameters:
4304: --IN:
4305: --p_doc_level
4306: -- The type of ids that are being passed. Use g_doc_level_<>