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 1883: FND_FLEX_VALUE_SETS FLX

1879: SELECT FLX.FLEX_VALUE_SET_ID,
1880: BVB.VARIABLE_TYPE
1881: FROM
1882: OKC_BUS_VARIABLES_B BVB,
1883: FND_FLEX_VALUE_SETS FLX
1884: WHERE BVB.VARIABLE_CODE = cp_variable_code
1885: --AND BVB.VARIABLE_TYPE = 'U'
1886: AND FLX.FLEX_VALUE_SET_ID(+) = BVB.VALUE_SET_ID;
1887:

Line 2046: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

2042: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
2043: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
2044: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%TYPE;
2045: l_variable_type OKC_BUS_VARIABLES_B.VARIABLE_TYPE%TYPE;
2046: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
2047: l_return_status VARCHAR2(1);
2048: api_return_status VARCHAR2(1);
2049: l_doc_sequence_type CHAR(1);
2050: l_error_index NUMBER := 1;

Line 4424: FROM FND_FLEX_VALUE_SETS FLX

4420: CURSOR get_valset_id_csr (cp_valset_name IN VARCHAR2 ) IS
4421: SELECT
4422: FLX.FLEX_VALUE_SET_ID ,
4423: DECODE(FORMAT_TYPE,'C','V','X','D',FORMAT_TYPE) FORMAT_TYPE
4424: FROM FND_FLEX_VALUE_SETS FLX
4425: WHERE FLX.FLEX_VALUE_SET_NAME = cp_valset_name;
4426:
4427:
4428: -- Cursor to check valueset exists in the valueset interface Table

Line 4565: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

4561: l_dummy_unq VARCHAR2(1) := '?';
4562: l_dummy VARCHAR2(1) := '?';
4563: l_vs_id VARCHAR2(1) := NULL;
4564: l_language varchar2(1) := '?';
4565: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
4566: l_variable_datatype OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
4567:
4568: BEGIN
4569: IF (l_debug = 'Y') THEN

Line 6987: PROCEDURE import_fnd_flex_value_sets(

6983: END IF;
6984: get_print_msgs_stack(p_msg_data => x_msg_data);
6985: END import_relationships;
6986:
6987: PROCEDURE import_fnd_flex_value_sets(
6988: x_return_status OUT NOCOPY VARCHAR2,
6989: x_msg_count OUT NOCOPY NUMBER,
6990: x_msg_data OUT NOCOPY VARCHAR2,
6991:

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

6994: p_validate_only IN VARCHAR2 := 'Y',
6995: p_fetchsize IN NUMBER := 100
6996: ) IS
6997: l_api_version CONSTANT NUMBER := 1;
6998: l_api_name CONSTANT VARCHAR2(30) := 'import_fnd_flex_value_sets';
6999: l_sts_warning CONSTANT VARCHAR2(1) := 'W';
7000: l_row_notfound BOOLEAN := FALSE;
7001: l_user_id NUMBER;
7002: l_login_id NUMBER;

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

7460:
7461: EXCEPTION
7462: WHEN FND_API.G_EXC_ERROR THEN
7463: IF (l_debug = 'Y') THEN
7464: okc_debug.log('300: In Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
7465: END IF;
7466: --l_return_status := G_RET_STS_ERROR ;
7467: build_error_array(
7468: p_msg_data => x_msg_data,

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

7480: -- Continue to next row
7481:
7482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7483: IF (l_debug = 'Y') THEN
7484: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7485: END IF;
7486:
7487: IF l_valset_interface_csr%ISOPEN THEN
7488: CLOSE l_valset_interface_csr;

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

7508: exit; -- exit the current fetch
7509:
7510: WHEN OTHERS THEN
7511: IF (l_debug = 'Y') THEN
7512: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7513: END IF;
7514:
7515: IF l_valset_interface_csr%ISOPEN THEN
7516: CLOSE l_valset_interface_csr;

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

7566: -------------------------
7567: EXCEPTION
7568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7569: IF (l_debug = 'Y') THEN
7570: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7571: END IF;
7572:
7573: IF l_valset_interface_csr%ISOPEN THEN
7574: CLOSE l_valset_interface_csr;

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

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

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

7596: -------------------------
7597: -------------------------
7598:
7599: ------------------------------------------------------------------------
7600: --------------------- Start Do_DML for Fnd Flex Value Sets ---------------
7601: -- Insert Fnd Flex Value Sets
7602: -------------------------------------------------------------------------
7603: -- initialize l_return_status to track status of DML execution
7604: l_return_status := G_RET_STS_SUCCESS;

Line 7601: -- Insert Fnd Flex Value Sets

7597: -------------------------
7598:
7599: ------------------------------------------------------------------------
7600: --------------------- Start Do_DML for Fnd Flex Value Sets ---------------
7601: -- Insert Fnd Flex Value Sets
7602: -------------------------------------------------------------------------
7603: -- initialize l_return_status to track status of DML execution
7604: l_return_status := G_RET_STS_SUCCESS;
7605:

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

7661:
7662: EXCEPTION
7663: WHEN OTHERS THEN
7664: IF (l_debug = 'Y') THEN
7665: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
7666: END IF;
7667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7668: END;
7669:

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

7667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7668: END;
7669:
7670: --
7671: -- End of Insert into FND FLEX VALUE SETS
7672: --
7673: --
7674:
7675:

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

7753: interface_id = vsinf_interface_id_tbl(i);
7754: EXCEPTION
7755: WHEN OTHERS THEN
7756: IF (l_debug = 'Y') THEN
7757: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7758: END IF;
7759:
7760: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7761: p_msg_name => G_UNEXPECTED_ERROR,

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

7886: --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');
7887: commit; -- Final commit for status update
7888:
7889: IF (l_debug = 'Y') THEN
7890: okc_debug.log('2000: Leaving Fnd_flex_value_sets import', 2);
7891: END IF;
7892: --x_return_status := l_return_status; this may cause to erase error x_return_status
7893:
7894: EXCEPTION

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

7894: EXCEPTION
7895:
7896: WHEN FND_API.G_EXC_ERROR THEN
7897: IF (l_debug = 'Y') THEN
7898: okc_debug.log('3000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
7899: END IF;
7900: --Insert Errors into Error table if there is any
7901: insert_error_array(
7902: x_return_status => x_return_status,

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

7906: x_return_status := G_RET_STS_ERROR ;
7907:
7908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7909: IF (l_debug = 'Y') THEN
7910: okc_debug.log('4000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7911: END IF;
7912: --Insert Errors into Error table if there is any
7913:
7914: insert_error_array(

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

7933: -- In this exception handling, we don't insert error array again
7934: -- because error happend in the module
7935: --
7936: IF (l_debug = 'Y') THEN
7937: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
7938: END IF;
7939:
7940: IF l_valset_interface_csr%ISOPEN THEN
7941: CLOSE l_valset_interface_csr;

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

7950: commit;
7951:
7952: WHEN OTHERS THEN
7953: IF (l_debug = 'Y') THEN
7954: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7955: END IF;
7956: --Insert Errors into Error table if there is any
7957: insert_error_array(
7958: x_return_status => x_return_status,

Line 7973: END import_fnd_flex_value_sets;

7969: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7971: END IF;
7972: get_print_msgs_stack(p_msg_data => x_msg_data);
7973: END import_fnd_flex_value_sets;
7974:
7975: PROCEDURE import_fnd_flex_values(
7976: x_return_status OUT NOCOPY VARCHAR2,
7977: x_msg_count OUT NOCOPY NUMBER,

Line 8020: FROM OKC_VS_VALUES_INTERFACE VINT,FND_FLEX_VALUE_SETS VS

8016: VS.NUMERIC_MODE_ENABLED_FLAG,
8017: VS.MINIMUM_VALUE ,
8018: VS.MAXIMUM_VALUE ,
8019: TO_NUMBER(NULL) FLEX_VALUE_ID
8020: FROM OKC_VS_VALUES_INTERFACE VINT,FND_FLEX_VALUE_SETS VS
8021: WHERE VINT.FLEX_VALUE_SET_NAME = VS.FLEX_VALUE_SET_NAME
8022: AND nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
8023: AND BATCH_NUMBER = cp_batch_number
8024: UNION ALL

Line 8056: ( SELECT 1 FROM FND_FLEX_VALUE_SETS FVS

8052: AND VINT.BATCH_NUMBER = VS.BATCH_NUMBER (+)
8053: AND nvl(VS.PROCESS_STATUS,'*') NOT IN ('E')
8054: AND VINT.BATCH_NUMBER = cp_batch_number
8055: AND NOT EXISTS
8056: ( SELECT 1 FROM FND_FLEX_VALUE_SETS FVS
8057: WHERE FVS.FLEX_VALUE_SET_NAME = VINT.FLEX_VALUE_SET_NAME)
8058: ORDER BY FLEX_VALUE_SET_NAME,FLEX_VALUE ASC;
8059:
8060:

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

8098: TYPE l_vinf_flex_value_meaning IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_MEANING%TYPE INDEX BY BINARY_INTEGER ;
8099:
8100:
8101: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8102: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8103: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8104: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8105: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;

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

8099:
8100:
8101: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8102: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8103: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8104: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8105: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

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

8100:
8101: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8102: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8103: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8104: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8105: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8108: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

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

8101: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8102: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8103: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8104: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8105: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8108: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8109: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

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

8102: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;
8103: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8104: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8105: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8108: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8109: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8110: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

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

8103: TYPE l_vinf_validation_type IS TABLE OF FND_FLEX_VALUE_SETS.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8104: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8105: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8108: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8109: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8110: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8111: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

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

8104: TYPE l_vinf_format_type IS TABLE OF FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
8105: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8108: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8109: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8110: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8111: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8112:

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

8105: TYPE l_vinf_maximum_size IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8108: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8109: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8110: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8111: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8112:
8113:

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

8106: TYPE l_vinf_number_precision IS TABLE OF FND_FLEX_VALUE_SETS.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8108: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8109: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8110: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8111: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8112:
8113:
8114: TYPE l_vinf_flex_value_orig IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;

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

8107: TYPE l_vinf_alphanum_allowed IS TABLE OF FND_FLEX_VALUE_SETS.ALPHANUMERIC_ALLOWED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8108: TYPE l_vinf_uppercase_only IS TABLE OF FND_FLEX_VALUE_SETS.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8109: TYPE l_vinf_num_mode_enabled IS TABLE OF FND_FLEX_VALUE_SETS.NUMERIC_MODE_ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8110: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8111: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8112:
8113:
8114: TYPE l_vinf_flex_value_orig IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8115: