APPS.OZF_OFFER_ADJUSTMENT_PKG dependencies on OZF_OFFER_ADJUSTMENTS_TL

Line 143: INSERT INTO ozf_offer_adjustments_tl(

139: p_attribute13,
140: p_attribute14,
141: p_attribute15);
142:
143: INSERT INTO ozf_offer_adjustments_tl(
144: offer_adjustment_id ,
145: language ,
146: last_update_date ,
147: last_updated_by ,

Line 168: AND NOT EXISTS(SELECT NULL FROM ozf_offer_adjustments_tl t

164: p_offer_adjustment_name,
165: p_description
166: FROM fnd_languages l
167: WHERE l.installed_flag IN ('I','B')
168: AND NOT EXISTS(SELECT NULL FROM ozf_offer_adjustments_tl t
169: WHERE t.offer_adjustment_id = DECODE( px_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_id)
170: AND t.language = l.language_code);
171: END Insert_Row;
172:

Line 254: UPDATE ozf_offer_adjustments_tl

250: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
251: WHERE offer_adjustment_id = p_offer_adjustment_id
252: AND object_version_number = px_object_version_number;
253:
254: UPDATE ozf_offer_adjustments_tl
255: set offer_adjustment_name = DECODE( p_offer_adjustment_name, null, offer_adjustment_name, FND_API.g_miss_char, null, p_offer_adjustment_name),
256: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
257: 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),
258: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 293: DELETE FROM ozf_offer_adjustments_tl

289: p_object_version_number NUMBER)
290: IS
291: BEGIN
292:
293: DELETE FROM ozf_offer_adjustments_tl
294: WHERE offer_adjustment_id = p_offer_adjustment_id;
295: If (SQL%NOTFOUND) then
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297: End If;

Line 365: delete from ozf_offer_adjustments_tl T

361:
362: PROCEDURE Add_Language
363: IS
364: BEGIN
365: delete from ozf_offer_adjustments_tl T
366: where not exists
367: (select NULL
368: from ozf_offer_adjustments_b b
369: where b.offer_adjustment_id = t.offer_adjustment_id

Line 372: update ozf_offer_adjustments_tl t set (

368: from ozf_offer_adjustments_b b
369: where b.offer_adjustment_id = t.offer_adjustment_id
370: );
371:
372: update ozf_offer_adjustments_tl t set (
373: offer_adjustment_name
374: , description
375: ) = (select
376: b.offer_adjustment_name

Line 378: from ozf_offer_adjustments_tl b

374: , description
375: ) = (select
376: b.offer_adjustment_name
377: , b.description
378: from ozf_offer_adjustments_tl b
379: where b.offer_adjustment_id = t.offer_adjustment_id
380: and b.language = t.source_lang)
381: where (
382: t.offer_adjustment_id,

Line 387: from ozf_offer_adjustments_tl subb, ozf_offer_adjustments_tl subt

383: t.language
384: ) in (select
385: subt.offer_adjustment_id,
386: subt.language
387: from ozf_offer_adjustments_tl subb, ozf_offer_adjustments_tl subt
388: where subb.offer_adjustment_id = subt.offer_adjustment_id
389: and subb.language = subt.source_lang
390: and (subb.offer_adjustment_name <> subt.offer_adjustment_name
391: or subb.description <> subt.description

Line 396: insert into ozf_offer_adjustments_tl (

392: or (subb.description is null and subt.description is not null)
393: or (subb.description is not null and subt.description is null)
394: ));
395:
396: insert into ozf_offer_adjustments_tl (
397: offer_adjustment_id,
398: creation_date,
399: created_by,
400: last_update_date,

Line 418: from ozf_offer_adjustments_tl b, fnd_languages l

414: b.offer_adjustment_name,
415: b.description,
416: l.language_code,
417: b.source_lang
418: from ozf_offer_adjustments_tl b, fnd_languages l
419: where l.installed_flag in ('I', 'B')
420: and b.language = userenv('lang')
421: and not exists
422: (select null

Line 423: from ozf_offer_adjustments_tl t

419: where l.installed_flag in ('I', 'B')
420: and b.language = userenv('lang')
421: and not exists
422: (select null
423: from ozf_offer_adjustments_tl t
424: where t.offer_adjustment_id = b.offer_adjustment_id
425: and t.language = l.language_code);
426: END ADD_LANGUAGE;
427: