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_GRP dependencies on OKC_ARTICLE_RELATNS_ALL

Line 1919: DELETE FROM OKC_ARTICLE_RELATNS_ALL -- delete all relationships

1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1916: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1917: RAISE FND_API.G_EXC_ERROR ;
1918: END IF;
1919: DELETE FROM OKC_ARTICLE_RELATNS_ALL -- delete all relationships
1920: WHERE source_article_id = p_article_id OR
1921: target_article_id = p_article_id;
1922: DELETE FROM OKC_FOLDER_CONTENTS -- delete all folder contents
1923: WHERE member_id = p_article_id ;

Line 3168: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

3164: l_api_name CONSTANT VARCHAR2(30) := 'g_copy_article';
3165: l_p_org_id NUMBER;
3166: l_earlier_version_id NUMBER;
3167: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3168: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3169: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3170: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
3171:
3172: -- l_source_article_id_tbl l_source_article_id_list ;

Line 3169: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

3165: l_p_org_id NUMBER;
3166: l_earlier_version_id NUMBER;
3167: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3168: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3169: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3170: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
3171:
3172: -- l_source_article_id_tbl l_source_article_id_list ;
3173: l_target_article_id_tbl l_target_article_id_list ;

Line 3170: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;

3166: l_earlier_version_id NUMBER;
3167: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3168: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3169: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3170: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
3171:
3172: -- l_source_article_id_tbl l_source_article_id_list ;
3173: l_target_article_id_tbl l_target_article_id_list ;
3174: l_relationship_type_tbl l_relationship_type_list ;

Line 3188: FROM OKC_ARTICLE_RELATNS_ALL

3184: cp_org_id IN NUMBER) IS
3185: SELECT
3186: TARGET_ARTICLE_ID,
3187: RELATIONSHIP_TYPE
3188: FROM OKC_ARTICLE_RELATNS_ALL
3189: WHERE source_article_id = cp_article_id
3190: AND org_id = cp_org_id;
3191:
3192: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 3546: INSERT INTO OKC_ARTICLE_RELATNS_ALL

