APPS.JTF_DIAGNOSTIC dependencies on DUAL

Line 1474: into v_valsetnumber from dual;

1470:
1471: -- now get the max valuesetnumber and increment it by 1
1472:
1473: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval
1474: into v_valsetnumber from dual;
1475:
1476: -- select max(valuesetnumber) into v_valsetnumber
1477: -- from jtf_diagnostic_arg;
1478:

Line 3034: into V_PRODUCT from dual;

3030: select substr(P_TESTCLASSNAME,
3031: instr(P_TESTCLASSNAME,'.',1,2)+1,
3032: instr(P_TESTCLASSNAME,'.',1,3) -
3033: instr(P_TESTCLASSNAME,'.',1,2) - 1)
3034: into V_PRODUCT from dual;
3035:
3036: select substr(P_TESTCLASSNAME,
3037: instr(P_TESTCLASSNAME,'.',-1,1)+1)
3038: into V_FILENAME from dual;

Line 3038: into V_FILENAME from dual;

3034: into V_PRODUCT from dual;
3035:
3036: select substr(P_TESTCLASSNAME,
3037: instr(P_TESTCLASSNAME,'.',-1,1)+1)
3038: into V_FILENAME from dual;
3039:
3040: END PARSE_TESTCLASSNAME;
3041:
3042: PROCEDURE SEED_TESTSET(

Line 3099: select sysdate into f_ludate from dual;

3095: f_luby number;
3096: f_ludate date;
3097: BEGIN
3098: f_luby := FND_GLOBAL.user_id;
3099: select sysdate into f_ludate from dual;
3100: UPDATE_TESTSET(P_NAME, P_DESCRIPTION, P_XML, f_luby, f_ludate);
3101: END UPDATE_TESTSET;
3102:
3103: PROCEDURE UPDATE_TESTSET(

Line 3127: select sysdate into f_ludate from dual;

3123: f_luby number;
3124: f_ludate date;
3125: BEGIN
3126: f_luby := FND_GLOBAL.user_id;
3127: select sysdate into f_ludate from dual;
3128: INSERT_TESTSET(P_NAME, P_DESCRIPTION, P_XML, f_luby, f_ludate, null, f_luby, f_ludate);
3129: END INSERT_TESTSET;
3130:
3131: PROCEDURE INSERT_TESTSET(

Line 3163: SELECT SYSDATE INTO F_LUDATE FROM DUAL;

3159: F_LUBY NUMBER;
3160: F_LUDATE DATE;
3161: BEGIN
3162: F_LUBY := FND_GLOBAL.user_id;
3163: SELECT SYSDATE INTO F_LUDATE FROM DUAL;
3164: UPDATE_VALID_APPS(P_APPSHORTNAME, P_GROUPNAME, P_TESTCLASSNAME,P_VALIDAPPS, F_LUBY, F_LUDATE);
3165: END UPDATE_VALID_APPS;
3166:
3167: -- ------------------------------------------------------------------------------------------