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

1: PACKAGE BODY jtf_rs_job_roles_pvt AS
2: /* $Header: jtfrsvnb.pls 120.0 2005/05/11 08:23:09 appldev ship $ */
3:
4: /*****************************************************************************************
5: This private package body defines the procedures for managing resource job roles,

Line 16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_JOB_ROLES_PVT';

12: ******************************************************************************************/
13:
14: /* Package variables. */
15:
16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_JOB_ROLES_PVT';
17:
18:
19: /* Procedure to create the resource job roles
20: based on input values passed by calling routines. */

Line 26: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,

22: PROCEDURE create_resource_job_roles
23: (P_API_VERSION IN NUMBER,
24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
27: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE,
29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,
30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,

Line 27: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,

23: (P_API_VERSION IN NUMBER,
24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
27: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE,
29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,
30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,
31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,

Line 28: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE,

24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
27: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE,
29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,
30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,
31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,
32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,

Line 29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,

25: P_COMMIT IN VARCHAR2,
26: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
27: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE,
29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,
30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,
31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,
32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,
33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,

Line 30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,

26: P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
27: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE,
29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,
30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,
31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,
32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,
33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,
34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,

Line 31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,

27: P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE,
29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,
30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,
31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,
32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,
33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,
34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,
35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,

Line 32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,

28: P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE,
29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,
30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,
31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,
32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,
33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,
34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,
35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,
36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,

Line 33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,

29: P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE,
30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,
31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,
32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,
33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,
34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,
35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,
36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,
37: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE,

Line 34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,

30: P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE,
31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,
32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,
33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,
34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,
35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,
36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,
37: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE,
38: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE,

Line 35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,

31: P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE,
32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,
33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,
34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,
35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,
36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,
37: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE,
38: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE,
39: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE,

Line 36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,

32: P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE,
33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,
34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,
35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,
36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,
37: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE,
38: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE,
39: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE,
40: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE,

Line 37: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE,

33: P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE,
34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,
35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,
36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,
37: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE,
38: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE,
39: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE,
40: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE,
41: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE,

Line 38: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE,

34: P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE,
35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,
36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,
37: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE,
38: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE,
39: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE,
40: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE,
41: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE,
42: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE,

Line 39: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE,

35: P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE,
36: P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE,
37: P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE,
38: P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE,
39: P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE,
40: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE,
41: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE,
42: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE,
43: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE,

Line 40: P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE,

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

Line 41: P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE,

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

Line 42: P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE,

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

Line 43: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE,

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

Line 47: X_JOB_ROLE_ID OUT NOCOPY JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE

43: P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE,
44: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
45: X_MSG_COUNT OUT NOCOPY NUMBER,
46: X_MSG_DATA OUT NOCOPY VARCHAR2,
47: X_JOB_ROLE_ID OUT NOCOPY JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE
48: ) IS
49:
50: l_api_version CONSTANT NUMBER := 1.0;
51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_JOB_ROLES';

Line 53: l_job_id jtf_rs_job_roles.job_id%TYPE := p_job_id;

49:
50: l_api_version CONSTANT NUMBER := 1.0;
51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_JOB_ROLES';
52: l_rowid ROWID;
53: l_job_id jtf_rs_job_roles.job_id%TYPE := p_job_id;
54: l_role_id jtf_rs_job_roles.role_id%type := p_role_id;
55: l_job_role_id jtf_rs_job_roles.job_role_id%TYPE;
56: l_check_char VARCHAR2(1);
57: l_check_count NUMBER;

Line 54: l_role_id jtf_rs_job_roles.role_id%type := p_role_id;

50: l_api_version CONSTANT NUMBER := 1.0;
51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_JOB_ROLES';
52: l_rowid ROWID;
53: l_job_id jtf_rs_job_roles.job_id%TYPE := p_job_id;
54: l_role_id jtf_rs_job_roles.role_id%type := p_role_id;
55: l_job_role_id jtf_rs_job_roles.job_role_id%TYPE;
56: l_check_char VARCHAR2(1);
57: l_check_count NUMBER;
58:

Line 55: l_job_role_id jtf_rs_job_roles.job_role_id%TYPE;

51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_JOB_ROLES';
52: l_rowid ROWID;
53: l_job_id jtf_rs_job_roles.job_id%TYPE := p_job_id;
54: l_role_id jtf_rs_job_roles.role_id%type := p_role_id;
55: l_job_role_id jtf_rs_job_roles.job_role_id%TYPE;
56: l_check_char VARCHAR2(1);
57: l_check_count NUMBER;
58:
59:

Line 60: CURSOR c_jtf_rs_job_roles( l_rowid IN ROWID ) IS

56: l_check_char VARCHAR2(1);
57: l_check_count NUMBER;
58:
59:
60: CURSOR c_jtf_rs_job_roles( l_rowid IN ROWID ) IS
61: SELECT 'Y'
62: FROM jtf_rs_job_roles
63: WHERE ROWID = l_rowid;
64:

Line 62: FROM jtf_rs_job_roles

58:
59:
60: CURSOR c_jtf_rs_job_roles( l_rowid IN ROWID ) IS
61: SELECT 'Y'
62: FROM jtf_rs_job_roles
63: WHERE ROWID = l_rowid;
64:
65:
66: BEGIN

Line 94: FROM jtf_rs_job_roles

90: l_check_count := 0;
91:
92: SELECT count(*)
93: INTO l_check_count
94: FROM jtf_rs_job_roles
95: WHERE job_id = l_job_id
96: AND role_id = l_role_id;
97:
98: IF l_check_count > 0 THEN

Line 112: SELECT jtf_rs_job_roles_s.nextval

108:
109:
110: /* Get the next value of the Job_Role_id from the sequence. */
111:
112: SELECT jtf_rs_job_roles_s.nextval
113: INTO l_job_role_id
114: FROM dual;
115:
116:

Line 119: jtf_rs_job_roles_pkg.insert_row(

115:
116:
117: /* Insert the row into the table by calling the table handler. */
118:
119: jtf_rs_job_roles_pkg.insert_row(
120: x_rowid => l_rowid,
121: x_job_role_id => l_job_role_id,
122: x_job_id => l_job_id,
123: x_role_id => l_role_id,

Line 148: OPEN c_jtf_rs_job_roles(l_rowid);

144: x_last_update_login => jtf_resource_utl.login_id
145: );
146:
147:
148: OPEN c_jtf_rs_job_roles(l_rowid);
149:
150: FETCH c_jtf_rs_job_roles INTO l_check_char;
151:
152:

Line 150: FETCH c_jtf_rs_job_roles INTO l_check_char;

146:
147:
148: OPEN c_jtf_rs_job_roles(l_rowid);
149:
150: FETCH c_jtf_rs_job_roles INTO l_check_char;
151:
152:
153: IF c_jtf_rs_job_roles%NOTFOUND THEN
154:

Line 153: IF c_jtf_rs_job_roles%NOTFOUND THEN

149:
150: FETCH c_jtf_rs_job_roles INTO l_check_char;
151:
152:
153: IF c_jtf_rs_job_roles%NOTFOUND THEN
154:
155: x_return_status := fnd_api.g_ret_sts_unexp_error;
156:
157: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

Line 160: IF c_jtf_rs_job_roles%ISOPEN THEN

156:
157: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
158: fnd_msg_pub.add;
159:
160: IF c_jtf_rs_job_roles%ISOPEN THEN
161:
162: CLOSE c_jtf_rs_job_roles;
163:
164: END IF;

Line 162: CLOSE c_jtf_rs_job_roles;

158: fnd_msg_pub.add;
159:
160: IF c_jtf_rs_job_roles%ISOPEN THEN
161:
162: CLOSE c_jtf_rs_job_roles;
163:
164: END IF;
165:
166: RAISE fnd_api.g_exc_unexpected_error;

Line 177: IF c_jtf_rs_job_roles%ISOPEN THEN

173:
174:
175: /* Close the cursor */
176:
177: IF c_jtf_rs_job_roles%ISOPEN THEN
178:
179: CLOSE c_jtf_rs_job_roles;
180:
181: END IF;

Line 179: CLOSE c_jtf_rs_job_roles;

175: /* Close the cursor */
176:
177: IF c_jtf_rs_job_roles%ISOPEN THEN
178:
179: CLOSE c_jtf_rs_job_roles;
180:
181: END IF;
182:
183:

Line 224: P_JOB_ROLE_ID IN JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE,

220: PROCEDURE delete_resource_job_roles
221: (P_API_VERSION IN NUMBER,
222: P_INIT_MSG_LIST IN VARCHAR2,
223: P_COMMIT IN VARCHAR2,
224: P_JOB_ROLE_ID IN JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE,
225: P_OBJECT_VERSION_NUM IN JTF_RS_JOB_ROLES.OBJECT_VERSION_NUMBER%TYPE,
226: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
227: X_MSG_COUNT OUT NOCOPY NUMBER,
228: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 225: P_OBJECT_VERSION_NUM IN JTF_RS_JOB_ROLES.OBJECT_VERSION_NUMBER%TYPE,

221: (P_API_VERSION IN NUMBER,
222: P_INIT_MSG_LIST IN VARCHAR2,
223: P_COMMIT IN VARCHAR2,
224: P_JOB_ROLE_ID IN JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE,
225: P_OBJECT_VERSION_NUM IN JTF_RS_JOB_ROLES.OBJECT_VERSION_NUMBER%TYPE,
226: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
227: X_MSG_COUNT OUT NOCOPY NUMBER,
228: X_MSG_DATA OUT NOCOPY VARCHAR2
229: )

Line 235: l_job_role_id jtf_rs_job_roles.job_role_id%TYPE := p_job_role_id;

231: IS
232:
233: l_api_version CONSTANT NUMBER := 1.0;
234: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_JOB_ROLES';
235: l_job_role_id jtf_rs_job_roles.job_role_id%TYPE := p_job_role_id;
236: l_check_char VARCHAR2(1);
237:
238:
239: BEGIN

Line 267: jtf_rs_job_roles_pkg.lock_row(

263: is still valid. */
264:
265: BEGIN
266:
267: jtf_rs_job_roles_pkg.lock_row(
268: x_job_role_id => l_job_role_id,
269: x_object_version_number => p_object_version_num
270: );
271:

Line 292: jtf_rs_job_roles_pkg.delete_row(

288: BEGIN
289:
290: /* Delete the row into the table by calling the table handler. */
291:
292: jtf_rs_job_roles_pkg.delete_row(
293: x_job_role_id => l_job_role_id
294: );
295:
296: EXCEPTION

Line 343: END jtf_rs_job_roles_pvt;

339:
340: END delete_resource_job_roles;
341:
342:
343: END jtf_rs_job_roles_pvt;