APPS.OZF_NA_DDN_RULE_PKG dependencies on OZF_NA_DEDUCTION_RULES_TL

Line 89: INSERT INTO ozf_na_deduction_rules_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_deduction_rules_tl(
90: na_deduction_rule_id ,
91: language ,
92: last_update_date ,
93: last_updated_by ,

Line 114: AND NOT EXISTS(SELECT NULL FROM ozf_na_deduction_rules_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_deduction_rules_tl t
115: WHERE t.na_deduction_rule_id = DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id)
116: AND t.language = l.language_code);
117: END Insert_Row;
118:

Line 164: UPDATE ozf_na_deduction_rules_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_deduction_rule_id = p_na_deduction_rule_id
162: AND object_version_number = p_object_version_number;
163:
164: UPDATE ozf_na_deduction_rules_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 204: DELETE FROM ozf_na_deduction_rules_tl

200: BEGIN
201: DELETE FROM ozf_na_deduction_rules_b
202: WHERE na_deduction_rule_id = p_na_deduction_rule_id
203: AND object_version_number = p_object_version_number;
204: DELETE FROM ozf_na_deduction_rules_tl
205: WHERE na_deduction_rule_id = p_na_deduction_rule_id;
206:
207: If (SQL%NOTFOUND) then
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 270: delete from ozf_na_deduction_rules_tl T

266:
267: PROCEDURE Add_Language
268: IS
269: BEGIN
270: delete from ozf_na_deduction_rules_tl T
271: where not exists
272: (select NULL
273: from ozf_na_deduction_rules_b b
274: where b.na_deduction_rule_id = t.na_deduction_rule_id

Line 277: update ozf_na_deduction_rules_tl t set (

273: from ozf_na_deduction_rules_b b
274: where b.na_deduction_rule_id = t.na_deduction_rule_id
275: );
276:
277: update ozf_na_deduction_rules_tl t set (
278: name
279: , description
280: ) = (select
281: b.name

Line 283: from ozf_na_deduction_rules_tl b

279: , description
280: ) = (select
281: b.name
282: , b.description
283: from ozf_na_deduction_rules_tl b
284: where b.na_deduction_rule_id = t.na_deduction_rule_id
285: and b.language = t.source_lang)
286: where (
287: t.na_deduction_rule_id,

Line 292: from ozf_na_deduction_rules_tl subb, ozf_na_deduction_rules_tl subt

288: t.language
289: ) in (select
290: subt.na_deduction_rule_id,
291: subt.language
292: from ozf_na_deduction_rules_tl subb, ozf_na_deduction_rules_tl subt
293: where subb.na_deduction_rule_id = subt.na_deduction_rule_id
294: and subb.language = subt.source_lang
295: and (subb.name <> subt.name
296: or subb.description <> subt.description

Line 301: insert into ozf_na_deduction_rules_tl (

297: or (subb.description is null and subt.description is not null)
298: or (subb.description is not null and subt.description is null)
299: ));
300:
301: insert into ozf_na_deduction_rules_tl (
302: na_deduction_rule_id,
303: creation_date,
304: created_by,
305: last_update_date,

Line 323: from ozf_na_deduction_rules_tl b, fnd_languages l

319: b.name,
320: b.description,
321: l.language_code,
322: b.source_lang
323: from ozf_na_deduction_rules_tl b, fnd_languages l
324: where l.installed_flag in ('I', 'B')
325: and b.language = userenv('lang')
326: and not exists
327: (select null

Line 328: from ozf_na_deduction_rules_tl t

324: where l.installed_flag in ('I', 'B')
325: and b.language = userenv('lang')
326: and not exists
327: (select null
328: from ozf_na_deduction_rules_tl t
329: where t.na_deduction_rule_id = b.na_deduction_rule_id
330: and t.language = l.language_code);
331: END ADD_LANGUAGE;
332: