APPS.PO_VAL_DISTRIBUTIONS dependencies on STANDARD

Line 8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

4: c_ENTITY_TYPE_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_DISTRIBUTION;
5: c_NEW CONSTANT VARCHAR2(3) := 'NEW';
6: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
7: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';
9: c_PREPAYMENT CONSTANT VARCHAR2(30) := 'PREPAYMENT'; --
10: c_DEST_TYPE_SHOP_FLOOR CONSTANT VARCHAR2(30) := 'SHOP FLOOR';
11: c_DEST_TYPE_EXPENSE CONSTANT VARCHAR2(30) := 'EXPENSE';
12: c_DEST_TYPE_INVENTORY CONSTANT VARCHAR2(30) :='INVENTORY';

Line 299: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --

295: FROM
296: PO_DISTRIBUTIONS_ALL POD
297: WHERE
298: POD.po_distribution_id = p_dist_id_tbl(i)
299: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --
300: -- Quantity is being reduced below the current transaction quantity:
301: AND p_qty_ordered_tbl(i) < POD.quantity_ordered
302: AND p_qty_ordered_tbl(i) < --
303: GREATEST(NVL(POD.quantity_delivered, 0),

Line 451: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --

447: FROM
448: PO_DISTRIBUTIONS_ALL POD
449: WHERE
450: POD.po_distribution_id = p_dist_id_tbl(i)
451: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --
452: -- Amount is being reduced below the current transaction amount:
453: AND p_amt_ordered_tbl(i) < POD.amount_ordered
454: AND p_amt_ordered_tbl(i) < GREATEST(NVL(POD.amount_delivered, 0),
455: NVL(POD.amount_financed, 0),

Line 962: -- For Standard POs only.

958:
959: ------------------------------------------------------------------------
960: -- ECO 4059111
961: -- Performs the federal financial validations for distributions
962: -- For Standard POs only.
963: ------------------------------------------------------------------------
964: PROCEDURE check_fv_validations(
965: p_dist_id_tbl IN PO_TBL_NUMBER
966: , p_ccid_tbl IN PO_TBL_NUMBER

Line 1800: -- Valid Distributions are CLM-enabled, STANDARD type,

1796: -- A view of the in-memory and stored data will be constructed
1797: -- as follows:
1798: -- 1. Gather the in-memory data(distribution_id,req_distribution_id,funded_value)
1799: -- and the stored data(PO_DISTRIBUTIONS_MERGE_V.funded_value) into the temp table.
1800: -- Valid Distributions are CLM-enabled, STANDARD type,
1801: -- having a Req reference, and when PO and Req Encumbrance is On
1802: -- 2. Compare the temp table data with Funds remaining on Req as follows:
1803: -- For each distinct Req being referred to by the Distributions, record error If
1804: -- For Base Documeny:

Line 1836: AND p_dist_type_tbl(i) = c_STANDARD

1832: WHERE po_distribution_id = p_dist_id_tbl(i)
1833: AND draft_id = Nvl(p_draft_id_tbl(i), -1))
1834: FROM dual
1835: WHERE p_req_dist_id_tbl(i) IS NOT NULL
1836: AND p_dist_type_tbl(i) = c_STANDARD
1837: AND PO_DOC_STYLE_HELPER.get_clm_flag(p_style_id => p_style_id_tbl(i)) = 'Y'
1838: AND EXISTS(
1839: SELECT NULL
1840: FROM FINANCIALS_SYSTEM_PARAMS_ALL