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

Line 905: OKC_ARTICLES_IMPORT_GRP.import_fnd_flex_value_sets(

901: l_wrap_up := 'N' ;
902: END IF;
903:
904: BEGIN
905: OKC_ARTICLES_IMPORT_GRP.import_fnd_flex_value_sets(
906: x_return_status => l_return_status,
907: x_msg_count => x_msg_count,
908: x_msg_data => x_msg_data,
909: p_batch_procs_id => l_batch_process_id,

Line 1888: FND_FLEX_VALUE_SETS FLX

1884: SELECT FLX.FLEX_VALUE_SET_ID,
1885: BVB.VARIABLE_TYPE
1886: FROM
1887: OKC_BUS_VARIABLES_B BVB,
1888: FND_FLEX_VALUE_SETS FLX
1889: WHERE BVB.VARIABLE_CODE = cp_variable_code
1890: --AND BVB.VARIABLE_TYPE = 'U'
1891: AND FLX.FLEX_VALUE_SET_ID(+) = BVB.VALUE_SET_ID;
1892:

Line 2060: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

2056: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
2057: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
2058: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%TYPE;
2059: l_variable_type OKC_BUS_VARIABLES_B.VARIABLE_TYPE%TYPE;
2060: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
2061: l_return_status VARCHAR2(1);
2062: api_return_status VARCHAR2(1);
2063: l_doc_sequence_type CHAR(1);
2064: l_error_index NUMBER := 1;

Line 4490: FROM FND_FLEX_VALUE_SETS FLX

4486: CURSOR get_valset_id_csr (cp_valset_name IN VARCHAR2 ) IS
4487: SELECT
4488: FLX.FLEX_VALUE_SET_ID ,
4489: DECODE(FORMAT_TYPE,'C','V','X','D',FORMAT_TYPE) FORMAT_TYPE
4490: FROM FND_FLEX_VALUE_SETS FLX
4491: WHERE FLX.FLEX_VALUE_SET_NAME = cp_valset_name;
4492:
4493:
4494: -- Cursor to check valueset exists in the valueset interface Table

Line 4631: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

4627: l_dummy_unq VARCHAR2(1) := '?';
4628: l_dummy VARCHAR2(1) := '?';
4629: l_vs_id VARCHAR2(1) := NULL;
4630: l_language varchar2(1) := '?';
4631: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
4632: l_variable_datatype OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
4633:
4634: BEGIN
4635: IF (l_debug = 'Y') THEN

Line 7055: PROCEDURE import_fnd_flex_value_sets(

7051: END IF;
7052: get_print_msgs_stack(p_msg_data => x_msg_data);
7053: END import_relationships;
7054:
7055: PROCEDURE import_fnd_flex_value_sets(
7056: x_return_status OUT NOCOPY VARCHAR2,
7057: x_msg_count OUT NOCOPY NUMBER,
7058: x_msg_data OUT NOCOPY VARCHAR2,
7059:

Line 7066: l_api_name CONSTANT VARCHAR2(30) := 'import_fnd_flex_value_sets';

7062: p_validate_only IN VARCHAR2 := 'Y',
7063: p_fetchsize IN NUMBER := 100
7064: ) IS
7065: l_api_version CONSTANT NUMBER := 1;
7066: l_api_name CONSTANT VARCHAR2(30) := 'import_fnd_flex_value_sets';
7067: l_sts_warning CONSTANT VARCHAR2(1) := 'W';
7068: l_row_notfound BOOLEAN := FALSE;
7069: l_user_id NUMBER;
7070: l_login_id NUMBER;

Line 7532: okc_debug.log('300: In Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

7528:
7529: EXCEPTION
7530: WHEN FND_API.G_EXC_ERROR THEN
7531: IF (l_debug = 'Y') THEN
7532: okc_debug.log('300: In Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
7533: END IF;
7534: --l_return_status := G_RET_STS_ERROR ;
7535: build_error_array(
7536: p_msg_data => x_msg_data,

Line 7552: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

7548: -- Continue to next row
7549:
7550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7551: IF (l_debug = 'Y') THEN
7552: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7553: END IF;
7554:
7555: IF l_valset_interface_csr%ISOPEN THEN
7556: CLOSE l_valset_interface_csr;

Line 7580: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);

7576: exit; -- exit the current fetch
7577:
7578: WHEN OTHERS THEN
7579: IF (l_debug = 'Y') THEN
7580: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7581: END IF;
7582:
7583: IF l_valset_interface_csr%ISOPEN THEN
7584: CLOSE l_valset_interface_csr;

Line 7638: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

7634: -------------------------
7635: EXCEPTION
7636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7637: IF (l_debug = 'Y') THEN
7638: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7639: END IF;
7640:
7641: IF l_valset_interface_csr%ISOPEN THEN
7642: CLOSE l_valset_interface_csr;

Line 7650: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);

7646: exit; -- exit outermost loop
7647:
7648: WHEN OTHERS THEN
7649: IF (l_debug = 'Y') THEN
7650: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7651: END IF;
7652:
7653: IF l_valset_interface_csr%ISOPEN THEN
7654: CLOSE l_valset_interface_csr;

Line 7668: --------------------- Start Do_DML for Fnd Flex Value Sets ---------------

7664: -------------------------
7665: -------------------------
7666:
7667: ------------------------------------------------------------------------
7668: --------------------- Start Do_DML for Fnd Flex Value Sets ---------------
7669: -- Insert Fnd Flex Value Sets
7670: -------------------------------------------------------------------------
7671: -- initialize l_return_status to track status of DML execution
7672: l_return_status := G_RET_STS_SUCCESS;

Line 7669: -- Insert Fnd Flex Value Sets

7665: -------------------------
7666:
7667: ------------------------------------------------------------------------
7668: --------------------- Start Do_DML for Fnd Flex Value Sets ---------------
7669: -- Insert Fnd Flex Value Sets
7670: -------------------------------------------------------------------------
7671: -- initialize l_return_status to track status of DML execution
7672: l_return_status := G_RET_STS_SUCCESS;
7673:

Line 7733: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

7729:
7730: EXCEPTION
7731: WHEN OTHERS THEN
7732: IF (l_debug = 'Y') THEN
7733: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
7734: END IF;
7735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7736: END;
7737:

Line 7739: -- End of Insert into FND FLEX VALUE SETS

7735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7736: END;
7737:
7738: --
7739: -- End of Insert into FND FLEX VALUE SETS
7740: --
7741: --
7742:
7743:

Line 7825: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);

7821: interface_id = vsinf_interface_id_tbl(i);
7822: EXCEPTION
7823: WHEN OTHERS THEN
7824: IF (l_debug = 'Y') THEN
7825: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7826: END IF;
7827:
7828: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7829: p_msg_name => G_UNEXPECTED_ERROR,

Line 7958: okc_debug.log('2000: Leaving Fnd_flex_value_sets import', 2);

7954: --wrap_up(p_validate_only,p_batch_number,l_tot_rows_processed,l_tot_rows_failed,l_tot_rows_warned,l_batch_process_id,'VALUESET');
7955: commit; -- Final commit for status update
7956:
7957: IF (l_debug = 'Y') THEN
7958: okc_debug.log('2000: Leaving Fnd_flex_value_sets import', 2);
7959: END IF;
7960: --x_return_status := l_return_status; this may cause to erase error x_return_status
7961:
7962: EXCEPTION

Line 7966: okc_debug.log('3000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

7962: EXCEPTION
7963:
7964: WHEN FND_API.G_EXC_ERROR THEN
7965: IF (l_debug = 'Y') THEN
7966: okc_debug.log('3000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
7967: END IF;
7968: --Insert Errors into Error table if there is any
7969: insert_error_array(
7970: x_return_status => x_return_status,

Line 7978: okc_debug.log('4000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

7974: x_return_status := G_RET_STS_ERROR ;
7975:
7976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7977: IF (l_debug = 'Y') THEN
7978: okc_debug.log('4000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7979: END IF;
7980: --Insert Errors into Error table if there is any
7981:
7982: insert_error_array(

Line 8005: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);

8001: -- In this exception handling, we don't insert error array again
8002: -- because error happend in the module
8003: --
8004: IF (l_debug = 'Y') THEN
8005: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
8006: END IF;
8007:
8008: IF l_valset_interface_csr%ISOPEN THEN
8009: CLOSE l_valset_interface_csr;

Line 8022: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);

8018: commit;
8019:
8020: WHEN OTHERS THEN
8021: IF (l_debug = 'Y') THEN
8022: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
8023: END IF;
8024: --Insert Errors into Error table if there is any
8025: insert_error_array(
8026: x_return_status => x_return_status,

Line 8041: END import_fnd_flex_value_sets;

8037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8038: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8039: END IF;
8040: get_print_msgs_stack(p_msg_data => x_msg_data);
8041: END import_fnd_flex_value_sets;
8042:
8043: PROCEDURE import_fnd_flex_values(
8044: x_return_status OUT NOCOPY VARCHAR2,
8045: x_msg_count OUT NOCOPY NUMBER,

Line 8088: FROM OKC_VS_VALUES_INTERFACE VINT,FND_FLEX_VALUE_SETS VS

8084: VS.NUMERIC_MODE_ENABLED_FLAG,
8085: VS.MINIMUM_VALUE ,
8086: VS.MAXIMUM_VALUE ,
8087: TO_NUMBER(NULL) FLEX_VALUE_ID
8088: FROM OKC_VS_VALUES_INTERFACE VINT,FND_FLEX_VALUE_SETS VS
8089: WHERE VINT.FLEX_VALUE_SET_NAME = VS.FLEX_VALUE_SET_NAME
8090: AND nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
8091: AND BATCH_NUMBER = cp_batch_number
8092: UNION ALL

Line 8124: ( SELECT 1 FROM FND_FLEX_VALUE_SETS FVS

8120: AND VINT.BATCH_NUMBER = VS.BATCH_NUMBER (+)
8121: AND nvl(VS.PROCESS_STATUS,'*') NOT IN ('E')
8122: AND VINT.BATCH_NUMBER = cp_batch_number
8123: AND NOT EXISTS
8124: ( SELECT 1 FROM FND_FLEX_VALUE_SETS FVS
8125: WHERE FVS.FLEX_VALUE_SET_NAME = VINT.FLEX_VALUE_SET_NAME)
8126: ORDER BY FLEX_VALUE_SET_NAME,FLEX_VALUE ASC;
8127:
8128:

Line 8170: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;

8166: TYPE l_vinf_flex_value_meaning IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_MEANING%TYPE INDEX BY BINARY_INTEGER ;
8167:
8168:
8169: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8170: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8171: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8172: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;

Line 8171: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;

8167:
8168:
8169: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8170: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8171: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8172: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

Line 8172: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;

8168:
8169: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8170: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8171: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8172: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

Line 8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;

8169: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8170: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8171: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8172: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8177: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

Line 8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;

8170: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8171: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8172: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8177: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8178: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

Line 8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

8171: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8172: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8177: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8178: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8179: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

Line 8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

8172: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8177: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8178: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8179: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8180:

Line 8177: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

8173: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8177: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8178: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8179: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8180:
8181:

Line 8178: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

8174: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8177: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8178: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8179: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8180:
8181:
8182: TYPE l_vinf_flex_value_orig IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;

Line 8179: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

8175: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8176: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8177: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8178: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8179: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8180:
8181:
8182: TYPE l_vinf_flex_value_orig IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8183: