1 PACKAGE jtf_rs_group_members_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspms.pls 120.0 2005/05/11 08:21:16 appldev ship $ */
3 /*#
4 * Group Member create, update and delete API
5 * This API contains the procedures to insert, update and delete Group member record.
6 * @rep:scope internal
7 * @rep:product JTF
8 * @rep:displayname Group Members API
9 * @rep:category BUSINESS_ENTITY JTF_RS_GROUP_MEMBER
10 */
11 /*****************************************************************************************
12 This is a public API that caller will invoke.
13 It provides procedures for managing resource group members, like
14 create, update and delete resource group members from other modules.
15 Its main procedures are as following:
16 Create Resource Group Members
17 Delete Resource Group Members
18 Calls to these procedures will invoke procedures from jtf_rs_group_members_pvt
19 to do business validations and to do actual inserts and deletes into tables.
20 ******************************************************************************************/
21
22
23 /* Procedure to create the resource group members
24 based on input values passed by calling routines. */
25 /*#
26 * Create Group Member API
27 * This procedure allows the user to create a group member record.
28 * @param p_api_version API version
29 * @param p_init_msg_list Initialization of the message list
30 * @param p_commit Commit
31 * @param p_group_id Group Identifier
32 * @param p_group_number Group Number
33 * @param p_resource_id Resource Identifier
34 * @param p_resource_number Resource Number
35 * @param x_return_status Output parameter for return status
36 * @param x_msg_count Output parameter for number of user messages from this procedure
37 * @param x_msg_data Output parameter containing last user message from this procedure
38 * @param x_group_member_id Out parameter for Group Member Identifier
39 * @rep:scope internal
40 * @rep:lifecycle active
41 * @rep:displayname Create Group Member API
42 */
43 PROCEDURE create_resource_group_members
44 (P_API_VERSION IN NUMBER,
45 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
48 P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
49 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
50 P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
51 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52 X_MSG_COUNT OUT NOCOPY NUMBER,
53 X_MSG_DATA OUT NOCOPY VARCHAR2,
54 X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE
55 );
56
57
58 /* Procedure to update the resource group members. */
59 /*#
60 * Update Group Member API
61 * This procedure allows the user to update a group member record.
62 * @param p_api_version API version
63 * @param p_init_msg_list Initialization of the message list
64 * @param p_commit Commit
65 * @param p_group_member_id Group Member Identifier
66 * @param p_group_id Group Identifier
67 * @param p_group_number Group Number
68 * @param p_resource_id Resource Identifier
69 * @param p_resource_number Resource Number
70 * @param p_object_version_number The object version number of the group member derives from the jtf_rs_group_members table.
71 * @param x_return_status Output parameter for return status
72 * @param x_msg_count Output parameter for number of user messages from this procedure
73 * @param x_msg_data Output parameter containing last user message from this procedure
74 * @rep:scope internal
75 * @rep:lifecycle active
76 * @rep:displayname Update Group Member API
77 */
78 PROCEDURE update_resource_group_members
79 (P_API_VERSION IN NUMBER,
80 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
81 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82 P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
83 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
84 P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
85 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
86 P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
87 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
88 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89 X_MSG_COUNT OUT NOCOPY NUMBER,
90 X_MSG_DATA OUT NOCOPY VARCHAR2
91 );
92
93 /* Procedure to delete the resource group members. */
94 /*#
95 * Delete Group Member API
96 * This procedure allows the user to delete a group member record.
97 * @param p_api_version API version
98 * @param p_init_msg_list Initialization of the message list
99 * @param p_commit Commit
100 * @param p_group_id Group Identifier
101 * @param p_group_number Group Number
102 * @param p_resource_id Resource Identifier
103 * @param p_resource_number Resource Number
104 * @param p_object_version_num The object version number of the group member derives from the jtf_rs_group_members table.
105 * @param x_return_status Output parameter for return status
106 * @param x_msg_count Output parameter for number of user messages from this procedure
107 * @param x_msg_data Output parameter containing last user message from this procedure
108 * @rep:scope internal
109 * @rep:lifecycle active
110 * @rep:displayname Delete Group Member API
111 */
112 PROCEDURE delete_resource_group_members
113 (P_API_VERSION IN NUMBER,
114 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
117 P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
118 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
119 P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
120 P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
121 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
122 X_MSG_COUNT OUT NOCOPY NUMBER,
123 X_MSG_DATA OUT NOCOPY VARCHAR2
124 );
125
126
127 END jtf_rs_group_members_pub;