APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on ASO_SUP_INSTANCE_VALUE

Line 301: l_tmp_value ASO_SUP_INSTANCE_VALUE.value%TYPE;

297: IS
298:
299: l_api_name CONSTANT VARCHAR2(30) := 'GET_QUOTE_SALES_SUPPLEMENT';
300: l_tmp_instance_id ASO_SUP_tmpl_INSTANCE.TEMPLATE_INSTANCE_ID%TYPE;
301: l_tmp_value ASO_SUP_INSTANCE_VALUE.value%TYPE;
302: l_tmp1_value ASO_SUP_INSTANCE_VALUE.value%TYPE;
303: l_tmp2_value ASO_SUP_response_tl.response_name%TYPE;
304:
305:

Line 302: l_tmp1_value ASO_SUP_INSTANCE_VALUE.value%TYPE;

298:
299: l_api_name CONSTANT VARCHAR2(30) := 'GET_QUOTE_SALES_SUPPLEMENT';
300: l_tmp_instance_id ASO_SUP_tmpl_INSTANCE.TEMPLATE_INSTANCE_ID%TYPE;
301: l_tmp_value ASO_SUP_INSTANCE_VALUE.value%TYPE;
302: l_tmp1_value ASO_SUP_INSTANCE_VALUE.value%TYPE;
303: l_tmp2_value ASO_SUP_response_tl.response_name%TYPE;
304:
305:
306:

Line 312: SELECT value FROM ASO_SUP_INSTANCE_VALUE

308: SELECT TEMPLATE_INSTANCE_ID FROM ASO_SUP_tmpl_INSTANCE where owner_table_id = P_DOC_ID;
309:
310: --cursor to get text values
311: Cursor l_sup_value_csr(p_tmp_instace_id number,p_comp_name varchar2) is
312: SELECT value FROM ASO_SUP_INSTANCE_VALUE
313: WHERE template_instance_id = p_tmp_instace_id
314: AND value is not null;
315: -- AND sect_comp_map_id =
316: -- (select component_id from ASO_SUP_component_tl where component_name = p_comp_name and language = 'US');

Line 332: FROM ASO_SUP_INSTANCE_VALUE

328: WHERE flex_value_set_name = 'Industry Type') --1022577 -- Need to be known from setup for 'Industry Type'
329: AND flex_value = (SELECT response_name
330: FROM ASO_SUP_response_tl
331: WHERE response_id IN (SELECT response_id
332: FROM ASO_SUP_INSTANCE_VALUE
333: WHERE template_instance_id = p_tmp_instace_id)
334: AND language = USERENV('LANG'));
335:
336: --Cursor l_sup_lov_value_csr(p_tmp_instace_id number,p_comp_name varchar2) is

Line 338: --(SELECT response_id FROM ASO_SUP_INSTANCE_VALUE WHERE template_instance_id = p_tmp_instace_id)

334: AND language = USERENV('LANG'));
335:
336: --Cursor l_sup_lov_value_csr(p_tmp_instace_id number,p_comp_name varchar2) is
337: --select response_name from ASO_SUP_response_tl where response_id in
338: --(SELECT response_id FROM ASO_SUP_INSTANCE_VALUE WHERE template_instance_id = p_tmp_instace_id)
339: --and language = 'US';
340:
341:
342: BEGIN