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.OZF_VOLUME_OFFER_ADJ dependencies on QP_MODIFIERS_PUB

Line 141: x_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

137: AND offer_adjustment_id = cp_offerAdjustmentId
138: AND c.list_line_id = cp_listLineId;
139: l_endDate c_endDate%ROWTYPE;
140:
141: x_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
142: l_modifier_line_tbl qp_modifiers_pub.Modifiers_Tbl_Type;
143: l_errorLoc NUMBER;
144: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
145: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

Line 142: l_modifier_line_tbl qp_modifiers_pub.Modifiers_Tbl_Type;

138: AND c.list_line_id = cp_listLineId;
139: l_endDate c_endDate%ROWTYPE;
140:
141: x_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
142: l_modifier_line_tbl qp_modifiers_pub.Modifiers_Tbl_Type;
143: l_errorLoc NUMBER;
144: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
145: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
146: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 144: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

140:
141: x_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
142: l_modifier_line_tbl qp_modifiers_pub.Modifiers_Tbl_Type;
143: l_errorLoc NUMBER;
144: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
145: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
146: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
147: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
148: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 145: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

141: x_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
142: l_modifier_line_tbl qp_modifiers_pub.Modifiers_Tbl_Type;
143: l_errorLoc NUMBER;
144: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
145: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
146: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
147: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
148: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
149: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 146: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

142: l_modifier_line_tbl qp_modifiers_pub.Modifiers_Tbl_Type;
143: l_errorLoc NUMBER;
144: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
145: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
146: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
147: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
148: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
149: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
150: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 147: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

143: l_errorLoc NUMBER;
144: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
145: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
146: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
147: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
148: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
149: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
150: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
151: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 150: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

146: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
147: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
148: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
149: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
150: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
151: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
152:
153: BEGIN
154: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 151: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

147: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
148: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
149: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
150: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
151: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
152:
153: BEGIN
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155: -- retrieve end_date into local record

Line 173: QP_Modifiers_PUB.process_modifiers(

169: l_modifier_line_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;
170: l_modifier_line_tbl(1).list_line_type_code := l_listLines.list_line_type_code;
171: l_modifier_line_tbl(1).price_break_type_code:= l_listLines.price_break_type_code;
172: END LOOP;
173: QP_Modifiers_PUB.process_modifiers(
174: p_api_version_number => 1.0,
175: p_init_msg_list => FND_API.G_FALSE,
176: p_return_values => FND_API.G_FALSE,
177: x_return_status => x_return_status,

Line 231: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

227:
228:
229: PROCEDURE populate_discounts
230: (
231: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
232: , p_list_line_id IN NUMBER
233: )
234: IS
235: CURSOR c_discounts(cp_listLineId NUMBER) IS

Line 282: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

278: FROM
279: qp_list_lines c
280: WHERE c.list_line_id = cp_listLineId;
281: i NUMBER := null;
282: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
283: BEGIN
284: --dbms_output.put_line('listLIneId1 is :'||p_list_line_id);
285: FOR l_discounts in c_discounts(cp_listLineId => p_list_line_id) LOOP
286: x_modifiers_rec.list_header_id := l_discounts.list_header_id;

Line 336: x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

332: END populate_discounts;
333:
334: PROCEDURE populate_pricing_attributes
335: (
336: x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
337: , p_list_line_id IN NUMBER
338: , p_index IN NUMBER
339: )
340: IS

Line 385: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

381: x_return_status OUT NOCOPY VARCHAR2
382: , x_msg_count OUT NOCOPY NUMBER
383: , x_msg_data OUT NOCOPY VARCHAR2
384: , p_listLineId IN NUMBER
385: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
386: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
387: )
388: IS
389: BEGIN

Line 386: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

382: , x_msg_count OUT NOCOPY NUMBER
383: , x_msg_data OUT NOCOPY VARCHAR2
384: , p_listLineId IN NUMBER
385: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
386: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
387: )
388: IS
389: BEGIN
390: --dbms_output.put_line('IN populate pbh line');

Line 414: p_to_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

410: END populate_pbh_line;
411:
412: PROCEDURE merge_modifiers
413: (
414: p_to_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
415: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
416: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
417: )
418: IS

Line 415: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

411:
412: PROCEDURE merge_modifiers
413: (
414: p_to_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
415: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
416: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
417: )
418: IS
419: BEGIN

Line 416: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

412: PROCEDURE merge_modifiers
413: (
414: p_to_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
415: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
416: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
417: )
418: IS
419: BEGIN
420: x_modifier_line_tbl.delete;

Line 435: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

431: END merge_modifiers;
432:
433: PROCEDURE merge_modifiers
434: (
435: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
436: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
437: )
438: IS
439: BEGIN

Line 436: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

432:
433: PROCEDURE merge_modifiers
434: (
435: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
436: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
437: )
438: IS
439: BEGIN
440: --dbms_output.put_line('In Merge Modifiers:');

Line 455: p_to_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

451: END merge_modifiers;
452:
453: PROCEDURE merge_pricing_attributes
454: (
455: p_to_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
456: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
457: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
458: )
459: IS

Line 456: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

452:
453: PROCEDURE merge_pricing_attributes
454: (
455: p_to_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
456: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
457: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
458: )
459: IS
460: BEGIN

Line 457: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

453: PROCEDURE merge_pricing_attributes
454: (
455: p_to_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
456: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
457: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
458: )
459: IS
460: BEGIN
461: x_pricing_attr_tbl.delete;

Line 477: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

473:
474:
475: PROCEDURE merge_pricing_attributes
476: (
477: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
478: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
479: )
480: IS
481: BEGIN

Line 478: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

474:
475: PROCEDURE merge_pricing_attributes
476: (
477: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
478: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
479: )
480: IS
481: BEGIN
482: IF nvl(p_from_pricing_attr_tbl.count,0) > 0 THEN

Line 499: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

495: , x_msg_count OUT NOCOPY NUMBER
496: , x_msg_data OUT NOCOPY VARCHAR2
497: , p_listLineId IN NUMBER
498: , p_offerAdjustmentId IN NUMBER
499: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
500: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
501: )
502: IS
503: CURSOR c_discountLines(cp_listLineId NUMBER , cp_offerAdjustmentId NUMBER)

Line 500: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

496: , x_msg_data OUT NOCOPY VARCHAR2
497: , p_listLineId IN NUMBER
498: , p_offerAdjustmentId IN NUMBER
499: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
500: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
501: )
502: IS
503: CURSOR c_discountLines(cp_listLineId NUMBER , cp_offerAdjustmentId NUMBER)
504: IS

Line 518: l_pricingAttrTbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

514: FROM qp_rltd_modifiers
515: WHERE from_rltd_modifier_id = cp_listLineId;
516: */
517: i NUMBER;
518: l_pricingAttrTbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
519: BEGIN
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521: x_modifier_line_tbl.delete;
522: x_pricing_attr_tbl.delete;

Line 563: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

559: x_return_status OUT NOCOPY VARCHAR2
560: , x_msg_count OUT NOCOPY NUMBER
561: , x_msg_data OUT NOCOPY VARCHAR2
562: , p_listLineId IN NUMBER
563: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
564: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
565: , p_offerAdjustmentId IN NUMBER
566: )
567: IS

Line 564: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

560: , x_msg_count OUT NOCOPY NUMBER
561: , x_msg_data OUT NOCOPY VARCHAR2
562: , p_listLineId IN NUMBER
563: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
564: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
565: , p_offerAdjustmentId IN NUMBER
566: )
567: IS
568: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 568: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

564: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
565: , p_offerAdjustmentId IN NUMBER
566: )
567: IS
568: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
569: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
570: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
571: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
572: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)

Line 569: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

565: , p_offerAdjustmentId IN NUMBER
566: )
567: IS
568: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
569: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
570: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
571: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
572: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)
573: IS

Line 570: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

566: )
567: IS
568: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
569: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
570: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
571: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
572: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)
573: IS
574: SELECT

Line 571: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

567: IS
568: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
569: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
570: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
571: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
572: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)
573: IS
574: SELECT
575: a.effective_date, a.list_header_id

Line 669: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

665: , x_msg_count OUT NOCOPY NUMBER
666: , x_msg_data OUT NOCOPY VARCHAR2
667: , p_offerAdjustmentId IN NUMBER
668: , p_listLineId IN NUMBER
669: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
670: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
671: )
672: IS
673: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

Line 670: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

666: , x_msg_data OUT NOCOPY VARCHAR2
667: , p_offerAdjustmentId IN NUMBER
668: , p_listLineId IN NUMBER
669: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
670: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
671: )
672: IS
673: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
674: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

Line 673: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

669: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
670: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
671: )
672: IS
673: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
674: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
675: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
676: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
677: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 674: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

670: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
671: )
672: IS
673: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
674: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
675: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
676: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
677: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
678: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 675: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

671: )
672: IS
673: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
674: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
675: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
676: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
677: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
678: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
679: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 676: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

672: IS
673: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
674: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
675: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
676: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
677: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
678: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
679: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
680: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 679: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

675: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
676: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
677: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
678: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
679: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
680: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
681: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
682: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
683: BEGIN

Line 680: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

676: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
677: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
678: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
679: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
680: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
681: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
682: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
683: BEGIN
684: -- initialize return status, nested tables

Line 681: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

677: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
678: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
679: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
680: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
681: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
682: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
683: BEGIN
684: -- initialize return status, nested tables
685: -- for given adjustment id get the adjustment tiers

Line 682: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

678: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
679: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
680: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
681: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
682: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
683: BEGIN
684: -- initialize return status, nested tables
685: -- for given adjustment id get the adjustment tiers
686: -- populate the qp_list_lines using the tiers and adjustment tiers

Line 708: QP_Modifiers_PUB.process_modifiers(

704: RAISE FND_API.G_EXC_ERROR;
705: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708: QP_Modifiers_PUB.process_modifiers(
709: p_api_version_number => 1.0,
710: p_init_msg_list => FND_API.G_FALSE,
711: p_return_values => FND_API.G_FALSE,
712: x_return_status => x_return_status,

Line 746: ,p_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

742: ,x_msg_count OUT NOCOPY NUMBER
743: ,x_msg_data OUT NOCOPY VARCHAR2
744: ,p_offerAdjustmentId IN NUMBER
745: ,p_offerDiscountLineId IN NUMBER
746: ,p_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
747: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
748: )
749: IS
750: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;

Line 747: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

743: ,x_msg_data OUT NOCOPY VARCHAR2
744: ,p_offerAdjustmentId IN NUMBER
745: ,p_offerDiscountLineId IN NUMBER
746: ,p_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
747: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
748: )
749: IS
750: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
751: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

Line 871: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

867: x_return_status OUT NOCOPY VARCHAR2
868: ,x_msg_count OUT NOCOPY NUMBER
869: ,x_msg_data OUT NOCOPY VARCHAR2
870: ,p_offerAdjustmentId IN NUMBER
871: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
872: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
873: )
874: IS
875: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 872: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

868: ,x_msg_count OUT NOCOPY NUMBER
869: ,x_msg_data OUT NOCOPY VARCHAR2
870: ,p_offerAdjustmentId IN NUMBER
871: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
872: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
873: )
874: IS
875: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
876: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 875: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

871: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
872: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
873: )
874: IS
875: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
876: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
877: CURSOR c_tierHeader(cp_offerAdjustmentId NUMBER)
878: IS
879: SELECT distinct parent_discount_line_id , c.list_line_id

Line 876: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

872: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
873: )
874: IS
875: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
876: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
877: CURSOR c_tierHeader(cp_offerAdjustmentId NUMBER)
878: IS
879: SELECT distinct parent_discount_line_id , c.list_line_id
880: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d

Line 931: ,p_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

927: ,x_msg_count OUT NOCOPY NUMBER
928: ,x_msg_data OUT NOCOPY VARCHAR2
929: ,p_offerAdjustmentId IN NUMBER
930: ,p_offerDiscountLineId IN NUMBER
931: ,p_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
932: ,p_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
933: )*/
934: merge_modifiers
935: (

Line 932: ,p_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

928: ,x_msg_data OUT NOCOPY VARCHAR2
929: ,p_offerAdjustmentId IN NUMBER
930: ,p_offerDiscountLineId IN NUMBER
931: ,p_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
932: ,p_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
933: )*/
934: merge_modifiers
935: (
936: px_to_modifier_line_tbl => x_modifier_line_tbl

Line 998: p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type

994: END relate_lines;
995:
996: PROCEDURE relate_lines
997: (
998: p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type
999: , p_offer_adjustment_id IN NUMBER
1000: , x_return_status OUT NOCOPY VARCHAR2
1001: , x_msg_count OUT NOCOPY NUMBER
1002: , x_msg_data OUT NOCOPY VARCHAR2

Line 1049: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1045: ,x_msg_data OUT NOCOPY VARCHAR2
1046: ,p_offerAdjustmentId IN NUMBER
1047: )
1048: IS
1049: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1050: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1051: BEGIN
1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053: /*

Line 1050: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1046: ,p_offerAdjustmentId IN NUMBER
1047: )
1048: IS
1049: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1050: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1051: BEGIN
1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053: /*
1054: Corresponding to the discount changes, update the tier definitions.

Line 1246: , x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

1242:
1243: PROCEDURE populate_advanced_options
1244: (
1245: p_listHeaderId IN NUMBER
1246: , x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
1247: )
1248: IS
1249: CURSOR c_advOptions(cp_listHeaderId NUMBER)
1250: IS

Line 1281: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

1277: This produre populates and returns a qp_modifier_rec given the offerDiscountLineId
1278: */
1279: PROCEDURE populate_discounts
1280: (
1281: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
1282: , p_offerDiscountLineId IN NUMBER
1283: )
1284: IS
1285: -- list header id

Line 1345: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1341: x_return_status OUT NOCOPY VARCHAR2
1342: , x_msg_count OUT NOCOPY NUMBER
1343: , x_msg_data OUT NOCOPY VARCHAR2
1344: , p_offerDiscountLineId IN NUMBER
1345: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1346: )
1347: IS
1348: BEGIN
1349: --dbms_output.put_line('IN populate pbh line');

