APPS.ICX_POR_CTX_DESC dependencies on DUAL

Line 818: FROM DUAL

814: xErrLoc := 500;
815: BEGIN
816: SELECT 1
817: INTO vCatTableExists
818: FROM DUAL
819: WHERE EXISTS
820: (SELECT 1
821: FROM ICX_CAT_DESCRIPTORS_TL
822: WHERE RT_CATEGORY_ID=p_category_id

Line 854: FROM DUAL

850: xErrLoc := 620;
851: BEGIN
852: SELECT 1
853: INTO vSearchableExists
854: FROM DUAL
855: WHERE EXISTS
856: (SELECT 1
857: FROM ICX_CAT_DESCRIPTORS_TL
858: WHERE RT_CATEGORY_ID=p_category_id

Line 936: select instr(versionString, '.') into majorReleasePos from dual;

932: /*
933: majorVersion := substr(versionString, 1, 1);
934: minorVersion := substr(versionString, 3, 1);
935: */
936: select instr(versionString, '.') into majorReleasePos from dual;
937: select instr(substr(versionString,majorReleasePos), '.')
938: into minorReleasePos from dual;
939:
940: xErrLoc := 30;

Line 938: into minorReleasePos from dual;

934: minorVersion := substr(versionString, 3, 1);
935: */
936: select instr(versionString, '.') into majorReleasePos from dual;
937: select instr(substr(versionString,majorReleasePos), '.')
938: into minorReleasePos from dual;
939:
940: xErrLoc := 30;
941: majorVersion := substr(versionString, 1, majorReleasePos-1);
942: minorVersion := substr(versionString, majorReleasePos+1, minorReleasePos);