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_B

Line 22: cursor chk_dup_skill(ll_skill_level jtf_rs_skill_levels_b.skill_level%type,

18: X_SKILL_LEVEL_ID IN OUT NOCOPY NUMBER,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY NUMBER,
21: X_MSG_DATA OUT NOCOPY VARCHAR2) is
22: cursor chk_dup_skill(ll_skill_level jtf_rs_skill_levels_b.skill_level%type,
23: ll_skill_level_id jtf_rs_skill_levels_b.skill_level_id%type)
24: is
25: select * from
26: jtf_rs_skill_levels_b where

Line 23: ll_skill_level_id jtf_rs_skill_levels_b.skill_level_id%type)

19: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY NUMBER,
21: X_MSG_DATA OUT NOCOPY VARCHAR2) is
22: cursor chk_dup_skill(ll_skill_level jtf_rs_skill_levels_b.skill_level%type,
23: ll_skill_level_id jtf_rs_skill_levels_b.skill_level_id%type)
24: is
25: select * from
26: jtf_rs_skill_levels_b where
27: skill_level = ll_skill_level and

Line 26: jtf_rs_skill_levels_b where

22: cursor chk_dup_skill(ll_skill_level jtf_rs_skill_levels_b.skill_level%type,
23: ll_skill_level_id jtf_rs_skill_levels_b.skill_level_id%type)
24: is
25: select * from
26: jtf_rs_skill_levels_b where
27: skill_level = ll_skill_level and
28: skill_level_id <> ll_skill_level_id;
29:
30: skill_levels_rec chk_dup_skill%rowtype;

Line 56: ll_skill_level_id jtf_rs_skill_levels_b.skill_level_id%type)

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
60: upper(level_name) = upper(ll_level_name) and

Line 90: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,

86: PROCEDURE create_skills
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,

Line 93: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE,

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,
97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,

Line 94: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE,

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,
97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,

Line 95: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%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,
97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,

Line 96: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%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,
97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,

Line 97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%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,
97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,

Line 98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%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,
97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,

Line 99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,

95: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE,
96: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,

Line 100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,

96: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,

Line 101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,

97: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,

Line 102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,

98: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
106: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,

Line 103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,

99: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
106: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
107: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,

Line 104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,

100: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
106: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
107: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
108: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,

Line 105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,

101: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
106: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
107: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
108: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
109: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 106: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,

102: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
106: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
107: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
108: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
109: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
110: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 107: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,

103: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
106: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
107: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
108: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
109: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
110: X_MSG_COUNT OUT NOCOPY NUMBER,
111: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 108: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,

104: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
105: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
106: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
107: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
108: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
109: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
110: X_MSG_COUNT OUT NOCOPY NUMBER,
111: X_MSG_DATA OUT NOCOPY VARCHAR2,
112: X_SKILL_LEVEL_ID OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE

Line 112: X_SKILL_LEVEL_ID OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE

108: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
109: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
110: X_MSG_COUNT OUT NOCOPY NUMBER,
111: X_MSG_DATA OUT NOCOPY VARCHAR2,
112: X_SKILL_LEVEL_ID OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE
113: )IS
114: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SKILLS';
115: l_api_version CONSTANT NUMBER :=1.0;
116: l_bind_data_id number;

Line 120: l_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE;

116: l_bind_data_id number;
117:
118: l_object_version_number number := 1;
119:
120: l_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE;
121:
122: l_return_code VARCHAR2(100);
123: l_count NUMBER;
124: l_data VARCHAR2(200);

Line 246: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,

242: PROCEDURE update_skills
243: (P_API_VERSION IN NUMBER,
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,

Line 247: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,

243: (P_API_VERSION IN NUMBER,
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,

Line 250: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,

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,
254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,

Line 251: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%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,
254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,

Line 252: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%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,
254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,

Line 253: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%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,
254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,

Line 254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%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,
254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,

Line 255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%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,
254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,

Line 256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,

252: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE,
253: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE,
254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,

Line 257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,

253: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE,
254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,

Line 258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,

254: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE,
255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,

Line 259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,

255: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE,
256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,

Line 260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,

256: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE,
257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
264: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,

Line 261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,

257: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE,
258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
264: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
265: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,

Line 262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,

258: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE,
259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
264: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
265: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
266: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,

Line 263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,

259: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE,
260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
264: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
265: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
266: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
267: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 264: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,

260: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE,
261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
264: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
265: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
266: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
267: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
268: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 265: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,

261: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE,
262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
264: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
265: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
266: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
267: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
268: X_MSG_COUNT OUT NOCOPY NUMBER,
269: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 266: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,

262: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE,
263: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE,
264: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE,
265: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE,
266: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE,
267: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
268: X_MSG_COUNT OUT NOCOPY NUMBER,
269: X_MSG_DATA OUT NOCOPY VARCHAR2
270: )IS

Line 280: L_ATTRIBUTE1 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE;

276: l_count NUMBER;
277: l_data VARCHAR2(200);
278:
279:
280: L_ATTRIBUTE1 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE;
281: L_ATTRIBUTE2 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE;
282: L_ATTRIBUTE3 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE;
283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;
284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;

Line 281: L_ATTRIBUTE2 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE;

277: l_data VARCHAR2(200);
278:
279:
280: L_ATTRIBUTE1 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE;
281: L_ATTRIBUTE2 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE;
282: L_ATTRIBUTE3 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE;
283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;
284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;
285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;

Line 282: L_ATTRIBUTE3 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE;

278:
279:
280: L_ATTRIBUTE1 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE;
281: L_ATTRIBUTE2 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE;
282: L_ATTRIBUTE3 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE;
283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;
284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;
285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;
286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;

Line 283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;

279:
280: L_ATTRIBUTE1 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE;
281: L_ATTRIBUTE2 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE;
282: L_ATTRIBUTE3 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE;
283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;
284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;
285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;
286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;
287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;

Line 284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;

280: L_ATTRIBUTE1 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE;
281: L_ATTRIBUTE2 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE;
282: L_ATTRIBUTE3 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE;
283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;
284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;
285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;
286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;
287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;
288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;

Line 285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;

281: L_ATTRIBUTE2 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE;
282: L_ATTRIBUTE3 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE;
283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;
284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;
285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;
286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;
287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;
288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;
289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;

Line 286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;

282: L_ATTRIBUTE3 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE;
283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;
284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;
285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;
286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;
287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;
288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;
289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;
290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;

Line 287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;

283: L_ATTRIBUTE4 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE;
284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;
285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;
286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;
287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;
288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;
289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;
290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;
291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;

Line 288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;

284: L_ATTRIBUTE5 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE;
285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;
286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;
287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;
288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;
289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;
290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;
291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;
292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;

Line 289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;

285: L_ATTRIBUTE6 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE;
286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;
287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;
288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;
289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;
290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;
291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;
292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;
293: L_ATTRIBUTE14 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE;

Line 290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;

286: L_ATTRIBUTE7 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE;
287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;
288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;
289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;
290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;
291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;
292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;
293: L_ATTRIBUTE14 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE;
294: L_ATTRIBUTE15 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE;

Line 291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;

287: L_ATTRIBUTE8 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE;
288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;
289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;
290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;
291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;
292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;
293: L_ATTRIBUTE14 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE;
294: L_ATTRIBUTE15 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE;
295: L_ATTRIBUTE_CATEGORY JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE;

Line 292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;

288: L_ATTRIBUTE9 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE;
289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;
290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;
291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;
292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;
293: L_ATTRIBUTE14 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE;
294: L_ATTRIBUTE15 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE;
295: L_ATTRIBUTE_CATEGORY JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE;
296:

Line 293: L_ATTRIBUTE14 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE;

289: L_ATTRIBUTE10 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE;
290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;
291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;
292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;
293: L_ATTRIBUTE14 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE;
294: L_ATTRIBUTE15 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE;
295: L_ATTRIBUTE_CATEGORY JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE;
296:
297:

Line 294: L_ATTRIBUTE15 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE;

290: L_ATTRIBUTE11 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE;
291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;
292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;
293: L_ATTRIBUTE14 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE;
294: L_ATTRIBUTE15 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE;
295: L_ATTRIBUTE_CATEGORY JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE;
296:
297:
298: CURSOR chk_skill_cur(ll_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE)

Line 295: L_ATTRIBUTE_CATEGORY JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE;

291: L_ATTRIBUTE12 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE;
292: L_ATTRIBUTE13 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE;
293: L_ATTRIBUTE14 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE;
294: L_ATTRIBUTE15 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE;
295: L_ATTRIBUTE_CATEGORY JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE;
296:
297:
298: CURSOR chk_skill_cur(ll_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE)
299: IS

Line 298: CURSOR chk_skill_cur(ll_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE)

294: L_ATTRIBUTE15 JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE;
295: L_ATTRIBUTE_CATEGORY JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE;
296:
297:
298: CURSOR chk_skill_cur(ll_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE)
299: IS
300: SELECT *
301: FROM jtf_rs_skill_levels_vl
302: WHERE skill_level_id = ll_skill_level_id;

Line 306: l_skill_level_id JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE := p_skill_level_id;

302: WHERE skill_level_id = ll_skill_level_id;
303:
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;

Line 307: l_skill_level JTF_RS_SKILL_LEVELS_B.skill_level%TYPE := p_skill_level;

303:
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:

Line 310: l_object_version_number JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

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;
314: l_msg_data VARCHAR2(200);

Line 593: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,

589: PROCEDURE delete_skills
590: (P_API_VERSION IN NUMBER,
591: P_INIT_MSG_LIST IN VARCHAR2,
592: P_COMMIT IN VARCHAR2,
593: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
594: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
595: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
596: X_MSG_COUNT OUT NOCOPY NUMBER,
597: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 594: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,

590: (P_API_VERSION IN NUMBER,
591: P_INIT_MSG_LIST IN VARCHAR2,
592: P_COMMIT IN VARCHAR2,
593: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
594: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
595: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
596: X_MSG_COUNT OUT NOCOPY NUMBER,
597: X_MSG_DATA OUT NOCOPY VARCHAR2
598: )IS

Line 601: CURSOR chk_skill_exist_cur(ll_skill_level_id JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE)

597: X_MSG_DATA OUT NOCOPY VARCHAR2
598: )IS
599:
600:
601: CURSOR chk_skill_exist_cur(ll_skill_level_id JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE)
602: IS
603: SELECT skill_level_id
604: FROM JTF_RS_SKILL_LEVELS_B
605: WHERE skill_level_id = ll_skill_level_id;

Line 604: FROM JTF_RS_SKILL_LEVELS_B

600:
601: CURSOR chk_skill_exist_cur(ll_skill_level_id JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE)
602: IS
603: SELECT skill_level_id
604: FROM JTF_RS_SKILL_LEVELS_B
605: WHERE skill_level_id = ll_skill_level_id;
606:
607: chk_skill_exist_rec chk_skill_exist_cur%rowtype;
608:

Line 609: l_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE := p_skill_level_id;

605: WHERE skill_level_id = ll_skill_level_id;
606:
607: chk_skill_exist_rec chk_skill_exist_cur%rowtype;
608:
609: l_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
610:
611: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SKILLS';
612: l_api_version CONSTANT NUMBER := 1.0;
613: l_bind_data_id number;