1 PACKAGE JTF_RS_RESOURCE_SKILLS_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfrseks.pls 120.0 2005/05/11 08:19:54 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_RESOURCE_SKILLS table
7 create, update and delete rows
8 Its main procedures are as following:
9 Create resource skills
10 Update resource skills
11 Delete resource skills
12 Calls to these procedures will invoke procedures from JTF_RS_RESOURCE_SKILLS_PUB
13 to do business validations and to do actual inserts, updates and deletes into tables.
14 ******************************************************************************************/
15
16
17 /* Procedure to create the resource skill
18 based on input values passed by calling routines. */
19
20 PROCEDURE create_resource_skills
21 (P_API_VERSION IN NUMBER,
22 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24 P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
25 P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
26 P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT NULL,
27 P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT NULL,
28 P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT NULL,
29 P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT NULL,
30 P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT NULL,
31 P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT NULL,
32 P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT NULL,
33 P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT NULL,
34 P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT NULL,
35 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT NULL,
36 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT NULL,
37 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT NULL,
38 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT NULL,
39 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT NULL,
40 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT NULL,
41 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT NULL,
42 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT NULL,
43 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT NULL,
44 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT NULL,
45 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT NULL,
46 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT NULL,
47 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT NULL,
48 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT NULL,
49 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT NULL,
50 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
51 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52 X_MSG_COUNT OUT NOCOPY NUMBER,
53 X_MSG_DATA OUT NOCOPY VARCHAR2,
54 X_RESOURCE_SKILL_ID OUT NOCOPY JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE
55 );
56
57
58 /* Procedure to update resource skill
59 based on input values passed by calling routines. */
60
61 PROCEDURE update_resource_skills
62 (P_API_VERSION IN NUMBER,
63 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
66 P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
67 P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
68 P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
69 P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
70 P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
71 P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
72 P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
73 P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74 P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
75 P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
76 P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
77 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
78 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
79 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
80 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
81 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
82 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
83 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
84 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
85 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
86 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
87 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
88 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
89 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
90 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
91 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
92 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
93 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
94 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95 X_MSG_COUNT OUT NOCOPY NUMBER,
96 X_MSG_DATA OUT NOCOPY VARCHAR2
97 );
98
99
100 /* Procedure to delete the resource skill */
101
102 PROCEDURE delete_resource_skills
103 (P_API_VERSION IN NUMBER,
104 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106 P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
107 P_OBJECT_VERSION_NUM IN JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
108 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
109 X_MSG_COUNT OUT NOCOPY NUMBER,
110 X_MSG_DATA OUT NOCOPY VARCHAR2
111 );
112
113 END JTF_RS_RESOURCE_SKILLS_PVT;