APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 2322: FROM fnd_flex_value_norm_hierarchy

2318: IS
2319: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
2320: ROWID, parent_flex_value,
2321: child_flex_value_low, child_flex_value_high
2322: FROM fnd_flex_value_norm_hierarchy
2323: WHERE flex_value_set_id = p_flex_value_set_id;
2324:
2325: nhier_rec nhier_cur%ROWTYPE;
2326:

Line 2561: UPDATE fnd_flex_value_norm_hierarchy

2557: IF (nhier_rec.parent_flex_value <> l_vc2_tmp1 OR
2558: nhier_rec.child_flex_value_low <> l_vc2_tmp2 OR
2559: nhier_rec.child_flex_value_high <> l_vc2_tmp3) THEN
2560: BEGIN
2561: UPDATE fnd_flex_value_norm_hierarchy
2562: SET
2563: parent_flex_value = l_vc2_tmp1,
2564: child_flex_value_low = l_vc2_tmp2,
2565: child_flex_value_high = l_vc2_tmp3,

Line 2573: 'Failure in UPDATE FND_FLEX_VALUE_NORM_HIERARCHY.',

2569: l_upg_count := l_upg_count + SQL%rowcount;
2570: EXCEPTION
2571: WHEN OTHERS THEN
2572: cp_report_error(l_func_name,
2573: 'Failure in UPDATE FND_FLEX_VALUE_NORM_HIERARCHY.',
2574: Sqlerrm);
2575: END;
2576: END IF;
2577: END LOOP;

Line 2579: cp_debug('FND_FLEX_VALUE_NORM_HIERARCHY : Upg/Count : ' ||

2575: END;
2576: END IF;
2577: END LOOP;
2578: IF (l_rows_count > 0) THEN
2579: cp_debug('FND_FLEX_VALUE_NORM_HIERARCHY : Upg/Count : ' ||
2580: l_upg_count || '/' || l_rows_count);
2581: IF (l_upg_count > 0) THEN
2582: COMMIT;
2583: END IF;