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_OFFER_ADJ_PVT dependencies on QP_MODIFIERS_PUB

Line 168: ,p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type

164: (
165: x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY NUMBER
167: ,x_msg_data OUT NOCOPY VARCHAR2
168: ,p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type
169: ,p_offerAdjustmentId IN NUMBER
170: )
171: IS
172: l_adj_line_rec OZF_Offer_Adj_Line_PVT.offadj_line_rec_type;

Line 234: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

230: x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_count OUT NOCOPY NUMBER
232: ,x_msg_data OUT NOCOPY VARCHAR2
233: ,p_pbhListLineId IN NUMBER
234: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
235: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
236: )
237: IS
238: CURSOR c_disLines(cp_pbhListLineId NUMBER) IS

Line 235: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

231: ,x_msg_count OUT NOCOPY NUMBER
232: ,x_msg_data OUT NOCOPY VARCHAR2
233: ,p_pbhListLineId IN NUMBER
234: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
235: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
236: )
237: IS
238: CURSOR c_disLines(cp_pbhListLineId NUMBER) IS
239: SELECT to_rltd_modifier_id

Line 244: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

240: FROM qp_rltd_modifiers
241: WHERE from_rltd_modifier_id = cp_pbhListLineId
242: ORDER BY to_rltd_modifier_id asc;
243: i NUMBER;
244: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
245:
246: BEGIN
247: -- initialize
248: -- loop thru. dis lines

Line 292: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

288: x_return_status OUT NOCOPY VARCHAR2
289: ,x_msg_count OUT NOCOPY NUMBER
290: ,x_msg_data OUT NOCOPY VARCHAR2
291: ,p_pbhListLineId IN NUMBER
292: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
294: )
295: IS
296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

289: ,x_msg_count OUT NOCOPY NUMBER
290: ,x_msg_data OUT NOCOPY VARCHAR2
291: ,p_pbhListLineId IN NUMBER
292: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
294: )
295: IS
296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
297: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

292: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
294: )
295: IS
296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
297: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
298: BEGIN
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: OZF_VOLUME_OFFER_ADJ.populate_pbh_line

Line 297: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
294: )
295: IS
296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
297: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
298: BEGIN
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: OZF_VOLUME_OFFER_ADJ.populate_pbh_line
301: (

Line 355: ,px_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

351: ,x_msg_count OUT NOCOPY NUMBER
352: ,x_msg_data OUT NOCOPY VARCHAR2
353: ,p_pbhListLineId IN NUMBER
354: , p_offerAdjustmentId IN NUMBER
355: ,px_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
356: , px_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
357: )
358: IS
359: CURSOR c_discounts(cp_offerAdjustmentId NUMBER, cp_pbhListLineId NUMBER) IS

Line 356: , px_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

352: ,x_msg_data OUT NOCOPY VARCHAR2
353: ,p_pbhListLineId IN NUMBER
354: , p_offerAdjustmentId IN NUMBER
355: ,px_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
356: , px_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
357: )
358: IS
359: CURSOR c_discounts(cp_offerAdjustmentId NUMBER, cp_pbhListLineId NUMBER) IS
360: SELECT

Line 653: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

649: , p_toListLineId IN NUMBER
650: )
651: IS
652: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
653: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
654: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
655: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
656: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
657: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 654: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

650: )
651: IS
652: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
653: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
654: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
655: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
656: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
657: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
658: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 655: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

651: IS
652: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
653: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
654: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
655: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
656: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
657: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
658: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
659: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 656: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

652: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
653: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
654: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
655: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
656: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
657: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
658: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
659: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
660: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 659: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

655: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
656: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
657: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
658: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
659: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
660: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
661: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
662: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
663: BEGIN

Line 660: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

656: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
657: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
658: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
659: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
660: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
661: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
662: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
663: BEGIN
664: --initialize

Line 661: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

657: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
658: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
659: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
660: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
661: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
662: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
663: BEGIN
664: --initialize
665: -- populate qualifiers

Line 662: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

658: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
659: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
660: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
661: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
662: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
663: BEGIN
664: --initialize
665: -- populate qualifiers
666: -- populate the new list line into the qualifiers

Line 690: QP_Modifiers_PUB.process_modifiers(

686: RAISE FND_API.G_EXC_ERROR;
687: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;
690: QP_Modifiers_PUB.process_modifiers(
691: p_api_version_number => 1.0,
692: p_init_msg_list => FND_API.G_FALSE,
693: p_return_values => FND_API.G_FALSE,
694: x_return_status => x_return_status,

Line 724: ,p_modifier_line_tbl IN qp_modifiers_pub.modifiers_tbl_type

720: (
721: x_return_status OUT NOCOPY VARCHAR2
722: ,x_msg_count OUT NOCOPY NUMBER
723: ,x_msg_data OUT NOCOPY VARCHAR2
724: ,p_modifier_line_tbl IN qp_modifiers_pub.modifiers_tbl_type
725: )
726: IS
727: BEGIN
728: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 758: ,p_modifier_line_tbl IN qp_modifiers_pub.modifiers_tbl_type

754: (
755: x_return_status OUT NOCOPY VARCHAR2
756: , x_msg_count OUT NOCOPY NUMBER
757: , x_msg_data OUT NOCOPY VARCHAR2
758: ,p_modifier_line_tbl IN qp_modifiers_pub.modifiers_tbl_type
759: )
760: IS
761: BEGIN
762: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 793: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

789: ,x_msg_count OUT NOCOPY NUMBER
790: ,x_msg_data OUT NOCOPY VARCHAR2
791: ,p_pbhListLineId IN NUMBER
792: ,p_offerAdjustmentId IN NUMBER
793: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
794: )
795: IS
796:
797: l_pbhLineId NUMBER;

Line 798: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

794: )
795: IS
796:
797: l_pbhLineId NUMBER;
798: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
799: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
800:
801: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
802: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

Line 799: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

795: IS
796:
797: l_pbhLineId NUMBER;
798: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
799: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
800:
801: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
802: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
803: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 801: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

797: l_pbhLineId NUMBER;
798: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
799: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
800:
801: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
802: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
803: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
804: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
805: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 802: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

798: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
799: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
800:
801: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
802: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
803: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
804: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
805: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
806: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 803: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

799: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
800:
801: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
802: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
803: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
804: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
805: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
806: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
807: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 804: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

800:
801: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
802: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
803: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
804: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
805: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
806: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
807: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
808: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 807: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

803: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
804: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
805: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
806: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
807: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
808: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
809: BEGIN
810: -- initialise
811: -- populate lines

Line 808: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

804: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
805: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
806: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
807: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
808: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
809: BEGIN
810: -- initialise
811: -- populate lines
812: -- copy list line

Line 847: QP_Modifiers_PUB.process_modifiers(

843: RAISE FND_API.G_EXC_ERROR;
844: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847: QP_Modifiers_PUB.process_modifiers(
848: p_api_version_number => 1.0,
849: p_init_msg_list => FND_API.G_FALSE,
850: p_return_values => FND_API.G_FALSE,
851: x_return_status => x_return_status,

Line 906: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

902: ,p_offerAdjustmentId IN NUMBER
903: )
904: IS
905: l_phbLineId NUMBER;
906: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
907: CURSOR c_pbhLines(cp_offerAdjustmentId NUMBER) IS
908: SELECT distinct b.from_rltd_modifier_id
909: FROM ozf_offer_adjustment_lines a, qp_rltd_modifiers b
910: WHERE a.list_line_id = b.to_rltd_modifier_id

Line 985: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

981: x_return_status OUT NOCOPY VARCHAR2
982: , x_msg_count OUT NOCOPY NUMBER
983: , x_msg_data OUT NOCOPY VARCHAR2
984: , p_listLineId IN NUMBER
985: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
986: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
987: )
988: IS
989: CURSOR c_listLineDetails(cp_listLineId NUMBER) IS

Line 986: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

982: , x_msg_count OUT NOCOPY NUMBER
983: , x_msg_data OUT NOCOPY VARCHAR2
984: , p_listLineId IN NUMBER
985: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
986: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
987: )
988: IS
989: CURSOR c_listLineDetails(cp_listLineId NUMBER) IS
990: SELECT

Line 995: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

991: list_line_id
992: FROM qp_list_lines
993: WHERE list_line_id = cp_listLineId;
994: i NUMBER;
995: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
996: BEGIN
997: -- initialize
998: -- loop thru. list Lines
999: -- populate list_lines progressively

Line 1054: ,x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1050: (
1051: x_return_status OUT NOCOPY VARCHAR2
1052: ,x_msg_count OUT NOCOPY NUMBER
1053: ,x_msg_data OUT NOCOPY VARCHAR2
1054: ,x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1055: ,p_offerAdjustmentId IN NUMBER
1056: ,p_offerAdjustmentLineId IN NUMBER
1057: )
1058: IS

Line 1079: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1075: x_return_status OUT NOCOPY VARCHAR2
1076: ,x_msg_count OUT NOCOPY NUMBER
1077: ,x_msg_data OUT NOCOPY VARCHAR2
1078: ,p_listLineId IN NUMBER
1079: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1080: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1081: , x_listLineId OUT NOCOPY NUMBER
1082: , p_offerAdjustmentLineId IN NUMBER
1083: , p_offerAdjustmentId IN NUMBER

Line 1080: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

1076: ,x_msg_count OUT NOCOPY NUMBER
1077: ,x_msg_data OUT NOCOPY VARCHAR2
1078: ,p_listLineId IN NUMBER
1079: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1080: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1081: , x_listLineId OUT NOCOPY NUMBER
1082: , p_offerAdjustmentLineId IN NUMBER
1083: , p_offerAdjustmentId IN NUMBER
1084: )

Line 1086: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

1082: , p_offerAdjustmentLineId IN NUMBER
1083: , p_offerAdjustmentId IN NUMBER
1084: )
1085: IS
1086: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1087: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1088: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1089: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1090: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1087: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

1083: , p_offerAdjustmentId IN NUMBER
1084: )
1085: IS
1086: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1087: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1088: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1089: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1090: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1091: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 1088: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1084: )
1085: IS
1086: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1087: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1088: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1089: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1090: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1091: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1092: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 1089: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

1085: IS
1086: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1087: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1088: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1089: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1090: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1091: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1092: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1093: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1092: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1088: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1089: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1090: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1091: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1092: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1093: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1094: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1095: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1096: BEGIN

Line 1093: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

1089: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1090: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1091: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1092: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1093: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1094: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1095: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1096: BEGIN
1097: -- initialize

Line 1094: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1090: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1091: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1092: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1093: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1094: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1095: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1096: BEGIN
1097: -- initialize
1098: -- populate data from qp_list_line

Line 1095: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1091: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1092: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1093: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1094: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1095: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1096: BEGIN
1097: -- initialize
1098: -- populate data from qp_list_line
1099: -- populate adjustments data

Line 1135: QP_Modifiers_PUB.process_modifiers(

1131: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1133: END IF;
1134:
1135: QP_Modifiers_PUB.process_modifiers(
1136: p_api_version_number => 1.0,
1137: p_init_msg_list => FND_API.G_FALSE,
1138: p_return_values => FND_API.G_FALSE,
1139: x_return_status => x_return_status,

Line 1177: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1173: ,x_msg_data OUT NOCOPY VARCHAR2
1174: ,p_offer_type IN VARCHAR2
1175: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
1176: ,p_list_header_id IN NUMBER
1177: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1178: ,x_error_location OUT NOCOPY NUMBER
1179: );
1180: */
1181: END create_dis_line;

Line 1201: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

1197: , p_offerAdjustmentLineId IN NUMBER
1198: , p_offerAdjustmentId IN NUMBER
1199: )
1200: IS
1201: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
1202: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1203: BEGIN
1204: -- initialise
1205: -- create Discount lines and pricing attributes(including exclusions)

Line 1202: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1198: , p_offerAdjustmentId IN NUMBER
1199: )
1200: IS
1201: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
1202: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1203: BEGIN
1204: -- initialise
1205: -- create Discount lines and pricing attributes(including exclusions)
1206: -- create qualifiers

Line 1436: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

1432: x_return_status OUT NOCOPY VARCHAR2
1433: ,x_msg_count OUT NOCOPY NUMBER
1434: ,x_msg_data OUT NOCOPY VARCHAR2
1435: , p_listLineId IN NUMBER
1436: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1437: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1438: )
1439: IS
1440: /**

Line 1437: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1433: ,x_msg_count OUT NOCOPY NUMBER
1434: ,x_msg_data OUT NOCOPY VARCHAR2
1435: , p_listLineId IN NUMBER
1436: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1437: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1438: )
1439: IS
1440: /**
1441: This cursor probably may have issues and we may have to join qp_list_lines and put a filter on list_line_type_code = PRG

Line 1486: , x_pricing_attr_tbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

1482: ,x_msg_count OUT NOCOPY NUMBER
1483: ,x_msg_data OUT NOCOPY VARCHAR2
1484: , p_offerAdjustmentLineId IN NUMBER
1485: , p_offerAdjustmentId IN NUMBER
1486: , x_pricing_attr_tbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1487: , x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1488: )
1489: IS
1490: BEGIN

Line 1487: , x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1483: ,x_msg_data OUT NOCOPY VARCHAR2
1484: , p_offerAdjustmentLineId IN NUMBER
1485: , p_offerAdjustmentId IN NUMBER
1486: , x_pricing_attr_tbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1487: , x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1488: )
1489: IS
1490: BEGIN
1491: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1509: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

1505: , p_listLineId IN NUMBER
1506: , x_listLineId OUT NOCOPY NUMBER
1507: , p_offerAdjustmentLineId IN NUMBER
1508: , p_offerAdjustmentId IN NUMBER
1509: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1510: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1511: )
1512: IS
1513: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

Line 1510: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1506: , x_listLineId OUT NOCOPY NUMBER
1507: , p_offerAdjustmentLineId IN NUMBER
1508: , p_offerAdjustmentId IN NUMBER
1509: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1510: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1511: )
1512: IS
1513: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1514: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

Line 1513: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

1509: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1510: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1511: )
1512: IS
1513: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1514: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1515: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1516: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1517: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1514: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

1510: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1511: )
1512: IS
1513: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1514: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1515: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1516: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1517: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1518: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 1515: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1511: )
1512: IS
1513: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1514: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1515: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1516: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1517: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1518: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1519: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 1516: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

1512: IS
1513: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1514: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1515: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1516: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1517: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1518: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1519: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1520: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1519: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1515: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1516: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1517: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1518: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1519: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1520: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1521: BEGIN
1522: -- initialize
1523: -- populate modifiers table and pricing attribute table

Line 1520: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

1516: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1517: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1518: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1519: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1520: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1521: BEGIN
1522: -- initialize
1523: -- populate modifiers table and pricing attribute table
1524: -- process modifiers table and pricing attribute table

Line 1560: QP_Modifiers_PUB.process_modifiers(

1556: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1558: END IF;
1559:
1560: QP_Modifiers_PUB.process_modifiers(
1561: p_api_version_number => 1.0,
1562: p_init_msg_list => FND_API.G_TRUE,
1563: p_return_values => FND_API.G_FALSE,
1564: x_return_status => x_return_status,

Line 1606: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

1602: , p_offerAdjustmentLineId IN NUMBER
1603: ,p_offerAdjustmentId IN NUMBER
1604: )
1605: IS
1606: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
1607: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1608: BEGIN
1609: -- initialise
1610: -- create Discount lines and pricing attributes(including exclusions)

Line 1607: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1603: ,p_offerAdjustmentId IN NUMBER
1604: )
1605: IS
1606: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
1607: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1608: BEGIN
1609: -- initialise
1610: -- create Discount lines and pricing attributes(including exclusions)
1611: -- create qualifiers

Line 1945: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

1941: ,x_msg_count OUT NOCOPY NUMBER
1942: ,x_msg_data OUT NOCOPY VARCHAR2
1943: ,p_offerAdjustmentId IN NUMBER
1944: , p_listLineId IN NUMBER
1945: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
1946: )
1947:
1948: IS
1949: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

Line 1950: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

1946: )
1947:
1948: IS
1949: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
1950: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
1951: l_errorLocation NUMBER;
1952: BEGIN
1953: -- initialize
1954: -- populate td lines

Line 2000: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type

1996: ,x_msg_data => x_msg_data
1997: ,p_offer_type => 'DEAL'
1998: ,p_modifier_line_tbl => l_modifier_line_tbl
1999: ,p_list_header_id => l_modifier_line_tbl(1).list_header_id
2000: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type
2001: ,x_error_location => l_errorLocation
2002: );
2003: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2004: RAISE FND_API.G_EXC_ERROR;

Line 2159: , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type

2155: x_return_status OUT NOCOPY VARCHAR2
2156: , x_msg_count OUT NOCOPY NUMBER
2157: , x_msg_data OUT NOCOPY VARCHAR2
2158: ,p_listLineId IN NUMBER
2159: , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
2160: )
2161: IS
2162: BEGIN
2163: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2196: , x_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type

2192: x_return_status OUT NOCOPY VARCHAR2
2193: ,x_msg_count OUT NOCOPY NUMBER
2194: ,x_msg_data OUT NOCOPY VARCHAR2
2195: , p_listLineId IN NUMBER
2196: , x_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
2197: )
2198: IS
2199: BEGIN
2200: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2236: , x_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type

2232: x_return_status OUT NOCOPY VARCHAR2
2233: ,x_msg_count OUT NOCOPY NUMBER
2234: ,x_msg_data OUT NOCOPY VARCHAR2
2235: , p_listLineId IN NUMBER
2236: , x_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
2237: )
2238: IS
2239: BEGIN
2240: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2295: , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type

2291: ,x_msg_count OUT NOCOPY NUMBER
2292: ,x_msg_data OUT NOCOPY VARCHAR2
2293: ,p_offerAdjustmentId IN NUMBER
2294: , p_listLineId IN NUMBER
2295: , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
2296: )
2297: IS
2298: CURSOR c_accrualFlag(cp_listLineId NUMBER)
2299: IS

Line 2361: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

2357: ,x_msg_data OUT NOCOPY VARCHAR2
2358: ,p_offerAdjustmentId IN NUMBER
2359: , p_listLineId IN NUMBER
2360: , x_listLineId IN NUMBER
2361: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
2362: )
2363: IS
2364: BEGIN
2365: -- initialize

Line 2439: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

2435: , p_listLineId IN NUMBER
2436: )
2437: IS
2438: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2439: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2440: l_errorLocation NUMBER;
2441: BEGIN
2442: -- initialize
2443: -- populate end date lines

Line 2488: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type

2484: ,x_msg_data => x_msg_data
2485: ,p_offer_type => 'DEAL'
2486: ,p_modifier_line_tbl => l_modifier_line_tbl
2487: ,p_list_header_id => l_modifier_line_tbl(1).list_header_id
2488: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type
2489: ,x_error_location => l_errorLocation
2490: );
2491: ozf_utility_pvt.debug_message('after process_qp_list_lines :'||x_return_status);
2492: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2517: l_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

2513: ,p_offerAdjustmentId IN NUMBER
2514: , p_listLineId IN NUMBER
2515: )
2516: IS
2517: l_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2518: l_listLineId number;
2519: BEGIN
2520: x_return_status := FND_API.G_RET_STS_SUCCESS;
2521: ozf_utility_pvt.debug_message('before endDateTdLine :'||x_return_status);

Line 2773: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

2769: x_return_status OUT NOCOPY VARCHAR2
2770: ,x_msg_count OUT NOCOPY NUMBER
2771: ,x_msg_data OUT NOCOPY VARCHAR2
2772: ,p_offerAdjNewLineId IN NUMBER
2773: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
2774: )
2775: IS
2776: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2777: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

Line 2777: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

2773: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
2774: )
2775: IS
2776: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2777: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2778: l_errorLocation NUMBER;
2779: BEGIN
2780: -- initilize
2781: -- populate data

Line 2850: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

2846: ,x_msg_data OUT NOCOPY VARCHAR2
2847: ,p_offerAdjNewLineId IN NUMBER
2848: )
2849: IS
2850: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2851: BEGIN
2852: -- initialize
2853: -- create new line
2854: -- create line in ozf_offer_adjustment_lines

Line 3002: ,x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

2998: x_return_status OUT NOCOPY VARCHAR2
2999: ,x_msg_count OUT NOCOPY NUMBER
3000: ,x_msg_data OUT NOCOPY VARCHAR2
3001: ,p_offerAdjNewLineId IN NUMBER
3002: ,x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3003: )
3004: IS
3005: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3006: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

Line 3006: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

3002: ,x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3003: )
3004: IS
3005: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3006: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3007: l_errorLocation NUMBER;
3008: BEGIN
3009: -- initialize
3010: -- populate data in qp structures

Line 3070: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

3066: ,x_msg_data OUT NOCOPY VARCHAR2
3067: ,p_offerAdjNewLineId IN NUMBER
3068: )
3069: IS
3070: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3071: BEGIN
3072: -- initialize
3073: -- create new get product
3074: -- create offer_adjustment_line

Line 3287: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

3283: ,p_offerAdjNewLineId IN NUMBER
3284: )
3285: IS
3286: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
3287: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
3288: l_errorLocation NUMBER;
3289: BEGIN
3290: -- initialize
3291: -- populate discounts

Line 3361: , px_modifier_line_rec IN OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

3357: x_return_status OUT NOCOPY VARCHAR2
3358: ,x_msg_count OUT NOCOPY NUMBER
3359: ,x_msg_data OUT NOCOPY VARCHAR2
3360: ,p_listHeaderId IN NUMBER
3361: , px_modifier_line_rec IN OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3362: )
3363: IS
3364: CURSOR c_advOpt(cp_listHeaderId NUMBER) IS
3365: SELECT

Line 3393: , px_modifier_line_rec IN OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

3389: x_return_status OUT NOCOPY VARCHAR2
3390: ,x_msg_count OUT NOCOPY NUMBER
3391: ,x_msg_data OUT NOCOPY VARCHAR2
3392: ,p_offerAdjNewLineId IN NUMBER
3393: , px_modifier_line_rec IN OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3394: )
3395: IS
3396: CURSOR c_offerDetails(cp_offerAdjNewLineId NUMBER) IS
3397: SELECT

Line 3444: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

3440: x_return_status OUT NOCOPY VARCHAR2
3441: ,x_msg_count OUT NOCOPY NUMBER
3442: ,x_msg_data OUT NOCOPY VARCHAR2
3443: ,p_offerAdjNewLineId IN NUMBER
3444: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3445: , p_index IN NUMBER
3446: )
3447: IS
3448: CURSOR c_productAttributes(cp_offerAdjNewLineId NUMBER) IS

Line 3486: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

3482: x_return_status OUT NOCOPY VARCHAR2
3483: ,x_msg_count OUT NOCOPY NUMBER
3484: ,x_msg_data OUT NOCOPY VARCHAR2
3485: ,p_offerAdjNewLineId IN NUMBER
3486: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3487: )
3488: IS
3489: CURSOR c_pbhData (cp_offerAdjNewLineId NUMBER) IS
3490: SELECT

Line 3540: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

3536: x_return_status OUT NOCOPY VARCHAR2
3537: ,x_msg_count OUT NOCOPY NUMBER
3538: ,x_msg_data OUT NOCOPY VARCHAR2
3539: ,p_offerAdjNewLineId IN NUMBER
3540: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3541: )
3542: IS
3543: BEGIN
3544: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3556: ,x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

3552: x_return_status OUT NOCOPY VARCHAR2
3553: ,x_msg_count OUT NOCOPY NUMBER
3554: ,x_msg_data OUT NOCOPY VARCHAR2
3555: ,p_offerAdjNewLineId IN NUMBER
3556: ,x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3557: )
3558: IS
3559: CURSOR c_discounts(cp_offerAdjNewLineId NUMBER) IS
3560: SELECT

Line 3603: , x_pricing_attr_rec OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type

3599: x_return_status OUT NOCOPY VARCHAR2
3600: ,x_msg_count OUT NOCOPY NUMBER
3601: ,x_msg_data OUT NOCOPY VARCHAR2
3602: ,p_offerAdjNewLineId IN NUMBER
3603: , x_pricing_attr_rec OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type
3604: , p_index IN NUMBER
3605: )
3606: IS
3607: CURSOR c_pricingAttributes(cp_offerAdjNewLineId NUMBER) IS

Line 3649: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

3645: x_return_status OUT NOCOPY VARCHAR2
3646: ,x_msg_count OUT NOCOPY NUMBER
3647: ,x_msg_data OUT NOCOPY VARCHAR2
3648: ,p_offerAdjNewLineId IN NUMBER
3649: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
3650: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3651: )
3652: IS
3653: CURSOR c_adjNewLines(cp_offerAdjNewLineId NUMBER) IS

Line 3650: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

3646: ,x_msg_count OUT NOCOPY NUMBER
3647: ,x_msg_data OUT NOCOPY VARCHAR2
3648: ,p_offerAdjNewLineId IN NUMBER
3649: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
3650: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3651: )
3652: IS
3653: CURSOR c_adjNewLines(cp_offerAdjNewLineId NUMBER) IS
3654: SELECT offer_adj_new_line_id

Line 3704: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

3700: x_return_status OUT NOCOPY VARCHAR2
3701: ,x_msg_count OUT NOCOPY NUMBER
3702: ,x_msg_data OUT NOCOPY VARCHAR2
3703: ,p_offerAdjNewLineId IN NUMBER
3704: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3705: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3706: )
3707: IS
3708: i NUMBER;

Line 3705: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

3701: ,x_msg_count OUT NOCOPY NUMBER
3702: ,x_msg_data OUT NOCOPY VARCHAR2
3703: ,p_offerAdjNewLineId IN NUMBER
3704: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3705: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3706: )
3707: IS
3708: i NUMBER;
3709: BEGIN

Line 3746: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

3742: x_return_status OUT NOCOPY VARCHAR2
3743: ,x_msg_count OUT NOCOPY NUMBER
3744: ,x_msg_data OUT NOCOPY VARCHAR2
3745: ,p_offerAdjNewLineId IN NUMBER
3746: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
3747: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3748: )
3749: IS
3750: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 3747: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

3743: ,x_msg_count OUT NOCOPY NUMBER
3744: ,x_msg_data OUT NOCOPY VARCHAR2
3745: ,p_offerAdjNewLineId IN NUMBER
3746: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
3747: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3748: )
3749: IS
3750: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3751: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 3750: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

3746: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
3747: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3748: )
3749: IS
3750: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3751: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3752: BEGIN
3753: x_return_status := FND_API.G_RET_STS_SUCCESS;
3754: x_modifier_line_tbl.delete;

Line 3751: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

3747: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3748: )
3749: IS
3750: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3751: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3752: BEGIN
3753: x_return_status := FND_API.G_RET_STS_SUCCESS;
3754: x_modifier_line_tbl.delete;
3755: x_pricing_attr_tbl.delete;

Line 3816: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

3812: x_return_status OUT NOCOPY VARCHAR2
3813: ,x_msg_count OUT NOCOPY NUMBER
3814: ,x_msg_data OUT NOCOPY VARCHAR2
3815: , p_offerAdjNewLineId IN NUMBER
3816: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
3817: )
3818: IS
3819: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3820: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 3819: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

3815: , p_offerAdjNewLineId IN NUMBER
3816: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
3817: )
3818: IS
3819: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3820: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3821: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
3822: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
3823: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 3820: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

3816: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
3817: )
3818: IS
3819: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3820: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3821: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
3822: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
3823: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
3824: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

Line 3821: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

3817: )
3818: IS
3819: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3820: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3821: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
3822: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
3823: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
3824: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
3825: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 3822: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

3818: IS
3819: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3820: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3821: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
3822: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
3823: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
3824: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
3825: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
3826: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 3823: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

3819: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3820: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3821: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
3822: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
3823: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
3824: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
3825: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
3826: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
3827: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 3824: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

3820: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3821: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
3822: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
3823: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
3824: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
3825: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
3826: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
3827: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3828: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 3827: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

3823: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
3824: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
3825: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
3826: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
3827: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3828: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
3829: BEGIN
3830: -- initialize
3831: -- populate records

Line 3828: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

3824: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
3825: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
3826: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
3827: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
3828: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
3829: BEGIN
3830: -- initialize
3831: -- populate records
3832: -- process data

Line 3854: QP_Modifiers_PUB.process_modifiers(

3850: RAISE FND_API.G_EXC_ERROR;
3851: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3853: END IF;
3854: QP_Modifiers_PUB.process_modifiers(
3855: p_api_version_number => 1.0,
3856: p_init_msg_list => FND_API.G_FALSE,
3857: p_return_values => FND_API.G_FALSE,
3858: x_return_status => x_return_status,

Line 3899: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

3895: ,x_msg_data OUT NOCOPY VARCHAR2
3896: ,p_offerAdjNewLineId IN NUMBER
3897: )
3898: IS
3899: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3900: BEGIN
3901: -- initialize
3902: -- create a product qp data
3903: -- back create ozf_offer_adjustment_lines