APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 2330: FROM fnd_flex_value_hierarchies

2326: IS
2327: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
2328: ROWID, parent_flex_value,
2329: child_flex_value_low, child_flex_value_high
2330: FROM fnd_flex_value_hierarchies
2331: WHERE flex_value_set_id = p_flex_value_set_id;
2332:
2333: hier_rec hier_cur%ROWTYPE;
2334:

Line 2608: UPDATE fnd_flex_value_hierarchies

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

Line 2620: 'Failure in UPDATE FND_FLEX_VALUE_HIERARCHIES.',

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

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

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