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 379: l_return_value fnd_flex_value_sets.validation_type%TYPE;

375: ---------------------------------------------------------------------
376: FUNCTION get_vs_validation_type (p_value_set_id IN NUMBER
377: ,p_value_set_name IN VARCHAR2
378: ) RETURN VARCHAR2 IS
379: l_return_value fnd_flex_value_sets.validation_type%TYPE;
380: BEGIN
381: l_return_value := NULL;
382: IF p_value_set_id IS NOT NULL THEN
383: SELECT validation_type

Line 385: FROM fnd_flex_value_sets

381: l_return_value := NULL;
382: IF p_value_set_id IS NOT NULL THEN
383: SELECT validation_type
384: INTO l_return_value
385: FROM fnd_flex_value_sets
386: WHERE flex_value_set_id = p_value_set_id;
387: ELSIF p_value_set_name IS NOT NULL THEN
388: SELECT validation_type
389: INTO l_return_value

Line 390: FROM fnd_flex_value_sets

386: WHERE flex_value_set_id = p_value_set_id;
387: ELSIF p_value_set_name IS NOT NULL THEN
388: SELECT validation_type
389: INTO l_return_value
390: FROM fnd_flex_value_sets
391: WHERE flex_value_set_name = p_value_set_name;
392: END IF;
393: RETURN l_return_value;
394: EXCEPTION

Line 608: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

604: l_value_set_id FND_FLEX_VALUES.flex_value_set_id%TYPE;
605: l_Sysdate DATE;
606: l_rowid VARCHAR2(100);
607:
608: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
609: l_storage_value VARCHAR2(32767);
610: l_msg_count NUMBER;
611: l_msg_data VARCHAR2(32767);
612: l_owner NUMBER;

Line 646: FROM fnd_flex_value_sets

642: -- IF l_validation_type = G_TRANS_IND_VALIDATION_CODE THEN
643: l_Sysdate := SYSDATE;
644: SELECT flex_value_set_id
645: INTO l_value_set_id
646: FROM fnd_flex_value_sets
647: WHERE flex_value_set_name = p_value_set_name;
648:
649: IF p_transaction_type = 'CREATE' THEN
650: -- create an translatable independent value set

Line 5322: FROM FND_FLEX_VALUE_SETS

5318: BEGIN
5319:
5320: SELECT FORMAT_TYPE
5321: INTO l_value_set_format_code
5322: FROM FND_FLEX_VALUE_SETS
5323: WHERE FLEX_VALUE_SET_ID = p_value_set_id;
5324:
5325: IF (l_value_set_format_code IS NULL OR
5326: (l_value_set_format_code <> p_data_type)) THEN

Line 6800: =( SELECT CREATED_BY FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID) ;

6796: l_created_by VARCHAR2(20) ;
6797: BEGIN
6798: --Inserting party id instead of user id .
6799: SELECT PERSON_PARTY_ID INTO L_CREATED_BY FROM FND_USER WHERE USER_ID
6800: =( SELECT CREATED_BY FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID) ;
6801:
6802: --Inserting the new record in EGO_FLEX_VALUESET_VERSION_B for making versioned value set.
6803: INSERT INTO EGO_FLEX_VALUESET_VERSION_B(FLEX_VALUE_SET_ID,VERSION_SEQ_ID,DESCRIPTION
6804: ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)

Line 6950: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;

6946:
6947: -- l_add_where_clause VARCHAR2(1000);
6948: l_owner NUMBER;
6949: l_maximum_size NUMBER;
6950: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6951: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
6952: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6953: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6954: -- l_Sysdate DATE := Sysdate;

Line 6952: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;

6948: l_owner NUMBER;
6949: l_maximum_size NUMBER;
6950: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6951: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
6952: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6953: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6954: -- l_Sysdate DATE := Sysdate;
6955:
6956: l_owner_name VARCHAR2(40):='ANONYMOUS';

Line 6953: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;

6949: l_maximum_size NUMBER;
6950: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6951: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
6952: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6953: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6954: -- l_Sysdate DATE := Sysdate;
6955:
6956: l_owner_name VARCHAR2(40):='ANONYMOUS';
6957: BEGIN

Line 7064: UPDATE fnd_flex_value_sets

7060: ,min_value => l_minimum_value
7061: ,max_value => l_maximum_value
7062: );
7063: IF l_validation_code = G_TRANS_IND_VALIDATION_CODE THEN
7064: UPDATE fnd_flex_value_sets
7065: SET validation_type = l_validation_code
7066: WHERE flex_value_set_name = p_value_set_name;
7067: END IF;
7068: ELSIF (l_validation_code = G_TABLE_VALIDATION_CODE) THEN

Line 7089: UPDATE fnd_flex_value_sets

7085: ,RIGHT_JUSTIFY_ZERO_FILL => 'N'
7086: ,MIN_VALUE => l_minimum_value
7087: ,MAX_VALUE => l_maximum_value
7088: );
7089: UPDATE fnd_flex_value_sets
7090: SET validation_type = l_validation_code
7091: WHERE flex_value_set_name = p_value_set_name;
7092: END IF;*/
7093: --Bug No:5292701

Line 7154: FROM fnd_flex_value_sets

7150: --Bug No:5292701 :END
7151:
7152: SELECT flex_value_set_id
7153: INTO x_value_set_id
7154: FROM fnd_flex_value_sets
7155: WHERE flex_value_set_name = p_value_set_name;
7156:
7157: -- Standard check of p_commit
7158: IF FND_API.To_Boolean(p_commit) THEN

Line 7510: -- Delete from fnd_flex_value_sets --

7506: IS
7507: BEGIN
7508:
7509: ----------------------------------------------------------------------------
7510: -- Delete from fnd_flex_value_sets --
7511: ----------------------------------------------------------------------------
7512: delete from FND_FLEX_VALUE_SETS where flex_value_set_id = p_child_vs_id;
7513:
7514:

Line 7512: delete from FND_FLEX_VALUE_SETS where flex_value_set_id = p_child_vs_id;

7508:
7509: ----------------------------------------------------------------------------
7510: -- Delete from fnd_flex_value_sets --
7511: ----------------------------------------------------------------------------
7512: delete from FND_FLEX_VALUE_SETS where flex_value_set_id = p_child_vs_id;
7513:
7514:
7515: ----------------------------------------------------------------------------
7516: -- Delete from EGO_VALUE_SET_EXT --

Line 7542: ,p_long_list_flag IN FND_FLEX_VALUE_SETS.LONGLIST_FLAG%TYPE

7538: ,p_format_code IN VARCHAR2
7539: ,p_maximum_size IN NUMBER
7540: ,p_maximum_value IN VARCHAR2
7541: ,p_minimum_value IN VARCHAR2
7542: ,p_long_list_flag IN FND_FLEX_VALUE_SETS.LONGLIST_FLAG%TYPE
7543: -- VARCHAR2
7544: ,p_validation_code IN VARCHAR2
7545: ,p_owner IN NUMBER DEFAULT NULL
7546: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

Line 7567: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;

7563: l_Sysdate DATE;
7564: l_OPDXcheck_dummy VARCHAR(2);
7565: l_owner NUMBER;
7566:
7567: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
7568: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
7569: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
7570:
7571: l_value_set_rec EGO_VALUE_SETS_V%ROWTYPE;

Line 7568: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;

7564: l_OPDXcheck_dummy VARCHAR(2);
7565: l_owner NUMBER;
7566:
7567: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
7568: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
7569: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
7570:
7571: l_value_set_rec EGO_VALUE_SETS_V%ROWTYPE;
7572: --changes FOR P4T

Line 7569: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;

7565: l_owner NUMBER;
7566:
7567: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
7568: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
7569: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
7570:
7571: l_value_set_rec EGO_VALUE_SETS_V%ROWTYPE;
7572: --changes FOR P4T
7573: isVersionedVS NUMBER ;

Line 7636: UPDATE FND_FLEX_VALUE_SETS

7632: END IF;
7633:
7634: -- API not available in FND for updation
7635: -- logged bug 3957430 against FND
7636: UPDATE FND_FLEX_VALUE_SETS
7637: SET DESCRIPTION = p_description,
7638: LONGLIST_FLAG = p_long_list_flag,
7639: MINIMUM_VALUE = l_minimum_value,
7640: MAXIMUM_VALUE = l_maximum_value,

Line 7672: -- UPDATE fnd_flex_value_sets

7668: -- BULK COLLECT INTO child_value_set_ids;
7669: --
7670: -- we cannot use it in a SQL Update statement like this:
7671: --
7672: -- UPDATE fnd_flex_value_sets
7673: -- SET longlist_flag = p_long_list_flag
7674: -- WHERE flex_value_set_id IN TABLE (child_value_set_ids);
7675: --
7676: -- because the collection's data type

Line 7691: UPDATE fnd_flex_value_sets

7687: WHERE parent_value_set_id = p_value_set_id)
7688: LOOP
7689:
7690: -- Update the long list display type
7691: UPDATE fnd_flex_value_sets
7692: SET longlist_flag = p_long_list_flag
7693: WHERE flex_value_set_id = l_value_set_rec.value_set_id;
7694:
7695: -- dbms_output.put_line(' ' || l_value_set_rec.value_set_id);

Line 8321: x_flex_Value_Set_Id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;

8317: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
8318: -- l_Sysdate DATE;
8319: l_rowid VARCHAR2(100);
8320: l_owner NUMBER;
8321: x_flex_Value_Set_Id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;
8322: VersionedValueSet NUMBER ;
8323: L_VALUE_EXIST NUMBER;
8324:
8325:

Line 8328: X_FLEX_VALUE_SET_ID FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_NAME = P_VALUE_SET_NAME ;

8324:
8325:
8326: BEGIN
8327: SELECT FLEX_VALUE_SET_ID INTO
8328: X_FLEX_VALUE_SET_ID FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_NAME = P_VALUE_SET_NAME ;
8329:
8330: SELECT COUNT(*) INTO L_VALUE_EXIST FROM FND_FLEX_VALUES WHERE FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID
8331: AND FLEX_VALUE = P_INTERNAL_NAME ;
8332:

Line 8429: flex_Value_Set_Id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;

8425: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
8426: -- l_Sysdate DATE;
8427: l_rowid VARCHAR2(100);
8428: l_owner NUMBER;
8429: flex_Value_Set_Id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;
8430: VersionedValueSet NUMBER ;
8431:
8432:
8433: BEGIN

Line 8626: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;

8622: --if we change required parameters, version goes from n.x to (n+1).x
8623: --if we change optional parameters, version goes from x.n to x.(n+1)
8624: l_api_version NUMBER;
8625: l_owner NUMBER;
8626: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;
8627: l_values_count NUMBER;
8628: l_flex_value_id fnd_flex_values.flex_value_id%type;
8629: BEGIN
8630:

Line 8676: SELECT flex_value_set_id INTO l_value_set_id FROM fnd_flex_value_sets

8672: AND VIEW_APPLICATION_ID = p_application_id
8673: --AND LANGUAGE = USERENV('LANG');
8674: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
8675: ***/
8676: SELECT flex_value_set_id INTO l_value_set_id FROM fnd_flex_value_sets
8677: WHERE flex_value_set_name = p_value_set_name;
8678:
8679: SELECT flex_value_id INTO l_flex_value_id FROM fnd_flex_values
8680: WHERE flex_value_set_id = l_value_set_id AND flex_value = p_internal_name;

Line 8776: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

8772: ,x_msg_data OUT NOCOPY VARCHAR2
8773: ) IS
8774: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
8775: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
8776: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
8777:
8778: l_vsv_row fnd_flex_values%ROWTYPE;
8779: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
8780:

Line 8797: FROM FND_FLEX_VALUE_SETS vs

8793:
8794: BEGIN
8795: SELECT vs.flex_value_set_id, vs.validation_type
8796: INTO l_value_set_id, l_validation_type
8797: FROM FND_FLEX_VALUE_SETS vs
8798: WHERE vs.flex_value_set_name = p_value_set_name;
8799:
8800: IF l_validation_type = G_TRANS_IND_VALIDATION_CODE THEN
8801:

Line 8936: l_vs_row fnd_flex_value_sets%ROWTYPE;

8932: RETURN VARCHAR2 IS
8933: -- T is VS is editable
8934: -- F if VS is not editable.
8935: l_return_status VARCHAR2(1);
8936: l_vs_row fnd_flex_value_sets%ROWTYPE;
8937: BEGIN
8938: l_return_status := FND_API.G_TRUE;
8939: SELECT *
8940: INTO l_vs_row

Line 8941: FROM fnd_flex_value_sets

8937: BEGIN
8938: l_return_status := FND_API.G_TRUE;
8939: SELECT *
8940: INTO l_vs_row
8941: FROM fnd_flex_value_sets
8942: WHERE flex_value_set_id = cp_value_set_id;
8943:
8944: IF l_vs_row.created_by IN (1,2)
8945: OR

Line 8987: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;

8983: l_return_status VARCHAR2(1);
8984:
8985: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8986: l_vs_created_by fnd_flex_values.created_by%TYPE;
8987: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8990: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8991: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;

Line 8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;

8984:
8985: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8986: l_vs_created_by fnd_flex_values.created_by%TYPE;
8987: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8990: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8991: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8992: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;

Line 8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

8985: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8986: l_vs_created_by fnd_flex_values.created_by%TYPE;
8987: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8990: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8991: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8992: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;
8993:

Line 8990: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;

8986: l_vs_created_by fnd_flex_values.created_by%TYPE;
8987: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8990: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8991: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8992: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;
8993:
8994: BEGIN

Line 8991: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;

8987: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8990: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8991: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8992: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;
8993:
8994: BEGIN
8995:

Line 8992: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;

8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8990: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;
8991: l_vs_numeric_mode_enabled fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE;
8992: l_vs_security_enabled fnd_flex_value_sets.security_enabled_flag%TYPE;
8993:
8994: BEGIN
8995:
8996: l_return_status := FND_API.G_TRUE;

Line 9003: FROM fnd_flex_values a, fnd_flex_value_sets b

8999: b.numeric_mode_enabled_flag, b.security_enabled_flag, b.created_by
9000: INTO l_vsv_created_by, l_vs_format_type, l_vs_validation_type,
9001: l_vs_alpha_numeric_allowed, l_vs_uppercase_only,
9002: l_vs_numeric_mode_enabled, l_vs_security_enabled, l_vs_created_by
9003: FROM fnd_flex_values a, fnd_flex_value_sets b
9004: WHERE a.flex_value_id = cp_vs_value_id
9005: AND a.flex_value_set_id = b.flex_value_set_id;
9006:
9007: IF l_vsv_created_by IN (1,2)

Line 9075: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

9071:
9072: l_api_name VARCHAR2(30);
9073: l_api_version NUMBER;
9074: l_value_set_value_id fnd_flex_values.flex_value_id%TYPE;
9075: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
9076: l_sequence EGO_VS_VALUES_DISP_ORDER.disp_sequence%TYPE;
9077: l_invalid_params BOOLEAN;
9078: l_create_sequence BOOLEAN;
9079: l_update_sequence BOOLEAN;

Line 9146: FROM fnd_flex_values a, fnd_flex_value_sets b

9142: ELSE
9143: BEGIN
9144: SELECT a.flex_value_id, a.flex_value_set_id
9145: INTO l_value_set_value_id, l_value_set_id
9146: FROM fnd_flex_values a, fnd_flex_value_sets b
9147: WHERE a.flex_value_set_id = b.flex_value_set_id
9148: AND a.flex_value = p_value_set_value
9149: AND (b.flex_value_set_id = p_value_set_id OR b.flex_value_set_name = p_value_set_name);
9150: EXCEPTION

Line 15474: l_value_set_name FND_FLEX_VALUE_SETS.flex_value_set_name%TYPE;

15470: ,p_value_id IN NUMBER
15471: ,x_return_status OUT NOCOPY VARCHAR2
15472: ) IS
15473:
15474: l_value_set_name FND_FLEX_VALUE_SETS.flex_value_set_name%TYPE;
15475: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
15476: l_internal_name FND_FLEX_VALUES.FLEX_VALUE%TYPE;
15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;
15478: l_description FND_FLEX_VALUES_TL.description%TYPE;

Line 15484: SELECT FLEX_VALUE_SET_NAME INTO L_VALUE_SET_NAME FROM FND_FLEX_VALUE_SETS

15480: l_end_date DATE;
15481: l_enabled FND_FLEX_VALUES.ENABLED_FLAG%TYPE;
15482:
15483: BEGIN
15484: SELECT FLEX_VALUE_SET_NAME INTO L_VALUE_SET_NAME FROM FND_FLEX_VALUE_SETS
15485: WHERE FLEX_VALUE_SET_ID = p_value_set_id ;
15486: SELECT FLEX_VALUE,FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,
15487: ENABLED_FLAG INTO l_internal_name,l_display_name,l_description,l_start_date,l_enabled
15488: FROM FND_FLEX_VALUES,FND_FLEX_VALUES_TL WHERE