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_VS_VALUES_INTERFACE

Line 220: from okc_art_int_errors a,okc_vs_values_interface b

216:
217: CURSOR get_val_info_csr IS
218: SELECT a.interface_id,a.entity,error_description,
219: b.flex_value,b.flex_value_set_name
220: from okc_art_int_errors a,okc_vs_values_interface b
221: where a.interface_id = b.interface_id
222: and b.batch_number = p_batch_number
223: and a.batch_process_id = p_batch_procs_id
224: and a.entity = p_entity

Line 617: DELETE FROM OKC_VS_VALUES_INTERFACE ;

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
621: WHERE interface_id in ( SELECT interface_id

Line 654: DELETE FROM OKC_VS_VALUES_INTERFACE

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)
653: ;
654: DELETE FROM OKC_VS_VALUES_INTERFACE
655: WHERE last_update_date >= trunc(l_start_date)
656: AND last_update_date <= l_end_date
657: AND (batch_number = p_batch_number OR p_batch_number IS NULL)
658: AND (process_status = p_process_status OR p_process_status IS NULL)

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 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 8086: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;

8082:
8083:
8084: -- Flex Values Interface Rows
8085:
8086: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8087: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8088: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;

Line 8087: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

8083:
8084: -- Flex Values Interface Rows
8085:
8086: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8087: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8088: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

Line 8088: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

8084: -- Flex Values Interface Rows
8085:
8086: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8087: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8088: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

Line 8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;

8085:
8086: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8087: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8088: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

Line 8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;

8086: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8087: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8088: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;

Line 8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

8087: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8088: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;

Line 8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

8088: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8096: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;

Line 8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

8089: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8096: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8097: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

Line 8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;

8090: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8096: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8097: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%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 ;

Line 8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;

8091: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8096: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8097: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%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:

Line 8096: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;

8092: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8096: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8097: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%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:

Line 8097: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

8093: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8096: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8097: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%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 ;

Line 8098: TYPE l_vinf_flex_value_meaning IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_MEANING%TYPE INDEX BY BINARY_INTEGER ;

8094: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8095: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8096: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8097: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%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 ;

Line 8114: TYPE l_vinf_flex_value_orig IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%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:
8116: l_return_status VARCHAR2(1);
8117: l_error_index NUMBER := 1;
8118: l_batch_process_id NUMBER := 1;

Line 8162: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;

8158: I NUMBER := 0;
8159: j NUMBER := 0;
8160: k NUMBER := 0;
8161: x NUMBER := 0;
8162: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;
8163: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
8164: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
8165: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;
8166: l_rowid ROWID;

Line 8163: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;

8159: j NUMBER := 0;
8160: k NUMBER := 0;
8161: x NUMBER := 0;
8162: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;
8163: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
8164: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
8165: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;
8166: l_rowid ROWID;
8167: api_return_status VARCHAR2(1);

Line 8164: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;

8160: k NUMBER := 0;
8161: x NUMBER := 0;
8162: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;
8163: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
8164: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
8165: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;
8166: l_rowid ROWID;
8167: api_return_status VARCHAR2(1);
8168: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 8165: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;

8161: x NUMBER := 0;
8162: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;
8163: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
8164: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
8165: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;
8166: l_rowid ROWID;
8167: api_return_status VARCHAR2(1);
8168: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
8169: l_display_value VARCHAR2(2000);

Line 8862: UPDATE OKC_VS_VALUES_INTERFACE

8858: i:=0;
8859: BEGIN
8860: l_context := 'UPDATING VALUES INTERFACE TABLE';
8861: FORALL i in vinf_interface_id_tbl.FIRST..vinf_interface_id_tbl.LAST
8862: UPDATE OKC_VS_VALUES_INTERFACE
8863: SET
8864: -- We don't want to update process_status to 'S' or 'W' in validation_mode
8865: -- because it is not going to be picked up in next run if we do so
8866: PROCESS_STATUS = decode(p_validate_only||vinf_process_status_tbl(i)||l_bulk_failed,

Line 8922: -- End of Update OKC_VS_VALUES_INTERFACE

8918:
8919: --RAISE FND_API.G_EXC_ERROR ;
8920: END;
8921: --
8922: -- End of Update OKC_VS_VALUES_INTERFACE
8923: --
8924: --
8925:
8926: --