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 OZF_OFFR_DISC_STRUCT_NAME_TL

Line 22: delete from ozf_offr_disc_struct_name_tl T

18:
19: PROCEDURE Add_Language
20: IS
21: BEGIN
22: delete from ozf_offr_disc_struct_name_tl T
23: where not exists
24: (select NULL
25: from ozf_offr_disc_struct_name_b b
26: where b.offr_disc_struct_name_id = t.offr_disc_struct_name_id

Line 29: update ozf_offr_disc_struct_name_tl t set (

25: from ozf_offr_disc_struct_name_b b
26: where b.offr_disc_struct_name_id = t.offr_disc_struct_name_id
27: );
28:
29: update ozf_offr_disc_struct_name_tl t set (
30: discount_table_name
31: , description
32: ) = (select
33: b.discount_table_name

Line 35: from ozf_offr_disc_struct_name_tl b

31: , description
32: ) = (select
33: b.discount_table_name
34: , b.description
35: from ozf_offr_disc_struct_name_tl b
36: where b.offr_disc_struct_name_id = t.offr_disc_struct_name_id
37: and b.language = t.source_lang)
38: where (
39: t.offr_disc_struct_name_id,

Line 44: from ozf_offr_disc_struct_name_tl subb, ozf_offr_disc_struct_name_tl subt

40: t.language
41: ) in (select
42: subt.offr_disc_struct_name_id,
43: subt.language
44: from ozf_offr_disc_struct_name_tl subb, ozf_offr_disc_struct_name_tl subt
45: where subb.offr_disc_struct_name_id = subt.offr_disc_struct_name_id
46: and subb.language = subt.source_lang
47: and (subb.discount_table_name <> subt.discount_table_name
48: or subb.description <> subt.description

Line 53: insert into ozf_offr_disc_struct_name_tl (

49: or (subb.description is null and subt.description is not null)
50: or (subb.description is not null and subt.description is null)
51: ));
52:
53: insert into ozf_offr_disc_struct_name_tl (
54: offr_disc_struct_name_id,
55: creation_date,
56: created_by,
57: last_update_date,

Line 75: from ozf_offr_disc_struct_name_tl b, fnd_languages l

71: b.discount_table_name,
72: b.description,
73: l.language_code,
74: b.source_lang
75: from ozf_offr_disc_struct_name_tl b, fnd_languages l
76: where l.installed_flag in ('I', 'B')
77: and b.language = userenv('lang')
78: and not exists
79: (select null

Line 80: from ozf_offr_disc_struct_name_tl t

76: where l.installed_flag in ('I', 'B')
77: and b.language = userenv('lang')
78: and not exists
79: (select null
80: from ozf_offr_disc_struct_name_tl t
81: where t.offr_disc_struct_name_id = b.offr_disc_struct_name_id
82: and t.language = l.language_code);
83: END ADD_LANGUAGE;
84:

Line 137: INSERT INTO ozf_offr_disc_struct_name_tl(

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
139: , language
140: , last_update_date
141: , last_updated_by

Line 162: AND NOT EXISTS(SELECT NULL FROM ozf_offr_disc_struct_name_tl t

158: , p_name
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;

Line 205: UPDATE ozf_offr_disc_struct_name_tl

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:
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)

Line 243: DELETE FROM ozf_offr_disc_struct_name_tl

239: p_object_version_number NUMBER
240: )
241: IS
242: BEGIN
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;

Line 315: delete from ozf_offr_disc_struct_name_tl T

311: /*
312: PROCEDURE Add_Language
313: IS
314: BEGIN
315: delete from ozf_offr_disc_struct_name_tl T
316: where not exists
317: (select NULL
318: from ozf_offr_disc_struct_name_b b
319: where b.offr_disc_struct_name_id = t.offr_disc_struct_name_id

Line 322: update ozf_offr_disc_struct_name_tl t set (

318: from ozf_offr_disc_struct_name_b b
319: where b.offr_disc_struct_name_id = t.offr_disc_struct_name_id
320: );
321:
322: update ozf_offr_disc_struct_name_tl t set (
323: name
324: , description
325: ) = (select
326: b.name

Line 328: from ozf_offr_disc_struct_name_tl b

324: , description
325: ) = (select
326: b.name
327: , b.description
328: from ozf_offr_disc_struct_name_tl b
329: where b.offr_disc_struct_name_id = t.offr_disc_struct_name_id
330: and b.language = t.source_lang)
331: where (
332: t.offr_disc_struct_name_id,