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.

[Home] [Help]

APPS.OZF_VOLUME_OFFER_ADJ dependencies on QP_MODIFIERS_PUB

Line 143: x_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

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

Line 144: l_modifier_line_tbl qp_modifiers_pub.Modifiers_Tbl_Type;

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

Line 146: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

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

Line 147: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

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

Line 148: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

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

Line 149: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

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

Line 152: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

148: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
149: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
150: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
151: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
152: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
153: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
154:
155: -- Fix for bug 12975394
156: l_qualifiers_tbl OZF_OFFER_PVT.QUALIFIERS_TBL_TYPE;

Line 153: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

149: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
150: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
151: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
152: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
153: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
154:
155: -- Fix for bug 12975394
156: l_qualifiers_tbl OZF_OFFER_PVT.QUALIFIERS_TBL_TYPE;
157: x_error_location NUMBER;

Line 228: QP_Modifiers_PUB.process_modifiers(

224: END IF;
225:
226:
227: END LOOP;
228: QP_Modifiers_PUB.process_modifiers(
229: p_api_version_number => 1.0,
230: p_init_msg_list => FND_API.G_FALSE,
231: p_return_values => FND_API.G_FALSE,
232: x_return_status => x_return_status,

Line 286: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

282:
283:
284: PROCEDURE populate_discounts
285: (
286: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
287: , p_list_line_id IN NUMBER
288: )
289: IS
290: CURSOR c_discounts(cp_listLineId NUMBER) IS

Line 337: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

333: FROM
334: qp_list_lines c
335: WHERE c.list_line_id = cp_listLineId;
336: i NUMBER := null;
337: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
338: BEGIN
339: --dbms_output.put_line('listLIneId1 is :'||p_list_line_id);
340: FOR l_discounts in c_discounts(cp_listLineId => p_list_line_id) LOOP
341: x_modifiers_rec.list_header_id := l_discounts.list_header_id;

Line 391: x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

387: END populate_discounts;
388:
389: PROCEDURE populate_pricing_attributes
390: (
391: x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
392: , p_list_line_id IN NUMBER
393: , p_index IN NUMBER
394: )
395: IS

Line 440: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

436: x_return_status OUT NOCOPY VARCHAR2
437: , x_msg_count OUT NOCOPY NUMBER
438: , x_msg_data OUT NOCOPY VARCHAR2
439: , p_listLineId IN NUMBER
440: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
441: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
442: )
443: IS
444: BEGIN

Line 441: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

437: , x_msg_count OUT NOCOPY NUMBER
438: , x_msg_data OUT NOCOPY VARCHAR2
439: , p_listLineId IN NUMBER
440: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
441: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
442: )
443: IS
444: BEGIN
445: --dbms_output.put_line('IN populate pbh line');

Line 469: p_to_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

465: END populate_pbh_line;
466:
467: PROCEDURE merge_modifiers
468: (
469: p_to_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
470: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
471: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
472: )
473: IS

Line 470: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

466:
467: PROCEDURE merge_modifiers
468: (
469: p_to_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
470: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
471: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
472: )
473: IS
474: BEGIN

Line 471: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

467: PROCEDURE merge_modifiers
468: (
469: p_to_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
470: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
471: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
472: )
473: IS
474: BEGIN
475: x_modifier_line_tbl.delete;

Line 490: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

486: END merge_modifiers;
487:
488: PROCEDURE merge_modifiers
489: (
490: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
491: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
492: )
493: IS
494: BEGIN

Line 491: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

487:
488: PROCEDURE merge_modifiers
489: (
490: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
491: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
492: )
493: IS
494: BEGIN
495: --dbms_output.put_line('In Merge Modifiers:');

Line 510: p_to_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

506: END merge_modifiers;
507:
508: PROCEDURE merge_pricing_attributes
509: (
510: p_to_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
511: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
512: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
513: )
514: IS

Line 511: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

507:
508: PROCEDURE merge_pricing_attributes
509: (
510: p_to_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
511: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
512: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
513: )
514: IS
515: BEGIN

Line 512: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

508: PROCEDURE merge_pricing_attributes
509: (
510: p_to_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
511: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
512: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
513: )
514: IS
515: BEGIN
516: x_pricing_attr_tbl.delete;

Line 532: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

528:
529:
530: PROCEDURE merge_pricing_attributes
531: (
532: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
533: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
534: )
535: IS
536: BEGIN

Line 533: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

529:
530: PROCEDURE merge_pricing_attributes
531: (
532: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
533: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
534: )
535: IS
536: BEGIN
537: IF nvl(p_from_pricing_attr_tbl.count,0) > 0 THEN

Line 554: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

550: , x_msg_count OUT NOCOPY NUMBER
551: , x_msg_data OUT NOCOPY VARCHAR2
552: , p_listLineId IN NUMBER
553: , p_offerAdjustmentId IN NUMBER
554: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
555: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
556: )
557: IS
558: CURSOR c_discountLines(cp_listLineId NUMBER , cp_offerAdjustmentId NUMBER)

Line 555: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

551: , x_msg_data OUT NOCOPY VARCHAR2
552: , p_listLineId IN NUMBER
553: , p_offerAdjustmentId IN NUMBER
554: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
555: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
556: )
557: IS
558: CURSOR c_discountLines(cp_listLineId NUMBER , cp_offerAdjustmentId NUMBER)
559: IS

Line 573: l_pricingAttrTbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

569: FROM qp_rltd_modifiers
570: WHERE from_rltd_modifier_id = cp_listLineId;
571: */
572: i NUMBER;
573: l_pricingAttrTbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
574: BEGIN
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576: x_modifier_line_tbl.delete;
577: x_pricing_attr_tbl.delete;

Line 618: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

614: x_return_status OUT NOCOPY VARCHAR2
615: , x_msg_count OUT NOCOPY NUMBER
616: , x_msg_data OUT NOCOPY VARCHAR2
617: , p_listLineId IN NUMBER
618: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
619: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
620: , p_offerAdjustmentId IN NUMBER
621: )
622: IS

Line 619: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

615: , x_msg_count OUT NOCOPY NUMBER
616: , x_msg_data OUT NOCOPY VARCHAR2
617: , p_listLineId IN NUMBER
618: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
619: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
620: , p_offerAdjustmentId IN NUMBER
621: )
622: IS
623: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 623: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

619: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
620: , p_offerAdjustmentId IN NUMBER
621: )
622: IS
623: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
624: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
625: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
626: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
627: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)

Line 624: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

620: , p_offerAdjustmentId IN NUMBER
621: )
622: IS
623: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
624: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
625: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
626: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
627: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)
628: IS

Line 625: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

621: )
622: IS
623: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
624: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
625: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
626: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
627: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)
628: IS
629: SELECT

Line 626: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

622: IS
623: pbh_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
624: dis_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
625: pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
626: dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
627: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)
628: IS
629: SELECT
630: a.effective_date, a.list_header_id

Line 724: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

720: , x_msg_count OUT NOCOPY NUMBER
721: , x_msg_data OUT NOCOPY VARCHAR2
722: , p_offerAdjustmentId IN NUMBER
723: , p_listLineId IN NUMBER
724: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
725: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
726: )
727: IS
728: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

Line 725: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

721: , x_msg_data OUT NOCOPY VARCHAR2
722: , p_offerAdjustmentId IN NUMBER
723: , p_listLineId IN NUMBER
724: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
725: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
726: )
727: IS
728: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
729: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

Line 728: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

724: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
725: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
726: )
727: IS
728: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
729: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
730: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
731: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
732: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 729: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

725: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
726: )
727: IS
728: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
729: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
730: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
731: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
732: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
733: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 730: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

726: )
727: IS
728: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
729: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
730: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
731: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
732: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
733: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
734: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 731: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

727: IS
728: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
729: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
730: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
731: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
732: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
733: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
734: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
735: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 734: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

730: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
731: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
732: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
733: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
734: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
735: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
736: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
737: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
738: BEGIN

Line 735: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

731: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
732: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
733: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
734: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
735: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
736: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
737: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
738: BEGIN
739: -- initialize return status, nested tables

Line 736: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

732: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
733: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
734: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
735: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
736: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
737: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
738: BEGIN
739: -- initialize return status, nested tables
740: -- for given adjustment id get the adjustment tiers

Line 737: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

733: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
734: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
735: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
736: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
737: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
738: BEGIN
739: -- initialize return status, nested tables
740: -- for given adjustment id get the adjustment tiers
741: -- populate the qp_list_lines using the tiers and adjustment tiers

Line 763: QP_Modifiers_PUB.process_modifiers(

759: RAISE FND_API.G_EXC_ERROR;
760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763: QP_Modifiers_PUB.process_modifiers(
764: p_api_version_number => 1.0,
765: p_init_msg_list => FND_API.G_FALSE,
766: p_return_values => FND_API.G_FALSE,
767: x_return_status => x_return_status,

Line 801: ,p_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

797: ,x_msg_count OUT NOCOPY NUMBER
798: ,x_msg_data OUT NOCOPY VARCHAR2
799: ,p_offerAdjustmentId IN NUMBER
800: ,p_offerDiscountLineId IN NUMBER
801: ,p_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
802: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
803: )
804: IS
805: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;

Line 802: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

798: ,x_msg_data OUT NOCOPY VARCHAR2
799: ,p_offerAdjustmentId IN NUMBER
800: ,p_offerDiscountLineId IN NUMBER
801: ,p_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
802: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
803: )
804: IS
805: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
806: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

Line 926: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

922: x_return_status OUT NOCOPY VARCHAR2
923: ,x_msg_count OUT NOCOPY NUMBER
924: ,x_msg_data OUT NOCOPY VARCHAR2
925: ,p_offerAdjustmentId IN NUMBER
926: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
927: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
928: )
929: IS
930: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 927: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

923: ,x_msg_count OUT NOCOPY NUMBER
924: ,x_msg_data OUT NOCOPY VARCHAR2
925: ,p_offerAdjustmentId IN NUMBER
926: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
927: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
928: )
929: IS
930: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
931: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 930: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

926: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
927: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
928: )
929: IS
930: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
931: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
932: CURSOR c_tierHeader(cp_offerAdjustmentId NUMBER)
933: IS
934: SELECT distinct parent_discount_line_id , c.list_line_id

Line 931: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

927: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
928: )
929: IS
930: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
931: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
932: CURSOR c_tierHeader(cp_offerAdjustmentId NUMBER)
933: IS
934: SELECT distinct parent_discount_line_id , c.list_line_id
935: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d

Line 986: ,p_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

982: ,x_msg_count OUT NOCOPY NUMBER
983: ,x_msg_data OUT NOCOPY VARCHAR2
984: ,p_offerAdjustmentId IN NUMBER
985: ,p_offerDiscountLineId IN NUMBER
986: ,p_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
987: ,p_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
988: )*/
989: merge_modifiers
990: (

Line 987: ,p_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

983: ,x_msg_data OUT NOCOPY VARCHAR2
984: ,p_offerAdjustmentId IN NUMBER
985: ,p_offerDiscountLineId IN NUMBER
986: ,p_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
987: ,p_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
988: )*/
989: merge_modifiers
990: (
991: px_to_modifier_line_tbl => x_modifier_line_tbl

Line 1053: p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type

1049: END relate_lines;
1050:
1051: PROCEDURE relate_lines
1052: (
1053: p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type
1054: , p_offer_adjustment_id IN NUMBER
1055: , x_return_status OUT NOCOPY VARCHAR2
1056: , x_msg_count OUT NOCOPY NUMBER
1057: , x_msg_data OUT NOCOPY VARCHAR2

Line 1104: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1100: ,x_msg_data OUT NOCOPY VARCHAR2
1101: ,p_offerAdjustmentId IN NUMBER
1102: )
1103: IS
1104: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1105: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1106: BEGIN
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108: /*

Line 1105: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1101: ,p_offerAdjustmentId IN NUMBER
1102: )
1103: IS
1104: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1105: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1106: BEGIN
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108: /*
1109: Corresponding to the discount changes, update the tier definitions.

Line 1301: , x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

1297:
1298: PROCEDURE populate_advanced_options
1299: (
1300: p_listHeaderId IN NUMBER
1301: , x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
1302: )
1303: IS
1304: CURSOR c_advOptions(cp_listHeaderId NUMBER)
1305: IS

Line 1336: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

1332: This produre populates and returns a qp_modifier_rec given the offerDiscountLineId
1333: */
1334: PROCEDURE populate_discounts
1335: (
1336: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
1337: , p_offerDiscountLineId IN NUMBER
1338: )
1339: IS
1340: -- list header id

Line 1404: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1400: x_return_status OUT NOCOPY VARCHAR2
1401: , x_msg_count OUT NOCOPY NUMBER
1402: , x_msg_data OUT NOCOPY VARCHAR2
1403: , p_offerDiscountLineId IN NUMBER
1404: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1405: )
1406: IS
1407: BEGIN
1408: --dbms_output.put_line('IN populate pbh line');

