APPS.MSD_COMMON_UTILITIES dependencies on DUAL

Line 324: from sys.dual ;

320: x_temp number ;
321: Begin
322:
323: select msd_level_values_s.nextval into x_temp
324: from sys.dual ;
325:
326: return x_temp;
327:
328:

Line 460: from sys.dual;

456: -- loop until unique key is generated
457: while (v_count > 0) loop
458: select MSD_SR_LEVEL_PK_S.nextval
459: into v_ret
460: from sys.dual;
461:
462: select count(*)
463: into v_count
464: from msd_level_values

Line 491: from sys.dual;

487: while ( v_count1 > 0 OR v_count2 > 0) loop
488:
489: select MSD_SR_LEVEL_PK_S.nextval
490: into v_next
491: from sys.dual;
492:
493: select count(*)
494: into v_count1
495: from msd_st_level_values

Line 1215: execute immediate 'select dbms_aw.interp(:1) from dual' into v_ret using cmd;

1211: /* wrappers for dbms_aw package */
1212: FUNCTION DBMS_AW_INTERP(cmd varchar2) RETURN CLOB IS
1213: v_ret clob;
1214: begin
1215: execute immediate 'select dbms_aw.interp(:1) from dual' into v_ret using cmd;
1216: return v_ret;
1217: end DBMS_AW_INTERP;
1218:
1219: FUNCTION DBMS_AW_INTERPCLOB(cmd clob) RETURN CLOB IS

Line 1222: execute immediate 'select dbms_aw.interpclob(:1) from dual' into v_ret using cmd;

1218:
1219: FUNCTION DBMS_AW_INTERPCLOB(cmd clob) RETURN CLOB IS
1220: v_ret clob;
1221: begin
1222: execute immediate 'select dbms_aw.interpclob(:1) from dual' into v_ret using cmd;
1223: return v_ret;
1224: end DBMS_AW_INTERPCLOB;
1225:
1226: PROCEDURE DBMS_AW_INTERP_SILENT(cmd varchar2) IS