[Home] [Help]
2278: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2281: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2282: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2283: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2284: l_variable_code_tbl variable_code_tbl_type;
2285: l_org_id NUMBER;
2286: l_global_article_version_id NUMBER;
3705: p_tar_article_id IN OUT NOCOPY NUMBER
3706: ) IS
3707: CURSOR l_local_article_csr(cp_article_id IN NUMBER,
3708: cp_local_org_id IN NUMBER) IS
3709: SELECT V2.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3710: OKC_ARTICLE_VERSIONS V1 ,
3711: OKC_ARTICLE_VERSIONS V2
3712: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3713: AND V2.ARTICLE_VERSION_ID = AA.LOCAL_ARTICLE_VERSION_ID
3717: AND V2.ARTICLE_STATUS = 'APPROVED'
3718: AND NVL(V2.END_DATE, SYSDATE+1) > SYSDATE
3719: AND rownum < 2
3720: UNION ALL
3721: SELECT V1.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3722: OKC_ARTICLE_VERSIONS V1
3723: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3724: AND V1.ARTICLE_ID = cp_article_id
3725: AND AA.LOCAL_ORG_ID = cp_local_org_id
3806: ) IS
3807: CURSOR l_local_article_csr(cp_src_article_id IN NUMBER,
3808: cp_tar_article_id IN NUMBER,
3809: cp_local_org_id IN NUMBER) IS
3810: SELECT '1' FROM OKC_ARTICLE_ADOPTIONS AA1,
3811: OKC_ARTICLE_VERSIONS V1,
3812: OKC_ARTICLE_ADOPTIONS AA2,
3813: OKC_ARTICLE_VERSIONS V2
3814: WHERE V1.ARTICLE_VERSION_ID = AA1.GLOBAL_ARTICLE_VERSION_ID
3808: cp_tar_article_id IN NUMBER,
3809: cp_local_org_id IN NUMBER) IS
3810: SELECT '1' FROM OKC_ARTICLE_ADOPTIONS AA1,
3811: OKC_ARTICLE_VERSIONS V1,
3812: OKC_ARTICLE_ADOPTIONS AA2,
3813: OKC_ARTICLE_VERSIONS V2
3814: WHERE V1.ARTICLE_VERSION_ID = AA1.GLOBAL_ARTICLE_VERSION_ID
3815: AND V1.ARTICLE_ID = cp_src_article_id
3816: AND AA1.LOCAL_ORG_ID = cp_local_org_id
3874: l_return_status VARCHAR2(1);
3875: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
3876: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3877: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
3878: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
3879: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3880: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3881: TYPE l_adoption_type_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3882:
3877: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
3878: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
3879: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3880: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3881: TYPE l_adoption_type_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3882:
3883: l_source_article_id_tbl l_source_article_id_list ;
3884: l_target_article_id_tbl l_target_article_id_list ;
3885: