1: PACKAGE jtf_rs_team_members_pvt AS
2: /* $Header: jtfrsves.pls 120.0 2005/05/11 08:22:57 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that caller will invoke.
20: PROCEDURE create_resource_team_members
21: (P_API_VERSION IN NUMBER,
22: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
25: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
26: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
27: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
21: (P_API_VERSION IN NUMBER,
22: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
25: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
26: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
27: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
22: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
25: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
26: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
27: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
25: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
26: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
27: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
24: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
25: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
26: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
27: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
25: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
26: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
27: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
26: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
27: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
27: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
28: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
29: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
30: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
31: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
39: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
32: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
39: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
40: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
33: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
39: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
40: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
41: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
34: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
39: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
40: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
41: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
42: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
35: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
39: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
40: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
41: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
42: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
43: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
39: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
40: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
41: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
42: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
43: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44: X_MSG_COUNT OUT NOCOPY NUMBER,
37: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
39: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
40: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
41: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
42: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
43: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44: X_MSG_COUNT OUT NOCOPY NUMBER,
45: X_MSG_DATA OUT NOCOPY VARCHAR2,
38: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
39: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
40: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
41: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
42: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
43: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44: X_MSG_COUNT OUT NOCOPY NUMBER,
45: X_MSG_DATA OUT NOCOPY VARCHAR2,
46: X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE
42: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
43: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44: X_MSG_COUNT OUT NOCOPY NUMBER,
45: X_MSG_DATA OUT NOCOPY VARCHAR2,
46: X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE
47: );
48:
49: /* Procedure to update the resource team members
50: based on input values passed by calling routines. */
52: PROCEDURE update_resource_team_members
53: (P_API_VERSION IN NUMBER,
54: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
57: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
58: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
59: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
53: (P_API_VERSION IN NUMBER,
54: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
57: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
58: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
59: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
54: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
57: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
58: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
59: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
55: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
57: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
58: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
59: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
56: P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
57: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
58: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
59: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
57: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
58: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
59: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
58: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
59: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_PERSON_ID IN JTF_RS_TEAM_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
60: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_DELETE_FLAG IN JTF_RS_TEAM_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_ATTRIBUTE1 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_ATTRIBUTE2 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE3 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE4 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE5 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE6 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE7 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE8 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE9 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
71: P_ATTRIBUTE10 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
79: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
72: P_ATTRIBUTE11 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
79: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
80: X_MSG_COUNT OUT NOCOPY NUMBER,
73: P_ATTRIBUTE12 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
79: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
80: X_MSG_COUNT OUT NOCOPY NUMBER,
81: X_MSG_DATA OUT NOCOPY VARCHAR2
74: P_ATTRIBUTE13 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE14 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE15 IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAM_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
79: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
80: X_MSG_COUNT OUT NOCOPY NUMBER,
81: X_MSG_DATA OUT NOCOPY VARCHAR2
82: ) ;
87: PROCEDURE delete_resource_team_members
88: (P_API_VERSION IN NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
92: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
93: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
94: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
88: (P_API_VERSION IN NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
92: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
93: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
94: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
92: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
93: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
94: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,
97: X_MSG_DATA OUT NOCOPY VARCHAR2
90: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
92: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
93: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
94: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,
97: X_MSG_DATA OUT NOCOPY VARCHAR2
98: );
97: X_MSG_DATA OUT NOCOPY VARCHAR2
98: );
99:
100:
101: END jtf_rs_team_members_pvt;