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_PERZ_PROFILE_PVT dependencies on JTF_PERZ_PROFILE_ATTRIB

Line 164: CURSOR C IS SELECT rowid FROM jtf_perz_profile_attrib

160: x_ATTRIBUTE_TYPE IN VARCHAR2,
161: x_ATTRIBUTE_VALUE IN VARCHAR2
162: ) IS
163:
164: CURSOR C IS SELECT rowid FROM jtf_perz_profile_attrib
165: WHERE PROFILE_ID = x_PROFILE_ID AND ROWNUM = 1;
166: CURSOR C2 IS SELECT jtf_perz_profile_attrib_s.NEXTVAL FROM SYS.DUAL;
167:
168: BEGIN

Line 166: CURSOR C2 IS SELECT jtf_perz_profile_attrib_s.NEXTVAL FROM SYS.DUAL;

162: ) IS
163:
164: CURSOR C IS SELECT rowid FROM jtf_perz_profile_attrib
165: WHERE PROFILE_ID = x_PROFILE_ID AND ROWNUM = 1;
166: CURSOR C2 IS SELECT jtf_perz_profile_attrib_s.NEXTVAL FROM SYS.DUAL;
167:
168: BEGIN
169: IF (X_PROFILE_ATTRIB_ID IS NULL) OR
170: (X_PROFILE_ATTRIB_ID = FND_API.G_MISS_NUM) THEN

Line 176: INSERT INTO jtf_perz_profile_attrib(

172: FETCH C2 INTO X_PROFILE_ATTRIB_ID;
173: CLOSE C2;
174: END IF;
175:
176: INSERT INTO jtf_perz_profile_attrib(
177: PROFILE_ATTRIB_ID,
178: PROFILE_ID,
179: PROFILE_ATTRIBUTE,
180: ATTRIBUTE_TYPE,

Line 215: UPDATE jtf_perz_profile_attrib SET

211: ) IS
212:
213: BEGIN
214:
215: UPDATE jtf_perz_profile_attrib SET
216: ATTRIBUTE_TYPE = decode( x_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR,
217: ATTRIBUTE_TYPE, x_ATTRIBUTE_TYPE ),
218: ATTRIBUTE_VALUE = decode( x_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR,
219: ATTRIBUTE_VALUE, x_ATTRIBUTE_VALUE ),

Line 518: ' from JTF_PERZ_PROFILE prfl, jtf_perz_profile_attrib prfl_attrib ';

514: 'prfl_attrib.PROFILE_ATTRIBUTE,' ||
515: 'prfl_attrib.ATTRIBUTE_TYPE,' ||
516: 'prfl_attrib.ATTRIBUTE_VALUE ' ||
517:
518: ' from JTF_PERZ_PROFILE prfl, jtf_perz_profile_attrib prfl_attrib ';
519:
520: --dbms_output.put_line(x_select_cl);
521:
522: END Gen_Select_Profile;

Line 761: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b

757: cursor prof1_curs (l_profname varchar2) is
758: SELECT a.PROFILE_ID, a.PROFILE_NAME,
759: a.PROFILE_TYPE, a.PROFILE_DESCRIPTION, a.ACTIVE_FLAG,
760: b.PROFILE_ATTRIBUTE, b.ATTRIBUTE_TYPE, b.ATTRIBUTE_VALUE
761: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b
762: WHERE a.profile_id = b.profile_id AND a.profile_name = l_profname ;
763:
764: cursor profid1_curs (l_profid number) is
765: SELECT a.PROFILE_ID, a.PROFILE_NAME,

Line 768: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b

764: cursor profid1_curs (l_profid number) is
765: SELECT a.PROFILE_ID, a.PROFILE_NAME,
766: a.PROFILE_TYPE, a.PROFILE_DESCRIPTION, a.ACTIVE_FLAG,
767: b.PROFILE_ATTRIBUTE, b.ATTRIBUTE_TYPE, b.ATTRIBUTE_VALUE
768: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b
769: WHERE a.profile_id = b.profile_id AND a.profile_id = l_profid ;
770:
771: cursor proftype1_curs (l_proftype varchar2) is
772: SELECT a.PROFILE_ID, a.PROFILE_NAME,

Line 775: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b

771: cursor proftype1_curs (l_proftype varchar2) is
772: SELECT a.PROFILE_ID, a.PROFILE_NAME,
773: a.PROFILE_TYPE, a.PROFILE_DESCRIPTION, a.ACTIVE_FLAG,
774: b.PROFILE_ATTRIBUTE, b.ATTRIBUTE_TYPE, b.ATTRIBUTE_VALUE
775: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b
776: WHERE a.profile_id = b.profile_id AND profile_type = l_proftype ;
777:
778: cursor proftype2_curs (l_proftype varchar2, l_profile_attrib varchar2) is
779: SELECT a.PROFILE_ID, a.PROFILE_NAME,

Line 782: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b

778: cursor proftype2_curs (l_proftype varchar2, l_profile_attrib varchar2) is
779: SELECT a.PROFILE_ID, a.PROFILE_NAME,
780: a.PROFILE_TYPE, a.PROFILE_DESCRIPTION, a.ACTIVE_FLAG,
781: b.PROFILE_ATTRIBUTE, b.ATTRIBUTE_TYPE, b.ATTRIBUTE_VALUE
782: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b
783: WHERE a.profile_id = b.profile_id
784: AND a.profile_type = l_proftype
785: AND b.PROFILE_ATTRIBUTE = l_profile_attrib ;
786:

Line 791: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b

787: cursor proftype3_curs (l_proftype varchar2, l_attrib_type varchar2) is
788: SELECT a.PROFILE_ID, a.PROFILE_NAME,
789: a.PROFILE_TYPE, a.PROFILE_DESCRIPTION, a.ACTIVE_FLAG,
790: b.PROFILE_ATTRIBUTE, b.ATTRIBUTE_TYPE, b.ATTRIBUTE_VALUE
791: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b
792: WHERE a.profile_id = b.profile_id
793: AND a.profile_type = l_proftype
794: AND b.ATTRIBUTE_TYPE = l_attrib_type ;
795:

Line 800: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b

796: cursor proftype4_curs (l_proftype varchar2, l_profile_attrib varchar2, l_attrib_type varchar2) is
797: SELECT a.PROFILE_ID, a.PROFILE_NAME,
798: a.PROFILE_TYPE, a.PROFILE_DESCRIPTION, a.ACTIVE_FLAG,
799: b.PROFILE_ATTRIBUTE, b.ATTRIBUTE_TYPE, b.ATTRIBUTE_VALUE
800: FROM JTF_PERZ_PROFILE a, JTF_PERZ_PROFILE_ATTRIB b
801: WHERE a.profile_id = b.profile_id
802: AND a.profile_type = l_proftype
803: AND b.ATTRIBUTE_TYPE = l_attrib_type
804: AND b.PROFILE_ATTRIBUTE = l_profile_attrib;

Line 808: FROM JTF_PERZ_PROFILE_ATTRIB

804: AND b.PROFILE_ATTRIBUTE = l_profile_attrib;
805:
806: cursor profid1attr_curs (l_profid number) is
807: SELECT PROFILE_ATTRIBUTE,ATTRIBUTE_TYPE,ATTRIBUTE_VALUE
808: FROM JTF_PERZ_PROFILE_ATTRIB
809: WHERE profile_id = l_profid;
810:
811: curso_1prof prof1_curs%ROWTYPE;
812: curso_1profid profid1_curs%ROWTYPE;