1 PACKAGE jtf_rs_group_members_pvt AS
2 /* $Header: jtfrsvms.pls 120.0 2005/05/11 08:23:09 appldev ship $ */
3
4 /*****************************************************************************************
5 This is a private API that caller will invoke.
6 It provides procedures for managing resource group members, like
7 create and delete resource group members.
8 Its main procedures are as following:
9 Create Resource Group Members
10 Delete Resource Group Members
11 Calls to these procedures will invoke calls to table handlers which
12 do actual inserts and deletes into tables.
13 ******************************************************************************************/
14
15 /* Global vraiable to indicate that the member is being moved from one group
16 to another as well as the old group id. This will be used for the insert in
17 of group member audit api for an insert of a new member. In this case the old_group_id
18 will be assigned this variable value which will be initialized when a member is moved */
19
20 G_MOVED_FR_GROUP_ID JTF_RS_GROUPS_B.GROUP_ID%TYPE DEFAULT NULL;
21
22
23 /*Procedure to assign value to the global variable */
24 PROCEDURE assign_value_to_global
25 (P_API_VERSION IN NUMBER,
26 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
29 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
30 X_MSG_COUNT OUT NOCOPY NUMBER,
31 X_MSG_DATA OUT NOCOPY VARCHAR2
32 );
33
34 /* Procedure to create the resource group members
35 based on input values passed by calling routines. */
36
37 PROCEDURE create_resource_group_members
38 (P_API_VERSION IN NUMBER,
39 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
42 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
43 P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
44 P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45 P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46 P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47 P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48 P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49 P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50 P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51 P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52 P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53 P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54 P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55 P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
56 P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
57 P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
58 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60 X_MSG_COUNT OUT NOCOPY NUMBER,
61 X_MSG_DATA OUT NOCOPY VARCHAR2,
62 X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE
63 );
64
65 /* Procedure to update the resource group members. */
66
67 PROCEDURE update_resource_group_members
68 (P_API_VERSION IN NUMBER,
69 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71 P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
72 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
73 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74 P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75 P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76 P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77 P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78 P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79 P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80 P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81 P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82 P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83 P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84 P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85 P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86 P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87 P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88 P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89 P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
90 P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
91 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
92 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
93 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94 X_MSG_COUNT OUT NOCOPY NUMBER,
95 X_MSG_DATA OUT NOCOPY VARCHAR2
96 );
97
98
99 /* Procedure to delete the resource group members. */
100
101 PROCEDURE delete_resource_group_members
102 (P_API_VERSION IN NUMBER,
103 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
106 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
107 P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
108 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
109 X_MSG_COUNT OUT NOCOPY NUMBER,
110 X_MSG_DATA OUT NOCOPY VARCHAR2
111 );
112
113 /* Procedure to move member hook */
114
115 PROCEDURE execute_sales_hook
116 (P_API_VERSION IN NUMBER,
117 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
118 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
119 P_OLD_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
120 P_NEW_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
121 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
122 P_OLD_START_DATE IN DATE,
123 P_OLD_END_DATE IN DATE,
124 P_NEW_START_DATE IN DATE,
125 P_NEW_END_DATE IN DATE,
126 X_RETURN_STATUS OUT NOCOPY VARCHAR2
127 );
128 END jtf_rs_group_members_pvt;