[Home] [Help]
PACKAGE: APPS.OZF_OFFER_MARKET_OPTIONS_PVT
Source
1 PACKAGE OZF_offer_Market_Options_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvomos.pls 120.4 2005/08/24 06:17:39 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 -- Mon Jul 11 2005:7/4 PM RSSHARMA Added function get_combine_discounts to determine if combine schedules
14 -- should be eneabled in Market Options
15
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- ozf_offer_line_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- offer_market_option_id
29 -- offer_id
30 -- qp_list_header_id
31 -- group_number
32 -- retroactive_flag
33 -- beneficiary_party_id
34 -- combine_schedule_flag
35 -- volume_tracking_level_code
36 -- accrue_to_code
37 -- precedence
38 -- object_version_number
39 -- last_update_date
40 -- last_updated_by
41 -- creation_date
42 -- created_by
43 -- last_update_login
44 -- security_group_id
45 -- Required
46 --
47 -- Defaults
48 --
49 -- Note: This is automatic generated record definition, it includes all columns
50 -- defined in the table, developer must manually add or delete some of the attributes.
51 --
52 -- End of Comments
53
54 --===================================================================
55 TYPE vo_mo_rec_type IS RECORD
56 (
57 offer_market_option_id NUMBER
58 , offer_id NUMBER
59 , qp_list_header_id NUMBER
60 , group_number NUMBER
61 , retroactive_flag VARCHAR2(1)
62 , beneficiary_party_id NUMBER
63 , combine_schedule_flag VARCHAR2(1)
64 , volume_tracking_level_code VARCHAR2(30)
65 , accrue_to_code VARCHAR2(30)
66 , precedence NUMBER
67 , object_version_number NUMBER
68 , last_update_date DATE
69 , last_updated_by NUMBER
70 , creation_date DATE
71 , created_by NUMBER
72 , last_update_login NUMBER
73 , security_group_id NUMBER
74 );
75
76
77 g_miss_mo_rec_type vo_mo_rec_type := NULL;
78 TYPE ozf_vo_mo_tbl_type IS TABLE OF vo_mo_rec_type INDEX BY BINARY_INTEGER;
79 g_miss_mo_tbl ozf_vo_mo_tbl_type;
80
81 -- ==============================================================================
82 -- Start of Comments
83 -- ==============================================================================
84 -- API Name
85 -- Create_market_options
86 -- Type
87 -- Private
88 -- Pre-Req
89 -- Parameters
90 --
91 -- IN
92 -- p_api_version_number IN NUMBER Required
93 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
96 -- p_vo_mo_rec IN vo_mo_rec_type
97 -- OUT
98 -- x_return_status OUT NOCOPY VARCHAR2
99 -- x_msg_count OUT NOCOPY NUMBER
100 -- x_msg_data OUT NOCOPY VARCHAR2
101 -- x_vo_market_option_id OUT NOCOPY NUMBER. Market Option id of the market option just created
102 -- Version : Current version 1.0
103 --
104 -- History
105 -- Mon Jun 20 2005:3/33 PM RSSHARMA Created
106 --
107 -- Description
108 -- : Method to Create New Market Options.
109 -- End of Comments
110 -- ==============================================================================
111
112 PROCEDURE Create_market_options(
113 p_api_version_number IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121
122 p_mo_rec IN vo_mo_rec_type ,
123 x_vo_market_option_id OUT NOCOPY NUMBER
124 );
125
126
127 -- ==============================================================================
128 -- Start of Comments
129 -- ==============================================================================
130 -- API Name
131 -- Update_market_options
132 -- Type
133 -- Private
134 -- Pre-Req
135 -- validate_market_options
136 -- Parameters
137 --
138 -- IN
139 -- p_api_version_number IN NUMBER Required
140 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143 -- p_mo_rec IN vo_mo_rec_type Required Record Containing Market options Data
144 -- x_return_status OUT NOCOPY VARCHAR2
145 -- x_msg_count OUT NOCOPY NUMBER
146 -- x_msg_data OUT NOCOPY VARCHAR2
147 -- Version : Current version 1.0
148 --
149 -- History
150 -- Mon Jun 20 2005:7/56 PM Created
151 --
152 -- Description
153 -- : Method to Update Discount Lines.
154 -- End of Comments
155 -- ==============================================================================
156 PROCEDURE Update_market_options(
157 p_api_version_number IN NUMBER,
158 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159 p_commit IN VARCHAR2 := FND_API.G_FALSE,
160 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165
166 p_mo_rec IN vo_mo_rec_type
167 );
168
169 -- ==============================================================================
170 -- Start of Comments
171 -- ==============================================================================
172 -- API Name
173 -- Delete_market_options
174 -- Type
175 -- Private
176 -- Pre-Req
177 -- Parameters
178 --
179 -- IN
180 -- p_api_version_number IN NUMBER
181 -- p_init_msg_list IN VARCHAR2
182 -- p_commit IN VARCHAR2
183 -- p_validation_level IN NUMBER
184 -- p_offer_market_option_id IN NUMBER
185 -- p_object_version_number IN NUMBER
186
187 --
188 -- OUT
189 -- x_return_status OUT NOCOPY VARCHAR2
190 -- x_msg_count OUT NOCOPY NUMBER
191 -- x_msg_data OUT NOCOPY VARCHAR2
192
193 -- Version : Current version 1.0
194 --
195 -- History
196 -- Mon Jun 20 2005:7/55 PM Created
197 --
198 -- Description
199 -- End of Comments
200 -- ==============================================================================
201 PROCEDURE Delete_market_options(
202 p_api_version_number IN NUMBER,
203 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204 p_commit IN VARCHAR2 := FND_API.G_FALSE,
205 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_offer_market_option_id IN NUMBER,
210 p_object_version_number IN NUMBER
211 );
212
213 FUNCTION get_mo_name(p_qp_list_header_id IN NUMBER, p_qualifier_grouping_no IN NUMBER)
214 RETURN VARCHAR2;
215 FUNCTION get_combine_discounts(p_offer_id IN NUMBER)
216 RETURN VARCHAR2;
217
218 END OZF_offer_Market_Options_PVT;
219