APPS.ENI_ITEMS_STAR_PKG dependencies on ENI_DENORM_HIERARCHIES

Line 1735: UPDATE eni_denorm_hierarchies B

1731:
1732: -- Bug: 4917496 Added child_id= default_category_id predicate
1733: -- updating Item Assignment flag for all categories,
1734: -- which have items attached to it
1735: UPDATE eni_denorm_hierarchies B
1736: SET
1737: item_assgn_flag = 'Y',
1738: last_update_date = sysdate,
1739: last_updated_by = l_user_id,

Line 1761: UPDATE eni_denorm_hierarchies b

1757: commenting this update as IOI(Item Create) can only result in creation of item assignment
1758: This update statement will always fetch zero rows.
1759:
1760: -- updating Item Assignment flag for all categories, which does not have items attached to it
1761: UPDATE eni_denorm_hierarchies b
1762: SET
1763: item_assgn_flag = 'N',
1764: last_update_date = SYSDATE,
1765: last_updated_by = l_user_id,

Line 1808: UPDATE eni_denorm_hierarchies b

1804: EXCEPTION WHEN NO_DATA_FOUND THEN
1805: l_count := 0;
1806: END;
1807:
1808: UPDATE eni_denorm_hierarchies b
1809: SET
1810: item_assgn_flag = decode(l_count, 0, 'N', 'Y'),
1811: last_update_date = sysdate,
1812: last_updated_by = l_user_id,

Line 1972: UPDATE eni_denorm_hierarchies B

1968: AND transaction_type IN ('CREATE','UPDATE')
1969: AND set_process_id = p_set_process_id
1970: AND category_set_id = l_vbh_category_set_id)
1971: LOOP
1972: UPDATE eni_denorm_hierarchies B
1973: SET
1974: item_assgn_flag = 'Y',
1975: last_update_date = sysdate,
1976: last_updated_by = l_user_id,

Line 2007: UPDATE eni_denorm_hierarchies b

2003: AND set_process_id = p_set_process_id
2004: AND category_set_id = l_vbh_category_set_id)
2005: LOOP
2006:
2007: UPDATE eni_denorm_hierarchies b
2008: SET
2009: item_assgn_flag = 'N',
2010: last_update_date = SYSDATE,
2011: last_updated_by = l_user_id,

Line 2063: UPDATE eni_denorm_hierarchies b

2059: EXCEPTION WHEN NO_DATA_FOUND THEN
2060: l_count := 0;
2061: END;
2062:
2063: UPDATE eni_denorm_hierarchies b
2064: SET
2065: item_assgn_flag = decode(l_count, 0, 'N', 'Y'),
2066: last_update_date = sysdate,
2067: last_updated_by = l_user_id,