APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on ASO_SUP_TMPL_INSTANCE

Line 300: l_tmp_instance_id ASO_SUP_tmpl_INSTANCE.TEMPLATE_INSTANCE_ID%TYPE;

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

Line 308: SELECT TEMPLATE_INSTANCE_ID FROM ASO_SUP_tmpl_INSTANCE where owner_table_id = P_DOC_ID;

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