eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.JTF_RS_GROUP_ORGS_PUB

Source


1 PACKAGE  JTF_RS_GROUP_ORGS_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfrsuos.pls 120.0 2005/05/11 08:22:50 appldev noship $ */
3 /*#
4  * API to create, update and delete Resource Group to HR Org mapping
5  * This API contains the procedures to insert, update and delete Resource Group
6  * to HR Org mapping record.
7  * @rep:scope internal
8  * @rep:product JTF
9  * @rep:displayname Resource Group to HR Organization Mapping API
10  * @rep:category BUSINESS_ENTITY JTF_RS_GROUP_HR_ORG_MAPPING
11 */
12   /*****************************************************************************************
13    This is a public API that caller will invoke.
14    It provides procedures for managing Resource Group to HR Org mapping, like
15    create, update and delete from other modules.
16    Its main procedures are as following:
17    Create Resource Group to HR Org mapping
18    Update Resource Group to HR Org mapping
19    Delete Resource Group to HR Org mapping
20    Calls to these procedures will invoke procedures from jtf_rs_group_orgs_pvt
21    to do business validations and to do actual inserts, updates and deletes into
22    tables.
23    ******************************************************************************************/
24 
25 
26   /* Procedure to create the Resource Group to HR Org mapping
27 	based on input values passed by calling routines. */
28 /*#
29  * Create Resource Group to HR Org mapping API
30  * This procedure allows the user to create a Resource Group to HR Org mapping record.
31  * @param p_api_version API version
32  * @param p_init_msg_list Initialization of the message list
33  * @param p_commit Commit
34  * @param p_group_id Group Identifier
35  * @param p_organization_id HR Organization Identifier
36  * @param p_attribute1 Descriptive flexfield Segment 1
37  * @param p_attribute2 Descriptive flexfield Segment 2
38  * @param p_attribute3 Descriptive flexfield Segment 3
39  * @param p_attribute4 Descriptive flexfield Segment 4
40  * @param p_attribute5 Descriptive flexfield Segment 5
41  * @param p_attribute6 Descriptive flexfield Segment 6
42  * @param p_attribute7 Descriptive flexfield Segment 7
43  * @param p_attribute8 Descriptive flexfield Segment 8
44  * @param p_attribute9 Descriptive flexfield Segment 9
45  * @param p_attribute10 Descriptive flexfield Segment 10
46  * @param p_attribute11 Descriptive flexfield Segment 11
47  * @param p_attribute12 Descriptive flexfield Segment 12
48  * @param p_attribute13 Descriptive flexfield Segment 13
49  * @param p_attribute14 Descriptive flexfield Segment 14
50  * @param p_attribute15 Descriptive flexfield Segment 15
51  * @param p_attribute_category Descriptive flexfield structure definition column
52  * @param x_return_status Output parameter for return status
53  * @param x_msg_count Output parameter for number of user messages from this procedure
54  * @param x_msg_data Output parameter containing last user message from this procedure
55  * @rep:scope internal
56  * @rep:lifecycle active
57  * @rep:displayname Create Resource Group to HR Org mapping API
58 */
59   PROCEDURE  create_group_org
60   (P_API_VERSION           IN  NUMBER,
61    P_INIT_MSG_LIST         IN  VARCHAR2   DEFAULT  FND_API.G_FALSE,
62    P_COMMIT                IN  VARCHAR2   DEFAULT  FND_API.G_FALSE,
63    P_GROUP_ID              IN  JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,
64    P_ORGANIZATION_ID       IN  JTF_RS_GROUP_ORGANIZATIONS.ORGANIZATION_ID%TYPE,
65    P_ATTRIBUTE1            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
66    P_ATTRIBUTE2            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
67    P_ATTRIBUTE3            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
68    P_ATTRIBUTE4            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
69    P_ATTRIBUTE5            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
70    P_ATTRIBUTE6            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
71    P_ATTRIBUTE7            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
72    P_ATTRIBUTE8            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
73    P_ATTRIBUTE9            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
74    P_ATTRIBUTE10           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
75    P_ATTRIBUTE11           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
76    P_ATTRIBUTE12           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
77    P_ATTRIBUTE13           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
78    P_ATTRIBUTE14           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
79    P_ATTRIBUTE15           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
80    P_ATTRIBUTE_CATEGORY    IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
81    X_RETURN_STATUS         OUT NOCOPY  	VARCHAR2,
82    X_MSG_COUNT             OUT NOCOPY  	NUMBER,
83    X_MSG_DATA              OUT NOCOPY  	VARCHAR2
84   ) ;
85 
86 
87   /* Procedure to update the Resource Group to HR Org mapping Attributes
88 	based on input values passed by calling routines. */
89 
90 /*#
91  * Update Resource Group to HR Org mapping Attributes API
92  * This procedure allows the user to update a Resource Group to HR Org mapping Attributes of a record.
93  * @param p_api_version API version
94  * @param p_init_msg_list Initialization of the message list
95  * @param p_commit Commit
96  * @param p_group_id Group Identifier
97  * @param p_organization_id HR Organization Identifier
98  * @param p_attribute1 Descriptive flexfield Segment 1
99  * @param p_attribute2 Descriptive flexfield Segment 2
100  * @param p_attribute3 Descriptive flexfield Segment 3
101  * @param p_attribute4 Descriptive flexfield Segment 4
102  * @param p_attribute5 Descriptive flexfield Segment 5
103  * @param p_attribute6 Descriptive flexfield Segment 6
104  * @param p_attribute7 Descriptive flexfield Segment 7
105  * @param p_attribute8 Descriptive flexfield Segment 8
106  * @param p_attribute9 Descriptive flexfield Segment 9
107  * @param p_attribute10 Descriptive flexfield Segment 10
108  * @param p_attribute11 Descriptive flexfield Segment 11
109  * @param p_attribute12 Descriptive flexfield Segment 12
110  * @param p_attribute13 Descriptive flexfield Segment 13
111  * @param p_attribute14 Descriptive flexfield Segment 14
112  * @param p_attribute15 Descriptive flexfield Segment 15
113  * @param p_attribute_category Descriptive flexfield structure definition column
114  * @param p_object_version_number The object version number of the group-org mapping derived from the jtf_rs_group_organizations table.
115  * @param x_return_status Output parameter for return status
116  * @param x_msg_count Output parameter for number of user messages from this procedure
117  * @param x_msg_data Output parameter containing last user message from this procedure
118  * @rep:scope internal
119  * @rep:lifecycle active
120  * @rep:displayname Update Group to HR Org mapping attributes API
121 */
122   PROCEDURE  update_group_org
123   (P_API_VERSION           IN  NUMBER,
124    P_INIT_MSG_LIST         IN  VARCHAR2   DEFAULT  FND_API.G_FALSE,
125    P_COMMIT                IN  VARCHAR2   DEFAULT  FND_API.G_FALSE,
126    P_GROUP_ID              IN  JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,
127    P_ORGANIZATION_ID       IN  JTF_RS_GROUP_ORGANIZATIONS.ORGANIZATION_ID%TYPE,
128    P_ATTRIBUTE1            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
129    P_ATTRIBUTE2            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
130    P_ATTRIBUTE3            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
131    P_ATTRIBUTE4            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
132    P_ATTRIBUTE5            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
133    P_ATTRIBUTE6            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
134    P_ATTRIBUTE7            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
135    P_ATTRIBUTE8            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
136    P_ATTRIBUTE9            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
137    P_ATTRIBUTE10           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
138    P_ATTRIBUTE11           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
139    P_ATTRIBUTE12           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
140    P_ATTRIBUTE13           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
141    P_ATTRIBUTE14           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
142    P_ATTRIBUTE15           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
143    P_ATTRIBUTE_CATEGORY    IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
144    P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_ORGANIZATIONS.OBJECT_VERSION_NUMBER%TYPE,
145    X_RETURN_STATUS         OUT NOCOPY  		VARCHAR2,
146    X_MSG_COUNT             OUT NOCOPY  		NUMBER,
147    X_MSG_DATA              OUT NOCOPY  		VARCHAR2
148   );
149 
150   /* Procedure to delete resource group - HR Org mapping  */
151 
152 /*#
153  * Delete Resource Group to HR Org mapping API
154  * This procedure allows the user to delete a Resource Group to HR Org mapping record.
155  * @param p_api_version API version
156  * @param p_init_msg_list Initialization of the message list
157  * @param p_commit Commit
158  * @param p_group_id Group Identifier
159  * @param p_organization_id HR Organization Identifier
160  * @param p_object_version_number The object version number of the group-org mapping derived from the jtf_rs_group_organizations table.
161  * @param x_return_status Output parameter for return status
162  * @param x_msg_count Output parameter for number of user messages from this procedure
163  * @param x_msg_data Output parameter containing last user message from this procedure
164  * @rep:scope internal
165  * @rep:lifecycle active
166  * @rep:displayname Delete Resource Group to HR Org mapping API
167 */
168 
169   PROCEDURE  delete_group_org
170   (P_API_VERSION            IN  NUMBER,
171    P_INIT_MSG_LIST          IN  VARCHAR2 DEFAULT  FND_API.G_FALSE,
172    P_COMMIT                 IN  VARCHAR2 DEFAULT  FND_API.G_FALSE,
173    P_GROUP_ID               IN  JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,
174    P_ORGANIZATION_ID        IN  JTF_RS_GROUP_ORGANIZATIONS.ORGANIZATION_ID%TYPE,
175    P_OBJECT_VERSION_NUMBER  IN  JTF_RS_GROUP_ORGANIZATIONS.OBJECT_VERSION_NUMBER%TYPE,
176    X_RETURN_STATUS          OUT NOCOPY  VARCHAR2,
177    X_MSG_COUNT              OUT NOCOPY  NUMBER,
178    X_MSG_DATA               OUT NOCOPY  VARCHAR2
179   );
180 
181 END JTF_RS_GROUP_ORGS_PUB;