[Home] [Help]
PACKAGE: APPS.CSC_PROFILE_GROUPS_PUB
Source
1 PACKAGE CSC_PROFILE_GROUPS_PUB AUTHID CURRENT_USER as
2 /* $Header: cscppgrs.pls 115.9 2002/11/29 05:16:50 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROFILE_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_GROUP_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- GROUP_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- GROUP_NAME
25 -- GROUP_NAME_CODE
26 -- DESCRIPTION
27 -- START_DATE_ACTIVE
28 -- END_DATE_ACTIVE
29 -- USE_IN_CUSTOMER_DASHBOARD
30 -- CUSTOMER_TYPE_FLAG
31 -- APPLICATION_ID
32 --
33 --
34 -- End of Comments
35
36 TYPE PROF_GROUP_Rec_Type IS RECORD
37 (
38 GROUP_ID NUMBER,
39 CREATED_BY NUMBER,
40 CREATION_DATE DATE,
41 LAST_UPDATED_BY NUMBER,
42 LAST_UPDATE_DATE DATE,
43 LAST_UPDATE_LOGIN NUMBER,
44 GROUP_NAME VARCHAR2(240),
45 GROUP_NAME_CODE VARCHAR2(240),
46 DESCRIPTION VARCHAR2(720),
47 PARTY_TYPE VARCHAR2(30),
48 START_DATE_ACTIVE DATE,
49 END_DATE_ACTIVE DATE,
50 USE_IN_CUSTOMER_DASHBOARD VARCHAR2(3),
51 CUSTOMER_TYPE_FLAG VARCHAR2(3),
52 SEEDED_FLAG VARCHAR2(3),
53 OBJECT_VERSION_NUMBER NUMBER,
54 APPLICATION_ID NUMBER
55 );
56
57 G_MISS_PROF_GROUP_REC PROF_GROUP_Rec_Type;
58
59 TYPE PROF_GROUP_Tbl_Type IS TABLE OF PROF_GROUP_Rec_Type
60 INDEX BY BINARY_INTEGER;
61
62 G_MISS_PROF_GROUP_TBL CSC_PROFILE_GROUPS_PVT.PROF_GROUP_Tbl_Type;
63
64 TYPE PROF_GROUP_sort_rec_type IS RECORD
65 (
66 -- Please define your own sort by record here.
67 CREATED_BY NUMBER := NULL
68 );
69
70 -- *******************************************************
71 -- Start of Comments
72 -- *******************************************************
73 -- API Name: Create_profile_groups
74 -- Type : Public
75 -- Pre-Req :
76 -- Parameters:
77 -- IN
78 -- p_api_version_number IN NUMBER Required
79 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
81 -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
82 --
83 -- OUT :
84 -- x_return_status OUT NOCOPY VARCHAR2
85 -- x_msg_count OUT NOCOPY NUMBER
86 -- x_msg_data OUT NOCOPY VARCHAR2
87 -- Version : Current version 1.0
88 --
89 -- End of Comments
90 --
91
92 PROCEDURE Create_profile_groups(
93 PX_Group_Id IN OUT NOCOPY NUMBER,
94 P_Api_Version_Number IN NUMBER,
95 P_Init_Msg_List IN VARCHAR2,
96 P_Commit IN VARCHAR2,
97 P_GROUP_ID IN NUMBER DEFAULT NULL,
98 P_CREATED_BY IN NUMBER DEFAULT NULL,
99 P_CREATION_DATE IN DATE DEFAULT NULL,
100 P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
101 P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
102 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
103 P_GROUP_NAME IN VARCHAR2 DEFAULT NULL,
104 P_GROUP_NAME_CODE IN VARCHAR2 DEFAULT NULL,
105 P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
106 P_PARTY_TYPE IN VARCHAR2 DEFAULT NULL,
107 P_START_DATE_ACTIVE IN DATE DEFAULT NULL,
108 P_END_DATE_ACTIVE IN DATE DEFAULT NULL,
109 P_USE_IN_CUSTOMER_DASHBOARD IN VARCHAR2 DEFAULT NULL,
110 P_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
111 X_Object_Version_Number OUT NOCOPY NUMBER,
112 P_APPLICATION_ID IN NUMBER DEFAULT NULL,
113 X_Return_Status OUT NOCOPY VARCHAR2,
114 X_Msg_Count OUT NOCOPY NUMBER,
115 X_Msg_Data OUT NOCOPY VARCHAR2
116 );
117
118 PROCEDURE Create_profile_groups(
119 P_Api_Version_Number IN NUMBER,
120 P_Init_Msg_List IN VARCHAR2,
121 P_Commit IN VARCHAR2,
122 P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
123 PX_GROUP_ID IN OUT NOCOPY NUMBER,
124 X_Object_Version_Number OUT NOCOPY NUMBER,
125 X_Return_Status OUT NOCOPY VARCHAR2,
126 X_Msg_Count OUT NOCOPY NUMBER,
127 X_Msg_Data OUT NOCOPY VARCHAR2
128 );
129
130 -- *******************************************************
131 -- Start of Comments
132 -- *******************************************************
133 -- API Name: Update_profile_groups
134 -- Type : Public
135 -- Pre-Req :
136 -- Parameters:
137 -- IN
138 -- p_api_version_number IN NUMBER Required
139 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
141 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
142 -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
143 --
144 -- OUT :
145 -- x_return_status OUT NOCOPY VARCHAR2
146 -- x_msg_count OUT NOCOPY NUMBER
147 -- x_msg_data OUT NOCOPY VARCHAR2
148 -- Version : Current version 1.0
149 --
150 -- End of Comments
151 --
152
153 PROCEDURE Update_profile_groups(
154 P_Api_Version_Number IN NUMBER,
155 P_Init_Msg_List IN VARCHAR2,
156 P_Commit IN VARCHAR2,
157 P_GROUP_ID IN NUMBER DEFAULT NULL,
158 P_CREATED_BY IN NUMBER DEFAULT NULL,
159 P_CREATION_DATE IN DATE DEFAULT NULL,
160 P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
161 P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
162 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
163 P_GROUP_NAME IN VARCHAR2 DEFAULT NULL,
164 P_GROUP_NAME_CODE IN VARCHAR2 DEFAULT NULL,
165 P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
166 P_PARTY_TYPE IN VARCHAR2 DEFAULT NULL,
167 P_START_DATE_ACTIVE IN DATE DEFAULT NULL,
168 P_END_DATE_ACTIVE IN DATE DEFAULT NULL,
169 P_USE_IN_CUSTOMER_DASHBOARD IN VARCHAR2 DEFAULT NULL,
170 P_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
171 PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
172 P_APPLICATION_ID IN NUMBER DEFAULT NULL,
173 X_Return_Status OUT NOCOPY VARCHAR2,
174 X_Msg_Count OUT NOCOPY NUMBER,
175 X_Msg_Data OUT NOCOPY VARCHAR2
176 );
177
178 PROCEDURE Update_profile_groups(
179 P_Api_Version_Number IN NUMBER,
180 P_Init_Msg_List IN VARCHAR2,
181 P_Commit IN VARCHAR2,
182 P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
183 PX_Object_Version_Number IN OUT NOCOPY NUMBER,
184 X_Return_Status OUT NOCOPY VARCHAR2,
185 X_Msg_Count OUT NOCOPY NUMBER,
186 X_Msg_Data OUT NOCOPY VARCHAR2
187 );
188
189 -- *******************************************************
190 -- Start of Comments
191 -- *******************************************************
192 -- API Name: Delete_profile_groups
193 -- Type : Public
194 -- Pre-Req :
195 -- Parameters:
196 -- IN
197 -- p_api_version_number IN NUMBER Required
198 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
200 -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
201 --
202 -- OUT :
203 -- x_return_status OUT NOCOPY VARCHAR2
204 -- x_msg_count OUT NOCOPY NUMBER
205 -- x_msg_data OUT NOCOPY VARCHAR2
206 -- Version : Current version 1.0
207 --
208 -- End of Comments
209 --
210 PROCEDURE Delete_profile_groups(
211 P_Api_Version_Number IN NUMBER,
212 P_Init_Msg_List IN VARCHAR2,
213 P_Commit IN VARCHAR2,
214 P_GROUP_Id IN NUMBER,
215 P_OBJECT_VERSION_NUMBER IN NUMBER,
216 X_Return_Status OUT NOCOPY VARCHAR2,
217 X_Msg_Count OUT NOCOPY NUMBER,
218 X_Msg_Data OUT NOCOPY VARCHAR2
219 );
220
221
222 End CSC_PROFILE_GROUPS_PUB;