5: g_cust_ord_enabled_flag varchar2(1):=nvl(FND_PROFILE.Value('ONT_VAL_CUST_ORD_ENABLED_FLAG'),'N'); /* Bug # 5036404 */
6:
7: -- Procedure Check_book_reqd_attributes.
8: PROCEDURE Check_Book_Reqd_Attributes
9: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
10: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
11: , x_return_status IN OUT NOCOPY VARCHAR2
12: );
13:
6:
7: -- Procedure Check_book_reqd_attributes.
8: PROCEDURE Check_Book_Reqd_Attributes
9: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
10: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
11: , x_return_status IN OUT NOCOPY VARCHAR2
12: );
13:
14: -- Procedure Entity
15:
16: -- Bug 3572931 added the Param p_validation_level
17: PROCEDURE Entity
18: ( x_return_status OUT NOCOPY VARCHAR2
19: , p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
20: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
21: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
22: );
23:
16: -- Bug 3572931 added the Param p_validation_level
17: PROCEDURE Entity
18: ( x_return_status OUT NOCOPY VARCHAR2
19: , p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
20: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
21: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
22: );
23:
24: -- Procedure Attributes
25:
26: PROCEDURE Attributes
27: ( x_return_status OUT NOCOPY VARCHAR2
28:
29: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
30: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
31: OE_Order_PUB.G_MISS_LINE_REC
32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: );
26: PROCEDURE Attributes
27: ( x_return_status OUT NOCOPY VARCHAR2
28:
29: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
30: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
31: OE_Order_PUB.G_MISS_LINE_REC
32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: );
34:
27: ( x_return_status OUT NOCOPY VARCHAR2
28:
29: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
30: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
31: OE_Order_PUB.G_MISS_LINE_REC
32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: );
34:
35: -- Procedure Entity_Delete
36:
37: PROCEDURE Entity_Delete
38: ( x_return_status OUT NOCOPY VARCHAR2
39:
40: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
41: );
42:
43: -- Procedure Validate_Flex, added for bug 2511313
44:
42:
43: -- Procedure Validate_Flex, added for bug 2511313
44:
45: PROCEDURE Validate_Flex
46: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
47: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
48: OE_Order_PUB.G_MISS_LINE_REC,
49: p_validation_level IN NUMBER,
50: x_return_status OUT NOCOPY VARCHAR2
43: -- Procedure Validate_Flex, added for bug 2511313
44:
45: PROCEDURE Validate_Flex
46: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
47: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
48: OE_Order_PUB.G_MISS_LINE_REC,
49: p_validation_level IN NUMBER,
50: x_return_status OUT NOCOPY VARCHAR2
51: );
44:
45: PROCEDURE Validate_Flex
46: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
47: p_old_line_rec IN OE_ORDER_PUB.line_rec_type :=
48: OE_Order_PUB.G_MISS_LINE_REC,
49: p_validation_level IN NUMBER,
50: x_return_status OUT NOCOPY VARCHAR2
51: );
52:
51: );
52:
53:
54: Procedure Validate_ShipSet_SMC
55: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
56: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
57: ,x_return_status OUT NOCOPY VARCHAR2
58: );
59:
52:
53:
54: Procedure Validate_ShipSet_SMC
55: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
56: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
57: ,x_return_status OUT NOCOPY VARCHAR2
58: );
59:
60: PROCEDURE Validate_Decimal_Quantity