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_ART_INT_ERRORS

Line 39: TYPE list_err_batch_process_id IS TABLE OF OKC_ART_INT_ERRORS.BATCH_PROCESS_ID%TYPE INDEX BY BINARY_INTEGER ;

35: G_CURRENT_ORG_ID NUMBER ;
36: G_FETCHSIZE_LIMIT NUMBER := 300;
37:
38: -- For Error
39: TYPE list_err_batch_process_id IS TABLE OF OKC_ART_INT_ERRORS.BATCH_PROCESS_ID%TYPE INDEX BY BINARY_INTEGER ;
40: TYPE list_err_interface_id IS TABLE OF OKC_ART_INT_ERRORS.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
41: TYPE list_err_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

Line 40: TYPE list_err_interface_id IS TABLE OF OKC_ART_INT_ERRORS.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;

36: G_FETCHSIZE_LIMIT NUMBER := 300;
37:
38: -- For Error
39: TYPE list_err_batch_process_id IS TABLE OF OKC_ART_INT_ERRORS.BATCH_PROCESS_ID%TYPE INDEX BY BINARY_INTEGER ;
40: TYPE list_err_interface_id IS TABLE OF OKC_ART_INT_ERRORS.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
41: TYPE list_err_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE list_err_error_type IS TABLE OF OKC_ART_INT_ERRORS.ERROR_TYPE%TYPE INDEX BY BINARY_INTEGER ;

Line 42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

38: -- For Error
39: TYPE list_err_batch_process_id IS TABLE OF OKC_ART_INT_ERRORS.BATCH_PROCESS_ID%TYPE INDEX BY BINARY_INTEGER ;
40: TYPE list_err_interface_id IS TABLE OF OKC_ART_INT_ERRORS.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
41: TYPE list_err_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE list_err_error_type IS TABLE OF OKC_ART_INT_ERRORS.ERROR_TYPE%TYPE INDEX BY BINARY_INTEGER ;
45: TYPE list_err_error_description IS TABLE OF OKC_ART_INT_ERRORS.ERROR_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
46: TYPE list_err_entity IS TABLE OF OKC_ART_INT_ERRORS.ENTITY%TYPE INDEX BY BINARY_INTEGER ;

Line 43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

39: TYPE list_err_batch_process_id IS TABLE OF OKC_ART_INT_ERRORS.BATCH_PROCESS_ID%TYPE INDEX BY BINARY_INTEGER ;
40: TYPE list_err_interface_id IS TABLE OF OKC_ART_INT_ERRORS.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
41: TYPE list_err_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE list_err_error_type IS TABLE OF OKC_ART_INT_ERRORS.ERROR_TYPE%TYPE INDEX BY BINARY_INTEGER ;
45: TYPE list_err_error_description IS TABLE OF OKC_ART_INT_ERRORS.ERROR_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
46: TYPE list_err_entity IS TABLE OF OKC_ART_INT_ERRORS.ENTITY%TYPE INDEX BY BINARY_INTEGER ;
47:

Line 44: TYPE list_err_error_type IS TABLE OF OKC_ART_INT_ERRORS.ERROR_TYPE%TYPE INDEX BY BINARY_INTEGER ;

40: TYPE list_err_interface_id IS TABLE OF OKC_ART_INT_ERRORS.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
41: TYPE list_err_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE list_err_error_type IS TABLE OF OKC_ART_INT_ERRORS.ERROR_TYPE%TYPE INDEX BY BINARY_INTEGER ;
45: TYPE list_err_error_description IS TABLE OF OKC_ART_INT_ERRORS.ERROR_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
46: TYPE list_err_entity IS TABLE OF OKC_ART_INT_ERRORS.ENTITY%TYPE INDEX BY BINARY_INTEGER ;
47:
48: err_batch_process_id_tbl list_err_batch_process_id ;

Line 45: TYPE list_err_error_description IS TABLE OF OKC_ART_INT_ERRORS.ERROR_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

41: TYPE list_err_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE list_err_error_type IS TABLE OF OKC_ART_INT_ERRORS.ERROR_TYPE%TYPE INDEX BY BINARY_INTEGER ;
45: TYPE list_err_error_description IS TABLE OF OKC_ART_INT_ERRORS.ERROR_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
46: TYPE list_err_entity IS TABLE OF OKC_ART_INT_ERRORS.ENTITY%TYPE INDEX BY BINARY_INTEGER ;
47:
48: err_batch_process_id_tbl list_err_batch_process_id ;
49: err_interface_id_tbl list_err_interface_id ;

Line 46: TYPE list_err_entity IS TABLE OF OKC_ART_INT_ERRORS.ENTITY%TYPE INDEX BY BINARY_INTEGER ;

42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE list_err_error_type IS TABLE OF OKC_ART_INT_ERRORS.ERROR_TYPE%TYPE INDEX BY BINARY_INTEGER ;
45: TYPE list_err_error_description IS TABLE OF OKC_ART_INT_ERRORS.ERROR_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
46: TYPE list_err_entity IS TABLE OF OKC_ART_INT_ERRORS.ENTITY%TYPE INDEX BY BINARY_INTEGER ;
47:
48: err_batch_process_id_tbl list_err_batch_process_id ;
49: err_interface_id_tbl list_err_interface_id ;
50: err_article_title_tbl list_err_article_title ;

Line 198: from okc_art_int_errors a,okc_art_interface_all b,

194: CURSOR get_art_info_csr IS
195: SELECT a.interface_id,a.entity,error_description,
196: b.article_title,b.article_number,
197: hr.name org_name
198: from okc_art_int_errors a,okc_art_interface_all b,
199: hr_organization_units hr
200: where a.interface_id = b.interface_id
201: and b.org_id = hr.organization_id
202: and b.batch_number = p_batch_number

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 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 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 241: from okc_art_int_errors a,okc_art_rels_interface b,

237: CURSOR get_rel_info_csr IS
238: SELECT a.interface_id,a.entity,error_description,
239: b.source_article_title,b.target_article_title,relationship_type,
240: hr.name org_name
241: from okc_art_int_errors a,okc_art_rels_interface b,
242: hr_organization_units hr
243: where a.interface_id = b.interface_id
244: and b.batch_number = p_batch_number
245: and a.batch_process_id = p_batch_procs_id

Line 599: DELETE FROM OKC_ART_INT_ERRORS

595: AND p_process_status is NULL
596: AND p_batch_number is NULL) THEN
597: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
598: p_msg_name => 'OKC_ART_WARN_PUR_ALL_DELETED');
599: DELETE FROM OKC_ART_INT_ERRORS
600: WHERE batch_process_id in
601: ( SELECT batch_process_id
602: FROM OKC_ART_INT_BATPROCS_ALL
603: WHERE org_id = G_CURRENT_ORG_ID

Line 620: DELETE FROM OKC_ART_INT_ERRORS

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
622: FROM OKC_ART_INTERFACE_ALL
623: WHERE last_update_date >= trunc(l_start_date)
624: AND last_update_date <= l_end_date

Line 662: DELETE FROM OKC_ART_INT_ERRORS

658: AND (process_status = p_process_status OR p_process_status IS NULL)
659: ;
660: -- this will clean the remaining error not related to interface_id
661: -- such as SQL exception etc.
662: DELETE FROM OKC_ART_INT_ERRORS
663: WHERE batch_process_id in ( SELECT batch_process_id
664: FROM OKC_ART_INT_BATPROCS_ALL
665: WHERE org_id = G_CURRENT_ORG_ID
666: AND batch_number not in

Line 1399: l_program_id OKC_ART_INT_ERRORS.PROGRAM_ID%TYPE;

1395: x_msg_data OUT NOCOPY VARCHAR2
1396: )IS
1397: l_user_id NUMBER;
1398: l_login_id NUMBER;
1399: l_program_id OKC_ART_INT_ERRORS.PROGRAM_ID%TYPE;
1400: l_program_login_id OKC_ART_INT_ERRORS.PROGRAM_LOGIN_ID%TYPE;
1401: l_program_appl_id OKC_ART_INT_ERRORS.PROGRAM_APPLICATION_ID%TYPE;
1402: l_request_id OKC_ART_INT_ERRORS.REQUEST_ID%TYPE;
1403: i_err NUMBER :=0;

Line 1400: l_program_login_id OKC_ART_INT_ERRORS.PROGRAM_LOGIN_ID%TYPE;

1396: )IS
1397: l_user_id NUMBER;
1398: l_login_id NUMBER;
1399: l_program_id OKC_ART_INT_ERRORS.PROGRAM_ID%TYPE;
1400: l_program_login_id OKC_ART_INT_ERRORS.PROGRAM_LOGIN_ID%TYPE;
1401: l_program_appl_id OKC_ART_INT_ERRORS.PROGRAM_APPLICATION_ID%TYPE;
1402: l_request_id OKC_ART_INT_ERRORS.REQUEST_ID%TYPE;
1403: i_err NUMBER :=0;
1404: cur_inf_id NUMBER :=0;

Line 1401: l_program_appl_id OKC_ART_INT_ERRORS.PROGRAM_APPLICATION_ID%TYPE;

1397: l_user_id NUMBER;
1398: l_login_id NUMBER;
1399: l_program_id OKC_ART_INT_ERRORS.PROGRAM_ID%TYPE;
1400: l_program_login_id OKC_ART_INT_ERRORS.PROGRAM_LOGIN_ID%TYPE;
1401: l_program_appl_id OKC_ART_INT_ERRORS.PROGRAM_APPLICATION_ID%TYPE;
1402: l_request_id OKC_ART_INT_ERRORS.REQUEST_ID%TYPE;
1403: i_err NUMBER :=0;
1404: cur_inf_id NUMBER :=0;
1405: cur_inf_id1 NUMBER :=0;

Line 1402: l_request_id OKC_ART_INT_ERRORS.REQUEST_ID%TYPE;

1398: l_login_id NUMBER;
1399: l_program_id OKC_ART_INT_ERRORS.PROGRAM_ID%TYPE;
1400: l_program_login_id OKC_ART_INT_ERRORS.PROGRAM_LOGIN_ID%TYPE;
1401: l_program_appl_id OKC_ART_INT_ERRORS.PROGRAM_APPLICATION_ID%TYPE;
1402: l_request_id OKC_ART_INT_ERRORS.REQUEST_ID%TYPE;
1403: i_err NUMBER :=0;
1404: cur_inf_id NUMBER :=0;
1405: cur_inf_id1 NUMBER :=0;
1406: l_insert_errors_exception EXCEPTION;

Line 1441: INSERT INTO OKC_ART_INT_ERRORS

1437: FOR i_err in err_batch_process_id_tbl.FIRST
1438: .. err_batch_process_id_tbl.LAST LOOP
1439:
1440:
1441: INSERT INTO OKC_ART_INT_ERRORS
1442: (
1443: BATCH_PROCESS_ID,
1444: INTERFACE_ID,
1445: ERROR_NUMBER,