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_ARTICLES_ALL

Line 59: l_local_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;

55: l_api_name CONSTANT VARCHAR2(30) := 'g_check_adoption';
56: l_lcz_article_id NUMBER;
57:
58: l_global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
59: l_local_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
60: l_adp_row_notfound BOOLEAN := FALSE;
61: l_lcz_row_notfound BOOLEAN := FALSE;
62: l_row_found BOOLEAN := FALSE;
63: l_row_notfound BOOLEAN := FALSE;

Line 190: FROM OKC_ARTICLES_ALL ARTL

186: CURSOR l_unq_local_title_csr (cp_local_org_id IN NUMBER,
187: cp_global_article_id IN NUMBER,
188: cp_global_org_id IN NUMBER) IS
189: SELECT 1
190: FROM OKC_ARTICLES_ALL ARTL
191: WHERE ARTL.ORG_ID = cp_local_org_id
192: AND ARTL.STANDARD_YN = 'Y'
193: AND ARTL.ARTICLE_TITLE = ( SELECT ARTG.ARTICLE_TITLE
194: FROM OKC_ARTICLES_ALL ARTG

Line 194: FROM OKC_ARTICLES_ALL ARTG

190: FROM OKC_ARTICLES_ALL ARTL
191: WHERE ARTL.ORG_ID = cp_local_org_id
192: AND ARTL.STANDARD_YN = 'Y'
193: AND ARTL.ARTICLE_TITLE = ( SELECT ARTG.ARTICLE_TITLE
194: FROM OKC_ARTICLES_ALL ARTG
195: WHERE ARTG.ARTICLE_ID = cp_global_article_id
196: AND ARTG.ORG_ID = cp_global_org_id
197: AND ARTG.STANDARD_YN= 'Y');
198:

Line 797: l_local_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;

793: l_global_version_id_out NUMBER;
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;

Line 807: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%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 ;
809: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
810: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
811:

Line 847: OKC_ARTICLES_ALL A

843: SOURCE_ARTICLE_ID,
844: TARGET_ARTICLE_ID,
845: RELATIONSHIP_TYPE
846: FROM OKC_ARTICLE_RELATNS_ALL R,
847: OKC_ARTICLES_ALL A
848: WHERE R.SOURCE_ARTICLE_ID = cp_global_article_id
849: AND R.TARGET_ARTICLE_ID = A.ARTICLE_ID
850: AND R.ORG_ID = cp_global_org_id
851: AND EXISTS

Line 879: FROM OKC_ARTICLES_ALL ARTL

875: CURSOR l_unq_local_title_csr (cp_local_org_id IN NUMBER,
876: cp_global_article_id IN NUMBER,
877: cp_global_org_id IN NUMBER) IS
878: SELECT 1
879: FROM OKC_ARTICLES_ALL ARTL
880: WHERE ARTL.ORG_ID = cp_local_org_id
881: AND ARTL.STANDARD_YN= 'Y'
882: AND ARTL.ARTICLE_TITLE = ( SELECT ARTG.ARTICLE_TITLE
883: FROM OKC_ARTICLES_ALL ARTG

Line 883: FROM OKC_ARTICLES_ALL ARTG

879: FROM OKC_ARTICLES_ALL ARTL
880: WHERE ARTL.ORG_ID = cp_local_org_id
881: AND ARTL.STANDARD_YN= 'Y'
882: AND ARTL.ARTICLE_TITLE = ( SELECT ARTG.ARTICLE_TITLE
883: FROM OKC_ARTICLES_ALL ARTG
884: WHERE ARTG.ARTICLE_ID = cp_global_article_id
885: AND ARTG.ORG_ID = cp_global_org_id
886: AND ARTG.STANDARD_YN='Y');
887: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 1195: l_prev_article_id OKC_ARTICLES_ALL.ARTICLE_ID%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;
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;

Line 1201: TYPE l_article_id_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

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 ;
1203: TYPE l_orig_system_ref_code_list IS TABLE of OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1204:
1205: l_adoption_type_tbl l_adoption_type_list;

Line 1202: TYPE l_article_title_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_TITLE%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 ;
1203: TYPE l_orig_system_ref_code_list IS TABLE of OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1204:
1205: l_adoption_type_tbl l_adoption_type_list;
1206: l_adoption_status_tbl l_adoption_status_list;

Line 1203: TYPE l_orig_system_ref_code_list IS TABLE of OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%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 ;
1203: TYPE l_orig_system_ref_code_list IS TABLE of OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1204:
1205: l_adoption_type_tbl l_adoption_type_list;
1206: l_adoption_status_tbl l_adoption_status_list;
1207: l_adp_record_status_tbl l_adp_record_status_list;

Line 1227: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART

1223: -- Modified Cursor Where clause , Bug 3315511
1224: CURSOR l_adoptions_csr (cp_global_org_id IN NUMBER, cp_local_org_id IN NUMBER) IS
1225: SELECT article_version_id , article_title,
1226: art.article_id, art.orig_system_reference_code
1227: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART
1228: WHERE global_yn = 'Y'
1229: AND org_id = cp_global_org_id
1230: AND VER.article_id = ART.article_id
1231: AND article_status in ('APPROVED', 'ON_HOLD')

Line 1245: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART

1241: SELECT article_version_id , article_title , art.article_id ,
1242: start_date , end_date,
1243: global_yn , org_id , article_status,
1244: art.orig_system_reference_code
1245: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART
1246: WHERE VER.article_id = ART.article_id
1247: AND global_yn = 'Y'
1248: AND org_id = cp_global_org_id
1249: AND start_date = ( SELECT max(start_date)

Line 1250: FROM OKC_ARTICLE_VERSIONS VER1,OKC_ARTICLES_ALL ART1

1246: WHERE VER.article_id = ART.article_id
1247: AND global_yn = 'Y'
1248: AND org_id = cp_global_org_id
1249: AND start_date = ( SELECT max(start_date)
1250: FROM OKC_ARTICLE_VERSIONS VER1,OKC_ARTICLES_ALL ART1
1251: WHERE VER1.ARTICLE_ID = ART1.ARTICLE_ID
1252: AND VER1.ARTICLE_ID = VER.ARTICLE_ID )
1253: )
1254: WHERE

Line 1266: FROM OKC_ARTICLES_ALL

1262: CURSOR l_dup_title_csr (
1263: cp_local_org_id IN NUMBER,
1264: cp_article_title IN VARCHAR2) IS
1265: SELECT '1'
1266: FROM OKC_ARTICLES_ALL
1267: WHERE org_id = cp_local_org_id
1268: AND article_title = cp_article_title
1269: AND standard_yn = 'Y';
1270: