APPS.ICX_DATATEMPLATE_PKG dependencies on DUAL

Line 161: l_op := ' select XMLConcat(' || l_sql || ') from dual';

157: ' and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
158: L_O_CTR := L_O_CTR + 1;
159: END LOOP;
160:
161: l_op := ' select XMLConcat(' || l_sql || ') from dual';
162: execute immediate l_op into l_uda_xml;
163: RETURN (l_uda_xml);
164: END GET_UDA_HEADER_XML;
165:

Line 395: from dual;

391: decode(l_state_or_province,null,'',l_state_or_province||',')||
392: decode(l_territory_short_name, null,'',l_territory_short_name||',')||
393: l_postal_code
394: into address_string
395: from dual;
396:
397: RETURN address_string;
398:
399: END GET_ADDRESS_FROM_LOCATION;

Line 462: l_op := ' select XMLConcat( ' || l_xml_sql || ') from dual';

458: end if;
459:
460: end if;
461:
462: l_op := ' select XMLConcat( ' || l_xml_sql || ') from dual';
463: execute immediate l_op into l_uda_xml;
464:
465: RETURN l_uda_xml.GETCLOBVAL();
466: END GET_FUNDSDATAXML;

Line 511: || l_both_flag ||''')) FROM DUAL';

507: l_sql := 'SELECT XMLCONCAT(XMLELEMENT(REIMBURSEMENT_FLAG, '''
508: || l_reimbursement_flag || '''),
509: XMLELEMENT(DIRECT_CITATION_FLAG, '''
510: || l_direct_citation_flag||'''), XMLELEMENT(OBLG_BOTH_FLAG,'''
511: || l_both_flag ||''')) FROM DUAL';
512:
513: EXECUTE IMMEDIATE l_sql INTO l_acc_xml;
514:
515: return l_acc_xml.getclobval();

Line 581: SELECT substr(l_col_names, 1, InStr(l_col_names, ',')-1), substr(l_col_names, InStr(l_col_names, ',')+1) INTO l_addresstype, l_address_det FROM dual;

577: and upper(ag.descriptive_flex_context_code) = upper('addresses')
578: AND upper(fcu.end_user_column_name) IN (upper(p_col_name), upper('addresstype'))
579: GROUP BY ag.attr_group_id;
580:
581: SELECT substr(l_col_names, 1, InStr(l_col_names, ',')-1), substr(l_col_names, InStr(l_col_names, ',')+1) INTO l_addresstype, l_address_det FROM dual;
582:
583: l_sql := 'select ' || l_col_names || ' from po_req_headers_ext_vl where requisition_header_id = :1 and attr_group_id = :2 and ' ||
584: l_addresstype || ' = :3';
585: