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 BODY JTF_RS_RESOURCE_SKILLS_PVT AS

1: PACKAGE BODY JTF_RS_RESOURCE_SKILLS_PVT AS
2: /* $Header: jtfrsekb.pls 120.0.12010000.2 2009/04/30 07:14:29 avjha ship $ */
3:
4: /*****************************************************************************************
5: Its main procedures are as following:

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

5: Its main procedures are as following:
6: Create resource skills
7: Update resource skills
8: Delete resource skills
9: Calls to these procedures will invoke procedures from JTF_RS_RESOURCE_SKILLS_PUB
10: to do business validations and to do actual inserts, updates and deletes into tables.
11: ******************************************************************************************/
12: /* Package variables. */
13:

Line 14: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_RESOURCE_SKILLS_PVT';

10: to do business validations and to do actual inserts, updates and deletes into tables.
11: ******************************************************************************************/
12: /* Package variables. */
13:
14: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_RESOURCE_SKILLS_PVT';
15: G_NAME VARCHAR2(240);
16:
17: /* Procedure to create the resource skills
18: based on input values passed by calling routines. */

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,
23: P_COMMIT IN VARCHAR2,
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,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,

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,
23: P_COMMIT IN VARCHAR2,
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,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,

Line 26: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,

22: P_INIT_MSG_LIST IN VARCHAR2,
23: P_COMMIT IN VARCHAR2,
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,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,

Line 27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,

23: P_COMMIT IN VARCHAR2,
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,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,

Line 28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,

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,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,

Line 29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_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,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,

Line 30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,

26: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,

Line 31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,

27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,

Line 32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,

28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,

Line 33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,

29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,

Line 34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,

30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,

Line 35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,

31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,

Line 36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,

32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,

Line 37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,

33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,

Line 38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,

34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,

Line 39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,

35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,

Line 40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,

36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,

Line 41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,

37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,

Line 42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,

38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,

Line 43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,

39: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,

Line 44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,

40: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,

Line 45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,

41: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,

Line 46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,

42: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,

Line 47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,

43: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,

44: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,
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,

45: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,
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,

46: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,
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,
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: )IS
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_SKILLS';
57: l_api_version CONSTANT NUMBER := 1.0;
58:

Line 61: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE;

57: l_api_version CONSTANT NUMBER := 1.0;
58:
59: l_object_version_number number ;
60:
61: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE;
62:
63: l_return_code VARCHAR2(100);
64: l_count NUMBER;
65: l_data VARCHAR2(200);

Line 73: CURSOR resource_id_cur(ll_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE)

69: l_msg_data VARCHAR2(200);
70: l_rowid VARCHAR2(200);
71:
72: -- Check resource_id is valid
73: CURSOR resource_id_cur(ll_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE)
74: IS
75: SELECT resource_id
76: FROM JTF_RS_RESOURCE_EXTNS
77: WHERE resource_id = ll_resource_id ;

Line 82: CURSOR skill_level_id_cur(ll_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE)

78:
79: resource_id_rec resource_id_cur%rowtype;
80:
81: -- Check Skill_level_id is valid
82: CURSOR skill_level_id_cur(ll_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE)
83: IS
84: SELECT skill_level_id
85: FROM JTF_RS_SKILL_LEVELS_B
86: WHERE skill_level_id = ll_skill_level_id;

Line 91: CURSOR category_id_cur(ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE)

87:
88: skill_level_id_rec skill_level_id_cur%rowtype;
89:
90: -- Check category_id is valid
91: CURSOR category_id_cur(ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE)
92: IS
93: SELECT category_id
94: FROM JTF_RS_ITEM_CATEGORIES_V
95: WHERE category_id = ll_category_id

Line 102: CURSOR category_catset_id_cur(ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,

98:
99: category_id_rec category_id_cur%rowtype;
100:
101: -- Check category_id is valid
102: CURSOR category_catset_id_cur(ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
103: ll_catset_id NUMBER )
104: IS
105: SELECT cat.category_id
106: FROM JTF_RS_ITEM_CATEGORIES_V cat,

Line 117: CURSOR subcategory_cur(ll_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE)

113:
114: category_catset_id_rec category_catset_id_cur%rowtype;
115:
116: -- Check subcategory is valid
117: CURSOR subcategory_cur(ll_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE)
118: IS
119: SELECT lookup_code, meaning
120: FROM FND_LOOKUPS
121: WHERE lookup_type = 'JTF_RS_SKILL_CAT_TYPE'

Line 127: CURSOR product_id_cur(ll_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,

123:
124: subcategory_rec subcategory_cur%rowtype;
125:
126: -- Check product_id is valid
127: CURSOR product_id_cur(ll_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
128: ll_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
129: IS
130: SELECT product_id
131: FROM JTF_RS_PRODUCTS_V

Line 128: ll_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)

124: subcategory_rec subcategory_cur%rowtype;
125:
126: -- Check product_id is valid
127: CURSOR product_id_cur(ll_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
128: ll_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
129: IS
130: SELECT product_id
131: FROM JTF_RS_PRODUCTS_V
132: WHERE product_id = ll_product_id

Line 140: CURSOR product_cat_id_cur(lpco_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,

136: product_id_rec product_id_cur%rowtype;
137:
138: -- Check product_id and category_id combination is valid
139: -- only if category_id is passed otherwise do not validate against it
140: CURSOR product_cat_id_cur(lpco_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
141: lpco_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
142: lpco_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
143: IS
144: SELECT p.product_id

Line 141: lpco_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,

137:
138: -- Check product_id and category_id combination is valid
139: -- only if category_id is passed otherwise do not validate against it
140: CURSOR product_cat_id_cur(lpco_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
141: lpco_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
142: lpco_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
143: IS
144: SELECT p.product_id
145: FROM JTF_RS_PRODUCTS_V p

Line 142: lpco_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)

138: -- Check product_id and category_id combination is valid
139: -- only if category_id is passed otherwise do not validate against it
140: CURSOR product_cat_id_cur(lpco_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
141: lpco_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
142: lpco_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
143: IS
144: SELECT p.product_id
145: FROM JTF_RS_PRODUCTS_V p
146: WHERE p.product_id = lpco_product_id

Line 157: CURSOR component_id_cur(ll_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,

153:
154: product_cat_id_rec product_cat_id_cur%rowtype;
155:
156: -- Check component_id is valid
157: CURSOR component_id_cur(ll_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
158: ll_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
159: ll_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE)
160: IS
161: SELECT component_id, product_id

Line 158: ll_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,

154: product_cat_id_rec product_cat_id_cur%rowtype;
155:
156: -- Check component_id is valid
157: CURSOR component_id_cur(ll_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
158: ll_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
159: ll_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE)
160: IS
161: SELECT component_id, product_id
162: FROM JTF_RS_COMPONENTS_V

Line 159: ll_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE)

155:
156: -- Check component_id is valid
157: CURSOR component_id_cur(ll_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
158: ll_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
159: ll_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE)
160: IS
161: SELECT component_id, product_id
162: FROM JTF_RS_COMPONENTS_V
163: WHERE component_id = ll_component_id

Line 172: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE;

168:
169: -- Check product, problem_code is valid
170: type prod_prob_code_cur_type is ref cursor;
171: prod_prob_code_cur prod_prob_code_cur_type;
172: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE;
173: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE;
174:
175: -- Check platform_id is valid
176: CURSOR platform_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,

Line 173: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE;

169: -- Check product, problem_code is valid
170: type prod_prob_code_cur_type is ref cursor;
171: prod_prob_code_cur prod_prob_code_cur_type;
172: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE;
173: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE;
174:
175: -- Check platform_id is valid
176: CURSOR platform_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
177: ll_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE)

Line 176: CURSOR platform_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,

172: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE;
173: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE;
174:
175: -- Check platform_id is valid
176: CURSOR platform_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
177: ll_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE)
178: IS
179: SELECT platform_id
180: FROM JTF_RS_PLATFORMS_V

Line 177: ll_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE)

173: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE;
174:
175: -- Check platform_id is valid
176: CURSOR platform_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
177: ll_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE)
178: IS
179: SELECT platform_id
180: FROM JTF_RS_PLATFORMS_V
181: WHERE platform_id = ll_platform_id

Line 187: CURSOR platform_cat_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,

183:
184: platform_id_rec platform_id_cur%rowtype;
185:
186: -- Check platform_id and category_id combination is valid
187: CURSOR platform_cat_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
188: ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
189: ll_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE)
190: IS
191: SELECT platform_id

Line 188: ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,

184: platform_id_rec platform_id_cur%rowtype;
185:
186: -- Check platform_id and category_id combination is valid
187: CURSOR platform_cat_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
188: ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
189: ll_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE)
190: IS
191: SELECT platform_id
192: FROM JTF_RS_PLATFORMS_V

Line 189: ll_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE)

185:
186: -- Check platform_id and category_id combination is valid
187: CURSOR platform_cat_id_cur(ll_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
188: ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
189: ll_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE)
190: IS
191: SELECT platform_id
192: FROM JTF_RS_PLATFORMS_V
193: WHERE platform_id = ll_platform_id

Line 200: CURSOR problem_code_cur(ll_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE)

196:
197: platform_cat_id_rec platform_cat_id_cur%rowtype;
198:
199: -- Check problem_code is valid
200: CURSOR problem_code_cur(ll_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE)
201: IS
202: SELECT problem_code
203: FROM JTF_RS_PROBLEM_CODES_V
204: WHERE problem_code = ll_problem_code

Line 212: CURSOR category_dup_cur (lpcat_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,

208:
209: problem_code_rec problem_code_cur%rowtype;
210:
211: -- Duplicate cursor check for category
212: CURSOR category_dup_cur (lpcat_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
213: lpcat_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE)
214: IS
215: SELECT resource_skill_id
216: FROM JTF_RS_RESOURCE_SKILLS

Line 213: lpcat_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE)

209: problem_code_rec problem_code_cur%rowtype;
210:
211: -- Duplicate cursor check for category
212: CURSOR category_dup_cur (lpcat_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
213: lpcat_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE)
214: IS
215: SELECT resource_skill_id
216: FROM JTF_RS_RESOURCE_SKILLS
217: WHERE resource_id = lpcat_resource_id

Line 216: FROM JTF_RS_RESOURCE_SKILLS

212: CURSOR category_dup_cur (lpcat_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
213: lpcat_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE)
214: IS
215: SELECT resource_skill_id
216: FROM JTF_RS_RESOURCE_SKILLS
217: WHERE resource_id = lpcat_resource_id
218: AND nvl(category_id,-99) = nvl(lpcat_category_id, -99)
219: AND subcategory is NULL;
220:

Line 224: CURSOR product_dup_cur (lpd_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,

220:
221: category_dup_rec category_dup_cur%rowtype;
222:
223: -- Duplicate cursor check for product
224: CURSOR product_dup_cur (lpd_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
225: lpd_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,
228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,

Line 225: lpd_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,

221: category_dup_rec category_dup_cur%rowtype;
222:
223: -- Duplicate cursor check for product
224: CURSOR product_dup_cur (lpd_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
225: lpd_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,
228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,
229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,

Line 226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,

222:
223: -- Duplicate cursor check for product
224: CURSOR product_dup_cur (lpd_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
225: lpd_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,
228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,
229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,
230: lpd_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)

Line 227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,

223: -- Duplicate cursor check for product
224: CURSOR product_dup_cur (lpd_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
225: lpd_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,
228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,
229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,
230: lpd_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
231: IS

Line 228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,

224: CURSOR product_dup_cur (lpd_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
225: lpd_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,
228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,
229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,
230: lpd_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
231: IS
232: SELECT resource_skill_id

Line 229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,

225: lpd_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,
228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,
229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,
230: lpd_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
231: IS
232: SELECT resource_skill_id
233: FROM JTF_RS_RESOURCE_SKILLS

Line 230: lpd_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)

226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,
228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,
229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,
230: lpd_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
231: IS
232: SELECT resource_skill_id
233: FROM JTF_RS_RESOURCE_SKILLS
234: WHERE resource_id = lpd_resource_id

Line 233: FROM JTF_RS_RESOURCE_SKILLS

229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,
230: lpd_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
231: IS
232: SELECT resource_skill_id
233: FROM JTF_RS_RESOURCE_SKILLS
234: WHERE resource_id = lpd_resource_id
235: AND subcategory = lpd_subcategory
236: AND product_id = lpd_product_id
237: AND product_org_id = lpd_product_org_id

Line 245: CURSOR platform_dup_cur (lpt_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,

241:
242: product_dup_rec product_dup_cur%rowtype;
243:
244: -- Duplicate cursor check for platform
245: CURSOR platform_dup_cur (lpt_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
246: lpt_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
247: lpt_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
248: lpt_platform_id JTF_RS_RESOURCE_SKILLS.platform_id%TYPE,
249: lpt_platform_org_id JTF_RS_RESOURCE_SKILLS.platform_org_id%TYPE)

Line 246: lpt_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,

242: product_dup_rec product_dup_cur%rowtype;
243:
244: -- Duplicate cursor check for platform
245: CURSOR platform_dup_cur (lpt_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
246: lpt_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
247: lpt_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
248: lpt_platform_id JTF_RS_RESOURCE_SKILLS.platform_id%TYPE,
249: lpt_platform_org_id JTF_RS_RESOURCE_SKILLS.platform_org_id%TYPE)
250: IS

Line 247: lpt_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,

243:
244: -- Duplicate cursor check for platform
245: CURSOR platform_dup_cur (lpt_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
246: lpt_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
247: lpt_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
248: lpt_platform_id JTF_RS_RESOURCE_SKILLS.platform_id%TYPE,
249: lpt_platform_org_id JTF_RS_RESOURCE_SKILLS.platform_org_id%TYPE)
250: IS
251: SELECT resource_skill_id

Line 248: lpt_platform_id JTF_RS_RESOURCE_SKILLS.platform_id%TYPE,

244: -- Duplicate cursor check for platform
245: CURSOR platform_dup_cur (lpt_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
246: lpt_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
247: lpt_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
248: lpt_platform_id JTF_RS_RESOURCE_SKILLS.platform_id%TYPE,
249: lpt_platform_org_id JTF_RS_RESOURCE_SKILLS.platform_org_id%TYPE)
250: IS
251: SELECT resource_skill_id
252: FROM JTF_RS_RESOURCE_SKILLS

Line 249: lpt_platform_org_id JTF_RS_RESOURCE_SKILLS.platform_org_id%TYPE)

245: CURSOR platform_dup_cur (lpt_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
246: lpt_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
247: lpt_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
248: lpt_platform_id JTF_RS_RESOURCE_SKILLS.platform_id%TYPE,
249: lpt_platform_org_id JTF_RS_RESOURCE_SKILLS.platform_org_id%TYPE)
250: IS
251: SELECT resource_skill_id
252: FROM JTF_RS_RESOURCE_SKILLS
253: WHERE resource_id = lpt_resource_id

Line 252: FROM JTF_RS_RESOURCE_SKILLS

248: lpt_platform_id JTF_RS_RESOURCE_SKILLS.platform_id%TYPE,
249: lpt_platform_org_id JTF_RS_RESOURCE_SKILLS.platform_org_id%TYPE)
250: IS
251: SELECT resource_skill_id
252: FROM JTF_RS_RESOURCE_SKILLS
253: WHERE resource_id = lpt_resource_id
254: AND subcategory = lpt_subcategory
255: AND platform_id = lpt_platform_id
256: AND platform_org_id = lpt_platform_org_id

Line 262: CURSOR problem_code_dup_cur (lpc_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,

258:
259: platform_dup_rec platform_dup_cur%rowtype;
260:
261: -- Duplicate cursor check for problem_code
262: CURSOR problem_code_dup_cur (lpc_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
263: lpc_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
264: lpc_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
265: lpc_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE)
266: IS

Line 263: lpc_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,

259: platform_dup_rec platform_dup_cur%rowtype;
260:
261: -- Duplicate cursor check for problem_code
262: CURSOR problem_code_dup_cur (lpc_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
263: lpc_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
264: lpc_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
265: lpc_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE)
266: IS
267: SELECT resource_skill_id

Line 264: lpc_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,

260:
261: -- Duplicate cursor check for problem_code
262: CURSOR problem_code_dup_cur (lpc_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
263: lpc_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
264: lpc_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
265: lpc_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE)
266: IS
267: SELECT resource_skill_id
268: FROM JTF_RS_RESOURCE_SKILLS

Line 265: lpc_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE)

261: -- Duplicate cursor check for problem_code
262: CURSOR problem_code_dup_cur (lpc_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
263: lpc_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
264: lpc_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
265: lpc_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE)
266: IS
267: SELECT resource_skill_id
268: FROM JTF_RS_RESOURCE_SKILLS
269: WHERE resource_id = lpc_resource_id

Line 268: FROM JTF_RS_RESOURCE_SKILLS

264: lpc_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
265: lpc_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE)
266: IS
267: SELECT resource_skill_id
268: FROM JTF_RS_RESOURCE_SKILLS
269: WHERE resource_id = lpc_resource_id
270: AND subcategory = lpc_subcategory
271: AND problem_code = lpc_problem_code
272: AND nvl(category_id, -99) = nvl(lpc_category_id, -99) ;

Line 626: SELECT jtf_rs_resource_skills_s.nextval

622: -----------------------------------------------------------------------
623:
624: IF (l_go_ahead = 'YES') THEN
625:
626: SELECT jtf_rs_resource_skills_s.nextval
627: INTO l_resource_skill_id
628: FROM dual;
629:
630: JTF_RS_RESOURCE_SKILLS_PKG.INSERT_ROW(

Line 630: JTF_RS_RESOURCE_SKILLS_PKG.INSERT_ROW(

626: SELECT jtf_rs_resource_skills_s.nextval
627: INTO l_resource_skill_id
628: FROM dual;
629:
630: JTF_RS_RESOURCE_SKILLS_PKG.INSERT_ROW(
631: X_ROWID => l_rowid,
632: X_RESOURCE_SKILL_ID => l_resource_skill_id,
633: X_RESOURCE_ID => p_resource_id,
634: X_SKILL_LEVEL_ID => p_SKILL_LEVEL_ID,

Line 718: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,

714: PROCEDURE update_resource_skills
715: (P_API_VERSION IN NUMBER,
716: P_INIT_MSG_LIST IN VARCHAR2,
717: P_COMMIT IN VARCHAR2,
718: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,

Line 719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,

715: (P_API_VERSION IN NUMBER,
716: P_INIT_MSG_LIST IN VARCHAR2,
717: P_COMMIT IN VARCHAR2,
718: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,

Line 720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,

716: P_INIT_MSG_LIST IN VARCHAR2,
717: P_COMMIT IN VARCHAR2,
718: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,

Line 721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,

717: P_COMMIT IN VARCHAR2,
718: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,

Line 722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,

718: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,

Line 723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,

719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,

Line 724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,

720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,

Line 725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,

721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,

Line 726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,

722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,

Line 727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,

723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,

Line 728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,

724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,

Line 729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,

725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,

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

726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,

Line 731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,

727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,

Line 732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,

728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,

Line 733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,

729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,

Line 734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,

730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,

Line 735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,

731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,

Line 736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,

732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,

Line 737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,

733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,

Line 738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,

734: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,
735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,

Line 739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,

735: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE,
736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,

Line 740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,

736: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE,
737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
744: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,

Line 741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,

737: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE,
738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
744: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
745: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,

Line 742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,

738: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE,
739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
744: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
745: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
746: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,

Line 743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,

739: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE,
740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
744: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
745: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
746: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,
747: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 744: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,

740: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE,
741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
744: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
745: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
746: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,
747: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
748: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 745: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,

741: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE,
742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
744: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
745: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
746: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,
747: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
748: X_MSG_COUNT OUT NOCOPY NUMBER,
749: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 746: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,

742: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE,
743: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE,
744: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE,
745: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE,
746: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE,
747: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
748: X_MSG_COUNT OUT NOCOPY NUMBER,
749: X_MSG_DATA OUT NOCOPY VARCHAR2
750: )IS

Line 759: L_ATTRIBUTE1 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE;

755: l_count NUMBER;
756: l_data VARCHAR2(200);
757:
758:
759: L_ATTRIBUTE1 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE;
760: L_ATTRIBUTE2 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE;
761: L_ATTRIBUTE3 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE;
762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;
763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;

Line 760: L_ATTRIBUTE2 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE;

756: l_data VARCHAR2(200);
757:
758:
759: L_ATTRIBUTE1 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE;
760: L_ATTRIBUTE2 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE;
761: L_ATTRIBUTE3 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE;
762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;
763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;
764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;

Line 761: L_ATTRIBUTE3 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE;

757:
758:
759: L_ATTRIBUTE1 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE;
760: L_ATTRIBUTE2 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE;
761: L_ATTRIBUTE3 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE;
762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;
763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;
764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;
765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;

Line 762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;

758:
759: L_ATTRIBUTE1 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE;
760: L_ATTRIBUTE2 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE;
761: L_ATTRIBUTE3 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE;
762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;
763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;
764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;
765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;
766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;

Line 763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;

759: L_ATTRIBUTE1 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE;
760: L_ATTRIBUTE2 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE;
761: L_ATTRIBUTE3 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE;
762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;
763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;
764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;
765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;
766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;
767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;

Line 764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;

760: L_ATTRIBUTE2 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE;
761: L_ATTRIBUTE3 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE;
762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;
763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;
764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;
765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;
766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;
767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;
768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;

Line 765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;

761: L_ATTRIBUTE3 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE;
762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;
763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;
764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;
765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;
766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;
767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;
768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;
769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;

Line 766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;

762: L_ATTRIBUTE4 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE;
763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;
764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;
765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;
766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;
767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;
768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;
769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;
770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;

Line 767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;

763: L_ATTRIBUTE5 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE;
764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;
765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;
766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;
767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;
768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;
769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;
770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;
771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;

Line 768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;

764: L_ATTRIBUTE6 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE;
765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;
766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;
767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;
768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;
769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;
770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;
771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;
772: L_ATTRIBUTE14 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE;

Line 769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;

765: L_ATTRIBUTE7 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE;
766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;
767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;
768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;
769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;
770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;
771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;
772: L_ATTRIBUTE14 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE;
773: L_ATTRIBUTE15 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE;

Line 770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;

766: L_ATTRIBUTE8 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE;
767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;
768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;
769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;
770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;
771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;
772: L_ATTRIBUTE14 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE;
773: L_ATTRIBUTE15 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE;
774: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE;

Line 771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;

767: L_ATTRIBUTE9 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE;
768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;
769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;
770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;
771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;
772: L_ATTRIBUTE14 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE;
773: L_ATTRIBUTE15 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE;
774: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE;
775:

Line 772: L_ATTRIBUTE14 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE;

768: L_ATTRIBUTE10 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE;
769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;
770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;
771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;
772: L_ATTRIBUTE14 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE;
773: L_ATTRIBUTE15 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE;
774: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE;
775:
776:

Line 773: L_ATTRIBUTE15 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE;

769: L_ATTRIBUTE11 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE;
770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;
771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;
772: L_ATTRIBUTE14 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE;
773: L_ATTRIBUTE15 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE;
774: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE;
775:
776:
777: CURSOR resource_skills_cur(ll_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE)

Line 774: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE;

770: L_ATTRIBUTE12 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE;
771: L_ATTRIBUTE13 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE;
772: L_ATTRIBUTE14 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE;
773: L_ATTRIBUTE15 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE;
774: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE;
775:
776:
777: CURSOR resource_skills_cur(ll_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE)
778: IS

Line 777: CURSOR resource_skills_cur(ll_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE)

773: L_ATTRIBUTE15 JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE;
774: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE;
775:
776:
777: CURSOR resource_skills_cur(ll_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE)
778: IS
779: SELECT
780: RESOURCE_SKILL_ID,
781: RESOURCE_ID,

Line 814: FROM jtf_rs_resource_skills

810: CREATION_DATE,
811: LAST_UPDATED_BY,
812: LAST_UPDATE_DATE,
813: LAST_UPDATE_LOGIN
814: FROM jtf_rs_resource_skills
815: WHERE resource_skill_id = ll_resource_skill_id;
816:
817: resource_skills_rec resource_skills_cur%rowtype;
818:

Line 819: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE := p_resource_skill_id;

815: WHERE resource_skill_id = ll_resource_skill_id;
816:
817: resource_skills_rec resource_skills_cur%rowtype;
818:
819: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE := p_resource_skill_id;
820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;
821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;

Line 820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;

816:
817: resource_skills_rec resource_skills_cur%rowtype;
818:
819: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE := p_resource_skill_id;
820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;
821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;

Line 821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;

817: resource_skills_rec resource_skills_cur%rowtype;
818:
819: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE := p_resource_skill_id;
820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;
821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;

Line 822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;

818:
819: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE := p_resource_skill_id;
820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;
821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;

Line 823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;

819: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE := p_resource_skill_id;
820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;
821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;

Line 824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;

820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;
821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;
828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;

Line 825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;

821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;
828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;
829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;

Line 826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;

822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;
828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;
829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;
830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;

Line 827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;

823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;
828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;
829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;
830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;
831:

Line 828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;

824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;
828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;
829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;
830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;
831:
832: l_object_version_number JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_num;

Line 829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;

825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;
828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;
829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;
830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;
831:
832: l_object_version_number JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_num;
833:

Line 830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;

826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;
828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;
829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;
830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;
831:
832: l_object_version_number JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_num;
833:
834: l_return_status VARCHAR2(200);

Line 832: l_object_version_number JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_num;

828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;
829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;
830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;
831:
832: l_object_version_number JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_num;
833:
834: l_return_status VARCHAR2(200);
835: l_msg_count NUMBER;
836: l_msg_data VARCHAR2(200);

Line 1066: jtf_rs_resource_skills_pkg.lock_row(

1062: -------------------------------------------------------------------------------------------
1063:
1064: BEGIN
1065:
1066: jtf_rs_resource_skills_pkg.lock_row(
1067: X_RESOURCE_SKILL_ID => l_resource_skill_id,
1068: X_OBJECT_VERSION_NUMBER => p_object_version_num
1069: );
1070:

Line 1083: jtf_rs_resource_skills_pkg.update_row(

1079: END;
1080:
1081: l_object_version_number := l_object_version_number +1;
1082:
1083: jtf_rs_resource_skills_pkg.update_row(
1084: X_RESOURCE_SKILL_ID => l_resource_skill_id,
1085: X_RESOURCE_ID => l_resource_id,
1086: X_SKILL_LEVEL_ID => l_SKILL_LEVEL_ID,
1087: X_CATEGORY_ID => l_category_id,

Line 1168: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,

1164: PROCEDURE delete_resource_skills
1165: (P_API_VERSION IN NUMBER,
1166: P_INIT_MSG_LIST IN VARCHAR2,
1167: P_COMMIT IN VARCHAR2,
1168: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
1169: P_OBJECT_VERSION_NUM IN JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
1170: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1171: X_MSG_COUNT OUT NOCOPY NUMBER,
1172: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1169: P_OBJECT_VERSION_NUM IN JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,

1165: (P_API_VERSION IN NUMBER,
1166: P_INIT_MSG_LIST IN VARCHAR2,
1167: P_COMMIT IN VARCHAR2,
1168: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
1169: P_OBJECT_VERSION_NUM IN JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
1170: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1171: X_MSG_COUNT OUT NOCOPY NUMBER,
1172: X_MSG_DATA OUT NOCOPY VARCHAR2
1173: )IS

Line 1176: CURSOR chk_res_exist_cur(ll_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE)

1172: X_MSG_DATA OUT NOCOPY VARCHAR2
1173: )IS
1174:
1175:
1176: CURSOR chk_res_exist_cur(ll_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE)
1177: IS
1178: SELECT resource_id
1179: FROM JTF_RS_RESOURCE_SKILLS
1180: WHERE resource_skill_id = ll_resource_skill_id;

Line 1179: FROM JTF_RS_RESOURCE_SKILLS

1175:
1176: CURSOR chk_res_exist_cur(ll_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE)
1177: IS
1178: SELECT resource_id
1179: FROM JTF_RS_RESOURCE_SKILLS
1180: WHERE resource_skill_id = ll_resource_skill_id;
1181:
1182: chk_res_exist_rec chk_res_exist_cur%rowtype;
1183:

Line 1184: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.resource_skill_id%TYPE := p_resource_skill_id;

1180: WHERE resource_skill_id = ll_resource_skill_id;
1181:
1182: chk_res_exist_rec chk_res_exist_cur%rowtype;
1183:
1184: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.resource_skill_id%TYPE := p_resource_skill_id;
1185:
1186: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_SKILLS';
1187: l_api_version CONSTANT NUMBER := 1.0;
1188:

Line 1225: JTF_RS_RESOURCE_SKILLS_PKG.DELETE_ROW(

1221: FETCH chk_res_exist_cur INTO chk_res_exist_rec;
1222: IF (chk_res_exist_cur%FOUND)
1223: THEN
1224:
1225: JTF_RS_RESOURCE_SKILLS_PKG.DELETE_ROW(
1226: X_RESOURCE_SKILL_ID => l_resource_skill_id);
1227:
1228: ELSIF (chk_res_exist_cur%notfound) THEN
1229: x_return_status := fnd_api.g_ret_sts_error;

Line 1269: END JTF_RS_RESOURCE_SKILLS_PVT;

1265: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1266:
1267: END delete_resource_skills;
1268:
1269: END JTF_RS_RESOURCE_SKILLS_PVT;