APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 2332: FROM fnd_flex_value_hierarchies

2328: IS
2329: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
2330: ROWID, parent_flex_value,
2331: child_flex_value_low, child_flex_value_high
2332: FROM fnd_flex_value_hierarchies
2333: WHERE flex_value_set_id = p_flex_value_set_id;
2334:
2335: hier_rec hier_cur%ROWTYPE;
2336:

Line 2610: UPDATE fnd_flex_value_hierarchies

2606: IF (hier_rec.parent_flex_value <> l_vc2_tmp1 OR
2607: hier_rec.child_flex_value_low <> l_vc2_tmp2 OR
2608: hier_rec.child_flex_value_high <> l_vc2_tmp3) THEN
2609: BEGIN
2610: UPDATE fnd_flex_value_hierarchies
2611: SET
2612: parent_flex_value = l_vc2_tmp1,
2613: child_flex_value_low = l_vc2_tmp2,
2614: child_flex_value_high = l_vc2_tmp3,

Line 2622: 'Failure in UPDATE FND_FLEX_VALUE_HIERARCHIES.',

2618: l_upg_count := l_upg_count + SQL%rowcount;
2619: EXCEPTION
2620: WHEN OTHERS THEN
2621: cp_report_error(l_func_name,
2622: 'Failure in UPDATE FND_FLEX_VALUE_HIERARCHIES.',
2623: Sqlerrm);
2624: END;
2625: END IF;
2626: END LOOP;

Line 2628: cp_debug('FND_FLEX_VALUE_HIERARCHIES : Upg/Count : ' ||

2624: END;
2625: END IF;
2626: END LOOP;
2627: IF (l_rows_count > 0) THEN
2628: cp_debug('FND_FLEX_VALUE_HIERARCHIES : Upg/Count : ' ||
2629: l_upg_count || '/' || l_rows_count);
2630: IF (l_upg_count > 0) THEN
2631: COMMIT;
2632: END IF;