APPS.MTL_ITEM_CATALOG_GROUPS_UTIL dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 10: INSERT INTO MTL_ITEM_CATALOG_GROUPS_B (

6:
7: l_return_status VARCHAR2(1); --Bug 4639946
8: BEGIN
9:
10: INSERT INTO MTL_ITEM_CATALOG_GROUPS_B (
11: PARENT_CATALOG_GROUP_ID,
12: ITEM_CREATION_ALLOWED_FLAG,
13: ITEM_CATALOG_GROUP_ID,
14: INACTIVE_DATE,

Line 205: FROM MTL_ITEM_CATALOG_GROUPS_B

201: ATTRIBUTE13,
202: ATTRIBUTE14,
203: ATTRIBUTE15,
204: REQUEST_ID
205: FROM MTL_ITEM_CATALOG_GROUPS_B
206: WHERE ITEM_CATALOG_GROUP_ID = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID
207: FOR UPDATE OF ITEM_CATALOG_GROUP_ID NOWAIT;
208:
209:

Line 352: From MTL_ITEM_CATALOG_GROUPS_B

348: BEGIN
349:
350: --Bug: 4639946
351: Select PARENT_CATALOG_GROUP_ID into l_old_parent_id
352: From MTL_ITEM_CATALOG_GROUPS_B
353: WHERE ITEM_CATALOG_GROUP_ID = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID;
354:
355: IF (SQL%NOTFOUND) THEN
356: RAISE no_data_found;

Line 359: UPDATE MTL_ITEM_CATALOG_GROUPS_B

355: IF (SQL%NOTFOUND) THEN
356: RAISE no_data_found;
357: END IF;
358:
359: UPDATE MTL_ITEM_CATALOG_GROUPS_B
360: SET
361: PARENT_CATALOG_GROUP_ID = P_Catalog_Group_Rec.PARENT_CATALOG_GROUP_ID,
362: ITEM_CREATION_ALLOWED_FLAG = NVL(P_Catalog_Group_Rec.ITEM_CREATION_ALLOWED_FLAG,ITEM_CREATION_ALLOWED_FLAG),
363: INACTIVE_DATE = P_Catalog_Group_Rec.INACTIVE_DATE,

Line 457: DELETE FROM MTL_ITEM_CATALOG_GROUPS_B

453: IF (SQL%NOTFOUND) THEN
454: RAISE no_data_found;
455: END IF;
456:
457: DELETE FROM MTL_ITEM_CATALOG_GROUPS_B
458: WHERE ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID;
459:
460: IF (SQL%NOTFOUND) THEN
461: RAISE no_data_found;

Line 471: FROM MTL_ITEM_CATALOG_GROUPS_B B

467: BEGIN
468:
469: DELETE FROM MTL_ITEM_CATALOG_GROUPS_TL T
470: WHERE NOT EXISTS (SELECT NULL
471: FROM MTL_ITEM_CATALOG_GROUPS_B B
472: WHERE B.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID);
473:
474: UPDATE MTL_ITEM_CATALOG_GROUPS_TL T
475: SET (DESCRIPTION) = (SELECT B.DESCRIPTION