DBA Data[Home] [Help]

APPS.CSC_PROFILE_GROUPS_PVT dependencies on CSC_CORE_UTILS_PVT

Line 72: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

68: -- Parameters:
69: -- IN
70: -- p_api_version_number IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
72: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
73: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
74: -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
75: --
76: -- OUT:

Line 73: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

69: -- IN
70: -- p_api_version_number IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
72: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
73: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
74: -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
75: --
76: -- OUT:
77: -- x_return_status OUT VARCHAR2

Line 88: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

84:
85: PROCEDURE Create_profile_groups(
86: PX_Group_Id IN OUT NOCOPY NUMBER,
87: P_Api_Version_Number IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
89: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
91: P_GROUP_ID IN NUMBER DEFAULT NULL,
92: P_CREATED_BY IN NUMBER,

Line 89: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

85: PROCEDURE Create_profile_groups(
86: PX_Group_Id IN OUT NOCOPY NUMBER,
87: P_Api_Version_Number IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
89: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
91: P_GROUP_ID IN NUMBER DEFAULT NULL,
92: P_CREATED_BY IN NUMBER,
93: P_CREATION_DATE IN DATE,

Line 90: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

86: PX_Group_Id IN OUT NOCOPY NUMBER,
87: P_Api_Version_Number IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
89: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
91: P_GROUP_ID IN NUMBER DEFAULT NULL,
92: P_CREATED_BY IN NUMBER,
93: P_CREATION_DATE IN DATE,
94: P_LAST_UPDATED_BY IN NUMBER,

Line 115: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

111:
112: PROCEDURE Create_profile_groups(
113: PX_Group_Id IN OUT NOCOPY NUMBER,
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
117: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
118: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type := G_MISS_PROF_GROUP_REC,
119: X_Object_Version_Number OUT NOCOPY NUMBER,

Line 116: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

112: PROCEDURE Create_profile_groups(
113: PX_Group_Id IN OUT NOCOPY NUMBER,
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
117: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
118: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type := G_MISS_PROF_GROUP_REC,
119: X_Object_Version_Number OUT NOCOPY NUMBER,
120: X_Return_Status OUT NOCOPY VARCHAR2,

Line 117: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

113: PX_Group_Id IN OUT NOCOPY NUMBER,
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
117: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
118: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type := G_MISS_PROF_GROUP_REC,
119: X_Object_Version_Number OUT NOCOPY NUMBER,
120: X_Return_Status OUT NOCOPY VARCHAR2,
121: X_Msg_Count OUT NOCOPY NUMBER,

Line 135: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

131: -- Parameters:
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
137: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
138: -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
139: --

Line 136: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
137: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
138: -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
139: --
140: -- OUT:

Line 152: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

148:
149:
150: PROCEDURE Update_profile_groups(
151: P_Api_Version_Number IN NUMBER,
152: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
153: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
155: P_GROUP_ID IN NUMBER ,
156: P_CREATED_BY IN NUMBER ,

Line 153: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

149:
150: PROCEDURE Update_profile_groups(
151: P_Api_Version_Number IN NUMBER,
152: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
153: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
155: P_GROUP_ID IN NUMBER ,
156: P_CREATED_BY IN NUMBER ,
157: P_CREATION_DATE IN DATE ,

Line 154: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

150: PROCEDURE Update_profile_groups(
151: P_Api_Version_Number IN NUMBER,
152: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
153: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
155: P_GROUP_ID IN NUMBER ,
156: P_CREATED_BY IN NUMBER ,
157: P_CREATION_DATE IN DATE ,
158: P_LAST_UPDATED_BY IN NUMBER ,

Line 180: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

176:
177:
178: PROCEDURE Update_profile_groups(
179: P_Api_Version_Number IN NUMBER,
180: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
181: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
182: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
183: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
184: PX_Object_Version_Number IN OUT NOCOPY NUMBER,

Line 181: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

177:
178: PROCEDURE Update_profile_groups(
179: P_Api_Version_Number IN NUMBER,
180: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
181: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
182: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
183: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
184: PX_Object_Version_Number IN OUT NOCOPY NUMBER,
185: X_Return_Status OUT NOCOPY VARCHAR2,

Line 182: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

178: PROCEDURE Update_profile_groups(
179: P_Api_Version_Number IN NUMBER,
180: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
181: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
182: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
183: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
184: PX_Object_Version_Number IN OUT NOCOPY NUMBER,
185: X_Return_Status OUT NOCOPY VARCHAR2,
186: X_Msg_Count OUT NOCOPY NUMBER,

Line 200: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

196: -- Parameters:
197: -- IN
198: -- p_api_version_number IN NUMBER Required
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
201: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
202: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
203: -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
204: --

Line 201: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

197: -- IN
198: -- p_api_version_number IN NUMBER Required
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
201: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
202: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
203: -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
204: --
205: -- OUT:

Line 216: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

212: --
213:
214: PROCEDURE Delete_profile_groups(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
217: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
218: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
219: P_GROUP_ID IN NUMBER,
220: P_OBJECT_VERSION_NUMBER IN NUMBER,

Line 217: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

213:
214: PROCEDURE Delete_profile_groups(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
217: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
218: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
219: P_GROUP_ID IN NUMBER,
220: P_OBJECT_VERSION_NUMBER IN NUMBER,
221: X_Return_Status OUT NOCOPY VARCHAR2,

Line 218: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

214: PROCEDURE Delete_profile_groups(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
217: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
218: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
219: P_GROUP_ID IN NUMBER,
220: P_OBJECT_VERSION_NUMBER IN NUMBER,
221: X_Return_Status OUT NOCOPY VARCHAR2,
222: X_Msg_Count OUT NOCOPY NUMBER,

Line 231: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package

227: -- Start of Comments
228: --
229: -- Item level validation procedures
230: --
231: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
232: -- For create: G_CREATE, for update: G_UPDATE
233: --
234: -- End of Comments
235:

Line 238: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

234: -- End of Comments
235:
236: PROCEDURE Validate_GROUP_NAME (
237: P_Api_Name IN VARCHAR2,
238: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
239: P_Validation_mode IN VARCHAR2,
240: P_GROUP_NAME IN VARCHAR2,
241: P_GROUP_ID IN NUMBER,
242: X_Return_Status OUT NOCOPY VARCHAR2,

Line 251: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package

247: -- Start of Comments
248: --
249: -- Item level validation procedures
250: --
251: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
252: -- For create: G_CREATE, for update: G_UPDATE
253: --
254: -- End of Comments
255:

Line 258: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

254: -- End of Comments
255:
256: PROCEDURE Validate_GROUP_NAME_CODE (
257: P_Api_Name IN VARCHAR2,
258: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
259: P_Validation_mode IN VARCHAR2,
260: P_GROUP_NAME_CODE IN VARCHAR2,
261: X_Return_Status OUT NOCOPY VARCHAR2,
262: X_Msg_Count OUT NOCOPY NUMBER,

Line 270: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package

266: -- Start of Comments
267: --
268: -- Item level validation procedures
269: --
270: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
271: -- For create: G_CREATE, for update: G_UPDATE
272: --
273: -- End of Comments
274:

Line 277: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

273: -- End of Comments
274:
275: PROCEDURE Validate_IN_CUST_DASHBOARD (
276: P_Api_Name IN VARCHAR2,
277: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
278: P_Validation_mode IN VARCHAR2,
279: P_USE_IN_CUSTOMER_DASHBOARD IN VARCHAR2,
280: X_Return_Status OUT NOCOPY VARCHAR2,
281: X_Msg_Count OUT NOCOPY NUMBER,

Line 289: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package

285: -- Start of Comments
286: --
287: -- Item level validation procedures
288: --
289: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
290: -- For create: G_CREATE, for update: G_UPDATE
291: --
292: -- End of Comments
293:

Line 296: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

292: -- End of Comments
293:
294: PROCEDURE Validate_SEEDED_FLAG (
295: P_Api_Name IN VARCHAR2,
296: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
297: P_Validation_mode IN VARCHAR2,
298: P_SEEDED_FLAG IN VARCHAR2,
299: X_Return_Status OUT NOCOPY VARCHAR2,
300: X_Msg_Count OUT NOCOPY NUMBER,

Line 309: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package

305: -- Start of Comments
306: --
307: -- validation procedures
308: --
309: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
310: -- For create: G_CREATE, for update: G_UPDATE
311: -- End of Comments
312:
313: PROCEDURE Validate_profile_groups(

Line 314: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

310: -- For create: G_CREATE, for update: G_UPDATE
311: -- End of Comments
312:
313: PROCEDURE Validate_profile_groups(
314: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
315: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
316: P_Validation_mode IN VARCHAR2,
317: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
318: X_Return_Status OUT NOCOPY VARCHAR2,

Line 315: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

311: -- End of Comments
312:
313: PROCEDURE Validate_profile_groups(
314: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
315: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
316: P_Validation_mode IN VARCHAR2,
317: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
318: X_Return_Status OUT NOCOPY VARCHAR2,
319: X_Msg_Count OUT NOCOPY NUMBER,