Line 1429: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

1425: x_return_status OUT NOCOPY VARCHAR2
1426: , x_msg_count OUT NOCOPY NUMBER
1427: , x_msg_data OUT NOCOPY VARCHAR2
1428: , p_offerDiscountLineId IN NUMBER
1429: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type
1430: , p_index IN NUMBER
1431: )
1432: IS
1433: CURSOR c_pricingAttr(cp_offerDiscountLineId NUMBER) IS

Line 1488: , x_modifier_line_rec IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Rec_Type

1484: , x_msg_count OUT NOCOPY NUMBER
1485: , x_msg_data OUT NOCOPY VARCHAR2
1486: , p_offDiscountProductId IN NUMBER
1487: , p_offerDiscountLineId IN NUMBER
1488: , x_modifier_line_rec IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Rec_Type
1489: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type
1490: )
1491: IS
1492: BEGIN

Line 1489: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

1485: , x_msg_data OUT NOCOPY VARCHAR2
1486: , p_offDiscountProductId IN NUMBER
1487: , p_offerDiscountLineId IN NUMBER
1488: , x_modifier_line_rec IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Rec_Type
1489: , x_pricing_attr_rec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type
1490: )
1491: IS
1492: BEGIN
1493: populate_discounts

Line 1525: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1521: , x_msg_count OUT NOCOPY NUMBER
1522: , x_msg_data OUT NOCOPY VARCHAR2
1523: , p_offerDiscountLineId IN NUMBER
1524: , p_offDiscountProductId IN NUMBER
1525: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1526: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_rec_type
1527: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1528: )
1529: IS

Line 1526: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_rec_type

1522: , x_msg_data OUT NOCOPY VARCHAR2
1523: , p_offerDiscountLineId IN NUMBER
1524: , p_offDiscountProductId IN NUMBER
1525: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1526: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_rec_type
1527: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1528: )
1529: IS
1530: CURSOR c_discountLines(cp_parentDiscountLineId NUMBER , cp_offDiscountProductId NUMBER)

Line 1527: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type

1523: , p_offerDiscountLineId IN NUMBER
1524: , p_offDiscountProductId IN NUMBER
1525: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1526: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_rec_type
1527: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1528: )
1529: IS
1530: CURSOR c_discountLines(cp_parentDiscountLineId NUMBER , cp_offDiscountProductId NUMBER)
1531: IS

Line 1603: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1599: , x_msg_count OUT NOCOPY NUMBER
1600: , x_msg_data OUT NOCOPY VARCHAR2
1601: , p_offerDiscountLineId IN NUMBER
1602: , p_offDiscountProductId IN NUMBER
1603: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1604: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
1605: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1606: )
1607: IS

Line 1604: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type

1600: , x_msg_data OUT NOCOPY VARCHAR2
1601: , p_offerDiscountLineId IN NUMBER
1602: , p_offDiscountProductId IN NUMBER
1603: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1604: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
1605: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1606: )
1607: IS
1608: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 1605: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type

1601: , p_offerDiscountLineId IN NUMBER
1602: , p_offDiscountProductId IN NUMBER
1603: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1604: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
1605: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1606: )
1607: IS
1608: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1609: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 1608: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1604: , p_pricing_attr_rec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
1605: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1606: )
1607: IS
1608: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1609: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1610: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1611: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1612: BEGIN

Line 1609: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1605: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Tbl_type
1606: )
1607: IS
1608: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1609: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1610: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1611: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1612: BEGIN
1613: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1610: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;

1606: )
1607: IS
1608: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1609: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1610: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1611: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1612: BEGIN
1613: x_return_status := FND_API.G_RET_STS_SUCCESS;
1614: x_modifier_line_tbl.delete;

Line 1611: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;

1607: IS
1608: l_dis_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1609: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1610: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1611: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1612: BEGIN
1613: x_return_status := FND_API.G_RET_STS_SUCCESS;
1614: x_modifier_line_tbl.delete;
1615: x_pricing_attr_tbl.delete;

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

1681: Note not initializing the record to attribute_grouping_no leads to unexpected error cannot insert null into qp_pricing_attributes.attribute_grouping_no
1682: */
1683: /**
1684: This method populates product attributes ie. Product Attribute, Product Attr Value , excluder flag
1685: into a Qp_Modifiers_Pub.pricing_attr_rec_type record given the Product Id in ozf_offer_discount_products table
1686: */
1687: PROCEDURE populate_product_attributes
1688: (
1689: x_pricing_attr_rec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

Line 1689: x_pricing_attr_rec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

1685: into a Qp_Modifiers_Pub.pricing_attr_rec_type record given the Product Id in ozf_offer_discount_products table
1686: */
1687: PROCEDURE populate_product_attributes
1688: (
1689: x_pricing_attr_rec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type
1690: , p_offDiscountProductId IN NUMBER
1691: -- , p_index IN NUMBER
1692: )
1693: IS

Line 1741: , p_modifiers_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1737: */
1738: PROCEDURE map_ozf_qp_data
1739: (
1740: p_offDiscountProductId IN NUMBER
1741: , p_modifiers_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1742: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1743: , x_return_status OUT NOCOPY VARCHAR2
1744: , x_msg_count OUT NOCOPY NUMBER
1745: , x_msg_data OUT NOCOPY VARCHAR2

Line 1742: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

1738: PROCEDURE map_ozf_qp_data
1739: (
1740: p_offDiscountProductId IN NUMBER
1741: , p_modifiers_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1742: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1743: , x_return_status OUT NOCOPY VARCHAR2
1744: , x_msg_count OUT NOCOPY NUMBER
1745: , x_msg_data OUT NOCOPY VARCHAR2
1746: )

Line 1817: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

1813: */
1814: PROCEDURE map_ozf_qp_products
1815: (
1816: p_offDiscountProductId IN NUMBER
1817: , p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1818: , x_return_status OUT NOCOPY VARCHAR2
1819: , x_msg_count OUT NOCOPY NUMBER
1820: , x_msg_data OUT NOCOPY VARCHAR2
1821: )

Line 1864: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1860: , x_msg_count OUT NOCOPY NUMBER
1861: , x_msg_data OUT NOCOPY VARCHAR2
1862: )
1863: IS
1864: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1865: i NUMBER;
1866: CURSOR c_qpListLines(cp_offDiscountProductId NUMBER)
1867: IS
1868: SELECT b.list_line_id, a.product_attribute, a.product_attr_value , c.list_header_id

Line 1875: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

1871: AND b.list_line_id = c.list_line_id
1872: AND a.off_discount_product_id = p_offDiscountProductId;
1873:
1874: l_errorLoc NUMBER;
1875: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1876: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1877: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1878: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1879: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1876: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

1872: AND a.off_discount_product_id = p_offDiscountProductId;
1873:
1874: l_errorLoc NUMBER;
1875: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1876: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1877: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1878: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1879: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1880: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 1877: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1873:
1874: l_errorLoc NUMBER;
1875: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1876: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1877: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1878: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1879: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1880: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1881: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 1878: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

1874: l_errorLoc NUMBER;
1875: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1876: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1877: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1878: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1879: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1880: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1881: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1882: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1881: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1877: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1878: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1879: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1880: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1881: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1882: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1883: BEGIN
1884: -- initialize
1885: -- retrieve all the qp_list_lines corresponding to the discount structure to which the exclusion is added.

Line 1882: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

1878: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1879: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1880: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1881: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1882: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1883: BEGIN
1884: -- initialize
1885: -- retrieve all the qp_list_lines corresponding to the discount structure to which the exclusion is added.
1886: -- exclude this new product from all the qp discount structures.

Line 1902: QP_Modifiers_PUB.process_modifiers(

1898: l_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
1899: --dbms_output.put_line('Details are:'||l_qpListLines.list_line_id||':'||l_qpListLines.list_header_id||':'||i);
1900: i := i + 1;
1901: END LOOP;
1902: QP_Modifiers_PUB.process_modifiers(
1903: p_api_version_number => 1.0,
1904: p_init_msg_list => FND_API.G_TRUE,
1905: p_return_values => FND_API.G_TRUE,
1906: x_return_status => x_return_status,

Line 1951: , px_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1947: x_return_status OUT NOCOPY VARCHAR2
1948: , x_msg_count OUT NOCOPY NUMBER
1949: , x_msg_data OUT NOCOPY VARCHAR2
1950: , p_offerAdjustmentId IN NUMBER
1951: , px_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1952: )
1953: IS
1954: CURSOR c_adjDetails(cp_offerAdjustmentId NUMBER) IS
1955: SELECT

Line 1988: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

1984: x_return_status OUT NOCOPY VARCHAR2
1985: ,x_msg_count OUT NOCOPY NUMBER
1986: ,x_msg_data OUT NOCOPY VARCHAR2
1987: ,p_offerAdjustmentId IN NUMBER
1988: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1989: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1990: )
1991: IS
1992: CURSOR c_products(cp_offerAdjustmentId NUMBER) IS

Line 1989: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

1985: ,x_msg_count OUT NOCOPY NUMBER
1986: ,x_msg_data OUT NOCOPY VARCHAR2
1987: ,p_offerAdjustmentId IN NUMBER
1988: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
1989: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1990: )
1991: IS
1992: CURSOR c_products(cp_offerAdjustmentId NUMBER) IS
1993: SELECT a.off_discount_product_id

Line 2008: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

2004: WHERE offer_adjustment_id = cp_offerAdjustmentId
2005: AND product_attr_value IS NOT NULL
2006: AND excluder_flag = 'Y';
2007:
2008: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2009: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2010: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
2011: i NUMBER;
2012: l_errorLoc NUMBER;

Line 2009: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

2005: AND product_attr_value IS NOT NULL
2006: AND excluder_flag = 'Y';
2007:
2008: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2009: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2010: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
2011: i NUMBER;
2012: l_errorLoc NUMBER;
2013: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

Line 2010: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;

2006: AND excluder_flag = 'Y';
2007:
2008: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2009: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2010: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
2011: i NUMBER;
2012: l_errorLoc NUMBER;
2013: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
2014: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

Line 2013: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

2009: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2010: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
2011: i NUMBER;
2012: l_errorLoc NUMBER;
2013: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
2014: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
2015: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2016: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
2017: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 2014: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

2010: l_pricing_attr_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
2011: i NUMBER;
2012: l_errorLoc NUMBER;
2013: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
2014: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
2015: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2016: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
2017: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2018: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 2015: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

2011: i NUMBER;
2012: l_errorLoc NUMBER;
2013: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
2014: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
2015: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2016: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
2017: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2018: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
2019: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 2016: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

2012: l_errorLoc NUMBER;
2013: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
2014: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
2015: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2016: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
2017: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2018: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
2019: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2020: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 2019: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

2015: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2016: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
2017: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2018: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
2019: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2020: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
2021: BEGIN
2022: -- initialize
2023: -- query new products entered using adjustments.

Line 2020: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

2016: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
2017: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2018: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
2019: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2020: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
2021: BEGIN
2022: -- initialize
2023: -- query new products entered using adjustments.
2024: -- for each new product id get the offer_discount_line_id

Line 2077: QP_Modifiers_PUB.process_modifiers(

2073: RAISE FND_API.G_EXC_ERROR;
2074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;
2077: QP_Modifiers_PUB.process_modifiers(
2078: p_api_version_number => 1.0,
2079: p_init_msg_list => FND_API.G_TRUE,
2080: p_return_values => FND_API.G_TRUE,
2081: x_return_status => x_return_status,

Line 2143: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

2139: ,x_msg_data OUT NOCOPY VARCHAR2
2140: ,p_offerAdjustmentId IN NUMBER
2141: )
2142: IS
2143: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2144: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2145: BEGIN
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147: /*

Line 2144: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

2140: ,p_offerAdjustmentId IN NUMBER
2141: )
2142: IS
2143: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2144: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2145: BEGIN
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147: /*
2148: New Products are added to Particular discount tables, so discount table id is stored .