[Home] [Help]
PACKAGE BODY: APPS.OZF_OFFR_MARKET_OPTION_PKG
Source
1 PACKAGE BODY OZF_OFFR_MARKET_OPTION_PKG as
2 /* $Header: ozftomob.pls 120.1 2005/08/24 02:59:31 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_OFFR_MARKET_OPTION_PKG
7 -- Purpose
8 --
9 -- History
10 -- Wed May 18 2005:11/57 AM RSSHARMA Added Insert_row and Update_row for Volume Offers
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19
20 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_OFFR_MARKET_OPTION_PKG';
21 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftomob.pls';
22
23
24
25
26 -- ========================================================
27 --
28 -- NAME
29 -- Insert_Row
30 --
31 -- PURPOSE
32 --
33 -- NOTES
34 --
35 -- HISTORY
36 --
37 -- ========================================================
38 PROCEDURE Insert_Row(
39 px_offer_market_option_id IN OUT NOCOPY NUMBER
40 , p_offer_id NUMBER
41 , p_qp_list_header_id NUMBER
42 , p_group_number NUMBER
43 , p_retroactive_flag VARCHAR2
44 , p_beneficiary_party_id NUMBER
45 , p_combine_schedule_flag VARCHAR2
46 , p_volume_tracking_level_code VARCHAR2
47 , p_accrue_to_code VARCHAR2
48 , p_precedence NUMBER
49 , px_object_version_number IN OUT NOCOPY NUMBER
50 , p_creation_date DATE
51 , p_created_by NUMBER
52 , p_last_update_date DATE
53 , p_last_updated_by NUMBER
54 , p_last_update_login NUMBER
55 )
56 IS
57 x_rowid VARCHAR2(30);
58
59
60 BEGIN
61
62
63 px_object_version_number := nvl(px_object_version_number, 1);
64
65
66 INSERT INTO ozf_offr_market_options(
67 offer_market_option_id
68 , offer_id
69 , qp_list_header_id
70 , group_number
71 , retroactive_flag
72 , beneficiary_party_id
73 , combine_schedule_flag
74 , volume_tracking_level_code
75 , accrue_to_code
76 , precedence
77 , object_version_number
78 , last_update_date
79 , last_updated_by
80 , creation_date
81 , created_by
82 , last_update_login
83 )
84 VALUES
85 (
86 DECODE( px_offer_market_option_id, FND_API.G_MISS_NUM, NULL, px_offer_market_option_id)
87 , DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id)
88 , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)
89 , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90 , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91 , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92 , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93 , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94 , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95 , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96 , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97 , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98 , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
99 , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
100 , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
101 , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
102 );
103
104 END Insert_Row;
105
106
107 -- ========================================================
108 --
109 -- NAME
110 -- Update_Row
111 --
112 -- PURPOSE
113 --
114 -- NOTES
115 --
116 -- HISTORY
117 --
118 -- ========================================================
119 PROCEDURE Update_Row(
120 p_offer_market_option_id NUMBER
121 , p_offer_id NUMBER
122 , p_qp_list_header_id NUMBER
123 , p_group_number NUMBER
124 , p_retroactive_flag VARCHAR2
125 , p_beneficiary_party_id NUMBER
126 , p_combine_schedule_flag VARCHAR2
127 , p_volume_tracking_level_code VARCHAR2
128 , p_accrue_to_code VARCHAR2
129 , p_precedence NUMBER
130 , p_object_version_number NUMBER
131 , p_creation_date DATE
132 , p_created_by NUMBER
133 , p_last_update_date DATE
134 , p_last_updated_by NUMBER
135 , p_last_update_login NUMBER
136 )
137
138 IS
139 BEGIN
140 Update ozf_offr_market_options
141 SET
142 offer_market_option_id = DECODE( p_offer_market_option_id, null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id),
143 offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
144 qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
145 group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146 retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147 beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148 combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149 volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150 accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151 precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
152 last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
153 last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
154 last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
155 object_version_number = nvl(p_object_version_number,0) + 1
156 WHERE offer_market_option_id = p_offer_market_option_id
157 AND object_version_number = p_object_version_number;
158
159
160 IF (SQL%NOTFOUND) THEN
161 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162 END IF;
163
164
165 END Update_Row;
166
167 -- ========================================================
168 --
169 -- NAME
170 -- Delete_Row
171 --
172 -- PURPOSE
173 --
174 -- NOTES
175 --
176 -- HISTORY
177 --
178 -- ========================================================
179 PROCEDURE Delete_Row(
180 p_offer_market_option_id NUMBER,
181 p_object_version_number NUMBER)
182 IS
183 BEGIN
184 DELETE FROM ozf_offr_market_options
185 WHERE offer_market_option_id = p_offer_market_option_id
186 AND object_version_number = p_object_version_number;
187 If (SQL%NOTFOUND) then
188 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189 End If;
190 END Delete_Row ;
191
192
193 -- ========================================================
194 --
195 -- NAME
196 -- Lock_Row
197 --
198 -- PURPOSE
199 --
200 -- NOTES
201 --
202 -- HISTORY
203 --
204 -- ========================================================
205 PROCEDURE Lock_Row(
206 p_offer_market_option_id NUMBER,
207 p_object_version_number NUMBER)
208 IS
209 CURSOR C IS
210 SELECT *
211 FROM ozf_offr_market_options
212 WHERE offer_market_option_id = p_offer_market_option_id
213 AND object_version_number = p_object_version_number
214 FOR UPDATE OF offer_market_option_id NOWAIT;
215 Recinfo C%ROWTYPE;
216 BEGIN
217
218 OPEN c;
219 FETCH c INTO Recinfo;
220 IF (c%NOTFOUND) THEN
221 CLOSE c;
222 AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
223 RAISE FND_API.g_exc_error;
224 END IF;
225 CLOSE c;
226 END Lock_Row;
227
228
229
230 END OZF_OFFR_MARKET_OPTION_PKG;