1 PACKAGE jtf_rs_team_members_pub AS
2 /* $Header: jtfrspes.pls 120.0 2005/05/11 08:21:07 appldev ship $ */
3 /*#
4 * Team Member create and delete API
5 * This API contains the procedures to insert and delete Team member record.
6 * @rep:scope internal
7 * @rep:product JTF
8 * @rep:displayname Team Members API
9 * @rep:category BUSINESS_ENTITY JTF_RS_TEAM_MEMBER
10 */
11 /*****************************************************************************************
12 This is a public API that caller will invoke.
13 It provides procedures for managing resource team members, like
14 create, update and delete resource team members from other modules.
15 Its main procedures are as following:
16 Create Resource Team Members
17 Update Resource Team Members
18 Delete Resource Team Members
19 Calls to these procedures will invoke procedures from jtf_rs_team_members_pvt
20 to do business validations and to do actual inserts, updates and deletes into tables.
21 ******************************************************************************************/
22
23
24 /* Procedure to create the resource team members
25 based on input values passed by calling routines. */
26
27 /*#
28 * Create Team Member API
29 * This procedure allows the user to create a team member record.
30 * @param p_api_version API version
31 * @param p_init_msg_list Initialization of the message list
32 * @param p_commit Commit
33 * @param p_team_id Team Identifier
34 * @param p_team_number Team Number
35 * @param p_team_resource_id Team Resource Identifier. This can be Resource or Group Identifier
36 * @param p_team_resource_number Team Resource Number. This can be Resource or Group Number
37 * @param p_resource_type Type of the Resource. This can be Resource or Group.
38 * @param x_return_status Output parameter for return status
39 * @param x_msg_count Output parameter for number of user messages from this procedure
40 * @param x_msg_data Output parameter containing last user message from this procedure
41 * @param x_team_member_id Out parameter for Team Member Identifier
42 * @rep:scope internal
43 * @rep:lifecycle active
44 * @rep:displayname Create Team Member API
45 */
46 PROCEDURE create_resource_team_members
47 (P_API_VERSION IN NUMBER,
48 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
50 P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
51 P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
52 P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
53 P_TEAM_RESOURCE_NUMBER IN NUMBER,
54 P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
55 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56 X_MSG_COUNT OUT NOCOPY NUMBER,
57 X_MSG_DATA OUT NOCOPY VARCHAR2,
58 X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE
59 );
60
61
62 /* Procedure to delete the resource team members. */
63 /*#
64 * Delete Team Member API
65 * This procedure allows the user to delete a team member record.
66 * @param p_api_version API version
67 * @param p_init_msg_list Initialization of the message list
68 * @param p_commit Commit
69 * @param p_team_id Team Identifier
70 * @param p_team_number Team Number
71 * @param p_team_resource_id Team Resource Identifier. This can be Resource or Group Identifier
72 * @param p_team_resource_number Team Resource Number. This can be Resource or Group Number
73 * @param p_resource_type Type of the Resource. This can be Resource or Group.
74 * @param p_object_version_num The object version number of the team member derives from the jtf_rs_team_members table
75 * @param x_return_status Output parameter for return status
76 * @param x_msg_count Output parameter for number of user messages from this procedure
77 * @param x_msg_data Output parameter containing last user message from this procedure
78 * @rep:scope internal
79 * @rep:lifecycle active
80 * @rep:displayname Delete Team Member API
81 */
82 PROCEDURE delete_resource_team_members
83 (P_API_VERSION IN NUMBER,
84 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86 P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
87 P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
88 P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
89 P_TEAM_RESOURCE_NUMBER IN NUMBER,
90 P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
91 P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
92 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
93 X_MSG_COUNT OUT NOCOPY NUMBER,
94 X_MSG_DATA OUT NOCOPY VARCHAR2
95 );
96
97
98 END jtf_rs_team_members_pub;
[Home] [Help]