APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALUES

Line 2311: FROM fnd_flex_values

2307: CURSOR val_cur(p_flex_value_set_id IN NUMBER)
2308: IS
2309: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
2310: ROWID, flex_value
2311: FROM fnd_flex_values
2312: WHERE flex_value_set_id = p_flex_value_set_id
2313: ORDER BY flex_value;
2314:
2315: val_rec val_cur%ROWTYPE;

Line 2341: FROM fnd_flex_values

2337: CURSOR par_cur(p_flex_value_set_id IN NUMBER)
2338: IS
2339: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
2340: ROWID, parent_flex_value_low
2341: FROM fnd_flex_values
2342: WHERE flex_value_set_id IN
2343: (SELECT flex_value_set_id
2344: FROM fnd_flex_value_sets
2345: WHERE parent_flex_value_set_id = p_flex_value_set_id

Line 2499: -- Update fnd_flex_values table.

2495:
2496:
2497: IF (vset_rec.validation_type IN ('I','D','F')) THEN
2498: --
2499: -- Update fnd_flex_values table.
2500: -- Vset must be Ind, Dep, or Table (We store parent values of
2501: -- Table Vsets in fnd_flex_values table.
2502: --
2503: l_rows_count := 0;

Line 2501: -- Table Vsets in fnd_flex_values table.

2497: IF (vset_rec.validation_type IN ('I','D','F')) THEN
2498: --
2499: -- Update fnd_flex_values table.
2500: -- Vset must be Ind, Dep, or Table (We store parent values of
2501: -- Table Vsets in fnd_flex_values table.
2502: --
2503: l_rows_count := 0;
2504: l_upg_count := 0;
2505: FOR val_rec IN val_cur(vset_rec.flex_value_set_id) LOOP

Line 2514: UPDATE fnd_flex_values

2510: val_rec.flex_value || ': ' || l_error);
2511: END IF;
2512: IF (val_rec.flex_value <> l_vc2_tmp1) THEN
2513: BEGIN
2514: UPDATE fnd_flex_values
2515: SET
2516: flex_value = l_vc2_tmp1,
2517: last_update_date = p_who_rec.last_update_date,
2518: last_updated_by = p_who_rec.last_updated_by

Line 2524: 'Failure in UPDATE FND_FLEX_VALUES.',

2520: l_upg_count := l_upg_count + SQL%rowcount;
2521: EXCEPTION
2522: WHEN OTHERS THEN
2523: cp_report_error(l_func_name,
2524: 'Failure in UPDATE FND_FLEX_VALUES.',
2525: Sqlerrm);
2526: END;
2527: END IF;
2528: END LOOP;

Line 2530: cp_debug('FND_FLEX_VALUES : Upg/Count : ' ||

2526: END;
2527: END IF;
2528: END LOOP;
2529: IF (l_rows_count > 0) THEN
2530: cp_debug('FND_FLEX_VALUES : Upg/Count : ' ||
2531: l_upg_count || '/' || l_rows_count);
2532: IF (l_upg_count > 0) THEN
2533: COMMIT;
2534: END IF;

Line 2654: UPDATE fnd_flex_values

2650: par_rec.parent_flex_value_low || ': ' || l_error);
2651: END IF;
2652: IF (par_rec.parent_flex_value_low <> l_vc2_tmp1) THEN
2653: BEGIN
2654: UPDATE fnd_flex_values
2655: SET
2656: parent_flex_value_low = l_vc2_tmp1,
2657: last_update_date = p_who_rec.last_update_date,
2658: last_updated_by = p_who_rec.last_updated_by

Line 2664: 'Failure in UPDATE PARENT FND_FLEX_VALUES.',

2660: l_upg_count := l_upg_count + SQL%rowcount;
2661: EXCEPTION
2662: WHEN OTHERS THEN
2663: cp_report_error(l_func_name,
2664: 'Failure in UPDATE PARENT FND_FLEX_VALUES.',
2665: Sqlerrm);
2666: END;
2667: END IF;
2668: END LOOP;

Line 2670: cp_debug('PARENT FND_FLEX_VALUES : Upg/Count : ' ||

2666: END;
2667: END IF;
2668: END LOOP;
2669: IF (l_rows_count > 0) THEN
2670: cp_debug('PARENT FND_FLEX_VALUES : Upg/Count : ' ||
2671: l_upg_count || '/' || l_rows_count);
2672: IF (l_upg_count > 0) THEN
2673: COMMIT;
2674: END IF;