DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on QP_QUALIFIER_RULES_PUB

Line 557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

553: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
554: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
555: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
559: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
560: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
561: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;

Line 558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

554: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
555: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
559: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
560: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
561: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;
562:

Line 736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

732: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
737: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
738: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
739: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
740:

Line 737: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
737: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
738: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
739: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
740:
741: CURSOR cur_get_adv_options(parent_list_line_id NUMBER) IS

Line 1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

1036: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1037: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1041: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1042: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1043: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1044:

Line 1041: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

1037: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1041: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1042: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1043: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1044:
1045: BEGIN

Line 1314: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;

1310:
1311: l_api_version CONSTANT NUMBER := 1.0;
1312: l_api_name CONSTANT VARCHAR2(30) := 'process_rltd_modifier_qual';
1313: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1314: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1315: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1316: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

1315: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1316: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1321: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1322: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1323: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

1316: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1321: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1322: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1323: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
1324:

Line 1323: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1321: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1322: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1323: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
1324:
1325: l_rltd_modifier_id NUMBER;
1326: l_index NUMBER := 0;
1327:

Line 1446: ,x_qualifiers_tbl OUT NOCOPY qp_qualifier_rules_pub.qualifiers_tbl_type

1442: ,x_msg_count OUT NOCOPY NUMBER
1443: ,x_msg_data OUT NOCOPY VARCHAR2
1444: ,p_qualifiers_tbl IN QUALIFIERS_TBL_TYPE
1445: ,x_error_location OUT NOCOPY NUMBER
1446: ,x_qualifiers_tbl OUT NOCOPY qp_qualifier_rules_pub.qualifiers_tbl_type
1447: )
1448: IS
1449: l_api_version CONSTANT NUMBER := 1.0;
1450: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';

Line 1452: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;

1448: IS
1449: l_api_version CONSTANT NUMBER := 1.0;
1450: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1451: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1452: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1453: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1454: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

1453: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1454: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1458: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1459: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1460: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1461: l_qualifier_deleted VARCHAR2(1) := 'N';

Line 1458: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

1454: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1458: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1459: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1460: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1461: l_qualifier_deleted VARCHAR2(1) := 'N';
1462: l_qp_list_header_id NUMBER;

Line 1658: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;

1654: IS
1655: l_api_version CONSTANT NUMBER := 1.0;
1656: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1657: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1658: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1659: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1660: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

1659: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1660: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1664: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1665: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1666: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1667: l_qualifier_deleted VARCHAR2(1) := 'N';

Line 1664: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

1660: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1664: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1665: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1666: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1667: l_qualifier_deleted VARCHAR2(1) := 'N';
1668: l_qp_list_header_id NUMBER;

Line 2169: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

2165: AND list_line_id = -1
2166: AND qualifier_context IN ('SOLD_BY');
2167:
2168: i NUMBER := 0;
2169: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
2170: BEGIN
2171:
2172: ----------- initialize -------------
2173: SAVEPOINT offer_qualifier;

Line 2365: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

2361:
2362: l_operation VARCHAR2(30);
2363:
2364: i NUMBER := 0;
2365: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
2366: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;
2367: BEGIN
2368:
2369: ----------- initialize -------------

Line 3478: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

3474: l_qualifiers_tbl qualifiers_tbl_type;
3475: l_error_location NUMBER;
3476:
3477: l_index NUMBER ;
3478: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3479: BEGIN
3480: SAVEPOINT Push_Target_group;
3481:
3482: -- Standard call to check for call compatibility.

Line 3725: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

3721: --l_offer_rec modifier_list_rec_type := p_offer_rec;
3722: l_recal VARCHAR2(1);
3723: l_pass_validation_flag VARCHAR2(1);
3724: l_offer_id NUMBER;
3725: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3726: l_start_date_q DATE;
3727: l_start_date_o DATE;
3728: l_start_date DATE;
3729: l_obj_ver_num NUMBER;

Line 4050: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

4046: WHERE list_header_id = l_list_header_id
4047: AND qualifier_context = 'ORDER'
4048: AND qualifier_attribute in ('QUALIFIER_ATTRIBUTE1','QUALIFIER_ATTRIBUTE8');
4049:
4050: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4051:
4052: BEGIN
4053:
4054: ----------- initialize -------------

Line 4234: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

4230:
4231: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4234: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4238:

Line 4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

4231: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4234: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4238:
4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

Line 5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

5389: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5394: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5395: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5396: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5397: l_control_rec qp_globals.control_rec_type;

Line 5394: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5394: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5395: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5396: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5397: l_control_rec qp_globals.control_rec_type;
5398: BEGIN

Line 5574: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

5570: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
5571:
5572: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
5573: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5574: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5580: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5581: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5582: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5583: p_list_line_id NUMBER;

Line 5580: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5580: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5581: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5582: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5583: p_list_line_id NUMBER;
5584:

Line 6454: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

6450: l_api_name CONSTANT VARCHAR2(30) := 'process_order_value';
6451: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
6452:
6453: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6454: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6455: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

6455: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6460: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6461: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6462: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6463:

Line 6460: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6460: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6461: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6462: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6463:
6464: p_list_line_id NUMBER;

Line 7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

7027: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7032: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7033: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7034: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
7035: l_control_rec qp_globals.control_rec_type;

Line 7032: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7032: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7033: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7034: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
7035: l_control_rec qp_globals.control_rec_type;
7036:

Line 10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10285: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10286: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10287: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
10288: l_control_rec qp_globals.control_rec_type;

Line 10285: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10285: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10286: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10287: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
10288: l_control_rec qp_globals.control_rec_type;
10289: BEGIN

Line 11348: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

11344: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
11345: l_dummy_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
11346: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
11347: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
11348: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
11349: l_advanced_options_rec ozf_offer_pvt.ADVANCED_OPTION_REC_TYPE;
11350: l_access_rec ams_access_pvt.access_rec_type;
11351:
11352: