1 PACKAGE jtf_rs_dynamic_groups_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspys.pls 120.0 2005/05/11 08:21:31 appldev ship $ */
3 /*#
4 * Package containing procedures to maintain dynamic groups
5 * @rep:scope internal
6 * @rep:product JTF
7 * @rep:displayname Dynamic Groups Package
8 * @rep:category BUSINESS_ENTITY JTF_RS_DYNAMIC_GROUP
9 */
10
11
12 /*****************************************************************************************
13 This is a public API that caller will invoke.
14 It provides PROCEDUREs for managing Dynamic Groups, like
15 create, update and delete Dynamic Groups from other modules.
16 Its main PROCEDUREs are as following:
17 Create Dynamic Groups
18 Update Dynamic Groups
19 Delete Dynamic Groups
20 ******************************************************************************************/
21
22
23 /* PROCEDURE to create the Dynamic Groups
24 based on input values passed by calling routines. */
25
26 /*#
27 * Procedure for creating a dynamic group
28 * @param P_API_VERSION API version number
29 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
30 * @param P_COMMIT Flag to commit at the end of the procedure
31 * @param P_GROUP_NAME Name of the group
32 * @param P_GROUP_DESC Description for the group
33 * @param P_USAGE Usage for the group
34 * @param P_START_DATE_ACTIVE Active From Date
35 * @param P_END_DATE_ACTIVE Active To Date
36 * @param P_SQL_TEXT SQL query for the dynamic group
37 * @param X_RETURN_STATUS Output parameter for return status
38 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
39 * @param X_MSG_DATA Output parameter containing last user message from this procedure
40 * @param X_GROUP_ID Output parameter containing internal unique id for the dynamic group
41 * @param X_GROUP_NUMBER Output parameter containing group number
42 * @rep:scope internal
43 * @rep:displayname Create Dynamic Group
44 */
45 PROCEDURE create_dynamic_groups
46 (P_API_VERSION IN NUMBER,
47 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49 P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
50 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
51 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
52 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
53 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
54 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
55 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56 X_MSG_COUNT OUT NOCOPY NUMBER,
57 X_MSG_DATA OUT NOCOPY VARCHAR2,
58 X_GROUP_ID OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
59 X_GROUP_NUMBER OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE
60 );
61
62
63 /* PROCEDURE to update the Dynamic Groups
64 based on input values passed by calling routines. */
65
66 /*#
67 * Procedure to update a dynamic group
68 * @param P_API_VERSION API version number
69 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
70 * @param P_COMMIT Flag to commit at the end of the procedure
71 * @param P_GROUP_ID internal unique id for the dynamic group
72 * @param P_GROUP_NUMBER dynamic group number
73 * @param P_GROUP_NAME Name of the group
74 * @param P_GROUP_DESC Description for the group
75 * @param P_USAGE Usage for the group
76 * @param P_START_DATE_ACTIVE Active From Date
77 * @param P_END_DATE_ACTIVE Active To Date
78 * @param P_SQL_TEXT SQL query for the dynamic group
79 * @param P_OBJECT_VERSION_NUMBER object version number for the database record
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:displayname Update Dynamic Group
85 */
86 PROCEDURE update_dynamic_groups
87 (P_API_VERSION IN NUMBER,
88 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90 P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
91 P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
92 P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
93 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
94 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
95 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
96 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
97 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
98 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
99 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
100 X_MSG_COUNT OUT NOCOPY NUMBER,
101 X_MSG_DATA OUT NOCOPY VARCHAR2
102 );
103
104
105 /* PROCEDURE to delete the Dynamic Groups. */
106
107 /*#
108 * Procedure to delete a dynamic group
109 * @param P_API_VERSION API version number
110 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
111 * @param P_COMMIT Flag to commit at the end of the procedure
112 * @param P_GROUP_ID internal unique id for the dynamic group
113 * @param P_OBJECT_VERSION_NUMBER object version number for the database record
114 * @param X_RETURN_STATUS Output parameter for return status
115 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
116 * @param X_MSG_DATA Output parameter containing last user message from this procedure
117 * @rep:scope internal
118 * @rep:displayname Delete Dynamic Group
119 */
120 PROCEDURE delete_dynamic_groups
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_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
125 P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.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
132 END jtf_rs_dynamic_groups_pub;