[Home] [Help]
PACKAGE: APPS.CSC_PROF_MODULE_GROUPS_PUB
Source
1 PACKAGE CSC_PROF_MODULE_GROUPS_PUB AUTHID CURRENT_USER as
2 /* $Header: cscppmgs.pls 115.14 2002/12/09 08:44:47 agaddam ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROF_MODULE_GROUPS_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:PROF_MODULE_GRP_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- ROW_ID
19 -- MODULE_GROUP_ID
20 -- FORM_FUNCTION_ID
21 -- FORM_FUNCTION_NAME
22 -- PARTY_TYPE
23 -- GROUP_ID
24 -- DASHBOARD_GROUP_FLAG
25 -- CURRENCY_CODE
26 -- LAST_UPDATE_DATE
27 -- LAST_UPDATED_BY
28 -- CREATION_DATE
29 -- CREATED_BY
30 -- LAST_UPDATE_LOGIN
31 -- SEEDED_FLAG
32 -- APPLICATION_ID
33 -- DASHBOARD_GROUP_ID
34 --
35 -- Required:
36 -- Defaults:
37 --
38 -- End of Comments
39
40 TYPE PROF_MODULE_GRP_Rec_Type IS RECORD
41 (
42 ROW_ID ROWID,
43 MODULE_GROUP_ID NUMBER,
44 FORM_FUNCTION_ID NUMBER,
45 FORM_FUNCTION_NAME VARCHAR2(30),
46 RESPONSIBILITY_ID NUMBER,
47 RESP_APPL_ID NUMBER,
48 PARTY_TYPE VARCHAR2(30),
49 GROUP_ID NUMBER,
50 DASHBOARD_GROUP_FLAG VARCHAR2(3),
51 CURRENCY_CODE VARCHAR2(15),
52 LAST_UPDATE_DATE DATE,
53 LAST_UPDATED_BY NUMBER,
54 CREATION_DATE DATE,
55 CREATED_BY NUMBER,
56 LAST_UPDATE_LOGIN NUMBER,
57 SEEDED_FLAG VARCHAR2(3),
58 APPLICATION_ID NUMBER,
59 DASHBOARD_GROUP_ID NUMBER
60 );
61
62 G_MISS_PROF_MODULE_GRP_REC PROF_MODULE_GRP_Rec_Type;
63 TYPE PROF_MODULE_GRP_Tbl_Type IS TABLE OF PROF_MODULE_GRP_Rec_Type
64 INDEX BY BINARY_INTEGER;
65 G_MISS_PROF_MODULE_GRP_TBL PROF_MODULE_GRP_Tbl_Type;
66
67 TYPE PROF_MODULE_GRP_sort_rec_type IS RECORD
68 (
69 -- Please define your own sort by record here.
70 MODULE_GROUP_ID NUMBER := NULL
71 );
72
73 -- *******************************************************
74 -- Start of Comments
75 -- *******************************************************
76 -- API Name: Create_prof_module_groups
77 -- Type : Public
78 -- Pre-Req :
79 -- Parameters:
80 -- IN
81 -- p_api_version_number IN NUMBER Required
82 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84 -- P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type Required
85 --
86 -- OUT :
87 -- x_return_status OUT NOCOPY VARCHAR2
88 -- x_msg_count OUT NOCOPY NUMBER
89 -- x_msg_data OUT NOCOPY VARCHAR2
90 --
91 -- End of Comments
92 --
93
94 PROCEDURE Create_prof_module_groups(
95 P_Api_Version_Number IN NUMBER,
96 P_Init_Msg_List IN VARCHAR2,
97 P_Commit IN VARCHAR2,
98 PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
99 p_FORM_FUNCTION_ID NUMBER DEFAULT NULL,
100 p_FORM_FUNCTION_NAME VARCHAR2 DEFAULT NULL,
101 p_RESPONSIBILITY_ID NUMBER DEFAULT NULL,
102 p_RESP_APPL_ID NUMBER DEFAULT NULL,
103 p_PARTY_TYPE VARCHAR2 DEFAULT NULL,
104 p_GROUP_ID NUMBER DEFAULT NULL,
105 p_DASHBOARD_GROUP_FLAG VARCHAR2 DEFAULT NULL,
106 p_CURRENCY_CODE VARCHAR2 DEFAULT NULL,
107 p_LAST_UPDATE_DATE DATE DEFAULT NULL,
108 p_LAST_UPDATED_BY NUMBER DEFAULT NULL,
109 p_CREATION_DATE DATE DEFAULT NULL,
110 p_CREATED_BY NUMBER DEFAULT NULL,
111 p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL,
112 p_SEEDED_FLAG VARCHAR2 DEFAULT NULL,
113 p_APPLICATION_ID NUMBER DEFAULT NULL,
114 p_DASHBOARD_GROUP_ID NUMBER DEFAULT NULL,
115 X_Return_Status OUT NOCOPY VARCHAR2,
116 X_Msg_Count OUT NOCOPY NUMBER,
117 X_Msg_Data OUT NOCOPY VARCHAR2
118 );
119
120
121 PROCEDURE Create_prof_module_groups(
122 P_Api_Version_Number IN NUMBER,
123 P_Init_Msg_List IN VARCHAR2,
124 P_Commit IN VARCHAR2,
125 P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
126 PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
127 X_Return_Status OUT NOCOPY VARCHAR2,
128 X_Msg_Count OUT NOCOPY NUMBER,
129 X_Msg_Data OUT NOCOPY VARCHAR2
130 );
131
132 -- *******************************************************
133 -- Start of Comments
134 -- *******************************************************
135 -- API Name: Update_prof_module_groups
136 -- Type : Public
137 -- Pre-Req :
138 -- Parameters:
139 -- IN
140 -- p_api_version_number IN NUMBER Required
141 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143 -- P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type Required
144 --
145 -- OUT :
146 -- x_return_status OUT NOCOPY VARCHAR2
147 -- x_msg_count OUT NOCOPY NUMBER
148 -- x_msg_data OUT NOCOPY VARCHAR2
149 -- Version : Current version 1.0
150 --
151 -- End of Comments
152 --
153
154 PROCEDURE Update_prof_module_groups(
155 P_Api_Version_Number IN NUMBER,
156 P_Init_Msg_List IN VARCHAR2,
157 P_Commit IN VARCHAR2,
158 P_MODULE_GROUP_ID NUMBER DEFAULT NULL,
159 p_FORM_FUNCTION_ID NUMBER DEFAULT NULL,
160 p_FORM_FUNCTION_NAME VARCHAR2 DEFAULT NULL,
161 p_RESPONSIBILITY_ID NUMBER DEFAULT NULL,
162 p_RESP_APPL_ID NUMBER DEFAULT NULL,
163 p_PARTY_TYPE VARCHAR2 DEFAULT NULL,
164 p_GROUP_ID NUMBER DEFAULT NULL,
165 p_DASHBOARD_GROUP_FLAG VARCHAR2 DEFAULT NULL,
166 p_CURRENCY_CODE VARCHAR2 DEFAULT NULL,
167 p_LAST_UPDATE_DATE DATE DEFAULT NULL,
168 p_LAST_UPDATED_BY NUMBER DEFAULT NULL,
169 p_CREATION_DATE DATE DEFAULT NULL,
170 p_CREATED_BY NUMBER DEFAULT NULL,
171 p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL,
172 p_SEEDED_FLAG VARCHAR2 DEFAULT NULL,
173 p_APPLICATION_ID NUMBER DEFAULT NULL,
174 p_DASHBOARD_GROUP_ID NUMBER DEFAULT NULL,
175 X_Return_Status OUT NOCOPY VARCHAR2,
176 X_Msg_Count OUT NOCOPY NUMBER,
177 X_Msg_Data OUT NOCOPY VARCHAR2
178 );
179
180
181 PROCEDURE Update_prof_module_groups(
182 P_Api_Version_Number IN NUMBER,
183 P_Init_Msg_List IN VARCHAR2,
184 P_Commit IN VARCHAR2,
185 P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
186 X_Return_Status OUT NOCOPY VARCHAR2,
187 X_Msg_Count OUT NOCOPY NUMBER,
188 X_Msg_Data OUT NOCOPY VARCHAR2
189 );
190
191 -- *******************************************************
192 -- Start of Comments
193 -- *******************************************************
194 -- API Name: Delete_prof_module_groups
195 -- Type : Public
196 -- Pre-Req :
197 -- Parameters:
198 -- IN
199 -- p_api_version_number IN NUMBER Required
200 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202 -- P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type Required
203 --
204 -- OUT :
205 -- x_return_status OUT NOCOPY VARCHAR2
206 -- x_msg_count OUT NOCOPY NUMBER
207 -- x_msg_data OUT NOCOPY VARCHAR2
208 -- Version : Current version 1.0
209 --
210 -- End of Comments
211 --
212 PROCEDURE Delete_prof_module_groups(
213 P_Api_Version_Number IN NUMBER,
214 P_Init_Msg_List IN VARCHAR2,
215 P_Commit IN VARCHAR2,
216 P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
217 X_Return_Status OUT NOCOPY VARCHAR2,
218 X_Msg_Count OUT NOCOPY NUMBER,
219 X_Msg_Data OUT NOCOPY VARCHAR2
220 );
221
222
223 End CSC_PROF_MODULE_GROUPS_PUB;