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_VARIABLES_INTERFACE

Line 210: from okc_art_int_errors a,okc_variables_interface b

206:
207: CURSOR get_var_info_csr IS
208: SELECT a.interface_id,a.entity,error_description,
209: b.variable_code,b.variable_name
210: from okc_art_int_errors a,okc_variables_interface b
211: where a.interface_id = b.interface_id
212: and b.batch_number = p_batch_number
213: and a.batch_process_id = p_batch_procs_id
214: and a.entity = p_entity

Line 613: DELETE FROM OKC_VARIABLES_INTERFACE ;

609: DELETE FROM OKC_ART_INTERFACE_ALL
610: WHERE org_id = G_CURRENT_ORG_ID;
611:
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 ;

Line 636: DELETE FROM OKC_VARIABLES_INTERFACE

632: AND (process_status = p_process_status OR p_process_status IS NULL)
633: AND org_id = G_CURRENT_ORG_ID;
634:
635: -- Below Added for FAR/DFAR Content Import
636: DELETE FROM OKC_VARIABLES_INTERFACE
637: WHERE last_update_date >= trunc(l_start_date)
638: AND last_update_date <= l_end_date
639: AND (batch_number = p_batch_number OR p_batch_number IS NULL)
640: AND (process_status = p_process_status OR p_process_status IS NULL)

Line 4449: FROM OKC_VARIABLES_INTERFACE VARINT, OKC_BUS_VARIABLES_B VAR,

4445: VARINT.ATTRIBUTE15 ,
4446: VAR.VARIABLE_CODE EXISTING_CODE,
4447: VAR.DATE_PUBLISHED EXISTING_DPUBLISHED,
4448: VARTL.LANGUAGE EXISTING_LANGUAGE
4449: FROM OKC_VARIABLES_INTERFACE VARINT, OKC_BUS_VARIABLES_B VAR,
4450: OKC_BUS_VARIABLES_TL VARTL
4451: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
4452: AND BATCH_NUMBER = cp_batch_number
4453: AND RTRIM(VARINT.VARIABLE_CODE) = VAR.VARIABLE_CODE(+)

Line 4512: TYPE l_vinf_interface_id IS TABLE OF OKC_VARIABLES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;

4508: AND language_code = lang_code;
4509:
4510: -- Variable Interface Rows
4511:
4512: TYPE l_vinf_interface_id IS TABLE OF OKC_VARIABLES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
4513: TYPE l_vinf_batch_number IS TABLE OF OKC_VARIABLES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4514: TYPE l_vinf_object_version_number IS TABLE OF OKC_VARIABLES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;

Line 4513: TYPE l_vinf_batch_number IS TABLE OF OKC_VARIABLES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

4509:
4510: -- Variable Interface Rows
4511:
4512: TYPE l_vinf_interface_id IS TABLE OF OKC_VARIABLES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
4513: TYPE l_vinf_batch_number IS TABLE OF OKC_VARIABLES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4514: TYPE l_vinf_object_version_number IS TABLE OF OKC_VARIABLES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;
4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

Line 4514: TYPE l_vinf_object_version_number IS TABLE OF OKC_VARIABLES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

4510: -- Variable Interface Rows
4511:
4512: TYPE l_vinf_interface_id IS TABLE OF OKC_VARIABLES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
4513: TYPE l_vinf_batch_number IS TABLE OF OKC_VARIABLES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4514: TYPE l_vinf_object_version_number IS TABLE OF OKC_VARIABLES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;
4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

Line 4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;

4511:
4512: TYPE l_vinf_interface_id IS TABLE OF OKC_VARIABLES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
4513: TYPE l_vinf_batch_number IS TABLE OF OKC_VARIABLES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4514: TYPE l_vinf_object_version_number IS TABLE OF OKC_VARIABLES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;
4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;

Line 4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;

4512: TYPE l_vinf_interface_id IS TABLE OF OKC_VARIABLES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
4513: TYPE l_vinf_batch_number IS TABLE OF OKC_VARIABLES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4514: TYPE l_vinf_object_version_number IS TABLE OF OKC_VARIABLES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;
4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

Line 4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

4513: TYPE l_vinf_batch_number IS TABLE OF OKC_VARIABLES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4514: TYPE l_vinf_object_version_number IS TABLE OF OKC_VARIABLES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;
4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

Line 4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

4514: TYPE l_vinf_object_version_number IS TABLE OF OKC_VARIABLES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;
4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;

Line 4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;

4515: TYPE l_vinf_variable_code IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;
4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;

Line 4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

4516: TYPE l_vinf_variable_name IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER ;
4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;
4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;

Line 4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

4517: TYPE l_vinf_process_status IS TABLE OF OKC_VARIABLES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;
4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;

Line 4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;

4518: TYPE l_vinf_action IS TABLE OF OKC_VARIABLES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;
4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;
4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;

Line 4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;

4519: TYPE l_vinf_language IS TABLE OF OKC_VARIABLES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;
4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;
4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;
4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;

Line 4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;

4520: TYPE l_vinf_description IS TABLE OF OKC_VARIABLES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;
4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;
4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;
4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;
4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;

4521: TYPE l_vinf_variable_type IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;
4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;
4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;
4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;
4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;
4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;

Line 4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;

4522: TYPE l_vinf_variable_intent IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;
4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;
4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;
4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;
4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;
4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;

Line 4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;

4523: TYPE l_vinf_contract_expert_yn IS TABLE OF OKC_VARIABLES_INTERFACE.CONTRACT_EXPERT_YN%TYPE INDEX BY BINARY_INTEGER ;
4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;
4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;
4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;
4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;
4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;
4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;

Line 4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;

4524: TYPE l_vinf_xprt_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.XPRT_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;
4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;
4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;
4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;
4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;
4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;

Line 4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;

4525: TYPE l_vinf_disabled_yn IS TABLE OF OKC_VARIABLES_INTERFACE.DISABLED_YN%TYPE INDEX BY BINARY_INTEGER ;
4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;
4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;
4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;
4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;
4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;

Line 4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;

4526: TYPE l_vinf_external_yn IS TABLE OF OKC_VARIABLES_INTERFACE.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER ;
4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;
4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;
4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;
4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;

Line 4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;

4527: TYPE l_vinf_variable_datatype IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER ;
4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;
4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;
4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;

Line 4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;

4528: TYPE l_vinf_application_id IS TABLE OF OKC_VARIABLES_INTERFACE.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER ;
4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;
4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;

Line 4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;

4529: TYPE l_vinf_value_set_name IS TABLE OF OKC_VARIABLES_INTERFACE.VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;
4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;

Line 4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;

4530: TYPE l_vinf_var_default_value IS TABLE OF OKC_VARIABLES_INTERFACE.VARIABLE_DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER ;
4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;

Line 4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;

4531: TYPE l_vinf_system_reference_code IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;

Line 4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;

4532: TYPE l_vinf_system_reference_id1 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;

Line 4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;

4533: TYPE l_vinf_system_reference_id2 IS TABLE OF OKC_VARIABLES_INTERFACE.ORIG_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;

Line 4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;

4534: TYPE l_vinf_date_published IS TABLE OF OKC_VARIABLES_INTERFACE.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;

Line 4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;

4535: TYPE l_vinf_attribute_category IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;

Line 4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;

4536: TYPE l_vinf_attribute1 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;

Line 4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;

4537: TYPE l_vinf_attribute2 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;

Line 4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;

4538: TYPE l_vinf_attribute3 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;

Line 4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;

4539: TYPE l_vinf_attribute4 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;

Line 4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;

4540: TYPE l_vinf_attribute5 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
4548: TYPE l_vinf_attribute13 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;

Line 4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;

4541: TYPE l_vinf_attribute6 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
4548: TYPE l_vinf_attribute13 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
4549: TYPE l_vinf_attribute14 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;

Line 4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;

4542: TYPE l_vinf_attribute7 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
4548: TYPE l_vinf_attribute13 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
4549: TYPE l_vinf_attribute14 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
4550: TYPE l_vinf_attribute15 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;

Line 4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;

4543: TYPE l_vinf_attribute8 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
4548: TYPE l_vinf_attribute13 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
4549: TYPE l_vinf_attribute14 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
4550: TYPE l_vinf_attribute15 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
4551:

Line 4548: TYPE l_vinf_attribute13 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;

4544: TYPE l_vinf_attribute9 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
4548: TYPE l_vinf_attribute13 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
4549: TYPE l_vinf_attribute14 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
4550: TYPE l_vinf_attribute15 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
4551:
4552:

Line 4549: TYPE l_vinf_attribute14 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;

4545: TYPE l_vinf_attribute10 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
4548: TYPE l_vinf_attribute13 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
4549: TYPE l_vinf_attribute14 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
4550: TYPE l_vinf_attribute15 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
4551:
4552:
4553: TYPE l_vinf_existing_code IS TABLE OF OKC_BUS_VARIABLES_B.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;

Line 4550: TYPE l_vinf_attribute15 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;

4546: TYPE l_vinf_attribute11 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
4547: TYPE l_vinf_attribute12 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
4548: TYPE l_vinf_attribute13 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
4549: TYPE l_vinf_attribute14 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
4550: TYPE l_vinf_attribute15 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
4551:
4552:
4553: TYPE l_vinf_existing_code IS TABLE OF OKC_BUS_VARIABLES_B.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4554: TYPE l_vinf_existing_dpublished IS TABLE OF OKC_BUS_VARIABLES_B.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;

