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_RS_SKILL_LEVELS_PVT dependencies on JTF_RS_SKILL_LEVELS_TL

Line 55: (ll_level_name jtf_rs_skill_levels_tl.level_name%type,

51: X_MSG_COUNT OUT NOCOPY NUMBER,
52: X_MSG_DATA OUT NOCOPY VARCHAR2)
53: is
54: cursor chk_dup_name
55: (ll_level_name jtf_rs_skill_levels_tl.level_name%type,
56: ll_skill_level_id jtf_rs_skill_levels_b.skill_level_id%type)
57: is
58: select * from
59: jtf_rs_skill_levels_tl where

Line 59: jtf_rs_skill_levels_tl where

55: (ll_level_name jtf_rs_skill_levels_tl.level_name%type,
56: ll_skill_level_id jtf_rs_skill_levels_b.skill_level_id%type)
57: is
58: select * from
59: jtf_rs_skill_levels_tl where
60: upper(level_name) = upper(ll_level_name) and
61: skill_level_id <> ll_skill_level_id;
62:
63: levels_vl_rec chk_dup_name%rowtype;

Line 91: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,

87: (P_API_VERSION IN NUMBER,
88: P_INIT_MSG_LIST IN VARCHAR2,
89: P_COMMIT IN VARCHAR2,
90: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
91: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
92: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE,
93: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE,
94: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE,
95: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE,

Line 92: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE,

88: P_INIT_MSG_LIST IN VARCHAR2,
89: P_COMMIT IN VARCHAR2,
90: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
91: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
92: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE,
93: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE,
94: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE,
95: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE,
96: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,

Line 248: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,

244: P_INIT_MSG_LIST IN VARCHAR2,
245: P_COMMIT IN VARCHAR2,
246: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
247: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
248: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
249: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE,
250: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
251: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE,
252: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE,

Line 249: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE,

245: P_COMMIT IN VARCHAR2,
246: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
247: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
248: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
249: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE,
250: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
251: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE,
252: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE,
253: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE,

Line 308: l_level_name JTF_RS_SKILL_LEVELS_TL.level_name%TYPE := p_level_name;

304: skill_levels_rec chk_skill_cur%rowtype;
305:
306: l_skill_level_id JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE := p_skill_level_id;
307: l_skill_level JTF_RS_SKILL_LEVELS_B.skill_level%TYPE := p_skill_level;
308: l_level_name JTF_RS_SKILL_LEVELS_TL.level_name%TYPE := p_level_name;
309: l_level_desc JTF_RS_SKILL_LEVELS_TL.level_desc%type := p_level_desc;
310: l_object_version_number JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
311:
312: l_return_status VARCHAR2(200);

Line 309: l_level_desc JTF_RS_SKILL_LEVELS_TL.level_desc%type := p_level_desc;

305:
306: l_skill_level_id JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE := p_skill_level_id;
307: l_skill_level JTF_RS_SKILL_LEVELS_B.skill_level%TYPE := p_skill_level;
308: l_level_name JTF_RS_SKILL_LEVELS_TL.level_name%TYPE := p_level_name;
309: l_level_desc JTF_RS_SKILL_LEVELS_TL.level_desc%type := p_level_desc;
310: l_object_version_number JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
311:
312: l_return_status VARCHAR2(200);
313: l_msg_count NUMBER;