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 OKC_TEMPLATE_USAGES

Line 37: G_DOCUMENT_NUMBER OKC_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE;

33:
34: G_ENABLE_DELIVERABLES VARCHAR2(1) := 'N';
35: G_COPY_DELIVERABLES VARCHAR2(1) := 'N';
36: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
37: G_DOCUMENT_NUMBER OKC_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE;
38: G_TARGET_DOC_TYPE VARCHAR2(240):= NULL;
39: G_TARGET_RESP_DOC_TYPE VARCHAR2(240);
40:
41: -- One Time fetch and cache the current Org.

Line 68: l_numbering_scheme OKC_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE;

64: x_msg_data OUT NOCOPY Varchar2,
65: x_msg_count OUT NOCOPY Number)
66: IS
67: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Numbering_Scheme';
68: l_numbering_scheme OKC_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE;
69:
70: CURSOR l_numbering_scheme_csr IS
71: SELECT doc_numbering_scheme
72: FROM

Line 73: OKC_TEMPLATE_USAGES

69:
70: CURSOR l_numbering_scheme_csr IS
71: SELECT doc_numbering_scheme
72: FROM
73: OKC_TEMPLATE_USAGES
74: WHERE document_type = p_document_type
75: AND document_id = p_document_id;
76:
77: BEGIN

Line 461: lc_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_document_id;

457: l_conterms_deliv_upd_date DATE := NULL;
458: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
459: l_document_id NUMBER;
460: lc_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_document_type;
461: lc_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_document_id;
462: l_dummy VARCHAR2(1) := NULL;
463: l_blob BLOB := null;
464: l_fid NUMBER;
465: l_content_type FND_LOBS.file_content_type%TYPE;

Line 538: OKC_TEMPLATE_USAGES

534:
535: CURSOR l_tmpl_doc_exist_csr IS
536: SELECT 1
537: FROM
538: OKC_TEMPLATE_USAGES
539: WHERE document_type = p_document_type
540: AND document_id = p_document_id;
541:
542:

Line 897: OKC_TEMPLATE_USAGES_GRP.create_template_usages(

893: END IF;
894:
895:
896: ELSE --(it is ATTACHED) -- IF (p_contract_source = 'STRUCTURED') THEN
897: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
898: p_api_version => l_api_version,
899: p_init_msg_list => FND_API.G_FALSE ,
900: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
901: p_commit => FND_API.G_FALSE,

Line 930: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_TEMPLATE_USAGESE_GRP.create_template_usages, return status'||x_return_status);

926: x_document_type => l_document_type,
927: x_document_id => l_document_id
928: );
929: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_TEMPLATE_USAGESE_GRP.create_template_usages, return status'||x_return_status);
931: END IF;
932:
933: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1271: OKC_TEMPLATE_USAGES

1267:
1268: CURSOR l_tmpl_doc_exist_csr IS
1269: SELECT 1
1270: FROM
1271: OKC_TEMPLATE_USAGES
1272: WHERE document_type = p_document_type
1273: AND document_id = p_document_id;
1274:
1275: CURSOR l_fnd_lobs_nextval_csr IS

Line 2463: OKC_TEMPLATE_USAGES

2459:
2460: CURSOR l_tmpl_doc_exist_csr IS
2461: SELECT 1
2462: FROM
2463: OKC_TEMPLATE_USAGES
2464: WHERE document_type = p_document_type
2465: AND document_id = p_document_id;
2466:
2467:

Line 2686: SELECT '!' FROM okc_template_usages

2682: x_msg_count OUT NOCOPY NUMBER )
2683: IS
2684:
2685: CURSOR c_tmpl_usgs_exists IS
2686: SELECT '!' FROM okc_template_usages
2687: WHERE document_type = p_doc_type
2688: AND document_id = p_doc_id;
2689:
2690: l_tmpl_exists VARCHAR2(1);

Line 3141: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;

3137: l_doc_intent VARCHAR2(2);
3138: l_dummy VARCHAR2(1) := NULL;
3139: l_dummy_n NUMBER;
3140:
3141: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
3142: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
3143: l_locked_by_user_id OKC_TEMPLATE_USAGES.LOCKED_BY_USER_ID%TYPE;
3144: l_document_type VARCHAR2(240);
3145: l_document_id NUMBER;

Line 3142: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;

3138: l_dummy VARCHAR2(1) := NULL;
3139: l_dummy_n NUMBER;
3140:
3141: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
3142: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
3143: l_locked_by_user_id OKC_TEMPLATE_USAGES.LOCKED_BY_USER_ID%TYPE;
3144: l_document_type VARCHAR2(240);
3145: l_document_id NUMBER;
3146:

Line 3143: l_locked_by_user_id OKC_TEMPLATE_USAGES.LOCKED_BY_USER_ID%TYPE;

3139: l_dummy_n NUMBER;
3140:
3141: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
3142: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
3143: l_locked_by_user_id OKC_TEMPLATE_USAGES.LOCKED_BY_USER_ID%TYPE;
3144: l_document_type VARCHAR2(240);
3145: l_document_id NUMBER;
3146:
3147: TYPE l_tmpl_type IS RECORD (

Line 3190: OKC_TEMPLATE_USAGES

3186:
3187: CURSOR l_tmpl_doc_exist_csr IS
3188: SELECT 1
3189: FROM
3190: OKC_TEMPLATE_USAGES
3191: WHERE document_type = p_document_type
3192: AND document_id = p_document_id;
3193:
3194: CURSOR l_mlp_tmpl_doc_exist_csr IS

Line 3197: OKC_TEMPLATE_USAGES

3193:
3194: CURSOR l_mlp_tmpl_doc_exist_csr IS
3195: SELECT template_id
3196: FROM
3197: OKC_TEMPLATE_USAGES
3198: WHERE document_type = p_document_type
3199: AND document_id = p_document_id
3200: UNION ALL
3201: SELECT template_id

Line 3439: OKC_TEMPLATE_USAGES_GRP.create_template_usages(

3435: END IF;
3436:
3437: IF p_primary_template = 'Y' THEN
3438:
3439: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3440: p_api_version => 1,
3441: p_init_msg_list => p_init_msg_list,
3442: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3443: p_commit => p_commit,