eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_GROUP_CHECKS_PVT dependencies on CSC_CORE_UTILS_PVT

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

70: -- Parameters:
71: -- IN
72: -- p_api_version_number IN NUMBER Required
73: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
74: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
75: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
76: -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
77: --
78: -- OUT:

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

71: -- IN
72: -- p_api_version_number IN NUMBER Required
73: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
74: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
75: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
76: -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
77: --
78: -- OUT:
79: -- x_return_status OUT VARCHAR2

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

85: --
86:
87: PROCEDURE Create_group_checks(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_GROUP_ID IN NUMBER ,
93: P_CHECK_ID IN NUMBER ,

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

86:
87: PROCEDURE Create_group_checks(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_GROUP_ID IN NUMBER ,
93: P_CHECK_ID IN NUMBER ,
94: P_END_DATE_ACTIVE IN DATE ,

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

87: PROCEDURE Create_group_checks(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_GROUP_ID IN NUMBER ,
93: P_CHECK_ID IN NUMBER ,
94: P_END_DATE_ACTIVE IN DATE ,
95: P_START_DATE_ACTIVE IN DATE ,

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

111:
112:
113: PROCEDURE Create_group_checks(
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_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
119: -- X_Check_Sequence OUT NOCOPY NUMBER,

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

112:
113: PROCEDURE Create_group_checks(
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_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
119: -- X_Check_Sequence 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: PROCEDURE Create_group_checks(
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_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
119: -- X_Check_Sequence 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_GROUP_CHK_Rec IN GROUP_CHK_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_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
139: --
140: -- OUT:

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

146: -- End of Comments
147: --
148: PROCEDURE Update_group_checks(
149: P_Api_Version_Number IN NUMBER,
150: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
151: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
152: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
153: P_GROUP_ID IN NUMBER,
154: P_CHECK_ID IN NUMBER,

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

147: --
148: PROCEDURE Update_group_checks(
149: P_Api_Version_Number IN NUMBER,
150: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
151: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
152: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
153: P_GROUP_ID IN NUMBER,
154: P_CHECK_ID IN NUMBER,
155: P_CHECK_SEQUENCE IN NUMBER,

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

148: PROCEDURE Update_group_checks(
149: P_Api_Version_Number IN NUMBER,
150: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
151: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
152: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
153: P_GROUP_ID IN NUMBER,
154: P_CHECK_ID IN NUMBER,
155: P_CHECK_SEQUENCE IN NUMBER,
156: P_END_DATE_ACTIVE IN DATE,

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

172:
173:
174: PROCEDURE Update_group_checks(
175: P_Api_Version_Number IN NUMBER,
176: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
177: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
178: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
179: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
180: X_Return_Status OUT NOCOPY VARCHAR2,

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

173:
174: PROCEDURE Update_group_checks(
175: P_Api_Version_Number IN NUMBER,
176: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
177: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
178: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
179: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
180: X_Return_Status OUT NOCOPY VARCHAR2,
181: X_Msg_Count OUT NOCOPY NUMBER,

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

174: PROCEDURE Update_group_checks(
175: P_Api_Version_Number IN NUMBER,
176: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
177: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
178: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
179: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
180: X_Return_Status OUT NOCOPY VARCHAR2,
181: X_Msg_Count OUT NOCOPY NUMBER,
182: X_Msg_Data OUT NOCOPY VARCHAR2

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

191: -- Parameters:
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
197: -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
198: --
199: -- OUT:

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

192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
197: -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
198: --
199: -- OUT:
200: -- x_return_status OUT VARCHAR2

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

205: -- End of Comments
206: --
207: PROCEDURE Delete_group_checks(
208: P_Api_Version_Number IN NUMBER,
209: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
210: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
211: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
212: P_GROUP_ID IN NUMBER,
213: P_CHECK_ID IN NUMBER,

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

206: --
207: PROCEDURE Delete_group_checks(
208: P_Api_Version_Number IN NUMBER,
209: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
210: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
211: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
212: P_GROUP_ID IN NUMBER,
213: P_CHECK_ID IN NUMBER,
214: P_CHECK_SEQUENCE IN NUMBER,

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

207: PROCEDURE Delete_group_checks(
208: P_Api_Version_Number IN NUMBER,
209: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
210: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
211: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
212: P_GROUP_ID IN NUMBER,
213: P_CHECK_ID IN NUMBER,
214: P_CHECK_SEQUENCE IN NUMBER,
215: X_Return_Status OUT NOCOPY VARCHAR2,

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

220: -- Start of Comments
221: --
222: -- Item level validation procedures
223: --
224: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
225: -- For create: G_CREATE, for update: G_UPDATE
226: --
227: -- End of Commens
228:

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

227: -- End of Commens
228:
229: PROCEDURE Validate_GROUP_ID (
230: P_Api_Name IN VARCHAR2,
231: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
232: P_Validation_mode IN VARCHAR2,
233: P_GROUP_ID IN NUMBER,
234: X_Return_Status OUT NOCOPY VARCHAR2,
235: X_Msg_Count OUT NOCOPY NUMBER,

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

244: -- End of Comments
245:
246: PROCEDURE Validate_CHECK_ID (
247: P_Api_Name IN VARCHAR2,
248: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
249: P_Validation_mode IN VARCHAR2,
250: P_CHECK_ID IN NUMBER,
251: X_Return_Status OUT NOCOPY VARCHAR2,
252: X_Msg_Count OUT NOCOPY NUMBER,

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

256: -- Start of Comments
257: --
258: -- Item level validation procedures
259: --
260: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
261: -- For create: G_CREATE, for update: G_UPDATE
262: --
263: -- End of Comments
264:

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

263: -- End of Comments
264:
265: PROCEDURE Validate_CHECK_SEQUENCE (
266: P_Api_Name IN VARCHAR2,
267: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
268: P_Validation_mode IN VARCHAR2,
269: P_CHECK_SEQUENCE IN NUMBER,
270: X_Return_Status OUT NOCOPY VARCHAR2,
271: X_Msg_Count OUT NOCOPY NUMBER,

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

276: -- Start of Comments
277: --
278: -- Item level validation procedures
279: --
280: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
281: -- For create: G_CREATE, for update: G_UPDATE
282: --
283: -- End of Comments
284:

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

283: -- End of Comments
284:
285: PROCEDURE Validate_CATEGORY_CODE (
286: P_Api_Name IN VARCHAR2,
287: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
288: P_Validation_mode IN VARCHAR2,
289: P_CATEGORY_CODE IN VARCHAR2,
290: X_Return_Status OUT NOCOPY VARCHAR2,
291: X_Msg_Count OUT NOCOPY NUMBER,

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

295: -- Start of Comments
296: --
297: -- Item level validation procedures
298: --
299: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
300: -- For create: G_CREATE, for update: G_UPDATE
301: --
302: -- End of Comments
303:

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

302: -- End of Comments
303:
304: PROCEDURE Validate_CATEGORY_SEQUENCE (
305: P_Api_Name IN VARCHAR2,
306: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307: P_Validation_mode IN VARCHAR2,
308: P_CHECK_ID IN NUMBER,
309: P_CATEGORY_SEQUENCE IN NUMBER,
310: X_Return_Status OUT NOCOPY VARCHAR2,

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

315: -- Start of Comments
316: --
317: -- Item level validation procedures
318: --
319: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
320: -- For create: G_CREATE, for update: G_UPDATE
321: --
322: -- End of Comments
323:

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

322: -- End of Comments
323:
324: PROCEDURE Validate_THRESHOLD_FLAG (
325: P_Api_Name IN VARCHAR2,
326: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
327: P_Validation_mode IN VARCHAR2,
328: P_THRESHOLD_FLAG IN VARCHAR2,
329: X_Return_Status OUT NOCOPY VARCHAR2,
330: X_Msg_Count OUT NOCOPY NUMBER,

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

335: -- Start of Comments
336: --
337: -- validation procedures
338: --
339: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
340: -- For create: G_CREATE, for update: G_UPDATE
341: -- End of Comments
342:
343: PROCEDURE Validate_group_checks(

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

340: -- For create: G_CREATE, for update: G_UPDATE
341: -- End of Comments
342:
343: PROCEDURE Validate_group_checks(
344: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
345: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
346: P_Validation_mode IN VARCHAR2,
347: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
348: X_Return_Status OUT NOCOPY VARCHAR2,

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

341: -- End of Comments
342:
343: PROCEDURE Validate_group_checks(
344: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
345: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
346: P_Validation_mode IN VARCHAR2,
347: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
348: X_Return_Status OUT NOCOPY VARCHAR2,
349: X_Msg_Count OUT NOCOPY NUMBER,