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 391: OKC_K_ART_VARIABLES_PVT.delete_set(

387: --------------------------------------------
388: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
389: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3500: Delete records from okc_k_art_varaibles for the doc');
390: END IF;
391: OKC_K_ART_VARIABLES_PVT.delete_set(
392: x_return_status => x_return_status,
393: p_doc_type => p_doc_type,
394: p_doc_id => p_doc_id
395: );

Line 588: x_return_status:=OKC_K_ART_VARIABLES_PVT.delete_version(

584: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3500: Delete records from okc_k_art_varaibles_h for the doc');
586: END IF;
587:
588: x_return_status:=OKC_K_ART_VARIABLES_PVT.delete_version(
589: p_doc_type => p_doc_type,
590: p_doc_id => p_doc_id,
591: p_major_version => p_version_number
592: );

Line 700: FROM okc_k_articles_b kart, okc_k_art_variables var

696: l_api_version CONSTANT NUMBER := 1;
697: l_api_name CONSTANT VARCHAR2(30) := 'Mark_Amendment';
698: CURSOR idlist_crs IS
699: SELECT distinct id, kart.object_version_number
700: FROM okc_k_articles_b kart, okc_k_art_variables var
701: WHERE document_type = p_doc_type
702: AND document_id = p_doc_id
703: AND var.cat_id = kart.id
704: AND kart.amendment_operation_code IS NULL

Line 913: OKC_K_ART_VARIABLES_PVT.delete_set(

909: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
910: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5300: Delete records from okc_k_art_varaibles for the doc');
911: END IF;
912: --------------------------------------------
913: OKC_K_ART_VARIABLES_PVT.delete_set(
914: x_return_status => x_return_status,
915: p_doc_type => G_TMPL_DOC_TYPE,
916: p_doc_id => l_base_template_id
917: );

Line 1200: FROM okc_k_articles_b kart, okc_k_art_variables var

1196: i NUMBER := 1;
1197: l_doc_class VARCHAR2(30) := '?';
1198: CURSOR var_doc_lst_crs IS
1199: SELECT distinct var.variable_code
1200: FROM okc_k_articles_b kart, okc_k_art_variables var
1201: WHERE kart.document_type=p_doc_type AND kart.document_id=p_doc_id
1202: and var.cat_id=kart.id AND variable_type='S';
1203:
1204: CURSOR var_def_lst_crs IS

Line 1408: FROM okc_k_art_variables

1404: l_api_name CONSTANT VARCHAR2(30) := 'Substitute_Var_Value_Globally';
1405: l_dummy VARCHAR2(10);
1406: CURSOR var_lst_crs IS
1407: SELECT cat_id, object_version_number
1408: FROM okc_k_art_variables
1409: WHERE variable_code=p_variable_code
1410: AND cat_id IN (SELECT id FROM okc_k_articles_b
1411: WHERE document_type=p_doc_type AND document_id=p_doc_id);
1412: CURSOR art_lst_crs IS

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

1412: CURSOR art_lst_crs IS
1413: SELECT id, object_version_number
1414: FROM okc_k_articles_b a
1415: WHERE document_type=p_doc_type AND document_id=p_doc_id
1416: and EXISTS (SELECT '!' FROM okc_k_art_variables v
1417: WHERE v.variable_code=p_variable_code AND v.cat_id = a.cat_id );
1418: BEGIN
1419: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Entered Substitute_Var_Value_Globally');

Line 1459: OKC_K_ART_VARIABLES_PVT.update_row(

1455: --------------------------------------------
1456: END IF;
1457:
1458: FOR cr IN var_lst_crs LOOP
1459: OKC_K_ART_VARIABLES_PVT.update_row(
1460: x_return_status => x_return_status,
1461: p_cat_id => cr.cat_id,
1462: p_variable_code => p_variable_code,
1463: p_variable_type => NULL,

Line 3407: FROM okc_k_art_variables

3403: */
3404:
3405: CURSOR l_doc_variable_csr IS
3406: SELECT variable_code
3407: FROM okc_k_art_variables
3408: WHERE cat_id = p_cat_id
3409: AND variable_type = 'D';
3410: l_api_name CONSTANT VARCHAR2(30) := 'deliverable_amendment_exists';
3411: l_variable_type okc_k_art_variables.variable_type%TYPE;

Line 3411: l_variable_type okc_k_art_variables.variable_type%TYPE;

3407: FROM okc_k_art_variables
3408: WHERE cat_id = p_cat_id
3409: AND variable_type = 'D';
3410: l_api_name CONSTANT VARCHAR2(30) := 'deliverable_amendment_exists';
3411: l_variable_type okc_k_art_variables.variable_type%TYPE;
3412: l_return VARCHAR2(1) := 'N';
3413: l_msg_data VARCHAR2(2000);
3414: l_msg_count NUMBER;
3415: l_return_status VARCHAR2(30);

Line 4978: FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN (

4974: AND DOCUMENT_ID=p_document_id;
4975:
4976: Cursor l_get_max_var_date_csr IS
4977: SELECT MAX(NVL(LAST_UPDATE_DATE,CREATION_DATE))
4978: FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN (
4979: SELECT ID FROM OKC_K_ARTICLES_B
4980: WHERE DOCUMENT_TYPE = p_document_type
4981: AND DOCUMENT_ID = document_id);
4982:

Line 5157: okc_k_art_variables KV,

5153: SELECT VB.variable_code,
5154: KA.id,
5155: KA.article_version_id
5156: FROM okc_k_articles_b KA,
5157: okc_k_art_variables KV,
5158: okc_bus_variables_b VB
5159: WHERE VB.variable_code = KV.variable_code
5160: AND KA.id = KV.cat_id
5161: AND VB.variable_source = 'P'