eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_BRMRULE_PVT dependencies on JTF_BRM_RULES_TL

Line 173: INSERT INTO JTF_BRM_RULES_TL

169:
170: --
171: -- Insert into _TL table
172: --
173: INSERT INTO JTF_BRM_RULES_TL
174: ( RULE_ID
175: , RULE_NAME
176: , RULE_DESCRIPTION
177: , CREATED_BY

Line 199: FROM JTF_BRM_RULES_TL t

195: , p_br_rec.APPLICATION_ID
196: FROM FND_LANGUAGES l
197: WHERE l.INSTALLED_FLAG IN ('I','B')
198: AND NOT EXISTS ( SELECT NULL
199: FROM JTF_BRM_RULES_TL t
200: WHERE t.RULE_ID = l_rule_id
201: AND t.LANGUAGE = l.LANGUAGE_CODE);
202:
203: --

Line 388: UPDATE JTF_BRM_RULES_TL

384: THEN
385: RAISE NO_DATA_FOUND;
386: END IF;
387:
388: UPDATE JTF_BRM_RULES_TL
389: SET RULE_NAME = p_br_rec.RULE_NAME
390: , RULE_DESCRIPTION = p_br_rec.RULE_DESCRIPTION
391: , LAST_UPDATE_DATE = p_br_rec.LAST_UPDATE_DATE
392: , LAST_UPDATED_BY = p_br_rec.LAST_UPDATED_BY

Line 529: DELETE FROM JTF_BRM_RULES_TL

525: -- Initialize return status to SUCCESS
526: --
527: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
528:
529: DELETE FROM JTF_BRM_RULES_TL
530: WHERE RULE_ID = p_rule_id;
531:
532: --
533: -- Check whether delete was succesful

Line 616: DELETE FROM JTF_BRM_RULES_TL t

612:
613: --
614: -- Delete all records that don't have a base record
615: --
616: DELETE FROM JTF_BRM_RULES_TL t
617: WHERE NOT EXISTS (SELECT NULL
618: FROM JTF_BRM_RULES_B b
619: WHERE b.RULE_ID = t.RULE_ID
620: );

Line 625: UPDATE JTF_BRM_RULES_TL T

621:
622: --
623: -- Translate the records that already exists
624: --
625: UPDATE JTF_BRM_RULES_TL T
626: SET ( RULE_NAME
627: , RULE_DESCRIPTION
628: ) = ( SELECT B.RULE_NAME
629: , B.RULE_DESCRIPTION

Line 630: FROM JTF_BRM_RULES_TL B

626: SET ( RULE_NAME
627: , RULE_DESCRIPTION
628: ) = ( SELECT B.RULE_NAME
629: , B.RULE_DESCRIPTION
630: FROM JTF_BRM_RULES_TL B
631: WHERE B.RULE_ID = T.RULE_ID
632: AND B.LANGUAGE = T.SOURCE_LANG
633: )
634: WHERE ( T.RULE_ID

Line 638: FROM JTF_BRM_RULES_TL SUBB

634: WHERE ( T.RULE_ID
635: , T.LANGUAGE
636: ) IN ( SELECT SUBT.RULE_ID
637: , SUBT.LANGUAGE
638: FROM JTF_BRM_RULES_TL SUBB
639: , JTF_BRM_RULES_TL SUBT
640: WHERE SUBB.RULE_ID = SUBT.RULE_ID
641: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
642: AND ( SUBB.RULE_NAME <> SUBT.RULE_NAME

Line 639: , JTF_BRM_RULES_TL SUBT

635: , T.LANGUAGE
636: ) IN ( SELECT SUBT.RULE_ID
637: , SUBT.LANGUAGE
638: FROM JTF_BRM_RULES_TL SUBB
639: , JTF_BRM_RULES_TL SUBT
640: WHERE SUBB.RULE_ID = SUBT.RULE_ID
641: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
642: AND ( SUBB.RULE_NAME <> SUBT.RULE_NAME
643: OR SUBB.RULE_DESCRIPTION <> SUBT.RULE_DESCRIPTION

Line 656: INSERT INTO JTF_BRM_RULES_TL

652:
653: --
654: -- add records for new languages
655: --
656: INSERT INTO JTF_BRM_RULES_TL
657: ( RULE_ID
658: , CREATED_BY
659: , CREATION_DATE
660: , LAST_UPDATED_BY

Line 679: FROM JTF_BRM_RULES_TL B, FND_LANGUAGES L

675: , B.RULE_DESCRIPTION
676: , L.LANGUAGE_CODE
677: , B.SOURCE_LANG
678: , B.APPLICATION_ID
679: FROM JTF_BRM_RULES_TL B, FND_LANGUAGES L
680: WHERE L.INSTALLED_FLAG IN ('I', 'B')
681: AND B.LANGUAGE = USERENV('LANG')
682: AND NOT EXISTS (SELECT NULL
683: FROM JTF_BRM_RULES_TL T

Line 683: FROM JTF_BRM_RULES_TL T

679: FROM JTF_BRM_RULES_TL B, FND_LANGUAGES L
680: WHERE L.INSTALLED_FLAG IN ('I', 'B')
681: AND B.LANGUAGE = USERENV('LANG')
682: AND NOT EXISTS (SELECT NULL
683: FROM JTF_BRM_RULES_TL T
684: WHERE T.RULE_ID = B.RULE_ID
685: AND T.LANGUAGE = L.LANGUAGE_CODE
686: );
687: END Add_Language;

Line 713: UPDATE JTF_BRM_RULES_TL

709: , p_owner IN VARCHAR2
710: )
711: IS
712: BEGIN
713: UPDATE JTF_BRM_RULES_TL
714: SET RULE_NAME = p_rule_name
715: , RULE_DESCRIPTION = p_rule_description
716: , LAST_UPDATE_DATE = SYSDATE
717: , LAST_UPDATED_BY = DECODE(p_owner, 'SEED',1,0)

Line 871: UPDATE JTF_BRM_RULES_TL

867:
868: ------------------------------------------------------------------------
869: -- Try to update the record in the language table
870: ------------------------------------------------------------------------
871: UPDATE JTF_BRM_RULES_TL
872: SET RULE_NAME = p_br_rec.rule_name
873: , RULE_DESCRIPTION = p_br_rec.rule_description
874: , LAST_UPDATE_DATE = SYSDATE
875: , LAST_UPDATED_BY = l_user_id

Line 886: INSERT INTO JTF_BRM_RULES_TL

882: -- Apparently the record doesn't exist so create it
883: ------------------------------------------------------------------------
884: IF (SQL%NOTFOUND)
885: THEN
886: INSERT INTO JTF_BRM_RULES_TL
887: ( RULE_ID
888: , CREATED_BY
889: , CREATION_DATE
890: , LAST_UPDATED_BY

Line 912: FROM JTF_BRM_RULES_TL t

908: , p_br_rec.application_id
909: FROM FND_LANGUAGES l
910: WHERE l.INSTALLED_FLAG IN ('I', 'B')
911: AND NOT EXISTS( SELECT NULL
912: FROM JTF_BRM_RULES_TL t
913: WHERE t.RULE_ID = p_rule_id
914: AND t.LANGUAGE = l.LANGUAGE_CODE
915: );
916: END IF;