APPS.OE_OE_AVAILABILITY dependencies on QP_PREQ_GRP

Line 264: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

260:
261: PROCEDURE copy_Header_to_request(
262: p_request_type_code in varchar2
263: ,p_calculate_price_flag in varchar2
264: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
265: );
266:
267:
268: PROCEDURE copy_Line_to_request(

Line 269: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

265: );
266:
267:
268: PROCEDURE copy_Line_to_request(
269: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
270: ,p_pricing_event in varchar2
271: ,p_Request_Type_Code in varchar2
272: ,p_honor_price_flag in VARCHAR2 Default 'Y'
273: ,p_line_index in number

Line 278: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE

274: );
275:
276:
277: PROCEDURE set_pricing_control_record (
278: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
279: ,in_pricing_event in varchar2);
280:
281:
282:

Line 287: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

283: PROCEDURE build_context_for_line(
284: p_req_line_tbl_count in number,
285: p_price_request_code in varchar2,
286: p_item_type_code in varchar2,
287: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
288: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
289: p_line_index in number
290: );
291:

Line 288: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

284: p_req_line_tbl_count in number,
285: p_price_request_code in varchar2,
286: p_item_type_code in varchar2,
287: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
288: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
289: p_line_index in number
290: );
291:
292:

Line 298: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

294: PROCEDURE build_context_for_header(
295: p_req_line_tbl_count in number,
296: p_price_request_code in varchar2,
297: p_item_type_code in varchar2,
298: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
299: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
300: );
301:
302:

Line 299: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

295: p_req_line_tbl_count in number,
296: p_price_request_code in varchar2,
297: p_item_type_code in varchar2,
298: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
299: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
300: );
301:
302:
303: PROCEDURE copy_attribs_to_Req(

Line 305: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

301:
302:
303: PROCEDURE copy_attribs_to_Req(
304: p_line_index number
305: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
306: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
307: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
308: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
309: );

Line 306: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

302:
303: PROCEDURE copy_attribs_to_Req(
304: p_line_index number
305: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
306: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
307: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
308: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
309: );
310: PROCEDURE append_attr_to_TTables(px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE);

Line 310: PROCEDURE append_attr_to_TTables(px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE);

306: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
307: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
308: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
309: );
310: PROCEDURE append_attr_to_TTables(px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE);
311:
312: PROCEDURE Append_attributes(
313: p_header_id number default null
314: ,p_Line_id number default null

Line 316: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

312: PROCEDURE Append_attributes(
313: p_header_id number default null
314: ,p_Line_id number default null
315: ,p_line_index number
316: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
317: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
318: ,p_g_line_index in number );
319:
320: PROCEDURE Reset_All_Tbls;

Line 317: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

313: p_header_id number default null
314: ,p_Line_id number default null
315: ,p_line_index number
316: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
317: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
318: ,p_g_line_index in number );
319:
320: PROCEDURE Reset_All_Tbls;
321: procedure Populate_Temp_Table;

Line 323: x_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,

319:
320: PROCEDURE Reset_All_Tbls;
321: procedure Populate_Temp_Table;
322: PROCEDURE populate_results(
323: x_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
324: x_line_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
325: x_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
326: x_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
327: x_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 324: x_line_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

320: PROCEDURE Reset_All_Tbls;
321: procedure Populate_Temp_Table;
322: PROCEDURE populate_results(
323: x_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
324: x_line_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
325: x_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
326: x_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
327: x_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
328: x_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 325: x_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

321: procedure Populate_Temp_Table;
322: PROCEDURE populate_results(
323: x_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
324: x_line_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
325: x_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
326: x_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
327: x_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
328: x_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
329: x_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE

Line 326: x_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

322: PROCEDURE populate_results(
323: x_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
324: x_line_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
325: x_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
326: x_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
327: x_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
328: x_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
329: x_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
330: );

Line 327: x_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

323: x_line_tbl out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
324: x_line_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
325: x_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
326: x_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
327: x_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
328: x_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
329: x_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
330: );
331:

Line 328: x_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

324: x_line_qual_tbl out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
325: x_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
326: x_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
327: x_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
328: x_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
329: x_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
330: );
331:
332: PROCEDURE price_item(

Line 329: x_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE

325: x_line_attr_tbl out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
326: x_LINE_DETAIL_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
327: x_LINE_DETAIL_qual_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
328: x_LINE_DETAIL_attr_tbl out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
329: x_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
330: );
331:
332: PROCEDURE price_item(
333: out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,

Line 333: out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,

329: x_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
330: );
331:
332: PROCEDURE price_item(
333: out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
334: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
335: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
336: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
337: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 334: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

330: );
331:
332: PROCEDURE price_item(
333: out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
334: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
335: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
336: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
337: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
338: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 335: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

331:
332: PROCEDURE price_item(
333: out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
334: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
335: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
336: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
337: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
338: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
339: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 336: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

332: PROCEDURE price_item(
333: out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
334: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
335: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
336: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
337: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
338: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
339: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
340: out_child_detail_type out nocopy varchar2

Line 337: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

333: out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
334: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
335: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
336: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
337: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
338: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
339: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
340: out_child_detail_type out nocopy varchar2
341: );

Line 338: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

334: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
335: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
336: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
337: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
338: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
339: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
340: out_child_detail_type out nocopy varchar2
341: );
342:

Line 339: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

335: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
336: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
337: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
338: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
339: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
340: out_child_detail_type out nocopy varchar2
341: );
342:
343: PROCEDURE pass_values_to_backend(