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 170: ,p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type

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

Line 236: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

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

Line 237: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 246: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

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

Line 294: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

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

Line 295: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 298: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

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

Line 299: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

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

Line 357: ,px_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

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

Line 358: , px_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 655: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

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

Line 656: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

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

Line 657: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

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

Line 658: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

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

Line 661: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

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

Line 662: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

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

Line 663: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

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

Line 664: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

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

Line 692: QP_Modifiers_PUB.process_modifiers(

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

Line 726: ,p_modifier_line_tbl IN qp_modifiers_pub.modifiers_tbl_type

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

Line 760: ,p_modifier_line_tbl IN qp_modifiers_pub.modifiers_tbl_type

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

Line 795: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

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

Line 800: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

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

Line 801: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

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

Line 803: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

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

Line 804: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

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

Line 805: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

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

Line 806: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

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

Line 809: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

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

Line 810: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

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

Line 849: QP_Modifiers_PUB.process_modifiers(

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

Line 908: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

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

Line 987: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

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

Line 988: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 997: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

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

Line 1056: ,x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

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

Line 1095: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1091: x_return_status OUT NOCOPY VARCHAR2
1092: ,x_msg_count OUT NOCOPY NUMBER
1093: ,x_msg_data OUT NOCOPY VARCHAR2
1094: ,p_listLineId IN NUMBER
1095: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1096: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1097: , x_listLineId OUT NOCOPY NUMBER
1098: , p_offerAdjustmentLineId IN NUMBER
1099: , p_offerAdjustmentId IN NUMBER

Line 1096: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

1092: ,x_msg_count OUT NOCOPY NUMBER
1093: ,x_msg_data OUT NOCOPY VARCHAR2
1094: ,p_listLineId IN NUMBER
1095: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1096: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
1097: , x_listLineId OUT NOCOPY NUMBER
1098: , p_offerAdjustmentLineId IN NUMBER
1099: , p_offerAdjustmentId IN NUMBER
1100: )

Line 1102: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

1098: , p_offerAdjustmentLineId IN NUMBER
1099: , p_offerAdjustmentId IN NUMBER
1100: )
1101: IS
1102: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1103: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1104: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1105: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1106: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1103: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

1099: , p_offerAdjustmentId IN NUMBER
1100: )
1101: IS
1102: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1103: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1104: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1105: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1106: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1107: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 1104: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1100: )
1101: IS
1102: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1103: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1104: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1105: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1106: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1107: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1108: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 1105: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

1101: IS
1102: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1103: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1104: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1105: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1106: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1107: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1108: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1109: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1108: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1104: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1105: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1106: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1107: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1108: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1109: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1110: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1111: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1112:

Line 1109: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

1105: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1106: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1107: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1108: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1109: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1110: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1111: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1112:
1113: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;

Line 1110: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1106: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1107: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1108: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1109: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1110: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1111: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1112:
1113: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
1114: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;

Line 1111: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1107: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1108: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1109: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1110: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1111: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1112:
1113: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
1114: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
1115: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;

Line 1366: QP_Modifiers_PUB.process_modifiers(

1362: END IF;
1363: END IF;
1364: END IF;
1365:
1366: QP_Modifiers_PUB.process_modifiers(
1367: p_api_version_number => 1.0,
1368: p_init_msg_list => FND_API.G_FALSE,
1369: p_return_values => FND_API.G_FALSE,
1370: x_return_status => x_return_status,

Line 1411: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1407: ,x_msg_data OUT NOCOPY VARCHAR2
1408: ,p_offer_type IN VARCHAR2
1409: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
1410: ,p_list_header_id IN NUMBER
1411: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1412: ,x_error_location OUT NOCOPY NUMBER
1413: );
1414: */
1415: END create_dis_line;

Line 1435: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

1431: , p_offerAdjustmentLineId IN NUMBER
1432: , p_offerAdjustmentId IN NUMBER
1433: )
1434: IS
1435: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
1436: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1437: BEGIN
1438: -- initialise
1439: -- create Discount lines and pricing attributes(including exclusions)

Line 1436: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1432: , p_offerAdjustmentId IN NUMBER
1433: )
1434: IS
1435: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
1436: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1437: BEGIN
1438: -- initialise
1439: -- create Discount lines and pricing attributes(including exclusions)
1440: -- create qualifiers

Line 1687: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

1683: x_return_status OUT NOCOPY VARCHAR2
1684: ,x_msg_count OUT NOCOPY NUMBER
1685: ,x_msg_data OUT NOCOPY VARCHAR2
1686: , p_listLineId IN NUMBER
1687: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1688: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1689: )
1690: IS
1691: /**

Line 1688: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1684: ,x_msg_count OUT NOCOPY NUMBER
1685: ,x_msg_data OUT NOCOPY VARCHAR2
1686: , p_listLineId IN NUMBER
1687: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1688: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1689: )
1690: IS
1691: /**
1692: 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 1737: , x_pricing_attr_tbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

1733: ,x_msg_count OUT NOCOPY NUMBER
1734: ,x_msg_data OUT NOCOPY VARCHAR2
1735: , p_offerAdjustmentLineId IN NUMBER
1736: , p_offerAdjustmentId IN NUMBER
1737: , x_pricing_attr_tbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1738: , x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1739: )
1740: IS
1741: BEGIN

Line 1738: , x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1734: ,x_msg_data OUT NOCOPY VARCHAR2
1735: , p_offerAdjustmentLineId IN NUMBER
1736: , p_offerAdjustmentId IN NUMBER
1737: , x_pricing_attr_tbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1738: , x_modifier_line_tbl IN OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1739: )
1740: IS
1741: BEGIN
1742: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1760: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

1756: , p_listLineId IN NUMBER
1757: , x_listLineId OUT NOCOPY NUMBER
1758: , p_offerAdjustmentLineId IN NUMBER
1759: , p_offerAdjustmentId IN NUMBER
1760: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1761: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1762: )
1763: IS
1764: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

Line 1761: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

1757: , x_listLineId OUT NOCOPY NUMBER
1758: , p_offerAdjustmentLineId IN NUMBER
1759: , p_offerAdjustmentId IN NUMBER
1760: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1761: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1762: )
1763: IS
1764: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1765: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

Line 1764: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

1760: , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
1761: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1762: )
1763: IS
1764: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1765: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1766: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1767: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1768: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1765: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

1761: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1762: )
1763: IS
1764: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1765: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1766: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1767: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1768: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1769: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 1766: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

1762: )
1763: IS
1764: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1765: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1766: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1767: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1768: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1769: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1770: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 1767: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

1763: IS
1764: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
1765: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
1766: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1767: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1768: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1769: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1770: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1771: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1770: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1766: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1767: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1768: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1769: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1770: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1771: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1772: BEGIN
1773: -- initialize
1774: -- populate modifiers table and pricing attribute table

Line 1771: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

1767: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
1768: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1769: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1770: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1771: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1772: BEGIN
1773: -- initialize
1774: -- populate modifiers table and pricing attribute table
1775: -- process modifiers table and pricing attribute table

Line 1811: QP_Modifiers_PUB.process_modifiers(

1807: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: END IF;
1810:
1811: QP_Modifiers_PUB.process_modifiers(
1812: p_api_version_number => 1.0,
1813: p_init_msg_list => FND_API.G_TRUE,
1814: p_return_values => FND_API.G_FALSE,
1815: x_return_status => x_return_status,

Line 1857: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

1853: , p_offerAdjustmentLineId IN NUMBER
1854: ,p_offerAdjustmentId IN NUMBER
1855: )
1856: IS
1857: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
1858: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1859: BEGIN
1860: -- initialise
1861: -- create Discount lines and pricing attributes(including exclusions)

Line 1858: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

1854: ,p_offerAdjustmentId IN NUMBER
1855: )
1856: IS
1857: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
1858: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1859: BEGIN
1860: -- initialise
1861: -- create Discount lines and pricing attributes(including exclusions)
1862: -- create qualifiers

Line 2229: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

2225: ,x_msg_count OUT NOCOPY NUMBER
2226: ,x_msg_data OUT NOCOPY VARCHAR2
2227: ,p_offerAdjustmentId IN NUMBER
2228: , p_listLineId IN NUMBER
2229: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
2230: )
2231:
2232: IS
2233: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

Line 2234: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

2230: )
2231:
2232: IS
2233: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2234: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2235: l_errorLocation NUMBER;
2236: BEGIN
2237: -- initialize
2238: -- populate td lines

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

2280: ,x_msg_data => x_msg_data
2281: ,p_offer_type => 'DEAL'
2282: ,p_modifier_line_tbl => l_modifier_line_tbl
2283: ,p_list_header_id => l_modifier_line_tbl(1).list_header_id
2284: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type
2285: ,x_error_location => l_errorLocation
2286: );
2287: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.G_EXC_ERROR;

Line 2443: , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type

2439: x_return_status OUT NOCOPY VARCHAR2
2440: , x_msg_count OUT NOCOPY NUMBER
2441: , x_msg_data OUT NOCOPY VARCHAR2
2442: ,p_listLineId IN NUMBER
2443: , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
2444: )
2445: IS
2446: BEGIN
2447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2480: , x_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type

2476: x_return_status OUT NOCOPY VARCHAR2
2477: ,x_msg_count OUT NOCOPY NUMBER
2478: ,x_msg_data OUT NOCOPY VARCHAR2
2479: , p_listLineId IN NUMBER
2480: , x_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
2481: )
2482: IS
2483: BEGIN
2484: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2520: , x_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type

2516: x_return_status OUT NOCOPY VARCHAR2
2517: ,x_msg_count OUT NOCOPY NUMBER
2518: ,x_msg_data OUT NOCOPY VARCHAR2
2519: , p_listLineId IN NUMBER
2520: , x_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
2521: )
2522: IS
2523: BEGIN
2524: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2579: , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type

2575: ,x_msg_count OUT NOCOPY NUMBER
2576: ,x_msg_data OUT NOCOPY VARCHAR2
2577: ,p_offerAdjustmentId IN NUMBER
2578: , p_listLineId IN NUMBER
2579: , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
2580: )
2581: IS
2582: CURSOR c_accrualFlag(cp_listLineId NUMBER)
2583: IS

Line 2645: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

2641: ,x_msg_data OUT NOCOPY VARCHAR2
2642: ,p_offerAdjustmentId IN NUMBER
2643: , p_listLineId IN NUMBER
2644: , x_listLineId IN NUMBER
2645: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
2646: )
2647: IS
2648: BEGIN
2649: -- initialize

Line 2723: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

2719: , p_listLineId IN NUMBER
2720: )
2721: IS
2722: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2723: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2724: l_errorLocation NUMBER;
2725: BEGIN
2726: -- initialize
2727: -- populate end date lines

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

2768: ,x_msg_data => x_msg_data
2769: ,p_offer_type => 'DEAL'
2770: ,p_modifier_line_tbl => l_modifier_line_tbl
2771: ,p_list_header_id => l_modifier_line_tbl(1).list_header_id
2772: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type
2773: ,x_error_location => l_errorLocation
2774: );
2775: ozf_utility_pvt.debug_message('after process_qp_list_lines :'||x_return_status);
2776: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2801: l_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

2797: ,p_offerAdjustmentId IN NUMBER
2798: , p_listLineId IN NUMBER
2799: )
2800: IS
2801: l_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2802: l_listLineId number;
2803: BEGIN
2804: x_return_status := FND_API.G_RET_STS_SUCCESS;
2805: ozf_utility_pvt.debug_message('before endDateTdLine :'||x_return_status);

Line 3057: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

3053: x_return_status OUT NOCOPY VARCHAR2
3054: ,x_msg_count OUT NOCOPY NUMBER
3055: ,x_msg_data OUT NOCOPY VARCHAR2
3056: ,p_offerAdjNewLineId IN NUMBER
3057: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3058: )
3059: IS
3060: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3061: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

Line 3061: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

3057: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3058: )
3059: IS
3060: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3061: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3062: l_errorLocation NUMBER;
3063: BEGIN
3064: -- initilize
3065: -- populate data

Line 3134: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

3130: ,x_msg_data OUT NOCOPY VARCHAR2
3131: ,p_offerAdjNewLineId IN NUMBER
3132: )
3133: IS
3134: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3135: BEGIN
3136: -- initialize
3137: -- create new line
3138: -- create line in ozf_offer_adjustment_lines

Line 3286: ,x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

3282: x_return_status OUT NOCOPY VARCHAR2
3283: ,x_msg_count OUT NOCOPY NUMBER
3284: ,x_msg_data OUT NOCOPY VARCHAR2
3285: ,p_offerAdjNewLineId IN NUMBER
3286: ,x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3287: )
3288: IS
3289: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3290: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

Line 3290: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

3286: ,x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3287: )
3288: IS
3289: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3290: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3291: l_errorLocation NUMBER;
3292: BEGIN
3293: -- initialize
3294: -- populate data in qp structures

Line 3354: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;

3350: ,x_msg_data OUT NOCOPY VARCHAR2
3351: ,p_offerAdjNewLineId IN NUMBER
3352: )
3353: IS
3354: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3355: BEGIN
3356: -- initialize
3357: -- create new get product
3358: -- create offer_adjustment_line

Line 3766: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

3762: ,p_offerAdjNewLineId IN NUMBER
3763: )
3764: IS
3765: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
3766: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
3767: l_errorLocation NUMBER;
3768: l_custom_setup_id NUMBER;
3769: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
3770: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;

Line 3907: , px_modifier_line_rec IN OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

3903: x_return_status OUT NOCOPY VARCHAR2
3904: ,x_msg_count OUT NOCOPY NUMBER
3905: ,x_msg_data OUT NOCOPY VARCHAR2
3906: ,p_listHeaderId IN NUMBER
3907: , px_modifier_line_rec IN OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3908: )
3909: IS
3910: CURSOR c_advOpt(cp_listHeaderId NUMBER) IS
3911: SELECT

Line 3939: , px_modifier_line_rec IN OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

3935: x_return_status OUT NOCOPY VARCHAR2
3936: ,x_msg_count OUT NOCOPY NUMBER
3937: ,x_msg_data OUT NOCOPY VARCHAR2
3938: ,p_offerAdjNewLineId IN NUMBER
3939: , px_modifier_line_rec IN OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
3940: )
3941: IS
3942: CURSOR c_offerDetails(cp_offerAdjNewLineId NUMBER) IS
3943: SELECT

Line 3990: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

3986: x_return_status OUT NOCOPY VARCHAR2
3987: ,x_msg_count OUT NOCOPY NUMBER
3988: ,x_msg_data OUT NOCOPY VARCHAR2
3989: ,p_offerAdjNewLineId IN NUMBER
3990: ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
3991: , p_index IN NUMBER
3992: )
3993: IS
3994: CURSOR c_productAttributes(cp_offerAdjNewLineId NUMBER) IS

Line 4032: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

4028: x_return_status OUT NOCOPY VARCHAR2
4029: ,x_msg_count OUT NOCOPY NUMBER
4030: ,x_msg_data OUT NOCOPY VARCHAR2
4031: ,p_offerAdjNewLineId IN NUMBER
4032: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
4033: )
4034: IS
4035: CURSOR c_pbhData (cp_offerAdjNewLineId NUMBER) IS
4036: SELECT

Line 4086: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

4082: x_return_status OUT NOCOPY VARCHAR2
4083: ,x_msg_count OUT NOCOPY NUMBER
4084: ,x_msg_data OUT NOCOPY VARCHAR2
4085: ,p_offerAdjNewLineId IN NUMBER
4086: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
4087: )
4088: IS
4089: BEGIN
4090: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4102: ,x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

4098: x_return_status OUT NOCOPY VARCHAR2
4099: ,x_msg_count OUT NOCOPY NUMBER
4100: ,x_msg_data OUT NOCOPY VARCHAR2
4101: ,p_offerAdjNewLineId IN NUMBER
4102: ,x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
4103: )
4104: IS
4105: CURSOR c_discounts(cp_offerAdjNewLineId NUMBER) IS
4106: SELECT

Line 4149: , x_pricing_attr_rec OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type

4145: x_return_status OUT NOCOPY VARCHAR2
4146: ,x_msg_count OUT NOCOPY NUMBER
4147: ,x_msg_data OUT NOCOPY VARCHAR2
4148: ,p_offerAdjNewLineId IN NUMBER
4149: , x_pricing_attr_rec OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type
4150: , p_index IN NUMBER
4151: )
4152: IS
4153: CURSOR c_pricingAttributes(cp_offerAdjNewLineId NUMBER) IS

Line 4195: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

4191: x_return_status OUT NOCOPY VARCHAR2
4192: ,x_msg_count OUT NOCOPY NUMBER
4193: ,x_msg_data OUT NOCOPY VARCHAR2
4194: ,p_offerAdjNewLineId IN NUMBER
4195: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
4196: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
4197: )
4198: IS
4199: CURSOR c_adjNewLines(cp_offerAdjNewLineId NUMBER) IS

Line 4196: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

4192: ,x_msg_count OUT NOCOPY NUMBER
4193: ,x_msg_data OUT NOCOPY VARCHAR2
4194: ,p_offerAdjNewLineId IN NUMBER
4195: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
4196: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
4197: )
4198: IS
4199: CURSOR c_adjNewLines(cp_offerAdjNewLineId NUMBER) IS
4200: SELECT offer_adj_new_line_id

Line 4250: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type

4246: x_return_status OUT NOCOPY VARCHAR2
4247: ,x_msg_count OUT NOCOPY NUMBER
4248: ,x_msg_data OUT NOCOPY VARCHAR2
4249: ,p_offerAdjNewLineId IN NUMBER
4250: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
4251: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
4252: )
4253: IS
4254: i NUMBER;

Line 4251: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

4247: ,x_msg_count OUT NOCOPY NUMBER
4248: ,x_msg_data OUT NOCOPY VARCHAR2
4249: ,p_offerAdjNewLineId IN NUMBER
4250: , x_modifier_line_rec OUT NOCOPY qp_modifiers_pub.modifiers_rec_type
4251: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
4252: )
4253: IS
4254: i NUMBER;
4255: BEGIN

Line 4292: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

4288: x_return_status OUT NOCOPY VARCHAR2
4289: ,x_msg_count OUT NOCOPY NUMBER
4290: ,x_msg_data OUT NOCOPY VARCHAR2
4291: ,p_offerAdjNewLineId IN NUMBER
4292: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
4293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
4294: )
4295: IS
4296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 4293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

4289: ,x_msg_count OUT NOCOPY NUMBER
4290: ,x_msg_data OUT NOCOPY VARCHAR2
4291: ,p_offerAdjNewLineId IN NUMBER
4292: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
4293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
4294: )
4295: IS
4296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4297: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 4296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

4292: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
4293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
4294: )
4295: IS
4296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4297: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4298: BEGIN
4299: x_return_status := FND_API.G_RET_STS_SUCCESS;
4300: x_modifier_line_tbl.delete;

Line 4297: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

4293: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
4294: )
4295: IS
4296: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4297: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4298: BEGIN
4299: x_return_status := FND_API.G_RET_STS_SUCCESS;
4300: x_modifier_line_tbl.delete;
4301: x_pricing_attr_tbl.delete;

Line 4362: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

4358: x_return_status OUT NOCOPY VARCHAR2
4359: ,x_msg_count OUT NOCOPY NUMBER
4360: ,x_msg_data OUT NOCOPY VARCHAR2
4361: , p_offerAdjNewLineId IN NUMBER
4362: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
4363: )
4364: IS
4365: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4366: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 4365: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

4361: , p_offerAdjNewLineId IN NUMBER
4362: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
4363: )
4364: IS
4365: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4366: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4367: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
4368: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
4369: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

Line 4366: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

4362: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
4363: )
4364: IS
4365: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4366: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4367: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
4368: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
4369: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
4370: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

Line 4367: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

4363: )
4364: IS
4365: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4366: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4367: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
4368: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
4369: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
4370: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
4371: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 4368: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;

4364: IS
4365: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4366: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4367: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
4368: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
4369: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
4370: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
4371: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
4372: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 4369: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

4365: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4366: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4367: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
4368: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
4369: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
4370: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
4371: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
4372: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
4373: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 4370: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;

4366: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4367: V_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
4368: V_MODIFIER_LIST_val_rec QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type;
4369: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
4370: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
4371: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
4372: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
4373: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4374: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

Line 4373: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

4369: V_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
4370: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
4371: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
4372: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
4373: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4374: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
4375: BEGIN
4376: -- initialize
4377: -- populate records

Line 4374: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;

4370: V_MODIFIERS_val_tbl QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type;
4371: V_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
4372: V_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
4373: V_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
4374: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
4375: BEGIN
4376: -- initialize
4377: -- populate records
4378: -- process data

Line 4400: QP_Modifiers_PUB.process_modifiers(

4396: RAISE FND_API.G_EXC_ERROR;
4397: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4399: END IF;
4400: QP_Modifiers_PUB.process_modifiers(
4401: p_api_version_number => 1.0,
4402: p_init_msg_list => FND_API.G_FALSE,
4403: p_return_values => FND_API.G_FALSE,
4404: x_return_status => x_return_status,

Line 4445: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

4441: ,x_msg_data OUT NOCOPY VARCHAR2
4442: ,p_offerAdjNewLineId IN NUMBER
4443: )
4444: IS
4445: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4446: BEGIN
4447: -- initialize
4448: -- create a product qp data
4449: -- back create ozf_offer_adjustment_lines