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.AMS_PRICE_PVT dependencies on QP_PREQ_GRP

Line 91: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

87: PROCEDURE Copy_Attribs_To_Req(
88: p_line_index number,
89: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
90: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
91: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
92: px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE)
93: IS
94: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
95: l_qual_index number := nvl(px_Req_qual_tbl.last,0);

Line 92: px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE)

88: p_line_index number,
89: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
90: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
91: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
92: px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE)
93: IS
94: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
95: l_qual_index number := nvl(px_Req_qual_tbl.last,0);
96: BEGIN

Line 139: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

135: ,p_party_id in number := FND_API.G_MISS_NUM
136: ,p_cust_account_id in number := FND_API.G_MISS_NUM
137: ,p_line_index in number
138: ,p_request_type_code in varchar2
139: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
140: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
141: )
142: is
143: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 140: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE

136: ,p_cust_account_id in number := FND_API.G_MISS_NUM
137: ,p_line_index in number
138: ,p_request_type_code in varchar2
139: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
140: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
141: )
142: is
143: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
144: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 146: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

142: is
143: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
144: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
145:
146: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
147: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
148:
149: begin
150:

Line 147: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

143: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
144: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
145:
146: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
147: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
148:
149: begin
150:
151:

Line 244: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

240: ,p_cust_account_id in number := FND_API.G_MISS_NUM
241: ,p_price_list_id in number := FND_API.G_MISS_NUM
242: ,p_line_index in number
243: ,p_request_type_code in varchar2
244: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
245: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
246: )
247: is
248: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 245: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE

241: ,p_price_list_id in number := FND_API.G_MISS_NUM
242: ,p_line_index in number
243: ,p_request_type_code in varchar2
244: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
245: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
246: )
247: is
248: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
249: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 250: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

246: )
247: is
248: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
249: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
250: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
251: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
252:
253: begin
254: getHeaderAttrAndQual(

Line 251: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

247: is
248: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
249: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
250: -- l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
251: -- l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
252:
253: begin
254: getHeaderAttrAndQual(
255: p_party_id => p_party_id,

Line 278: ,x_control_rec OUT nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE

274:
275:
276: PROCEDURE Set_Control_Rec(
277: p_pricing_event in varchar2
278: ,x_control_rec OUT nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
279: )
280: IS
281: BEGIN
282: -- setup control record

Line 295: ,px_line_rec IN OUT NOCOPY QP_PREQ_GRP.LINE_REC_TYPE

291: p_line_id IN Number
292: ,p_line_index IN Number
293: ,p_uom_code IN VARCHAR2
294: ,p_request_type_code IN varchar2
295: ,px_line_rec IN OUT NOCOPY QP_PREQ_GRP.LINE_REC_TYPE
296: )
297: IS
298: BEGIN
299:

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

321: ,p_currency_code in varchar2
322: ,p_line_id in number
323: ,p_line_index in number
324: ,p_request_type_code in varchar2
325: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE)
326: IS
327: l_index number := nvl(px_line_tbl.last,0);
328: l_line_rec QP_PREQ_GRP.Line_REC_TYPE;
329:

Line 328: l_line_rec QP_PREQ_GRP.Line_REC_TYPE;

324: ,p_request_type_code in varchar2
325: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE)
326: IS
327: l_index number := nvl(px_line_tbl.last,0);
328: l_line_rec QP_PREQ_GRP.Line_REC_TYPE;
329:
330: BEGIN
331:
332: l_line_rec.request_type_code := p_request_type_code;

Line 353: ,px_line_attr_rec IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_REC_TYPE

349:
350: PROCEDURE Set_Line_Attr_Rec(
351: p_line_index IN Number
352: ,p_inventory_item_id IN VARCHAR2
353: ,px_line_attr_rec IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_REC_TYPE
354: )
355: IS
356: BEGIN
357: -- setup line_attr_rec

Line 369: ,px_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

365:
366: PROCEDURE GetReqLineAttr(
367: p_line_index IN Number
368: ,p_inventory_item_id IN VARCHAR2
369: ,px_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
370: )
371: is
372: l_index number := nvl(px_line_attr_tbl.last,0);
373: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

Line 373: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

