1 PACKAGE jtf_rs_team_members_pvt AUTHID CURRENT_USER 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.
6 It provides procedures for managing resource team members, like
7 create and delete resource team members.
8 Its main procedures are as following:
9 Create Resource Team Members
10 Delete Resource Team Members
11 Calls to these procedures will invoke calls to table handlers which
12 do actual inserts and deletes into tables.
13 Update Resource Team Members
14 ******************************************************************************************/
15
16
17 /* Procedure to create the resource team members
18 based on input values passed by calling routines. */
19
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,
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,
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
47 );
48
49 /* Procedure to update the resource team members
50 based on input values passed by calling routines. */
51
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,
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,
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,
79 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
80 X_MSG_COUNT OUT NOCOPY NUMBER,
81 X_MSG_DATA OUT NOCOPY VARCHAR2
82 ) ;
83
84
85 /* Procedure to delete the resource team members. */
86
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,
96 X_MSG_COUNT OUT NOCOPY NUMBER,
97 X_MSG_DATA OUT NOCOPY VARCHAR2
98 );
99
100
101 END jtf_rs_team_members_pvt;