71: * @rep:displayname Create Resource Skill
72: */
73: PROCEDURE create_resource_skills
74: (P_API_VERSION IN NUMBER,
75: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
78: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
79: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT NULL,
72: */
73: PROCEDURE create_resource_skills
74: (P_API_VERSION IN NUMBER,
75: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
78: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
79: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT NULL,
80: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
151: * @rep:displayname Update Resource Skill
152: */
153: PROCEDURE update_resource_skills
154: (P_API_VERSION IN NUMBER,
155: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
158: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
159: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
152: */
153: PROCEDURE update_resource_skills
154: (P_API_VERSION IN NUMBER,
155: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
158: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
159: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
154: (P_API_VERSION IN NUMBER,
155: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
158: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
159: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
155: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
158: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
159: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
156: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
158: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
159: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
157: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
158: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
159: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
158: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
159: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
166: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
166: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
166: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
168: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
166: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
168: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
169: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
162: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
166: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
168: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
169: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
170: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
163: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
166: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
168: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
169: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
170: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
166: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
168: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
169: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
170: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
168: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
169: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
170: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
168: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
169: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
170: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
169: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
170: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
170: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
179: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
187: X_MSG_COUNT OUT NOCOPY NUMBER,
180: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
187: X_MSG_COUNT OUT NOCOPY NUMBER,
188: X_MSG_DATA OUT NOCOPY VARCHAR2
181: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
187: X_MSG_COUNT OUT NOCOPY NUMBER,
188: X_MSG_DATA OUT NOCOPY VARCHAR2
189: );
205: * @rep:displayname Update Resource Skill With Cascade
206: */
207: PROCEDURE delete_resource_skills
208: (P_API_VERSION IN NUMBER,
209: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
212: P_OBJECT_VERSION_NUM IN JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
213: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
206: */
207: PROCEDURE delete_resource_skills
208: (P_API_VERSION IN NUMBER,
209: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
212: P_OBJECT_VERSION_NUM IN JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
213: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
214: X_MSG_COUNT OUT NOCOPY NUMBER,
260: * @rep:displayname Create Resource Skill With Cascade
261: */
262: PROCEDURE create_resource_skills
263: (P_API_VERSION IN NUMBER,
264: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
267: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
268: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT NULL,
261: */
262: PROCEDURE create_resource_skills
263: (P_API_VERSION IN NUMBER,
264: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
267: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
268: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT NULL,
269: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT NULL,
343: * @rep:displayname Update Resource Skill With Cascade
344: */
345: PROCEDURE update_resource_skills
346: (P_API_VERSION IN NUMBER,
347: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
348: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
349: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
350: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
351: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
344: */
345: PROCEDURE update_resource_skills
346: (P_API_VERSION IN NUMBER,
347: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
348: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
349: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
350: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
351: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
346: (P_API_VERSION IN NUMBER,
347: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
348: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
349: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
350: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
351: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
347: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
348: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
349: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
350: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
351: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
348: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
349: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
350: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
351: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
349: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
350: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
351: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
350: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
351: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
358: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
351: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
358: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
359: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
358: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
359: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
360: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
358: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
359: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
360: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
361: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
354: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
358: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
359: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
360: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
361: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
362: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
355: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
358: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
359: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
360: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
361: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
362: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
363: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
356: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
358: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
359: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
360: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
361: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
362: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
363: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
364: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
358: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
359: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
360: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
361: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
362: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
363: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
364: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
365: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
359: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
360: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
361: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
362: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
363: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
364: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
365: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
360: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
361: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
362: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
363: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
364: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
365: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
361: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
362: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
363: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
364: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
365: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
362: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
363: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
364: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
365: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
363: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
364: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
365: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
364: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
365: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
365: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
366: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
367: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
375: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
368: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
375: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
376: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
369: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
375: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
376: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
377: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
370: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
375: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
376: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
377: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
378: P_CASCADE_OPTION IN NUMBER,
371: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
375: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
376: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
377: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
378: P_CASCADE_OPTION IN NUMBER,
379: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
372: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
375: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
376: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
377: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
378: P_CASCADE_OPTION IN NUMBER,
379: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
380: X_MSG_COUNT OUT NOCOPY NUMBER,
373: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
375: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
376: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
377: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
378: P_CASCADE_OPTION IN NUMBER,
379: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
380: X_MSG_COUNT OUT NOCOPY NUMBER,
381: X_MSG_DATA OUT NOCOPY VARCHAR2