369: ,px_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
370: )
371: is
372: l_index number := nvl(px_line_attr_tbl.last,0);
373: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
374: begin
375: set_line_attr_rec(p_line_index, p_inventory_item_id, l_line_attr_rec);
376: l_index := l_index +1;
377: px_line_attr_tbl(l_index) := l_line_attr_rec;

Line 384: ,px_qual_rec IN OUT NOCOPY QP_PREQ_GRP.QUAL_REC_TYPE

380:
381: PROCEDURE Set_Qual_Rec(
382: p_line_index IN Number
383: ,p_price_list_id IN VARCHAR2
384: ,px_qual_rec IN OUT NOCOPY QP_PREQ_GRP.QUAL_REC_TYPE
385: )
386: IS
387: BEGIN
388: IF (AMS_DEBUG_HIGH_ON) THEN

Line 405: ,px_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE

401:
402: PROCEDURE GetReqQual(
403: p_line_index IN Number
404: ,p_price_list_id IN VARCHAR2
405: ,px_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE
406: )
407: is
408: l_index number := nvl(px_qual_tbl.last,0);
409: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

Line 409: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

405: ,px_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE
406: )
407: is
408: l_index number := nvl(px_qual_tbl.last,0);
409: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
410: begin
411: set_qual_rec(p_line_index, p_price_list_id, l_qual_rec);
412: l_index := l_index +1;
413: px_qual_tbl(l_index) := l_qual_rec;

Line 430: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE

426: ,p_line_index in number
427: ,p_request_type_code varchar2
428: ,p_pricing_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
429: ,p_qual_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
430: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE
431: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
432: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
433:
434: )

Line 431: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

427: ,p_request_type_code varchar2
428: ,p_pricing_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
429: ,p_qual_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
430: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE
431: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
432: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
433:
434: )
435: IS

Line 432: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE

428: ,p_pricing_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
429: ,p_qual_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
430: ,px_line_tbl in out nocopy QP_PREQ_GRP.Line_TBL_TYPE
431: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
432: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE
433:
434: )
435: IS
436: BEGIN

Line 510: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

506: ,x_return_status out nocopy varchar2
507: ,x_return_status_text out nocopy varchar2
508: )
509: IS
510: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
511: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
512: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 511: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

507: ,x_return_status_text out nocopy varchar2
508: )
509: IS
510: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
511: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
512: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 512: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

508: )
509: IS
510: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
511: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
512: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

509: IS
510: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
511: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
512: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

Line 514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

510: l_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
511: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
512: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

511: l_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
512: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

512: l_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

513: l_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

514: l_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
522: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

515: l_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
522: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
523: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

516: l_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
522: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
523: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
524: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

517: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
522: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
523: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
524: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
525:

Line 522: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

518: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
522: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
523: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
524: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
525:
526:

Line 523: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

519: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
522: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
523: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
524: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
525:
526:
527: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

Line 524: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

520: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
521: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
522: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
523: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
524: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
525:
526:
527: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
528: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

Line 527: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

523: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
524: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
525:
526:
527: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
528: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
529: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
530: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
531:

Line 528: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

524: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
525:
526:
527: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
528: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
529: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
530: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
531:
532: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 529: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

525:
526:
527: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
528: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
529: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
530: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
531:
532: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
533: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 530: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;

526:
527: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
528: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
529: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
530: l_rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
531:
532: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
533: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
534:

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

594: IF (AMS_DEBUG_HIGH_ON) THEN
595:
596: AMS_UTILITY_PVT.debug_message('getpricefromqp: Line index='||l_rltd_rec.related_line_index);
597: END IF;
598: l_rltd_rec.RELATIONSHIP_TYPE_CODE := QP_PREQ_GRP.G_SERVICE_LINE;
599: l_related_lines_tbl(I) := l_rltd_rec;
600: END LOOP;
601: END IF;
602:

Line 605: QP_PREQ_GRP.PRICE_REQUEST(l_line_tbl,

601: END IF;
602:
603:
604: get_time(l_t1);
605: QP_PREQ_GRP.PRICE_REQUEST(l_line_tbl,
606: l_qual_tbl,
607: l_line_attr_tbl,
608: l_line_detail_tbl,
609: l_line_detail_qual_tbl,