1 PACKAGE jtf_rs_groups_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtfrsvgs.pls 120.0.12010000.2 2009/05/11 07:39:41 rgokavar ship $ */
3
4 /*****************************************************************************************
5 This is a public API that caller will invoke.
6 It provides procedures for managing resource groups.
7 Its main procedures are as following:
8 Create Resource Group
9 Update Resource Group
10 Calls to these procedures will invoke calls to table handlers which
11 do actual inserts, updates and deletes into tables.
12 ******************************************************************************************/
13
14
15 /* Procedure to create the resource group and the members
16 based on input values passed by calling routines. */
17
18 PROCEDURE create_resource_group
19 (P_API_VERSION IN NUMBER,
20 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
23 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
24 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
25 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
26 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
27 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
28 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
29 P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
30 P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
31 P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
32 P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
33 P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
34 P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
35 P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
36 P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
37 P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
38 P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
39 P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
40 P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
41 P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
42 P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
43 P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
44 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46 X_MSG_COUNT OUT NOCOPY NUMBER,
47 X_MSG_DATA OUT NOCOPY VARCHAR2,
48 X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
49 X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
50 P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
51 );
52
53
54 --Creating a Global Variable to be used for setting the flag,
55 --when the create_resource_group_migrate gets called
56
57 G_RS_GRP_ID_PVT_FLAG VARCHAR2(1) := 'Y';
58
59
63 PROCEDURE create_resource_group_migrate
60 --Create Resource Group Migration API, used for one-time migration of resource data
61 --The API includes GROUP_ID as one of its Input Parameters
62
64 (P_API_VERSION IN NUMBER,
65 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
68 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
69 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
70 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
71 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
72 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
73 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
74 P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
75 P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
76 P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
77 P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
78 P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
79 P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
80 P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
81 P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
82 P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
83 P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
84 P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
85 P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
86 P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
87 P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
88 P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
89 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
90 P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
91 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
92 X_MSG_COUNT OUT NOCOPY NUMBER,
93 X_MSG_DATA OUT NOCOPY VARCHAR2,
94 X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
95 X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
96 P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
97 );
98
99 /* Procedure to update the resource group based on input values
100 passed by calling routines. */
101
102 PROCEDURE update_resource_group
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 JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
107 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
108 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
109 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
110 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
111 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
112 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
113 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
114 P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
115 P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
116 P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
117 P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
118 P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
119 P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
120 P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
121 P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
122 P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
123 P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
124 P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
125 P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
126 P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
127 P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
128 P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
129 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
130 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
131 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
132 X_MSG_COUNT OUT NOCOPY NUMBER,
133 X_MSG_DATA OUT NOCOPY VARCHAR2,
134 P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM
135 );
136
137
138 END jtf_rs_groups_pvt;