APPS.HZ_PARTY_USAGES_PKG dependencies on HZ_PARTY_USAGES_TL

Line 64: INSERT INTO hz_party_usages_tl (

60: x_last_update_date,
61: x_last_updated_by
62: );
63:
64: INSERT INTO hz_party_usages_tl (
65: party_usage_code,
66: language,
67: source_lang,
68: party_usage_name,

Line 91: FROM hz_party_usages_tl t

87: FROM fnd_languages l
88: WHERE l.installed_flag IN ('I', 'B')
89: AND NOT EXISTS (
90: SELECT NULL
91: FROM hz_party_usages_tl t
92: WHERE t.party_usage_code = x_party_usage_code
93: AND t.language = l.language_code
94: );
95:

Line 151: UPDATE hz_party_usages_tl

147: IF ( SQL%NOTFOUND ) THEN
148: RAISE NO_DATA_FOUND;
149: END IF;
150:
151: UPDATE hz_party_usages_tl
152: SET
153: party_usage_name =
154: DECODE(x_party_usage_name,
155: NULL, party_usage_name,

Line 179: DELETE FROM hz_party_usages_tl t

175: PROCEDURE add_language IS
176:
177: BEGIN
178:
179: DELETE FROM hz_party_usages_tl t
180: WHERE NOT EXISTS (
181: SELECT NULL
182: FROM hz_party_usages_b b
183: WHERE b.party_usage_code = t.party_usage_code

Line 186: UPDATE hz_party_usages_tl t

182: FROM hz_party_usages_b b
183: WHERE b.party_usage_code = t.party_usage_code
184: );
185:
186: UPDATE hz_party_usages_tl t
187: SET (
188: party_usage_name,
189: description
190: ) = (

Line 194: FROM hz_party_usages_tl b

190: ) = (
191: SELECT
192: b.party_usage_name,
193: b.description
194: FROM hz_party_usages_tl b
195: WHERE b.party_usage_code = t.party_usage_code
196: AND b.language = t.source_lang)
197: WHERE (
198: t.party_usage_code,

Line 204: FROM hz_party_usages_tl subb, hz_party_usages_tl subt

200: ) IN (
201: SELECT
202: subt.party_usage_code,
203: subt.language
204: FROM hz_party_usages_tl subb, hz_party_usages_tl subt
205: WHERE subb.party_usage_code = subt.party_usage_code
206: AND subb.language = subt.source_lang
207: AND (subb.party_usage_name <> subt.party_usage_name
208: OR subb.description <> subt.description

Line 213: INSERT INTO hz_party_usages_tl (

209: OR (subb.description IS NULL AND subt.description IS NOT NULL)
210: OR (subb.description IS NOT NULL and subt.description IS NULL)
211: ));
212:
213: INSERT INTO hz_party_usages_tl (
214: party_usage_code,
215: party_usage_name,
216: description,
217: created_by,

Line 236: FROM hz_party_usages_tl b, fnd_languages l

232: b.last_update_date,
233: b.last_updated_by,
234: l.language_code,
235: b.source_lang
236: FROM hz_party_usages_tl b, fnd_languages l
237: WHERE l.installed_flag IN ('I', 'B')
238: AND b.language = USERENV('LANG')
239: AND NOT EXISTS (
240: SELECT NULL

Line 241: FROM hz_party_usages_tl t

237: WHERE l.installed_flag IN ('I', 'B')
238: AND b.language = USERENV('LANG')
239: AND NOT EXISTS (
240: SELECT NULL
241: FROM hz_party_usages_tl t
242: WHERE t.party_usage_code = b.party_usage_code
243: AND t.language = l.language_code
244: );
245:

Line 306: UPDATE hz_party_usages_tl

302:
303: -- Translate char last_update_date to date
304: f_ludate := NVL(TO_DATE(x_last_update_date, 'YYYY/MM/DD'), sysdate);
305:
306: UPDATE hz_party_usages_tl
307: SET
308: party_usage_name =
309: DECODE(x_party_usage_name,
310: NULL, party_usage_name,