APPS.HZ_MATCH_RULES_PKG dependencies on HZ_MATCH_RULES_TL

Line 105: insert into HZ_MATCH_RULES_TL (

101: END IF;
102: END;
103: END LOOP;
104:
105: insert into HZ_MATCH_RULES_TL (
106: LAST_UPDATE_DATE,
107: CREATION_DATE,
108: CREATED_BY,
109: DESCRIPTION,

Line 133: from HZ_MATCH_RULES_TL T

129: from FND_LANGUAGES L
130: where L.INSTALLED_FLAG in ('I', 'B')
131: and not exists
132: (select NULL
133: from HZ_MATCH_RULES_TL T
134: where T.MATCH_RULE_ID = X_MATCH_RULE_ID
135: and T.LANGUAGE = L.LANGUAGE_CODE);
136:
137:

Line 265: update HZ_MATCH_RULES_TL set

261: if (sql%notfound) then
262: raise no_data_found;
263: end if;
264:
265: update HZ_MATCH_RULES_TL set
266: RULE_NAME = X_RULE_NAME,
267: DESCRIPTION = X_DESCRIPTION,
268: LAST_UPDATE_DATE =hz_utility_v2pub.last_update_date,
269: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 312: delete from HZ_MATCH_RULES_TL

308: WHERE MATCH_RULE_ID = X_MATCH_RULE_ID;
309:
310: -- End of changes for Bug 3962742
311:
312: delete from HZ_MATCH_RULES_TL
313: where MATCH_RULE_ID = X_MATCH_RULE_ID;
314:
315: if (sql%notfound) then
316: raise no_data_found;

Line 330: delete from HZ_MATCH_RULES_TL T

326:
327: procedure ADD_LANGUAGE
328: is
329: begin
330: delete from HZ_MATCH_RULES_TL T
331: where not exists
332: (select NULL
333: from HZ_MATCH_RULES_B B
334: where B.MATCH_RULE_ID = T.MATCH_RULE_ID

Line 337: update HZ_MATCH_RULES_TL T set (

333: from HZ_MATCH_RULES_B B
334: where B.MATCH_RULE_ID = T.MATCH_RULE_ID
335: );
336:
337: update HZ_MATCH_RULES_TL T set (
338: RULE_NAME,
339: DESCRIPTION
340: ) = (select
341: B.RULE_NAME,

Line 343: from HZ_MATCH_RULES_TL B

339: DESCRIPTION
340: ) = (select
341: B.RULE_NAME,
342: B.DESCRIPTION
343: from HZ_MATCH_RULES_TL B
344: where B.MATCH_RULE_ID = T.MATCH_RULE_ID
345: and B.LANGUAGE = T.SOURCE_LANG)
346: where (
347: T.MATCH_RULE_ID,

Line 352: from HZ_MATCH_RULES_TL SUBB, HZ_MATCH_RULES_TL SUBT

348: T.LANGUAGE
349: ) in (select
350: SUBT.MATCH_RULE_ID,
351: SUBT.LANGUAGE
352: from HZ_MATCH_RULES_TL SUBB, HZ_MATCH_RULES_TL SUBT
353: where SUBB.MATCH_RULE_ID = SUBT.MATCH_RULE_ID
354: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
355: and (SUBB.RULE_NAME <> SUBT.RULE_NAME
356: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 361: insert into HZ_MATCH_RULES_TL (

357: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
358: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
359: ));
360:
361: insert into HZ_MATCH_RULES_TL (
362: LAST_UPDATE_DATE,
363: CREATION_DATE,
364: CREATED_BY,
365: DESCRIPTION,

Line 383: from HZ_MATCH_RULES_TL B, FND_LANGUAGES L

379: B.LAST_UPDATED_BY,
380: B.LAST_UPDATE_LOGIN,
381: L.LANGUAGE_CODE,
382: B.SOURCE_LANG
383: from HZ_MATCH_RULES_TL B, FND_LANGUAGES L
384: where L.INSTALLED_FLAG in ('I', 'B')
385: and B.LANGUAGE = userenv('LANG')
386: and L.LANGUAGE_CODE <> B.LANGUAGE
387: and not exists

Line 389: from HZ_MATCH_RULES_TL T

385: and B.LANGUAGE = userenv('LANG')
386: and L.LANGUAGE_CODE <> B.LANGUAGE
387: and not exists
388: (select NULL
389: from HZ_MATCH_RULES_TL T
390: where T.MATCH_RULE_ID = B.MATCH_RULE_ID
391: and T.LANGUAGE = L.LANGUAGE_CODE);
392: end ADD_LANGUAGE;
393:

Line 487: UPDATE hz_match_rules_tl set

483:
484: begin
485:
486: -- only update rows that have not been altered by user
487: UPDATE hz_match_rules_tl set
488: RULE_NAME = X_RULE_NAME,
489: DESCRIPTION = X_DESCRIPTION,
490: source_lang = userenv('LANG'),
491: last_update_date = sysdate,