[Home] [Help]
1915:
1916: -- Bug: 4917496 Added child_id= default_category_id predicate
1917: -- updating Item Assignment flag for all categories,
1918: -- which have items attached to it
1919: UPDATE eni_denorm_hierarchies B
1920: SET
1921: item_assgn_flag = 'Y',
1922: last_update_date = sysdate,
1923: last_updated_by = l_user_id,
1941: commenting this update as IOI(Item Create) can only result in creation of item assignment
1942: This update statement will always fetch zero rows.
1943:
1944: -- updating Item Assignment flag for all categories, which does not have items attached to it
1945: UPDATE eni_denorm_hierarchies b
1946: SET
1947: item_assgn_flag = 'N',
1948: last_update_date = SYSDATE,
1949: last_updated_by = l_user_id,
1988: EXCEPTION WHEN NO_DATA_FOUND THEN
1989: l_count := 0;
1990: END;
1991:
1992: UPDATE eni_denorm_hierarchies b
1993: SET
1994: item_assgn_flag = decode(l_count, 0, 'N', 'Y'),
1995: last_update_date = sysdate,
1996: last_updated_by = l_user_id,
2152: AND transaction_type IN ('CREATE','UPDATE')
2153: AND set_process_id = p_set_process_id
2154: AND category_set_id = l_vbh_category_set_id)
2155: LOOP
2156: UPDATE eni_denorm_hierarchies B
2157: SET
2158: item_assgn_flag = 'Y',
2159: last_update_date = sysdate,
2160: last_updated_by = l_user_id,
2187: AND set_process_id = p_set_process_id
2188: AND category_set_id = l_vbh_category_set_id)
2189: LOOP
2190:
2191: UPDATE eni_denorm_hierarchies b
2192: SET
2193: item_assgn_flag = 'N',
2194: last_update_date = SYSDATE,
2195: last_updated_by = l_user_id,
2243: EXCEPTION WHEN NO_DATA_FOUND THEN
2244: l_count := 0;
2245: END;
2246:
2247: UPDATE eni_denorm_hierarchies b
2248: SET
2249: item_assgn_flag = decode(l_count, 0, 'N', 'Y'),
2250: last_update_date = sysdate,
2251: last_updated_by = l_user_id,