3542: i := 0;
3543: EXIT WHEN l_target_article_id_tbl.COUNT = 0;
3544: -- dbms_output.put_line('Total Rel Found: '||l_target_article_id_tbl.cOUNT);
3545: FORALL i IN l_target_article_id_tbl.FIRST..l_target_article_id_tbl.LAST
3546: INSERT INTO OKC_ARTICLE_RELATNS_ALL
3547: (
3548: SOURCE_ARTICLE_ID,
3549: TARGET_ARTICLE_ID,
3550: ORG_ID,

Line 3575: INSERT INTO OKC_ARTICLE_RELATNS_ALL

3571: );
3572:
3573: -- Revert the target and source article ids.
3574: FORALL i IN l_target_article_id_tbl.FIRST..l_target_article_id_tbl.LAST
3575: INSERT INTO OKC_ARTICLE_RELATNS_ALL
3576: (
3577: SOURCE_ARTICLE_ID,
3578: TARGET_ARTICLE_ID,
3579: ORG_ID,

Line 3733: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL

3729:
3730: cursor l_rel_exist_csr (cp_src_article_id IN NUMBER,
3731: cp_tar_article_id IN NUMBER,
3732: cp_local_org_id IN NUMBER) IS
3733: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL
3734: WHERE source_article_id = cp_src_article_id
3735: AND target_article_id = cp_tar_article_id
3736: AND org_id = cp_local_org_id;
3737: l_src_local_article_id NUMBER;

Line 3824: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL

3820: AND AA2.LOCAL_ORG_ID = AA1.LOCAL_ORG_ID
3821: AND AA2.ADOPTION_TYPE = 'ADOPTED'
3822: AND NOT EXISTS
3823: (
3824: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL
3825: WHERE source_article_id = V1.ARTICLE_ID
3826: AND target_article_id = V2.ARTICLE_ID
3827: AND org_id = AA1.LOCAL_ORG_ID
3828: );

Line 3879: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

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:
3883: l_source_article_id_tbl l_source_article_id_list ;

Line 3880: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

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:
3883: l_source_article_id_tbl l_source_article_id_list ;
3884: l_target_article_id_tbl l_target_article_id_list ;

Line 3904: FROM OKC_ARTICLE_RELATNS_ALL R1

3900: AND ORGANIZATION_ID <> G_GLOBAL_ORG_ID
3901: AND NOT EXISTS
3902: (
3903: SELECT '1'
3904: FROM OKC_ARTICLE_RELATNS_ALL R1
3905: WHERE R1.SOURCE_ARTICLE_ID = cp_src_global_article_id AND
3906: R1.TARGET_ARTICLE_ID = cp_tar_global_article_id AND
3907: R1.RELATIONSHIP_TYPE = cp_relationship_type AND
3908: R1.ORG_ID = ORGANIZATION_ID

Line 3999: INSERT INTO OKC_ARTICLE_RELATNS_ALL

3995: exit;
3996: END IF;
3997:
3998: FORALL j IN l_org_id_tbl.FIRST..l_org_id_tbl.LAST
3999: INSERT INTO OKC_ARTICLE_RELATNS_ALL
4000: (
4001: SOURCE_ARTICLE_ID,
4002: TARGET_ARTICLE_ID,
4003: ORG_ID,

Line 4029: INSERT INTO OKC_ARTICLE_RELATNS_ALL

4025:
4026: -- Revert the target and source article ids.
4027:
4028: FORALL j IN l_org_id_tbl.FIRST..l_org_id_tbl.LAST
4029: INSERT INTO OKC_ARTICLE_RELATNS_ALL
4030: (
4031: SOURCE_ARTICLE_ID,
4032: TARGET_ARTICLE_ID,
4033: ORG_ID,

Line 4126: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;

4122: ) IS
4123:
4124: l_api_version CONSTANT NUMBER := 1;
4125: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
4126: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4127: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4128: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4129: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4130: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 4127: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;

4123:
4124: l_api_version CONSTANT NUMBER := 1;
4125: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
4126: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4127: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4128: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4129: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4130: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4131: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

Line 4128: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;

4124: l_api_version CONSTANT NUMBER := 1;
4125: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
4126: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4127: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4128: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4129: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4130: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4131: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
4132: l_source_article_id NUMBER;

Line 4129: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;

4125: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
4126: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4127: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4128: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4129: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4130: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4131: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
4132: l_source_article_id NUMBER;
4133: l_target_article_id NUMBER;

Line 4130: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

4126: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4127: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4128: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4129: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4130: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4131: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
4132: l_source_article_id NUMBER;
4133: l_target_article_id NUMBER;
4134: l_org_id NUMBER;

Line 4131: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

4127: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4128: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4129: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4130: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4131: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
4132: l_source_article_id NUMBER;
4133: l_target_article_id NUMBER;
4134: l_org_id NUMBER;
4135: BEGIN

Line 4281: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

4277: j NUMBER := 0;
4278: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4279: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4280: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4281: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4282: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4283:
4284: l_article_number_tbl l_article_number_list ;
4285: l_source_article_id_tbl l_source_article_id_list ;

Line 4282: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

4278: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4279: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4280: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4281: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4282: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4283:
4284: l_article_number_tbl l_article_number_list ;
4285: l_source_article_id_tbl l_source_article_id_list ;
4286: l_target_article_id_tbl l_target_article_id_list ;

Line 4293: FROM OKC_ARTICLE_RELATNS_ALL REL

4289:
4290: CURSOR l_relationship_csr (cp_source_global_article_id IN NUMBER,
4291: cp_target_global_article_id IN NUMBER) IS
4292: SELECT source_article_id, target_article_id, org_id
4293: FROM OKC_ARTICLE_RELATNS_ALL REL
4294: WHERE source_article_id = cp_source_global_article_id
4295: AND target_article_id = cp_target_global_article_id;
4296: /*
4297: AND exists

Line 4332: DELETE FROM OKC_ARTICLE_RELATNS_ALL

4328: end if;
4329: EXIT WHEN l_source_article_id_tbl.COUNT = 0;
4330: j := 0;
4331: FORALL j IN l_source_article_id_tbl.FIRST..l_source_article_id_tbl.LAST
4332: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4333: WHERE source_article_id = l_source_article_id_tbl(j) AND
4334: target_article_id = l_target_article_id_tbl(j) AND
4335: org_id = l_org_id_tbl(j);
4336:

Line 4340: DELETE FROM OKC_ARTICLE_RELATNS_ALL

4336:
4337: -- Revert the target and source article ids.
4338: j := 0;
4339: FORALL j IN l_source_article_id_tbl.FIRST..l_source_article_id_tbl.LAST
4340: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4341: WHERE target_article_id = l_source_article_id_tbl(j) AND
4342: source_article_id = l_target_article_id_tbl(j) AND
4343: org_id = l_org_id_tbl(j);
4344:

Line 4436: DELETE FROM OKC_ARTICLE_RELATNS_ALL

4432: ELSE
4433: -- For global article relationship deletion delete all similar relationships for all orgs
4434: -- including those adopted naturally or not.
4435:
4436: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4437: WHERE SOURCE_ARTICLE_ID = p_source_article_id
4438: AND TARGET_ARTICLE_ID = p_target_article_id;
4439:
4440: DELETE FROM OKC_ARTICLE_RELATNS_ALL

Line 4440: DELETE FROM OKC_ARTICLE_RELATNS_ALL

4436: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4437: WHERE SOURCE_ARTICLE_ID = p_source_article_id
4438: AND TARGET_ARTICLE_ID = p_target_article_id;
4439:
4440: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4441: WHERE SOURCE_ARTICLE_ID = p_target_article_id
4442: AND TARGET_ARTICLE_ID = p_source_article_id;
4443: /*
4444: DELETE_AUTO_ADOPTED_RELATIONS