[Home] [Help]
5973: CURSOR l_rel_exist_csr (cp_src_article_id IN NUMBER,
5974: cp_tar_article_id IN NUMBER,
5975: cp_org_id IN NUMBER,
5976: cp_rel_type IN VARCHAR2) IS
5977: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL
5978: WHERE source_article_id = cp_src_article_id
5979: AND target_article_id = cp_tar_article_id
5980: AND org_id = cp_org_id
5981: AND relationship_type = cp_rel_type;
6635: BEGIN
6636: l_context := 'INSERTING FIRST NEW RELATIONSHIP INTO TABLE';
6637:
6638: FORALL i in rinf_interface_id_tbl.FIRST ..rinf_interface_id_tbl.LAST
6639: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
6640: SOURCE_ARTICLE_ID,
6641: TARGET_ARTICLE_ID,
6642: ORG_ID,
6643: RELATIONSHIP_TYPE,
6663: rinf_process_status_tbl(i) in ('S', 'W') ;
6664:
6665:
6666: FORALL i in rinf_interface_id_tbl.FIRST ..rinf_interface_id_tbl.LAST
6667: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
6668: TARGET_ARTICLE_ID,
6669: SOURCE_ARTICLE_ID,
6670: ORG_ID,
6671: RELATIONSHIP_TYPE,
6696: END IF;
6697: END;
6698:
6699: --
6700: -- End of Insert into OKC_ARTICLE_RELATNS_ALL
6701: --
6702: --
6703:
6704:
6707: BEGIN
6708: l_context := 'DELETE RELATIONSHIP FROM TABLE';
6709:
6710: FORALL i in rinf_interface_id_tbl.FIRST ..rinf_interface_id_tbl.LAST
6711: DELETE FROM OKC_ARTICLE_RELATNS_ALL
6712: WHERE
6713: SOURCE_ARTICLE_ID = rinf_source_article_id_tbl(i) AND
6714: TARGET_ARTICLE_ID = rinf_target_article_id_tbl(i) AND
6715: ORG_ID = rinf_org_id_tbl(i) AND
6718: rinf_process_status_tbl(i) in ('S', 'W') ;
6719:
6720:
6721: FORALL i in rinf_interface_id_tbl.FIRST ..rinf_interface_id_tbl.LAST
6722: DELETE FROM OKC_ARTICLE_RELATNS_ALL
6723: WHERE
6724: TARGET_ARTICLE_ID = rinf_source_article_id_tbl(i) AND
6725: SOURCE_ARTICLE_ID = rinf_target_article_id_tbl(i) AND
6726: ORG_ID = rinf_org_id_tbl(i) AND
6735: END IF;
6736: END;
6737:
6738: --
6739: -- End of Delete from OKC_ARTICLE_RELATNS_ALL
6740: --
6741: --
6742:
6743: