APPS.CN_CLASSIFICATION_GEN dependencies on DUAL

Line 529: SELECT user INTO X_userid FROM sys.dual;

525: cn_utils.appendcr(code, '-- | All rights reserved. | --');
526: cn_utils.appendcr(code, '-- +======================================================================+ --');
527: cn_utils.appendcr(code);
528:
529: SELECT user INTO X_userid FROM sys.dual;
530:
531: cn_utils.appendcr(code, 'SET VERIFY OFF');
532: cn_utils.appendcr(code, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');
533:

Line 548: FROM dual;

544:
545: next_id := cn_utils.get_repository(module_id,x_org_id);
546: SELECT cn_objects_s.NEXTVAL
547: INTO object_id
548: FROM dual;
549: insert into CN_OBJECTS (
550: OBJECT_ID, DEPENDENCY_MAP_COMPLETE, NAME, OBJECT_TYPE, REPOSITORY_ID,
551: OBJECT_STATUS, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
552: LAST_UPDATE_LOGIN, DESCRIPTION, NEXT_SYNCHRONIZATION_DATE,

Line 662: SELECT user INTO X_userid FROM sys.dual;

658: cached_org_id:=x_org_id;
659: cached_org_append:='_'||cached_org_id;
660:
661:
662: SELECT user INTO X_userid FROM sys.dual;
663:
664: X_package_name := Lower(package_name) || cached_org_append;
665:
666: cn_utils.appendcr(code, 'DEFINE PACKAGE_NAME="' || LOWER(x_package_name) || '"');

Line 2096: FROM dual;

2092: -----+
2093:
2094: SELECT user
2095: INTO l_applsys_schema
2096: FROM dual;
2097:
2098: ad_ddl.create_plsql_object(
2099: applsys_schema => l_applsys_schema,
2100: application_short_name => 'CN',

Line 2282: FROM DUAL;

2278: PROCEDURE get_cached_org_info (x_cached_org_id OUT NOCOPY integer, x_cached_org_append OUT NOCOPY VARCHAR2) IS
2279: BEGIN
2280: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
2281: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99) INTO x_cached_org_id
2282: FROM DUAL;
2283:
2284: if x_cached_org_id = -99 then
2285: x_cached_org_append := '_MINUS99';
2286: else