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_JOB_ROLES_PVT dependencies on JTF_RS_JOB_ROLES

Line 1: PACKAGE jtf_rs_job_roles_pvt AUTHID CURRENT_USER AS

1: PACKAGE jtf_rs_job_roles_pvt AUTHID CURRENT_USER AS
2: /* $Header: jtfrsvns.pls 120.0 2005/05/11 08:23:10 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that caller will invoke.

Line 23: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,

19: PROCEDURE create_resource_job_roles
20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
24: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 24: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,

20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
24: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 25: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,

21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
24: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,

22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
24: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,

23: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
24: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,

24: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,

25: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,

26: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,

27: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,

28: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,

29: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,

30: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,

31: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,

32: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,

33: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 38: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,

34: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 39: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE DEFAULT NULL,

35: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42: X_MSG_COUNT OUT NOCOPY NUMBER,
43: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 40: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

36: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42: X_MSG_COUNT OUT NOCOPY NUMBER,
43: X_MSG_DATA OUT NOCOPY VARCHAR2,
44: X_JOB_ROLE_ID OUT NOCOPY JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE

Line 44: X_JOB_ROLE_ID OUT NOCOPY JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE

40: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42: X_MSG_COUNT OUT NOCOPY NUMBER,
43: X_MSG_DATA OUT NOCOPY VARCHAR2,
44: X_JOB_ROLE_ID OUT NOCOPY JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE
45: );
46:
47:
48:

Line 55: P_JOB_ROLE_ID IN JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE,

51: PROCEDURE delete_resource_job_roles
52: (P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_JOB_ROLE_ID IN JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE,
56: P_OBJECT_VERSION_NUM IN JTF_RS_JOB_ROLES.OBJECT_VERSION_NUMBER%TYPE,
57: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
58: X_MSG_COUNT OUT NOCOPY NUMBER,
59: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 56: P_OBJECT_VERSION_NUM IN JTF_RS_JOB_ROLES.OBJECT_VERSION_NUMBER%TYPE,

52: (P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_JOB_ROLE_ID IN JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE,
56: P_OBJECT_VERSION_NUM IN JTF_RS_JOB_ROLES.OBJECT_VERSION_NUMBER%TYPE,
57: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
58: X_MSG_COUNT OUT NOCOPY NUMBER,
59: X_MSG_DATA OUT NOCOPY VARCHAR2
60: );

Line 63: END jtf_rs_job_roles_pvt;

59: X_MSG_DATA OUT NOCOPY VARCHAR2
60: );
61:
62:
63: END jtf_rs_job_roles_pvt;