APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_BUS_VARIABLES_B

Line 1247: FROM OKC_BUS_DOC_TYPES_B vo, OKC_BUS_VARIABLES_B busvar

1243: and var.cat_id=kart.id AND variable_type='S';
1244:
1245: CURSOR var_def_lst_crs IS
1246: SELECT busvar.variable_code
1247: FROM OKC_BUS_DOC_TYPES_B vo, OKC_BUS_VARIABLES_B busvar
1248: WHERE vo.document_type=p_doc_type AND busvar.contract_expert_yn='Y'
1249: AND busvar.variable_intent=vo.intent;
1250: CURSOR doc_cls_lst_crs IS
1251: SELECT document_type_class

Line 5198: l_previous_var_code okc_bus_variables_b.variable_code%TYPE := '-99';

5194: l_api_version CONSTANT NUMBER := 1.0;
5195: l_api_name CONSTANT VARCHAR2(30) := 'set_udv_with_procedures';
5196:
5197: l_variable_value VARCHAR2(2500) := NULL;
5198: l_previous_var_code okc_bus_variables_b.variable_code%TYPE := '-99';
5199: l_return_status VARCHAR2(10) := NULL;
5200:
5201: CURSOR csr_get_udv_with_procs IS
5202: SELECT VB.variable_code,

Line 5207: okc_bus_variables_b VB

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'
5211: AND KA.document_type = p_document_type

Line 5373: l_procedure_name okc_bus_variables_b.procedure_name%TYPE;

5369: l_api_name CONSTANT VARCHAR2(30) := 'get_udv_with_proc_value';
5370:
5371: l_variable_value VARCHAR2(2500) := NULL;
5372:
5373: l_procedure_name okc_bus_variables_b.procedure_name%TYPE;
5374: l_value_set_id okc_bus_variables_b.value_set_id%TYPE;
5375: l_variable_name okc_bus_variables_tl.variable_name%TYPE;
5376: l_variable_value_id VARCHAR2(2500) := NULL;
5377: l_return_status VARCHAR2(10);

Line 5374: l_value_set_id okc_bus_variables_b.value_set_id%TYPE;

5370:
5371: l_variable_value VARCHAR2(2500) := NULL;
5372:
5373: l_procedure_name okc_bus_variables_b.procedure_name%TYPE;
5374: l_value_set_id okc_bus_variables_b.value_set_id%TYPE;
5375: l_variable_name okc_bus_variables_tl.variable_name%TYPE;
5376: l_variable_value_id VARCHAR2(2500) := NULL;
5377: l_return_status VARCHAR2(10);
5378: l_msg_count NUMBER;

Line 5399: FROM okc_bus_variables_b VB,

5395: CURSOR csr_get_udv_with_proc_dtls IS
5396: SELECT VB.procedure_name,
5397: VB.value_set_id,
5398: VT.variable_name
5399: FROM okc_bus_variables_b VB,
5400: okc_bus_variables_tl VT
5401: WHERE VB.variable_code = VT.variable_code
5402: AND VT.language = USERENV('LANG')
5403: AND VB.variable_code = p_variable_code