44: PROCEDURE Header_Adjs
45: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
46: , p_validation_level IN NUMBER
47: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
48: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
49: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
50: );
51:
52: PROCEDURE HEader_Price_Atts
45: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
46: , p_validation_level IN NUMBER
47: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
48: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
49: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
50: );
51:
52: PROCEDURE HEader_Price_Atts
53: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
52: PROCEDURE HEader_Price_Atts
53: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
54: , p_validation_level IN NUMBER
55: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
56: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
57: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
58: );
59:
60: PROCEDURE Header_Adj_Atts
53: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
54: , p_validation_level IN NUMBER
55: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
56: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
57: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
58: );
59:
60: PROCEDURE Header_Adj_Atts
61: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
60: PROCEDURE Header_Adj_Atts
61: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
62: , p_validation_level IN NUMBER
63: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
64: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
65: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
66: );
67:
68: PROCEDURE Header_Adj_Assocs
61: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
62: , p_validation_level IN NUMBER
63: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
64: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
65: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
66: );
67:
68: PROCEDURE Header_Adj_Assocs
69: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
68: PROCEDURE Header_Adj_Assocs
69: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
70: , p_validation_level IN NUMBER
71: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
72: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
73: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
74: );
75:
76: PROCEDURE Line_Adjs
69: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
70: , p_validation_level IN NUMBER
71: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
72: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
73: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
74: );
75:
76: PROCEDURE Line_Adjs
77: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
76: PROCEDURE Line_Adjs
77: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
78: , p_validation_level IN NUMBER
79: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
80: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
81: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
82: );
83:
84: PROCEDURE Line_Price_Atts
77: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
78: , p_validation_level IN NUMBER
79: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
80: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
81: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
82: );
83:
84: PROCEDURE Line_Price_Atts
85: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
84: PROCEDURE Line_Price_Atts
85: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
86: , p_validation_level IN NUMBER
87: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
88: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
89: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
90: );
91:
92: PROCEDURE Line_Adj_Atts
85: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
86: , p_validation_level IN NUMBER
87: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
88: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
89: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
90: );
91:
92: PROCEDURE Line_Adj_Atts
93: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
92: PROCEDURE Line_Adj_Atts
93: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
94: , p_validation_level IN NUMBER
95: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
96: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
97: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
98: );
99:
100: PROCEDURE Line_Adj_Assocs
93: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
94: , p_validation_level IN NUMBER
95: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
96: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
97: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
98: );
99:
100: PROCEDURE Line_Adj_Assocs
101: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
100: PROCEDURE Line_Adj_Assocs
101: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
102: , p_validation_level IN NUMBER
103: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
104: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
105: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
106: );
107:
108: procedure calculate_adjustments(
101: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
102: , p_validation_level IN NUMBER
103: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
104: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
105: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
106: );
107:
108: procedure calculate_adjustments(
109: x_return_status out nocopy varchar2,
120: x_Req_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
121: ,p_use_current_header in Boolean Default FALSE
122: ,p_write_to_db Boolean Default TRUE
123: ,x_any_frozen_line out nocopy Boolean
124: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
125: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
126: ,p_honor_price_flag VARCHAR2 Default 'Y'
127: ,p_multiple_events in VARCHAR2 Default 'N'
128: ,p_action_code in VARCHAR2 Default 'NONE'
121: ,p_use_current_header in Boolean Default FALSE
122: ,p_write_to_db Boolean Default TRUE
123: ,x_any_frozen_line out nocopy Boolean
124: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
125: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
126: ,p_honor_price_flag VARCHAR2 Default 'Y'
127: ,p_multiple_events in VARCHAR2 Default 'N'
128: ,p_action_code in VARCHAR2 Default 'NONE'
129: );
141: p_Req_Line_Detail_Attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type,
142: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type
143: ,p_write_to_db Boolean
144: ,p_any_frozen_line in Boolean
145: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
146: ,p_header_rec oe_Order_Pub.header_rec_type
147: ,p_multiple_events in Varchar2 Default 'N'
148: ,p_honor_price_flag in Varchar2 Default 'Y' --bug 2503186
149: );
142: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type
143: ,p_write_to_db Boolean
144: ,p_any_frozen_line in Boolean
145: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
146: ,p_header_rec oe_Order_Pub.header_rec_type
147: ,p_multiple_events in Varchar2 Default 'N'
148: ,p_honor_price_flag in Varchar2 Default 'Y' --bug 2503186
149: );
150:
154: ,p_Header_id Number DEfault Null
155: ,p_Request_Type_code Varchar2
156: ,p_Control_Rec QP_PREQ_GRP.control_record_type
157: ,p_write_to_db Boolean DEFAULT TRUE
158: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
159: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
160: ,p_honor_price_flag VARCHAR2 Default 'Y'
161: ,p_multiple_events Varchar2 default 'N'
162: ,p_action_code VARCHAR2 Default Null
155: ,p_Request_Type_code Varchar2
156: ,p_Control_Rec QP_PREQ_GRP.control_record_type
157: ,p_write_to_db Boolean DEFAULT TRUE
158: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
159: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
160: ,p_honor_price_flag VARCHAR2 Default 'Y'
161: ,p_multiple_events Varchar2 default 'N'
162: ,p_action_code VARCHAR2 Default Null
163: );
166: X_Return_Status out nocopy Varchar2
167: ,p_Header_id Number DEfault null
168: ,p_Line_id Number DEfault null
169: ,p_request_type_code varchar2
170: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
171:
172: );
173:
174: procedure price_action
360:
361: Procedure Get_Manual_Adjustments (
362: p_header_id in number Default Null,
363: p_line_id in number Default Null,
364: p_line_rec in oe_Order_Pub.Line_Rec_Type Default oe_order_pub.g_miss_line_rec,
365: p_level in Varchar2 default 'LINE',
366: p_pbh_mode in Varchar2 default 'CHILD',
367: p_cross_order in Varchar2 Default 'N',
368: p_line_level in Varchar2 Default 'N',
378: p_line_id in Number default null
379: );
380:
381: PROCEDURE Insert_Adj_Assocs
382: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
383: );
384:
385: PROCEDURE Insert_Adj_Atts
386: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
382: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
383: );
384:
385: PROCEDURE Insert_Adj_Atts
386: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
387: );
388:
389:
390: Procedure copy_Header_to_request(
387: );
388:
389:
390: Procedure copy_Header_to_request(
391: p_header_rec OE_Order_PUB.Header_Rec_Type
392: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
393: ,p_Request_Type_Code varchar2
394: ,p_calculate_price_flag varchar2
395: );
395: );
396:
397:
398: Procedure copy_Line_to_request(
399: p_Line_rec OE_Order_PUB.Line_Rec_Type
400: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
401: ,p_pricing_event varchar2
402: ,p_Request_Type_Code varchar2
403: ,p_honor_price_flag VARCHAR2 Default 'Y'
411: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
412: );
413:
414:
415: Procedure Reset_Fields(p_line_rec in Oe_Order_Pub.Line_Rec_Type);
416: -- bug 6718566
417: Procedure GET_MANUAL_ADV_STATUS(p_event_code IN VARCHAR2);
418:
419: end oe_order_adj_pvt;