DBA Data[Home] [Help]

APPS.IEO_SVR_UTIL_PVT dependencies on DUAL

Line 447: --VARRAYS allows assigning to individual object attributes i use it..

443: END IF;
444: END IF;
445:
446: --dude!!! I am using a combination of VARRAY and NST.. because
447: --VARRAYS allows assigning to individual object attributes i use it..
448:
449: --dbms_output.put_line( 'server found :' || c1_rec.SERVER_NAME );
450: v_svr_info_list(c1%ROWCOUNT).SERVER_NAME := c1_rec.SERVER_NAME;
451: v_svr_info_list(c1%ROWCOUNT).SERVER_ID := c1_rec.SERVER_ID;

Line 624: FROM dual;

620:
621: -- Get the current time:
622: SELECT sysdate
623: INTO X_DB_TIME
624: FROM dual;
625: END IF;
626:
627:
628: EXCEPTION

Line 727: SELECT sysdate INTO X_DB_TIME FROM dual;

723: then
724: X_SVR_INFO_LIST := NULL;
725: end IF;
726:
727: SELECT sysdate INTO X_DB_TIME FROM dual;
728:
729: EXCEPTION
730: WHEN OTHERS THEN
731: RAISE;