[Home] [Help]
5905: CURSOR l_rel_exist_csr (cp_src_article_id IN NUMBER,
5906: cp_tar_article_id IN NUMBER,
5907: cp_org_id IN NUMBER,
5908: cp_rel_type IN VARCHAR2) IS
5909: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL
5910: WHERE source_article_id = cp_src_article_id
5911: AND target_article_id = cp_tar_article_id
5912: AND org_id = cp_org_id
5913: AND relationship_type = cp_rel_type;
6567: BEGIN
6568: l_context := 'INSERTING FIRST NEW RELATIONSHIP INTO TABLE';
6569:
6570: FORALL i in rinf_interface_id_tbl.FIRST ..rinf_interface_id_tbl.LAST
6571: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
6572: SOURCE_ARTICLE_ID,
6573: TARGET_ARTICLE_ID,
6574: ORG_ID,
6575: RELATIONSHIP_TYPE,
6595: rinf_process_status_tbl(i) in ('S', 'W') ;
6596:
6597:
6598: FORALL i in rinf_interface_id_tbl.FIRST ..rinf_interface_id_tbl.LAST
6599: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
6600: TARGET_ARTICLE_ID,
6601: SOURCE_ARTICLE_ID,
6602: ORG_ID,
6603: RELATIONSHIP_TYPE,
6628: END IF;
6629: END;
6630:
6631: --
6632: -- End of Insert into OKC_ARTICLE_RELATNS_ALL
6633: --
6634: --
6635:
6636:
6639: BEGIN
6640: l_context := 'DELETE RELATIONSHIP FROM TABLE';
6641:
6642: FORALL i in rinf_interface_id_tbl.FIRST ..rinf_interface_id_tbl.LAST
6643: DELETE FROM OKC_ARTICLE_RELATNS_ALL
6644: WHERE
6645: SOURCE_ARTICLE_ID = rinf_source_article_id_tbl(i) AND
6646: TARGET_ARTICLE_ID = rinf_target_article_id_tbl(i) AND
6647: ORG_ID = rinf_org_id_tbl(i) AND
6650: rinf_process_status_tbl(i) in ('S', 'W') ;
6651:
6652:
6653: FORALL i in rinf_interface_id_tbl.FIRST ..rinf_interface_id_tbl.LAST
6654: DELETE FROM OKC_ARTICLE_RELATNS_ALL
6655: WHERE
6656: TARGET_ARTICLE_ID = rinf_source_article_id_tbl(i) AND
6657: SOURCE_ARTICLE_ID = rinf_target_article_id_tbl(i) AND
6658: ORG_ID = rinf_org_id_tbl(i) AND
6667: END IF;
6668: END;
6669:
6670: --
6671: -- End of Delete from OKC_ARTICLE_RELATNS_ALL
6672: --
6673: --
6674:
6675: