1 PACKAGE jtf_rs_role_relate_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspls.pls 120.0 2005/05/11 08:21:14 appldev ship $ */
3 /*#
4 * Role Relation create, update and delete API
5 * This API contains the procedures to insert, update and delete role relation record.
6 * @rep:scope internal
7 * @rep:product JTF
8 * @rep:displayname Role Relations API
9 * @rep:category BUSINESS_ENTITY JTF_RS_ROLE_RELATION
10 * @rep:businessevent oracle.apps.jtf.jres.rolerelate.create
11 * @rep:businessevent oracle.apps.jtf.jres.rolerelate.update
12 * @rep:businessevent oracle.apps.jtf.jres.rolerelate.delete
13 */
14
15 /*****************************************************************************************
16 This is a public API that caller will invoke.
17 It provides procedures for managing resource roles, like
18 create, update and delete resource roles from other modules.
19 Its main procedures are as following:
20 Create Resource Role Relate
21 Update Resource Role Relate
22 Delete Resource Role Relate
23 Calls to these procedures will invoke procedures from jtf_rs_role_relate_pvt
24 to do business validations and to do actual inserts, updates and deletes into tables.
25 ******************************************************************************************/
26
27
28 /* Procedure to create the resource roles
29 based on input values passed by calling routines. */
30 /*#
31 * Create Role Relations API
32 * This procedure allows the user to create role relations record.
33 * @param p_api_version API version
34 * @param p_init_msg_list Initialization of the message list
35 * @param p_commit Commit
36 * @param p_role_id Role Identifier
37 * @param p_role_code Role Code
38 * @param p_role_resource_id Role Resource Identifier. This can be Resource, group, team, group member or team member Identifier.
39 * @param p_role_resource_type Type of the Resource. This can be Resource, group, team, group member or team member.
40 * @param p_start_date_active Date on which the role relation becomes active.
41 * @param p_end_date_active Date on which the role relation is no longer active.
42 * @param x_return_status Output parameter for return status
43 * @param x_msg_count Output parameter for number of user messages from this procedure
44 * @param x_msg_data Output parameter containing last user message from this procedure
45 * @param x_role_relate_id Out parameter for role relation Identifier
46 * @rep:scope internal
47 * @rep:lifecycle active
48 * @rep:displayname Create Role Relations API
49 * @rep:businessevent oracle.apps.jtf.jres.rolerelate.create
50 */
51 PROCEDURE create_resource_role_relate
52 (P_API_VERSION IN NUMBER,
53 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
56 P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
57 P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
58 P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
59 P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE ,
60 P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
61 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62 X_MSG_COUNT OUT NOCOPY NUMBER,
63 X_MSG_DATA OUT NOCOPY VARCHAR2,
64 X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE
65 );
66
67
68 /* Procedure to update the resource roles
69 based on input values passed by calling routines. */
70 /*#
71 * Update Role Relations API
72 * This procedure allows the user to update role relations record.
73 * @param p_api_version API version
74 * @param p_init_msg_list Initialization of the message list
75 * @param p_commit Commit
76 * @param p_role_relate_id Role Relation Identifier
77 * @param p_start_date_active Date on which the role relation becomes active.
78 * @param p_end_date_active Date on which the role relation is no longer active.
79 * @param p_object_version_num The object version number of the role relation derives from the jtf_rs_role_relations table.
80 * @param x_return_status Output parameter for return status
81 * @param x_msg_count Output parameter for number of user messages from this procedure
82 * @param x_msg_data Output parameter containing last user message from this procedure
83 * @rep:scope internal
84 * @rep:lifecycle active
85 * @rep:displayname Update Role Relations API
86 * @rep:businessevent oracle.apps.jtf.jres.rolerelate.update
87 */
88 PROCEDURE update_resource_role_relate
89 (P_API_VERSION IN NUMBER,
90 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92 P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93 P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94 P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
95 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
96 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
97 X_MSG_COUNT OUT NOCOPY NUMBER,
98 X_MSG_DATA OUT NOCOPY VARCHAR2
99 );
100
101
102 /* Procedure to delete the resource roles. */
103
104 /*#
105 * Delete Role Relations API
106 * This procedure allows the user to delete role relations record.
107 * @param p_api_version API version
108 * @param p_init_msg_list Initialization of the message list
109 * @param p_commit Commit
110 * @param p_role_relate_id Role Relation Identifier
111 * @param p_object_version_num The object version number of the role relation derives from the jtf_rs_role_relations table.
112 * @param x_return_status Output parameter for return status
113 * @param x_msg_count Output parameter for number of user messages from this procedure
114 * @param x_msg_data Output parameter containing last user message from this procedure
115 * @rep:scope internal
116 * @rep:lifecycle active
117 * @rep:displayname Delete Role Relations API
118 * @rep:businessevent oracle.apps.jtf.jres.rolerelate.delete
119 */
120 PROCEDURE delete_resource_role_relate
121 (P_API_VERSION IN NUMBER,
122 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124 P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
125 P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
126 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
127 X_MSG_COUNT OUT NOCOPY NUMBER,
128 X_MSG_DATA OUT NOCOPY VARCHAR2
129 );
130
131 END jtf_rs_role_relate_pub;