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 282: FROM fnd_flex_value_sets

278: BEGIN
279: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
280: *
281: INTO x_vset_rec
282: FROM fnd_flex_value_sets
283: WHERE flex_value_set_name = p_flex_value_set_name;
284: RETURN(TRUE);
285: EXCEPTION
286: WHEN no_data_found THEN

Line 820: l_minimum_value fnd_flex_value_sets.minimum_value%TYPE;

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

Line 821: l_maximum_value fnd_flex_value_sets.maximum_value%TYPE;

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

Line 822: l_dependant_default_value fnd_flex_value_sets.dependant_default_value%TYPE;

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

Line 823: l_dependant_default_meaning fnd_flex_value_sets.dependant_default_meaning%TYPE;

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

Line 890: FROM fnd_flex_value_sets

886: BEGIN
887: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
888: *
889: INTO l_new_vset_rec
890: FROM fnd_flex_value_sets
891: WHERE flex_value_set_name = p_new_value_set_name;
892: --
893: -- New value set exists check the format and maximum size.
894: --

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

969: END IF;
970: END IF;
971:
972: --
973: -- Clone the row in FND_FLEX_VALUE_SETS table.
974: --
975: BEGIN
976: INSERT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
977: INTO fnd_flex_value_sets

Line 977: INTO fnd_flex_value_sets

973: -- Clone the row in FND_FLEX_VALUE_SETS table.
974: --
975: BEGIN
976: INSERT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
977: INTO fnd_flex_value_sets
978: (flex_value_set_id,
979: flex_value_set_name,
980: validation_type,
981: security_enabled_flag,

Line 1003: fnd_flex_value_sets_s.NEXTVAL,

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

Line 1026: FROM fnd_flex_value_sets

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

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

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

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

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

Line 1810: FROM fnd_flex_value_sets

1806:
1807: CURSOR dep_vset_cur(p_ind_vset_id IN NUMBER) IS
1808: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
1809: *
1810: FROM fnd_flex_value_sets
1811: WHERE validation_type = 'D'
1812: AND parent_flex_value_set_id = p_ind_vset_id;
1813:
1814: PROCEDURE debug_vset_details(p_vset_rec IN vset_rec_type)

Line 2013: UPDATE fnd_flex_value_sets

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

Line 2024: UPDATE fnd_flex_value_sets

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

Line 2344: FROM fnd_flex_value_sets

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

Line 2409: UPDATE fnd_flex_value_sets

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

Line 2422: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',

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

Line 2438: UPDATE fnd_flex_value_sets

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

Line 2454: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',

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

Line 2470: UPDATE fnd_flex_value_sets

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

Line 2486: 'Failure in UPDATE FND_FLEX_VALUE_SETS.',

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

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

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

Line 3113: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

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

Line 3280: ' FROM fnd_flex_value_sets ' ||

3276: IS
3277: l_sql VARCHAR2(1000) :=
3278: ('SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */ ' ||
3279: ' flex_value_set_name ' ||
3280: ' FROM fnd_flex_value_sets ' ||
3281: ' WHERE format_type IN (''X'', ''Y'')');
3282: BEGIN
3283: internal_init;
3284: cp_debug('Upgrading All Standard Date and Standard DateTime Value Sets.');

Line 3313: ' FROM fnd_flex_value_sets ' ||

3309: IS
3310: l_sql VARCHAR2(1000) :=
3311: ('SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */ ' ||
3312: ' flex_value_set_name ' ||
3313: ' FROM fnd_flex_value_sets ' ||
3314: ' WHERE (format_type = ''N'' OR ' ||
3315: ' (format_type = ''C'' AND ' ||
3316: ' alphanumeric_allowed_flag = ''N''))');
3317: BEGIN

Line 3457: fnd_flex_value_sets fvs

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

Line 3505: fnd_flex_value_sets fvs

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