APPS.CN_UTILS dependencies on DUAL

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

544: cn_utils.appendcr(code, '-- | All rights reserved. | --');
545: cn_utils.appendcr(code, '-- +======================================================================+ --');
546: cn_utils.appendcr(code);
547:
548: SELECT user INTO X_userid FROM sys.dual;
549:
550: cn_utils.appendcr(code, '--');
551: cn_utils.appendcr(code, '-- Package Name');
552: cn_utils.appendcr(code, '-- ' || package_name);

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

586: cn_utils.appendcr(code, '-- | All rights reserved. | --');
587: cn_utils.appendcr(code, '-- +======================================================================+ --');
588: cn_utils.appendcr(code);
589:
590: SELECT user INTO X_userid FROM sys.dual;
591:
592: cn_utils.appendcr(code, '--');
593: cn_utils.appendcr(code, '-- Package Name');
594: cn_utils.appendcr(code, '-- ' || package_name);

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

767: cn_utils.appendcr(code, '-- | All rights reserved. | --');
768: cn_utils.appendcr(code, '-- +======================================================================+ --');
769: cn_utils.appendcr(code);
770:
771: SELECT user INTO X_userid FROM sys.dual;
772:
773: cn_utils.appendcr(code, '--');
774: cn_utils.appendcr(code, '-- Package Name');
775: cn_utils.appendcr(code, '-- ' || package_name);

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

806: cn_utils.appendcr(code, '-- | All rights reserved. | --');
807: cn_utils.appendcr(code, '-- +======================================================================+ --');
808: cn_utils.appendcr(code);
809:
810: SELECT user INTO X_userid FROM sys.dual;
811:
812: cn_utils.appendcr(code, '--');
813: cn_utils.appendcr(code, '-- Package Name');
814: cn_utils.appendcr(code, '-- ' || package_name);

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

976:
977: X_userid VARCHAR2(20);
978:
979: BEGIN
980: SELECT user INTO X_userid FROM sys.dual;
981:
982: cn_utils.appendcr(code, '--');
983: cn_utils.appendcr(code, '-- Procedure Name');
984: cn_utils.appendcr(code, '-- ' || procedure_name);

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

998:
999: X_userid VARCHAR2(20);
1000:
1001: BEGIN
1002: SELECT user INTO X_userid FROM sys.dual;
1003:
1004: cn_utils.appendcr(code, '--');
1005: cn_utils.appendcr(code, '-- Procedure Name');
1006: cn_utils.appendcr(code, '-- ' || procedure_name);

Line 1586: FROM sys.dual;

1582: x_process_audit_id cn_process_audits.process_audit_id%TYPE;
1583: BEGIN
1584: SELECT cn_process_audits_s.NEXTVAL
1585: INTO x_process_audit_id
1586: FROM sys.dual;
1587: RETURN x_process_audit_id;
1588: END get_proc_audit_id;
1589:
1590:

Line 1597: FROM sys.dual;

1593: x_object_id cn_objects.object_id%TYPE;
1594: BEGIN
1595: SELECT cn_objects_s.NEXTVAL
1596: INTO x_object_id
1597: FROM sys.dual;
1598: RETURN x_object_id;
1599: END get_object_id;
1600:
1601:

Line 1608: FROM sys.dual;

1604: x_mod_obj_depends_id cn_mod_obj_depends.mod_obj_depends_id%TYPE;
1605: BEGIN
1606: SELECT cn_mod_obj_depends_s.NEXTVAL
1607: INTO x_mod_obj_depends_id
1608: FROM sys.dual;
1609: RETURN x_mod_obj_depends_id;
1610: END get_mod_obj_depends_id;
1611:
1612: