1 PACKAGE jtf_rs_grp_membership_pub AS
2 /* $Header: jtfrsrms.pls 120.0 2005/05/11 08:21:41 appldev ship $ */
3 /*#
4 * Package containing procedures to maintain group membership informatio
5 * @rep:scope private
6 * @rep:product JTF
7 * @rep:displayname Group Membership Package
8 * @rep:category BUSINESS_ENTITY JTF_RS_GROUP
9 * @rep:category BUSINESS_ENTITY JTF_RS_GROUP_MEMBER_ROLE
10 */
11
12 /*****************************************************************************************
13 ******************************************************************************************/
14
15 /* Procedure to create the Group member role and role relation */
16
17 /*#
18 * Procedure to create group membership information. This would
19 * create group member as well as its associated Group Member Role
20 * @param P_API_VERSION API version number
21 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
22 * @param P_COMMIT Flag to commit at the end of the procedure
23 * @param P_RESOURCE_ID Internal unique id for the resource
24 * @param P_GROUP_ID Internal unique id for the group
25 * @param P_ROLE_ID Internal unique id for the role
26 * @param P_START_DATE Active from date for the group member role
27 * @param P_END_DATE Active to date for the group member role
28 * @param X_RETURN_STATUS Output parameter for return status
29 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
30 * @param X_MSG_DATA Output parameter containing last user message from this procedure
31 * @rep:scope private
32 * @rep:displayname Create Group Membership
33 */
34 PROCEDURE create_group_membership
35 (P_API_VERSION IN NUMBER,
36 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38 P_RESOURCE_ID IN NUMBER,
39 P_GROUP_ID IN NUMBER,
40 P_ROLE_ID IN NUMBER,
41 P_START_DATE IN DATE,
42 P_END_DATE IN DATE DEFAULT NULL,
43 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44 X_MSG_COUNT OUT NOCOPY NUMBER,
45 X_MSG_DATA OUT NOCOPY VARCHAR2
46 );
47
48 /* Procedure to update the Group member role and role relation */
49
50 /*#
51 * Procedure to update group membership information. This would update
52 * Group Member Role.
53 * @param P_API_VERSION API version number
54 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
55 * @param P_COMMIT Flag to commit at the end of the procedure
56 * @param P_RESOURCE_ID Internal unique id for the resource
57 * @param P_ROLE_ID Internal unique id for the role
58 * @param P_ROLE_RELATE_ID Internal unique id for the group member role
59 * @param P_START_DATE Active from date for the group member role
60 * @param P_END_DATE Active to date for the group member role
61 * @param P_OBJECT_VERSION_NUM Object Version Number of the group member role record
62 * @param X_RETURN_STATUS Output parameter for return status
63 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
64 * @param X_MSG_DATA Output parameter containing last user message from this procedure
65 * @rep:scope private
66 * @rep:displayname Create Group Membership
67 */
68 PROCEDURE update_group_membership
69 (P_API_VERSION IN NUMBER,
70 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72 P_RESOURCE_ID IN NUMBER,
73 P_ROLE_ID IN NUMBER,
74 P_ROLE_RELATE_ID IN NUMBER,
75 P_START_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
76 P_END_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
77 P_OBJECT_VERSION_NUM IN NUMBER,
78 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
79 X_MSG_COUNT OUT NOCOPY NUMBER,
80 X_MSG_DATA OUT NOCOPY VARCHAR2
81 );
82
83 /* Procedure to delete the Group member role and role relation */
84
85 /*#
86 * Procedure to delete group membership information. If there is group member
87 * role relation, then its deleted. Otherwise group member information is deleted.
88 * @param P_API_VERSION API version number
89 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
90 * @param P_COMMIT Flag to commit at the end of the procedure
91 * @param P_GROUP_ID Internal unique id for the group
92 * @param P_RESOURCE_ID Internal unique id for the resource
93 * @param P_GROUP_MEMBER_ID Internal unique id for the group member
94 * @param P_ROLE_RELATE_ID Internal unique id for the group member role
95 * @param P_OBJECT_VERSION_NUM Object Version Number of the group member role record
96 * @param X_RETURN_STATUS Output parameter for return status
97 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
98 * @param X_MSG_DATA Output parameter containing last user message from this procedure
99 * @rep:scope private
100 * @rep:displayname Delete Group Membership
101 */
102 PROCEDURE delete_group_membership
103 (P_API_VERSION IN NUMBER,
104 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106 P_GROUP_ID IN NUMBER,
107 P_RESOURCE_ID IN NUMBER,
108 P_GROUP_MEMBER_ID IN NUMBER,
109 P_ROLE_RELATE_ID IN NUMBER,
110 P_OBJECT_VERSION_NUM IN NUMBER,
111 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
112 X_MSG_COUNT OUT NOCOPY NUMBER,
113 X_MSG_DATA OUT NOCOPY VARCHAR2
114 );
115
116
117 END jtf_rs_grp_membership_pub;