APPS.OZF_NA_RULE_HEADER_PKG dependencies on OZF_NA_RULE_HEADERS_TL

Line 89: INSERT INTO ozf_na_rule_headers_tl(

85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
88:
89: INSERT INTO ozf_na_rule_headers_tl(
90: na_rule_header_id ,
91: language ,
92: last_update_date ,
93: last_updated_by ,

Line 114: AND NOT EXISTS(SELECT NULL FROM ozf_na_rule_headers_tl t

110: DECODE( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
112: FROM fnd_languages l
113: WHERE l.installed_flag IN ('I','B')
114: AND NOT EXISTS(SELECT NULL FROM ozf_na_rule_headers_tl t
115: WHERE t.na_rule_header_id = DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id)
116: AND t.language = l.language_code);
117: END Insert_Row;
118:

Line 164: UPDATE ozf_na_rule_headers_tl

160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
161: WHERE na_rule_header_id = p_na_rule_header_id
162: AND object_version_number = p_object_version_number;
163:
164: UPDATE ozf_na_rule_headers_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: 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),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 208: DELETE FROM ozf_na_rule_headers_tl

204: If (SQL%NOTFOUND) then
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: End If;
207:
208: DELETE FROM ozf_na_rule_headers_tl
209: WHERE na_rule_header_id = p_na_rule_header_id;
210:
211: If (SQL%NOTFOUND) then
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 275: delete from ozf_na_rule_headers_tl T

271:
272: PROCEDURE Add_Language
273: IS
274: BEGIN
275: delete from ozf_na_rule_headers_tl T
276: where not exists
277: (select NULL
278: from ozf_na_rule_headers_b b
279: where b.na_rule_header_id = t.na_rule_header_id

Line 282: update ozf_na_rule_headers_tl t set (

278: from ozf_na_rule_headers_b b
279: where b.na_rule_header_id = t.na_rule_header_id
280: );
281:
282: update ozf_na_rule_headers_tl t set (
283: name
284: , description
285: ) = (select
286: b.name

Line 288: from ozf_na_rule_headers_tl b

284: , description
285: ) = (select
286: b.name
287: , b.description
288: from ozf_na_rule_headers_tl b
289: where b.na_rule_header_id = t.na_rule_header_id
290: and b.language = t.source_lang)
291: where (
292: t.na_rule_header_id,

Line 297: from ozf_na_rule_headers_tl subb, ozf_na_rule_headers_tl subt

293: t.language
294: ) in (select
295: subt.na_rule_header_id,
296: subt.language
297: from ozf_na_rule_headers_tl subb, ozf_na_rule_headers_tl subt
298: where subb.na_rule_header_id = subt.na_rule_header_id
299: and subb.language = subt.source_lang
300: and (subb.name <> subt.name
301: or subb.description <> subt.description

Line 306: insert into ozf_na_rule_headers_tl (

302: or (subb.description is null and subt.description is not null)
303: or (subb.description is not null and subt.description is null)
304: ));
305:
306: insert into ozf_na_rule_headers_tl (
307: na_rule_header_id,
308: creation_date,
309: created_by,
310: last_update_date,

Line 328: from ozf_na_rule_headers_tl b, fnd_languages l

324: b.name,
325: b.description,
326: l.language_code,
327: b.source_lang
328: from ozf_na_rule_headers_tl b, fnd_languages l
329: where l.installed_flag in ('I', 'B')
330: and b.language = userenv('lang')
331: and not exists
332: (select null

Line 333: from ozf_na_rule_headers_tl t

329: where l.installed_flag in ('I', 'B')
330: and b.language = userenv('lang')
331: and not exists
332: (select null
333: from ozf_na_rule_headers_tl t
334: where t.na_rule_header_id = b.na_rule_header_id
335: and t.language = l.language_code);
336: END ADD_LANGUAGE;
337: