APPS.AHL_APPROVAL_RULES_PKG dependencies on AHL_APPROVAL_RULES_TL

Line 129: insert into AHL_APPROVAL_RULES_TL

125: );
126:
127:
128:
129: insert into AHL_APPROVAL_RULES_TL
130:
131: (
132: APPROVAL_RULE_NAME,
133: DESCRIPTION,

Line 160: from AHL_APPROVAL_RULES_TL T

156:
157: and not exists
158:
159: (select NULL
160: from AHL_APPROVAL_RULES_TL T
161: where T.APPROVAL_RULE_ID = X_APPROVAL_RULE_ID
162: and T.LANGUAGE = L.LANGUAGE_CODE);
163:
164:

Line 319: from AHL_APPROVAL_RULES_TL

315: DESCRIPTION,
316:
317: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
318:
319: from AHL_APPROVAL_RULES_TL
320:
321: where APPROVAL_RULE_ID = X_APPROVAL_RULE_ID
322:
323: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 631: update AHL_APPROVAL_RULES_TL set

627: end if;
628:
629:
630:
631: update AHL_APPROVAL_RULES_TL set
632:
633: APPROVAL_RULE_NAME = X_APPROVAL_RULE_NAME,
634:
635: DESCRIPTION = X_DESCRIPTION,

Line 671: delete from AHL_APPROVAL_RULES_TL

667: is
668:
669: begin
670:
671: delete from AHL_APPROVAL_RULES_TL
672:
673: where APPROVAL_RULE_ID = X_APPROVAL_RULE_ID;
674:
675:

Line 707: delete from AHL_APPROVAL_RULES_TL T

703: is
704:
705: begin
706:
707: delete from AHL_APPROVAL_RULES_TL T
708:
709: where not exists
710:
711: (select NULL

Line 721: update AHL_APPROVAL_RULES_TL T set (

717: );
718:
719:
720:
721: update AHL_APPROVAL_RULES_TL T set (
722:
723: APPROVAL_RULE_NAME,
724:
725: DESCRIPTION

Line 733: from AHL_APPROVAL_RULES_TL B

729: B.APPROVAL_RULE_NAME,
730:
731: B.DESCRIPTION
732:
733: from AHL_APPROVAL_RULES_TL B
734:
735: where B.APPROVAL_RULE_ID = T.APPROVAL_RULE_ID
736:
737: and B.LANGUAGE = T.SOURCE_LANG)

Line 751: from AHL_APPROVAL_RULES_TL SUBB, AHL_APPROVAL_RULES_TL SUBT

747: SUBT.APPROVAL_RULE_ID,
748:
749: SUBT.LANGUAGE
750:
751: from AHL_APPROVAL_RULES_TL SUBB, AHL_APPROVAL_RULES_TL SUBT
752:
753: where SUBB.APPROVAL_RULE_ID = SUBT.APPROVAL_RULE_ID
754:
755: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 773: insert into AHL_APPROVAL_RULES_TL (

769: ));
770:
771:
772:
773: insert into AHL_APPROVAL_RULES_TL (
774:
775: APPROVAL_RULE_NAME,
776:
777: DESCRIPTION,

Line 821: from AHL_APPROVAL_RULES_TL B, FND_LANGUAGES L

817: L.LANGUAGE_CODE,
818:
819: B.SOURCE_LANG
820:
821: from AHL_APPROVAL_RULES_TL B, FND_LANGUAGES L
822:
823: where L.INSTALLED_FLAG in ('I', 'B')
824:
825: and B.LANGUAGE = userenv('LANG')

Line 831: from AHL_APPROVAL_RULES_TL T

827: and not exists
828:
829: (select NULL
830:
831: from AHL_APPROVAL_RULES_TL T
832:
833: where T.APPROVAL_RULE_ID = B.APPROVAL_RULE_ID
834:
835: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 848: update AHL_APPROVAL_RULES_TL set

844: X_OWNER in VARCHAR2
845: ) IS
846:
847: begin
848: update AHL_APPROVAL_RULES_TL set
849: approval_rule_name = nvl(x_approval_rule_name, approval_rule_name),
850: description = nvl(x_description, description),
851: source_lang = userenv('LANG'),
852: last_update_date = sysdate,