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_UTIL_PVT dependencies on OKC_K_ART_VARIABLES

Line 399: OKC_K_ART_VARIABLES_PVT.delete_set(

395: --------------------------------------------
396: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3500: Delete records from okc_k_art_varaibles for the doc');
398: END IF;
399: OKC_K_ART_VARIABLES_PVT.delete_set(
400: x_return_status => x_return_status,
401: p_doc_type => p_doc_type,
402: p_doc_id => p_doc_id
403: ,p_retain_lock_terms_yn => p_retain_lock_terms_yn

Line 629: x_return_status:=OKC_K_ART_VARIABLES_PVT.delete_version(

625: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3500: Delete records from okc_k_art_varaibles_h for the doc');
627: END IF;
628:
629: x_return_status:=OKC_K_ART_VARIABLES_PVT.delete_version(
630: p_doc_type => p_doc_type,
631: p_doc_id => p_doc_id,
632: p_major_version => p_version_number
633: );

Line 741: FROM okc_k_articles_b kart, okc_k_art_variables var

737: l_api_version CONSTANT NUMBER := 1;
738: l_api_name CONSTANT VARCHAR2(30) := 'Mark_Amendment';
739: CURSOR idlist_crs IS
740: SELECT distinct id, kart.object_version_number
741: FROM okc_k_articles_b kart, okc_k_art_variables var
742: WHERE document_type = p_doc_type
743: AND document_id = p_doc_id
744: AND var.cat_id = kart.id
745: AND kart.amendment_operation_code IS NULL

Line 954: OKC_K_ART_VARIABLES_PVT.delete_set(

950: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5300: Delete records from okc_k_art_varaibles for the doc');
952: END IF;
953: --------------------------------------------
954: OKC_K_ART_VARIABLES_PVT.delete_set(
955: x_return_status => x_return_status,
956: p_doc_type => G_TMPL_DOC_TYPE,
957: p_doc_id => l_base_template_id
958: );

Line 1241: FROM okc_k_articles_b kart, okc_k_art_variables var

1237: i NUMBER := 1;
1238: l_doc_class VARCHAR2(30) := '?';
1239: CURSOR var_doc_lst_crs IS
1240: SELECT distinct var.variable_code
1241: FROM okc_k_articles_b kart, okc_k_art_variables var
1242: WHERE kart.document_type=p_doc_type AND kart.document_id=p_doc_id
1243: and var.cat_id=kart.id AND variable_type='S';
1244:
1245: CURSOR var_def_lst_crs IS

Line 1450: FROM okc_k_art_variables

1446: l_api_name CONSTANT VARCHAR2(30) := 'Substitute_Var_Value_Globally';
1447: l_dummy VARCHAR2(10);
1448: CURSOR var_lst_crs IS
1449: SELECT cat_id, object_version_number
1450: FROM okc_k_art_variables
1451: WHERE variable_code=p_variable_code
1452: AND cat_id IN (SELECT id FROM okc_k_articles_b
1453: WHERE document_type=p_doc_type AND document_id=p_doc_id);
1454: CURSOR art_lst_crs IS

Line 1458: and EXISTS (SELECT '!' FROM okc_k_art_variables v

1454: CURSOR art_lst_crs IS
1455: SELECT id, object_version_number
1456: FROM okc_k_articles_b a
1457: WHERE document_type=p_doc_type AND document_id=p_doc_id
1458: and EXISTS (SELECT '!' FROM okc_k_art_variables v
1459: WHERE v.variable_code=p_variable_code AND v.cat_id = a.cat_id );
1460: BEGIN
1461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1462: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Entered Substitute_Var_Value_Globally');

Line 1501: OKC_K_ART_VARIABLES_PVT.update_row(

1497: --------------------------------------------
1498: END IF;
1499:
1500: FOR cr IN var_lst_crs LOOP
1501: OKC_K_ART_VARIABLES_PVT.update_row(
1502: x_return_status => x_return_status,
1503: p_cat_id => cr.cat_id,
1504: p_variable_code => p_variable_code,
1505: p_variable_type => NULL,

Line 3449: FROM okc_k_art_variables

3445: */
3446:
3447: CURSOR l_doc_variable_csr IS
3448: SELECT variable_code
3449: FROM okc_k_art_variables
3450: WHERE cat_id = p_cat_id
3451: AND variable_type = 'D';
3452: l_api_name CONSTANT VARCHAR2(30) := 'deliverable_amendment_exists';
3453: l_variable_type okc_k_art_variables.variable_type%TYPE;

Line 3453: l_variable_type okc_k_art_variables.variable_type%TYPE;

3449: FROM okc_k_art_variables
3450: WHERE cat_id = p_cat_id
3451: AND variable_type = 'D';
3452: l_api_name CONSTANT VARCHAR2(30) := 'deliverable_amendment_exists';
3453: l_variable_type okc_k_art_variables.variable_type%TYPE;
3454: l_return VARCHAR2(1) := 'N';
3455: l_msg_data VARCHAR2(2000);
3456: l_msg_count NUMBER;
3457: l_return_status VARCHAR2(30);

Line 5027: FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN (

5023: AND DOCUMENT_ID=p_document_id;
5024:
5025: Cursor l_get_max_var_date_csr IS
5026: SELECT MAX(NVL(LAST_UPDATE_DATE,CREATION_DATE))
5027: FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN (
5028: SELECT ID FROM OKC_K_ARTICLES_B
5029: WHERE DOCUMENT_TYPE = p_document_type
5030: AND DOCUMENT_ID = document_id);
5031:

Line 5206: okc_k_art_variables KV,

5202: SELECT VB.variable_code,
5203: KA.id,
5204: KA.article_version_id
5205: FROM okc_k_articles_b KA,
5206: okc_k_art_variables KV,
5207: okc_bus_variables_b VB
5208: WHERE VB.variable_code = KV.variable_code
5209: AND KA.id = KV.cat_id
5210: AND VB.variable_source = 'P'