APPS.PO_SGD_PKG dependencies on DUAL

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

279: ' and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
280: L_O_CTR := L_O_CTR + 1;
281: END LOOP;
282:
283: l_op := ' select XMLConcat(' || l_sql || ') from dual';
284: execute immediate l_op into l_uda_xml;
285: RETURN (l_uda_xml);
286: END get_uda_header_xml;
287:

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

378: ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
379: L_O_CTR := L_O_CTR + 1;
380: END LOOP;
381:
382: l_op := ' select XMLConcat(' || l_sql || ') from dual';
383: execute immediate l_op into l_uda_xml;
384: RETURN (l_uda_xml);
385: END get_uda_line_xml;
386:

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

478: || ' and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
479: L_O_CTR := L_O_CTR + 1;
480: END LOOP;
481:
482: l_op := ' select XMLConcat(' || l_sql || ') from dual';
483: execute immediate l_op into l_uda_xml;
484: RETURN (l_uda_xml);
485:
486: END get_uda_lineloc_xml;

Line 539: from dual;

535: execute immediate l_sql into clob_addr using p_line_location_id, p_draft_id,l_attr_grp_id ;
536: exception
537: when others then
538: select '' into clob_addr
539: from dual;
540: end;
541: end if;
542: RETURN(clob_addr);
543: END get_shipaddressxml;

Line 917: FROM dual) ';

913: XMLELement("mod_id", ''' || l_modvalue ||'''),
914: XMLELement("orig_value", ''' || l_origvalue_desc ||'''),
915: XMLELement("mod_value", ''' || l_modvalue_desc || '''),
916: XMLELement("printable_pks", ''' || l_print_string ||'''))
917: FROM dual) ';
918: ELSE
919: l_sql_stmt := l_sql_stmt || ',' || '(select XMLElement("ATTRIBUTE" , XMLATTRIBUTES(''' || l_msgcode || ''' as "name",
920: ''' || l_datatype || ''' as "datatype",
921: ''' || l_subentity || ''' as "sub_entity"),

Line 927: FROM dual) ';

923: XMLELement("mod_id", ''' || l_modvalue ||'''),
924: XMLELement("orig_value", ''' || l_origvalue_desc ||'''),
925: XMLELement("mod_value", ''' || l_modvalue_desc || '''),
926: XMLELement("printable_pks", ''' || l_print_string ||'''))
927: FROM dual) ';
928: END IF;
929: END LOOP;
930:
931:

Line 932: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';

928: END IF;
929: END LOOP;
930:
931:
932: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';
933: execute immediate l_sql_stmt into l_xml;
934: END IF;
935:
936: RETURN (l_xml);

Line 1204: FROM dual) ';

1200: XMLELement("mod_id", ''' || l_modvalue ||'''),
1201: XMLELement("orig_value", ''' || l_origvalue_desc ||'''),
1202: XMLELement("mod_value", ''' || l_modvalue_desc || '''),
1203: XMLELement("printable_pks", ''' || l_print_string ||'''))
1204: FROM dual) ';
1205: ELSE
1206: l_sql_stmt := l_sql_stmt || ',' || '(select XMLElement("ATTRIBUTE" , XMLATTRIBUTES(''' || l_msgcode || ''' as "name",
1207: ''' || l_datatype || ''' as "datatype",
1208: ''' || l_subentity || ''' as "sub_entity"),

Line 1214: FROM dual) ';

1210: XMLELement("mod_id", ''' || l_modvalue ||'''),
1211: XMLELement("orig_value", ''' || l_origvalue_desc ||'''),
1212: XMLELement("mod_value", ''' || l_modvalue_desc || '''),
1213: XMLELement("printable_pks", ''' || l_print_string ||'''))
1214: FROM dual) ';
1215: END IF;
1216: END LOOP;
1217:
1218: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';

Line 1218: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';

1214: FROM dual) ';
1215: END IF;
1216: END LOOP;
1217:
1218: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';
1219: execute immediate l_sql_stmt into l_xml;
1220:
1221: END IF;
1222: RETURN (l_xml);

Line 1499: FROM dual) ';

1495: XMLELement("mod_id", ''' || l_modvalue ||'''),
1496: XMLELement("orig_value", ''' || l_origvalue_desc ||'''),
1497: XMLELement("mod_value", ''' || l_modvalue_desc || '''),
1498: XMLELement("printable_pks", ''' || l_print_string ||'''))
1499: FROM dual) ';
1500: ELSE
1501: l_sql_stmt := l_sql_stmt || ',' || '(select XMLElement("ATTRIBUTE" , XMLATTRIBUTES(''' || l_msgcode || ''' as "name",
1502: ''' || l_datatype || ''' as "datatype",
1503: ''' || l_subentity || ''' as "sub_entity"),

Line 1509: FROM dual) ';

1505: XMLELement("mod_id", ''' || l_modvalue ||'''),
1506: XMLELement("orig_value", ''' || l_origvalue_desc ||'''),
1507: XMLELement("mod_value", ''' || l_modvalue_desc || '''),
1508: XMLELement("printable_pks", ''' || l_print_string ||'''))
1509: FROM dual) ';
1510: END IF;
1511: END LOOP;
1512:
1513:

Line 1515: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';

1511: END LOOP;
1512:
1513:
1514:
1515: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';
1516: execute immediate l_sql_stmt into l_xml;
1517:
1518:
1519: END IF;