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,
289: LAST_UPDATED_BY,
290: LAST_UPDATE_DATE,
291: LAST_UPDATE_LOGIN,
292: SEEDED_FLAG
293: From CSC_PROF_GROUP_CATEGORIES
294: Where Group_category_id = c_Group_category_id
295: For Update NOWAIT;
296:
297: l_api_name CONSTANT VARCHAR2(30) := 'Update_csc_prof_group_cat';
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: --
669: IS
670: p_Api_Name Varchar2(100) := 'Validate_Category_Code';
671: Cursor C1 is
672: Select Null
673: from csc_prof_Group_categories
674: where group_id = p_GROUP_ID
675: and category_code = p_CATEGORY_CODE;
676: BEGIN
677: