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_RELS_INTERFACE

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 547: FROM okc_art_rels_interface a,hr_organization_units hr

543: AND batch_number = p_batch_number
544: AND a.org_id = hr.organization_id(+)
545: UNION ALL
546: SELECT DISTINCT a.org_id org_id,nvl(hr.name,' ') org_name
547: FROM okc_art_rels_interface a,hr_organization_units hr
548: WHERE a.org_id IS NOT NULL
549: AND batch_number = p_batch_number
550: AND a.org_id = hr.organization_id(+)
551: AND NOT EXISTS

Line 614: DELETE FROM OKC_ART_RELS_INTERFACE

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 ;
618:

Line 642: DELETE FROM OKC_ART_RELS_INTERFACE

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)
641: ;
642: DELETE FROM OKC_ART_RELS_INTERFACE
643: WHERE last_update_date >= trunc(l_start_date)
644: AND last_update_date <= l_end_date
645: AND (batch_number = p_batch_number OR p_batch_number IS NULL)
646: AND (process_status = p_process_status OR p_process_status IS NULL)

Line 768: FROM okc_art_rels_interface a,hr_organization_units hr

764: AND batch_number = p_batch_number
765: AND a.org_id = hr.organization_id(+)
766: UNION ALL
767: SELECT DISTINCT a.org_id org_id,nvl(hr.name,' ') org_name
768: FROM okc_art_rels_interface a,hr_organization_units hr
769: WHERE a.org_id IS NOT NULL
770: AND batch_number = p_batch_number
771: AND a.org_id = hr.organization_id(+)
772: AND NOT EXISTS

Line 5962: FROM OKC_ART_RELS_INTERFACE RELINT,

5958: RELS.ARTICLE_INTENT SOURCE_INTENT,
5959: RELS.ARTICLE_ID SOURCE_ARTICLE_ID ,
5960: RELT.ARTICLE_INTENT TARGET_INTENT,
5961: RELT.ARTICLE_ID TARGET_ARTICLE_ID
5962: FROM OKC_ART_RELS_INTERFACE RELINT,
5963: OKC_ARTICLES_ALL RELS, OKC_ARTICLES_ALL RELT
5964: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
5965: AND BATCH_NUMBER = cp_batch_number
5966: AND RELINT.ORG_ID = cp_local_org_id

Line 6009: TYPE l_rinf_interface_id IS TABLE OF OKC_ART_RELS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;

6005:
6006:
6007: -- Relationships Interface Rows
6008:
6009: TYPE l_rinf_interface_id IS TABLE OF OKC_ART_RELS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
6010: TYPE l_rinf_batch_number IS TABLE OF OKC_ART_RELS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6011: TYPE l_rinf_object_version_number IS TABLE OF OKC_ART_RELS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;

Line 6010: TYPE l_rinf_batch_number IS TABLE OF OKC_ART_RELS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

6006:
6007: -- Relationships Interface Rows
6008:
6009: TYPE l_rinf_interface_id IS TABLE OF OKC_ART_RELS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
6010: TYPE l_rinf_batch_number IS TABLE OF OKC_ART_RELS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6011: TYPE l_rinf_object_version_number IS TABLE OF OKC_ART_RELS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 6011: TYPE l_rinf_object_version_number IS TABLE OF OKC_ART_RELS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

6007: -- Relationships Interface Rows
6008:
6009: TYPE l_rinf_interface_id IS TABLE OF OKC_ART_RELS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
6010: TYPE l_rinf_batch_number IS TABLE OF OKC_ART_RELS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6011: TYPE l_rinf_object_version_number IS TABLE OF OKC_ART_RELS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;

Line 6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;

6008:
6009: TYPE l_rinf_interface_id IS TABLE OF OKC_ART_RELS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
6010: TYPE l_rinf_batch_number IS TABLE OF OKC_ART_RELS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6011: TYPE l_rinf_object_version_number IS TABLE OF OKC_ART_RELS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

Line 6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;

6009: TYPE l_rinf_interface_id IS TABLE OF OKC_ART_RELS_INTERFACE.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
6010: TYPE l_rinf_batch_number IS TABLE OF OKC_ART_RELS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6011: TYPE l_rinf_object_version_number IS TABLE OF OKC_ART_RELS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

Line 6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;

6010: TYPE l_rinf_batch_number IS TABLE OF OKC_ART_RELS_INTERFACE.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6011: TYPE l_rinf_object_version_number IS TABLE OF OKC_ART_RELS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
6018:

Line 6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;

6011: TYPE l_rinf_object_version_number IS TABLE OF OKC_ART_RELS_INTERFACE.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
6018:
6019: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

6012: TYPE l_rinf_source_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.SOURCE_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
6018:
6019: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6020: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;

Line 6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;

6013: TYPE l_rinf_target_article_title IS TABLE OF OKC_ART_RELS_INTERFACE.TARGET_ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
6014: TYPE l_rinf_org_id IS TABLE OF OKC_ART_RELS_INTERFACE.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
6018:
6019: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6020: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6021: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 6058: l_program_id OKC_ART_RELS_INTERFACE.PROGRAM_ID%TYPE;

6054: I NUMBER := 0;
6055: j NUMBER := 0;
6056: k NUMBER := 0;
6057: x NUMBER := 0;
6058: l_program_id OKC_ART_RELS_INTERFACE.PROGRAM_ID%TYPE;
6059: l_program_login_id OKC_ART_RELS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
6060: l_program_appl_id OKC_ART_RELS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
6061: l_request_id OKC_ART_RELS_INTERFACE.REQUEST_ID%TYPE;
6062: l_dummy VARCHAR2(1) := '2';

Line 6059: l_program_login_id OKC_ART_RELS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;

6055: j NUMBER := 0;
6056: k NUMBER := 0;
6057: x NUMBER := 0;
6058: l_program_id OKC_ART_RELS_INTERFACE.PROGRAM_ID%TYPE;
6059: l_program_login_id OKC_ART_RELS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
6060: l_program_appl_id OKC_ART_RELS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
6061: l_request_id OKC_ART_RELS_INTERFACE.REQUEST_ID%TYPE;
6062: l_dummy VARCHAR2(1) := '2';
6063: l_dummy1 VARCHAR2(1) := '3';

Line 6060: l_program_appl_id OKC_ART_RELS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;

6056: k NUMBER := 0;
6057: x NUMBER := 0;
6058: l_program_id OKC_ART_RELS_INTERFACE.PROGRAM_ID%TYPE;
6059: l_program_login_id OKC_ART_RELS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
6060: l_program_appl_id OKC_ART_RELS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
6061: l_request_id OKC_ART_RELS_INTERFACE.REQUEST_ID%TYPE;
6062: l_dummy VARCHAR2(1) := '2';
6063: l_dummy1 VARCHAR2(1) := '3';
6064: l_clause VARCHAR2(1) := NULL;

Line 6061: l_request_id OKC_ART_RELS_INTERFACE.REQUEST_ID%TYPE;

6057: x NUMBER := 0;
6058: l_program_id OKC_ART_RELS_INTERFACE.PROGRAM_ID%TYPE;
6059: l_program_login_id OKC_ART_RELS_INTERFACE.PROGRAM_LOGIN_ID%TYPE;
6060: l_program_appl_id OKC_ART_RELS_INTERFACE.PROGRAM_APPLICATION_ID%TYPE;
6061: l_request_id OKC_ART_RELS_INTERFACE.REQUEST_ID%TYPE;
6062: l_dummy VARCHAR2(1) := '2';
6063: l_dummy1 VARCHAR2(1) := '3';
6064: l_clause VARCHAR2(1) := NULL;
6065: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 6796: UPDATE OKC_ART_RELS_INTERFACE

6792: i:=0;
6793: BEGIN
6794: l_context := 'UPDATING RELATIONSHIPS INTERFACE TABLE';
6795: FORALL i in rinf_interface_id_tbl.FIRST..rinf_interface_id_tbl.LAST
6796: UPDATE OKC_ART_RELS_INTERFACE
6797: SET
6798: -- We don't want to update process_status to 'S' or 'W' in validation_mode
6799: -- because it is not going to be picked up in next run if we do so
6800: PROCESS_STATUS = decode(p_validate_only||rinf_process_status_tbl(i)||l_bulk_failed,