APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 2320: FROM fnd_flex_value_norm_hierarchy

2316: IS
2317: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
2318: ROWID, parent_flex_value,
2319: child_flex_value_low, child_flex_value_high
2320: FROM fnd_flex_value_norm_hierarchy
2321: WHERE flex_value_set_id = p_flex_value_set_id;
2322:
2323: nhier_rec nhier_cur%ROWTYPE;
2324:

Line 2559: UPDATE fnd_flex_value_norm_hierarchy

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

Line 2571: 'Failure in UPDATE FND_FLEX_VALUE_NORM_HIERARCHY.',

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

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

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