DBA Data[Home] [Help]

APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on OZF_QUAL_MARKET_OPTION_PVT

Line 24: , p_qual_mo_rec IN OUT NOCOPY OZF_QUAL_MARKET_OPTION_PVT.qual_mo_rec_type

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
27: , x_msg_data OUT NOCOPY VARCHAR2
28: )

Line 142: l_qual_mo_rec OZF_QUAL_MARKET_OPTION_PVT.qual_mo_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
145: --initialize
146: -- Standard Start of API savepoint

Line 274: OZF_QUAL_MARKET_OPTION_PVT.Create_qual_market_options(

270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: OZF_QUAL_MARKET_OPTION_PVT.Create_qual_market_options(
275: p_api_version_number => p_api_version_number
276: , p_init_msg_list => p_init_msg_list
277: , p_commit => p_commit
278: , p_validation_level => p_validation_level

Line 404: l_qual_mo_rec OZF_QUAL_MARKET_OPTION_PVT.qual_mo_rec_type;

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
408: WHERE qp_qualifier_id = p_qualifier_id;

Line 595: OZF_QUAL_MARKET_OPTION_PVT.update_qual_market_options(

591: IF l_market_option_id <> -2 THEN
592: l_qual_mo_rec.offer_market_option_id := l_market_option_id;
593: debug_message('uupdating interface');
594:
595: OZF_QUAL_MARKET_OPTION_PVT.update_qual_market_options(
596: p_api_version_number => p_api_version_number
597: , p_init_msg_list => p_init_msg_list
598: , p_commit => p_commit
599: , p_validation_level => p_validation_level

Line 814: OZF_QUAL_MARKET_OPTION_PVT.Delete_qual_market_options(

810: IF (c_qual_mo%NOTFOUND) THEN
811: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INTF_REC_NOT_FOUND');
812: x_return_status := FND_API.g_ret_sts_error;
813: ELSE
814: OZF_QUAL_MARKET_OPTION_PVT.Delete_qual_market_options(
815: p_api_version_number => p_api_version_number
816: , p_init_msg_list => p_init_msg_list
817: , p_commit => p_commit
818: , p_validation_level => p_validation_level