APPS.HZ_WORD_RPL_CONDS_PKG dependencies on HZ_WORD_RPL_CONDS_TL

Line 61: INSERT INTO HZ_WORD_RPL_CONDS_TL (

57: FND_API.G_MISS_NUM, NULL,
58: x_object_version_number)
59: ) ;
60:
61: INSERT INTO HZ_WORD_RPL_CONDS_TL (
62: condition_id,
63: condition_name,
64: condition_description,
65: last_update_date,

Line 90: from HZ_WORD_RPL_CONDS_TL T

86: FROM FND_LANGUAGES L
87: where L.INSTALLED_FLAG in ('I', 'B')
88: and not exists
89: (select NULL
90: from HZ_WORD_RPL_CONDS_TL T
91: where T.CONDITION_ID = X_CONDITION_ID
92: and T.LANGUAGE = L.LANGUAGE_CODE);
93: l_success := 'Y';
94: END;

Line 129: update HZ_WORD_RPL_CONDS_TL set

125: if (sql%notfound) then
126: raise no_data_found;
127: end if;
128:
129: update HZ_WORD_RPL_CONDS_TL set
130: condition_name = x_condition_name,
131: condition_description = x_condition_description,
132: object_version_number = p_object_version_number,
133: last_update_date = hz_utility_v2pub.last_update_date,

Line 161: delete from HZ_WORD_RPL_CONDS_TL

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: delete from HZ_WORD_RPL_CONDS_TL
162: where condition_id = x_condition_id ;
163:
164: if (sql%notfound) then
165: raise no_data_found;

Line 213: delete from HZ_WORD_RPL_CONDS_TL T

209:
210: procedure Add_Language
211: IS
212: BEGIN
213: delete from HZ_WORD_RPL_CONDS_TL T
214: where not exists
215: (select NULL
216: from HZ_WORD_RPL_CONDS_B B
217: where B.condition_id = T.condition_id

Line 220: update HZ_WORD_RPL_CONDS_TL T set (

216: from HZ_WORD_RPL_CONDS_B B
217: where B.condition_id = T.condition_id
218: );
219:
220: update HZ_WORD_RPL_CONDS_TL T set (
221: condition_name,
222: condition_description,
223: object_version_number ------> VJN Introduced for Bug 4397811
224: ) = (select

Line 228: from HZ_WORD_RPL_CONDS_TL B

224: ) = (select
225: B.condition_name,
226: B.condition_description,
227: NVL(T.object_version_number, 1) + 1 ------> VJN Introduced for Bug 4397811
228: from HZ_WORD_RPL_CONDS_TL B
229: where B.condition_id = T.condition_id
230: and B.language = T.source_lang)
231: where (
232: T.condition_id,

Line 237: from HZ_WORD_RPL_CONDS_TL SUBB, HZ_WORD_RPL_CONDS_TL SUBT

233: T.language
234: ) in (select
235: SUBT.condition_id,
236: SUBT.language
237: from HZ_WORD_RPL_CONDS_TL SUBB, HZ_WORD_RPL_CONDS_TL SUBT
238: where SUBB.condition_id = SUBT.condition_id
239: and SUBB.language = SUBT.source_lang
240: and (SUBB.condition_name <> SUBT.condition_name
241: or SUBB.condition_description <> SUBT.condition_description

Line 246: insert into HZ_WORD_RPL_CONDS_TL (

242: or (SUBB.condition_description is null and SUBT.condition_description is not null)
243: or (SUBB.condition_description is not null and SUBT.condition_description is null)
244: ));
245:
246: insert into HZ_WORD_RPL_CONDS_TL (
247: LAST_UPDATE_DATE,
248: CREATION_DATE,
249: CREATED_BY,
250: CONDITION_DESCRIPTION,

Line 270: from HZ_WORD_RPL_CONDS_TL B, FND_LANGUAGES L

266: B.LAST_UPDATE_LOGIN,
267: L.LANGUAGE_CODE,
268: B.SOURCE_LANG,
269: 1 ------> VJN Introduced for Bug 4397811
270: from HZ_WORD_RPL_CONDS_TL B, FND_LANGUAGES L
271: where L.INSTALLED_FLAG in ('I', 'B')
272: and B.LANGUAGE = userenv('LANG')
273: and not exists
274: (select NULL

Line 275: from HZ_WORD_RPL_CONDS_TL T

271: where L.INSTALLED_FLAG in ('I', 'B')
272: and B.LANGUAGE = userenv('LANG')
273: and not exists
274: (select NULL
275: from HZ_WORD_RPL_CONDS_TL T
276: where T.condition_id = B.condition_id
277: and T.language = L.language_code );
278: END ;
279:

Line 372: UPDATE HZ_WORD_RPL_CONDS_TL set

368: x_owner in VARCHAR2)
369: IS
370: BEGIN
371:
372: UPDATE HZ_WORD_RPL_CONDS_TL set
373: condition_name = x_condition_name,
374: condition_description = x_condition_description,
375: source_lang = userenv('LANG'),
376: last_update_date = sysdate,