17: --
18: -- End of Comments
19:
20: G_PKG_NAME VARCHAR2(30) := 'OE_SALES_CAN_UTIL';
21: G_LINE_REC OE_ORDER_PUB.Line_Rec_Type;
22: G_REQUIRE_REASON BOOLEAN := FALSE;
23: G_ORDER_CANCEL BOOLEAN := FALSE;
24:
25: /* 7576948: IR ISO Change Management project Start */
56:
57: /* IR ISO Change Management project End */
58:
59: PROCEDURE check_constraints
60: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
61: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
62: OE_Order_PUB.G_MISS_LINE_REC
63: , x_return_status OUT NOCOPY VARCHAR2
64:
57: /* IR ISO Change Management project End */
58:
59: PROCEDURE check_constraints
60: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
61: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
62: OE_Order_PUB.G_MISS_LINE_REC
63: , x_return_status OUT NOCOPY VARCHAR2
64:
65: );
58:
59: PROCEDURE check_constraints
60: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
61: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
62: OE_Order_PUB.G_MISS_LINE_REC
63: , x_return_status OUT NOCOPY VARCHAR2
64:
65: );
66:
64:
65: );
66:
67: PROCEDURE check_constraints
68: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
69: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
70: OE_Order_PUB.G_MISS_header_REC
71: , x_return_status OUT NOCOPY VARCHAR2
72:
65: );
66:
67: PROCEDURE check_constraints
68: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
69: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
70: OE_Order_PUB.G_MISS_header_REC
71: , x_return_status OUT NOCOPY VARCHAR2
72:
73: );
66:
67: PROCEDURE check_constraints
68: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
69: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
70: OE_Order_PUB.G_MISS_header_REC
71: , x_return_status OUT NOCOPY VARCHAR2
72:
73: );
74:
72:
73: );
74:
75: PROCEDURE update_service
76: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
77: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
78: OE_Order_PUB.G_MISS_LINE_REC
79: , x_return_status OUT NOCOPY VARCHAR2
80:
73: );
74:
75: PROCEDURE update_service
76: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
77: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
78: OE_Order_PUB.G_MISS_LINE_REC
79: , x_return_status OUT NOCOPY VARCHAR2
80:
81: );
74:
75: PROCEDURE update_service
76: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
77: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
78: OE_Order_PUB.G_MISS_LINE_REC
79: , x_return_status OUT NOCOPY VARCHAR2
80:
81: );
82:
81: );
82:
83:
84: FUNCTION Cal_Cancelled_Qty (
85: p_line_rec IN OE_Order_PUB.Line_Rec_Type
86: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
87: OE_Order_PUB.G_MISS_LINE_REC
88: )Return Number;
89:
82:
83:
84: FUNCTION Cal_Cancelled_Qty (
85: p_line_rec IN OE_Order_PUB.Line_Rec_Type
86: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
87: OE_Order_PUB.G_MISS_LINE_REC
88: )Return Number;
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
83:
84: FUNCTION Cal_Cancelled_Qty (
85: p_line_rec IN OE_Order_PUB.Line_Rec_Type
86: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
87: OE_Order_PUB.G_MISS_LINE_REC
88: )Return Number;
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
91: p_line_rec IN OE_Order_PUB.Line_Rec_Type
87: OE_Order_PUB.G_MISS_LINE_REC
88: )Return Number;
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
91: p_line_rec IN OE_Order_PUB.Line_Rec_Type
92: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
93: OE_Order_PUB.G_MISS_LINE_REC
94: )Return Number;
95:
88: )Return Number;
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
91: p_line_rec IN OE_Order_PUB.Line_Rec_Type
92: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
93: OE_Order_PUB.G_MISS_LINE_REC
94: )Return Number;
95:
96:
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
91: p_line_rec IN OE_Order_PUB.Line_Rec_Type
92: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
93: OE_Order_PUB.G_MISS_LINE_REC
94: )Return Number;
95:
96:
97: PROCEDURE perform_line_change
94: )Return Number;
95:
96:
97: PROCEDURE perform_line_change
98: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
99: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
100: OE_Order_PUB.G_MISS_LINE_REC
101: , x_return_status OUT NOCOPY varchar2
102:
95:
96:
97: PROCEDURE perform_line_change
98: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
99: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
100: OE_Order_PUB.G_MISS_LINE_REC
101: , x_return_status OUT NOCOPY varchar2
102:
103: );
96:
97: PROCEDURE perform_line_change
98: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
99: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
100: OE_Order_PUB.G_MISS_LINE_REC
101: , x_return_status OUT NOCOPY varchar2
102:
103: );
104:
102:
103: );
104:
105: PROCEDURE perform_cancel_order
106: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
107: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
108: OE_Order_PUB.G_MISS_header_REC
109: , x_return_status OUT NOCOPY varchar2
110:
103: );
104:
105: PROCEDURE perform_cancel_order
106: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
107: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
108: OE_Order_PUB.G_MISS_header_REC
109: , x_return_status OUT NOCOPY varchar2
110:
111: );
104:
105: PROCEDURE perform_cancel_order
106: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
107: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
108: OE_Order_PUB.G_MISS_header_REC
109: , x_return_status OUT NOCOPY varchar2
110:
111: );
112:
110:
111: );
112:
113: PROCEDURE Cancel_Remaining_Order
114: ( p_Header_Rec IN OE_Order_PUB.Header_Rec_Type
115: := OE_Order_PUB.G_MISS_header_REC,
116: p_header_id IN NUMBER := FND_API.G_MISS_NUM
117: , x_return_status OUT NOCOPY varchar2
118:
111: );
112:
113: PROCEDURE Cancel_Remaining_Order
114: ( p_Header_Rec IN OE_Order_PUB.Header_Rec_Type
115: := OE_Order_PUB.G_MISS_header_REC,
116: p_header_id IN NUMBER := FND_API.G_MISS_NUM
117: , x_return_status OUT NOCOPY varchar2
118:
119: );
123: ( p_line_id IN NUMBER :=
124: FND_API.G_MISS_NUM
125: , p_header_id IN NUMBER :=
126: FND_API.G_MISS_NUM
127: ) RETURN OE_Order_PUB.Line_Tbl_Type;
128:
129: PROCEDURE Cancel_Wf
130: (
131: x_return_status OUT NOCOPY varchar2
128:
129: PROCEDURE Cancel_Wf
130: (
131: x_return_status OUT NOCOPY varchar2
132: , x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type
133: );
134:
135: END OE_SALES_CAN_UTIL;