APPS.CSC_GROUP_CHECKS_PVT dependencies on CSC_PROF_GROUP_CHECKS

Line 175: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Insert_Row)

171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174:
175: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Insert_Row)
176: CSC_PROF_GROUP_CHECKS_PKG.Insert_Row(
177: p_GROUP_ID => p_GROUP_CHK_rec.GROUP_ID,
178: p_CHECK_ID => p_GROUP_CHK_rec.CHECK_ID,
179: P_CHECK_SEQUENCE => p_GROUP_CHK_rec.CHECK_SEQUENCE,

Line 176: CSC_PROF_GROUP_CHECKS_PKG.Insert_Row(

172: END IF;
173:
174:
175: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Insert_Row)
176: CSC_PROF_GROUP_CHECKS_PKG.Insert_Row(
177: p_GROUP_ID => p_GROUP_CHK_rec.GROUP_ID,
178: p_CHECK_ID => p_GROUP_CHK_rec.CHECK_ID,
179: P_CHECK_SEQUENCE => p_GROUP_CHK_rec.CHECK_SEQUENCE,
180: p_END_DATE_ACTIVE => p_GROUP_CHK_rec.END_DATE_ACTIVE,

Line 334: From CSC_PROF_GROUP_CHECKS

330: CREATION_DATE,
331: LAST_UPDATED_BY,
332: LAST_UPDATE_DATE,
333: LAST_UPDATE_LOGIN
334: From CSC_PROF_GROUP_CHECKS
335: Where GROUP_ID = c_GROUP_ID
336: And CHECK_ID = c_CHECK_ID
337: For Update NOWAIT;
338:

Line 398: --FND_MESSAGE.Set_Token ('INFO', 'CSC_PROF_GROUP_CHECKS', FALSE);

394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_api_name=>l_api_name);
397: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
398: --FND_MESSAGE.Set_Token ('INFO', 'CSC_PROF_GROUP_CHECKS', FALSE);
399: --FND_MSG_PUB.Add;
400: END IF;
401: raise FND_API.G_EXC_ERROR;
402: END IF;

Line 421: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)

417:
418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)
422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),

Line 422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(

418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)
422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),

Line 527: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Delete_Row)

523: --
524: -- Api body
525: --
526:
527: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Delete_Row)
528: CSC_PROF_GROUP_CHECKS_PKG.Delete_Row(
529: p_GROUP_ID => p_GROUP_ID,
530: P_CHECK_ID => P_CHECK_ID,
531: p_CHECK_SEQUENCE => p_CHECK_SEQUENCE );

Line 528: CSC_PROF_GROUP_CHECKS_PKG.Delete_Row(

524: -- Api body
525: --
526:
527: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Delete_Row)
528: CSC_PROF_GROUP_CHECKS_PKG.Delete_Row(
529: p_GROUP_ID => p_GROUP_ID,
530: P_CHECK_ID => P_CHECK_ID,
531: p_CHECK_SEQUENCE => p_CHECK_SEQUENCE );
532: --

Line 851: FROM csc_prof_group_Checks

847: X_Msg_Data OUT NOCOPY VARCHAR2
848: )
849: IS
850: CURSOR C1 IS SELECT NULL
851: FROM csc_prof_group_Checks
852: WHERE check_id = p_CHECK_ID
853: AND category_sequence = p_CATEGORY_SEQUENCE;
854: l_dummy number;
855: BEGIN

Line 1006: p_api_name =>'CSC_PROF_GROUP_CHECKS_PVT.VALIDATE_SEEDED_FLAG',

1002: raise FND_API.G_EXC_ERROR;
1003: END IF;
1004:
1005: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
1006: p_api_name =>'CSC_PROF_GROUP_CHECKS_PVT.VALIDATE_SEEDED_FLAG',
1007: p_seeded_flag => P_GROUP_CHK_Rec.seeded_flag,
1008: x_return_status => x_return_status );
1009:
1010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN