1 PACKAGE JTF_RS_SKILL_LEVELS_PVT AS
2 /* $Header: jtfrsess.pls 120.0 2005/05/11 08:19:58 appldev ship $ */
3
4 /*****************************************************************************************
5 This is a private API that public API will invoke.
6 It provides procedures for managing data of JTF_RS_SKILL_LEVELS_VL view
7 create, update and delete rows
8 Its main procedures are as following:
9 Create skill levels
10 Update skill levels
11 Delete skill levels
12 Calls to these procedures will invoke procedures from JTF_RS_SKILL_LEVELS_PUB
13 to do business validations and to do actual inserts, updates and deletes into tables.
14 ******************************************************************************************/
15
16 /* Procedure to create the skill levels
17 based on input values passed by calling routines. */
18
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,
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,
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
46 );
47
48 /* Procedure to update skill levels
49 based on input values passed by calling routines. */
50
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,
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,
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,
78 X_MSG_DATA OUT NOCOPY VARCHAR2
79 );
80
81 /* Procedure to delete the skill levels */
82
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
92 );
93
94 END JTF_RS_SKILL_LEVELS_PVT;