[Home] [Help]
2334: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2338: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2339: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2340: l_variable_code_tbl variable_code_tbl_type;
2341: l_org_id NUMBER;
2342: l_global_article_version_id NUMBER;
3872: p_tar_article_id IN OUT NOCOPY NUMBER
3873: ) IS
3874: CURSOR l_local_article_csr(cp_article_id IN NUMBER,
3875: cp_local_org_id IN NUMBER) IS
3876: SELECT V2.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3877: OKC_ARTICLE_VERSIONS V1 ,
3878: OKC_ARTICLE_VERSIONS V2
3879: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3880: AND V2.ARTICLE_VERSION_ID = AA.LOCAL_ARTICLE_VERSION_ID
3884: AND V2.ARTICLE_STATUS = 'APPROVED'
3885: AND NVL(V2.END_DATE, SYSDATE+1) > SYSDATE
3886: AND rownum < 2
3887: UNION ALL
3888: SELECT V1.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3889: OKC_ARTICLE_VERSIONS V1
3890: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3891: AND V1.ARTICLE_ID = cp_article_id
3892: AND AA.LOCAL_ORG_ID = cp_local_org_id
3973: ) IS
3974: CURSOR l_local_article_csr(cp_src_article_id IN NUMBER,
3975: cp_tar_article_id IN NUMBER,
3976: cp_local_org_id IN NUMBER) IS
3977: SELECT '1' FROM OKC_ARTICLE_ADOPTIONS AA1,
3978: OKC_ARTICLE_VERSIONS V1,
3979: OKC_ARTICLE_ADOPTIONS AA2,
3980: OKC_ARTICLE_VERSIONS V2
3981: WHERE V1.ARTICLE_VERSION_ID = AA1.GLOBAL_ARTICLE_VERSION_ID
3975: cp_tar_article_id IN NUMBER,
3976: cp_local_org_id IN NUMBER) IS
3977: SELECT '1' FROM OKC_ARTICLE_ADOPTIONS AA1,
3978: OKC_ARTICLE_VERSIONS V1,
3979: OKC_ARTICLE_ADOPTIONS AA2,
3980: OKC_ARTICLE_VERSIONS V2
3981: WHERE V1.ARTICLE_VERSION_ID = AA1.GLOBAL_ARTICLE_VERSION_ID
3982: AND V1.ARTICLE_ID = cp_src_article_id
3983: AND AA1.LOCAL_ORG_ID = cp_local_org_id
4041: l_return_status VARCHAR2(1);
4042: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4043: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4044: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
4045: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
4046: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4047: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4048: TYPE l_adoption_type_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4049:
4044: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
4045: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
4046: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4047: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4048: TYPE l_adoption_type_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4049:
4050: l_source_article_id_tbl l_source_article_id_list ;
4051: l_target_article_id_tbl l_target_article_id_list ;
4052: