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: G_CANCELLATION_ACTION VARCHAR2(2) := 'N'; -- 12695580
25:
57:
58: /* IR ISO Change Management project End */
59:
60: PROCEDURE check_constraints
61: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
62: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
63: OE_Order_PUB.G_MISS_LINE_REC
64: , x_return_status OUT NOCOPY VARCHAR2
65:
58: /* IR ISO Change Management project End */
59:
60: PROCEDURE check_constraints
61: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
62: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
63: OE_Order_PUB.G_MISS_LINE_REC
64: , x_return_status OUT NOCOPY VARCHAR2
65:
66: );
59:
60: PROCEDURE check_constraints
61: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
62: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
63: OE_Order_PUB.G_MISS_LINE_REC
64: , x_return_status OUT NOCOPY VARCHAR2
65:
66: );
67:
65:
66: );
67:
68: PROCEDURE check_constraints
69: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
70: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
71: OE_Order_PUB.G_MISS_header_REC
72: , x_return_status OUT NOCOPY VARCHAR2
73:
66: );
67:
68: PROCEDURE check_constraints
69: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
70: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
71: OE_Order_PUB.G_MISS_header_REC
72: , x_return_status OUT NOCOPY VARCHAR2
73:
74: );
67:
68: PROCEDURE check_constraints
69: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
70: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
71: OE_Order_PUB.G_MISS_header_REC
72: , x_return_status OUT NOCOPY VARCHAR2
73:
74: );
75:
73:
74: );
75:
76: PROCEDURE update_service
77: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
78: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
79: OE_Order_PUB.G_MISS_LINE_REC
80: , x_return_status OUT NOCOPY VARCHAR2
81:
74: );
75:
76: PROCEDURE update_service
77: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
78: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
79: OE_Order_PUB.G_MISS_LINE_REC
80: , x_return_status OUT NOCOPY VARCHAR2
81:
82: );
75:
76: PROCEDURE update_service
77: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
78: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
79: OE_Order_PUB.G_MISS_LINE_REC
80: , x_return_status OUT NOCOPY VARCHAR2
81:
82: );
83:
82: );
83:
84:
85: FUNCTION Cal_Cancelled_Qty (
86: p_line_rec IN OE_Order_PUB.Line_Rec_Type
87: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
88: OE_Order_PUB.G_MISS_LINE_REC
89: )Return Number;
90:
83:
84:
85: FUNCTION Cal_Cancelled_Qty (
86: p_line_rec IN OE_Order_PUB.Line_Rec_Type
87: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
88: OE_Order_PUB.G_MISS_LINE_REC
89: )Return Number;
90:
91: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
84:
85: FUNCTION Cal_Cancelled_Qty (
86: p_line_rec IN OE_Order_PUB.Line_Rec_Type
87: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
88: OE_Order_PUB.G_MISS_LINE_REC
89: )Return Number;
90:
91: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
92: p_line_rec IN OE_Order_PUB.Line_Rec_Type
88: OE_Order_PUB.G_MISS_LINE_REC
89: )Return Number;
90:
91: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
92: p_line_rec IN OE_Order_PUB.Line_Rec_Type
93: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
94: OE_Order_PUB.G_MISS_LINE_REC
95: )Return Number;
96:
89: )Return Number;
90:
91: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
92: p_line_rec IN OE_Order_PUB.Line_Rec_Type
93: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
94: OE_Order_PUB.G_MISS_LINE_REC
95: )Return Number;
96:
97:
90:
91: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
92: p_line_rec IN OE_Order_PUB.Line_Rec_Type
93: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
94: OE_Order_PUB.G_MISS_LINE_REC
95: )Return Number;
96:
97:
98: PROCEDURE perform_line_change
95: )Return Number;
96:
97:
98: PROCEDURE perform_line_change
99: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
100: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
101: OE_Order_PUB.G_MISS_LINE_REC
102: , x_return_status OUT NOCOPY varchar2
103:
96:
97:
98: PROCEDURE perform_line_change
99: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
100: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
101: OE_Order_PUB.G_MISS_LINE_REC
102: , x_return_status OUT NOCOPY varchar2
103:
104: );
97:
98: PROCEDURE perform_line_change
99: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
100: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
101: OE_Order_PUB.G_MISS_LINE_REC
102: , x_return_status OUT NOCOPY varchar2
103:
104: );
105:
103:
104: );
105:
106: PROCEDURE perform_cancel_order
107: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
108: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
109: OE_Order_PUB.G_MISS_header_REC
110: , x_return_status OUT NOCOPY varchar2
111:
104: );
105:
106: PROCEDURE perform_cancel_order
107: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
108: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
109: OE_Order_PUB.G_MISS_header_REC
110: , x_return_status OUT NOCOPY varchar2
111:
112: );
105:
106: PROCEDURE perform_cancel_order
107: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
108: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
109: OE_Order_PUB.G_MISS_header_REC
110: , x_return_status OUT NOCOPY varchar2
111:
112: );
113:
111:
112: );
113:
114: PROCEDURE Cancel_Remaining_Order
115: ( p_Header_Rec IN OE_Order_PUB.Header_Rec_Type
116: := OE_Order_PUB.G_MISS_header_REC,
117: p_header_id IN NUMBER := FND_API.G_MISS_NUM
118: , x_return_status OUT NOCOPY varchar2
119:
112: );
113:
114: PROCEDURE Cancel_Remaining_Order
115: ( p_Header_Rec IN OE_Order_PUB.Header_Rec_Type
116: := OE_Order_PUB.G_MISS_header_REC,
117: p_header_id IN NUMBER := FND_API.G_MISS_NUM
118: , x_return_status OUT NOCOPY varchar2
119:
120: );
124: ( p_line_id IN NUMBER :=
125: FND_API.G_MISS_NUM
126: , p_header_id IN NUMBER :=
127: FND_API.G_MISS_NUM
128: ) RETURN OE_Order_PUB.Line_Tbl_Type;
129:
130: PROCEDURE Cancel_Wf
131: (
132: x_return_status OUT NOCOPY varchar2
129:
130: PROCEDURE Cancel_Wf
131: (
132: x_return_status OUT NOCOPY varchar2
133: , x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type
134: );
135:
136: END OE_SALES_CAN_UTIL;