Line 4623: l_program_id OKC_VARIABLES_INTERFACE.PROGRAM_ID%TYPE;

4619: I NUMBER := 0;
4620: j NUMBER := 0;
4621: k NUMBER := 0;
4622: x NUMBER := 0;
4623: l_program_id OKC_VARIABLES_INTERFACE.PROGRAM_ID%TYPE;
4624: l_program_login_id OKC_VARIABLES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
4625: l_program_appl_id OKC_VARIABLES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
4626: l_request_id OKC_VARIABLES_INTERFACE.REQUEST_ID%TYPE;
4627: l_dummy_unq VARCHAR2(1) := '?';

Line 4624: l_program_login_id OKC_VARIABLES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;

4620: j NUMBER := 0;
4621: k NUMBER := 0;
4622: x NUMBER := 0;
4623: l_program_id OKC_VARIABLES_INTERFACE.PROGRAM_ID%TYPE;
4624: l_program_login_id OKC_VARIABLES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
4625: l_program_appl_id OKC_VARIABLES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
4626: l_request_id OKC_VARIABLES_INTERFACE.REQUEST_ID%TYPE;
4627: l_dummy_unq VARCHAR2(1) := '?';
4628: l_dummy VARCHAR2(1) := '?';

Line 4625: l_program_appl_id OKC_VARIABLES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;

4621: k NUMBER := 0;
4622: x NUMBER := 0;
4623: l_program_id OKC_VARIABLES_INTERFACE.PROGRAM_ID%TYPE;
4624: l_program_login_id OKC_VARIABLES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
4625: l_program_appl_id OKC_VARIABLES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
4626: l_request_id OKC_VARIABLES_INTERFACE.REQUEST_ID%TYPE;
4627: l_dummy_unq VARCHAR2(1) := '?';
4628: l_dummy VARCHAR2(1) := '?';
4629: l_vs_id VARCHAR2(1) := NULL;

Line 4626: l_request_id OKC_VARIABLES_INTERFACE.REQUEST_ID%TYPE;

4622: x NUMBER := 0;
4623: l_program_id OKC_VARIABLES_INTERFACE.PROGRAM_ID%TYPE;
4624: l_program_login_id OKC_VARIABLES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
4625: l_program_appl_id OKC_VARIABLES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
4626: l_request_id OKC_VARIABLES_INTERFACE.REQUEST_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) := '?';

Line 5579: UPDATE OKC_VARIABLES_INTERFACE

5575: i:=0;
5576: BEGIN
5577: l_context := 'UPDATING VARIABLES INTERFACE TABLE';
5578: FORALL i in vinf_interface_id_tbl.FIRST..vinf_interface_id_tbl.LAST
5579: UPDATE OKC_VARIABLES_INTERFACE
5580: SET
5581: -- We don't want to update process_status to 'S' or 'W' in validation_mode
5582: -- because it is not going to be picked up in next run if we do so
5583: PROCESS_STATUS = decode(p_validate_only||vinf_process_status_tbl(i)||l_bulk_failed,

Line 5638: -- End of Update OKC_VARIABLES_INTERFACE

5634:
5635: --RAISE FND_API.G_EXC_ERROR ;
5636: END;
5637: --
5638: -- End of Update OKC_VARIABLES_INTERFACE
5639: --
5640: --
5641:
5642: --

Line 5765: OKC_VARIABLES_INTERFACE VARI

5761: LANG.LANGUAGE_CODE,
5762: VART.SOURCE_LANG
5763: FROM OKC_BUS_VARIABLES_TL VART,
5764: FND_LANGUAGES LANG,
5765: OKC_VARIABLES_INTERFACE VARI
5766: WHERE LANG.INSTALLED_FLAG IN ('I', 'B')
5767: AND VART.VARIABLE_CODE = RTRIM(VARI.VARIABLE_CODE)
5768: AND NVL(VARI.PROCESS_STATUS,'*') = 'S'
5769: AND VARI.BATCH_NUMBER = p_batch_number

Line 5780: FROM OKC_VARIABLES_INTERFACE VARI1

5776: AND VART.ROWID = (SELECT MIN(VART2.ROWID)
5777: FROM OKC_BUS_VARIABLES_TL VART2
5778: WHERE VART2.VARIABLE_CODE = VART.VARIABLE_CODE)
5779: AND VARI.ROWID = (SELECT MIN(VARI1.ROWID)
5780: FROM OKC_VARIABLES_INTERFACE VARI1
5781: WHERE RTRIM(VARI1.VARIABLE_CODE) = RTRIM(VARI.VARIABLE_CODE)
5782: AND VARI1.ACTION <> 'D'
5783: AND VARI1.BATCH_NUMBER = VARI.BATCH_NUMBER
5784: AND NVL(VARI1.PROCESS_STATUS,'*') = 'S');