Line 1370: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

1366: x_return_status OUT NOCOPY VARCHAR2
1367: , x_msg_count OUT NOCOPY NUMBER
1368: , x_msg_data OUT NOCOPY VARCHAR2
1369: , p_offerDiscountLineId IN NUMBER
1370: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type
1371: , p_index IN NUMBER
1372: )
1373: IS
1374: CURSOR c_pricingAttr(cp_offerDiscountLineId NUMBER) IS

Line 1429: , x_modifier_line_rec IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Rec_Type

1425: , x_msg_count OUT NOCOPY NUMBER
1426: , x_msg_data OUT NOCOPY VARCHAR2
1427: , p_offDiscountProductId IN NUMBER
1428: , p_offerDiscountLineId IN NUMBER
1429: , x_modifier_line_rec IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Rec_Type
1430: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type
1431: )
1432: IS
1433: BEGIN

Line 1430: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

1426: , x_msg_data OUT NOCOPY VARCHAR2
1427: , p_offDiscountProductId IN NUMBER
1428: , p_offerDiscountLineId IN NUMBER
1429: , x_modifier_line_rec IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Rec_Type
1430: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type
1431: )
1432: IS
1433: BEGIN
1434: populate_discounts

Line 1466: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1462: , x_msg_count OUT NOCOPY NUMBER
1463: , x_msg_data OUT NOCOPY VARCHAR2
1464: , p_offerDiscountLineId IN NUMBER
1465: , p_offDiscountProductId IN NUMBER
1466: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1467: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_rec_type
1468: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1469: )
1470: IS

Line 1467: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_rec_type

1463: , x_msg_data OUT NOCOPY VARCHAR2
1464: , p_offerDiscountLineId IN NUMBER
1465: , p_offDiscountProductId IN NUMBER
1466: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1467: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_rec_type
1468: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1469: )
1470: IS
1471: CURSOR c_discountLines(cp_parentDiscountLineId NUMBER , cp_offDiscountProductId NUMBER)

Line 1468: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type

1464: , p_offerDiscountLineId IN NUMBER
1465: , p_offDiscountProductId IN NUMBER
1466: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1467: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_rec_type
1468: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1469: )
1470: IS
1471: CURSOR c_discountLines(cp_parentDiscountLineId NUMBER , cp_offDiscountProductId NUMBER)
1472: IS

Line 1544: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1540: , x_msg_count OUT NOCOPY NUMBER
1541: , x_msg_data OUT NOCOPY VARCHAR2
1542: , p_offerDiscountLineId IN NUMBER
1543: , p_offDiscountProductId IN NUMBER
1544: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1545: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
1546: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1547: )
1548: IS

Line 1545: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type

1541: , x_msg_data OUT NOCOPY VARCHAR2
1542: , p_offerDiscountLineId IN NUMBER
1543: , p_offDiscountProductId IN NUMBER
1544: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1545: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
1546: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1547: )
1548: IS
1549: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 1546: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type

1542: , p_offerDiscountLineId IN NUMBER
1543: , p_offDiscountProductId IN NUMBER
1544: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1545: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
1546: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1547: )
1548: IS
1549: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1550: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 1549: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1545: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
1546: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1547: )
1548: IS
1549: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1550: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1551: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1552: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1553: BEGIN

Line 1550: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1546: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1547: )
1548: IS
1549: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1550: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1551: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1552: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1553: BEGIN
1554: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1551: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;

1547: )
1548: IS
1549: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1550: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1551: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1552: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1553: BEGIN
1554: x_return_status := FND_API.G_RET_STS_SUCCESS;
1555: x_modifier_line_tbl.delete;

Line 1552: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;

1548: IS
1549: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1550: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1551: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1552: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1553: BEGIN
1554: x_return_status := FND_API.G_RET_STS_SUCCESS;
1555: x_modifier_line_tbl.delete;
1556: x_pricing_attr_tbl.delete;

Line 1626: into a Qp_Modifiers_Pub.pricing_attr_rec_type record given the Product Id in ozf_offer_discount_products table

1622: Note not initializing the record to attribute_grouping_no leads to unexpected error cannot insert null into qp_pricing_attributes.attribute_grouping_no
1623: */
1624: /**
1625: This method populates product attributes ie. Product Attribute, Product Attr Value , excluder flag
1626: into a Qp_Modifiers_Pub.pricing_attr_rec_type record given the Product Id in ozf_offer_discount_products table
1627: */
1628: PROCEDURE populate_product_attributes
1629: (
1630: x_pricing_attr_rec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

Line 1630: x_pricing_attr_rec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

1626: into a Qp_Modifiers_Pub.pricing_attr_rec_type record given the Product Id in ozf_offer_discount_products table
1627: */
1628: PROCEDURE populate_product_attributes
1629: (
1630: x_pricing_attr_rec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type
1631: , p_offDiscountProductId IN NUMBER
1632: -- , p_index IN NUMBER
1633: )
1634: IS

Line 1682: , p_modifiers_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1678: */
1679: PROCEDURE map_ozf_qp_data
1680: (
1681: p_offDiscountProductId IN NUMBER
1682: , p_modifiers_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1683: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1684: , x_return_status OUT NOCOPY VARCHAR2
1685: , x_msg_count OUT NOCOPY NUMBER
1686: , x_msg_data OUT NOCOPY VARCHAR2

Line 1683: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

1679: PROCEDURE map_ozf_qp_data
1680: (
1681: p_offDiscountProductId IN NUMBER
1682: , p_modifiers_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1683: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1684: , x_return_status OUT NOCOPY VARCHAR2
1685: , x_msg_count OUT NOCOPY NUMBER
1686: , x_msg_data OUT NOCOPY VARCHAR2
1687: )

Line 1758: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

1754: */
1755: PROCEDURE map_ozf_qp_products
1756: (
1757: p_offDiscountProductId IN NUMBER
1758: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1759: , x_return_status OUT NOCOPY VARCHAR2
1760: , x_msg_count OUT NOCOPY NUMBER
1761: , x_msg_data OUT NOCOPY VARCHAR2
1762: )

Line 1805: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1801: , x_msg_count OUT NOCOPY NUMBER
1802: , x_msg_data OUT NOCOPY VARCHAR2
1803: )
1804: IS
1805: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1806: i NUMBER;
1807: CURSOR c_qpListLines(cp_offDiscountProductId NUMBER)
1808: IS
1809: SELECT b.list_line_id, a.product_attribute, a.product_attr_value , c.list_header_id

Line 1816: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

1812: AND b.list_line_id = c.list_line_id
1813: AND a.off_discount_product_id = p_offDiscountProductId;
1814:
1815: l_errorLoc NUMBER;
1816: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1817: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1818: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1819: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1820: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1817: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

1813: AND a.off_discount_product_id = p_offDiscountProductId;
1814:
1815: l_errorLoc NUMBER;
1816: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1817: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1818: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1819: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1820: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1821: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 1818: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1814:
1815: l_errorLoc NUMBER;
1816: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1817: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1818: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1819: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1820: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1821: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1822: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 1819: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

1815: l_errorLoc NUMBER;
1816: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1817: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1818: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1819: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1820: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1821: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1822: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1823: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1822: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1818: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1819: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1820: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1821: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1822: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1823: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1824: BEGIN
1825: -- initialize
1826: -- retrieve all the qp_list_lines corresponding to the discount structure to which the exclusion is added.

Line 1823: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

1819: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1820: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1821: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1822: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1823: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1824: BEGIN
1825: -- initialize
1826: -- retrieve all the qp_list_lines corresponding to the discount structure to which the exclusion is added.
1827: -- exclude this new product from all the qp discount structures.

Line 1843: QP_Modifiers_PUB.process_modifiers(

1839: l_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
1840: --dbms_output.put_line('Details are:'||l_qpListLines.list_line_id||':'||l_qpListLines.list_header_id||':'||i);
1841: i := i + 1;
1842: END LOOP;
1843: QP_Modifiers_PUB.process_modifiers(
1844: p_api_version_number => 1.0,
1845: p_init_msg_list => FND_API.G_TRUE,
1846: p_return_values => FND_API.G_TRUE,
1847: x_return_status => x_return_status,

Line 1892: , px_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1888: x_return_status OUT NOCOPY VARCHAR2
1889: , x_msg_count OUT NOCOPY NUMBER
1890: , x_msg_data OUT NOCOPY VARCHAR2
1891: , p_offerAdjustmentId IN NUMBER
1892: , px_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1893: )
1894: IS
1895: CURSOR c_adjDetails(cp_offerAdjustmentId NUMBER) IS
1896: SELECT

Line 1929: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1925: x_return_status OUT NOCOPY VARCHAR2
1926: ,x_msg_count OUT NOCOPY NUMBER
1927: ,x_msg_data OUT NOCOPY VARCHAR2
1928: ,p_offerAdjustmentId IN NUMBER
1929: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1930: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1931: )
1932: IS
1933: CURSOR c_products(cp_offerAdjustmentId NUMBER) IS

Line 1930: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

1926: ,x_msg_count OUT NOCOPY NUMBER
1927: ,x_msg_data OUT NOCOPY VARCHAR2
1928: ,p_offerAdjustmentId IN NUMBER
1929: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1930: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1931: )
1932: IS
1933: CURSOR c_products(cp_offerAdjustmentId NUMBER) IS
1934: SELECT a.off_discount_product_id

Line 1949: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1945: WHERE offer_adjustment_id = cp_offerAdjustmentId
1946: AND product_attr_value IS NOT NULL
1947: AND excluder_flag = 'Y';
1948:
1949: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1950: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1951: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
1952: i NUMBER;
1953: l_errorLoc NUMBER;

Line 1950: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1946: AND product_attr_value IS NOT NULL
1947: AND excluder_flag = 'Y';
1948:
1949: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1950: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1951: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
1952: i NUMBER;
1953: l_errorLoc NUMBER;
1954: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

Line 1951: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;

1947: AND excluder_flag = 'Y';
1948:
1949: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1950: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1951: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
1952: i NUMBER;
1953: l_errorLoc NUMBER;
1954: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1955: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

Line 1954: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

1950: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1951: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
1952: i NUMBER;
1953: l_errorLoc NUMBER;
1954: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1955: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1956: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1957: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1958: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1955: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

1951: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
1952: i NUMBER;
1953: l_errorLoc NUMBER;
1954: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1955: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1956: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1957: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1958: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1959: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 1956: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1952: i NUMBER;
1953: l_errorLoc NUMBER;
1954: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1955: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1956: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1957: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1958: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1959: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1960: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 1957: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

1953: l_errorLoc NUMBER;
1954: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1955: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1956: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1957: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1958: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1959: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1960: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1961: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1960: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1956: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1957: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1958: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1959: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1960: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1961: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1962: BEGIN
1963: -- initialize
1964: -- query new products entered using adjustments.

Line 1961: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

1957: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1958: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1959: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1960: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1961: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1962: BEGIN
1963: -- initialize
1964: -- query new products entered using adjustments.
1965: -- for each new product id get the offer_discount_line_id

Line 2018: QP_Modifiers_PUB.process_modifiers(

2014: RAISE FND_API.G_EXC_ERROR;
2015: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2017: END IF;
2018: QP_Modifiers_PUB.process_modifiers(
2019: p_api_version_number => 1.0,
2020: p_init_msg_list => FND_API.G_TRUE,
2021: p_return_values => FND_API.G_TRUE,
2022: x_return_status => x_return_status,

Line 2084: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

2080: ,x_msg_data OUT NOCOPY VARCHAR2
2081: ,p_offerAdjustmentId IN NUMBER
2082: )
2083: IS
2084: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2085: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2086: BEGIN
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088: /*

Line 2085: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

2081: ,p_offerAdjustmentId IN NUMBER
2082: )
2083: IS
2084: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2085: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2086: BEGIN
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088: /*
2089: New Products are added to Particular discount tables, so discount table id is stored .