APPS.JTF_RS_SKILL_LEVELS_PUB dependencies on JTF_RS_SKILL_LEVELS_B

Line 41: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,

37: PROCEDURE create_skills
38: (P_API_VERSION IN NUMBER,
39: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
42: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
43: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
44: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
45: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 44: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,

40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
42: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
43: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
44: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
45: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
46: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 45: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,

41: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
42: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
43: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
44: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
45: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
46: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 46: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,

42: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
43: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
44: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
45: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
46: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,

43: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
44: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
45: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
46: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,

44: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
45: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
46: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,

45: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
46: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,

46: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,

47: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,

48: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,

49: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
57: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,

50: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
57: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
58: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,

51: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
57: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
58: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
59: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,

52: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
57: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
58: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
59: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 57: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,

53: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
57: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
58: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
59: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 58: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,

54: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
57: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
58: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
59: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61: X_MSG_COUNT OUT NOCOPY NUMBER,
62: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 59: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

55: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
56: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
57: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
58: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
59: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61: X_MSG_COUNT OUT NOCOPY NUMBER,
62: X_MSG_DATA OUT NOCOPY VARCHAR2,
63: X_SKILL_LEVEL_ID OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE

Line 63: X_SKILL_LEVEL_ID OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE

59: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61: X_MSG_COUNT OUT NOCOPY NUMBER,
62: X_MSG_DATA OUT NOCOPY VARCHAR2,
63: X_SKILL_LEVEL_ID OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE
64: )IS
65:
66: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SKILLS';
67: l_api_version CONSTANT NUMBER := 1.0;

Line 72: l_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE;

68: l_bind_data_id number;
69:
70: l_object_version_number number;
71:
72: l_skill_level_id JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE;
73:
74: l_return_code VARCHAR2(100);
75: l_count NUMBER;
76: l_data VARCHAR2(200);

Line 174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,

170: PROCEDURE update_skills
171: (P_API_VERSION IN NUMBER,
172: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
173: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,

Line 175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,

171: (P_API_VERSION IN NUMBER,
172: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
173: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
196: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
196: X_MSG_COUNT OUT NOCOPY NUMBER,
197: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
196: X_MSG_COUNT OUT NOCOPY NUMBER,
197: X_MSG_DATA OUT NOCOPY VARCHAR2
198: ) IS

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

203: l_return_code VARCHAR2(100);
204: l_count NUMBER;
205: l_data VARCHAR2(200);
206:
207: l_object_version_number JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
208:
209: l_return_status VARCHAR2(200);
210: l_msg_count NUMBER;
211: l_msg_data VARCHAR2(200);

Line 302: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,

298: PROCEDURE delete_skills
299: (P_API_VERSION IN NUMBER,
300: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
303: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
304: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
305: X_MSG_COUNT OUT NOCOPY NUMBER,
306: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 303: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,

299: (P_API_VERSION IN NUMBER,
300: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
303: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
304: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
305: X_MSG_COUNT OUT NOCOPY NUMBER,
306: X_MSG_DATA OUT NOCOPY VARCHAR2
307: )IS