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 1961: DELETE FROM OKC_ARTICLE_RELATNS_ALL -- delete all relationships

1957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1958: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1959: RAISE FND_API.G_EXC_ERROR ;
1960: END IF;
1961: DELETE FROM OKC_ARTICLE_RELATNS_ALL -- delete all relationships
1962: WHERE source_article_id = p_article_id OR
1963: target_article_id = p_article_id;
1964: DELETE FROM OKC_FOLDER_CONTENTS -- delete all folder contents
1965: WHERE member_id = p_article_id ;

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

3281: l_api_name CONSTANT VARCHAR2(30) := 'g_copy_article';
3282: l_p_org_id NUMBER;
3283: l_earlier_version_id NUMBER;
3284: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3285: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3286: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3287: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
3288:
3289: -- l_source_article_id_tbl l_source_article_id_list ;

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

3282: l_p_org_id NUMBER;
3283: l_earlier_version_id NUMBER;
3284: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3285: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3286: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3287: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
3288:
3289: -- l_source_article_id_tbl l_source_article_id_list ;
3290: l_target_article_id_tbl l_target_article_id_list ;

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

3283: l_earlier_version_id NUMBER;
3284: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3285: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3286: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3287: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
3288:
3289: -- l_source_article_id_tbl l_source_article_id_list ;
3290: l_target_article_id_tbl l_target_article_id_list ;
3291: l_relationship_type_tbl l_relationship_type_list ;

Line 3305: FROM OKC_ARTICLE_RELATNS_ALL

3301: cp_org_id IN NUMBER) IS
3302: SELECT
3303: TARGET_ARTICLE_ID,
3304: RELATIONSHIP_TYPE
3305: FROM OKC_ARTICLE_RELATNS_ALL
3306: WHERE source_article_id = cp_article_id
3307: AND org_id = cp_org_id;
3308:
3309: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 3672: INSERT INTO OKC_ARTICLE_RELATNS_ALL

3668: i := 0;
3669: EXIT WHEN l_target_article_id_tbl.COUNT = 0;
3670: -- dbms_output.put_line('Total Rel Found: '||l_target_article_id_tbl.cOUNT);
3671: FORALL i IN l_target_article_id_tbl.FIRST..l_target_article_id_tbl.LAST
3672: INSERT INTO OKC_ARTICLE_RELATNS_ALL
3673: (
3674: SOURCE_ARTICLE_ID,
3675: TARGET_ARTICLE_ID,
3676: ORG_ID,

Line 3701: INSERT INTO OKC_ARTICLE_RELATNS_ALL

3697: );
3698:
3699: -- Revert the target and source article ids.
3700: FORALL i IN l_target_article_id_tbl.FIRST..l_target_article_id_tbl.LAST
3701: INSERT INTO OKC_ARTICLE_RELATNS_ALL
3702: (
3703: SOURCE_ARTICLE_ID,
3704: TARGET_ARTICLE_ID,
3705: ORG_ID,

Line 3900: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL

3896:
3897: cursor l_rel_exist_csr (cp_src_article_id IN NUMBER,
3898: cp_tar_article_id IN NUMBER,
3899: cp_local_org_id IN NUMBER) IS
3900: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL
3901: WHERE source_article_id = cp_src_article_id
3902: AND target_article_id = cp_tar_article_id
3903: AND org_id = cp_local_org_id;
3904: l_src_local_article_id NUMBER;

Line 3991: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL

3987: AND AA2.LOCAL_ORG_ID = AA1.LOCAL_ORG_ID
3988: AND AA2.ADOPTION_TYPE = 'ADOPTED'
3989: AND NOT EXISTS
3990: (
3991: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL
3992: WHERE source_article_id = V1.ARTICLE_ID
3993: AND target_article_id = V2.ARTICLE_ID
3994: AND org_id = AA1.LOCAL_ORG_ID
3995: );

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

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

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

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:
4050: l_source_article_id_tbl l_source_article_id_list ;
4051: l_target_article_id_tbl l_target_article_id_list ;

Line 4071: FROM OKC_ARTICLE_RELATNS_ALL R1

4067: AND ORGANIZATION_ID <> G_GLOBAL_ORG_ID
4068: AND NOT EXISTS
4069: (
4070: SELECT '1'
4071: FROM OKC_ARTICLE_RELATNS_ALL R1
4072: WHERE R1.SOURCE_ARTICLE_ID = cp_src_global_article_id AND
4073: R1.TARGET_ARTICLE_ID = cp_tar_global_article_id AND
4074: R1.RELATIONSHIP_TYPE = cp_relationship_type AND
4075: R1.ORG_ID = ORGANIZATION_ID

Line 4166: INSERT INTO OKC_ARTICLE_RELATNS_ALL

4162: exit;
4163: END IF;
4164:
4165: FORALL j IN l_org_id_tbl.FIRST..l_org_id_tbl.LAST
4166: INSERT INTO OKC_ARTICLE_RELATNS_ALL
4167: (
4168: SOURCE_ARTICLE_ID,
4169: TARGET_ARTICLE_ID,
4170: ORG_ID,

Line 4196: INSERT INTO OKC_ARTICLE_RELATNS_ALL

4192:
4193: -- Revert the target and source article ids.
4194:
4195: FORALL j IN l_org_id_tbl.FIRST..l_org_id_tbl.LAST
4196: INSERT INTO OKC_ARTICLE_RELATNS_ALL
4197: (
4198: SOURCE_ARTICLE_ID,
4199: TARGET_ARTICLE_ID,
4200: ORG_ID,

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

4289: ) IS
4290:
4291: l_api_version CONSTANT NUMBER := 1;
4292: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
4293: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4294: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4295: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4296: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4297: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 4294: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;

4290:
4291: l_api_version CONSTANT NUMBER := 1;
4292: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
4293: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4294: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4295: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4296: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4297: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4298: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

Line 4295: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;

4291: l_api_version CONSTANT NUMBER := 1;
4292: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
4293: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4294: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4295: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4296: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4297: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4298: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
4299: l_source_article_id NUMBER;

Line 4296: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;

4292: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
4293: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4294: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4295: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4296: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4297: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4298: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
4299: l_source_article_id NUMBER;
4300: l_target_article_id NUMBER;

Line 4297: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

4293: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
4294: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4295: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4296: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4297: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4298: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
4299: l_source_article_id NUMBER;
4300: l_target_article_id NUMBER;
4301: l_org_id NUMBER;

Line 4298: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

4294: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
4295: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
4296: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
4297: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
4298: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
4299: l_source_article_id NUMBER;
4300: l_target_article_id NUMBER;
4301: l_org_id NUMBER;
4302: BEGIN

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

4444: j NUMBER := 0;
4445: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4446: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4447: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4448: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4449: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4450:
4451: l_article_number_tbl l_article_number_list ;
4452: l_source_article_id_tbl l_source_article_id_list ;

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

4445: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4446: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4447: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4448: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4449: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4450:
4451: l_article_number_tbl l_article_number_list ;
4452: l_source_article_id_tbl l_source_article_id_list ;
4453: l_target_article_id_tbl l_target_article_id_list ;

Line 4460: FROM OKC_ARTICLE_RELATNS_ALL REL

4456:
4457: CURSOR l_relationship_csr (cp_source_global_article_id IN NUMBER,
4458: cp_target_global_article_id IN NUMBER) IS
4459: SELECT source_article_id, target_article_id, org_id
4460: FROM OKC_ARTICLE_RELATNS_ALL REL
4461: WHERE source_article_id = cp_source_global_article_id
4462: AND target_article_id = cp_target_global_article_id;
4463: /*
4464: AND exists

Line 4499: DELETE FROM OKC_ARTICLE_RELATNS_ALL

4495: end if;
4496: EXIT WHEN l_source_article_id_tbl.COUNT = 0;
4497: j := 0;
4498: FORALL j IN l_source_article_id_tbl.FIRST..l_source_article_id_tbl.LAST
4499: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4500: WHERE source_article_id = l_source_article_id_tbl(j) AND
4501: target_article_id = l_target_article_id_tbl(j) AND
4502: org_id = l_org_id_tbl(j);
4503:

Line 4507: DELETE FROM OKC_ARTICLE_RELATNS_ALL

4503:
4504: -- Revert the target and source article ids.
4505: j := 0;
4506: FORALL j IN l_source_article_id_tbl.FIRST..l_source_article_id_tbl.LAST
4507: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4508: WHERE target_article_id = l_source_article_id_tbl(j) AND
4509: source_article_id = l_target_article_id_tbl(j) AND
4510: org_id = l_org_id_tbl(j);
4511:

Line 4603: DELETE FROM OKC_ARTICLE_RELATNS_ALL

4599: ELSE
4600: -- For global article relationship deletion delete all similar relationships for all orgs
4601: -- including those adopted naturally or not.
4602:
4603: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4604: WHERE SOURCE_ARTICLE_ID = p_source_article_id
4605: AND TARGET_ARTICLE_ID = p_target_article_id;
4606:
4607: DELETE FROM OKC_ARTICLE_RELATNS_ALL

Line 4607: DELETE FROM OKC_ARTICLE_RELATNS_ALL

4603: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4604: WHERE SOURCE_ARTICLE_ID = p_source_article_id
4605: AND TARGET_ARTICLE_ID = p_target_article_id;
4606:
4607: DELETE FROM OKC_ARTICLE_RELATNS_ALL
4608: WHERE SOURCE_ARTICLE_ID = p_target_article_id
4609: AND TARGET_ARTICLE_ID = p_source_article_id;
4610: /*
4611: DELETE_AUTO_ADOPTED_RELATIONS