APPS.AME_RULES_API2 dependencies on AME_RULES_TL

Line 335: insert into AME_RULES_TL

331: if sql%found then
332: if not AME_SEED_UTILITY.MLS_ENABLED then
333: return;
334: end if;
335: insert into AME_RULES_TL
336: (RULE_ID
337: ,DESCRIPTION
338: ,CREATED_BY
339: ,CREATION_DATE

Line 357: from AME_RULES_TL T

353: userenv('LANG')
354: from FND_LANGUAGES L
355: where L.INSTALLED_FLAG in ('I', 'B')
356: and not exists (select null
357: from AME_RULES_TL T
358: where T.RULE_ID = X_RULE_ID
359: and T.LANGUAGE = L.LANGUAGE_CODE);
360: end if;
361: end if;

Line 428: insert into AME_RULES_TL

424: if sql%found then
425: if not AME_SEED_UTILITY.MLS_ENABLED then
426: return;
427: end if;
428: insert into AME_RULES_TL
429: (RULE_ID
430: ,DESCRIPTION
431: ,CREATED_BY
432: ,CREATION_DATE

Line 450: from AME_RULES_TL T

446: userenv('LANG')
447: from FND_LANGUAGES L
448: where L.INSTALLED_FLAG in ('I', 'B')
449: and not exists (select null
450: from AME_RULES_TL T
451: where T.RULE_ID = X_RULE_ID
452: and T.LANGUAGE = L.LANGUAGE_CODE);
453: end if;
454: end if;

Line 462: delete from AME_RULES_TL

458: X_RULE_KEY in VARCHAR2
459: ) is
460: begin
461: if AME_SEED_UTILITY.MLS_ENABLED then
462: delete from AME_RULES_TL
463: where RULE_ID in (select RULE_ID
464: from AME_RULES
465: where RULE_KEY = X_RULE_KEY);
466: end if;

Line 659: AME_RULES_TL ARUTL

655: X_CURRENT_LAST_UPDATE_DATE,
656: X_CREATED_BY,
657: X_RULE_ID
658: from AME_RULES ARU,
659: AME_RULES_TL ARUTL
660: where ARU.RULE_KEY = X_RULE_KEY
661: and sysdate between ARU.START_DATE and nvl(ARU.END_DATE - (1/86400),sysdate)
662: and ARUTL.RULE_ID = ARU.RULE_ID
663: and ARUTL.LANGUAGE = userenv('LANG');

Line 671: update AME_RULES_TL ARUTL

667: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
668: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
669: X_CREATED_BY => X_CREATED_BY,
670: X_CUSTOM_MODE => X_CUSTOM_MODE) then
671: update AME_RULES_TL ARUTL
672: set DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
673: SOURCE_LANG = userenv('LANG'),
674: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
675: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),