eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_RESOURCE_SKILLS_PVT dependencies on JTF_RS_RESOURCE_SKILLS

Line 1: PACKAGE JTF_RS_RESOURCE_SKILLS_PVT AUTHID CURRENT_USER AS

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.

Line 6: It provides procedures for managing data of JTF_RS_RESOURCE_SKILLS table

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

Line 12: Calls to these procedures will invoke procedures from JTF_RS_RESOURCE_SKILLS_PUB

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:

Line 24: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,

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,

Line 25: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,

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,

Line 26: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT NULL,

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,

Line 27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT NULL,

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,

Line 28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT NULL,

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,

Line 29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT NULL,

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,

Line 30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT NULL,

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,

Line 31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_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,

Line 32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%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,

Line 33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_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,

Line 34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_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,

Line 35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%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,

Line 36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%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,

Line 37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%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,

Line 38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%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,

Line 39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%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,

Line 40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%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,

Line 41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%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,

Line 42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%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,

Line 43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%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,

Line 44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%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,

Line 45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%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,

Line 46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%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,

Line 47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%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,

Line 48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%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,

Line 49: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%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,

Line 50: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%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

Line 54: X_RESOURCE_SKILL_ID OUT NOCOPY JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE

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

Line 65: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,

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,

Line 66: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

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,

Line 67: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

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,

Line 68: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

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,

Line 69: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

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,

Line 70: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

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,

Line 71: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_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,

Line 72: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_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,

Line 73: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_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,

Line 74: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%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,

Line 75: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_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,

Line 76: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_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,

Line 77: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,

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,

Line 78: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

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,

Line 79: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%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,

Line 80: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

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,

Line 81: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

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,

Line 82: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

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,

Line 83: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%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,

Line 84: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%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,

Line 85: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%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,

Line 86: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%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,

Line 87: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%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,

Line 88: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%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,

Line 89: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%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,

Line 90: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%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,

Line 91: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%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,

Line 92: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%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

Line 93: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%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: );

Line 106: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,

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

Line 107: P_OBJECT_VERSION_NUM IN JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,

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: );

Line 113: END JTF_RS_RESOURCE_SKILLS_PVT;

109: X_MSG_COUNT OUT NOCOPY NUMBER,
110: X_MSG_DATA OUT NOCOPY VARCHAR2
111: );
112:
113: END JTF_RS_RESOURCE_SKILLS_PVT;