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 4498: FROM OKC_VALUESETS_INTERFACE

4494: -- Cursor to check valueset exists in the valueset interface Table
4495: CURSOR valset_exists_csr (cp_valset_name IN VARCHAR2,
4496: cp_batch_number IN VARCHAR2) IS
4497: SELECT '1'
4498: FROM OKC_VALUESETS_INTERFACE
4499: WHERE flex_value_set_name = cp_valset_name
4500: AND batch_number = cp_batch_number
4501: AND nvl(process_status,'X') not in ('E');
4502:

Line 7091: FROM OKC_VALUESETS_INTERFACE VSINT

7087: VSINT.MAXIMUM_VALUE ,
7088: VSINT.NUMBER_PRECISION ,
7089: VSINT.UPPERCASE_ONLY_FLAG ,
7090: VSINT.NUMBER_ONLY_FLAG
7091: FROM OKC_VALUESETS_INTERFACE VSINT
7092: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
7093: AND BATCH_NUMBER = cp_batch_number
7094: ORDER BY VSINT.FLEX_VALUE_SET_NAME ASC;
7095:

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

7094: ORDER BY VSINT.FLEX_VALUE_SET_NAME ASC;
7095:
7096: -- Flex Valuesets Interface Rows
7097:
7098: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7099: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7100: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7101: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;

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

7095:
7096: -- Flex Valuesets Interface Rows
7097:
7098: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7099: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7100: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7101: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

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

7096: -- Flex Valuesets Interface Rows
7097:
7098: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7099: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7100: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7101: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

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

7097:
7098: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7099: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7100: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7101: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;

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

7098: TYPE l_vsinf_interface_id IS TABLE OF OKC_VALUESETS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
7099: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7100: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7101: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;

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

7099: TYPE l_vsinf_batch_number IS TABLE OF OKC_VALUESETS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7100: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7101: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

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

7100: TYPE l_vsinf_obj_ver_number IS TABLE OF OKC_VALUESETS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
7101: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

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

7101: TYPE l_vsinf_flex_value_set_name IS TABLE OF OKC_VALUESETS_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7109: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;

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

7102: TYPE l_vsinf_validation_type IS TABLE OF OKC_VALUESETS_INTERFACE.VALIDATION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7109: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7110: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;

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

7103: TYPE l_vsinf_process_status IS TABLE OF OKC_VALUESETS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7109: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7110: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7111: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

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

7104: TYPE l_vsinf_action IS TABLE OF OKC_VALUESETS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7109: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7110: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7111: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7112: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;

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

7105: TYPE l_vsinf_format_type IS TABLE OF OKC_VALUESETS_INTERFACE.FORMAT_TYPE%TYPE INDEX BY BINARY_INTEGER ;
7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7109: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7110: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7111: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7112: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7113:

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

7106: TYPE l_vsinf_maximum_size IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_SIZE%TYPE INDEX BY BINARY_INTEGER ;
7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7109: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7110: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7111: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7112: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7113:
7114:

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

7107: TYPE l_vsinf_description IS TABLE OF OKC_VALUESETS_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7109: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7110: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7111: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7112: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7113:
7114:
7115:

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

7108: TYPE l_vsinf_minimum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7109: TYPE l_vsinf_maximum_value IS TABLE OF OKC_VALUESETS_INTERFACE.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
7110: TYPE l_vsinf_number_precision IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_PRECISION%TYPE INDEX BY BINARY_INTEGER ;
7111: TYPE l_vsinf_uppercase_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.UPPERCASE_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7112: TYPE l_vsinf_number_only_flag IS TABLE OF OKC_VALUESETS_INTERFACE.NUMBER_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER ;
7113:
7114:
7115:
7116: l_return_status VARCHAR2(1);

Line 7151: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;

7147: I NUMBER := 0;
7148: j NUMBER := 0;
7149: k NUMBER := 0;
7150: x NUMBER := 0;
7151: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;
7152: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
7153: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
7154: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;
7155: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 7152: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;

7148: j NUMBER := 0;
7149: k NUMBER := 0;
7150: x NUMBER := 0;
7151: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;
7152: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
7153: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
7154: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;
7155: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
7156:

Line 7153: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;

7149: k NUMBER := 0;
7150: x NUMBER := 0;
7151: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;
7152: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
7153: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
7154: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;
7155: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
7156:
7157:

Line 7154: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;

7150: x NUMBER := 0;
7151: l_program_id OKC_VALUESETS_INTERFACE.PROGRAM_ID%TYPE;
7152: l_program_login_id OKC_VALUESETS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
7153: l_program_appl_id OKC_VALUESETS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
7154: l_request_id OKC_VALUESETS_INTERFACE.REQUEST_ID%TYPE;
7155: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
7156:
7157:
7158: BEGIN

Line 7795: UPDATE OKC_VALUESETS_INTERFACE

7791: i:=0;
7792: BEGIN
7793: l_context := 'UPDATING VALUE SETS INTERFACE TABLE';
7794: FORALL i in vsinf_interface_id_tbl.FIRST..vsinf_interface_id_tbl.LAST
7795: UPDATE OKC_VALUESETS_INTERFACE
7796: SET
7797: -- We don't want to update process_status to 'S' or 'W' in validation_mode
7798: -- because it is not going to be picked up in next run if we do so
7799: PROCESS_STATUS = decode(p_validate_only||vsinf_process_status_tbl(i)||l_bulk_failed,

Line 7856: -- End of Update OKC_VALUESETS_INTERFACE

7852:
7853: --RAISE FND_API.G_EXC_ERROR ;
7854: END;
7855: --
7856: -- End of Update OKC_VALUESETS_INTERFACE
7857: --
7858: --
7859:
7860: --

Line 8118: FROM OKC_VS_VALUES_INTERFACE VINT,OKC_VALUESETS_INTERFACE VS

8114: VS.NUMBER_ONLY_FLAG NUMERIC_MODE_ENABLED_FLAG,
8115: VS.MINIMUM_VALUE ,
8116: VS.MAXIMUM_VALUE ,
8117: TO_NUMBER(NULL) FLEX_VALUE_ID
8118: FROM OKC_VS_VALUES_INTERFACE VINT,OKC_VALUESETS_INTERFACE VS
8119: WHERE VINT.FLEX_VALUE_SET_NAME = VS.FLEX_VALUE_SET_NAME (+)
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

Line 8146: FROM OKC_VALUESETS_INTERFACE

8142: -- Cursor to check valueset in the valueset interface Table
8143: CURSOR valset_exists_csr (cp_vs_name IN VARCHAR2,
8144: cp_batch_number IN VARCHAR2) IS
8145: SELECT '1'
8146: FROM OKC_VALUESETS_INTERFACE
8147: WHERE flex_value_set_name = cp_vs_name
8148: AND batch_number = cp_batch_number
8149: AND nvl(process_status,'X') not in ('E');
8150: