1 PACKAGE jtf_rs_group_orgs_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtfrseos.pls 120.0 2005/05/11 08:19:57 appldev noship $ */
3
4 /*****************************************************************************************
5 This is a private API that caller will invoke.
6 It provides procedures for managing resource group to HR Org mapping
7 Its main procedures are as following:
8 Create Group Org
9 Update Group Org
10 Delete Group Org
11 Calls to these procedures will invoke calls to table handlers which
12 do actual insert, update and delete into tables.
13 ******************************************************************************************/
14
15 /* Procedure to create the resource group - HR Org mapping
16 */
17
18 PROCEDURE create_group_org
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_ID IN JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,
23 P_ORGANIZATION_ID IN JTF_RS_GROUP_ORGANIZATIONS.ORGANIZATION_ID%TYPE,
24 P_ATTRIBUTE1 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
25 P_ATTRIBUTE2 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
26 P_ATTRIBUTE3 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
27 P_ATTRIBUTE4 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
28 P_ATTRIBUTE5 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
29 P_ATTRIBUTE6 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
30 P_ATTRIBUTE7 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
31 P_ATTRIBUTE8 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
32 P_ATTRIBUTE9 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
33 P_ATTRIBUTE10 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
34 P_ATTRIBUTE11 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
35 P_ATTRIBUTE12 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
36 P_ATTRIBUTE13 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
37 P_ATTRIBUTE14 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
38 P_ATTRIBUTE15 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
39 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
40 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
41 X_MSG_COUNT OUT NOCOPY NUMBER,
42 X_MSG_DATA OUT NOCOPY VARCHAR2
43 );
44
45 /* Procedure to update the resource group - HR Org mapping
46 */
47
48 PROCEDURE update_group_org
49 (P_API_VERSION IN NUMBER,
50 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52 P_GROUP_ID IN JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,
53 P_ORGANIZATION_ID IN JTF_RS_GROUP_ORGANIZATIONS.ORGANIZATION_ID%TYPE,
54 P_ATTRIBUTE1 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
55 P_ATTRIBUTE2 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
56 P_ATTRIBUTE3 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
57 P_ATTRIBUTE4 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
58 P_ATTRIBUTE5 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
59 P_ATTRIBUTE6 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
60 P_ATTRIBUTE7 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
61 P_ATTRIBUTE8 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
62 P_ATTRIBUTE9 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
63 P_ATTRIBUTE10 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
64 P_ATTRIBUTE11 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
65 P_ATTRIBUTE12 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
66 P_ATTRIBUTE13 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
67 P_ATTRIBUTE14 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
68 P_ATTRIBUTE15 IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
69 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
70 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_ORGANIZATIONS.OBJECT_VERSION_NUMBER%TYPE,
71 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
72 X_MSG_COUNT OUT NOCOPY NUMBER,
73 X_MSG_DATA OUT NOCOPY VARCHAR2
74 );
75
76 /* Procedure to delete resource group - HR Org mapping
77 */
78
79 PROCEDURE delete_group_org
80 (P_API_VERSION IN NUMBER,
81 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83 P_GROUP_ID IN JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,
84 P_ORGANIZATION_ID IN JTF_RS_GROUP_ORGANIZATIONS.ORGANIZATION_ID%TYPE,
85 P_OBJECT_VERSION_NUMBER IN JTF_RS_GROUP_ORGANIZATIONS.OBJECT_VERSION_NUMBER%TYPE,
86 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
87 X_MSG_COUNT OUT NOCOPY NUMBER,
88 X_MSG_DATA OUT NOCOPY VARCHAR2
89 );
90
91 END jtf_rs_group_orgs_pvt;