eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_PRICE_PVT dependencies on QP_PREQ_GRP

Line 97: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

93: PROCEDURE Copy_Attribs_To_Req(
94: p_line_index number,
95: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
96: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
97: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
98: px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE)
99: IS
100: l_attr_index number ;
101: l_qual_index number ;

Line 98: px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE)

94: p_line_index number,
95: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
96: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
97: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
98: px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE)
99: IS
100: l_attr_index number ;
101: l_qual_index number ;
102: BEGIN

Line 156: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

152: ,p_model_id in number --:= FND_API.G_MISS_NUM
153:
154: ,p_line_index in number
155: ,p_request_type_code in varchar2
156: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
157: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
158: )
159: is
160: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 157: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE

153:
154: ,p_line_index in number
155: ,p_request_type_code in varchar2
156: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
157: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
158: )
159: is
160: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
161: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 163: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

159: is
160: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
161: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
162:
163: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
164: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
165:
166: begin
167:

Line 164: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

160: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
161: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
162:
163: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
164: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
165:
166: begin
167:
168: aso_pricing_int.G_LINE_rec :=set_aso_line_rec(

Line 255: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

251: --,p_model_id in number := FND_API.G_MISS_NUM
252:
253: ,p_line_index in number
254: ,p_request_type_code in varchar2
255: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
256: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
257: )
258: is
259: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 256: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE

252:
253: ,p_line_index in number
254: ,p_request_type_code in varchar2
255: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
256: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
257: )
258: is
259: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
260: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 261: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

257: )
258: is
259: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
260: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
261: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
262: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
263:
264: begin
265: getHeaderAttrAndQual(

Line 262: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

258: is
259: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
260: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
261: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
262: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
263:
264: begin
265: getHeaderAttrAndQual(
266: p_party_id => p_party_id,

Line 293: ,x_control_rec OUT nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE

289:
290:
291: PROCEDURE Set_Control_Rec(
292: p_pricing_event in varchar2
293: ,x_control_rec OUT nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
294: )
295: IS
296: BEGIN
297: -- setup control record

Line 310: ,px_line_rec IN OUT NOCOPY QP_PREQ_GRP.LINE_REC_TYPE

306: p_line_id IN Number
307: ,p_line_index IN Number
308: ,p_uom_code IN VARCHAR2
309: ,p_request_type_code IN varchar2
310: ,px_line_rec IN OUT NOCOPY QP_PREQ_GRP.LINE_REC_TYPE
311: )
312: IS
313: BEGIN
314: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 335: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE)

331: ,p_currency_code in varchar2
332: ,p_line_id in number
333: ,p_line_index in number
334: ,p_request_type_code in varchar2
335: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE)
336: IS
337: l_index number;
338: l_line_rec QP_PREQ_GRP.Line_REC_TYPE;
339:

Line 338: l_line_rec QP_PREQ_GRP.Line_REC_TYPE;

334: ,p_request_type_code in varchar2
335: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE)
336: IS
337: l_index number;
338: l_line_rec QP_PREQ_GRP.Line_REC_TYPE;
339:
340: BEGIN
341: l_index := nvl(px_line_tbl.last,0);
342:

Line 364: ,px_line_attr_rec IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_REC_TYPE

360:
361: PROCEDURE Set_Line_Attr_Rec(
362: p_line_index IN Number
363: ,p_inventory_item_id IN VARCHAR2
364: ,px_line_attr_rec IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_REC_TYPE
365: )
366: IS
367: BEGIN
368: -- setup line_attr_rec

Line 380: ,px_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

376:
377: PROCEDURE GetReqLineAttr(
378: p_line_index IN Number
379: ,p_inventory_item_id IN VARCHAR2
380: ,px_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
381: )
382: is
383: l_index number;
384: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

Line 384: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

380: ,px_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
381: )
382: is
383: l_index number;
384: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
385: begin
386: l_index := nvl(px_line_attr_tbl.last,0);
387: set_line_attr_rec(p_line_index, p_inventory_item_id, l_line_attr_rec);
388: l_index := l_index +1;

Line 396: ,px_qual_rec IN OUT NOCOPY QP_PREQ_GRP.QUAL_REC_TYPE

392:
393: PROCEDURE Set_Qual_Rec(
394: p_line_index IN Number
395: ,p_price_list_id IN VARCHAR2
396: ,px_qual_rec IN OUT NOCOPY QP_PREQ_GRP.QUAL_REC_TYPE
397: )
398: IS
399: BEGIN
400: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 417: ,px_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE

413:
414: PROCEDURE GetReqQual(
415: p_line_index IN Number
416: ,p_price_list_id IN VARCHAR2
417: ,px_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE
418: )
419: is
420: l_index number;
421: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

Line 421: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

417: ,px_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE
418: )
419: is
420: l_index number;
421: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
422: begin
423: l_index := nvl(px_qual_tbl.last,0);
424: set_qual_rec(p_line_index, p_price_list_id, l_qual_rec);
425: l_index := l_index +1;

Line 447: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE

443: ,p_line_index in number
444: ,p_request_type_code varchar2
445: ,p_pricing_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
446: ,p_qual_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
447: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE
448: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
449: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
450:
451: )

Line 448: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

444: ,p_request_type_code varchar2
445: ,p_pricing_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
446: ,p_qual_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
447: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE
448: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
449: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
450:
451: )
452: IS

Line 449: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE

445: ,p_pricing_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
446: ,p_qual_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
447: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE
448: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
449: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
450:
451: )
452: IS
453: BEGIN

Line 540: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

536: ,x_return_status out nocopy varchar2
537: ,x_return_status_text out nocopy varchar2
538: )
539: IS
540: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
541: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
542: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 541: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

537: ,x_return_status_text out nocopy varchar2
538: )
539: IS
540: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
541: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
542: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 542: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

538: )
539: IS
540: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
541: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
542: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

539: IS
540: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
541: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
542: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

Line 544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

540: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
541: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
542: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

541: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
542: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

542: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

543: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

544: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
552: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

545: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
552: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
553: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

546: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
552: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
553: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
554: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

547: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
552: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
553: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
554: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
555:

Line 552: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

548: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
552: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
553: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
554: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
555:
556:

Line 553: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

549: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
552: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
553: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
554: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
555:
556:
557: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

Line 554: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

550: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
551: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
552: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
553: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
554: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
555:
556:
557: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
558: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

Line 557: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

553: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
554: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
555:
556:
557: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
558: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
559: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
560: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
561:

Line 558: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

554: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
555:
556:
557: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
558: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
559: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
560: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
561:
562: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 559: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

555:
556:
557: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
558: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
559: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
560: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
561:
562: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
563: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 560: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;

556:
557: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
558: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
559: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
560: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
561:
562: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
563: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
564:

Line 644: l_rltd_rec.RELATIONSHIP_TYPE_CODE := QP_PREQ_GRP.G_SERVICE_LINE;

640: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
641: ibe_util.debug('getpricefromqp: Line index='||l_rltd_rec.related_line_index);
642: END IF;
643:
644: l_rltd_rec.RELATIONSHIP_TYPE_CODE := QP_PREQ_GRP.G_SERVICE_LINE;
645: l_related_lines_tbl(I) := l_rltd_rec;
646: END LOOP;
647: END IF;
648:

