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_NUMBER_SCHEME_GRP dependencies on OKC_TEMPLATE_USAGES

Line 742: SELECT template_id,object_version_number from OKC_template_usages

738: SELECT num_sequence_code,sequence_level,concatenation_yn,end_character from OKC_NUMBER_SCHEME_DTLS
739: where num_scheme_id=p_num_scheme_id;
740:
741: cursor l_get_usage_rec IS
742: SELECT template_id,object_version_number from OKC_template_usages
743: where document_type=p_doc_type and document_id=p_doc_id;
744:
745: CURSOR l_get_art_csr IS
746: SELECT id,object_version_number

Line 1223: okc_debug.log('400: OKC_TEMPLATE_USAGES_GRP.update_template_usages', 2);

1219: FOR cr in l_get_usage_rec LOOP
1220:
1221: -- Updating usage rec with numbering scheme
1222: /*IF (l_debug = 'Y') THEN
1223: okc_debug.log('400: OKC_TEMPLATE_USAGES_GRP.update_template_usages', 2);
1224: END IF;*/
1225:
1226: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1227: FND_LOG.STRING(G_PROC_LEVEL,

Line 1228: G_PKG_NAME, '400: OKC_TEMPLATE_USAGES_GRP.update_template_usages' );

1224: END IF;*/
1225:
1226: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1227: FND_LOG.STRING(G_PROC_LEVEL,
1228: G_PKG_NAME, '400: OKC_TEMPLATE_USAGES_GRP.update_template_usages' );
1229: END IF;
1230:
1231: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
1232: p_api_version =>1,

Line 1231: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

1227: FND_LOG.STRING(G_PROC_LEVEL,
1228: G_PKG_NAME, '400: OKC_TEMPLATE_USAGES_GRP.update_template_usages' );
1229: END IF;
1230:
1231: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
1232: p_api_version =>1,
1233: p_init_msg_list => FND_API.G_FALSE,
1234: x_return_status => x_return_status,
1235: x_msg_count => x_msg_count,

Line 1250: okc_debug.log('400: After Call to OKC_TEMPLATE_USAGES_GRP.update_template_usages x_return_status : '||x_return_status, 2);

1246: p_object_version_number =>cr.object_version_number
1247: );
1248:
1249: /*IF (l_debug = 'Y') THEN
1250: okc_debug.log('400: After Call to OKC_TEMPLATE_USAGES_GRP.update_template_usages x_return_status : '||x_return_status, 2);
1251: END IF;*/
1252:
1253: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1254: FND_LOG.STRING(G_PROC_LEVEL,

Line 1255: G_PKG_NAME, '400: After Call to OKC_TEMPLATE_USAGES_GRP.update_template_usages x_return_status : '||x_return_status );

1251: END IF;*/
1252:
1253: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1254: FND_LOG.STRING(G_PROC_LEVEL,
1255: G_PKG_NAME, '400: After Call to OKC_TEMPLATE_USAGES_GRP.update_template_usages x_return_status : '||x_return_status );
1256: END IF;
1257:
1258: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1338: SELECT 'N' from OKC_TEMPLATE_USAGES_V

1334: CURSOR used_in_tmpl_crs IS
1335: SELECT 'N' from OKC_TERMS_TEMPLATES_ALL
1336: WHERE TMPL_NUMBERING_SCHEME=p_num_scheme_id;
1337: CURSOR used_in_doc_crs IS -- it's required index on DOC_NUMBERING_SCHEME column
1338: SELECT 'N' from OKC_TEMPLATE_USAGES_V
1339: WHERE DOC_NUMBERING_SCHEME=p_num_scheme_id;
1340: l_ret VARCHAR2(1) := 'Y';
1341: BEGIN
1342: OPEN used_in_tmpl_crs;