APPS.AHL_MC_RULES_PKG dependencies on AHL_MC_RULES_TL

Line 99: insert into AHL_MC_RULES_TL (

95: X_LAST_UPDATED_BY,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into AHL_MC_RULES_TL (
100: CREATED_BY,
101: LAST_UPDATE_LOGIN,
102: LAST_UPDATE_DATE,
103: LAST_UPDATED_BY,

Line 123: from AHL_MC_RULES_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from AHL_MC_RULES_TL T
124: where T.RULE_ID = X_RULE_ID
125: and T.LANGUAGE = L.LANGUAGE_CODE);
126:
127: open c;

Line 194: from AHL_MC_RULES_TL

190:
191: cursor c1 is select
192: DESCRIPTION,
193: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
194: from AHL_MC_RULES_TL
195: where RULE_ID = X_RULE_ID
196: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
197: for update of RULE_ID nowait;
198: begin

Line 331: update AHL_MC_RULES_TL set

327: if (sql%notfound) then
328: raise no_data_found;
329: end if;
330:
331: update AHL_MC_RULES_TL set
332: DESCRIPTION = X_DESCRIPTION,
333: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
334: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
335: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 349: delete from AHL_MC_RULES_TL

345: procedure DELETE_ROW (
346: X_RULE_ID in NUMBER
347: ) is
348: begin
349: delete from AHL_MC_RULES_TL
350: where RULE_ID = X_RULE_ID;
351:
352: if (sql%notfound) then
353: raise no_data_found;

Line 367: delete from AHL_MC_RULES_TL T

363:
364: procedure ADD_LANGUAGE
365: is
366: begin
367: delete from AHL_MC_RULES_TL T
368: where not exists
369: (select NULL
370: from AHL_MC_RULES_B B
371: where B.RULE_ID = T.RULE_ID

Line 374: update AHL_MC_RULES_TL T set (

370: from AHL_MC_RULES_B B
371: where B.RULE_ID = T.RULE_ID
372: );
373:
374: update AHL_MC_RULES_TL T set (
375: DESCRIPTION
376: ) = (select
377: B.DESCRIPTION
378: from AHL_MC_RULES_TL B

Line 378: from AHL_MC_RULES_TL B

374: update AHL_MC_RULES_TL T set (
375: DESCRIPTION
376: ) = (select
377: B.DESCRIPTION
378: from AHL_MC_RULES_TL B
379: where B.RULE_ID = T.RULE_ID
380: and B.LANGUAGE = T.SOURCE_LANG)
381: where (
382: T.RULE_ID,

Line 387: from AHL_MC_RULES_TL SUBB, AHL_MC_RULES_TL SUBT

383: T.LANGUAGE
384: ) in (select
385: SUBT.RULE_ID,
386: SUBT.LANGUAGE
387: from AHL_MC_RULES_TL SUBB, AHL_MC_RULES_TL SUBT
388: where SUBB.RULE_ID = SUBT.RULE_ID
389: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
390: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
391: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 395: insert into AHL_MC_RULES_TL (

391: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
392: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
393: ));
394:
395: insert into AHL_MC_RULES_TL (
396: CREATED_BY,
397: LAST_UPDATE_LOGIN,
398: LAST_UPDATE_DATE,
399: LAST_UPDATED_BY,

Line 415: from AHL_MC_RULES_TL B, FND_LANGUAGES L

411: B.RULE_ID,
412: B.DESCRIPTION,
413: L.LANGUAGE_CODE,
414: B.SOURCE_LANG
415: from AHL_MC_RULES_TL B, FND_LANGUAGES L
416: where L.INSTALLED_FLAG in ('I', 'B')
417: and B.LANGUAGE = userenv('LANG')
418: and not exists
419: (select NULL

Line 420: from AHL_MC_RULES_TL T

416: where L.INSTALLED_FLAG in ('I', 'B')
417: and B.LANGUAGE = userenv('LANG')
418: and not exists
419: (select NULL
420: from AHL_MC_RULES_TL T
421: where T.RULE_ID = B.RULE_ID
422: and T.LANGUAGE = L.LANGUAGE_CODE);
423: end ADD_LANGUAGE;
424: