APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALUES

Line 2309: FROM fnd_flex_values

2305: CURSOR val_cur(p_flex_value_set_id IN NUMBER)
2306: IS
2307: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
2308: ROWID, flex_value
2309: FROM fnd_flex_values
2310: WHERE flex_value_set_id = p_flex_value_set_id
2311: ORDER BY flex_value;
2312:
2313: val_rec val_cur%ROWTYPE;

Line 2339: FROM fnd_flex_values

2335: CURSOR par_cur(p_flex_value_set_id IN NUMBER)
2336: IS
2337: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
2338: ROWID, parent_flex_value_low
2339: FROM fnd_flex_values
2340: WHERE flex_value_set_id IN
2341: (SELECT flex_value_set_id
2342: FROM fnd_flex_value_sets
2343: WHERE parent_flex_value_set_id = p_flex_value_set_id

Line 2497: -- Update fnd_flex_values table.

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

Line 2499: -- Table Vsets in fnd_flex_values table.

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

Line 2512: UPDATE fnd_flex_values

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

Line 2522: 'Failure in UPDATE FND_FLEX_VALUES.',

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

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

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

Line 2652: UPDATE fnd_flex_values

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

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

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

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

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