Line 655: QP_PREQ_GRP.PRICE_REQUEST(l_line_tbl,

651: ibe_util.debug('total lines ='|| l_line_tbl.count);
652: END IF;
653:
654: get_time(l_t1);
655: QP_PREQ_GRP.PRICE_REQUEST(l_line_tbl,
656: l_qual_tbl,
657: l_line_attr_tbl,
658: l_line_detail_tbl,
659: l_line_detail_qual_tbl,

Line 2042: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE

2038: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
2039: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
2040: ,p_currency_code IN VARCHAR2
2041: ,p_minisite_id IN NUMBER := NULL
2042: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2043: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
2044: ,p_model_id_tbl IN JTF_NUMBER_TABLE
2045: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
2046: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE

Line 2043: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE

2039: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
2040: ,p_currency_code IN VARCHAR2
2041: ,p_minisite_id IN NUMBER := NULL
2042: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2043: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
2044: ,p_model_id_tbl IN JTF_NUMBER_TABLE
2045: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
2046: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2047: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE

Line 2045: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE

2041: ,p_minisite_id IN NUMBER := NULL
2042: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2043: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
2044: ,p_model_id_tbl IN JTF_NUMBER_TABLE
2045: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
2046: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2047: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2048: ,p_request_type_code IN VARCHAR2 := 'ASO'
2049: ,p_pricing_event IN VARCHAR2

Line 2046: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE

2042: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2043: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
2044: ,p_model_id_tbl IN JTF_NUMBER_TABLE
2045: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
2046: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2047: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2048: ,p_request_type_code IN VARCHAR2 := 'ASO'
2049: ,p_pricing_event IN VARCHAR2
2050: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE

Line 2047: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE

2043: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
2044: ,p_model_id_tbl IN JTF_NUMBER_TABLE
2045: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
2046: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2047: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2048: ,p_request_type_code IN VARCHAR2 := 'ASO'
2049: ,p_pricing_event IN VARCHAR2
2050: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE
2051: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 2059: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

2055: IS
2056:
2057: L_API VARCHAR2(64);
2058:
2059: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2060:
2061: I BINARY_INTEGER;
2062: l_t0 NUMBER;
2063: l_t1 NUMBER;

Line 2067: G_LINE_INDEX_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

2063: l_t1 NUMBER;
2064: l_t2 NUMBER;
2065: l_ti NUMBER;
2066:
2067: G_LINE_INDEX_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2068: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2069: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2068: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2064: l_t2 NUMBER;
2065: l_ti NUMBER;
2066:
2067: G_LINE_INDEX_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2068: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2069: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

Line 2069: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;

2065: l_ti NUMBER;
2066:
2067: G_LINE_INDEX_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2068: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2069: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

Line 2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;

2066:
2067: G_LINE_INDEX_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2068: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2069: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

Line 2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2067: G_LINE_INDEX_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2068: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2069: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

2068: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2069: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

2069: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

2070: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2071: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2072: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

2073: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

2074: --G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2075: --G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2076: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

2077: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

2078: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

2079: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

2080: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2081: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2082: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

Line 2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

2083: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

2084: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

2085: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

2086: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2087: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2088: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

2089: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2090: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2091: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2092: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2100: G_RELATIONSHIP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2093: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2100: G_RELATIONSHIP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
2101: G_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

2094: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2100: G_RELATIONSHIP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
2101: G_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2102: G_RLTD_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

2095: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2100: G_RELATIONSHIP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
2101: G_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2102: G_RLTD_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2103:

Line 2100: G_RELATIONSHIP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

2096: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2100: G_RELATIONSHIP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
2101: G_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2102: G_RLTD_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2103:
2104: L_PRICE_LIST NUMBER := -9999;

Line 2101: G_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;

2097: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2100: G_RELATIONSHIP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
2101: G_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2102: G_RLTD_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2103:
2104: L_PRICE_LIST NUMBER := -9999;
2105: l_model_id NUMBER;

Line 2102: G_RLTD_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;

2098: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2099: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2100: G_RELATIONSHIP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
2101: G_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2102: G_RLTD_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
2103:
2104: L_PRICE_LIST NUMBER := -9999;
2105: l_model_id NUMBER;
2106: l_cust_party_id NUMBER;

Line 2131: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': QP Version'||QP_PREQ_GRP.GET_VERSION);

2127:
2128: BEGIN
2129: L_API := 'PRICE_REQUEST';
2130: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2131: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': QP Version'||QP_PREQ_GRP.GET_VERSION);
2132: END IF;
2133:
2134: l_t0 := DBMS_UTILITY.GET_TIME;
2135: IF p_price_list_id IS NOT NULL AND p_price_list_id <> FND_API.G_MISS_NUM THEN

Line 2278: G_PRICING_STATUS_CODE_tbl(I) := QP_PREQ_GRP.G_STATUS_UNCHANGED; --23:

2274: G_PROCESSED_FLAG_TBL(I) := null; --19:
2275: G_PRICE_FLAG_TBL(I) := 'Y'; --20: Price Flag can have 'Y' , 'N'(No pricing) , 'P'(Phase)
2276: G_LINE_ID_TBL(I) := I; --21: Order Line Id.
2277: G_PROCESSING_ORDER_TBL(I) := null; --22:
2278: G_PRICING_STATUS_CODE_tbl(I) := QP_PREQ_GRP.G_STATUS_UNCHANGED; --23:
2279: G_PRICING_STATUS_TEXT_tbl(I) := null; --24:
2280: G_ROUNDING_FLAG_TBL(I) := null; --25:
2281: G_ROUNDING_FACTOR_TBL(I) := null; --26:
2282: G_QUALIFIERS_EXIST_FLAG_TBL(I) := 'N'; --27:

Line 2287: G_usage_pricing_type_tbl(I) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE; --32: This can be 'REGULAR', 'AUTHORING', 'BILLING' --used in usage pricing

2283: G_PRICING_ATTRS_EXIST_FLAG_TBL(I) := 'N'; --28:
2284: G_PRICE_LIST_ID_TBL(I) := L_PRICE_LIST; --29:price list id used by qp
2285: G_PL_VALIDATED_FLAG_TBL(I) := 'N'; --30:
2286: G_PRICE_REQUEST_CODE_TBL(I) := null; --31:
2287: G_usage_pricing_type_tbl(I) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE; --32: This can be 'REGULAR', 'AUTHORING', 'BILLING' --used in usage pricing
2288: --G_LINE_CATEGORY_tbl(I) := null; --33:
2289:
2290: -- populate line attributes/qualifiers
2291: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2349: G_PRICING_STATUS_CODE_tbl(I) := QP_PREQ_GRP.G_STATUS_UNCHANGED; --23:

