157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160:
161: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Insert_Row)
162: CSC_PROF_GROUP_CATEGORIES_PKG.Insert_Row(
163: px_GROUP_CATEGORY_ID => px_GROUP_CATEGORY_ID,
164: p_GROUP_ID => p_PROF_GRP_CAT_rec.GROUP_ID,
165: p_CATEGORY_CODE => p_PROF_GRP_CAT_rec.CATEGORY_CODE,
158: END IF;
159:
160:
161: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Insert_Row)
162: CSC_PROF_GROUP_CATEGORIES_PKG.Insert_Row(
163: px_GROUP_CATEGORY_ID => px_GROUP_CATEGORY_ID,
164: p_GROUP_ID => p_PROF_GRP_CAT_rec.GROUP_ID,
165: p_CATEGORY_CODE => p_PROF_GRP_CAT_rec.CATEGORY_CODE,
166: p_CATEGORY_SEQUENCE => p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373:
374: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row)
375: CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row(
376: p_GROUP_CATEGORY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID,l_old_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID),
377: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_ID,l_old_PROF_GRP_CAT_rec.GROUP_ID),
378: p_CATEGORY_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),
371: END IF;
372:
373:
374: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row)
375: CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row(
376: p_GROUP_CATEGORY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID,l_old_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID),
377: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_ID,l_old_PROF_GRP_CAT_rec.GROUP_ID),
378: p_CATEGORY_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),
379: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),
463: --
464: -- Api body
465: --
466:
467: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Delete_Row)
468: CSC_PROF_GROUP_CATEGORIES_PKG.Delete_Row(
469: p_GROUP_CATEGORY_ID => p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID);
470: --
471: -- End of API body
464: -- Api body
465: --
466:
467: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Delete_Row)
468: CSC_PROF_GROUP_CATEGORIES_PKG.Delete_Row(
469: p_GROUP_CATEGORY_ID => p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID);
470: --
471: -- End of API body
472: --