19: PROCEDURE create_skills
20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
24: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
25: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
26: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
27: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
24: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
25: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
26: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
27: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
28: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
29: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
23: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
24: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
25: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
26: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
27: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
28: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
29: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
24: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
25: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
26: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
27: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
28: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
29: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
25: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
26: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
27: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
28: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
29: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
26: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,
27: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
28: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
29: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
27: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT NULL,
28: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
29: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
28: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT NULL,
29: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
29: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
30: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
31: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
39: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
32: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
39: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
40: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
33: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
39: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
40: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
41: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
34: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
39: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
40: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
41: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
39: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
40: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
41: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
36: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
39: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
40: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
41: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2,
37: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT NULL,
39: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT NULL,
40: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT NULL,
41: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2,
45: X_SKILL_LEVEL_ID OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE
41: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2,
45: X_SKILL_LEVEL_ID OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE
46: );
47:
48: /* Procedure to update skill levels
49: based on input values passed by calling routines. */
51: PROCEDURE update_skills
52: (P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
56: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
57: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
58: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
52: (P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
56: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
57: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
58: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
60: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
55: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
56: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
57: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
58: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
60: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
56: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
57: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
58: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
60: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
57: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
58: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
60: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
58: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
60: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
60: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
60: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
69: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
77: X_MSG_COUNT OUT NOCOPY NUMBER,
70: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
77: X_MSG_COUNT OUT NOCOPY NUMBER,
78: X_MSG_DATA OUT NOCOPY VARCHAR2
71: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
77: X_MSG_COUNT OUT NOCOPY NUMBER,
78: X_MSG_DATA OUT NOCOPY VARCHAR2
79: );
83: PROCEDURE delete_skills
84: (P_API_VERSION IN NUMBER,
85: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
88: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
89: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
90: X_MSG_COUNT OUT NOCOPY NUMBER,
91: X_MSG_DATA OUT NOCOPY VARCHAR2
84: (P_API_VERSION IN NUMBER,
85: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
88: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
89: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
90: X_MSG_COUNT OUT NOCOPY NUMBER,
91: X_MSG_DATA OUT NOCOPY VARCHAR2
92: );