2345: G_PROCESSED_FLAG_TBL(I) := null; --19:
2346: G_PRICE_FLAG_TBL(I) := 'Y'; --20: Price Flag can have 'Y' , 'N'(No pricing) , 'P'(Phase)
2347: G_LINE_ID_TBL(I) := I; --21: Order Line Id.
2348: G_PROCESSING_ORDER_TBL(I) := null; --22:
2349: G_PRICING_STATUS_CODE_tbl(I) := QP_PREQ_GRP.G_STATUS_UNCHANGED; --23:
2350: G_PRICING_STATUS_TEXT_tbl(I) := null; --24:
2351: G_ROUNDING_FLAG_TBL(I) := null; --25:
2352: G_ROUNDING_FACTOR_TBL(I) := null; --26:
2353: G_QUALIFIERS_EXIST_FLAG_TBL(I) := 'N'; --27:

Line 2358: G_usage_pricing_type_tbl(I) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE; --32: This can be 'REGULAR', 'AUTHORING', 'BILLING' --used in usage pricing

2354: G_PRICING_ATTRS_EXIST_FLAG_TBL(I) := 'N'; --28:
2355: G_PRICE_LIST_ID_TBL(I) := L_PRICE_LIST; --29:???
2356: G_PL_VALIDATED_FLAG_TBL(I) := 'N'; --30:
2357: G_PRICE_REQUEST_CODE_TBL(I) := null; --31:
2358: G_usage_pricing_type_tbl(I) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE; --32: This can be 'REGULAR', 'AUTHORING', 'BILLING' --used in usage pricing
2359: --G_LINE_CATEGORY_tbl(I) := null; --33:
2360:
2361: -- populate header attibutes/qualifiers
2362: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2394: QP_PREQ_GRP.INSERT_LINES2

2390: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': inserting request lines into QP temp table, total lines='||G_LINE_INDEX_TBL.count);
2391: END IF;
2392:
2393: l_ti := DBMS_UTILITY.GET_TIME;
2394: QP_PREQ_GRP.INSERT_LINES2
2395: (p_LINE_INDEX => G_LINE_INDEX_TBL,
2396: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
2397: p_PRICING_EFFECTIVE_DATE => G_PRICING_EFFECTIVE_DATE_TBL,
2398: p_ACTIVE_DATE_FIRST => G_ACTIVE_DATE_FIRST_TBL,

Line 2447: G_RELATIONSHIP_TYPE_CODE(I) := QP_PREQ_GRP.G_SERVICE_LINE;

2443: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2444: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': populating related lines...');
2445: END IF;
2446: FOR I IN p_parentIndex_tbl.FIRST..p_parentIndex_tbl.LAST LOOP
2447: G_RELATIONSHIP_TYPE_CODE(I) := QP_PREQ_GRP.G_SERVICE_LINE;
2448: G_LINE_DETAIL_INDEX_TBL(I) := NULL;
2449: G_RLTD_LINE_DETAIL_INDEX_TBL(I) := NULL; --gzhang 06/07/2003
2450: END LOOP;
2451:

Line 2456: QP_PREQ_GRP.INSERT_RLTD_LINES2

2452: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2453: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': inserting related lines...');
2454: END IF;
2455:
2456: QP_PREQ_GRP.INSERT_RLTD_LINES2
2457: (p_LINE_INDEX => p_parentIndex_tbl,
2458: p_LINE_DETAIL_INDEX => G_LINE_DETAIL_INDEX_TBL,
2459: p_RELATIONSHIP_TYPE_CODE => G_RELATIONSHIP_TYPE_CODE,
2460: p_RELATED_LINE_INDEX => p_childindex_tbl,

Line 2529: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;

2525: ,x_return_status_text OUT NOCOPY VARCHAR2
2526: )
2527: IS
2528: L_API VARCHAR2(64);
2529: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2530: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2531: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2532: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2533: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 2530: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

2526: )
2527: IS
2528: L_API VARCHAR2(64);
2529: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2530: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2531: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2532: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2533: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2534: idx BINARY_INTEGER;

Line 2531: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

2527: IS
2528: L_API VARCHAR2(64);
2529: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2530: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2531: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2532: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2533: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2534: idx BINARY_INTEGER;
2535: l_total_lines INTEGER;

Line 2532: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

2528: L_API VARCHAR2(64);
2529: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2530: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2531: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2532: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2533: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2534: idx BINARY_INTEGER;
2535: l_total_lines INTEGER;
2536: l_pricing_flag BOOLEAN := TRUE;

Line 2533: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

2529: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2530: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2531: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2532: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2533: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2534: idx BINARY_INTEGER;
2535: l_total_lines INTEGER;
2536: l_pricing_flag BOOLEAN := TRUE;
2537: l_start_time NUMBER;