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_ADOPTIONS_GRP dependencies on OKC_ARTICLE_ADOPTIONS

Line 72: okc_article_adoptions.adoption_type

68: SELECT article_id,
69: start_date,
70: article_status,
71: local_article_version_id,
72: okc_article_adoptions.adoption_type
73: FROM OKC_ARTICLE_ADOPTIONS, OKC_ARTICLE_VERSIONS
74: WHERE global_article_version_id = cp_global_article_version_id
75: AND article_version_id = global_article_version_id
76: AND global_yn = 'Y'

Line 73: FROM OKC_ARTICLE_ADOPTIONS, OKC_ARTICLE_VERSIONS

69: start_date,
70: article_status,
71: local_article_version_id,
72: okc_article_adoptions.adoption_type
73: FROM OKC_ARTICLE_ADOPTIONS, OKC_ARTICLE_VERSIONS
74: WHERE global_article_version_id = cp_global_article_version_id
75: AND article_version_id = global_article_version_id
76: AND global_yn = 'Y'
77: AND local_org_id = cp_local_org_id

Line 80: AND okc_article_adoptions.adoption_type = 'AVAILABLE';

76: AND global_yn = 'Y'
77: AND local_org_id = cp_local_org_id
78: AND article_status = 'APPROVED'
79: AND nvl(end_date, sysdate+1) >= trunc(sysdate)
80: AND okc_article_adoptions.adoption_type = 'AVAILABLE';
81:
82: CURSOR l_latest_ver_adp_csr(cp_article_id IN NUMBER,
83: cp_article_version_id IN NUMBER,
84: cp_local_org_id IN NUMBER) IS

Line 95: okc_article_adoptions ad

91: av.article_version_number,
92: av.article_version_id
93: FROM
94: okc_article_versions av,
95: okc_article_adoptions ad
96: WHERE
97: av.article_id = cp_article_id
98: AND
99: ad.global_article_version_id = av.article_version_id

Line 111: okc_article_adoptions ad1

107: av.start_date = (SELECT
108: max(av1.start_date)
109: FROM
110: okc_article_versions av1,
111: okc_article_adoptions ad1
112: WHERE
113: av1.article_id = av.article_id
114: AND
115: ad1.global_article_version_id = av1.article_version_id

Line 146: FROM OKC_ARTICLE_VERSIONS A, OKC_ARTICLE_ADOPTIONS AD

142: AD.ADOPTION_STATUS,
143: AD.LOCAL_ARTICLE_VERSION_ID,
144: A.ARTICLE_VERSION_NUMBER,
145: A.ARTICLE_VERSION_ID
146: FROM OKC_ARTICLE_VERSIONS A, OKC_ARTICLE_ADOPTIONS AD
147: WHERE A.ARTICLE_ID = cp_article_id
148: AND AD.GLOBAL_ARTICLE_VERSION_ID = A.ARTICLE_VERSION_ID
149: AND AD.LOCAL_ORG_ID = cp_local_org_id
150: AND AD.ADOPTION_TYPE <> 'AVAILABLE'

Line 159: FROM OKC_ARTICLE_ADOPTIONS ADP,

155: -- Cursor to find article_id of localized articles if the global article is localized
156: CURSOR l_lcz_article_id_csr(cp_global_article_id IN NUMBER,
157: cp_local_org_id IN NUMBER) IS
158: SELECT distinct(ARVL.ARTICLE_ID)
159: FROM OKC_ARTICLE_ADOPTIONS ADP,
160: OKC_ARTICLE_VERSIONS ARVG,
161: OKC_ARTICLE_VERSIONS ARVL
162: WHERE ARVG.ARTICLE_ID = cp_global_article_id
163: AND ADP.GLOBAL_ARTICLE_VERSION_ID = ARVG.ARTICLE_VERSION_ID

Line 448: SELECT 'T' , global_article_version_id FROM OKC_ARTICLE_ADOPTIONS A

444:
445: CURSOR l_other_version_csr (cp_article_version_id IN NUMBER,
446: cp_local_org_id IN NUMBER) IS
447:
448: SELECT 'T' , global_article_version_id FROM OKC_ARTICLE_ADOPTIONS A
449: WHERE local_article_version_id = cp_article_version_id
450: AND local_org_id = cp_local_org_id
451: AND EXISTS
452: (SELECT '1' FROM OKC_ARTICLE_ADOPTIONS B

Line 452: (SELECT '1' FROM OKC_ARTICLE_ADOPTIONS B

448: SELECT 'T' , global_article_version_id FROM OKC_ARTICLE_ADOPTIONS A
449: WHERE local_article_version_id = cp_article_version_id
450: AND local_org_id = cp_local_org_id
451: AND EXISTS
452: (SELECT '1' FROM OKC_ARTICLE_ADOPTIONS B
453: WHERE B.GLOBAL_ARTICLE_VERSION_ID = A.GLOBAL_ARTICLE_VERSION_ID
454: AND B.LOCAL_ARTICLE_VERSION_ID <> A.LOCAL_ARTICLE_VERSION_ID
455: AND B.LOCAL_ORG_ID = A.LOCAL_ORG_ID);
456:

Line 510: OKC_ARTICLE_ADOPTIONS_PVT.update_row(

506: -- Simple API will figure it out if we pass the global article version id as NULL
507: --dbms_output.put_line('In Adoption:' ||l_delete_adoption||'*'||p_only_local_version);
508:
509: IF l_delete_adoption = 'F' Then
510: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
511: x_return_status => x_return_status,
512: p_global_article_version_id => l_global_article_version_id,
513: p_adoption_type => 'AVAILABLE',
514: p_local_org_id => p_local_org_id,

Line 521: OKC_ARTICLE_ADOPTIONS_PVT.delete_row(

517: p_adoption_status => OKC_API.G_MISS_CHAR,
518: p_object_version_number => NULL
519: );
520: ELSIF l_delete_adoption = 'T' Then
521: OKC_ARTICLE_ADOPTIONS_PVT.delete_row(
522: x_return_status => x_return_status,
523: p_global_article_version_id => l_global_article_version_id,
524: p_local_org_id => p_local_org_id,
525: p_local_article_version_id => p_local_article_version_id,

Line 579: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;

575: l_global_article_version_id NUMBER := -99;
576: l_global_version_id_out NUMBER;
577: l_article_id NUMBER;
578: l_local_org_id NUMBER;
579: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
580: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
581: l_start_date DATE;
582: l_end_date DATE;
583: l_row_notfound BOOLEAN := FALSE;

Line 580: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;

576: l_global_version_id_out NUMBER;
577: l_article_id NUMBER;
578: l_local_org_id NUMBER;
579: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
580: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
581: l_start_date DATE;
582: l_end_date DATE;
583: l_row_notfound BOOLEAN := FALSE;
584: CURSOR l_adoption_csr (cp_local_article_version_id IN NUMBER,

Line 587: OKC_ARTICLE_ADOPTIONS

583: l_row_notfound BOOLEAN := FALSE;
584: CURSOR l_adoption_csr (cp_local_article_version_id IN NUMBER,
585: cp_local_org_id IN NUMBER) IS
586: SELECT global_article_version_id, adoption_type FROM
587: OKC_ARTICLE_ADOPTIONS
588: WHERE local_article_version_id = cp_local_article_version_id
589: AND local_org_id = cp_local_org_id;
590:
591: l_adoption_rec l_adoption_csr%ROWTYPE;

Line 662: OKC_ARTICLE_ADOPTIONS_PVT.update_row(

658: -- dbms_output.put_line('GLOBAL VERSION ID:'||l_global_article_version_id);
659: -- dbms_output.put_line('LOCAL VERSION ID:'||p_local_article_version_id);
660: -- dbms_output.put_line('EARLIER VERSION ID:'||p_earlier_local_version_id);
661: IF p_global_article_version_id IS NOT NULL THEN
662: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
663: p_validation_level => p_validation_level,
664: x_return_status => x_return_status,
665: p_global_article_version_id => p_global_article_version_id,
666: p_adoption_type => 'LOCALIZED',

Line 691: OKC_ARTICLE_ADOPTIONS_PVT.update_row(

687: l_global_article_version_id <> -99 THEN
688:
689: IF p_earlier_local_version_id IS NULL Then
690:
691: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
692: p_validation_level => p_validation_level,
693: x_return_status => x_return_status,
694: p_global_article_version_id => l_global_article_version_id,
695: p_adoption_type => 'LOCALIZED',

Line 713: OKC_ARTICLE_ADOPTIONS_PVT.INSERT_ROW

709: -- adoption row for this new version based on global and org details from
710: -- the previous version.
711:
712:
713: OKC_ARTICLE_ADOPTIONS_PVT.INSERT_ROW
714: (
715: p_validation_level => p_validation_level,
716: x_return_status => x_return_status,
717: p_global_article_version_id=> l_global_article_version_id,

Line 798: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;

794: l_article_id NUMBER;
795: l_local_org_id NUMBER;
796: l_return_status VARCHAR2(1);
797: l_local_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
798: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
799: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
800: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
801: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
802: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 799: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;

795: l_local_org_id NUMBER;
796: l_return_status VARCHAR2(1);
797: l_local_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
798: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
799: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
800: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
801: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
802: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
803: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;

Line 804: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;

800: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
801: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
802: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
803: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
804: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
805: TYPE l_adp_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
806: TYPE l_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
807: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
808: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 834: FROM OKC_ARTICLE_ADOPTIONS

830: AND ORGANIZATION_ID <> cp_global_org_id;
831:
832: CURSOR l_adoptions_csr (cp_global_version_id IN NUMBER, cp_local_org_id IN NUMBER) IS
833: SELECT '1'
834: FROM OKC_ARTICLE_ADOPTIONS
835: WHERE GLOBAL_ARTICLE_VERSION_ID = cp_global_version_id
836: AND LOCAL_ORG_ID = cp_local_org_id
837: AND rownum < 2;
838:

Line 1072: INSERT INTO OKC_ARTICLE_ADOPTIONS

1068: i := 0;
1069: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then
1070: IF p_adoption_yn = 'Y' AND l_org_id_tbl.COUNT > 0 Then
1071: FORALL i in l_org_id_tbl.FIRST .. l_org_id_tbl.LAST
1072: INSERT INTO OKC_ARTICLE_ADOPTIONS
1073: (
1074: GLOBAL_ARTICLE_VERSION_ID,
1075: ADOPTION_TYPE,
1076: LOCAL_ORG_ID,

Line 1189: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;

1185: i NUMBER := 0;
1186: j NUMBER := 0;
1187: l_article_id NUMBER;
1188: l_return_status VARCHAR2(1);
1189: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1190: l_prev_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1191: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1192: l_adoption_type_meaning FND_LOOKUPS.MEANING%TYPE;
1193: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;

Line 1190: l_prev_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;

1186: j NUMBER := 0;
1187: l_article_id NUMBER;
1188: l_return_status VARCHAR2(1);
1189: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1190: l_prev_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1191: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1192: l_adoption_type_meaning FND_LOOKUPS.MEANING%TYPE;
1193: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
1194:

Line 1191: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;

1187: l_article_id NUMBER;
1188: l_return_status VARCHAR2(1);
1189: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1190: l_prev_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1191: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1192: l_adoption_type_meaning FND_LOOKUPS.MEANING%TYPE;
1193: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
1194:
1195: l_prev_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;

Line 1198: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;

1194:
1195: l_prev_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
1196: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1197: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
1199: TYPE l_adp_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
1200: TYPE l_article_version_id_list IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1201: TYPE l_article_id_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1202: TYPE l_article_title_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;

Line 1234: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS

1230: AND VER.article_id = ART.article_id
1231: AND article_status in ('APPROVED', 'ON_HOLD')
1232: AND nvl(end_date, sysdate) >= trunc(sysdate)
1233: AND NOT EXISTS
1234: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS
1235: WHERE global_article_version_id = VER.article_version_id
1236: AND local_org_id = cp_local_org_id)
1237: UNION ALL
1238: SELECT article_version_id , article_title, article_id, orig_system_reference_code

Line 1258: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS

1254: WHERE
1255: article_status = 'APPROVED'
1256: AND end_date < trunc(sysdate)
1257: AND NOT EXISTS
1258: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS
1259: WHERE global_article_version_id = article_version_id
1260: AND local_org_id = cp_local_org_id);
1261:
1262: CURSOR l_dup_title_csr (

Line 1364: INSERT INTO OKC_ARTICLE_ADOPTIONS

1360: /**
1361: BEGIN
1362: savepoint adoption_dml;
1363: FORALL i IN l_article_version_id_tbl.FIRST..l_article_version_id_tbl.LAST
1364: INSERT INTO OKC_ARTICLE_ADOPTIONS
1365: (
1366: GLOBAL_ARTICLE_VERSION_ID,
1367: ADOPTION_TYPE,
1368: LOCAL_ORG_ID,

Line 1472: INSERT INTO OKC_ARTICLE_ADOPTIONS

1468:
1469: SAVEPOINT adoption_dml;
1470: BEGIN
1471: FORALL i IN l_article_version_id_tbl.FIRST..l_article_version_id_tbl.LAST
1472: INSERT INTO OKC_ARTICLE_ADOPTIONS
1473: (
1474: GLOBAL_ARTICLE_VERSION_ID,
1475: ADOPTION_TYPE,
1476: LOCAL_ORG_ID,

Line 1529: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1, OKC_ARTICLE_ADOPTIONS A1

1525: sysdate
1526: FROM OKC_ARTICLE_RELATNS_ALL R
1527: WHERE R.ORG_ID = l_global_org_id
1528: AND EXISTS
1529: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1, OKC_ARTICLE_ADOPTIONS A1
1530: WHERE V1.ARTICLE_ID = R.TARGET_ARTICLE_ID
1531: AND A1.GLOBAL_ARTICLE_VERSION_ID = V1.ARTICLE_VERSION_ID
1532: AND V1.GLOBAL_YN = 'Y'
1533: AND A1.ADOPTION_STATUS = 'APPROVED'

Line 1538: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V2, OKC_ARTICLE_ADOPTIONS A2

1534: AND A1.ADOPTION_TYPE = 'ADOPTED'
1535: AND A1.LOCAL_ORG_ID = p_org_id
1536: )
1537: AND EXISTS
1538: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V2, OKC_ARTICLE_ADOPTIONS A2
1539: WHERE V2.ARTICLE_ID = R.SOURCE_ARTICLE_ID
1540: AND A2.GLOBAL_ARTICLE_VERSION_ID = V2.ARTICLE_VERSION_ID
1541: AND V2.GLOBAL_YN = 'Y'
1542: AND A2.ADOPTION_STATUS = 'APPROVED'