APPS.ENI_UPD_ASSGN dependencies on ENI_DENORM_HIERARCHIES

Line 20: UPDATE ENI_DENORM_HIERARCHIES B

16: BEGIN
17:
18: -- Updating Item Assignment flag to 'Y' for new_category_id
19: -- Bug# 3045649, added WHO columns in update statements
20: UPDATE ENI_DENORM_HIERARCHIES B
21: SET ITEM_ASSGN_FLAG = 'Y',
22: LAST_UPDATE_DATE = SYSDATE,
23: LAST_UPDATED_BY = l_user_id,
24: LAST_UPDATE_LOGIN = l_user_id

Line 34: UPDATE ENI_DENORM_HIERARCHIES B

30: l_rows_updated := SQL%ROWCOUNT;
31:
32: -- Updating Item Assignment to 'N' for old_category_id, if there are no more items assigned to it
33: -- Bug# 3045649, added WHO columns in update statements
34: UPDATE ENI_DENORM_HIERARCHIES B
35: SET ITEM_ASSGN_FLAG = 'N',
36: LAST_UPDATE_DATE = SYSDATE,
37: LAST_UPDATED_BY = l_user_id,
38: LAST_UPDATE_LOGIN = l_user_id

Line 83: UPDATE ENI_DENORM_HIERARCHIES B

79: EXCEPTION WHEN NO_DATA_FOUND THEN
80: l_count := 0;
81: END;
82:
83: UPDATE ENI_DENORM_HIERARCHIES B
84: SET
85: ITEM_ASSGN_FLAG = DECODE(l_count, 0, 'N', 'Y'),
86: LAST_UPDATE_DATE = SYSDATE,
87: LAST_UPDATED_BY = l_user_id,