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_GROUP_MEMBERS_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1: PACKAGE BODY jtf_rs_group_members_pvt AS

1: PACKAGE BODY jtf_rs_group_members_pvt AS
2: /* $Header: jtfrsvmb.pls 120.0 2005/05/11 08:23:08 appldev ship $ */
3:
4: /*****************************************************************************************
5: This private package body defines the procedures for managing resource group members,

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

12: ******************************************************************************************/
13:
14: /* Package variables. */
15:
16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_GROUP_MEMBERS_PVT';
17:
18:
19: /*Procedure to assign value to the global variable */
20: PROCEDURE assign_value_to_global

Line 24: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

20: PROCEDURE assign_value_to_global
21: (P_API_VERSION IN NUMBER,
22: P_INIT_MSG_LIST IN VARCHAR2,
23: P_COMMIT IN VARCHAR2,
24: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
25: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26: X_MSG_COUNT OUT NOCOPY NUMBER,
27: X_MSG_DATA OUT NOCOPY VARCHAR2
28: )

Line 48: jtf_rs_group_members_pvt.g_moved_fr_group_id := p_group_id;

44: fnd_msg_pub.initialize;
45: END IF;
46:
47: --assign the value;
48: jtf_rs_group_members_pvt.g_moved_fr_group_id := p_group_id;
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: ROLLBACK TO assign_value_sp;

Line 70: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

66: PROCEDURE create_resource_group_members
67: (P_API_VERSION IN NUMBER,
68: P_INIT_MSG_LIST IN VARCHAR2,
69: P_COMMIT IN VARCHAR2,
70: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
71: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
72: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,

Line 71: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

67: (P_API_VERSION IN NUMBER,
68: P_INIT_MSG_LIST IN VARCHAR2,
69: P_COMMIT IN VARCHAR2,
70: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
71: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
72: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,

Line 72: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,

68: P_INIT_MSG_LIST IN VARCHAR2,
69: P_COMMIT IN VARCHAR2,
70: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
71: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
72: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,

Line 73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,

69: P_COMMIT IN VARCHAR2,
70: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
71: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
72: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,

Line 74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,

70: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
71: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
72: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,

Line 75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,

71: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
72: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,

Line 76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,

72: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,

Line 77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,

73: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,

Line 78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,

74: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,

Line 79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,

75: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,

Line 80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,

76: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,

Line 81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,

77: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
85: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,

Line 82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,

78: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
85: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
86: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,

Line 83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,

79: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
85: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
86: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
87: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,

Line 84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,

80: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
85: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
86: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
87: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
88: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 85: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,

81: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
85: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
86: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
87: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
88: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 86: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,

82: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
85: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
86: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
87: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
88: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89: X_MSG_COUNT OUT NOCOPY NUMBER,
90: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 87: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,

83: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
84: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
85: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
86: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
87: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
88: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89: X_MSG_COUNT OUT NOCOPY NUMBER,
90: X_MSG_DATA OUT NOCOPY VARCHAR2,
91: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE

Line 91: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE

87: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
88: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89: X_MSG_COUNT OUT NOCOPY NUMBER,
90: X_MSG_DATA OUT NOCOPY VARCHAR2,
91: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE
92: ) IS
93:
94: l_api_version CONSTANT NUMBER := 1.0;
95: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP_MEMBERS';

Line 97: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;

93:
94: l_api_version CONSTANT NUMBER := 1.0;
95: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP_MEMBERS';
96: l_rowid ROWID;
97: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
98: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
99: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
100: l_person_id jtf_rs_group_members.person_id%TYPE;
101: l_check_char VARCHAR2(1);

Line 98: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;

94: l_api_version CONSTANT NUMBER := 1.0;
95: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP_MEMBERS';
96: l_rowid ROWID;
97: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
98: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
99: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
100: l_person_id jtf_rs_group_members.person_id%TYPE;
101: l_check_char VARCHAR2(1);
102: l_check_count NUMBER;

Line 99: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;

95: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP_MEMBERS';
96: l_rowid ROWID;
97: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
98: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
99: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
100: l_person_id jtf_rs_group_members.person_id%TYPE;
101: l_check_char VARCHAR2(1);
102: l_check_count NUMBER;
103: l_bind_data_id NUMBER;

Line 100: l_person_id jtf_rs_group_members.person_id%TYPE;

96: l_rowid ROWID;
97: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
98: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
99: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
100: l_person_id jtf_rs_group_members.person_id%TYPE;
101: l_check_char VARCHAR2(1);
102: l_check_count NUMBER;
103: l_bind_data_id NUMBER;
104: l_return_status VARCHAR2(1);

Line 108: CURSOR c_jtf_rs_group_members( l_rowid IN ROWID ) IS

104: l_return_status VARCHAR2(1);
105: l_msg_data VARCHAR2(2000);
106: l_msg_count NUMBER;
107:
108: CURSOR c_jtf_rs_group_members( l_rowid IN ROWID ) IS
109: SELECT 'Y'
110: FROM jtf_rs_group_members
111: WHERE ROWID = l_rowid;
112:

Line 110: FROM jtf_rs_group_members

106: l_msg_count NUMBER;
107:
108: CURSOR c_jtf_rs_group_members( l_rowid IN ROWID ) IS
109: SELECT 'Y'
110: FROM jtf_rs_group_members
111: WHERE ROWID = l_rowid;
112:
113:
114: CURSOR c_employee_person_id( l_resource_id IN NUMBER ) IS

Line 166: 'JTF_RS_GROUP_MEMBERS_PVT',

162:
163: /* Pre Call to the Customer Type User Hook */
164:
165: IF jtf_resource_utl.ok_to_execute(
166: 'JTF_RS_GROUP_MEMBERS_PVT',
167: 'CREATE_RESOURCE_GROUP_MEMBERS',
168: 'B',
169: 'C')
170: THEN

Line 172: 'JTF_RS_GROUP_MEMBERS_PVT',

168: 'B',
169: 'C')
170: THEN
171: IF jtf_usr_hks.ok_to_execute(
172: 'JTF_RS_GROUP_MEMBERS_PVT',
173: 'CREATE_RESOURCE_GROUP_MEMBERS',
174: 'B',
175: 'C')
176: THEN

Line 205: 'JTF_RS_GROUP_MEMBERS_PVT',

201:
202: /* Pre Call to the Vertical Type User Hook */
203:
204: IF jtf_resource_utl.ok_to_execute(
205: 'JTF_RS_GROUP_MEMBERS_PVT',
206: 'CREATE_RESOURCE_GROUP_MEMBERS',
207: 'B',
208: 'V')
209: THEN

Line 211: 'JTF_RS_GROUP_MEMBERS_PVT',

207: 'B',
208: 'V')
209: THEN
210: IF jtf_usr_hks.ok_to_execute(
211: 'JTF_RS_GROUP_MEMBERS_PVT',
212: 'CREATE_RESOURCE_GROUP_MEMBERS',
213: 'B',
214: 'V')
215: THEN

Line 244: 'JTF_RS_GROUP_MEMBERS_PVT',

240:
241: /* Pre Call to the Internal Type User Hook */
242:
243: IF jtf_resource_utl.ok_to_execute(
244: 'JTF_RS_GROUP_MEMBERS_PVT',
245: 'CREATE_RESOURCE_GROUP_MEMBERS',
246: 'B',
247: 'I')
248: THEN

Line 250: 'JTF_RS_GROUP_MEMBERS_PVT',

246: 'B',
247: 'I')
248: THEN
249: IF jtf_usr_hks.ok_to_execute(
250: 'JTF_RS_GROUP_MEMBERS_PVT',
251: 'CREATE_RESOURCE_GROUP_MEMBERS',
252: 'B',
253: 'I')
254: THEN

Line 286: FROM jtf_rs_group_members

282: l_check_count := 0;
283:
284: SELECT count(*)
285: INTO l_check_count
286: FROM jtf_rs_group_members
287: WHERE group_id = l_group_id
288: AND resource_id = l_resource_id
289: AND nvl(delete_flag,'N') <> 'Y';
290:

Line 322: SELECT jtf_rs_group_members_s.nextval

318:
319:
320: /* Get the next value of the Group_member_id from the sequence. */
321:
322: SELECT jtf_rs_group_members_s.nextval
323: INTO l_group_member_id
324: FROM dual;
325:
326:

Line 329: jtf_rs_group_members_aud_pvt.insert_member

325:
326:
327: /* Make a call to the group member Audit API */
328:
329: jtf_rs_group_members_aud_pvt.insert_member
330: (P_API_VERSION => 1,
331: P_INIT_MSG_LIST => fnd_api.g_false,
332: P_COMMIT => fnd_api.g_false,
333: P_GROUP_MEMBER_ID => l_group_member_id,

Line 359: jtf_rs_group_members_pkg.insert_row(

355:
356:
357: /* Insert the row into the table by calling the table handler. */
358:
359: jtf_rs_group_members_pkg.insert_row(
360: x_rowid => l_rowid,
361: x_group_member_id => l_group_member_id,
362: x_group_id => l_group_id,
363: x_resource_id => l_resource_id,

Line 392: OPEN c_jtf_rs_group_members(l_rowid);

388:
389:
390: -- dbms_output.put_line('Inserted Row');
391:
392: OPEN c_jtf_rs_group_members(l_rowid);
393:
394: FETCH c_jtf_rs_group_members INTO l_check_char;
395:
396:

Line 394: FETCH c_jtf_rs_group_members INTO l_check_char;

390: -- dbms_output.put_line('Inserted Row');
391:
392: OPEN c_jtf_rs_group_members(l_rowid);
393:
394: FETCH c_jtf_rs_group_members INTO l_check_char;
395:
396:
397: IF c_jtf_rs_group_members%NOTFOUND THEN
398:

Line 397: IF c_jtf_rs_group_members%NOTFOUND THEN

393:
394: FETCH c_jtf_rs_group_members INTO l_check_char;
395:
396:
397: IF c_jtf_rs_group_members%NOTFOUND THEN
398:
399: -- dbms_output.put_line('Error in Table Handler');
400:
401:

Line 405: IF c_jtf_rs_group_members%ISOPEN THEN

401:
402: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
403: fnd_msg_pub.add;
404:
405: IF c_jtf_rs_group_members%ISOPEN THEN
406:
407: CLOSE c_jtf_rs_group_members;
408:
409: END IF;

Line 407: CLOSE c_jtf_rs_group_members;

403: fnd_msg_pub.add;
404:
405: IF c_jtf_rs_group_members%ISOPEN THEN
406:
407: CLOSE c_jtf_rs_group_members;
408:
409: END IF;
410:
411: RAISE fnd_api.g_exc_error;

Line 460: IF c_jtf_rs_group_members%ISOPEN THEN

456:
457: END IF;
458: END IF;
459:
460: IF c_jtf_rs_group_members%ISOPEN THEN
461:
462: CLOSE c_jtf_rs_group_members;
463:
464: END IF;

Line 462: CLOSE c_jtf_rs_group_members;

458: END IF;
459:
460: IF c_jtf_rs_group_members%ISOPEN THEN
461:
462: CLOSE c_jtf_rs_group_members;
463:
464: END IF;
465: x_group_member_id := l_group_member_id;
466:

Line 479: IF c_jtf_rs_group_members%ISOPEN THEN

475:
476: END IF;
477:
478:
479: IF c_jtf_rs_group_members%ISOPEN THEN
480:
481: CLOSE c_jtf_rs_group_members;
482:
483: END IF;

Line 481: CLOSE c_jtf_rs_group_members;

477:
478:
479: IF c_jtf_rs_group_members%ISOPEN THEN
480:
481: CLOSE c_jtf_rs_group_members;
482:
483: END IF;
484:
485:

Line 491: 'JTF_RS_GROUP_MEMBERS_PVT',

487:
488: /* Post Call to the Customer Type User Hook */
489:
490: IF jtf_resource_utl.ok_to_execute(
491: 'JTF_RS_GROUP_MEMBERS_PVT',
492: 'CREATE_RESOURCE_GROUP_MEMBERS',
493: 'A',
494: 'C')
495: THEN

Line 497: 'JTF_RS_GROUP_MEMBERS_PVT',

493: 'A',
494: 'C')
495: THEN
496: IF jtf_usr_hks.ok_to_execute(
497: 'JTF_RS_GROUP_MEMBERS_PVT',
498: 'CREATE_RESOURCE_GROUP_MEMBERS',
499: 'A',
500: 'C')
501: THEN

Line 532: 'JTF_RS_GROUP_MEMBERS_PVT',

528:
529: /* Post Call to the Vertical Type User Hook */
530:
531: IF jtf_resource_utl.ok_to_execute(
532: 'JTF_RS_GROUP_MEMBERS_PVT',
533: 'CREATE_RESOURCE_GROUP_MEMBERS',
534: 'A',
535: 'V')
536: THEN

Line 538: 'JTF_RS_GROUP_MEMBERS_PVT',

534: 'A',
535: 'V')
536: THEN
537: IF jtf_usr_hks.ok_to_execute(
538: 'JTF_RS_GROUP_MEMBERS_PVT',
539: 'CREATE_RESOURCE_GROUP_MEMBERS',
540: 'A',
541: 'V')
542: THEN

Line 574: 'JTF_RS_GROUP_MEMBERS_PVT',

570:
571: /* Post Call to the Internal Type User Hook */
572:
573: IF jtf_resource_utl.ok_to_execute(
574: 'JTF_RS_GROUP_MEMBERS_PVT',
575: 'CREATE_RESOURCE_GROUP_MEMBERS',
576: 'A',
577: 'I')
578: THEN

Line 580: 'JTF_RS_GROUP_MEMBERS_PVT',

576: 'A',
577: 'I')
578: THEN
579: IF jtf_usr_hks.ok_to_execute(
580: 'JTF_RS_GROUP_MEMBERS_PVT',
581: 'CREATE_RESOURCE_GROUP_MEMBERS',
582: 'A',
583: 'I')
584: THEN

Line 614: 'JTF_RS_GROUP_MEMBERS_PVT',

610:
611: /* Standard call for Message Generation */
612:
613: IF jtf_resource_utl.ok_to_execute(
614: 'JTF_RS_GROUP_MEMBERS_PVT',
615: 'CREATE_RESOURCE_GROUP_MEMBERS',
616: 'M',
617: 'M')
618: THEN

Line 620: 'JTF_RS_GROUP_MEMBERS_PVT',

616: 'M',
617: 'M')
618: THEN
619: IF jtf_usr_hks.ok_to_execute(
620: 'JTF_RS_GROUP_MEMBERS_PVT',
621: 'CREATE_RESOURCE_GROUP_MEMBERS',
622: 'M',
623: 'M')
624: THEN

Line 732: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,

728: PROCEDURE update_resource_group_members
729: (P_API_VERSION IN NUMBER,
730: P_INIT_MSG_LIST IN VARCHAR2,
731: P_COMMIT IN VARCHAR2,
732: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
733: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
734: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,

Line 733: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

729: (P_API_VERSION IN NUMBER,
730: P_INIT_MSG_LIST IN VARCHAR2,
731: P_COMMIT IN VARCHAR2,
732: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
733: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
734: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,
737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,

Line 734: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

730: P_INIT_MSG_LIST IN VARCHAR2,
731: P_COMMIT IN VARCHAR2,
732: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
733: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
734: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,
737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,

Line 735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

731: P_COMMIT IN VARCHAR2,
732: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
733: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
734: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,
737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,

Line 736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,

732: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
733: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
734: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,
737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,

Line 737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,

733: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
734: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,
737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,

Line 738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,

734: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,
737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,

Line 739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,

735: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,
737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,

Line 740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,

736: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE,
737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,

Line 741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,

737: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,

Line 742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,

738: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,

Line 743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,

739: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,

Line 744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,

740: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,
741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,

Line 745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,

741: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE,
742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,

Line 746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,

742: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE,
743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,

Line 747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,

743: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE,
744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
751: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,

Line 748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,

744: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE,
745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
751: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
752: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,

Line 749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,

745: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE,
746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
751: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
752: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
753: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

Line 750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,

746: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE,
747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
751: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
752: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
753: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
754: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 751: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,

747: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE,
748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
751: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
752: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
753: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
754: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
755: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 752: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,

748: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE,
749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
751: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
752: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
753: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
754: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
755: X_MSG_COUNT OUT NOCOPY NUMBER,
756: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 753: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

749: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE,
750: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE,
751: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE,
752: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
753: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
754: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
755: X_MSG_COUNT OUT NOCOPY NUMBER,
756: X_MSG_DATA OUT NOCOPY VARCHAR2
757: )

Line 761: l_group_member_id jtf_rs_group_members.group_member_id%type := p_group_member_id;

757: )
758: IS
759: l_api_version CONSTANT NUMBER := 1.0;
760: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP_MEMBERS';
761: l_group_member_id jtf_rs_group_members.group_member_id%type := p_group_member_id;
762: l_object_version_number jtf_rs_group_members.object_version_number%type :=p_object_version_number;
763: l_attribute1 jtf_rs_group_members.attribute1%type := p_attribute1;
764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;
765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;

Line 762: l_object_version_number jtf_rs_group_members.object_version_number%type :=p_object_version_number;

758: IS
759: l_api_version CONSTANT NUMBER := 1.0;
760: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP_MEMBERS';
761: l_group_member_id jtf_rs_group_members.group_member_id%type := p_group_member_id;
762: l_object_version_number jtf_rs_group_members.object_version_number%type :=p_object_version_number;
763: l_attribute1 jtf_rs_group_members.attribute1%type := p_attribute1;
764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;
765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;
766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;

Line 763: l_attribute1 jtf_rs_group_members.attribute1%type := p_attribute1;

759: l_api_version CONSTANT NUMBER := 1.0;
760: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP_MEMBERS';
761: l_group_member_id jtf_rs_group_members.group_member_id%type := p_group_member_id;
762: l_object_version_number jtf_rs_group_members.object_version_number%type :=p_object_version_number;
763: l_attribute1 jtf_rs_group_members.attribute1%type := p_attribute1;
764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;
765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;
766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;
767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;

Line 764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;

760: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP_MEMBERS';
761: l_group_member_id jtf_rs_group_members.group_member_id%type := p_group_member_id;
762: l_object_version_number jtf_rs_group_members.object_version_number%type :=p_object_version_number;
763: l_attribute1 jtf_rs_group_members.attribute1%type := p_attribute1;
764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;
765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;
766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;
767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;
768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;

Line 765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;

761: l_group_member_id jtf_rs_group_members.group_member_id%type := p_group_member_id;
762: l_object_version_number jtf_rs_group_members.object_version_number%type :=p_object_version_number;
763: l_attribute1 jtf_rs_group_members.attribute1%type := p_attribute1;
764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;
765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;
766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;
767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;
768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;
769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;

Line 766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;

762: l_object_version_number jtf_rs_group_members.object_version_number%type :=p_object_version_number;
763: l_attribute1 jtf_rs_group_members.attribute1%type := p_attribute1;
764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;
765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;
766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;
767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;
768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;
769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;
770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;

Line 767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;

763: l_attribute1 jtf_rs_group_members.attribute1%type := p_attribute1;
764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;
765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;
766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;
767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;
768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;
769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;
770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;
771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;

Line 768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;

764: l_attribute2 jtf_rs_group_members.attribute2%type := p_attribute2;
765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;
766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;
767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;
768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;
769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;
770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;
771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;
772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;

Line 769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;

765: l_attribute3 jtf_rs_group_members.attribute3%type := p_attribute3;
766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;
767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;
768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;
769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;
770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;
771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;
772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;
773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;

Line 770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;

766: l_attribute4 jtf_rs_group_members.attribute4%type := p_attribute4;
767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;
768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;
769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;
770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;
771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;
772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;
773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;
774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;

Line 771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;

767: l_attribute5 jtf_rs_group_members.attribute5%type := p_attribute5;
768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;
769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;
770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;
771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;
772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;
773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;
774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;
775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;

Line 772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;

768: l_attribute6 jtf_rs_group_members.attribute6%type := p_attribute6;
769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;
770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;
771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;
772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;
773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;
774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;
775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;
776: l_attribute14 jtf_rs_group_members.attribute14%type := p_attribute14;

Line 773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;

769: l_attribute7 jtf_rs_group_members.attribute7%type := p_attribute7;
770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;
771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;
772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;
773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;
774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;
775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;
776: l_attribute14 jtf_rs_group_members.attribute14%type := p_attribute14;
777: l_attribute15 jtf_rs_group_members.attribute15%type := p_attribute15;

Line 774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;

770: l_attribute8 jtf_rs_group_members.attribute8%type := p_attribute8;
771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;
772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;
773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;
774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;
775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;
776: l_attribute14 jtf_rs_group_members.attribute14%type := p_attribute14;
777: l_attribute15 jtf_rs_group_members.attribute15%type := p_attribute15;
778: l_attribute_category jtf_rs_group_members.attribute_category%type := p_attribute_category;

Line 775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;

771: l_attribute9 jtf_rs_group_members.attribute9%type := p_attribute9;
772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;
773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;
774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;
775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;
776: l_attribute14 jtf_rs_group_members.attribute14%type := p_attribute14;
777: l_attribute15 jtf_rs_group_members.attribute15%type := p_attribute15;
778: l_attribute_category jtf_rs_group_members.attribute_category%type := p_attribute_category;
779:

Line 776: l_attribute14 jtf_rs_group_members.attribute14%type := p_attribute14;

772: l_attribute10 jtf_rs_group_members.attribute10%type := p_attribute10;
773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;
774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;
775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;
776: l_attribute14 jtf_rs_group_members.attribute14%type := p_attribute14;
777: l_attribute15 jtf_rs_group_members.attribute15%type := p_attribute15;
778: l_attribute_category jtf_rs_group_members.attribute_category%type := p_attribute_category;
779:
780:

Line 777: l_attribute15 jtf_rs_group_members.attribute15%type := p_attribute15;

773: l_attribute11 jtf_rs_group_members.attribute11%type := p_attribute11;
774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;
775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;
776: l_attribute14 jtf_rs_group_members.attribute14%type := p_attribute14;
777: l_attribute15 jtf_rs_group_members.attribute15%type := p_attribute15;
778: l_attribute_category jtf_rs_group_members.attribute_category%type := p_attribute_category;
779:
780:
781: l_bind_data_id NUMBER;

Line 778: l_attribute_category jtf_rs_group_members.attribute_category%type := p_attribute_category;

774: l_attribute12 jtf_rs_group_members.attribute12%type := p_attribute12;
775: l_attribute13 jtf_rs_group_members.attribute13%type := p_attribute13;
776: l_attribute14 jtf_rs_group_members.attribute14%type := p_attribute14;
777: l_attribute15 jtf_rs_group_members.attribute15%type := p_attribute15;
778: l_attribute_category jtf_rs_group_members.attribute_category%type := p_attribute_category;
779:
780:
781: l_bind_data_id NUMBER;
782:

Line 805: FROM jtf_rs_group_members

801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
803: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
804: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category
805: FROM jtf_rs_group_members
806: WHERE group_member_id = l_group_member_id;
807:
808: rs_group_member_rec c_rs_group_members_update%ROWTYPE;
809: BEGIN

Line 824: 'JTF_RS_GROUP_MEMBERS_PVT',

820:
821: /* Pre Call to the Customer Type User Hook */
822:
823: IF jtf_resource_utl.ok_to_execute(
824: 'JTF_RS_GROUP_MEMBERS_PVT',
825: 'UPDATE_RESOURCE_GROUP_MEMBERS',
826: 'B',
827: 'C')
828: THEN

Line 830: 'JTF_RS_GROUP_MEMBERS_PVT',

826: 'B',
827: 'C')
828: THEN
829: IF jtf_usr_hks.ok_to_execute(
830: 'JTF_RS_GROUP_MEMBERS_PVT',
831: 'UPDATE_RESOURCE_GROUP_MEMBERS',
832: 'B',
833: 'C')
834: THEN

Line 860: 'JTF_RS_GROUP_MEMBERS_PVT',

856:
857: /* Pre Call to the Vertical Type User Hook */
858:
859: IF jtf_resource_utl.ok_to_execute(
860: 'JTF_RS_GROUP_MEMBERS_PVT',
861: 'UPDATE_RESOURCE_GROUP_MEMBERS',
862: 'B',
863: 'V')
864: THEN

Line 866: 'JTF_RS_GROUP_MEMBERS_PVT',

862: 'B',
863: 'V')
864: THEN
865: IF jtf_usr_hks.ok_to_execute(
866: 'JTF_RS_GROUP_MEMBERS_PVT',
867: 'UPDATE_RESOURCE_GROUP_MEMBERS',
868: 'B',
869: 'V')
870: THEN

Line 896: 'JTF_RS_GROUP_MEMBERS_PVT',

892:
893: /* Pre Call to the Internal Type User Hook */
894:
895: IF jtf_resource_utl.ok_to_execute(
896: 'JTF_RS_GROUP_MEMBERS_PVT',
897: 'UPDATE_RESOURCE_GROUP_MEMBERS',
898: 'B',
899: 'I')
900: THEN

Line 902: 'JTF_RS_GROUP_MEMBERS_PVT',

898: 'B',
899: 'I')
900: THEN
901: IF jtf_usr_hks.ok_to_execute(
902: 'JTF_RS_GROUP_MEMBERS_PVT',
903: 'UPDATE_RESOURCE_GROUP_MEMBERS',
904: 'B',
905: 'I')
906: THEN

Line 940: jtf_rs_group_members_pkg.lock_row (

936: END IF;
937:
938:
939: --Call the Lock Row Table Handler before updating the record
940: jtf_rs_group_members_pkg.lock_row (
941: X_GROUP_MEMBER_ID => l_group_member_id,
942: X_OBJECT_VERSION_NUMBER => l_object_version_number
943: );
944:

Line 947: jtf_rs_group_members_aud_pvt.update_member

943: );
944:
945: /* Make a call to the group member Audit API */
946:
947: jtf_rs_group_members_aud_pvt.update_member
948: (
949: P_API_VERSION => 1,
950: P_INIT_MSG_LIST => fnd_api.g_false,
951: P_COMMIT => fnd_api.g_false,

Line 976: jtf_rs_group_members_pkg.update_row (

972: l_object_version_number := l_object_version_number+1;
973:
974: --Call the Table Handler to Update the Values in jtf_rs_role tables
975: BEGIN
976: jtf_rs_group_members_pkg.update_row (
977: X_GROUP_MEMBER_ID => l_group_member_id,
978: X_ATTRIBUTE1 => rs_group_member_rec.l_attribute1,
979: X_ATTRIBUTE2 => rs_group_member_rec.l_attribute2,
980: X_ATTRIBUTE3 => rs_group_member_rec.l_attribute3,

Line 1020: 'JTF_RS_GROUP_MEMBERS_PVT',

1016:
1017: /* Post Call to the Customer Type User Hook */
1018:
1019: IF jtf_resource_utl.ok_to_execute(
1020: 'JTF_RS_GROUP_MEMBERS_PVT',
1021: 'UPDATE_RESOURCE_GROUP_MEMBERS',
1022: 'A',
1023: 'C')
1024: THEN

Line 1026: 'JTF_RS_GROUP_MEMBERS_PVT',

1022: 'A',
1023: 'C')
1024: THEN
1025: IF jtf_usr_hks.ok_to_execute(
1026: 'JTF_RS_GROUP_MEMBERS_PVT',
1027: 'UPDATE_RESOURCE_GROUP_MEMBERS',
1028: 'A',
1029: 'C')
1030: THEN

Line 1056: 'JTF_RS_GROUP_MEMBERS_PVT',

1052:
1053: /* Post Call to the Vertical Type User Hook */
1054:
1055: IF jtf_resource_utl.ok_to_execute(
1056: 'JTF_RS_GROUP_MEMBERS_PVT',
1057: 'UPDATE_RESOURCE_GROUP_MEMBERS',
1058: 'A',
1059: 'V')
1060: THEN

Line 1062: 'JTF_RS_GROUP_MEMBERS_PVT',

1058: 'A',
1059: 'V')
1060: THEN
1061: IF jtf_usr_hks.ok_to_execute(
1062: 'JTF_RS_GROUP_MEMBERS_PVT',
1063: 'UPDATE_RESOURCE_GROUP_MEMBERS',
1064: 'A',
1065: 'V')
1066: THEN

Line 1092: 'JTF_RS_GROUP_MEMBERS_PVT',

1088:
1089: /* Post Call to the Internal Type User Hook */
1090:
1091: IF jtf_resource_utl.ok_to_execute(
1092: 'JTF_RS_GROUP_MEMBERS_PVT',
1093: 'UPDATE_RESOURCE_GROUP_MEMBERS',
1094: 'A',
1095: 'I')
1096: THEN

Line 1098: 'JTF_RS_GROUP_MEMBERS_PVT',

1094: 'A',
1095: 'I')
1096: THEN
1097: IF jtf_usr_hks.ok_to_execute(
1098: 'JTF_RS_GROUP_MEMBERS_PVT',
1099: 'UPDATE_RESOURCE_GROUP_MEMBERS',
1100: 'A',
1101: 'I')
1102: THEN

Line 1126: 'JTF_RS_GROUP_MEMBERS_PVT',

1122:
1123: /* Standard call for Message Generation */
1124:
1125: IF jtf_resource_utl.ok_to_execute(
1126: 'JTF_RS_GROUP_MEMBERS_PVT',
1127: 'UPDATE_RESOURCE_GROUP_MEMBERS',
1128: 'M',
1129: 'M')
1130: THEN

Line 1132: 'JTF_RS_GROUP_MEMBERS_PVT',

1128: 'M',
1129: 'M')
1130: THEN
1131: IF jtf_usr_hks.ok_to_execute(
1132: 'JTF_RS_GROUP_MEMBERS_PVT',
1133: 'UPDATE_RESOURCE_GROUP_MEMBERS',
1134: 'M',
1135: 'M')
1136: THEN

Line 1219: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

1215: PROCEDURE delete_resource_group_members
1216: (P_API_VERSION IN NUMBER,
1217: P_INIT_MSG_LIST IN VARCHAR2,
1218: P_COMMIT IN VARCHAR2,
1219: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1220: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
1221: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
1222: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1223: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1220: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

1216: (P_API_VERSION IN NUMBER,
1217: P_INIT_MSG_LIST IN VARCHAR2,
1218: P_COMMIT IN VARCHAR2,
1219: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1220: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
1221: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
1222: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1223: X_MSG_COUNT OUT NOCOPY NUMBER,
1224: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1221: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

1217: P_INIT_MSG_LIST IN VARCHAR2,
1218: P_COMMIT IN VARCHAR2,
1219: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1220: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
1221: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
1222: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1223: X_MSG_COUNT OUT NOCOPY NUMBER,
1224: X_MSG_DATA OUT NOCOPY VARCHAR2
1225: )

Line 1231: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;

1227: IS
1228:
1229: l_api_version CONSTANT NUMBER := 1.0;
1230: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_MEMBERS';
1231: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
1232: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
1233: l_check_char VARCHAR2(1);
1234: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
1235: l_role_relate_count NUMBER;

Line 1232: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;

1228:
1229: l_api_version CONSTANT NUMBER := 1.0;
1230: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_MEMBERS';
1231: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
1232: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
1233: l_check_char VARCHAR2(1);
1234: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
1235: l_role_relate_count NUMBER;
1236: l_bind_data_id NUMBER;

Line 1234: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;

1230: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_MEMBERS';
1231: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
1232: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
1233: l_check_char VARCHAR2(1);
1234: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
1235: l_role_relate_count NUMBER;
1236: l_bind_data_id NUMBER;
1237:
1238: l_return_status VARCHAR2(1);

Line 1248: FROM jtf_rs_group_members

1244: l_group_id IN NUMBER,
1245: l_resource_id IN NUMBER )
1246: IS
1247: SELECT group_member_id
1248: FROM jtf_rs_group_members
1249: WHERE group_id = l_group_id
1250: AND resource_id = l_resource_id
1251: AND nvl(delete_flag,'N') <> 'Y';
1252:

Line 1299: 'JTF_RS_GROUP_MEMBERS_PVT',

1295:
1296: /* Pre Call to the Customer Type User Hook */
1297:
1298: IF jtf_resource_utl.ok_to_execute(
1299: 'JTF_RS_GROUP_MEMBERS_PVT',
1300: 'DELETE_RESOURCE_GROUP_MEMBERS',
1301: 'B',
1302: 'C')
1303: THEN

Line 1305: 'JTF_RS_GROUP_MEMBERS_PVT',

1301: 'B',
1302: 'C')
1303: THEN
1304: IF jtf_usr_hks.ok_to_execute(
1305: 'JTF_RS_GROUP_MEMBERS_PVT',
1306: 'DELETE_RESOURCE_GROUP_MEMBERS',
1307: 'B',
1308: 'C')
1309: THEN

Line 1340: 'JTF_RS_GROUP_MEMBERS_PVT',

1336:
1337: /* Pre Call to the Vertical Type User Hook */
1338:
1339: IF jtf_resource_utl.ok_to_execute(
1340: 'JTF_RS_GROUP_MEMBERS_PVT',
1341: 'DELETE_RESOURCE_GROUP_MEMBERS',
1342: 'B',
1343: 'V')
1344: THEN

Line 1346: 'JTF_RS_GROUP_MEMBERS_PVT',

1342: 'B',
1343: 'V')
1344: THEN
1345: IF jtf_usr_hks.ok_to_execute(
1346: 'JTF_RS_GROUP_MEMBERS_PVT',
1347: 'DELETE_RESOURCE_GROUP_MEMBERS',
1348: 'B',
1349: 'V')
1350: THEN

Line 1380: 'JTF_RS_GROUP_MEMBERS_PVT',

1376:
1377: /* Pre Call to the Internal Type User Hook */
1378:
1379: IF jtf_resource_utl.ok_to_execute(
1380: 'JTF_RS_GROUP_MEMBERS_PVT',
1381: 'DELETE_RESOURCE_GROUP_MEMBERS',
1382: 'B',
1383: 'I')
1384: THEN

Line 1386: 'JTF_RS_GROUP_MEMBERS_PVT',

1382: 'B',
1383: 'I')
1384: THEN
1385: IF jtf_usr_hks.ok_to_execute(
1386: 'JTF_RS_GROUP_MEMBERS_PVT',
1387: 'DELETE_RESOURCE_GROUP_MEMBERS',
1388: 'B',
1389: 'I')
1390: THEN

Line 1505: jtf_rs_group_members_pkg.lock_row(

1501: is still valid. */
1502:
1503: BEGIN
1504:
1505: jtf_rs_group_members_pkg.lock_row(
1506: x_group_member_id => l_group_member_id,
1507: x_object_version_number => p_object_version_num
1508: );
1509:

Line 1528: jtf_rs_group_members_aud_pvt.delete_member

1524:
1525:
1526: /* Make a call to the group member Audit API */
1527:
1528: jtf_rs_group_members_aud_pvt.delete_member
1529: (P_API_VERSION => 1,
1530: P_INIT_MSG_LIST => fnd_api.g_false,
1531: P_COMMIT => fnd_api.g_false,
1532: P_GROUP_MEMBER_ID => l_group_member_id,

Line 1575: jtf_rs_group_members_pkg.logical_delete_row(

1571: END;
1572:
1573: /* Delete the row into the table by calling the table handler. */
1574:
1575: jtf_rs_group_members_pkg.logical_delete_row(
1576: x_group_member_id => l_group_member_id
1577: );
1578:
1579: -- Delete record in active group members table

Line 1608: 'JTF_RS_GROUP_MEMBERS_PVT',

1604:
1605: /* Post Call to the Customer Type User Hook */
1606:
1607: IF jtf_resource_utl.ok_to_execute(
1608: 'JTF_RS_GROUP_MEMBERS_PVT',
1609: 'DELETE_RESOURCE_GROUP_MEMBERS',
1610: 'A',
1611: 'C')
1612: THEN

Line 1614: 'JTF_RS_GROUP_MEMBERS_PVT',

1610: 'A',
1611: 'C')
1612: THEN
1613: IF jtf_usr_hks.ok_to_execute(
1614: 'JTF_RS_GROUP_MEMBERS_PVT',
1615: 'DELETE_RESOURCE_GROUP_MEMBERS',
1616: 'A',
1617: 'C')
1618: THEN

Line 1649: 'JTF_RS_GROUP_MEMBERS_PVT',

1645:
1646: /* Post Call to the Vertical Type User Hook */
1647:
1648: IF jtf_resource_utl.ok_to_execute(
1649: 'JTF_RS_GROUP_MEMBERS_PVT',
1650: 'DELETE_RESOURCE_GROUP_MEMBERS',
1651: 'A',
1652: 'V')
1653: THEN

Line 1655: 'JTF_RS_GROUP_MEMBERS_PVT',

1651: 'A',
1652: 'V')
1653: THEN
1654: IF jtf_usr_hks.ok_to_execute(
1655: 'JTF_RS_GROUP_MEMBERS_PVT',
1656: 'DELETE_RESOURCE_GROUP_MEMBERS',
1657: 'A',
1658: 'V')
1659: THEN

Line 1689: 'JTF_RS_GROUP_MEMBERS_PVT',

1685:
1686: /* Post Call to the Internal Type User Hook */
1687:
1688: IF jtf_resource_utl.ok_to_execute(
1689: 'JTF_RS_GROUP_MEMBERS_PVT',
1690: 'DELETE_RESOURCE_GROUP_MEMBERS',
1691: 'A',
1692: 'I')
1693: THEN

Line 1695: 'JTF_RS_GROUP_MEMBERS_PVT',

1691: 'A',
1692: 'I')
1693: THEN
1694: IF jtf_usr_hks.ok_to_execute(
1695: 'JTF_RS_GROUP_MEMBERS_PVT',
1696: 'DELETE_RESOURCE_GROUP_MEMBERS',
1697: 'A',
1698: 'I')
1699: THEN

Line 1727: 'JTF_RS_GROUP_MEMBERS_PVT',

1723:
1724: /* Standard call for Message Generation */
1725:
1726: IF jtf_resource_utl.ok_to_execute(
1727: 'JTF_RS_GROUP_MEMBERS_PVT',
1728: 'DELETE_RESOURCE_GROUP_MEMBERS',
1729: 'M',
1730: 'M')
1731: THEN

Line 1733: 'JTF_RS_GROUP_MEMBERS_PVT',

1729: 'M',
1730: 'M')
1731: THEN
1732: IF jtf_usr_hks.ok_to_execute(
1733: 'JTF_RS_GROUP_MEMBERS_PVT',
1734: 'DELETE_RESOURCE_GROUP_MEMBERS',
1735: 'M',
1736: 'M')
1737: THEN

Line 1827: P_OLD_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

1823: PROCEDURE execute_sales_hook
1824: (P_API_VERSION IN NUMBER,
1825: P_INIT_MSG_LIST IN VARCHAR2,
1826: P_COMMIT IN VARCHAR2,
1827: P_OLD_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1828: P_NEW_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1829: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1830: P_OLD_START_DATE IN DATE,
1831: P_OLD_END_DATE IN DATE,

Line 1828: P_NEW_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

1824: (P_API_VERSION IN NUMBER,
1825: P_INIT_MSG_LIST IN VARCHAR2,
1826: P_COMMIT IN VARCHAR2,
1827: P_OLD_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1828: P_NEW_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1829: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1830: P_OLD_START_DATE IN DATE,
1831: P_OLD_END_DATE IN DATE,
1832: P_NEW_START_DATE IN DATE,

Line 1846: END jtf_rs_group_members_pvt;

1842:
1843: END execute_sales_hook;
1844:
1845:
1846: END jtf_rs_group_members_pvt;