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_PVT dependencies on QP_QUALIFIER_RULES_PUB

Line 648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

644: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
645: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
646: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
650: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
651: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
652: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;

Line 649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

645: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
646: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
650: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
651: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
652: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;
653:

Line 830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

826: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
831: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
832: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
833: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
834:

Line 831: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
831: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
832: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
833: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
834:
835: CURSOR cur_get_adv_options(parent_list_line_id NUMBER) IS

Line 1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

1133: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1134: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1138: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1139: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1140: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1141:

Line 1138: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

1134: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1138: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1139: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1140: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1141:
1142: BEGIN

Line 1415: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;

1411:
1412: l_api_version CONSTANT NUMBER := 1.0;
1413: l_api_name CONSTANT VARCHAR2(30) := 'process_rltd_modifier_qual';
1414: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1415: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1416: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1417: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

1416: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1417: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1422: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1423: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1424: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

1417: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1422: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1423: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1424: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
1425:

Line 1424: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1422: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1423: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1424: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
1425:
1426: l_rltd_modifier_id NUMBER;
1427: l_index NUMBER := 0;
1428:

Line 1552: ,x_qualifiers_tbl OUT NOCOPY qp_qualifier_rules_pub.qualifiers_tbl_type

1548: ,x_msg_count OUT NOCOPY NUMBER
1549: ,x_msg_data OUT NOCOPY VARCHAR2
1550: ,p_qualifiers_tbl IN QUALIFIERS_TBL_TYPE
1551: ,x_error_location OUT NOCOPY NUMBER
1552: ,x_qualifiers_tbl OUT NOCOPY qp_qualifier_rules_pub.qualifiers_tbl_type
1553: )
1554: IS
1555: l_api_version CONSTANT NUMBER := 1.0;
1556: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';

Line 1558: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;

1554: IS
1555: l_api_version CONSTANT NUMBER := 1.0;
1556: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1557: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1558: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1559: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1560: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

1559: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1560: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1564: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1565: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1566: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1567: l_qualifier_deleted VARCHAR2(1) := 'N';

Line 1564: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

1560: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1564: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1565: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1566: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1567: l_qualifier_deleted VARCHAR2(1) := 'N';
1568: l_qp_list_header_id NUMBER;

Line 1766: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;

1762: IS
1763: l_api_version CONSTANT NUMBER := 1.0;
1764: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1765: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1766: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

1767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1775: l_qualifier_deleted VARCHAR2(1) := 'N';

Line 1772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

1768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1775: l_qualifier_deleted VARCHAR2(1) := 'N';
1776: l_qp_list_header_id NUMBER;

Line 2280: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

2276: AND list_line_id = -1
2277: AND qualifier_context IN ('SOLD_BY');
2278:
2279: i NUMBER := 0;
2280: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
2281:
2282: ---Start POS profile Batch changes
2283: cursor check_Ship_From_Stock(p_offr_code VARCHAR2) IS
2284: SELECT ship_from_stock_flag

Line 2527: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

2523:
2524: l_operation VARCHAR2(30);
2525:
2526: i NUMBER := 0;
2527: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
2528: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;
2529: BEGIN
2530:
2531: ----------- initialize -------------

Line 3643: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

3639: l_qualifiers_tbl qualifiers_tbl_type;
3640: l_error_location NUMBER;
3641:
3642: l_index NUMBER ;
3643: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3644: BEGIN
3645: SAVEPOINT Push_Target_group;
3646:
3647: -- Standard call to check for call compatibility.

Line 3905: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

3901: --l_offer_rec modifier_list_rec_type := p_offer_rec;
3902: l_recal VARCHAR2(1);
3903: l_pass_validation_flag VARCHAR2(1);
3904: l_offer_id NUMBER;
3905: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3906: l_start_date_q DATE;
3907: l_start_date_o DATE;
3908: l_start_date DATE;
3909: l_obj_ver_num NUMBER;

Line 4249: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

4245: WHERE list_header_id = l_list_header_id
4246: AND qualifier_context = 'ORDER'
4247: AND qualifier_attribute in ('QUALIFIER_ATTRIBUTE1','QUALIFIER_ATTRIBUTE8');
4248:
4249: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4250:
4251: BEGIN
4252:
4253: ----------- initialize -------------

Line 4449: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

4445:
4446: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4449: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4453:

Line 4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

4446: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4449: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4453:
4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

Line 5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

5767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5775: l_control_rec qp_globals.control_rec_type;

Line 5772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5775: l_control_rec qp_globals.control_rec_type;
5776: BEGIN

Line 6074: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

6070: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
6071:
6072: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6073: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
6074: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6080: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6081: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6082: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6083: p_list_line_id NUMBER;

Line 6080: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6080: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6081: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6082: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6083: p_list_line_id NUMBER;
6084:

Line 6984: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

6980: l_api_name CONSTANT VARCHAR2(30) := 'process_order_value';
6981: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
6982:
6983: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6984: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6985: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

6985: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6990: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6991: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6992: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6993:

Line 6990: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6990: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6991: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6992: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6993:
6994: p_list_line_id NUMBER;

Line 7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

7561: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7566: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7567: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7568: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
7569: l_control_rec qp_globals.control_rec_type;

Line 7566: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7566: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7567: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7568: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
7569: l_control_rec qp_globals.control_rec_type;
7570:

Line 10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10866: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10867: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10868: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
10869: l_control_rec qp_globals.control_rec_type;

Line 10866: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10866: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10867: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10868: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
10869: l_control_rec qp_globals.control_rec_type;
10870: BEGIN

Line 12156: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

12152: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
12153: l_dummy_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
12154: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
12155: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
12156: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
12157: l_advanced_options_rec ozf_offer_pvt.ADVANCED_OPTION_REC_TYPE;
12158: l_access_rec ams_access_pvt.access_rec_type;
12159:
12160: