APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on OZF_OFFER_MARKET_OPTIONS_PVT

Line 22: p_mo_rec IN OZF_offer_Market_Options_PVT.vo_mo_rec_type

18: END debug_message;
19:
20:
21: PROCEDURE populate_mkt_option_qual_intf(
22: p_mo_rec IN OZF_offer_Market_Options_PVT.vo_mo_rec_type
23: , p_qualifiers_rec qp_qualifier_rules_pub.qualifiers_rec_type
24: , p_qual_mo_rec IN OUT NOCOPY OZF_QUAL_MARKET_OPTION_PVT.qual_mo_rec_type
25: , x_return_status OUT NOCOPY VARCHAR2
26: , x_msg_count OUT NOCOPY NUMBER

Line 45: p_mo_rec IN OUT NOCOPY OZF_offer_Market_Options_PVT.vo_mo_rec_type

41: p_qual_mo_rec.qp_qualifier_id := p_qualifiers_rec.qualifier_id;
42: END populate_mkt_option_qual_intf;
43:
44: PROCEDURE populate_deflt_mkt_options(
45: p_mo_rec IN OUT NOCOPY OZF_offer_Market_Options_PVT.vo_mo_rec_type
46: , p_qualifiers_rec qp_qualifier_rules_pub.qualifiers_rec_type
47: , x_return_status OUT NOCOPY VARCHAR2
48: , x_msg_count OUT NOCOPY NUMBER
49: , x_msg_data OUT NOCOPY VARCHAR2

Line 140: l_Mo_rec OZF_offer_Market_Options_PVT.vo_mo_rec_type;

136: l_qualifiers_tbl OZF_OFFER_PVT.QUALIFIERS_TBL_TYPE;
137: l_qualifiers_rec OZF_OFFER_PVT.QUALIFIERS_REC_TYPE;
138: x_error_location NUMBER;
139: l_mo_id NUMBER;
140: l_Mo_rec OZF_offer_Market_Options_PVT.vo_mo_rec_type;
141:
142: l_qual_mo_rec OZF_QUAL_MARKET_OPTION_PVT.qual_mo_rec_type;
143: l_qual_market_option_id NUMBER;
144: BEGIN

Line 237: OZF_offer_Market_Options_PVT.Create_market_options

233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: END IF;
236:
237: OZF_offer_Market_Options_PVT.Create_market_options
238: (
239: p_api_version_number => p_api_version_number
240: , p_init_msg_list => p_init_msg_list
241: , p_commit => p_commit

Line 403: l_mo_rec OZF_offer_Market_Options_PVT.vo_mo_rec_type;

399:
400: l_mkt_opt_dtail c_mkt_opt_dtail%ROWTYPE;
401: l_mkt_option_found VARCHAR2(1) := 'N';
402: l_mo_id NUMBER;
403: l_mo_rec OZF_offer_Market_Options_PVT.vo_mo_rec_type;
404: l_qual_mo_rec OZF_QUAL_MARKET_OPTION_PVT.qual_mo_rec_type;
405:
406: CURSOR c_qual_mo(p_qualifier_id NUMBER) IS
407: SELECT * FROM ozf_qualifier_market_option

Line 507: OZF_offer_Market_Options_PVT.Delete_market_options(

503: IF l_mkt_option_found <> 'N' THEN
504: -- if members do not exist in the old group delete the market option associated with the old group
505: IF l_old_group_members_exist = 'N' THEN
506: debug_message('Deleting old market option');
507: OZF_offer_Market_Options_PVT.Delete_market_options(
508: p_api_version_number => p_api_version_number
509: , p_init_msg_list => p_init_msg_list
510: , p_commit => p_commit
511: , p_validation_level => p_validation_level

Line 539: OZF_offer_Market_Options_PVT.Create_market_options

535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: RAISE FND_API.G_EXC_ERROR;
537: END IF;
538:
539: OZF_offer_Market_Options_PVT.Create_market_options
540: (
541: p_api_version_number => p_api_version_number
542: , p_init_msg_list => p_init_msg_list
543: , p_commit => p_commit

Line 785: OZF_offer_Market_Options_PVT.Delete_market_options(

781: IF l_mkt_option_found = 'Y' THEN
782: debug_message('Group no is : '||group_no);
783: IF group_no <> -1000 THEN
784: IF get_group_members(l_group_no.list_header_id,l_group_no.qualifier_grouping_no ) = 'N' THEN
785: OZF_offer_Market_Options_PVT.Delete_market_options(
786: p_api_version_number => p_api_version_number
787: , p_init_msg_list => p_init_msg_list
788: , p_commit => p_commit
789: , p_validation_level => p_validation_level