APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on ASO_SUP_RESPONSE_TL

Line 303: l_tmp2_value ASO_SUP_response_tl.response_name%TYPE;

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:
307: Cursor l_tmp_instance_csr is

Line 330: FROM ASO_SUP_response_tl

326: FROM fnd_flex_value_sets
327: -- Added the Flex vbalue set where condition again on 04162007
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'));

Line 337: --select response_name from ASO_SUP_response_tl where response_id in

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
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: