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_TEAM_MEMBERS_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 1: PACKAGE BODY jtf_rs_team_members_pvt AS

1: PACKAGE BODY jtf_rs_team_members_pvt AS
2: /* $Header: jtfrsveb.pls 120.0 2005/05/11 08:22:56 appldev ship $ */
3:
4: /*****************************************************************************************
5: This private package body defines the procedures for managing resource team members,

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_TEAM_MEMBERS_PVT';

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

Line 26: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,

22: PROCEDURE create_resource_team_members
23: (P_API_VERSION IN NUMBER,
24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
27: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
28: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
29: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,

Line 27: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

23: (P_API_VERSION IN NUMBER,
24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
27: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
28: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
29: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,

Line 28: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
27: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
28: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
29: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
32: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,

Line 29: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,

25: P_COMMIT IN VARCHAR2,
26: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
27: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
28: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
29: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
32: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
33: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,

Line 30: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,

26: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
27: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
28: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
29: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
32: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
33: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
34: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,

Line 31: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,

27: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
28: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
29: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
32: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
33: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
34: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
35: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,

Line 32: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,

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

Line 33: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,

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

Line 34: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,

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

Line 35: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,

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

Line 36: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,

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

Line 37: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,

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

Line 38: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,

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

Line 39: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,

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

Line 40: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,

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

Line 41: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,

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

Line 42: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,

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

Line 43: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,

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

Line 44: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,

40: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
41: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
42: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,
43: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE

Line 48: X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE

44: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE
49: ) IS
50:
51: l_api_version CONSTANT NUMBER := 1.0;
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM_MEMBERS';

Line 54: l_team_id jtf_rs_team_members.team_id%TYPE;

50:
51: l_api_version CONSTANT NUMBER := 1.0;
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM_MEMBERS';
53: l_rowid ROWID;
54: l_team_id jtf_rs_team_members.team_id%TYPE;
55: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
56: l_resource_type jtf_rs_team_members.resource_type%TYPE;
57: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
58: l_person_id jtf_rs_team_members.person_id%TYPE;

Line 55: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;

51: l_api_version CONSTANT NUMBER := 1.0;
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM_MEMBERS';
53: l_rowid ROWID;
54: l_team_id jtf_rs_team_members.team_id%TYPE;
55: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
56: l_resource_type jtf_rs_team_members.resource_type%TYPE;
57: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
58: l_person_id jtf_rs_team_members.person_id%TYPE;
59:

Line 56: l_resource_type jtf_rs_team_members.resource_type%TYPE;

52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM_MEMBERS';
53: l_rowid ROWID;
54: l_team_id jtf_rs_team_members.team_id%TYPE;
55: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
56: l_resource_type jtf_rs_team_members.resource_type%TYPE;
57: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
58: l_person_id jtf_rs_team_members.person_id%TYPE;
59:
60: l_check_char VARCHAR2(1);

Line 57: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;

53: l_rowid ROWID;
54: l_team_id jtf_rs_team_members.team_id%TYPE;
55: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
56: l_resource_type jtf_rs_team_members.resource_type%TYPE;
57: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
58: l_person_id jtf_rs_team_members.person_id%TYPE;
59:
60: l_check_char VARCHAR2(1);
61: l_check_count NUMBER;

Line 58: l_person_id jtf_rs_team_members.person_id%TYPE;

54: l_team_id jtf_rs_team_members.team_id%TYPE;
55: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
56: l_resource_type jtf_rs_team_members.resource_type%TYPE;
57: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
58: l_person_id jtf_rs_team_members.person_id%TYPE;
59:
60: l_check_char VARCHAR2(1);
61: l_check_count NUMBER;
62: l_bind_data_id NUMBER;

Line 70: CURSOR c_jtf_rs_team_members( l_rowid IN ROWID ) IS

66: l_msg_data VARCHAR2(2000);
67: l_msg_count NUMBER;
68:
69:
70: CURSOR c_jtf_rs_team_members( l_rowid IN ROWID ) IS
71: SELECT 'Y'
72: FROM jtf_rs_team_members
73: WHERE ROWID = l_rowid;
74:

Line 72: FROM jtf_rs_team_members

68:
69:
70: CURSOR c_jtf_rs_team_members( l_rowid IN ROWID ) IS
71: SELECT 'Y'
72: FROM jtf_rs_team_members
73: WHERE ROWID = l_rowid;
74:
75:
76: CURSOR c_employee_person_id( l_team_resource_id IN NUMBER ) IS

Line 116: 'JTF_RS_TEAM_MEMBERS_PVT',

112:
113: /* Pre Call to the Customer Type User Hook */
114:
115: IF jtf_resource_utl.ok_to_execute(
116: 'JTF_RS_TEAM_MEMBERS_PVT',
117: 'CREATE_RESOURCE_TEAM_MEMBERS',
118: 'B',
119: 'C')
120: THEN

Line 122: 'JTF_RS_TEAM_MEMBERS_PVT',

118: 'B',
119: 'C')
120: THEN
121: IF jtf_usr_hks.ok_to_execute(
122: 'JTF_RS_TEAM_MEMBERS_PVT',
123: 'CREATE_RESOURCE_TEAM_MEMBERS',
124: 'B',
125: 'C')
126: THEN

Line 154: 'JTF_RS_TEAM_MEMBERS_PVT',

150:
151: /* Pre Call to the Vertical Type User Hook */
152:
153: IF jtf_resource_utl.ok_to_execute(
154: 'JTF_RS_TEAM_MEMBERS_PVT',
155: 'CREATE_RESOURCE_TEAM_MEMBERS',
156: 'B',
157: 'V')
158: THEN

Line 160: 'JTF_RS_TEAM_MEMBERS_PVT',

156: 'B',
157: 'V')
158: THEN
159: IF jtf_usr_hks.ok_to_execute(
160: 'JTF_RS_TEAM_MEMBERS_PVT',
161: 'CREATE_RESOURCE_TEAM_MEMBERS',
162: 'B',
163: 'V')
164: THEN

Line 192: 'JTF_RS_TEAM_MEMBERS_PVT',

188:
189: /* Pre Call to the Internal Type User Hook */
190:
191: IF jtf_resource_utl.ok_to_execute(
192: 'JTF_RS_TEAM_MEMBERS_PVT',
193: 'CREATE_RESOURCE_TEAM_MEMBERS',
194: 'B',
195: 'I')
196: THEN

Line 198: 'JTF_RS_TEAM_MEMBERS_PVT',

194: 'B',
195: 'I')
196: THEN
197: IF jtf_usr_hks.ok_to_execute(
198: 'JTF_RS_TEAM_MEMBERS_PVT',
199: 'CREATE_RESOURCE_TEAM_MEMBERS',
200: 'B',
201: 'I')
202: THEN

Line 231: FROM jtf_rs_team_members

227: l_check_count := 0;
228:
229: SELECT count(*)
230: INTO l_check_count
231: FROM jtf_rs_team_members
232: WHERE team_id = l_team_id
233: AND team_resource_id = l_team_resource_id
234: AND resource_type = l_resource_type
235: AND nvl(delete_flag,'N') <> 'Y';

Line 273: SELECT jtf_rs_team_members_s.nextval

269:
270:
271: /* Get the next value of the Team_member_id from the sequence. */
272:
273: SELECT jtf_rs_team_members_s.nextval
274: INTO l_team_member_id
275: FROM dual;
276:
277:

Line 280: jtf_rs_team_members_pkg.insert_row(

276:
277:
278: /* Insert the row into the table by calling the table handler. */
279:
280: jtf_rs_team_members_pkg.insert_row(
281: x_rowid => l_rowid,
282: x_team_member_id => l_team_member_id,
283: x_team_id => l_team_id,
284: x_team_resource_id => l_team_resource_id,

Line 314: OPEN c_jtf_rs_team_members(l_rowid);

310:
311:
312: -- dbms_output.put_line('Inserted Row');
313:
314: OPEN c_jtf_rs_team_members(l_rowid);
315:
316: FETCH c_jtf_rs_team_members INTO l_check_char;
317:
318:

Line 316: FETCH c_jtf_rs_team_members INTO l_check_char;

312: -- dbms_output.put_line('Inserted Row');
313:
314: OPEN c_jtf_rs_team_members(l_rowid);
315:
316: FETCH c_jtf_rs_team_members INTO l_check_char;
317:
318:
319: IF c_jtf_rs_team_members%NOTFOUND THEN
320:

Line 319: IF c_jtf_rs_team_members%NOTFOUND THEN

315:
316: FETCH c_jtf_rs_team_members INTO l_check_char;
317:
318:
319: IF c_jtf_rs_team_members%NOTFOUND THEN
320:
321: -- dbms_output.put_line('Error in Table Handler');
322:
323: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 328: IF c_jtf_rs_team_members%ISOPEN THEN

324:
325: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
326: fnd_msg_pub.add;
327:
328: IF c_jtf_rs_team_members%ISOPEN THEN
329:
330: CLOSE c_jtf_rs_team_members;
331:
332: END IF;

Line 330: CLOSE c_jtf_rs_team_members;

326: fnd_msg_pub.add;
327:
328: IF c_jtf_rs_team_members%ISOPEN THEN
329:
330: CLOSE c_jtf_rs_team_members;
331:
332: END IF;
333:
334: RAISE fnd_api.g_exc_unexpected_error;

Line 353: IF c_jtf_rs_team_members%ISOPEN THEN

349: CLOSE c_employee_person_id;
350:
351: END IF;
352:
353: IF c_jtf_rs_team_members%ISOPEN THEN
354:
355: CLOSE c_jtf_rs_team_members;
356:
357: END IF;

Line 355: CLOSE c_jtf_rs_team_members;

351: END IF;
352:
353: IF c_jtf_rs_team_members%ISOPEN THEN
354:
355: CLOSE c_jtf_rs_team_members;
356:
357: END IF;
358:
359:

Line 365: 'JTF_RS_TEAM_MEMBERS_PVT',

361:
362: /* Post Call to the Customer Type User Hook */
363:
364: IF jtf_resource_utl.ok_to_execute(
365: 'JTF_RS_TEAM_MEMBERS_PVT',
366: 'CREATE_RESOURCE_TEAM_MEMBERS',
367: 'A',
368: 'C')
369: THEN

Line 371: 'JTF_RS_TEAM_MEMBERS_PVT',

367: 'A',
368: 'C')
369: THEN
370: IF jtf_usr_hks.ok_to_execute(
371: 'JTF_RS_TEAM_MEMBERS_PVT',
372: 'CREATE_RESOURCE_TEAM_MEMBERS',
373: 'A',
374: 'C')
375: THEN

Line 404: 'JTF_RS_TEAM_MEMBERS_PVT',

400:
401: /* Post Call to the Vertical Type User Hook */
402:
403: IF jtf_resource_utl.ok_to_execute(
404: 'JTF_RS_TEAM_MEMBERS_PVT',
405: 'CREATE_RESOURCE_TEAM_MEMBERS',
406: 'A',
407: 'V')
408: THEN

Line 410: 'JTF_RS_TEAM_MEMBERS_PVT',

406: 'A',
407: 'V')
408: THEN
409: IF jtf_usr_hks.ok_to_execute(
410: 'JTF_RS_TEAM_MEMBERS_PVT',
411: 'CREATE_RESOURCE_TEAM_MEMBERS',
412: 'A',
413: 'V')
414: THEN

Line 443: 'JTF_RS_TEAM_MEMBERS_PVT',

439:
440: /* Post Call to the Internal Type User Hook */
441:
442: IF jtf_resource_utl.ok_to_execute(
443: 'JTF_RS_TEAM_MEMBERS_PVT',
444: 'CREATE_RESOURCE_TEAM_MEMBERS',
445: 'A',
446: 'I')
447: THEN

Line 449: 'JTF_RS_TEAM_MEMBERS_PVT',

445: 'A',
446: 'I')
447: THEN
448: IF jtf_usr_hks.ok_to_execute(
449: 'JTF_RS_TEAM_MEMBERS_PVT',
450: 'CREATE_RESOURCE_TEAM_MEMBERS',
451: 'A',
452: 'I')
453: THEN

Line 480: 'JTF_RS_TEAM_MEMBERS_PVT',

476:
477: /* Standard call for Message Generation */
478:
479: IF jtf_resource_utl.ok_to_execute(
480: 'JTF_RS_TEAM_MEMBERS_PVT',
481: 'CREATE_RESOURCE_TEAM_MEMBERS',
482: 'M',
483: 'M')
484: THEN

Line 486: 'JTF_RS_TEAM_MEMBERS_PVT',

482: 'M',
483: 'M')
484: THEN
485: IF jtf_usr_hks.ok_to_execute(
486: 'JTF_RS_TEAM_MEMBERS_PVT',
487: 'CREATE_RESOURCE_TEAM_MEMBERS',
488: 'M',
489: 'M')
490: THEN

Line 610: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,

606: PROCEDURE update_resource_team_members
607: (P_API_VERSION IN NUMBER,
608: P_INIT_MSG_LIST IN VARCHAR2,
609: P_COMMIT IN VARCHAR2,
610: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
611: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
612: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,
614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

Line 611: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,

607: (P_API_VERSION IN NUMBER,
608: P_INIT_MSG_LIST IN VARCHAR2,
609: P_COMMIT IN VARCHAR2,
610: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
611: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
612: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,
614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,

Line 612: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

608: P_INIT_MSG_LIST IN VARCHAR2,
609: P_COMMIT IN VARCHAR2,
610: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
611: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
612: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,
614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,
616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,

Line 613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,

609: P_COMMIT IN VARCHAR2,
610: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
611: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
612: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,
614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,
616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,

Line 614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

610: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
611: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
612: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,
614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,
616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,

Line 615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,

611: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
612: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,
614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,
616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,

Line 616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,

612: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,
614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,
616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,

Line 617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,

613: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE,
614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,
616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,

Line 618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,

614: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,
616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,

Line 619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,

615: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE,
616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,
623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,

Line 620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,

616: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE,
617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,
623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,
624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,

Line 621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,

617: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE,
618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,
623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,
624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,
625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,

Line 622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,

618: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE,
619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,
623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,
624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,
625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,
626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,

Line 623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,

619: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE,
620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,
623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,
624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,
625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,
626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,
627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,

Line 624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,

620: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE,
621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,
623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,
624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,
625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,
626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,
627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,

Line 625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,

621: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE,
622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,
623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,
624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,
625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,
626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,
627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,

Line 626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,

622: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE,
623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,
624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,
625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,
626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,
627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,
630: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,

Line 627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,

623: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE,
624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,
625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,
626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,
627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,
630: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,
631: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,

Line 628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,

624: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE,
625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,
626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,
627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,
630: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,
631: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
632: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

Line 629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,

625: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE,
626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,
627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,
630: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,
631: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
632: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
633: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 630: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,

626: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE,
627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,
630: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,
631: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
632: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
633: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
634: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 631: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,

627: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE,
628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,
630: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,
631: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
632: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
633: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
634: X_MSG_COUNT OUT NOCOPY NUMBER,
635: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 632: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

628: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE,
629: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE,
630: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE,
631: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
632: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
633: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
634: X_MSG_COUNT OUT NOCOPY NUMBER,
635: X_MSG_DATA OUT NOCOPY VARCHAR2
636: ) IS

Line 640: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;

636: ) IS
637:
638: l_api_version CONSTANT NUMBER := 1.0;
639: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM_MEMBERS';
640: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
641: l_team_id jtf_rs_team_members.team_id%TYPE;
642: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
643: l_resource_type jtf_rs_team_members.resource_type%TYPE;
644: l_person_id jtf_rs_team_members.person_id%TYPE;

Line 641: l_team_id jtf_rs_team_members.team_id%TYPE;

637:
638: l_api_version CONSTANT NUMBER := 1.0;
639: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM_MEMBERS';
640: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
641: l_team_id jtf_rs_team_members.team_id%TYPE;
642: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
643: l_resource_type jtf_rs_team_members.resource_type%TYPE;
644: l_person_id jtf_rs_team_members.person_id%TYPE;
645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;

Line 642: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;

638: l_api_version CONSTANT NUMBER := 1.0;
639: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM_MEMBERS';
640: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
641: l_team_id jtf_rs_team_members.team_id%TYPE;
642: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
643: l_resource_type jtf_rs_team_members.resource_type%TYPE;
644: l_person_id jtf_rs_team_members.person_id%TYPE;
645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;
646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;

Line 643: l_resource_type jtf_rs_team_members.resource_type%TYPE;

639: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM_MEMBERS';
640: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
641: l_team_id jtf_rs_team_members.team_id%TYPE;
642: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
643: l_resource_type jtf_rs_team_members.resource_type%TYPE;
644: l_person_id jtf_rs_team_members.person_id%TYPE;
645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;
646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;
647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;

Line 644: l_person_id jtf_rs_team_members.person_id%TYPE;

640: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
641: l_team_id jtf_rs_team_members.team_id%TYPE;
642: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
643: l_resource_type jtf_rs_team_members.resource_type%TYPE;
644: l_person_id jtf_rs_team_members.person_id%TYPE;
645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;
646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;
647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;
648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;

Line 645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;

641: l_team_id jtf_rs_team_members.team_id%TYPE;
642: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
643: l_resource_type jtf_rs_team_members.resource_type%TYPE;
644: l_person_id jtf_rs_team_members.person_id%TYPE;
645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;
646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;
647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;
648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;
649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;

Line 646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;

642: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
643: l_resource_type jtf_rs_team_members.resource_type%TYPE;
644: l_person_id jtf_rs_team_members.person_id%TYPE;
645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;
646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;
647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;
648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;
649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;
650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;

Line 647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;

643: l_resource_type jtf_rs_team_members.resource_type%TYPE;
644: l_person_id jtf_rs_team_members.person_id%TYPE;
645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;
646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;
647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;
648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;
649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;
650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;
651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;

Line 648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;

644: l_person_id jtf_rs_team_members.person_id%TYPE;
645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;
646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;
647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;
648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;
649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;
650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;
651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;
652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;

Line 649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;

645: l_delete_flag jtf_rs_team_members.delete_flag%TYPE;
646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;
647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;
648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;
649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;
650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;
651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;
652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;
653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;

Line 650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;

646: l_object_version_number jtf_rs_team_members.object_version_number%TYPE;
647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;
648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;
649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;
650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;
651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;
652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;
653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;
654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;

Line 651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;

647: l_attribute1 jtf_rs_team_members.attribute1%TYPE;
648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;
649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;
650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;
651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;
652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;
653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;
654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;
655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;

Line 652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;

648: l_attribute2 jtf_rs_team_members.attribute2%TYPE;
649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;
650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;
651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;
652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;
653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;
654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;
655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;
656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;

Line 653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;

649: l_attribute3 jtf_rs_team_members.attribute3%TYPE;
650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;
651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;
652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;
653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;
654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;
655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;
656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;
657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;

Line 654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;

650: l_attribute4 jtf_rs_team_members.attribute4%TYPE;
651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;
652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;
653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;
654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;
655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;
656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;
657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;
658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;

Line 655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;

651: l_attribute5 jtf_rs_team_members.attribute5%TYPE;
652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;
653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;
654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;
655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;
656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;
657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;
658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;
659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;

Line 656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;

652: l_attribute6 jtf_rs_team_members.attribute6%TYPE;
653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;
654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;
655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;
656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;
657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;
658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;
659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;
660: l_attribute14 jtf_rs_team_members.attribute14%TYPE;

Line 657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;

653: l_attribute7 jtf_rs_team_members.attribute7%TYPE;
654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;
655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;
656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;
657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;
658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;
659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;
660: l_attribute14 jtf_rs_team_members.attribute14%TYPE;
661: l_attribute15 jtf_rs_team_members.attribute15%TYPE;

Line 658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;

654: l_attribute8 jtf_rs_team_members.attribute8%TYPE;
655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;
656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;
657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;
658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;
659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;
660: l_attribute14 jtf_rs_team_members.attribute14%TYPE;
661: l_attribute15 jtf_rs_team_members.attribute15%TYPE;
662: l_attribute_catgory jtf_rs_team_members.attribute_category%TYPE;

Line 659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;

655: l_attribute9 jtf_rs_team_members.attribute9%TYPE;
656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;
657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;
658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;
659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;
660: l_attribute14 jtf_rs_team_members.attribute14%TYPE;
661: l_attribute15 jtf_rs_team_members.attribute15%TYPE;
662: l_attribute_catgory jtf_rs_team_members.attribute_category%TYPE;
663:

Line 660: l_attribute14 jtf_rs_team_members.attribute14%TYPE;

656: l_attribute10 jtf_rs_team_members.attribute10%TYPE;
657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;
658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;
659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;
660: l_attribute14 jtf_rs_team_members.attribute14%TYPE;
661: l_attribute15 jtf_rs_team_members.attribute15%TYPE;
662: l_attribute_catgory jtf_rs_team_members.attribute_category%TYPE;
663:
664: l_check_char VARCHAR2(1);

Line 661: l_attribute15 jtf_rs_team_members.attribute15%TYPE;

657: l_attribute11 jtf_rs_team_members.attribute11%TYPE;
658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;
659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;
660: l_attribute14 jtf_rs_team_members.attribute14%TYPE;
661: l_attribute15 jtf_rs_team_members.attribute15%TYPE;
662: l_attribute_catgory jtf_rs_team_members.attribute_category%TYPE;
663:
664: l_check_char VARCHAR2(1);
665: l_check_count NUMBER;

Line 662: l_attribute_catgory jtf_rs_team_members.attribute_category%TYPE;

658: l_attribute12 jtf_rs_team_members.attribute12%TYPE;
659: l_attribute13 jtf_rs_team_members.attribute13%TYPE;
660: l_attribute14 jtf_rs_team_members.attribute14%TYPE;
661: l_attribute15 jtf_rs_team_members.attribute15%TYPE;
662: l_attribute_catgory jtf_rs_team_members.attribute_category%TYPE;
663:
664: l_check_char VARCHAR2(1);
665: l_check_count NUMBER;
666: l_bind_data_id NUMBER;

Line 690: FROM jtf_rs_team_members

686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
688: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
689: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
690: FROM jtf_rs_team_members
691: WHERE team_member_id = l_team_member_id ;
692:
693: rs_team_member_rec c_rs_team_members_update%ROWTYPE ;
694:

Line 737: 'JTF_RS_TEAM_MEMBERS_PVT',

733:
734: /* Pre Call to the Customer Type User Hook */
735:
736: IF jtf_resource_utl.ok_to_execute(
737: 'JTF_RS_TEAM_MEMBERS_PVT',
738: 'UPDATE_RESOURCE_TEAM_MEMBERS',
739: 'B',
740: 'C')
741: THEN

Line 743: 'JTF_RS_TEAM_MEMBERS_PVT',

739: 'B',
740: 'C')
741: THEN
742: IF jtf_usr_hks.ok_to_execute(
743: 'JTF_RS_TEAM_MEMBERS_PVT',
744: 'UPDATE_RESOURCE_TEAM_MEMBERS',
745: 'B',
746: 'C')
747: THEN

Line 765: 'JTF_RS_TEAM_MEMBERS_PVT',

761:
762: /* Pre Call to the Vertical Type User Hook */
763:
764: IF jtf_resource_utl.ok_to_execute(
765: 'JTF_RS_TEAM_MEMBERS_PVT',
766: 'UPDATE_RESOURCE_TEAM_MEMBERS',
767: 'B',
768: 'V')
769: THEN

Line 771: 'JTF_RS_TEAM_MEMBERS_PVT',

767: 'B',
768: 'V')
769: THEN
770: IF jtf_usr_hks.ok_to_execute(
771: 'JTF_RS_TEAM_MEMBERS_PVT',
772: 'UPDATE_RESOURCE_TEAM_MEMBERS',
773: 'B',
774: 'V')
775: THEN

Line 793: 'JTF_RS_TEAM_MEMBERS_PVT',

