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.OE_VALIDATE_LINE dependencies on OE_ORDER_PUB

Line 20: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

16: against transaction phase (Negotiation vs Fulfillment).
17: --------------------------------------------------------*/
18:
19: PROCEDURE Check_Negotiation_Attributes
20: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
21: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
22: , x_return_status IN OUT NOCOPY VARCHAR2
23: )
24: IS

Line 21: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

17: --------------------------------------------------------*/
18:
19: PROCEDURE Check_Negotiation_Attributes
20: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
21: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
22: , x_return_status IN OUT NOCOPY VARCHAR2
23: )
24: IS
25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 250: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

246: -- orders.
247:
248:
249: PROCEDURE Check_Book_Reqd_Attributes
250: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
251: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
252: , x_return_status IN OUT NOCOPY VARCHAR2
253: )
254: IS

Line 251: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

247:
248:
249: PROCEDURE Check_Book_Reqd_Attributes
250: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
251: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
252: , x_return_status IN OUT NOCOPY VARCHAR2
253: )
254: IS
255: l_proj_ref_enabled NUMBER;

Line 759: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

755: -- procedure Entity.
756: -----------------------------------------------------------
757:
758: Procedure Validate_ShipSet_SMC
759: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
760: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
761: ,x_return_status OUT NOCOPY VARCHAR2
762: )
763: IS

Line 760: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

756: -----------------------------------------------------------
757:
758: Procedure Validate_ShipSet_SMC
759: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
760: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
761: ,x_return_status OUT NOCOPY VARCHAR2
762: )
763: IS
764: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1061: (p_line_rec IN OE_ORDER_PUB.Line_rec_type

1057: for ATO options are allowed.
1058: -----------------------------------------------------------------------*/
1059:
1060: PROCEDURE Decimal_Ratio_Check
1061: (p_line_rec IN OE_ORDER_PUB.Line_rec_type
1062: ,x_return_status OUT NOCOPY VARCHAR2)
1063: IS
1064: l_ordered_item VARCHAR2(2000);
1065: l_item_type_code VARCHAR2(30);

Line 1157: Procedure Validate_Line_Type(p_line_rec IN oe_order_pub.line_rec_type,

1153: END Decimal_Ratio_Check;
1154:
1155:
1156:
1157: Procedure Validate_Line_Type(p_line_rec IN oe_order_pub.line_rec_type,
1158: p_old_line_rec IN oe_order_pub.line_rec_type)
1159: IS
1160:
1161: lorder_type_id NUMBER;

Line 1158: p_old_line_rec IN oe_order_pub.line_rec_type)

1154:
1155:
1156:
1157: Procedure Validate_Line_Type(p_line_rec IN oe_order_pub.line_rec_type,
1158: p_old_line_rec IN oe_order_pub.line_rec_type)
1159: IS
1160:
1161: lorder_type_id NUMBER;
1162: lexists VARCHAR2(30);

Line 1389: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

1385: END Validate_Receiving_Org;
1386:
1387: -- bug 6647169 begin
1388: FUNCTION Validate_Warehouse_Change
1389: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1390: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1391: ) RETURN BOOLEAN
1392: IS
1393: l_result BOOLEAN;

Line 1390: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

1386:
1387: -- bug 6647169 begin
1388: FUNCTION Validate_Warehouse_Change
1389: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1390: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1391: ) RETURN BOOLEAN
1392: IS
1393: l_result BOOLEAN;
1394: l_shipable_flag_new VARCHAR2(1);

Line 2572: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

2568: -- given sold_to_org_id, and against OTA course end date.
2569: ---------------------------------------------------
2570:
2571: PROCEDURE Validate_Commitment
2572: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2573: , p_hdr_currency_code IN VARCHAR2
2574: , p_ota_line IN BOOLEAN := FALSE
2575: , x_return_status OUT NOCOPY VARCHAR2
2576: ) IS

Line 2815: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

2811: We use this procedure to add validations related to source_type
2812: = EXTERNAL.
2813: --------------------------------------------------------------*/
2814: PROCEDURE Validate_Source_Type
2815: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2816: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2817: ,x_return_status OUT NOCOPY VARCHAR2)
2818:
2819: IS

Line 2816: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

2812: = EXTERNAL.
2813: --------------------------------------------------------------*/
2814: PROCEDURE Validate_Source_Type
2815: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2816: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2817: ,x_return_status OUT NOCOPY VARCHAR2)
2818:
2819: IS
2820: l_purchasing_enabled_flag VARCHAR2(1) := 'Y';

Line 2937: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

2933: END Validate_Source_Type;
2934:
2935:
2936: FUNCTION Validate_Set_id
2937: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2938: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type)
2939: RETURN BOOLEAN
2940: IS
2941: l_arrival_set_id Number;

Line 2938: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type)

2934:
2935:
2936: FUNCTION Validate_Set_id
2937: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2938: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type)
2939: RETURN BOOLEAN
2940: IS
2941: l_arrival_set_id Number;
2942: l_ship_set_id Number;

Line 3034: (p_line_rec IN OE_Order_PUB.Line_Rec_Type

3030: RETURN FALSE;
3031: END Validate_Set_id;
3032:
3033: PROCEDURE Validate_User_Item_Description
3034: (p_line_rec IN OE_Order_PUB.Line_Rec_Type
3035: , x_return_status OUT NOCOPY VARCHAR2
3036:
3037: )
3038: IS

Line 3078: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,

3074: -- Procedure Validate_Blanket_Values
3075: ----------------------------------------------------------------------------
3076:
3077: Procedure Validate_Blanket_Values
3078: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,
3079: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type,
3080: x_return_status OUT NOCOPY VARCHAR2
3081: )
3082: IS

Line 3079: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type,

3075: ----------------------------------------------------------------------------
3076:
3077: Procedure Validate_Blanket_Values
3078: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,
3079: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type,
3080: x_return_status OUT NOCOPY VARCHAR2
3081: )
3082: IS
3083: l_temp VARCHAR2(240);

Line 3718: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

3714: returns. In case the line is part of ato model the function also returns the
3715: ato_line_id. Added for bug 3718547.
3716: ------------------------------------------------------------------------------*/
3717: PROCEDURE Get_Return_Line_Attributes
3718: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
3719: , x_line_id OUT NOCOPY NUMBER
3720: , x_item_type_code OUT NOCOPY VARCHAR2
3721: , x_ato_line_id OUT NOCOPY NUMBER
3722: , x_return_status OUT NOCOPY VARCHAR2

Line 3776: , p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3772: --
3773: --
3774: PROCEDURE Entity
3775: ( x_return_status OUT NOCOPY VARCHAR2
3776: , p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3777: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
3778: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3779: )
3780: IS

Line 3777: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC

3773: --
3774: PROCEDURE Entity
3775: ( x_return_status OUT NOCOPY VARCHAR2
3776: , p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3777: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
3778: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3779: )
3780: IS
3781: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3895: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

3891: AND mmt.organization_id = ool.ship_from_org_id;
3892: -- AND mmt.revision = p_line_rec.item_revision;
3893:
3894: -- For bug3327250
3895: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3896: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3897: l_control_rec OE_GLOBALS.Control_Rec_Type;
3898: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
3899: -- Variable to indicate Referenced RMA creation or change of reference

Line 3896: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3892: -- AND mmt.revision = p_line_rec.item_revision;
3893:
3894: -- For bug3327250
3895: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3896: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3897: l_control_rec OE_GLOBALS.Control_Rec_Type;
3898: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
3899: -- Variable to indicate Referenced RMA creation or change of reference
3900: G_REF_RMA VARCHAR2(1) := 'N';

Line 3898: l_old_line_rec OE_Order_PUB.Line_Rec_Type;

3894: -- For bug3327250
3895: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3896: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3897: l_control_rec OE_GLOBALS.Control_Rec_Type;
3898: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
3899: -- Variable to indicate Referenced RMA creation or change of reference
3900: G_REF_RMA VARCHAR2(1) := 'N';
3901: -- Variable to indicate that a oe_order_pvt.line call is needed to redefault
3902: -- Missing / Invalid attributes

Line 8128: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

8124:
8125: PROCEDURE Attributes
8126: ( x_return_status OUT NOCOPY VARCHAR2
8127:
8128: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
8129: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
8130: OE_Order_PUB.G_MISS_LINE_REC
8131: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
8132: )

Line 8129: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

8125: PROCEDURE Attributes
8126: ( x_return_status OUT NOCOPY VARCHAR2
8127:
8128: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
8129: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
8130: OE_Order_PUB.G_MISS_LINE_REC
8131: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
8132: )
8133: IS

Line 8130: OE_Order_PUB.G_MISS_LINE_REC

8126: ( x_return_status OUT NOCOPY VARCHAR2
8127:
8128: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
8129: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
8130: OE_Order_PUB.G_MISS_LINE_REC
8131: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
8132: )
8133: IS
8134: l_return_status VARCHAR2(1);

Line 8135: l_header_rec OE_Order_PUB.Header_Rec_Type;

8131: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
8132: )
8133: IS
8134: l_return_status VARCHAR2(1);
8135: l_header_rec OE_Order_PUB.Header_Rec_Type;
8136: l_type_code VARCHAR2(30);
8137: l_header_created BOOLEAN := FALSE;
8138: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8139: l_ret_sts_dff VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ; --bug8302126

Line 9609: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,

9605: ---------------------------------------------------------------------
9606:
9607:
9608: PROCEDURE Validate_Flex
9609: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
9610: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
9611: OE_Order_PUB.G_MISS_LINE_REC,
9612: p_validation_level IN NUMBER,
9613: x_return_status OUT NOCOPY VARCHAR2

Line 9610: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=

9606:
9607:
9608: PROCEDURE Validate_Flex
9609: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
9610: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
9611: OE_Order_PUB.G_MISS_LINE_REC,
9612: p_validation_level IN NUMBER,
9613: x_return_status OUT NOCOPY VARCHAR2
9614: )

Line 9611: OE_Order_PUB.G_MISS_LINE_REC,

9607:
9608: PROCEDURE Validate_Flex
9609: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
9610: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
9611: OE_Order_PUB.G_MISS_LINE_REC,
9612: p_validation_level IN NUMBER,
9613: x_return_status OUT NOCOPY VARCHAR2
9614: )
9615: IS

Line 11101: , p_line_rec IN OE_Order_PUB.Line_Rec_Type

11097: -- Procedure Entity_Delete
11098:
11099: PROCEDURE Entity_Delete
11100: ( x_return_status OUT NOCOPY VARCHAR2
11101: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
11102: )
11103: IS
11104: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11105: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;