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.EGO_EXT_FWK_PUB dependencies on FND_FLEX_VALUE_SETS

Line 343: l_return_value fnd_flex_value_sets.validation_type%TYPE;

339: ---------------------------------------------------------------------
340: FUNCTION get_vs_validation_type (p_value_set_id IN NUMBER
341: ,p_value_set_name IN VARCHAR2
342: ) RETURN VARCHAR2 IS
343: l_return_value fnd_flex_value_sets.validation_type%TYPE;
344: BEGIN
345: l_return_value := NULL;
346: IF p_value_set_id IS NOT NULL THEN
347: SELECT validation_type

Line 349: FROM fnd_flex_value_sets

345: l_return_value := NULL;
346: IF p_value_set_id IS NOT NULL THEN
347: SELECT validation_type
348: INTO l_return_value
349: FROM fnd_flex_value_sets
350: WHERE flex_value_set_id = p_value_set_id;
351: ELSIF p_value_set_name IS NOT NULL THEN
352: SELECT validation_type
353: INTO l_return_value

Line 354: FROM fnd_flex_value_sets

350: WHERE flex_value_set_id = p_value_set_id;
351: ELSIF p_value_set_name IS NOT NULL THEN
352: SELECT validation_type
353: INTO l_return_value
354: FROM fnd_flex_value_sets
355: WHERE flex_value_set_name = p_value_set_name;
356: END IF;
357: RETURN l_return_value;
358: EXCEPTION

Line 572: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

568: l_value_set_id FND_FLEX_VALUES.flex_value_set_id%TYPE;
569: l_Sysdate DATE;
570: l_rowid VARCHAR2(100);
571:
572: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
573: l_storage_value VARCHAR2(32767);
574: l_msg_count NUMBER;
575: l_msg_data VARCHAR2(32767);
576: l_owner NUMBER;

Line 608: FROM fnd_flex_value_sets

604: -- IF l_validation_type = G_TRANS_IND_VALIDATION_CODE THEN
605: l_Sysdate := SYSDATE;
606: SELECT flex_value_set_id
607: INTO l_value_set_id
608: FROM fnd_flex_value_sets
609: WHERE flex_value_set_name = p_value_set_name;
610:
611: IF p_transaction_type = 'CREATE' THEN
612: -- create an translatable independent value set

Line 5114: FROM FND_FLEX_VALUE_SETS

5110: BEGIN
5111:
5112: SELECT FORMAT_TYPE
5113: INTO l_value_set_format_code
5114: FROM FND_FLEX_VALUE_SETS
5115: WHERE FLEX_VALUE_SET_ID = p_value_set_id;
5116:
5117: IF (l_value_set_format_code IS NULL OR
5118: (l_value_set_format_code <> p_data_type)) THEN

Line 6210: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;

6206:
6207: -- l_add_where_clause VARCHAR2(1000);
6208: l_owner NUMBER;
6209: l_maximum_size NUMBER;
6210: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6211: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
6212: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6213: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6214: -- l_Sysdate DATE := Sysdate;

Line 6212: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;

6208: l_owner NUMBER;
6209: l_maximum_size NUMBER;
6210: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6211: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
6212: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6213: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6214: -- l_Sysdate DATE := Sysdate;
6215:
6216: l_owner_name VARCHAR2(40):='ANONYMOUS';

Line 6213: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;

6209: l_maximum_size NUMBER;
6210: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6211: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
6212: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6213: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6214: -- l_Sysdate DATE := Sysdate;
6215:
6216: l_owner_name VARCHAR2(40):='ANONYMOUS';
6217: BEGIN

Line 6324: UPDATE fnd_flex_value_sets

6320: ,min_value => l_minimum_value
6321: ,max_value => l_maximum_value
6322: );
6323: IF l_validation_code = G_TRANS_IND_VALIDATION_CODE THEN
6324: UPDATE fnd_flex_value_sets
6325: SET validation_type = l_validation_code
6326: WHERE flex_value_set_name = p_value_set_name;
6327: END IF;
6328: ELSIF (l_validation_code = G_TABLE_VALIDATION_CODE) THEN

Line 6349: UPDATE fnd_flex_value_sets

6345: ,RIGHT_JUSTIFY_ZERO_FILL => 'N'
6346: ,MIN_VALUE => l_minimum_value
6347: ,MAX_VALUE => l_maximum_value
6348: );
6349: UPDATE fnd_flex_value_sets
6350: SET validation_type = l_validation_code
6351: WHERE flex_value_set_name = p_value_set_name;
6352: END IF;*/
6353: --Bug No:5292701

Line 6414: FROM fnd_flex_value_sets

6410: --Bug No:5292701 :END
6411:
6412: SELECT flex_value_set_id
6413: INTO x_value_set_id
6414: FROM fnd_flex_value_sets
6415: WHERE flex_value_set_name = p_value_set_name;
6416:
6417: -- Standard check of p_commit
6418: IF FND_API.To_Boolean(p_commit) THEN

Line 6770: -- Delete from fnd_flex_value_sets --

6766: IS
6767: BEGIN
6768:
6769: ----------------------------------------------------------------------------
6770: -- Delete from fnd_flex_value_sets --
6771: ----------------------------------------------------------------------------
6772: delete from FND_FLEX_VALUE_SETS where flex_value_set_id = p_child_vs_id;
6773:
6774:

Line 6772: delete from FND_FLEX_VALUE_SETS where flex_value_set_id = p_child_vs_id;

6768:
6769: ----------------------------------------------------------------------------
6770: -- Delete from fnd_flex_value_sets --
6771: ----------------------------------------------------------------------------
6772: delete from FND_FLEX_VALUE_SETS where flex_value_set_id = p_child_vs_id;
6773:
6774:
6775: ----------------------------------------------------------------------------
6776: -- Delete from EGO_VALUE_SET_EXT --

Line 6796: ,p_long_list_flag IN FND_FLEX_VALUE_SETS.LONGLIST_FLAG%TYPE

6792: ,p_format_code IN VARCHAR2
6793: ,p_maximum_size IN NUMBER
6794: ,p_maximum_value IN VARCHAR2
6795: ,p_minimum_value IN VARCHAR2
6796: ,p_long_list_flag IN FND_FLEX_VALUE_SETS.LONGLIST_FLAG%TYPE
6797: -- VARCHAR2
6798: ,p_validation_code IN VARCHAR2
6799: ,p_owner IN NUMBER DEFAULT NULL
6800: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

Line 6819: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;

6815: l_Sysdate DATE;
6816: l_OPDXcheck_dummy VARCHAR(2);
6817: l_owner NUMBER;
6818:
6819: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6820: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6821: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6822:
6823: l_value_set_rec EGO_VALUE_SETS_V%ROWTYPE;

Line 6820: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;

6816: l_OPDXcheck_dummy VARCHAR(2);
6817: l_owner NUMBER;
6818:
6819: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6820: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6821: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6822:
6823: l_value_set_rec EGO_VALUE_SETS_V%ROWTYPE;
6824: BEGIN

Line 6821: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;

6817: l_owner NUMBER;
6818:
6819: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6820: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6821: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6822:
6823: l_value_set_rec EGO_VALUE_SETS_V%ROWTYPE;
6824: BEGIN
6825:

Line 6885: UPDATE FND_FLEX_VALUE_SETS

6881: END IF;
6882:
6883: -- API not available in FND for updation
6884: -- logged bug 3957430 against FND
6885: UPDATE FND_FLEX_VALUE_SETS
6886: SET DESCRIPTION = p_description,
6887: LONGLIST_FLAG = p_long_list_flag,
6888: MINIMUM_VALUE = l_minimum_value,
6889: MAXIMUM_VALUE = l_maximum_value,

Line 6921: -- UPDATE fnd_flex_value_sets

6917: -- BULK COLLECT INTO child_value_set_ids;
6918: --
6919: -- we cannot use it in a SQL Update statement like this:
6920: --
6921: -- UPDATE fnd_flex_value_sets
6922: -- SET longlist_flag = p_long_list_flag
6923: -- WHERE flex_value_set_id IN TABLE (child_value_set_ids);
6924: --
6925: -- because the collection's data type

Line 6940: UPDATE fnd_flex_value_sets

6936: WHERE parent_value_set_id = p_value_set_id)
6937: LOOP
6938:
6939: -- Update the long list display type
6940: UPDATE fnd_flex_value_sets
6941: SET longlist_flag = p_long_list_flag
6942: WHERE flex_value_set_id = l_value_set_rec.value_set_id;
6943:
6944: -- dbms_output.put_line(' ' || l_value_set_rec.value_set_id);

Line 7828: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

7824: ,x_msg_data OUT NOCOPY VARCHAR2
7825: ) IS
7826: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
7827: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
7828: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
7829:
7830: l_vsv_row fnd_flex_values%ROWTYPE;
7831: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
7832:

Line 7849: FROM FND_FLEX_VALUE_SETS vs

7845:
7846: BEGIN
7847: SELECT vs.flex_value_set_id, vs.validation_type
7848: INTO l_value_set_id, l_validation_type
7849: FROM FND_FLEX_VALUE_SETS vs
7850: WHERE vs.flex_value_set_name = p_value_set_name;
7851:
7852: IF l_validation_type = G_TRANS_IND_VALIDATION_CODE THEN
7853:

Line 7988: l_vs_row fnd_flex_value_sets%ROWTYPE;

7984: RETURN VARCHAR2 IS
7985: -- T is VS is editable
7986: -- F if VS is not editable.
7987: l_return_status VARCHAR2(1);
7988: l_vs_row fnd_flex_value_sets%ROWTYPE;
7989: BEGIN
7990: l_return_status := FND_API.G_TRUE;
7991: SELECT *
7992: INTO l_vs_row

Line 7993: FROM fnd_flex_value_sets

7989: BEGIN
7990: l_return_status := FND_API.G_TRUE;
7991: SELECT *
7992: INTO l_vs_row
7993: FROM fnd_flex_value_sets
7994: WHERE flex_value_set_id = cp_value_set_id;
7995:
7996: IF l_vs_row.created_by IN (1,2)
7997: OR

Line 8039: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;

8035: l_return_status VARCHAR2(1);
8036:
8037: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8038: l_vs_created_by fnd_flex_values.created_by%TYPE;
8039: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8042: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8043: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;

Line 8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;

8036:
8037: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8038: l_vs_created_by fnd_flex_values.created_by%TYPE;
8039: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8042: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8043: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8044: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;

Line 8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

8037: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8038: l_vs_created_by fnd_flex_values.created_by%TYPE;
8039: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8042: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8043: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8044: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;
8045:

Line 8042: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;

8038: l_vs_created_by fnd_flex_values.created_by%TYPE;
8039: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8042: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8043: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8044: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;
8045:
8046: BEGIN

Line 8043: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;

8039: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8042: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8043: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8044: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;
8045:
8046: BEGIN
8047:

Line 8044: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;

8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8042: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8043: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8044: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;
8045:
8046: BEGIN
8047:
8048: l_return_status := FND_API.G_TRUE;

Line 8055: FROM fnd_flex_values a, fnd_flex_value_sets b

8051: b.numeric_mode_enabled_flag, b.security_enabled_flag, b.created_by
8052: INTO l_vsv_created_by, l_vs_format_type, l_vs_validation_type,
8053: l_vs_alpha_numeric_allowed, l_vs_uppercase_only,
8054: l_vs_numeric_mode_enabled, l_vs_security_enabled, l_vs_created_by
8055: FROM fnd_flex_values a, fnd_flex_value_sets b
8056: WHERE a.flex_value_id = cp_vs_value_id
8057: AND a.flex_value_set_id = b.flex_value_set_id;
8058:
8059: IF l_vsv_created_by IN (1,2)

Line 8127: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

8123:
8124: l_api_name VARCHAR2(30);
8125: l_api_version NUMBER;
8126: l_value_set_value_id fnd_flex_values.flex_value_id%TYPE;
8127: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
8128: l_sequence EGO_VS_VALUES_DISP_ORDER.disp_sequence%TYPE;
8129: l_invalid_params BOOLEAN;
8130: l_create_sequence BOOLEAN;
8131: l_update_sequence BOOLEAN;

Line 8197: FROM fnd_flex_values a, fnd_flex_value_sets b

8193: ELSE
8194: BEGIN
8195: SELECT a.flex_value_id, a.flex_value_set_id
8196: INTO l_value_set_value_id, l_value_set_id
8197: FROM fnd_flex_values a, fnd_flex_value_sets b
8198: WHERE a.flex_value_set_id = b.flex_value_set_id
8199: AND a.flex_value = p_value_set_value
8200: AND (b.flex_value_set_id = p_value_set_id OR b.flex_value_set_name = p_value_set_name);
8201: EXCEPTION