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 OKC_VALUESETS_INTERFACE

Line 230: from okc_art_int_errors a,okc_valuesets_interface b

226:
227: CURSOR get_vs_info_csr IS
228: SELECT a.interface_id,a.entity,error_description,
229: b.flex_value_set_name
230: from okc_art_int_errors a,okc_valuesets_interface b
231: where a.interface_id = b.interface_id
232: and b.batch_number = p_batch_number
233: and a.batch_process_id = p_batch_procs_id
234: and a.entity = p_entity

Line 616: DELETE FROM OKC_VALUESETS_INTERFACE ;

612: -- Below Added for FAR/DFAR Content Import
613: DELETE FROM OKC_VARIABLES_INTERFACE ;
614: DELETE FROM OKC_ART_RELS_INTERFACE
615: WHERE org_id = G_CURRENT_ORG_ID ;
616: DELETE FROM OKC_VALUESETS_INTERFACE ;
617: DELETE FROM OKC_VS_VALUES_INTERFACE ;
618:
619: ELSE
620: DELETE FROM OKC_ART_INT_ERRORS

Line 648: DELETE FROM OKC_VALUESETS_INTERFACE

644: AND last_update_date <= l_end_date
645: AND (batch_number = p_batch_number OR p_batch_number IS NULL)
646: AND (process_status = p_process_status OR p_process_status IS NULL)
647: AND org_id = G_CURRENT_ORG_ID;
648: DELETE FROM OKC_VALUESETS_INTERFACE
649: WHERE last_update_date >= trunc(l_start_date)
650: AND last_update_date <= l_end_date
651: AND (batch_number = p_batch_number OR p_batch_number IS NULL)
652: AND (process_status = p_process_status OR p_process_status IS NULL)

Line 4432: FROM OKC_VALUESETS_INTERFACE

4428: -- Cursor to check valueset exists in the valueset interface Table
4429: CURSOR valset_exists_csr (cp_valset_name IN VARCHAR2,
4430: cp_batch_number IN VARCHAR2) IS
4431: SELECT '1'
4432: FROM OKC_VALUESETS_INTERFACE
4433: WHERE flex_value_set_name = cp_valset_name
4434: AND batch_number = cp_batch_number
4435: AND nvl(process_status,'X') not in ('E');
4436:

Line 7023: FROM OKC_VALUESETS_INTERFACE VSINT

7019: VSINT.MAXIMUM_VALUE ,
7020: VSINT.NUMBER_PRECISION ,
7021: VSINT.UPPERCASE_ONLY_FLAG ,
7022: VSINT.NUMBER_ONLY_FLAG
7023: FROM OKC_VALUESETS_INTERFACE VSINT
7024: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
7025: AND BATCH_NUMBER = cp_batch_number
7026: ORDER BY VSINT.FLEX_VALUE_SET_NAME ASC;
7027:

Line 7030: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;

7026: ORDER BY VSINT.FLEX_VALUE_SET_NAME ASC;
7027:
7028: -- Flex Valuesets Interface Rows
7029:
7030: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7031: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7032: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;

Line 7031: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

7027:
7028: -- Flex Valuesets Interface Rows
7029:
7030: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7031: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7032: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

Line 7032: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

7028: -- Flex Valuesets Interface Rows
7029:
7030: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7031: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7032: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

Line 7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;

7029:
7030: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7031: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7032: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;

Line 7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;

7030: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7031: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7032: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;

Line 7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

7031: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7032: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

Line 7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

7032: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

Line 7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;

7033: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

Line 7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;

7034: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7042: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;

Line 7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

7035: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7042: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7043: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

Line 7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

7036: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7042: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7043: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7044: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

Line 7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

7037: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7042: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7043: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7044: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7045:

Line 7042: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;

7038: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7042: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7043: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7044: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7045:
7046:

Line 7043: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

7039: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7042: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7043: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7044: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7045:
7046:
7047:

Line 7044: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

7040: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7041: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7042: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7043: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7044: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7045:
7046:
7047:
7048: l_return_status VARCHAR2(1);

Line 7083: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;

7079: I NUMBER := 0;
7080: j NUMBER := 0;
7081: k NUMBER := 0;
7082: x NUMBER := 0;
7083: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;
7084: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
7085: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
7086: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;
7087: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 7084: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;

7080: j NUMBER := 0;
7081: k NUMBER := 0;
7082: x NUMBER := 0;
7083: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;
7084: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
7085: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
7086: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;
7087: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
7088:

Line 7085: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;

7081: k NUMBER := 0;
7082: x NUMBER := 0;
7083: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;
7084: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
7085: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
7086: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;
7087: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
7088:
7089:

Line 7086: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;

7082: x NUMBER := 0;
7083: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;
7084: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
7085: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
7086: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;
7087: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
7088:
7089:
7090: BEGIN

Line 7727: UPDATE OKC_VALUESETS_INTERFACE

7723: i:=0;
7724: BEGIN
7725: l_context := 'UPDATING VALUE SETS INTERFACE TABLE';
7726: FORALL i in vsinf_interface_id_tbl.FIRST..vsinf_interface_id_tbl.LAST
7727: UPDATE OKC_VALUESETS_INTERFACE
7728: SET
7729: -- We don't want to update process_status to 'S' or 'W' in validation_mode
7730: -- because it is not going to be picked up in next run if we do so
7731: PROCESS_STATUS = decode(p_validate_only||vsinf_process_status_tbl(i)||l_bulk_failed,

Line 7788: -- End of Update OKC_VALUESETS_INTERFACE

7784:
7785: --RAISE FND_API.G_EXC_ERROR ;
7786: END;
7787: --
7788: -- End of Update OKC_VALUESETS_INTERFACE
7789: --
7790: --
7791:
7792: --

Line 8050: FROM OKC_VS_VALUES_INTERFACE VINT,OKC_VALUESETS_INTERFACE VS

8046: VS.NUMBER_ONLY_FLAG NUMERIC_MODE_ENABLED_FLAG,
8047: VS.MINIMUM_VALUE ,
8048: VS.MAXIMUM_VALUE ,
8049: TO_NUMBER(NULL) FLEX_VALUE_ID
8050: FROM OKC_VS_VALUES_INTERFACE VINT,OKC_VALUESETS_INTERFACE VS
8051: WHERE VINT.FLEX_VALUE_SET_NAME = VS.FLEX_VALUE_SET_NAME (+)
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

Line 8078: FROM OKC_VALUESETS_INTERFACE

8074: -- Cursor to check valueset in the valueset interface Table
8075: CURSOR valset_exists_csr (cp_vs_name IN VARCHAR2,
8076: cp_batch_number IN VARCHAR2) IS
8077: SELECT '1'
8078: FROM OKC_VALUESETS_INTERFACE
8079: WHERE flex_value_set_name = cp_vs_name
8080: AND batch_number = cp_batch_number
8081: AND nvl(process_status,'X') not in ('E');
8082: