[Home] [Help]
PACKAGE: APPS.OZF_VOLUME_OFFER_QUAL_PVT
Source
1 PACKAGE OZF_volume_offer_qual_PVT AS
2 /* $Header: ozfvvoqs.pls 120.4 2005/08/24 06:33 rssharma noship $*/
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 -- Mon Jun 20 2005:2/19 PM RSSHARMA Added new procedure copy_vo_discounts
13 -- Wed Aug 24 2005:1/21 AM rssharma Commented out showerrors and added nocopy hint to all out variables
14 -- End of Comments
15 -- ===============================================================
16
17
18 PROCEDURE create_vo_qualifier
19 (
20 p_api_version_number IN NUMBER
21 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
22 , p_commit IN VARCHAR2 := FND_API.G_FALSE
23 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
24
25 , x_return_status OUT NOCOPY VARCHAR2
26 , x_msg_count OUT NOCOPY NUMBER
27 , x_msg_data OUT NOCOPY VARCHAR2
28
29 , p_qualifiers_rec IN OZF_Offer_Pvt.qualifiers_rec_Type
30 );
31
32 FUNCTION create_mo_for_group(
33 p_group_number NUMBER
34 , p_qp_list_header_id NUMBER
35 ) RETURN VARCHAR2;
36
37 FUNCTION get_market_option_id(p_group_number NUMBER,p_qp_list_header_id NUMBER) return number;
38
39
40 FUNCTION get_group_members(p_qp_list_header_id NUMBER, p_group_number NUMBER)
41 RETURN VARCHAR2;
42
43
44 PROCEDURE update_vo_qualifier
45 (
46 p_api_version_number IN NUMBER
47 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48 , p_commit IN VARCHAR2 := FND_API.G_FALSE
49 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
50
51 , x_return_status OUT NOCOPY VARCHAR2
52 , x_msg_count OUT NOCOPY NUMBER
53 , x_msg_data OUT NOCOPY VARCHAR2
54
55 , p_qualifiers_rec IN OZF_Offer_Pvt.qualifiers_Rec_Type
56 );
57 PROCEDURE Delete_vo_qualifier(
58 p_api_version_number IN NUMBER
59 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
60 , p_commit IN VARCHAR2 := FND_API.G_FALSE
61 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
62 , x_return_status OUT NOCOPY VARCHAR2
63 , x_msg_count OUT NOCOPY NUMBER
64 , x_msg_data OUT NOCOPY VARCHAR2
65 , p_qualifier_id IN NUMBER
66 );
67
68 END OZF_volume_offer_qual_PVT;
69