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_TERMS_MIGRATE_GRP dependencies on FND_DOCUMENT_CATEGORIES

Line 489: l_category_id FND_DOCUMENT_CATEGORIES.CATEGORY_ID%TYPE;

485:
486: l_attached_document_id OKC_CONTRACT_DOCS.ATTACHED_DOCUMENT_ID%TYPE;
487: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE;
488: L_primary_contract_doc_flag VARCHAR2(1) := 'N';
489: l_category_id FND_DOCUMENT_CATEGORIES.CATEGORY_ID%TYPE;
490:
491: l_doc_intent VARCHAR2(1);
492:
493: TYPE l_tmpl_type IS RECORD (

Line 563: FND_DOCUMENT_CATEGORIES

559:
560: CURSOR l_cat_id_csr IS
561: SELECT category_id
562: FROM
563: FND_DOCUMENT_CATEGORIES
564: WHERE application_id = 510 AND name = 'OKC_REPO_CONTRACT' ;
565:
566:
567: CURSOR l_bus_doc_ver_csr IS

Line 1266: l_category_id FND_DOCUMENT_CATEGORIES.CATEGORY_ID%TYPE;

1262: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1263:
1264: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE;
1265: L_primary_contract_doc_flag VARCHAR2(1) := 'N';
1266: l_category_id FND_DOCUMENT_CATEGORIES.CATEGORY_ID%TYPE;
1267:
1268: CURSOR l_tmpl_doc_exist_csr IS
1269: SELECT 1
1270: FROM

Line 1288: FND_DOCUMENT_CATEGORIES

1284:
1285: CURSOR l_cat_id_csr(l_category IN VARCHAR2) IS
1286: SELECT category_id
1287: FROM
1288: FND_DOCUMENT_CATEGORIES
1289: WHERE application_id = 510
1290: AND name = l_category;
1291:
1292: CURSOR l_bus_doc_ver_csr IS