APPS.AMS_OBJECT_RULES_PKG dependencies on AMS_OBJECT_RULES_TL

Line 125: insert into AMS_OBJECT_RULES_TL (

121: X_LAST_UPDATED_BY,
122: X_LAST_UPDATE_LOGIN
123: );
124:
125: insert into AMS_OBJECT_RULES_TL (
126: OBJECT_RULE_ID,
127: LAST_UPDATE_DATE,
128: LAST_UPDATED_BY,
129: CREATION_DATE,

Line 153: from AMS_OBJECT_RULES_TL T

149: from FND_LANGUAGES L
150: where L.INSTALLED_FLAG in ('I', 'B')
151: and not exists
152: (select NULL
153: from AMS_OBJECT_RULES_TL T
154: where T.OBJECT_RULE_ID = X_OBJECT_RULE_ID
155: and T.LANGUAGE = L.LANGUAGE_CODE);
156:
157: open c;

Line 239: from AMS_OBJECT_RULES_TL

235:
236: cursor c1 is select
237: OBJECT_RULE_ID,
238: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
239: from AMS_OBJECT_RULES_TL
240: where OBJECT_RULE_ID = X_OBJECT_RULE_ID
241: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
242: for update of OBJECT_RULE_ID nowait;
243: begin

Line 412: update AMS_OBJECT_RULES_TL set

408: if (sql%notfound) then
409: raise no_data_found;
410: end if;
411:
412: update AMS_OBJECT_RULES_TL set
413: OBJECT_RULE_ID = X_OBJECT_RULE_ID,
414: OBJECT_RULE_NAME = X_OBJECT_RULE_NAME,
415: DESCRIPTION = X_DESCRIPTION,
416: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 432: delete from AMS_OBJECT_RULES_TL

428: procedure DELETE_ROW (
429: X_OBJECT_RULE_ID in NUMBER
430: ) is
431: begin
432: delete from AMS_OBJECT_RULES_TL
433: where OBJECT_RULE_ID = X_OBJECT_RULE_ID;
434:
435: if (sql%notfound) then
436: raise no_data_found;

Line 454: update AMS_OBJECT_RULES_TL set

450: X_DESCRIPTION in VARCHAR2,
451: X_OWNER in VARCHAR2
452: ) IS
453: begin
454: update AMS_OBJECT_RULES_TL set
455: object_rule_name = nvl(x_object_rule_name, object_rule_name),
456: description = nvl(x_description, description),
457: source_lang = userenv('LANG'),
458: last_update_date = sysdate,

Line 634: delete from AMS_OBJECT_RULES_TL T

630:
631: procedure ADD_LANGUAGE
632: is
633: begin
634: delete from AMS_OBJECT_RULES_TL T
635: where not exists
636: (select NULL
637: from AMS_OBJECT_RULES_B B
638: where B.OBJECT_RULE_ID = T.OBJECT_RULE_ID

Line 641: update AMS_OBJECT_RULES_TL T set (

637: from AMS_OBJECT_RULES_B B
638: where B.OBJECT_RULE_ID = T.OBJECT_RULE_ID
639: );
640:
641: update AMS_OBJECT_RULES_TL T set (
642: OBJECT_RULE_ID
643: ) = (select
644: B.OBJECT_RULE_ID
645: from AMS_OBJECT_RULES_TL B

Line 645: from AMS_OBJECT_RULES_TL B

641: update AMS_OBJECT_RULES_TL T set (
642: OBJECT_RULE_ID
643: ) = (select
644: B.OBJECT_RULE_ID
645: from AMS_OBJECT_RULES_TL B
646: where B.OBJECT_RULE_ID = T.OBJECT_RULE_ID
647: and B.LANGUAGE = T.SOURCE_LANG)
648: where (
649: T.OBJECT_RULE_ID,

Line 654: from AMS_OBJECT_RULES_TL SUBB, AMS_OBJECT_RULES_TL SUBT

650: T.LANGUAGE
651: ) in (select
652: SUBT.OBJECT_RULE_ID,
653: SUBT.LANGUAGE
654: from AMS_OBJECT_RULES_TL SUBB, AMS_OBJECT_RULES_TL SUBT
655: where SUBB.OBJECT_RULE_ID = SUBT.OBJECT_RULE_ID
656: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
657: and (SUBB.OBJECT_RULE_ID <> SUBT.OBJECT_RULE_ID
658: ));

Line 660: insert into AMS_OBJECT_RULES_TL (

656: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
657: and (SUBB.OBJECT_RULE_ID <> SUBT.OBJECT_RULE_ID
658: ));
659:
660: insert into AMS_OBJECT_RULES_TL (
661: OBJECT_RULE_ID,
662: LAST_UPDATE_DATE,
663: LAST_UPDATED_BY,
664: CREATION_DATE,

Line 684: from AMS_OBJECT_RULES_TL B, FND_LANGUAGES L

680: B.OBJECT_RULE_NAME,
681: B.DESCRIPTION,
682: L.LANGUAGE_CODE,
683: B.SOURCE_LANG
684: from AMS_OBJECT_RULES_TL B, FND_LANGUAGES L
685: where L.INSTALLED_FLAG in ('I', 'B')
686: and B.LANGUAGE = userenv('LANG')
687: and not exists
688: (select NULL

Line 689: from AMS_OBJECT_RULES_TL T

685: where L.INSTALLED_FLAG in ('I', 'B')
686: and B.LANGUAGE = userenv('LANG')
687: and not exists
688: (select NULL
689: from AMS_OBJECT_RULES_TL T
690: where T.OBJECT_RULE_ID = B.OBJECT_RULE_ID
691: and T.LANGUAGE = L.LANGUAGE_CODE);
692: end ADD_LANGUAGE;
693: