eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALUE_SETS

Line 70: SUBTYPE vset_rec_type IS fnd_flex_value_sets%ROWTYPE;

66: last_update_date fnd_id_flexs.last_update_date%TYPE,
67: last_updated_by fnd_id_flexs.last_updated_by%TYPE,
68: last_update_login fnd_id_flexs.last_update_login%TYPE);
69:
70: SUBTYPE vset_rec_type IS fnd_flex_value_sets%ROWTYPE;
71:
72: TYPE cursor_type IS REF CURSOR;
73:
74:

Line 280: FROM fnd_flex_value_sets

276: BEGIN
277: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
278: *
279: INTO x_vset_rec
280: FROM fnd_flex_value_sets
281: WHERE flex_value_set_name = p_flex_value_set_name;
282: RETURN(TRUE);
283: EXCEPTION
284: WHEN no_data_found THEN

Line 818: l_minimum_value fnd_flex_value_sets.minimum_value%TYPE;

814: l_format_type VARCHAR2(1);
815: l_maximum_size NUMBER;
816: l_ret_code NUMBER := g_ret_no_error;
817:
818: l_minimum_value fnd_flex_value_sets.minimum_value%TYPE;
819: l_maximum_value fnd_flex_value_sets.maximum_value%TYPE;
820: l_dependant_default_value fnd_flex_value_sets.dependant_default_value%TYPE;
821: l_dependant_default_meaning fnd_flex_value_sets.dependant_default_meaning%TYPE;
822: l_who_rec who_rec_type;

Line 819: l_maximum_value fnd_flex_value_sets.maximum_value%TYPE;

815: l_maximum_size NUMBER;
816: l_ret_code NUMBER := g_ret_no_error;
817:
818: l_minimum_value fnd_flex_value_sets.minimum_value%TYPE;
819: l_maximum_value fnd_flex_value_sets.maximum_value%TYPE;
820: l_dependant_default_value fnd_flex_value_sets.dependant_default_value%TYPE;
821: l_dependant_default_meaning fnd_flex_value_sets.dependant_default_meaning%TYPE;
822: l_who_rec who_rec_type;
823: l_old_vset_rec vset_rec_type;

Line 820: l_dependant_default_value fnd_flex_value_sets.dependant_default_value%TYPE;

816: l_ret_code NUMBER := g_ret_no_error;
817:
818: l_minimum_value fnd_flex_value_sets.minimum_value%TYPE;
819: l_maximum_value fnd_flex_value_sets.maximum_value%TYPE;
820: l_dependant_default_value fnd_flex_value_sets.dependant_default_value%TYPE;
821: l_dependant_default_meaning fnd_flex_value_sets.dependant_default_meaning%TYPE;
822: l_who_rec who_rec_type;
823: l_old_vset_rec vset_rec_type;
824: l_new_vset_rec vset_rec_type;

Line 821: l_dependant_default_meaning fnd_flex_value_sets.dependant_default_meaning%TYPE;

817:
818: l_minimum_value fnd_flex_value_sets.minimum_value%TYPE;
819: l_maximum_value fnd_flex_value_sets.maximum_value%TYPE;
820: l_dependant_default_value fnd_flex_value_sets.dependant_default_value%TYPE;
821: l_dependant_default_meaning fnd_flex_value_sets.dependant_default_meaning%TYPE;
822: l_who_rec who_rec_type;
823: l_old_vset_rec vset_rec_type;
824: l_new_vset_rec vset_rec_type;
825: l_long VARCHAR2(32000);

Line 888: FROM fnd_flex_value_sets

884: BEGIN
885: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
886: *
887: INTO l_new_vset_rec
888: FROM fnd_flex_value_sets
889: WHERE flex_value_set_name = p_new_value_set_name;
890: --
891: -- New value set exists check the format and maximum size.
892: --

Line 971: -- Clone the row in FND_FLEX_VALUE_SETS table.

967: END IF;
968: END IF;
969:
970: --
971: -- Clone the row in FND_FLEX_VALUE_SETS table.
972: --
973: BEGIN
974: INSERT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
975: INTO fnd_flex_value_sets

Line 975: INTO fnd_flex_value_sets

971: -- Clone the row in FND_FLEX_VALUE_SETS table.
972: --
973: BEGIN
974: INSERT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
975: INTO fnd_flex_value_sets
976: (flex_value_set_id,
977: flex_value_set_name,
978: validation_type,
979: security_enabled_flag,

Line 1001: fnd_flex_value_sets_s.NEXTVAL,

997: dependant_default_value,/* note spelling */
998: dependant_default_meaning,/* note spelling */
999: parent_flex_value_set_id)
1000: SELECT
1001: fnd_flex_value_sets_s.NEXTVAL,
1002: p_new_value_set_name,
1003: validation_type,
1004: security_enabled_flag,
1005: longlist_flag,

Line 1024: FROM fnd_flex_value_sets

1020: l_who_rec.created_by,
1021: l_dependant_default_value,
1022: l_dependant_default_meaning,
1023: parent_flex_value_set_id
1024: FROM fnd_flex_value_sets
1025: WHERE flex_value_set_name = p_old_value_set_name;
1026:
1027: IF (SQL%rowcount = 1) THEN
1028: debug('FND_FLEX_VALUE_SETS entry cloned successfully.');

Line 1028: debug('FND_FLEX_VALUE_SETS entry cloned successfully.');

1024: FROM fnd_flex_value_sets
1025: WHERE flex_value_set_name = p_old_value_set_name;
1026:
1027: IF (SQL%rowcount = 1) THEN
1028: debug('FND_FLEX_VALUE_SETS entry cloned successfully.');
1029: ELSE
1030: report_error(l_func_name,
1031: 'SQL%ROWCOUNT : ' || SQL%rowcount,NULL);
1032: l_ret_code := g_ret_critical_error;

Line 1038: 'INSERT INTO fnd_flex_value_sets failed.', Sqlerrm);

1034: END IF;
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: report_error(l_func_name,
1038: 'INSERT INTO fnd_flex_value_sets failed.', Sqlerrm);
1039: l_ret_code := g_ret_critical_error;
1040: GOTO lbl_return;
1041: END;
1042:

Line 1808: FROM fnd_flex_value_sets

1804:
1805: CURSOR dep_vset_cur(p_ind_vset_id IN NUMBER) IS
1806: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
1807: *
1808: FROM fnd_flex_value_sets
1809: WHERE validation_type = 'D'
1810: AND parent_flex_value_set_id = p_ind_vset_id;
1811:
1812: PROCEDURE debug_vset_details(p_vset_rec IN vset_rec_type)

Line 2011: UPDATE fnd_flex_value_sets

2007: --
2008: -- Now we can upgrade. First upgrade the dependent vsets.
2009: --
2010: FOR dep_vset_rec IN dep_vset_cur(l_ind_vset_rec.flex_value_set_id) LOOP
2011: UPDATE fnd_flex_value_sets
2012: SET
2013: validation_type = 'Y',
2014: last_update_date = l_who_rec.last_update_date,
2015: last_updated_by = l_who_rec.last_updated_by

Line 2022: UPDATE fnd_flex_value_sets

2018:
2019: --
2020: -- Upgrade the independent vset.
2021: --
2022: UPDATE fnd_flex_value_sets
2023: SET
2024: validation_type = 'X',
2025: last_update_date = l_who_rec.last_update_date,
2026: last_updated_by = l_who_rec.last_updated_by

Line 2342: FROM fnd_flex_value_sets

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
2344: AND validation_type = 'D');
2345:
2346: par_rec par_cur%ROWTYPE;

Line 2407: UPDATE fnd_flex_value_sets

2403: vset_rec.maximum_value <> l_vc2_tmp2 OR
2404: vset_rec.dependant_default_value <> l_vc2_tmp3 OR
2405: vset_rec.alphanumeric_allowed_flag <> 'N') THEN
2406: BEGIN
2407: UPDATE fnd_flex_value_sets
2408: SET
2409: alphanumeric_allowed_flag = 'N',
2410: minimum_value = l_vc2_tmp1,
2411: maximum_value = l_vc2_tmp2,

Line 2420: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',

2416: l_upg_count := SQL%rowcount;
2417: EXCEPTION
2418: WHEN OTHERS THEN
2419: cp_report_error(l_func_name,
2420: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',
2421: Sqlerrm);
2422: END;
2423: END IF;
2424: ELSIF (p_mode = g_date_mode) THEN

Line 2436: UPDATE fnd_flex_value_sets

2432: vset_rec.alphanumeric_allowed_flag <> 'Y' OR
2433: vset_rec.uppercase_only_flag <> 'Y' OR
2434: vset_rec.numeric_mode_enabled_flag <> 'N') THEN
2435: BEGIN
2436: UPDATE fnd_flex_value_sets
2437: SET
2438: maximum_size = 11,
2439: alphanumeric_allowed_flag = 'Y',
2440: uppercase_only_flag = 'Y',

Line 2452: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',

2448: l_upg_count := SQL%rowcount;
2449: EXCEPTION
2450: WHEN OTHERS THEN
2451: cp_report_error(l_func_name,
2452: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',
2453: Sqlerrm);
2454: END;
2455: END IF;
2456: ELSIF (p_mode = g_datetime_mode) THEN

Line 2468: UPDATE fnd_flex_value_sets

2464: vset_rec.alphanumeric_allowed_flag <> 'Y' OR
2465: vset_rec.uppercase_only_flag <> 'Y' OR
2466: vset_rec.numeric_mode_enabled_flag <> 'N') THEN
2467: BEGIN
2468: UPDATE fnd_flex_value_sets
2469: SET
2470: maximum_size = 20,
2471: alphanumeric_allowed_flag = 'Y',
2472: uppercase_only_flag = 'Y',

Line 2484: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',

2480: l_upg_count := SQL%rowcount;
2481: EXCEPTION
2482: WHEN OTHERS THEN
2483: cp_report_error(l_func_name,
2484: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',
2485: Sqlerrm);
2486: END;
2487: END IF;
2488: END IF;

Line 2489: cp_debug('FND_FLEX_VALUE_SETS:Upg/Count:'||l_upg_count||'/1');

2485: Sqlerrm);
2486: END;
2487: END IF;
2488: END IF;
2489: cp_debug('FND_FLEX_VALUE_SETS:Upg/Count:'||l_upg_count||'/1');
2490: IF (l_upg_count > 0) THEN
2491: COMMIT;
2492: END IF;
2493:

Line 3111: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

3107: p_sub_program IN VARCHAR2,
3108: p_sub_description IN VARCHAR2,
3109: p_sql_select IN VARCHAR2)
3110: IS
3111: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3112: l_request_id NUMBER;
3113: l_sub_request_id NUMBER;
3114: l_request_count NUMBER;
3115: i NUMBER;

Line 3278: ' FROM fnd_flex_value_sets ' ||

3274: IS
3275: l_sql VARCHAR2(1000) :=
3276: ('SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */ ' ||
3277: ' flex_value_set_name ' ||
3278: ' FROM fnd_flex_value_sets ' ||
3279: ' WHERE format_type IN (''X'', ''Y'')');
3280: BEGIN
3281: internal_init;
3282: cp_debug('Upgrading All Standard Date and Standard DateTime Value Sets.');

Line 3311: ' FROM fnd_flex_value_sets ' ||

3307: IS
3308: l_sql VARCHAR2(1000) :=
3309: ('SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */ ' ||
3310: ' flex_value_set_name ' ||
3311: ' FROM fnd_flex_value_sets ' ||
3312: ' WHERE (format_type = ''N'' OR ' ||
3313: ' (format_type = ''C'' AND ' ||
3314: ' alphanumeric_allowed_flag = ''N''))');
3315: BEGIN

Line 3455: fnd_flex_value_sets fvs

3451:
3452: FROM fnd_descr_flex_col_usage_vl dfcu, fnd_descr_flex_contexts_vl dfc,
3453: fnd_descriptive_flexs_vl df, fnd_application_vl fa,
3454: fnd_lookups fl1, fnd_lookups fl2, fnd_lookups fl3,
3455: fnd_flex_value_sets fvs
3456: WHERE df.application_id = fa.application_id
3457: AND dfc.application_id = df.application_id
3458: AND dfc.descriptive_flexfield_name = df.descriptive_flexfield_name
3459: AND dfc.enabled_flag = fl1.lookup_code

Line 3503: fnd_flex_value_sets fvs

3499:
3500: FROM fnd_id_flex_segments_vl ifsg, fnd_id_flex_structures_vl ifst,
3501: fnd_id_flexs idf, fnd_application_vl fa,
3502: fnd_lookups fl1, fnd_lookups fl2, fnd_lookups fl3,
3503: fnd_flex_value_sets fvs
3504: WHERE idf.application_id = fa.application_id
3505: AND ifst.application_id = idf.application_id
3506: AND ifst.id_flex_code = idf.id_flex_code
3507: AND ifst.enabled_flag = fl1.lookup_code