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 OZF_OFFER_PVT

Line 1: Package BODY OZF_Offer_Pvt AS

1: Package BODY OZF_Offer_Pvt AS
2: /* $Header: ozfvofrb.pls 120.141.12020000.7 2013/05/31 00:56:32 ninarasi ship $ */
3: -------------------------------
4: -- PACKAGE
5: -- OZF_Offer_PVT

Line 5: -- OZF_Offer_PVT

1: Package BODY OZF_Offer_Pvt AS
2: /* $Header: ozfvofrb.pls 120.141.12020000.7 2013/05/31 00:56:32 ninarasi ship $ */
3: -------------------------------
4: -- PACKAGE
5: -- OZF_Offer_PVT
6: --
7: -- PURPOSE
8: -- Use QP_Modifiers_PUB package to create offers.
9: --

Line 211: g_pkg_name CONSTANT VARCHAR2(30):= 'OZF_Offer_Pvt';

207: -- 27-Jun-2012 amitamku Modified procedure populateSDQualifiers for bug 13981597
208: -- 30-May-2013 ninarasi 16870803 - R.TST1222:NOT ABLE TO ADD MORE THAN ONE PRODUCT TO DISCOUNT RULE
209: -----------------------------------------------------------------------------------------------------------------------
210:
211: g_pkg_name CONSTANT VARCHAR2(30):= 'OZF_Offer_Pvt';
212: g_file_name CONSTANT VARCHAR2(15) := 'ozfvofrb.pls';
213: g_sd_offer VARCHAR2(15) := 'N';
214:
215: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 691: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_adv_options before calling QP for list_header_id : '|| p_advanced_options_rec.list_header_id);

687: i:= i+1;
688: END LOOP;
689:
690: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_adv_options---');
691: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_adv_options before calling QP for list_header_id : '|| p_advanced_options_rec.list_header_id);
692:
693: Qp_Modifiers_Pub.process_modifiers(
694: p_api_version_number => 1.0,
695: p_init_msg_list => p_init_msg_list,

Line 977: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.create_offer_tiers before calling QP for list_header_id : '|| p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);

973:
974:
975: debug_message('Calling Pub Process in tiers');
976: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in create_offer_tiers---');
977: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.create_offer_tiers before calling QP for list_header_id : '|| p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);
978: END IF;
979: Qp_Modifiers_Pub.process_modifiers(
980: p_api_version_number => 1.0,
981: p_init_msg_list => p_init_msg_list,

Line 1183: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT processRegExclusions before calling QP for list_header_id : '|| p_pricing_attr_tbl(p_pricing_attr_tbl.FIRST).list_line_id);

1179: l_pricing_attr_tbl(i).operation := p_pricing_attr_tbl(i).operation;
1180: --dbms_output.put_line('end:'||i);
1181: END IF;
1182: END LOOP;
1183: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT processRegExclusions before calling QP for list_header_id : '|| p_pricing_attr_tbl(p_pricing_attr_tbl.FIRST).list_line_id);
1184: END IF;
1185:
1186: Qp_Modifiers_Pub.process_modifiers(
1187: p_api_version_number => 1.0,

Line 1485: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_rltd_modifier_qual before calling QP for list_header_id : '|| l_qualifiers_tbl(l_qualifiers_tbl.first).list_header_id);

1481: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_rltd_modifier_qual---');
1482:
1483: IF l_qualifiers_tbl.COUNT > 0 THEN
1484:
1485: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_rltd_modifier_qual before calling QP for list_header_id : '|| l_qualifiers_tbl(l_qualifiers_tbl.first).list_header_id);
1486: Qp_Modifiers_Pub.process_modifiers(
1487: p_api_version_number => 1.0,
1488: p_init_msg_list => p_init_msg_list,
1489: p_return_values => Fnd_Api.G_FALSE,

Line 1644: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_market_qualifiers before calling QP for list_header_id : '|| p_qualifiers_tbl(p_qualifiers_tbl.FIRST).list_header_id);

1640: l_qp_list_header_id := p_qualifiers_tbl(i).list_header_id;
1641: END IF;
1642: END IF;
1643: END LOOP;
1644: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_market_qualifiers before calling QP for list_header_id : '|| p_qualifiers_tbl(p_qualifiers_tbl.FIRST).list_header_id);
1645: END IF;
1646:
1647: Qp_Modifiers_Pub.process_modifiers(
1648: p_api_version_number => 1.0,

Line 1846: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_market_qualifiers2 before calling QP for list_header_id : '||p_qualifiers_tbl(p_qualifiers_tbl.FIRST).list_header_id);

1842: l_qp_list_header_id := p_qualifiers_tbl(i).list_header_id;
1843: END IF;
1844: END IF;
1845: END LOOP;
1846: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_market_qualifiers2 before calling QP for list_header_id : '||p_qualifiers_tbl(p_qualifiers_tbl.FIRST).list_header_id);
1847: END IF;
1848:
1849: Qp_Modifiers_Pub.process_modifiers(
1850: p_api_version_number => 1.0,

Line 2166: l_qualifier_rec OZF_OFFER_PVT.qualifiers_Rec_Type;

2162:
2163: l_qualifier_id NUMBER;
2164:
2165: l_operation VARCHAR2(30);
2166: l_qualifier_rec OZF_OFFER_PVT.qualifiers_Rec_Type;
2167:
2168: BEGIN
2169: x_return_status := FND_API.G_RET_STS_SUCCESS;
2170: debug_message('Sales method flag = : '||p_modifier_list_rec.sales_method_flag);

Line 2202: , p_qualifiers_rec => l_qualifier_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type

2198: , x_return_status => x_return_status
2199: , x_msg_count => x_msg_count
2200: , x_msg_data => x_msg_data
2201:
2202: , p_qualifiers_rec => l_qualifier_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type
2203: );
2204: ELSIF l_operation ='CREATE' THEN
2205:
2206: OZF_Volume_Offer_Qual_PVT.create_vo_qualifier

Line 2217: , p_qualifiers_rec => l_qualifier_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type

2213: , x_return_status => x_return_status
2214: , x_msg_count => x_msg_count
2215: , x_msg_data => x_msg_data
2216:
2217: , p_qualifiers_rec => l_qualifier_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type
2218: );
2219: END IF;
2220: END IF;
2221:

Line 2528: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;

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 -------------
2532: SAVEPOINT vo_qualifier_pvt;

Line 2593: , p_qualifiers_rec => l_qualifiers_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type

2589: , x_return_status => x_return_status
2590: , x_msg_count => x_msg_count
2591: , x_msg_data => x_msg_data
2592:
2593: , p_qualifiers_rec => l_qualifiers_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type
2594: );
2595: ELSIF l_operation ='CREATE' THEN
2596:
2597: OZF_Volume_Offer_Qual_PVT.create_vo_qualifier

Line 2608: , p_qualifiers_rec => l_qualifiers_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type

2604: , x_return_status => x_return_status
2605: , x_msg_count => x_msg_count
2606: , x_msg_data => x_msg_data
2607:
2608: , p_qualifiers_rec => l_qualifiers_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type
2609: );
2610: END IF;
2611:
2612: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

Line 2812: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_limits before calling QP for list_header_id : '|| p_list_header_id);

2808: IF (l_limits_rec.operation = 'DELETE'
2809: OR (l_limits_rec.amount IS NOT NULL AND
2810: l_limits_rec.amount <> FND_API.G_MISS_NUM)) THEN
2811:
2812: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_limits before calling QP for list_header_id : '|| p_list_header_id);
2813:
2814: QP_Limits_PUB.Process_Limits
2815: ( p_init_msg_list => FND_API.g_true,
2816: p_api_version_number => 1.0,

Line 3697: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.Push_Target_group','before process_market_qualifiers 3 l_qualifiers_tbl.count = '|| l_qualifiers_tbl.count);

3693:
3694: END LOOP;
3695:
3696: IF l_qualifiers_tbl.count > 0 THEN
3697: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.Push_Target_group','before process_market_qualifiers 3 l_qualifiers_tbl.count = '|| l_qualifiers_tbl.count);
3698: process_market_qualifiers
3699: (
3700: p_init_msg_list => p_init_msg_list
3701: ,p_api_version => p_api_version

Line 4663: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before resetting context for list_header_id : '||l_modifier_list_rec.list_header_id);

4659: IF (l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM) THEN
4660: IF NVL(l_org_id,0) <> NVL(p_modifier_list_rec.orig_org_id,0) THEN
4661: /*1. Set context to access_mode =S AND org_id = old org id
4662: 2. Set flag to indicate that context has been changed*/
4663: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before resetting context for list_header_id : '||l_modifier_list_rec.list_header_id);
4664: MO_GLOBAL.set_policy_context('S', l_org_id);
4665: l_context_changed := 'T';
4666: END IF;
4667: END IF;

Line 4688: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before resetting context for list_header_id : '||l_modifier_list_rec.list_header_id);

4684: IF (l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM) THEN
4685: IF NVL(l_org_id,0) <> NVL(p_modifier_list_rec.orig_org_id,0) THEN
4686: /*1. Set context to access_mode =S AND org_id = old org id
4687: 2. Set flag to indicate that context has been changed*/
4688: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before resetting context for list_header_id : '||l_modifier_list_rec.list_header_id);
4689: MO_GLOBAL.set_policy_context('S', l_org_id);
4690: l_context_changed := 'T';
4691: END IF;
4692: END IF;

Line 4697: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before calling QP for list_header_id : '||l_modifier_list_rec.list_header_id);

4693: l_modifier_list_rec.global_flag := 'N';
4694: l_modifier_list_rec.org_id := p_modifier_list_rec.orig_org_id;
4695: END IF;
4696:
4697: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before calling QP for list_header_id : '||l_modifier_list_rec.list_header_id);
4698: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header org_id = '|| l_modifier_list_rec.org_id);
4699: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header global_flag = '|| l_modifier_list_rec.global_flag);
4700:
4701: Qp_Modifiers_Pub.process_modifiers(

Line 4734: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before returning to UI : '|| l_modifier_list_rec.list_header_id);

4730: --need not handle global to local. As QP_ORG_SECURITY function will always find global offers
4731: -- no matter what is the context.
4732: MO_GLOBAL.set_policy_context('M',null);
4733: END IF;
4734: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before returning to UI : '|| l_modifier_list_rec.list_header_id);
4735: END IF;
4736: --dbms_output.put_line('Return status1 is :'||x_return_status);
4737: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
4738: add_message(x_msg_count);

Line 4847: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits for list_header_id : '|| l_limits_rec.list_header_id);

4843: END IF;
4844: END IF;
4845: */
4846:
4847: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits for list_header_id : '|| l_limits_rec.list_header_id);
4848:
4849: QP_Limits_PUB.Process_Limits
4850: ( p_init_msg_list => FND_API.g_true,
4851: p_api_version_number => 1.0,

Line 4922: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits2 for list_header_id : '|| l_limits_rec.list_header_id);

4918: l_limits_rec.amount := p_modifier_list_rec.max_no_of_uses;
4919: END IF;
4920: END IF;
4921:
4922: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits2 for list_header_id : '|| l_limits_rec.list_header_id);
4923:
4924: QP_Limits_PUB.Process_Limits
4925: ( p_init_msg_list => FND_API.g_true,
4926: p_api_version_number => 1.0,

Line 5813: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.processPbhLine','QP Call in processPbhLine---');

5809: RAISE FND_API.G_EXC_ERROR;
5810: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5812: END IF;
5813: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.processPbhLine','QP Call in processPbhLine---');
5814: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT processPbhLine before calling QP for list_header_id : '||p_modifierLineRec.list_header_id);
5815: QP_Modifiers_PUB.process_modifiers(
5816: p_api_version_number => 1.0,
5817: p_init_msg_list => FND_API.G_FALSE,

Line 5814: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT processPbhLine before calling QP for list_header_id : '||p_modifierLineRec.list_header_id);

5810: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5812: END IF;
5813: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.processPbhLine','QP Call in processPbhLine---');
5814: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT processPbhLine before calling QP for list_header_id : '||p_modifierLineRec.list_header_id);
5815: QP_Modifiers_PUB.process_modifiers(
5816: p_api_version_number => 1.0,
5817: p_init_msg_list => FND_API.G_FALSE,
5818: p_return_values => FND_API.G_FALSE,

Line 6423: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_regular_discounts before calling for QP list_header_id : '|| l_modifiers_tbl(l_modifiers_tbl.FIRST).list_header_id);

6419:
6420: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_regular_discounts--- l_modifiers_tbl.count = '|| l_modifiers_tbl.count);
6421:
6422: IF l_modifiers_tbl.count > 0 THEN -- bug 3711957. when processing PBH, l_modifiers_tbl is empty
6423: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_regular_discounts before calling for QP list_header_id : '|| l_modifiers_tbl(l_modifiers_tbl.FIRST).list_header_id);
6424: QP_Modifiers_PUB.process_modifiers(
6425: p_api_version_number => 1.0,
6426: p_init_msg_list => FND_API.G_FALSE,
6427: p_return_values => FND_API.G_FALSE,

Line 7059: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_order_value before calling QP for list_header_id : '||p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);

7055:
7056: FOR i in p_modifier_line_tbl.first..p_modifier_line_tbl.last LOOP
7057: IF p_modifier_line_tbl.exists(i) THEN
7058:
7059: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_order_value before calling QP for list_header_id : '||p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);
7060:
7061: l_modifiers_tbl(i).operation := p_modifier_line_tbl(i).operation;
7062: l_modifiers_tbl(i).list_header_id := p_modifier_line_tbl(i).list_header_id;
7063: l_modifiers_tbl(i).list_line_id := p_modifier_line_tbl(i).list_line_id;

Line 7251: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_order_value before calling QP for list_header_id : '||p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);

7247: l_qualifiers_tbl(i).operation := p_modifier_line_tbl(i).operation;
7248:
7249: END IF;
7250:
7251: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_order_value before calling QP for list_header_id : '||p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);
7252:
7253: END LOOP;
7254:
7255: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_order_value 2---p_modifier_line_tbl.count = '|| p_modifier_line_tbl.count);

Line 10936: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.pushDiscountRuleToQp','QP Call in pushDiscountRuleToQp---');

10932: RAISE FND_API.G_EXC_ERROR;
10933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10935: END IF;
10936: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.pushDiscountRuleToQp','QP Call in pushDiscountRuleToQp---');
10937: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT pushDiscountRuleToQp before calling QP for list_header_id : '||p_qp_list_header_id);
10938: QP_Modifiers_PUB.process_modifiers(
10939: p_api_version_number => 1.0,
10940: p_init_msg_list => FND_API.G_FALSE,

Line 10937: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT pushDiscountRuleToQp before calling QP for list_header_id : '||p_qp_list_header_id);

10933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10935: END IF;
10936: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.pushDiscountRuleToQp','QP Call in pushDiscountRuleToQp---');
10937: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT pushDiscountRuleToQp before calling QP for list_header_id : '||p_qp_list_header_id);
10938: QP_Modifiers_PUB.process_modifiers(
10939: p_api_version_number => 1.0,
10940: p_init_msg_list => FND_API.G_FALSE,
10941: p_return_values => FND_API.G_FALSE,

Line 12151: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

12147: l_theme_approval_req VARCHAR2(1);
12148: l_budget_approval_req VARCHAR2(1);
12149:
12150:
12151: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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;

Line 12152: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

12148: l_budget_approval_req VARCHAR2(1);
12149:
12150:
12151: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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;

Line 12153: l_dummy_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

12149:
12150:
12151: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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;

Line 12154: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;

12150:
12151: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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;

Line 12155: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;

12151: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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:

Line 12157: l_advanced_options_rec ozf_offer_pvt.ADVANCED_OPTION_REC_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:
12161:

Line 12418: Ozf_Offer_Pvt.process_modifiers(

12414: /*Create Discount Lines*/
12415:
12416: IF l_modifier_line_tbl.count>0 THEN
12417:
12418: Ozf_Offer_Pvt.process_modifiers(
12419: p_init_msg_list => p_init_msg_list
12420: ,p_api_version => p_api_version
12421: ,p_commit => p_commit
12422: ,x_return_status => x_return_status

Line 12492: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.process_sd_modifiers','before process_market_qualifiers 5');

12488: RAISE Fnd_Api.g_exc_unexpected_error;
12489: END IF;
12490:
12491: /*Create Market Qualifiers*/
12492: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.process_sd_modifiers','before process_market_qualifiers 5');
12493: process_market_qualifiers(
12494: p_init_msg_list => p_init_msg_list
12495: ,p_api_version => p_api_version
12496: ,p_commit => p_commit

Line 12752: END OZF_Offer_Pvt;

12748: );
12749:
12750: END process_sd_modifiers;
12751:
12752: END OZF_Offer_Pvt;
12753: