APPS.MSC_X_USER_EXCEP_GEN dependencies on DUAL

Line 1754: select msc_x_exception_details_s.nextval into v_EXCEPTION_DETAIL_ID(i) from dual;

1750: v_CREATED_BY(i) := v_user_id ;
1751: v_CREATION_DATE(i) := vLastUpdateDate;
1752: v_LAST_UPDATED_BY(i) := v_user_id;
1753: v_LAST_UPDATE_DATE(i) := vLastUpdateDate;
1754: select msc_x_exception_details_s.nextval into v_EXCEPTION_DETAIL_ID(i) from dual;
1755: vExceptionTypeArray(i) := v_exception_id;
1756: vExceptionTypeNameArray(i) := v_exception_name;
1757: vExceptionGroupArray(i) := -99;
1758: vExceptionGroupNameArray(i) := vExceptionGroupName;

Line 2098: into details_url from dual;

2094:
2095: -- 'exceptiodDetailId='||to_char(v_EXCEPTION_DETAIL_ID(rowCounter));
2096:
2097: /* select fnd_profile.VALUE_SPECIFIC('APPS_WEB_AGENT',v_user_id)
2098: into details_url from dual;
2099:
2100: Select function_id into lFunctionId
2101: from fnd_form_functions
2102: where function_name = 'MSC_EXCEPTION_DETAILS';

Line 3366: lSQLString := 'select 1 from dual where rownum = 1 and '||capsAdvString;

3362:
3363: log_message('cal string='||lSQLString);
3364: execute immediate lSQLString;
3365: else
3366: lSQLString := 'select 1 from dual where rownum = 1 and '||capsAdvString;
3367: log_message('cal string='||lSQLString);
3368: execute immediate lSQLString;
3369:
3370: end if;

Line 3422: lSQLString := 'select ( '||pCalculationString||') from dual ';

3418: lSQLString := 'select '||pCalculationString||fromString;
3419: log_message('cal string='||lSQLString);
3420: execute immediate lSQLString;
3421: else
3422: lSQLString := 'select ( '||pCalculationString||') from dual ';
3423: log_message('cal string='||lSQLString);
3424: execute immediate lSQLString;
3425:
3426: end if;

Line 3580: into lexceptionId from dual;

3576: lAttribute15 VARCHAR2(240);
3577: lContext VARCHAR2(240);
3578: begin
3579: select MSC_USER_EXCEPTIONS_S.NEXTVAL
3580: into lexceptionId from dual;
3581:
3582: insert into MSC_USER_EXCEPTIONS(
3583: EXCEPTION_ID
3584: ,NAME