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.103.12010000.6 2008/12/08 05:25:54 nirprasa 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.103.12010000.6 2008/12/08 05:25:54 nirprasa ship $ */
3: -------------------------------
4: -- PACKAGE
5: -- OZF_Offer_PVT
6: --
7: -- PURPOSE
8: -- Use QP_Modifiers_PUB package to create offers.
9: --

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

180: -- Tue Aug 12 2008: nirprasa fixed bug 7321732
181: -- Tue Aug 22 2008: nirprasa fixed bug 7340864
182: -- Tue Aug 22 2008: nirprasa fixed bug 7584161 and 7580884
183: -------------------------------------------------------------------------------------
184: g_pkg_name CONSTANT VARCHAR2(30):= 'OZF_Offer_Pvt';
185: g_file_name CONSTANT VARCHAR2(15) := 'ozfvofrb.pls';
186: g_sd_offer VARCHAR2(15) := 'N';
187:
188: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 2055: l_qualifier_rec OZF_OFFER_PVT.qualifiers_Rec_Type;

2051:
2052: l_qualifier_id NUMBER;
2053:
2054: l_operation VARCHAR2(30);
2055: l_qualifier_rec OZF_OFFER_PVT.qualifiers_Rec_Type;
2056:
2057: BEGIN
2058: x_return_status := FND_API.G_RET_STS_SUCCESS;
2059: debug_message('Sales method flag = : '||p_modifier_list_rec.sales_method_flag);

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

2087: , x_return_status => x_return_status
2088: , x_msg_count => x_msg_count
2089: , x_msg_data => x_msg_data
2090:
2091: , p_qualifiers_rec => l_qualifier_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type
2092: );
2093: ELSIF l_operation ='CREATE' THEN
2094:
2095: OZF_Volume_Offer_Qual_PVT.create_vo_qualifier

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

2102: , x_return_status => x_return_status
2103: , x_msg_count => x_msg_count
2104: , x_msg_data => x_msg_data
2105:
2106: , p_qualifiers_rec => l_qualifier_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type
2107: );
2108: END IF;
2109: END IF;
2110:

Line 2366: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;

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

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

2427: , x_return_status => x_return_status
2428: , x_msg_count => x_msg_count
2429: , x_msg_data => x_msg_data
2430:
2431: , p_qualifiers_rec => l_qualifiers_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type
2432: );
2433: ELSIF l_operation ='CREATE' THEN
2434:
2435: OZF_Volume_Offer_Qual_PVT.create_vo_qualifier

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

2442: , x_return_status => x_return_status
2443: , x_msg_count => x_msg_count
2444: , x_msg_data => x_msg_data
2445:
2446: , p_qualifiers_rec => l_qualifiers_rec -- IN OZF_OFFER_PVT.qualifiers_Rec_Type
2447: );
2448: END IF;
2449:
2450: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

Line 11343: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

11339: l_theme_approval_req VARCHAR2(1);
11340: l_budget_approval_req VARCHAR2(1);
11341:
11342:
11343: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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;

Line 11344: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

11340: l_budget_approval_req VARCHAR2(1);
11341:
11342:
11343: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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;

Line 11345: l_dummy_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

11341:
11342:
11343: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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;

Line 11346: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;

11342:
11343: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_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;

Line 11347: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;

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

Line 11349: l_advanced_options_rec ozf_offer_pvt.ADVANCED_OPTION_REC_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:
11353:

Line 11608: Ozf_Offer_Pvt.process_modifiers(

11604: /*Create Discount Lines*/
11605:
11606: IF l_modifier_line_tbl.count>0 THEN
11607:
11608: Ozf_Offer_Pvt.process_modifiers(
11609: p_init_msg_list => p_init_msg_list
11610: ,p_api_version => p_api_version
11611: ,p_commit => p_commit
11612: ,x_return_status => x_return_status

Line 11941: END OZF_Offer_Pvt;

11937: );
11938:
11939: END process_sd_modifiers;
11940:
11941: END OZF_Offer_Pvt;
11942: