1 PACKAGE OZF_QUAL_MARKET_OPTION_PVT AS
2 /* $Header: ozfvqmos.pls 120.2 2005/08/24 06:28:24 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
14 -- End of Comments
15 -- ===============================================================
16
17 -- Default number of records fetch per call
18 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
19 --===================================================================
20 -- Start of Comments
21 -- -------------------------------------------------------
22 -- Record name
23 -- ozf_offer_line_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- qualifier_market_option_id
27 -- offer_market_option_id
28 -- precedence
29 -- qp_list_header_id
30 -- group_number
31 -- object_version_number
32 -- last_update_date
33 -- last_updated_by
34 -- creation_date
35 -- created_by
36 -- last_update_login
37 -- security_group_id
38 -- Required
39 --
40 -- Defaults
41 --
42 -- Note: This is automatic generated record definition, it includes all columns
43 -- defined in the table, developer must manually add or delete some of the attributes.
44 --
45 -- End of Comments
46
47 --===================================================================
48 TYPE qual_mo_rec_type IS RECORD
49 (
50 qualifier_market_option_id NUMBER
51 , offer_market_option_id NUMBER
52 , qp_qualifier_id NUMBER
53 , object_version_number NUMBER
54 , last_update_date DATE
55 , last_updated_by NUMBER
56 , creation_date DATE
57 , created_by NUMBER
58 , last_update_login NUMBER
59 , security_group_id NUMBER
60 );
61
62
63 g_miss_qual_mo_rec_type qual_mo_rec_type := NULL;
64 TYPE ozf_qual_mo_tbl_type IS TABLE OF qual_mo_rec_type INDEX BY BINARY_INTEGER;
65 g_miss_qual_mo_tbl ozf_qual_mo_tbl_type;
66
67 -- ==============================================================================
68 -- Start of Comments
69 -- ==============================================================================
70 -- API Name
71 -- Create_qual_market_options
72 -- Type
73 -- Private
74 -- Pre-Req
75 -- Parameters
76 --
77 -- IN
78 -- p_api_version_number IN NUMBER Required
79 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82 -- p_qual_mo_rec IN qual_mo_rec_type
83 -- OUT NOCOPY
84 -- x_return_status OUT NOCOPY VARCHAR2
85 -- x_msg_count OUT NOCOPY NUMBER
86 -- x_msg_data OUT NOCOPY VARCHAR2
87 -- x_vo_market_option_id OUT NOCOPY NUMBER. Market Option id of the market option just created
88 -- Version : Current version 1.0
89 --
90 -- History
91 -- Mon Jun 20 2005:3/33 PM RSSHARMA Created
92 --
93 -- Description
94 -- : Method to Create New Market Options.
95 -- End of Comments
96 -- ==============================================================================
97
98 PROCEDURE Create_qual_market_options(
99 p_api_version_number IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107
108 p_qual_mo_rec IN qual_mo_rec_type ,
109 x_qual_market_option_id OUT NOCOPY NUMBER
110 );
111
112
113 -- ==============================================================================
114 -- Start of Comments
115 -- ==============================================================================
116 -- API Name
117 -- update_qual_market_options
118 -- Type
119 -- Private
120 -- Pre-Req
121 -- validate_qual_market_options
122 -- Parameters
123 --
124 -- IN
125 -- p_api_version_number IN NUMBER Required
126 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129 -- p_qual_mo_rec IN qual_mo_rec_type Required Record Containing qualifier Market options Data
130 -- x_return_status OUT NOCOPY VARCHAR2
131 -- x_msg_count OUT NOCOPY NUMBER
132 -- x_msg_data OUT NOCOPY VARCHAR2
133 -- Version : Current version 1.0
134 --
135 -- History
136 -- Tue Jun 21 2005:3/2 PM RSSHARMA Created
137 --
138 -- Description
139 -- : Method to Update Qualifier MO Interface data
140 -- End of Comments
141 -- ==============================================================================
142 PROCEDURE update_qual_market_options(
143 p_api_version_number IN NUMBER
144 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145 , p_commit IN VARCHAR2 := FND_API.G_FALSE
146 , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
147
148 , x_return_status OUT NOCOPY VARCHAR2
149 , x_msg_count OUT NOCOPY VARCHAR2
150 , x_msg_data OUT NOCOPY VARCHAR2
151
152 , p_qual_mo_rec IN qual_mo_rec_type
153 );
154
155
156 -- ==============================================================================
157 -- Start of Comments
158 -- ==============================================================================
159 -- API Name
160 -- Delete_qual_market_options
161 -- Type
162 -- Private
163 -- Pre-Req
164 -- Parameters
165 --
166 -- IN
167 -- p_api_version_number IN NUMBER
168 -- p_init_msg_list IN VARCHAR2
169 -- p_commit IN VARCHAR2
170 -- p_validation_level IN NUMBER
171 -- p_qualifier_market_option_id IN NUMBER
172 -- p_object_version_number IN NUMBER
173
174 --
175 -- OUT NOCOPY
176 -- x_return_status OUT NOCOPY VARCHAR2
177 -- x_msg_count OUT NOCOPY NUMBER
178 -- x_msg_data OUT NOCOPY VARCHAR2
179
180 -- Version : Current version 1.0
181 --
182 -- History
183 -- Tue Jun 21 2005:3/25 PM RSSHARMA Created
184 --
185 -- Description
186 -- End of Comments
187 -- ==============================================================================
188 PROCEDURE Delete_qual_market_options(
189 p_api_version_number IN NUMBER
190 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191 , p_commit IN VARCHAR2 := FND_API.G_FALSE
192 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
193 , x_return_status OUT NOCOPY VARCHAR2
194 , x_msg_count OUT NOCOPY VARCHAR2
195 , x_msg_data OUT NOCOPY VARCHAR2
196 , p_qualifier_market_option_id IN NUMBER
197 , p_object_version_number IN NUMBER
198 );
199
200 END OZF_QUAL_MARKET_OPTION_PVT;
201