1 PACKAGE jtf_rs_group_relate_pub AS
2 /* $Header: jtfrspfs.pls 120.0 2005/05/11 08:21:08 appldev ship $ */
3 /*#
4 * Group Relation create, update and delete API
5 * This API contains the procedures to insert, update and delete Group relation record.
6 * @rep:scope internal
7 * @rep:product JTF
8 * @rep:displayname Group Relations API
9 * @rep:category BUSINESS_ENTITY JTF_RS_GROUP_RELATION
10 */
11
12 /*****************************************************************************************
13 This is a public API that caller will invoke.
14 It provides procedures for managing resource group relations, like
15 create, update and delete resource group relations from other modules.
16 Its main procedures are as following:
17 Create Resource Group Relate
18 Update Resource Group Relate
19 Delete Resource Group Relate
20 Calls to these procedures will invoke procedures from jtf_rs_group_relate_pvt
21 to do business validations and to do actual inserts, updates and deletes into tables.
22 ******************************************************************************************/
23
24
25 /* Procedure to create the resource group relation
26 based on input values passed by calling routines. */
27 /*#
28 * Create Group Relations API
29 * This procedure allows the user to create group relations record.
30 * @param p_api_version API version
31 * @param p_init_msg_list Initialization of the message list
32 * @param p_commit Commit
33 * @param p_group_id Group Identifier
34 * @param p_group_number Group Number
35 * @param p_related_group_id Related Group Identifier
36 * @param p_related_group_number Related Group Number
37 * @param p_relation_type Relation Type
38 * @param p_start_date_active Date on which the group relation becomes active.
39 * @param p_end_date_active Date on which the group relation is no longer active.
40 * @param x_return_status Output parameter for return status
41 * @param x_msg_count Output parameter for number of user messages from this procedure
42 * @param x_msg_data Output parameter containing last user message from this procedure
43 * @param x_group_relate_id Out parameter for Group Relations Identifier
44 * @rep:scope internal
45 * @rep:lifecycle active
46 * @rep:displayname Create Group Relations API
47 */
48 PROCEDURE create_resource_group_relate
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_GROUPS_B.GROUP_ID%TYPE,
53 P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
54 P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
55 P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
56 P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%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_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE
63 );
64
65
66 /* Procedure to update the resource group relation
67 based on input values passed by calling routines. */
68 /*#
69 * Update Group Relations API
70 * This procedure allows the user to update group relations record.
71 * @param p_api_version API version
72 * @param p_init_msg_list Initialization of the message list
73 * @param p_commit Commit
74 * @param p_group_relate_id Group Relation Identifier
75 * @param p_start_date_active Date on which the group relation becomes active.
76 * @param p_end_date_active Date on which the group relation is no longer active.
77 * @param p_object_version_num The object version number of the group relation derives from the jtf_rs_grp_relations table.
78 * @param x_return_status Output parameter for return status
79 * @param x_msg_count Output parameter for number of user messages from this procedure
80 * @param x_msg_data Output parameter containing last user message from this procedure
81 * @rep:scope internal
82 * @rep:lifecycle active
83 * @rep:displayname Update Group Relations API
84 */
85 PROCEDURE update_resource_group_relate
86 (P_API_VERSION IN NUMBER,
87 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
90 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
91 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
92 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.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 relation. */
100
101 /*#
102 * Delete Group Relations API
103 * This procedure allows the user to delete group relations record.
104 * @param p_api_version API version
105 * @param p_init_msg_list Initialization of the message list
106 * @param p_commit Commit
107 * @param p_group_relate_id Group Relation Identifier
108 * @param p_object_version_num The object version number of the group relation derives from the jtf_rs_grp_relations table.
109 * @param x_return_status Output parameter for return status
110 * @param x_msg_count Output parameter for number of user messages from this procedure
111 * @param x_msg_data Output parameter containing last user message from this procedure
112 * @rep:scope internal
113 * @rep:lifecycle active
114 * @rep:displayname Delete Group Relations API
115 */
116 PROCEDURE delete_resource_group_relate
117 (P_API_VERSION IN NUMBER,
118 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
119 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
120 P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
121 P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
122 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
123 X_MSG_COUNT OUT NOCOPY NUMBER,
124 X_MSG_DATA OUT NOCOPY VARCHAR2
125 );
126
127 END jtf_rs_group_relate_pub;
[Home] [Help]