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 735: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

731: -- procedure Entity.
732: -----------------------------------------------------------
733:
734: Procedure Validate_ShipSet_SMC
735: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
736: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
737: ,x_return_status OUT NOCOPY VARCHAR2
738: )
739: IS

Line 736: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

732: -----------------------------------------------------------
733:
734: Procedure Validate_ShipSet_SMC
735: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
736: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
737: ,x_return_status OUT NOCOPY VARCHAR2
738: )
739: IS
740: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1037: (p_line_rec IN OE_ORDER_PUB.Line_rec_type

1033: for ATO options are allowed.
1034: -----------------------------------------------------------------------*/
1035:
1036: PROCEDURE Decimal_Ratio_Check
1037: (p_line_rec IN OE_ORDER_PUB.Line_rec_type
1038: ,x_return_status OUT NOCOPY VARCHAR2)
1039: IS
1040: l_ordered_item VARCHAR2(2000);
1041: l_item_type_code VARCHAR2(30);

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

1129: END Decimal_Ratio_Check;
1130:
1131:
1132:
1133: Procedure Validate_Line_Type(p_line_rec IN oe_order_pub.line_rec_type,
1134: p_old_line_rec IN oe_order_pub.line_rec_type)
1135: IS
1136:
1137: lorder_type_id NUMBER;

Line 1134: p_old_line_rec IN oe_order_pub.line_rec_type)

1130:
1131:
1132:
1133: Procedure Validate_Line_Type(p_line_rec IN oe_order_pub.line_rec_type,
1134: p_old_line_rec IN oe_order_pub.line_rec_type)
1135: IS
1136:
1137: lorder_type_id NUMBER;
1138: lexists VARCHAR2(30);

Line 1365: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

1361: END Validate_Receiving_Org;
1362:
1363: -- bug 6647169 begin
1364: FUNCTION Validate_Warehouse_Change
1365: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1366: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1367: ) RETURN BOOLEAN
1368: IS
1369: l_result BOOLEAN;

Line 1366: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

1362:
1363: -- bug 6647169 begin
1364: FUNCTION Validate_Warehouse_Change
1365: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1366: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1367: ) RETURN BOOLEAN
1368: IS
1369: l_result BOOLEAN;
1370: l_shipable_flag_new VARCHAR2(1);

Line 2447: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

2443: -- given sold_to_org_id, and against OTA course end date.
2444: ---------------------------------------------------
2445:
2446: PROCEDURE Validate_Commitment
2447: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2448: , p_hdr_currency_code IN VARCHAR2
2449: , p_ota_line IN BOOLEAN := FALSE
2450: , x_return_status OUT NOCOPY VARCHAR2
2451: ) IS

Line 2690: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

2686: We use this procedure to add validations related to source_type
2687: = EXTERNAL.
2688: --------------------------------------------------------------*/
2689: PROCEDURE Validate_Source_Type
2690: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2691: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2692: ,x_return_status OUT NOCOPY VARCHAR2)
2693:
2694: IS

Line 2691: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

2687: = EXTERNAL.
2688: --------------------------------------------------------------*/
2689: PROCEDURE Validate_Source_Type
2690: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2691: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2692: ,x_return_status OUT NOCOPY VARCHAR2)
2693:
2694: IS
2695: l_purchasing_enabled_flag VARCHAR2(1) := 'Y';

Line 2812: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

2808: END Validate_Source_Type;
2809:
2810:
2811: FUNCTION Validate_Set_id
2812: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2813: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type)
2814: RETURN BOOLEAN
2815: IS
2816: l_arrival_set_id Number;

Line 2813: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type)

2809:
2810:
2811: FUNCTION Validate_Set_id
2812: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2813: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type)
2814: RETURN BOOLEAN
2815: IS
2816: l_arrival_set_id Number;
2817: l_ship_set_id Number;

Line 2909: (p_line_rec IN OE_Order_PUB.Line_Rec_Type

2905: RETURN FALSE;
2906: END Validate_Set_id;
2907:
2908: PROCEDURE Validate_User_Item_Description
2909: (p_line_rec IN OE_Order_PUB.Line_Rec_Type
2910: , x_return_status OUT NOCOPY VARCHAR2
2911:
2912: )
2913: IS

Line 2953: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,

2949: -- Procedure Validate_Blanket_Values
2950: ----------------------------------------------------------------------------
2951:
2952: Procedure Validate_Blanket_Values
2953: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,
2954: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type,
2955: x_return_status OUT NOCOPY VARCHAR2
2956: )
2957: IS

Line 2954: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type,

2950: ----------------------------------------------------------------------------
2951:
2952: Procedure Validate_Blanket_Values
2953: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,
2954: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type,
2955: x_return_status OUT NOCOPY VARCHAR2
2956: )
2957: IS
2958: l_temp VARCHAR2(240);

Line 3593: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

3589: returns. In case the line is part of ato model the function also returns the
3590: ato_line_id. Added for bug 3718547.
3591: ------------------------------------------------------------------------------*/
3592: PROCEDURE Get_Return_Line_Attributes
3593: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
3594: , x_line_id OUT NOCOPY NUMBER
3595: , x_item_type_code OUT NOCOPY VARCHAR2
3596: , x_ato_line_id OUT NOCOPY NUMBER
3597: , x_return_status OUT NOCOPY VARCHAR2

Line 3651: , p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3647: --
3648: --
3649: PROCEDURE Entity
3650: ( x_return_status OUT NOCOPY VARCHAR2
3651: , p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3652: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
3653: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3654: )
3655: IS

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

3648: --
3649: PROCEDURE Entity
3650: ( x_return_status OUT NOCOPY VARCHAR2
3651: , p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3652: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
3653: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3654: )
3655: IS
3656: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3763: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

3759: AND mmt.organization_id = ool.ship_from_org_id;
3760: -- AND mmt.revision = p_line_rec.item_revision;
3761:
3762: -- For bug3327250
3763: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3764: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3765: l_control_rec OE_GLOBALS.Control_Rec_Type;
3766: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
3767: -- Variable to indicate Referenced RMA creation or change of reference

Line 3764: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3760: -- AND mmt.revision = p_line_rec.item_revision;
3761:
3762: -- For bug3327250
3763: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3764: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3765: l_control_rec OE_GLOBALS.Control_Rec_Type;
3766: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
3767: -- Variable to indicate Referenced RMA creation or change of reference
3768: G_REF_RMA VARCHAR2(1) := 'N';

Line 3766: l_old_line_rec OE_Order_PUB.Line_Rec_Type;

3762: -- For bug3327250
3763: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3764: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3765: l_control_rec OE_GLOBALS.Control_Rec_Type;
3766: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
3767: -- Variable to indicate Referenced RMA creation or change of reference
3768: G_REF_RMA VARCHAR2(1) := 'N';
3769: -- Variable to indicate that a oe_order_pvt.line call is needed to redefault
3770: -- Missing / Invalid attributes

Line 7717: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

7713:
7714: PROCEDURE Attributes
7715: ( x_return_status OUT NOCOPY VARCHAR2
7716:
7717: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
7718: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
7719: OE_Order_PUB.G_MISS_LINE_REC
7720: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
7721: )

Line 7718: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

7714: PROCEDURE Attributes
7715: ( x_return_status OUT NOCOPY VARCHAR2
7716:
7717: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
7718: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
7719: OE_Order_PUB.G_MISS_LINE_REC
7720: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
7721: )
7722: IS

Line 7719: OE_Order_PUB.G_MISS_LINE_REC

7715: ( x_return_status OUT NOCOPY VARCHAR2
7716:
7717: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
7718: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
7719: OE_Order_PUB.G_MISS_LINE_REC
7720: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
7721: )
7722: IS
7723: l_return_status VARCHAR2(1);

Line 7724: l_header_rec OE_Order_PUB.Header_Rec_Type;

7720: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
7721: )
7722: IS
7723: l_return_status VARCHAR2(1);
7724: l_header_rec OE_Order_PUB.Header_Rec_Type;
7725: l_type_code VARCHAR2(30);
7726: l_header_created BOOLEAN := FALSE;
7727: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7728:

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

9117: ---------------------------------------------------------------------
9118:
9119:
9120: PROCEDURE Validate_Flex
9121: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
9122: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
9123: OE_Order_PUB.G_MISS_LINE_REC,
9124: p_validation_level IN NUMBER,
9125: x_return_status OUT NOCOPY VARCHAR2

Line 9122: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=

9118:
9119:
9120: PROCEDURE Validate_Flex
9121: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
9122: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
9123: OE_Order_PUB.G_MISS_LINE_REC,
9124: p_validation_level IN NUMBER,
9125: x_return_status OUT NOCOPY VARCHAR2
9126: )

Line 9123: OE_Order_PUB.G_MISS_LINE_REC,

9119:
9120: PROCEDURE Validate_Flex
9121: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
9122: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
9123: OE_Order_PUB.G_MISS_LINE_REC,
9124: p_validation_level IN NUMBER,
9125: x_return_status OUT NOCOPY VARCHAR2
9126: )
9127: IS

Line 10605: , p_line_rec IN OE_Order_PUB.Line_Rec_Type

10601:
10602: PROCEDURE Entity_Delete
10603: ( x_return_status OUT NOCOPY VARCHAR2
10604:
10605: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
10606: )
10607: IS
10608: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10609: BEGIN