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 8088: FROM OKC_VS_VALUES_INTERFACE VINT,FND_FLEX_VALUE_SETS VS

8084: VS.NUMERIC_MODE_ENABLED_FLAG,
8085: VS.MINIMUM_VALUE ,
8086: VS.MAXIMUM_VALUE ,
8087: TO_NUMBER(NULL) FLEX_VALUE_ID
8088: FROM OKC_VS_VALUES_INTERFACE VINT,FND_FLEX_VALUE_SETS VS
8089: WHERE VINT.FLEX_VALUE_SET_NAME = VS.FLEX_VALUE_SET_NAME
8090: AND nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
8091: AND BATCH_NUMBER = cp_batch_number
8092: UNION ALL

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

8150:
8151:
8152: -- Flex Values Interface Rows
8153:
8154: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8155: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8156: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8157: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;

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

8151:
8152: -- Flex Values Interface Rows
8153:
8154: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8155: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8156: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8157: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

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

8152: -- Flex Values Interface Rows
8153:
8154: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8155: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8156: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8157: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

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

8153:
8154: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8155: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8156: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8157: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;

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

8154: TYPE l_vinf_interface_id IS TABLE OF OKC_VS_VALUES_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
8155: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8156: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8157: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;

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

8155: TYPE l_vinf_batch_number IS TABLE OF OKC_VS_VALUES_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8156: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8157: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8163: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;

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

8156: TYPE l_vinf_obj_ver_number IS TABLE OF OKC_VS_VALUES_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
8157: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8163: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8164: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;

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

8157: TYPE l_vinf_flex_value_set_name IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_SET_NAME%TYPE INDEX BY BINARY_INTEGER ;
8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8163: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8164: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8165: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

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

8158: TYPE l_vinf_flex_value IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8163: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8164: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8165: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
8166: TYPE l_vinf_flex_value_meaning IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_MEANING%TYPE INDEX BY BINARY_INTEGER ;

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

8159: TYPE l_vinf_process_status IS TABLE OF OKC_VS_VALUES_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8163: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8164: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8165: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
8166: TYPE l_vinf_flex_value_meaning IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_MEANING%TYPE INDEX BY BINARY_INTEGER ;
8167:

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

8160: TYPE l_vinf_action IS TABLE OF OKC_VS_VALUES_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8163: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8164: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8165: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
8166: TYPE l_vinf_flex_value_meaning IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_MEANING%TYPE INDEX BY BINARY_INTEGER ;
8167:
8168:

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

8161: TYPE l_vinf_enabled_flag IS TABLE OF OKC_VS_VALUES_INTERFACE.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER ;
8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8163: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8164: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8165: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
8166: TYPE l_vinf_flex_value_meaning IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_MEANING%TYPE INDEX BY BINARY_INTEGER ;
8167:
8168:
8169: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;

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

8162: TYPE l_vinf_start_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8163: TYPE l_vinf_end_date_active IS TABLE OF OKC_VS_VALUES_INTERFACE.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER ;
8164: TYPE l_vinf_language IS TABLE OF OKC_VS_VALUES_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
8165: TYPE l_vinf_description IS TABLE OF OKC_VS_VALUES_INTERFACE.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
8166: TYPE l_vinf_flex_value_meaning IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE_MEANING%TYPE INDEX BY BINARY_INTEGER ;
8167:
8168:
8169: TYPE l_vinf_flex_value_id IS TABLE OF FND_FLEX_VALUES.flex_value_id%TYPE INDEX BY BINARY_INTEGER ;
8170: TYPE l_vinf_value_set_id IS TABLE OF FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER ;

Line 8182: TYPE l_vinf_flex_value_orig IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;

8178: TYPE l_vinf_maximum_value IS TABLE OF FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8179: TYPE l_vinf_minimum_value IS TABLE OF FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8180:
8181:
8182: TYPE l_vinf_flex_value_orig IS TABLE OF OKC_VS_VALUES_INTERFACE.FLEX_VALUE%TYPE INDEX BY BINARY_INTEGER ;
8183:
8184: l_return_status VARCHAR2(1);
8185: l_error_index NUMBER := 1;
8186: l_batch_process_id NUMBER := 1;

Line 8230: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;

8226: I NUMBER := 0;
8227: j NUMBER := 0;
8228: k NUMBER := 0;
8229: x NUMBER := 0;
8230: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;
8231: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
8232: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
8233: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;
8234: l_rowid ROWID;

Line 8231: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;

8227: j NUMBER := 0;
8228: k NUMBER := 0;
8229: x NUMBER := 0;
8230: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;
8231: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
8232: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
8233: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;
8234: l_rowid ROWID;
8235: api_return_status VARCHAR2(1);

Line 8232: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;

8228: k NUMBER := 0;
8229: x NUMBER := 0;
8230: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;
8231: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
8232: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
8233: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;
8234: l_rowid ROWID;
8235: api_return_status VARCHAR2(1);
8236: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 8233: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;

8229: x NUMBER := 0;
8230: l_program_id OKC_VS_VALUES_INTERFACE.PROGRAM_ID%TYPE;
8231: l_program_login_id OKC_VS_VALUES_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
8232: l_program_appl_id OKC_VS_VALUES_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
8233: l_request_id OKC_VS_VALUES_INTERFACE.REQUEST_ID%TYPE;
8234: l_rowid ROWID;
8235: api_return_status VARCHAR2(1);
8236: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
8237: l_display_value VARCHAR2(2000);

Line 8930: UPDATE OKC_VS_VALUES_INTERFACE

8926: i:=0;
8927: BEGIN
8928: l_context := 'UPDATING VALUES INTERFACE TABLE';
8929: FORALL i in vinf_interface_id_tbl.FIRST..vinf_interface_id_tbl.LAST
8930: UPDATE OKC_VS_VALUES_INTERFACE
8931: SET
8932: -- We don't want to update process_status to 'S' or 'W' in validation_mode
8933: -- because it is not going to be picked up in next run if we do so
8934: PROCESS_STATUS = decode(p_validate_only||vinf_process_status_tbl(i)||l_bulk_failed,

Line 8990: -- End of Update OKC_VS_VALUES_INTERFACE

8986:
8987: --RAISE FND_API.G_EXC_ERROR ;
8988: END;
8989: --
8990: -- End of Update OKC_VS_VALUES_INTERFACE
8991: --
8992: --
8993:
8994: --