789:
790: /* Pre Call to the Internal Type User Hook */
791:
792: IF jtf_resource_utl.ok_to_execute(
793: 'JTF_RS_TEAM_MEMBERS_PVT',
794: 'UPDATE_RESOURCE_TEAM_MEMBERS',
795: 'B',
796: 'I')
797: THEN

Line 799: 'JTF_RS_TEAM_MEMBERS_PVT',

795: 'B',
796: 'I')
797: THEN
798: IF jtf_usr_hks.ok_to_execute(
799: 'JTF_RS_TEAM_MEMBERS_PVT',
800: 'UPDATE_RESOURCE_TEAM_MEMBERS',
801: 'B',
802: 'I')
803: THEN

Line 832: jtf_rs_team_members_pkg.lock_row(

828: END IF ;
829:
830: /* Call the Lock Row Table Handler before updating the record */
831: BEGIN
832: jtf_rs_team_members_pkg.lock_row(
833: x_team_member_id => l_team_member_id,
834: x_object_version_number => l_object_version_number) ;
835: EXCEPTION
836: WHEN OTHERS THEN

Line 850: jtf_rs_team_members_pkg.update_row(

846: l_object_version_number := l_object_version_number + 1 ;
847:
848: /* Update the row into the table by calling the table handler. */
849: BEGIN
850: jtf_rs_team_members_pkg.update_row(
851: x_team_member_id => l_team_member_id,
852: x_team_id => rs_team_member_rec.l_team_id,
853: x_team_resource_id => rs_team_member_rec.l_team_resource_id,
854: x_resource_type => rs_team_member_rec.l_resource_type,

Line 900: 'JTF_RS_TEAM_MEMBERS_PVT',

896:
897: /* Post Call to the Customer Type User Hook */
898:
899: IF jtf_resource_utl.ok_to_execute(
900: 'JTF_RS_TEAM_MEMBERS_PVT',
901: 'UPDATE_RESOURCE_TEAM_MEMBERS',
902: 'A',
903: 'C')
904: THEN

Line 906: 'JTF_RS_TEAM_MEMBERS_PVT',

902: 'A',
903: 'C')
904: THEN
905: IF jtf_usr_hks.ok_to_execute(
906: 'JTF_RS_TEAM_MEMBERS_PVT',
907: 'UPDATE_RESOURCE_TEAM_MEMBERS',
908: 'A',
909: 'C')
910: THEN

Line 927: 'JTF_RS_TEAM_MEMBERS_PVT',

923:
924: /* Post Call to the Vertical Type User Hook */
925:
926: IF jtf_resource_utl.ok_to_execute(
927: 'JTF_RS_TEAM_MEMBERS_PVT',
928: 'UPDATE_RESOURCE_TEAM_MEMBERS',
929: 'A',
930: 'V')
931: THEN

Line 933: 'JTF_RS_TEAM_MEMBERS_PVT',

929: 'A',
930: 'V')
931: THEN
932: IF jtf_usr_hks.ok_to_execute(
933: 'JTF_RS_TEAM_MEMBERS_PVT',
934: 'UPDATE_RESOURCE_TEAM_MEMBERS',
935: 'A',
936: 'V')
937: THEN

Line 955: 'JTF_RS_TEAM_MEMBERS_PVT',

951:
952: /* Post Call to the Internal Type User Hook */
953:
954: IF jtf_resource_utl.ok_to_execute(
955: 'JTF_RS_TEAM_MEMBERS_PVT',
956: 'UPDATE_RESOURCE_TEAM_MEMBERS',
957: 'A',
958: 'I')
959: THEN

Line 961: 'JTF_RS_TEAM_MEMBERS_PVT',

957: 'A',
958: 'I')
959: THEN
960: IF jtf_usr_hks.ok_to_execute(
961: 'JTF_RS_TEAM_MEMBERS_PVT',
962: 'UPDATE_RESOURCE_TEAM_MEMBERS',
963: 'A',
964: 'I')
965: THEN

Line 982: 'JTF_RS_TEAM_MEMBERS_PVT',

978:
979: /* Standard call for Message Generation */
980:
981: IF jtf_resource_utl.ok_to_execute(
982: 'JTF_RS_TEAM_MEMBERS_PVT',
983: 'UPDATE_RESOURCE_TEAM_MEMBERS',
984: 'M',
985: 'M')
986: THEN

Line 988: 'JTF_RS_TEAM_MEMBERS_PVT',

984: 'M',
985: 'M')
986: THEN
987: IF jtf_usr_hks.ok_to_execute(
988: 'JTF_RS_TEAM_MEMBERS_PVT',
989: 'UPDATE_RESOURCE_TEAM_MEMBERS',
990: 'M',
991: 'M')
992: THEN

Line 1055: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,

1051: PROCEDURE delete_resource_team_members
1052: (P_API_VERSION IN NUMBER,
1053: P_INIT_MSG_LIST IN VARCHAR2,
1054: P_COMMIT IN VARCHAR2,
1055: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
1056: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
1057: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
1058: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
1059: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1056: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

1052: (P_API_VERSION IN NUMBER,
1053: P_INIT_MSG_LIST IN VARCHAR2,
1054: P_COMMIT IN VARCHAR2,
1055: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
1056: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
1057: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
1058: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
1059: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1060: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1057: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

1053: P_INIT_MSG_LIST IN VARCHAR2,
1054: P_COMMIT IN VARCHAR2,
1055: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
1056: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
1057: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
1058: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
1059: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1060: X_MSG_COUNT OUT NOCOPY NUMBER,
1061: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1058: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

1054: P_COMMIT IN VARCHAR2,
1055: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
1056: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
1057: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
1058: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
1059: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1060: X_MSG_COUNT OUT NOCOPY NUMBER,
1061: X_MSG_DATA OUT NOCOPY VARCHAR2
1062: ) IS

Line 1066: l_team_id jtf_rs_team_members.team_id%TYPE;

1062: ) IS
1063:
1064: l_api_version CONSTANT NUMBER := 1.0;
1065: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_TEAM_MEMBERS';
1066: l_team_id jtf_rs_team_members.team_id%TYPE;
1067: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
1068: l_resource_type jtf_rs_team_members.resource_type%TYPE;
1069: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
1070: l_role_relate_count NUMBER;

Line 1067: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;

1063:
1064: l_api_version CONSTANT NUMBER := 1.0;
1065: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_TEAM_MEMBERS';
1066: l_team_id jtf_rs_team_members.team_id%TYPE;
1067: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
1068: l_resource_type jtf_rs_team_members.resource_type%TYPE;
1069: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
1070: l_role_relate_count NUMBER;
1071: l_bind_data_id NUMBER;

Line 1068: l_resource_type jtf_rs_team_members.resource_type%TYPE;

1064: l_api_version CONSTANT NUMBER := 1.0;
1065: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_TEAM_MEMBERS';
1066: l_team_id jtf_rs_team_members.team_id%TYPE;
1067: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
1068: l_resource_type jtf_rs_team_members.resource_type%TYPE;
1069: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
1070: l_role_relate_count NUMBER;
1071: l_bind_data_id NUMBER;
1072: l_resource_id NUMBER;

Line 1069: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;

1065: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_TEAM_MEMBERS';
1066: l_team_id jtf_rs_team_members.team_id%TYPE;
1067: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE;
1068: l_resource_type jtf_rs_team_members.resource_type%TYPE;
1069: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
1070: l_role_relate_count NUMBER;
1071: l_bind_data_id NUMBER;
1072: l_resource_id NUMBER;
1073: l_group_id NUMBER;

Line 1084: FROM jtf_rs_team_members

1080: l_team_resource_id IN NUMBER,
1081: l_resource_type IN VARCHAR2)
1082: IS
1083: SELECT team_member_id
1084: FROM jtf_rs_team_members
1085: WHERE team_id = l_team_id
1086: AND team_resource_id = l_team_resource_id
1087: AND resource_type = l_resource_type
1088: AND nvl(delete_flag,'N') <> 'Y';

Line 1135: 'JTF_RS_TEAM_MEMBERS_PVT',

1131:
1132: /* Pre Call to the Customer Type User Hook */
1133:
1134: IF jtf_resource_utl.ok_to_execute(
1135: 'JTF_RS_TEAM_MEMBERS_PVT',
1136: 'DELETE_RESOURCE_TEAM_MEMBERS',
1137: 'B',
1138: 'C')
1139: THEN

Line 1141: 'JTF_RS_TEAM_MEMBERS_PVT',

1137: 'B',
1138: 'C')
1139: THEN
1140: IF jtf_usr_hks.ok_to_execute(
1141: 'JTF_RS_TEAM_MEMBERS_PVT',
1142: 'DELETE_RESOURCE_TEAM_MEMBERS',
1143: 'B',
1144: 'C')
1145: THEN

Line 1173: 'JTF_RS_TEAM_MEMBERS_PVT',

1169:
1170: /* Pre Call to the Vertical Type User Hook */
1171:
1172: IF jtf_resource_utl.ok_to_execute(
1173: 'JTF_RS_TEAM_MEMBERS_PVT',
1174: 'DELETE_RESOURCE_TEAM_MEMBERS',
1175: 'B',
1176: 'V')
1177: THEN

Line 1179: 'JTF_RS_TEAM_MEMBERS_PVT',

1175: 'B',
1176: 'V')
1177: THEN
1178: IF jtf_usr_hks.ok_to_execute(
1179: 'JTF_RS_TEAM_MEMBERS_PVT',
1180: 'DELETE_RESOURCE_TEAM_MEMBERS',
1181: 'B',
1182: 'V')
1183: THEN

Line 1211: 'JTF_RS_TEAM_MEMBERS_PVT',

1207:
1208: /* Pre Call to the Internal Type User Hook */
1209:
1210: IF jtf_resource_utl.ok_to_execute(
1211: 'JTF_RS_TEAM_MEMBERS_PVT',
1212: 'DELETE_RESOURCE_TEAM_MEMBERS',
1213: 'B',
1214: 'I')
1215: THEN

Line 1217: 'JTF_RS_TEAM_MEMBERS_PVT',

1213: 'B',
1214: 'I')
1215: THEN
1216: IF jtf_usr_hks.ok_to_execute(
1217: 'JTF_RS_TEAM_MEMBERS_PVT',
1218: 'DELETE_RESOURCE_TEAM_MEMBERS',
1219: 'B',
1220: 'I')
1221: THEN

Line 1337: jtf_rs_team_members_pkg.lock_row(

1333: is still valid. */
1334:
1335: BEGIN
1336:
1337: jtf_rs_team_members_pkg.lock_row(
1338: x_team_member_id => l_team_member_id,
1339: x_object_version_number => p_object_version_num
1340: );
1341:

Line 1389: jtf_rs_team_members_pkg.logical_delete_row(

1385: END;
1386:
1387: /* Delete the row into the table by calling the table handler. */
1388:
1389: jtf_rs_team_members_pkg.logical_delete_row(
1390: x_team_member_id => l_team_member_id
1391: );
1392:
1393: EXCEPTION

Line 1414: 'JTF_RS_TEAM_MEMBERS_PVT',

1410:
1411: /* Post Call to the Customer Type User Hook */
1412:
1413: IF jtf_resource_utl.ok_to_execute(
1414: 'JTF_RS_TEAM_MEMBERS_PVT',
1415: 'DELETE_RESOURCE_TEAM_MEMBERS',
1416: 'A',
1417: 'C')
1418: THEN

Line 1420: 'JTF_RS_TEAM_MEMBERS_PVT',

1416: 'A',
1417: 'C')
1418: THEN
1419: IF jtf_usr_hks.ok_to_execute(
1420: 'JTF_RS_TEAM_MEMBERS_PVT',
1421: 'DELETE_RESOURCE_TEAM_MEMBERS',
1422: 'A',
1423: 'C')
1424: THEN

Line 1452: 'JTF_RS_TEAM_MEMBERS_PVT',

1448:
1449: /* Post Call to the Vertical Type User Hook */
1450:
1451: IF jtf_resource_utl.ok_to_execute(
1452: 'JTF_RS_TEAM_MEMBERS_PVT',
1453: 'DELETE_RESOURCE_TEAM_MEMBERS',
1454: 'A',
1455: 'V')
1456: THEN

Line 1458: 'JTF_RS_TEAM_MEMBERS_PVT',

1454: 'A',
1455: 'V')
1456: THEN
1457: IF jtf_usr_hks.ok_to_execute(
1458: 'JTF_RS_TEAM_MEMBERS_PVT',
1459: 'DELETE_RESOURCE_TEAM_MEMBERS',
1460: 'A',
1461: 'V')
1462: THEN

Line 1490: 'JTF_RS_TEAM_MEMBERS_PVT',

1486:
1487: /* Post Call to the Internal Type User Hook */
1488:
1489: IF jtf_resource_utl.ok_to_execute(
1490: 'JTF_RS_TEAM_MEMBERS_PVT',
1491: 'DELETE_RESOURCE_TEAM_MEMBERS',
1492: 'A',
1493: 'I')
1494: THEN

Line 1496: 'JTF_RS_TEAM_MEMBERS_PVT',

1492: 'A',
1493: 'I')
1494: THEN
1495: IF jtf_usr_hks.ok_to_execute(
1496: 'JTF_RS_TEAM_MEMBERS_PVT',
1497: 'DELETE_RESOURCE_TEAM_MEMBERS',
1498: 'A',
1499: 'I')
1500: THEN

Line 1528: 'JTF_RS_TEAM_MEMBERS_PVT',

1524:
1525: /* Standard call for Message Generation */
1526:
1527: IF jtf_resource_utl.ok_to_execute(
1528: 'JTF_RS_TEAM_MEMBERS_PVT',
1529: 'DELETE_RESOURCE_TEAM_MEMBERS',
1530: 'M',
1531: 'M')
1532: THEN

Line 1534: 'JTF_RS_TEAM_MEMBERS_PVT',

1530: 'M',
1531: 'M')
1532: THEN
1533: IF jtf_usr_hks.ok_to_execute(
1534: 'JTF_RS_TEAM_MEMBERS_PVT',
1535: 'DELETE_RESOURCE_TEAM_MEMBERS',
1536: 'M',
1537: 'M')
1538: THEN

Line 1628: END jtf_rs_team_members_pvt;

1624: END delete_resource_team_members;
1625:
1626:
1627:
1628: END jtf_rs_team_members_pvt;