eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_VO_DISC_STRUCT_NAME_PKG dependencies on FND_API

Line 129: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)

125: , last_update_login
126: ) VALUES (
127: px_offr_disc_struct_name_id
128: , p_offer_discount_line_id
129: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)

Line 130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)

126: ) VALUES (
127: px_offr_disc_struct_name_id
128: , p_offer_discount_line_id
129: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

Line 131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)

127: px_offr_disc_struct_name_id
128: , p_offer_discount_line_id
129: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
135: );

Line 132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)

128: , p_offer_discount_line_id
129: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
135: );
136:

Line 133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)

129: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
135: );
136:
137: INSERT INTO ozf_offr_disc_struct_name_tl(

Line 134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
135: );
136:
137: INSERT INTO ozf_offr_disc_struct_name_tl(
138: offr_disc_struct_name_id

Line 163: WHERE t.offr_disc_struct_name_id = DECODE( px_offr_disc_struct_name_id, FND_API.G_MISS_NUM, NULL, px_offr_disc_struct_name_id)

159: , p_description
160: FROM fnd_languages l
161: WHERE l.installed_flag IN ('I','B')
162: AND NOT EXISTS(SELECT NULL FROM ozf_offr_disc_struct_name_tl t
163: WHERE t.offr_disc_struct_name_id = DECODE( px_offr_disc_struct_name_id, FND_API.G_MISS_NUM, NULL, px_offr_disc_struct_name_id)
164: AND t.language = l.language_code);
165:
166: END Insert_Row;
167:

Line 196: offr_disc_struct_name_id = DECODE( p_offr_disc_struct_name_id, null, offr_disc_struct_name_id, FND_API.G_MISS_NUM, null, p_offr_disc_struct_name_id)

192: IS
193: BEGIN
194: Update ozf_offr_disc_struct_name_b
195: SET
196: offr_disc_struct_name_id = DECODE( p_offr_disc_struct_name_id, null, offr_disc_struct_name_id, FND_API.G_MISS_NUM, null, p_offr_disc_struct_name_id)
197: , offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id)
198: , 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)
199: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
200: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 197: , offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id)

193: BEGIN
194: Update ozf_offr_disc_struct_name_b
195: SET
196: offr_disc_struct_name_id = DECODE( p_offr_disc_struct_name_id, null, offr_disc_struct_name_id, FND_API.G_MISS_NUM, null, p_offr_disc_struct_name_id)
197: , offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id)
198: , 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)
199: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
200: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
201: , object_version_number = object_version_number + 1

Line 198: , 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)

194: Update ozf_offr_disc_struct_name_b
195: SET
196: offr_disc_struct_name_id = DECODE( p_offr_disc_struct_name_id, null, offr_disc_struct_name_id, FND_API.G_MISS_NUM, null, p_offr_disc_struct_name_id)
197: , offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id)
198: , 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)
199: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
200: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
201: , object_version_number = object_version_number + 1
202: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id

Line 199: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)

195: SET
196: offr_disc_struct_name_id = DECODE( p_offr_disc_struct_name_id, null, offr_disc_struct_name_id, FND_API.G_MISS_NUM, null, p_offr_disc_struct_name_id)
197: , offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id)
198: , 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)
199: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
200: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
201: , object_version_number = object_version_number + 1
202: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id
203: AND object_version_number = px_object_version_number;

Line 200: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

196: offr_disc_struct_name_id = DECODE( p_offr_disc_struct_name_id, null, offr_disc_struct_name_id, FND_API.G_MISS_NUM, null, p_offr_disc_struct_name_id)
197: , offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id)
198: , 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)
199: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
200: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
201: , object_version_number = object_version_number + 1
202: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id
203: AND object_version_number = px_object_version_number;
204:

Line 206: set discount_table_name = DECODE( p_name, null, discount_table_name, FND_API.g_miss_char, null, p_name)

202: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id
203: AND object_version_number = px_object_version_number;
204:
205: UPDATE ozf_offr_disc_struct_name_tl
206: set discount_table_name = DECODE( p_name, null, discount_table_name, FND_API.g_miss_char, null, p_name)
207: , description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description)
208: , 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)
209: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
210: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 207: , description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description)

203: AND object_version_number = px_object_version_number;
204:
205: UPDATE ozf_offr_disc_struct_name_tl
206: set discount_table_name = DECODE( p_name, null, discount_table_name, FND_API.g_miss_char, null, p_name)
207: , description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description)
208: , 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)
209: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
210: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
211: , source_lang = USERENV('LANG')

Line 208: , 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)

204:
205: UPDATE ozf_offr_disc_struct_name_tl
206: set discount_table_name = DECODE( p_name, null, discount_table_name, FND_API.g_miss_char, null, p_name)
207: , description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description)
208: , 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)
209: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
210: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
211: , source_lang = USERENV('LANG')
212: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id

Line 209: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)

205: UPDATE ozf_offr_disc_struct_name_tl
206: set discount_table_name = DECODE( p_name, null, discount_table_name, FND_API.g_miss_char, null, p_name)
207: , description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description)
208: , 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)
209: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
210: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
211: , source_lang = USERENV('LANG')
212: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id
213: AND USERENV('LANG') IN (language, source_lang);

Line 210: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

206: set discount_table_name = DECODE( p_name, null, discount_table_name, FND_API.g_miss_char, null, p_name)
207: , description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description)
208: , 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)
209: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
210: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
211: , source_lang = USERENV('LANG')
212: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id
213: AND USERENV('LANG') IN (language, source_lang);
214:

Line 216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

212: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id
213: AND USERENV('LANG') IN (language, source_lang);
214:
215: IF (SQL%NOTFOUND) THEN
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;
218:
219: px_object_version_number := nvl(px_object_version_number,0) + 1;
220:

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243: DELETE FROM ozf_offr_disc_struct_name_tl
244: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id;
245:
246: If (SQL%NOTFOUND) then
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: End If;
249:
250: DELETE FROM ozf_offr_disc_struct_name_b
251: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id

Line 255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

251: WHERE offr_disc_struct_name_id = p_offr_disc_struct_name_id
252: AND object_version_number = p_object_version_number;
253:
254: If (SQL%NOTFOUND) then
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: End If;
257: END Delete_Row ;
258:
259:

Line 291: RAISE FND_API.g_exc_error;

287: FETCH c INTO Recinfo;
288: IF (c%NOTFOUND) THEN
289: CLOSE c;
290: OZF_Utility_PVT.error_message ('OZF_API_RECORD_NOT_FOUND');
291: RAISE FND_API.g_exc_error;
292: END IF;
293: CLOSE c;
294: END Lock_Row;
295: