APPS.PO_VAL_SHIPMENTS dependencies on STANDARD

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

6: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;
7:
8: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
9: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
10: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';
11: c_PREPAYMENT CONSTANT VARCHAR2(30) := 'PREPAYMENT'; --
12: c_DELIVERY CONSTANT VARCHAR2(30) := 'DELIVERY'; --
13:
14: -- Constants for column names

Line 523: -- For Standard POs, verifies that the ship-to-org id is not null.

519: END promise_date_open_period_check;
520:
521:
522: -------------------------------------------------------------------------
523: -- For Standard POs, verifies that the ship-to-org id is not null.
524: -------------------------------------------------------------------------
525: PROCEDURE ship_to_org_null_check(
526: p_line_loc_id_tbl IN PO_TBL_NUMBER
527: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

Line 559: IF (p_shipment_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)) THEN

555: l_count := 0;
556:
557: -- : Include PREPAYMENT shipment_type in check
558: FOR i IN 1 .. l_input_size LOOP
559: IF (p_shipment_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)) THEN
560: l_count := l_count + 1;
561: l_line_loc_id_tbl(l_count) := p_line_loc_id_tbl(i);
562: l_ship_to_org_id_tbl(l_count) := p_ship_to_org_id_tbl(i);
563: END IF;

Line 591: -- For Standard POs, verifies that the ship-to-org id is not null

587:
588: END ship_to_org_null_check;
589:
590: -------------------------------------------------------------------------
591: -- For Standard POs, verifies that the ship-to-org id is not null
592: -------------------------------------------------------------------------
593: PROCEDURE ship_to_loc_null_check(
594: p_line_loc_id_tbl IN PO_TBL_NUMBER
595: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER

Line 627: IF (p_shipment_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)) THEN

623: l_count := 0;
624:
625: -- : Include PREPAYMENT shipment_type in check
626: FOR i IN 1 .. l_input_size LOOP
627: IF (p_shipment_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)) THEN
628: l_count := l_count + 1;
629: l_line_loc_id_tbl(l_count) := p_line_loc_id_tbl(i);
630: l_ship_to_loc_id_tbl(l_count) := p_ship_to_loc_id_tbl(i);
631: END IF;

Line 925: IF (p_shipment_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)

921: l_count := 0;
922:
923: -- : Include PREPAYMENT shipment_type in check
924: FOR i IN 1 .. l_input_size LOOP
925: IF (p_shipment_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)
926: AND p_value_basis_tbl(i) NOT IN (c_RATE,c_FIXED_PRICE)
927: )
928: THEN
929: IF (p_value_basis_tbl(i) = 'QUANTITY' OR

Line 1075: AND PLL.shipment_type IN (c_STANDARD, c_PREPAYMENT) --

1071: FROM
1072: PO_LINE_LOCATIONS_ALL PLL
1073: WHERE
1074: PLL.line_location_id = p_line_loc_id_tbl(i)
1075: AND PLL.shipment_type IN (c_STANDARD, c_PREPAYMENT) --
1076: AND p_quantity_tbl(i) IS NOT NULL
1077: -- Quantity is being reduced below the current transaction quantity:
1078: AND p_quantity_tbl(i) < PLL.quantity
1079: AND p_quantity_tbl(i) < GREATEST(NVL(PLL.quantity_received, 0),

Line 1153: IF (p_shipment_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)

1149: l_count := 0;
1150:
1151: -- : Include shipment_type of PREPAYMENT in check
1152: FOR i IN 1 .. l_input_size LOOP
1153: IF (p_shipment_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)
1154: AND p_value_basis_tbl(i) IN (c_RATE,c_FIXED_PRICE)
1155: )
1156: THEN
1157: IF (p_value_basis_tbl(i) = 'QUANTITY' OR

Line 1300: AND PLL.shipment_type IN (c_STANDARD, c_PREPAYMENT) --

1296: FROM
1297: PO_LINE_LOCATIONS_ALL PLL
1298: WHERE
1299: PLL.line_location_id = p_line_loc_id_tbl(i)
1300: AND PLL.shipment_type IN (c_STANDARD, c_PREPAYMENT) --
1301: AND p_amount_tbl(i) IS NOT NULL
1302: -- Amount is being reduced below the current transaction amount:
1303: AND p_amount_tbl(i) < PLL.amount
1304: AND p_amount_tbl(i) < GREATEST(NVL(PLL.amount_received, 0),