DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on QP_PREQ_GRP

Line 113: p_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE,

109: x_return_status out nocopy varchar2,
110: p_line_id number default null,
111: p_header_id number Default null,
112: p_Request_Type_Code varchar2 ,
113: p_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE,
114: x_req_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
115: x_Req_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 114: x_req_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,

110: p_line_id number default null,
111: p_header_id number Default null,
112: p_Request_Type_Code varchar2 ,
113: p_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE,
114: x_req_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
115: x_Req_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
118: x_Req_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 115: x_Req_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

111: p_header_id number Default null,
112: p_Request_Type_Code varchar2 ,
113: p_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE,
114: x_req_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
115: x_Req_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
118: x_Req_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
119: x_Req_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

112: p_Request_Type_Code varchar2 ,
113: p_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE,
114: x_req_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
115: x_Req_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
118: x_Req_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
119: x_Req_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
120: x_Req_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE

Line 117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

113: p_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE,
114: x_req_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
115: x_Req_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
118: x_Req_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
119: x_Req_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
120: x_Req_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
121: ,p_use_current_header in Boolean Default FALSE

Line 118: x_Req_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

114: x_req_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
115: x_Req_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
118: x_Req_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
119: x_Req_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
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

Line 119: x_Req_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

115: x_Req_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
118: x_Req_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
119: x_Req_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
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

Line 120: x_Req_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE

116: x_Req_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
117: x_Req_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
118: x_Req_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
119: x_Req_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
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

Line 135: p_Req_Control_Rec QP_PREQ_GRP.Control_record_type,

131: procedure process_adjustments
132: (
133: p_request_type_code varchar2,
134: x_return_status out nocopy Varchar2,
135: p_Req_Control_Rec QP_PREQ_GRP.Control_record_type,
136: p_req_line_tbl QP_PREQ_GRP.line_tbl_type,
137: p_Req_qual_tbl QP_PREQ_GRP.qual_tbl_type,
138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,
139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,

Line 136: p_req_line_tbl QP_PREQ_GRP.line_tbl_type,

132: (
133: p_request_type_code varchar2,
134: x_return_status out nocopy Varchar2,
135: p_Req_Control_Rec QP_PREQ_GRP.Control_record_type,
136: p_req_line_tbl QP_PREQ_GRP.line_tbl_type,
137: p_Req_qual_tbl QP_PREQ_GRP.qual_tbl_type,
138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,
139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,
140: p_Req_Line_Detail_Qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type,

Line 137: p_Req_qual_tbl QP_PREQ_GRP.qual_tbl_type,

133: p_request_type_code varchar2,
134: x_return_status out nocopy Varchar2,
135: p_Req_Control_Rec QP_PREQ_GRP.Control_record_type,
136: p_req_line_tbl QP_PREQ_GRP.line_tbl_type,
137: p_Req_qual_tbl QP_PREQ_GRP.qual_tbl_type,
138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,
139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,
140: p_Req_Line_Detail_Qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type,
141: p_Req_Line_Detail_Attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type,

Line 138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,

134: x_return_status out nocopy Varchar2,
135: p_Req_Control_Rec QP_PREQ_GRP.Control_record_type,
136: p_req_line_tbl QP_PREQ_GRP.line_tbl_type,
137: p_Req_qual_tbl QP_PREQ_GRP.qual_tbl_type,
138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,
139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,
140: p_Req_Line_Detail_Qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type,
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

Line 139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,

135: p_Req_Control_Rec QP_PREQ_GRP.Control_record_type,
136: p_req_line_tbl QP_PREQ_GRP.line_tbl_type,
137: p_Req_qual_tbl QP_PREQ_GRP.qual_tbl_type,
138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,
139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,
140: p_Req_Line_Detail_Qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type,
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

Line 140: p_Req_Line_Detail_Qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type,

136: p_req_line_tbl QP_PREQ_GRP.line_tbl_type,
137: p_Req_qual_tbl QP_PREQ_GRP.qual_tbl_type,
138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,
139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,
140: p_Req_Line_Detail_Qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type,
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

Line 141: p_Req_Line_Detail_Attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type,

137: p_Req_qual_tbl QP_PREQ_GRP.qual_tbl_type,
138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,
139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,
140: p_Req_Line_Detail_Qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type,
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

Line 142: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type

138: p_Req_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type,
139: p_Req_Line_Detail_tbl QP_PREQ_GRP.line_detail_tbl_type,
140: p_Req_Line_Detail_Qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type,
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

Line 156: ,p_Control_Rec QP_PREQ_GRP.control_record_type

152: X_Return_Status out nocopy Varchar2
153: ,p_Line_id Number Default Null
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'

Line 392: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

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: );
396:

Line 400: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

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'
404: );

Line 410: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

406: Procedure copy_attribs_to_Req(
407: p_line_index number
408: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
409: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
410: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
411: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
412: );
413:
414:

Line 411: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

407: p_line_index number
408: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
409: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
410: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
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);