REM--------------------------------------------------------------------------------------------------------- REM-- Copywright 2000, david wendleken & chet west REM--------------------------------------------------------------------------------------------------------- REM Program: mkdomain.sql REM Author : David Wendelken REM Genesis: 10-Jun-1997 REM REM Purpose: To create default domain definitions for new applications. REM REM Modifications: REM 19-SEP-2000 (Chet West): Updated to work with Designer 6i and added REM additional Domains. Put API functions in the database. PROMPT Enter the Context Workarea Name DEFINE p_context_workarea_name='&1' PROMPT Enter the Application System Name DEFINE p_appl_sys_name='&2' PROMPT Enter the output filename DEFINE p_filename='&3' REM This is a wide report, so set the line width accordingly. set linesize 132 set pagesize 66 REM Let's not clutter up the screen and page with program code. REM set verify off REM set echo off REM set feedback off REM Force diagnostic output on so that the user can see what progress REM is being made and what the program did. REM Increase the size of this buffer if your application is very large REM and you get a buffer-overflow error. SET serveroutput ON SET serveroutput ON SIZE 1000000 SPOOL &p_filename DECLARE -- create default domain definitions. lws_last_domain_id NUMBER; BEGIN -- -- Initialize d2k_api_util.show_messages_on; d2k_api_util.initialize_api('&p_context_workarea_name','&p_appl_sys_name'); -- -- Date Domains -- lws_last_domain_id := d2k_api_util.create_domain('DATE' ,'DATE',NULL,NULL,NULL ,'DATE',NULL,NULL,NULL ,'Y',NULL ,NULL ,NULL,NULL,NULL,NULL,'Any valid date.'); lws_last_domain_id := d2k_api_util.create_domain('DATE_EFFECTIVE' ,'DATE',NULL,NULL,NULL ,'DATE',NULL,NULL,NULL ,'Y','DATE' ,NULL ,NULL,NULL,NULL,NULL,'The date this record is valid.'); lws_last_domain_id := d2k_api_util.create_domain('DATE_EXPIRED' ,'DATE',NULL,NULL,NULL ,'DATE',NULL,NULL,NULL ,'Y','DATE' ,NULL ,NULL,NULL,NULL,NULL,'The date this record is no longer valid.'); lws_last_domain_id := d2k_api_util.create_domain('DATE_CREATED' ,'DATE',NULL,NULL,NULL ,'DATE',NULL,NULL,NULL ,'Y','DATE' ,NULL ,NULL,NULL,NULL,NULL,'The date this record was created.'); lws_last_domain_id := d2k_api_util.create_domain('DATE_MODIFIED' ,'DATE',NULL,NULL,NULL ,'DATE',NULL,NULL,NULL ,'Y','DATE' ,NULL ,NULL,NULL,NULL,NULL,'The date this record was last modified.'); lws_last_domain_id := d2k_api_util.create_domain('TODAY' ,'DATE',NULL,NULL,NULL ,'DATE',NULL,NULL,NULL ,'Y','DATE' ,'SYSDATE' ,NULL,NULL,NULL,NULL,'Today''s date.'); lws_last_domain_id := d2k_api_util.create_domain('YESTERDAY' ,'DATE',NULL,NULL,NULL ,'DATE',NULL,NULL,NULL ,'Y','DATE' ,'SYSDATE - 1',NULL,NULL,NULL,NULL,'Yesterday''s date.'); -- -- Names, Codes, Remarks and other text items -- lws_last_domain_id := d2k_api_util.create_domain('DESCRIPTION' ,'VARCHAR2',30,NULL,20 ,'VARCHAR2',30,NULL,20 ,'Y',NULL ,NULL ,NULL,NULL,NULL,NULL,'A description for this record.'); lws_last_domain_id := d2k_api_util.create_domain('NAME' ,'VARCHAR2',30,NULL,30 ,'VARCHAR2',30,NULL,30 ,'Y',NULL ,NULL ,NULL,NULL,NULL,NULL,'A name for this record.'); lws_last_domain_id := d2k_api_util.create_domain('REMARK_SHORT' ,'VARCHAR2',70,NULL,10 ,'VARCHAR2',70,NULL,10 ,'Y','DESCRIPTION',NULL ,NULL,NULL,NULL,NULL,'A brief comment or note about this object.'); lws_last_domain_id := d2k_api_util.create_domain('REMARK_LONG' ,'VARCHAR2',2000,NULL,20,'VARCHAR2',2000,NULL,20,'Y','DESCRIPTION',NULL ,NULL,NULL,NULL,NULL,'A comment or note about this object.'); lws_last_domain_id := d2k_api_util.create_domain('CODE' ,'VARCHAR2',5,NULL,5 ,'VARCHAR2',5,NULL,5 ,'Y','DESCRIPTION',NULL ,NULL,NULL,NULL,NULL,'The name of this object.'); -- -- People and User names and User Ids -- lws_last_domain_id := d2k_api_util.create_domain('USERID' ,'VARCHAR2',30,NULL,8 ,'VARCHAR2',30,NULL,8 ,'Y',NULL ,NULL ,NULL,NULL,NULL,NULL,'A general purpose user id.'); lws_last_domain_id := d2k_api_util.create_domain('CREATED_BY' ,'VARCHAR2',30,NULL,12 ,'VARCHAR2',30,NULL,12 ,'Y','USERID' ,NULL ,NULL,NULL,NULL,NULL,'The userid of the user who created this record.'); lws_last_domain_id := d2k_api_util.create_domain('MODIFIED_BY' ,'VARCHAR2',30,NULL,12 ,'VARCHAR2',30,NULL,12 ,'Y','USERID' ,NULL ,NULL,NULL,NULL,NULL,'The userid of the user who last modified this record.'); lws_last_domain_id := d2k_api_util.create_domain('NAME_FIRST' ,'VARCHAR2',30,NULL,15 ,'VARCHAR2',30,NULL,15 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'A first name for this person.'); lws_last_domain_id := d2k_api_util.create_domain('NAME_LAST' ,'VARCHAR2',30,NULL,15 ,'VARCHAR2',30,NULL,15 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'A last name for this person.'); lws_last_domain_id := d2k_api_util.create_domain('NAME_MIDDLE' ,'VARCHAR2',30,NULL,1 ,'VARCHAR2',30,NULL,1 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'A middle name or initial for this person.'); lws_last_domain_id := d2k_api_util.create_domain('NAME_PREFIX' ,'VARCHAR2',30,NULL,3 ,'VARCHAR2',30,NULL,3 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'A prefix or salutation for this person.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Mr.' ,NULL,NULL,'Mister'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'Mrs.' ,NULL,NULL,'Misses'); d2k_api_util.create_domain_values(lws_last_domain_id, 3,'Ms.' ,NULL,NULL,'Miss'); d2k_api_util.create_domain_values(lws_last_domain_id, 4,'Miss.',NULL,NULL,'Miss'); d2k_api_util.create_domain_values(lws_last_domain_id, 5,'Dr.' ,NULL,NULL,'Doctor'); d2k_api_util.create_domain_values(lws_last_domain_id, 6,'Prof.',NULL,NULL,'Professor'); lws_last_domain_id := d2k_api_util.create_domain('NAME_SUFFIX' ,'VARCHAR2',30,NULL,3 ,'VARCHAR2',30,NULL,3 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'A suffix for this person.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Sr.' ,NULL,'SR','Senior'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'Jr.' ,NULL,'JR','Junior'); d2k_api_util.create_domain_values(lws_last_domain_id, 3,'I' ,NULL,NULL,'The First'); d2k_api_util.create_domain_values(lws_last_domain_id, 4,'II' ,NULL,NULL,'The Second'); d2k_api_util.create_domain_values(lws_last_domain_id, 5,'III' ,NULL,NULL,'The Third'); d2k_api_util.create_domain_values(lws_last_domain_id, 6,'IV' ,NULL,NULL,'The Forth'); d2k_api_util.create_domain_values(lws_last_domain_id, 7,'PHD' ,NULL,NULL,'Doctor'); d2k_api_util.create_domain_values(lws_last_domain_id, 8,'DDS' ,NULL,NULL,'Dentist'); d2k_api_util.create_domain_values(lws_last_domain_id, 9,'CPA' ,NULL,NULL,'Certified Public Accountant'); d2k_api_util.create_domain_values(lws_last_domain_id,10,'PE' ,NULL,NULL,'Professional Engineer'); -- -- Address and location related items -- lws_last_domain_id := d2k_api_util.create_domain('ADDRESS' ,'VARCHAR2',70,NULL,10 ,'VARCHAR2',70,NULL,10 ,'Y','DESCRIPTION',NULL ,NULL,NULL,NULL,NULL,'A line of an address.'); lws_last_domain_id := d2k_api_util.create_domain('CITY' ,'VARCHAR2',30,NULL,12 ,'VARCHAR2',30,NULL,12 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'The name of this city.'); lws_last_domain_id := d2k_api_util.create_domain('STATE_PROVINCE' ,'VARCHAR2',30,NULL,12 ,'VARCHAR2',30,NULL,12 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'The name of this state or province.'); lws_last_domain_id := d2k_api_util.create_domain('STATE' ,'VARCHAR2',6,NULL,3 ,'VARCHAR2',6,NULL,3 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'The state.'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AL',NULL,NULL,'Alabama'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 2,'AK',NULL,NULL,'Alaska'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 3,'AZ',NULL,NULL,'Arizona'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 4,'AR',NULL,NULL,'Arkansas'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 5,'CA',NULL,NULL,'California'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 6,'CO',NULL,NULL,'Colorado'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 7,'CT',NULL,NULL,'Connecticut'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 8,'DE',NULL,NULL,'Delaware'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 9,'DC',NULL,NULL,'District of Columbia'); -- d2k_api_util.create_domain_values(lws_last_domain_id,10,'FL',NULL,NULL,'Florida'); -- d2k_api_util.create_domain_values(lws_last_domain_id,11,'GA',NULL,NULL,'Georgia'); -- d2k_api_util.create_domain_values(lws_last_domain_id,12,'GU',NULL,NULL,'Guam'); -- d2k_api_util.create_domain_values(lws_last_domain_id,13,'HI',NULL,NULL,'Hawaii'); -- d2k_api_util.create_domain_values(lws_last_domain_id,14,'ID',NULL,NULL,'Idaho'); -- d2k_api_util.create_domain_values(lws_last_domain_id,15,'IL',NULL,NULL,'Illinois'); -- d2k_api_util.create_domain_values(lws_last_domain_id,16,'IN',NULL,NULL,'Indiana'); -- d2k_api_util.create_domain_values(lws_last_domain_id,17,'IA',NULL,NULL,'Iowa'); -- d2k_api_util.create_domain_values(lws_last_domain_id,18,'KS',NULL,NULL,'Kansas'); -- d2k_api_util.create_domain_values(lws_last_domain_id,19'KY',NULL,NULL,'Kentucky'); -- d2k_api_util.create_domain_values(lws_last_domain_id,20,'LA',NULL,NULL,'Louisiana'); -- d2k_api_util.create_domain_values(lws_last_domain_id,21,'ME',NULL,NULL,'Maine'); -- d2k_api_util.create_domain_values(lws_last_domain_id,22,'MD',NULL,NULL,'Maryland'); -- d2k_api_util.create_domain_values(lws_last_domain_id,23,'MA',NULL,NULL,'Massachusetts'); -- d2k_api_util.create_domain_values(lws_last_domain_id,24,'MI',NULL,NULL,'Michigan'); -- d2k_api_util.create_domain_values(lws_last_domain_id,25,'MN',NULL,NULL,'Minnesota'); -- d2k_api_util.create_domain_values(lws_last_domain_id,26,'MS',NULL,NULL,'Mississippi'); -- d2k_api_util.create_domain_values(lws_last_domain_id,27,'MO',NULL,NULL,'Missouri'); -- d2k_api_util.create_domain_values(lws_last_domain_id,28,'MT',NULL,NULL,'Montana'); -- d2k_api_util.create_domain_values(lws_last_domain_id,29,'NE',NULL,NULL,'Nebraska'); -- d2k_api_util.create_domain_values(lws_last_domain_id,30,'NV',NULL,NULL,'Nevada'); -- d2k_api_util.create_domain_values(lws_last_domain_id,31,'NH',NULL,NULL,'New Hampshire'); -- d2k_api_util.create_domain_values(lws_last_domain_id,32,'NJ',NULL,NULL,'New Jersey'); -- d2k_api_util.create_domain_values(lws_last_domain_id,33,'NM',NULL,NULL,'New Mexico'); -- d2k_api_util.create_domain_values(lws_last_domain_id,34,'NY',NULL,NULL,'New York'); -- d2k_api_util.create_domain_values(lws_last_domain_id,35,'NC',NULL,NULL,'North Carolina'); -- d2k_api_util.create_domain_values(lws_last_domain_id,36,'ND',NULL,NULL,'North Dakota'); -- d2k_api_util.create_domain_values(lws_last_domain_id,37,'NS',NULL,NULL,'Nova Scotia'); -- d2k_api_util.create_domain_values(lws_last_domain_id,38,'OH',NULL,NULL,'Ohio'); -- d2k_api_util.create_domain_values(lws_last_domain_id,39,'OK',NULL,NULL,'Oklahoma'); -- d2k_api_util.create_domain_values(lws_last_domain_id,40,'ON',NULL,NULL,'Ontario'); -- d2k_api_util.create_domain_values(lws_last_domain_id,41,'OR',NULL,NULL,'Oregon'); -- d2k_api_util.create_domain_values(lws_last_domain_id,42,'PA',NULL,NULL,'Pennsylvania'); -- d2k_api_util.create_domain_values(lws_last_domain_id,43,'PR',NULL,NULL,'Puerto Rico'); -- d2k_api_util.create_domain_values(lws_last_domain_id,44,'RI',NULL,NULL,'Rhode Island'); -- d2k_api_util.create_domain_values(lws_last_domain_id,45,'SC',NULL,NULL,'South Carolina'); -- d2k_api_util.create_domain_values(lws_last_domain_id,46,'SD',NULL,NULL,'South Dakota'); -- d2k_api_util.create_domain_values(lws_last_domain_id,47,'TN',NULL,NULL,'Tennessee'); -- d2k_api_util.create_domain_values(lws_last_domain_id,48,'TX',NULL,NULL,'Texas'); -- d2k_api_util.create_domain_values(lws_last_domain_id,49,'UT',NULL,NULL,'Utah'); -- d2k_api_util.create_domain_values(lws_last_domain_id,50,'VT',NULL,NULL,'Vermont'); -- d2k_api_util.create_domain_values(lws_last_domain_id,51,'VI',NULL,NULL,'Virgin Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id,52,'VA',NULL,NULL,'Virginia'); -- d2k_api_util.create_domain_values(lws_last_domain_id,53,'WA',NULL,NULL,'Washington'); -- d2k_api_util.create_domain_values(lws_last_domain_id,54,'WV',NULL,NULL,'West Virginia'); -- d2k_api_util.create_domain_values(lws_last_domain_id,55,'WI',NULL,NULL,'Wisconsin'); -- d2k_api_util.create_domain_values(lws_last_domain_id,56,'WY',NULL,NULL,'Wyoming'); -- d2k_api_util.create_domain_values(lws_last_domain_id,57,'NA',NULL,NULL,'Not in US'); lws_last_domain_id := d2k_api_util.create_domain('PROVINCE_CODE' ,'VARCHAR2',6,NULL,3 ,'VARCHAR2',20,NULL,8 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'The province.'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Alberta',NULL,NULL,'Alberta'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'British Columbia',NULL,NULL,'British Columbia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Manitoba',NULL,NULL,'Manitoba'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'New Brunswick',NULL,NULL,'New Brunswick'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Newfoundland',NULL,NULL,'Newfoundland'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Northwest Territories',NULL,NULL,'Northwest Territories'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Nova Scotia',NULL,NULL,'Nova Scotia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Nunavut',NULL,NULL,'Nunavut'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Ontario',NULL,NULL,'Ontario'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Prince Edward Island',NULL,NULL,'Prince Edward Island'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Quebec',NULL,NULL,'Quebec'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Saskatchewan',NULL,NULL,'Saskatchewan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Yukon',NULL,NULL,'Yukon'); lws_last_domain_id := d2k_api_util.create_domain('COUNTRY' ,'VARCHAR2',30,NULL,2 ,'VARCHAR2',30,NULL,2 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'The name of this country.'); lws_last_domain_id := d2k_api_util.create_domain('COUNTRY_CODE' ,'VARCHAR2',6,NULL,2 ,'VARCHAR2',6,NULL,2 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'The ISO code for this country.'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'USA',NULL,'USA','United States of America'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AF',NULL,NULL,'Afghanistan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AL',NULL,NULL,'Albania'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'DZ',NULL,NULL,'Algeria'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AS',NULL,NULL,'American Samoa'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AD',NULL,NULL,'Andorra'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AO',NULL,NULL,'Angola'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AI',NULL,NULL,'Anguilla'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AQ',NULL,NULL,'Antarctica'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AG',NULL,NULL,'Antigua and Barbuda'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AR',NULL,NULL,'Argentina'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AM',NULL,NULL,'Armenia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AW',NULL,NULL,'Aruba'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AU',NULL,NULL,'Australia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AT',NULL,NULL,'Austria'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AZ',NULL,NULL,'Azerbaijan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BS',NULL,NULL,'Bahamas'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BH',NULL,NULL,'Bahrain'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BD',NULL,NULL,'Bangladesh'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BB',NULL,NULL,'Barbados'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BY',NULL,NULL,'Belarus'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BE',NULL,NULL,'Belgium'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BZ',NULL,NULL,'Belize'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BJ',NULL,NULL,'Benin'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BM',NULL,NULL,'Bermuda'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BT',NULL,NULL,'Bhutan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BO',NULL,NULL,'Bolivia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BA',NULL,NULL,'Bosnia and Herzegovina'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BW',NULL,NULL,'Botswana'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BV',NULL,NULL,'Bouvet Island'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BR',NULL,NULL,'Brazil'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'IO',NULL,NULL,'British Indian Ocean Territory'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BN',NULL,NULL,'Brunei Darussalam'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BG',NULL,NULL,'Bulgaria'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BF',NULL,NULL,'Burkina Faso'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'BI',NULL,NULL,'Burundi'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KH',NULL,NULL,'Cambodia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CM',NULL,NULL,'Cameroon'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CA',NULL,NULL,'Canada'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CV',NULL,NULL,'Cape Verde'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KY',NULL,NULL,'Cayman Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CF',NULL,NULL,'Central African Republic'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TD',NULL,NULL,'Chad'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CL',NULL,NULL,'Chile'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CN',NULL,NULL,'China'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CX',NULL,NULL,'Christmas Island'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CC',NULL,NULL,'Cocos (Keeling) Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CO',NULL,NULL,'Colombia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KM',NULL,NULL,'Comoros'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CG',NULL,NULL,'Congo'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CK',NULL,NULL,'Cook Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CR',NULL,NULL,'Costa Rica'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CI',NULL,NULL,'Cote d'Ivoire'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'HR',NULL,NULL,'Croatia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CU',NULL,NULL,'Cuba'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CY',NULL,NULL,'Cyprus'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CZ',NULL,NULL,'Czech Republic'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'DK',NULL,NULL,'Denmark'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'DJ',NULL,NULL,'Djibouti'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'DM',NULL,NULL,'Dominica'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'DO',NULL,NULL,'Dominican Republic'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TP',NULL,NULL,'East Timor'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'EC',NULL,NULL,'Ecuador'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'EG',NULL,NULL,'Egypt'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SV',NULL,NULL,'El Salvador'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GQ',NULL,NULL,'Equatorial Guinea'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ER',NULL,NULL,'Eritrea'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'EE',NULL,NULL,'Estonia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ET',NULL,NULL,'Ethiopia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'FK',NULL,NULL,'Falkland Islands (Malvinas)'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'FO',NULL,NULL,'Faroe Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'FJ',NULL,NULL,'Fiji'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'FI',NULL,NULL,'Finland'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'FR',NULL,NULL,'France'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'FX',NULL,NULL,'France, Metropolitan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GF',NULL,NULL,'French Guiana'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PF',NULL,NULL,'French Polynesia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TF',NULL,NULL,'French Southern Territories'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GA',NULL,NULL,'Gabon'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GM',NULL,NULL,'Gambia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GE',NULL,NULL,'Georgia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'DE',NULL,NULL,'Germany'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GH',NULL,NULL,'Ghana'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GI',NULL,NULL,'Gibraltar'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GR',NULL,NULL,'Greece'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GL',NULL,NULL,'Greenland'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GD',NULL,NULL,'Grenada'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GP',NULL,NULL,'Guadeloupe'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GU',NULL,NULL,'Guam'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GT',NULL,NULL,'Guatemala'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GN',NULL,NULL,'Guinea'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GW',NULL,NULL,'Guinea-Bissau'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GY',NULL,NULL,'Guyana'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'HT',NULL,NULL,'Haiti'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'HM',NULL,NULL,'Heard Island and McDonald Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'HN',NULL,NULL,'Honduras'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'HK',NULL,NULL,'Hong Kong'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'HU',NULL,NULL,'Hungary'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'IS',NULL,NULL,'Iceland'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'IN',NULL,NULL,'India'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ID',NULL,NULL,'Indonesia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'IR',NULL,NULL,'Iran (Islamic Republic of)'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'IQ',NULL,NULL,'Iraq'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'IE',NULL,NULL,'Ireland'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'IL',NULL,NULL,'Israel'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'IT',NULL,NULL,'Italy'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'JM',NULL,NULL,'Jamaica'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'JP',NULL,NULL,'Japan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'JO',NULL,NULL,'Jordan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KZ',NULL,NULL,'Kazakhstan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KE',NULL,NULL,'Kenya'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KI',NULL,NULL,'Kiribati'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KP',NULL,NULL,'Korea, Democratic People's Republic of'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KR',NULL,NULL,'Korea, Republic of'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KW',NULL,NULL,'Kuwait'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KG',NULL,NULL,'Kyrgyzstan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LA',NULL,NULL,'Lao People's Democratic Republic'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LT',NULL,NULL,'Latin America'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LV',NULL,NULL,'Latvia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LB',NULL,NULL,'Lebanon'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LS',NULL,NULL,'Lesotho'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LR',NULL,NULL,'Liberia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LY',NULL,NULL,'Libyan Arab Jamahiriya'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LI',NULL,NULL,'Liechtenstein'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LX',NULL,NULL,'Lithuania'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LU',NULL,NULL,'Luxembourg'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MO',NULL,NULL,'Macau'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MK',NULL,NULL,'Macedonia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MG',NULL,NULL,'Madagascar'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MW',NULL,NULL,'Malawi'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MY',NULL,NULL,'Malaysia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MV',NULL,NULL,'Maldives'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ML',NULL,NULL,'Mali'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MT',NULL,NULL,'Malta'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MH',NULL,NULL,'Marshall Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MQ',NULL,NULL,'Martinique'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MR',NULL,NULL,'Mauritania'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MU',NULL,NULL,'Mauritius'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'YT',NULL,NULL,'Mayotte'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MX',NULL,NULL,'Mexico'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'FM',NULL,NULL,'Micronesia (Federated States of)'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MD',NULL,NULL,'Moldova, Republic of'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MC',NULL,NULL,'Monaco'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MN',NULL,NULL,'Mongolia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MS',NULL,NULL,'Montserrat'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MA',NULL,NULL,'Morocco'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MZ',NULL,NULL,'Mozambique'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MM',NULL,NULL,'Myanmar'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NA',NULL,NULL,'Namibia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NR',NULL,NULL,'Nauru'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NP',NULL,NULL,'Nepal'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NL',NULL,NULL,'Netherlands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AN',NULL,NULL,'Netherlands Antilles'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NC',NULL,NULL,'New Caledonia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NZ',NULL,NULL,'New Zealand'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NI',NULL,NULL,'Nicaragua'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NE',NULL,NULL,'Niger'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NG',NULL,NULL,'Nigeria'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NU',NULL,NULL,'Niue'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NF',NULL,NULL,'Norfolk Island'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'MP',NULL,NULL,'Northern Mariana Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'NO',NULL,NULL,'Norway'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'OM',NULL,NULL,'Oman'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PK',NULL,NULL,'Pakistan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PW',NULL,NULL,'Palau'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PA',NULL,NULL,'Panama'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PG',NULL,NULL,'Papua New Guinea'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PY',NULL,NULL,'Paraguay'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PE',NULL,NULL,'Peru'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PH',NULL,NULL,'Philippines'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PN',NULL,NULL,'Pitcairn'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PL',NULL,NULL,'Poland'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PT',NULL,NULL,'Portugal'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PR',NULL,NULL,'Puerto Rico'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'QA',NULL,NULL,'Qatar'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'RE',NULL,NULL,'Reunion'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'RO',NULL,NULL,'Romania'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'RU',NULL,NULL,'Russian Federation'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'RW',NULL,NULL,'Rwanda'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SH',NULL,NULL,'Saint Helena'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'KN',NULL,NULL,'Saint Kitts and Nevis'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LC',NULL,NULL,'Saint Lucia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PM',NULL,NULL,'Saint Pierre and Miquelon'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'VC',NULL,NULL,'Saint Vincent and the Grenadines'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'WS',NULL,NULL,'Samoa'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SM',NULL,NULL,'San Marino'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ST',NULL,NULL,'Sao Tome and Principe'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SA',NULL,NULL,'Saudi Arabia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SN',NULL,NULL,'Senegal'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SC',NULL,NULL,'Seychelles'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SL',NULL,NULL,'Sierra Leone'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SG',NULL,NULL,'Singapore'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SK',NULL,NULL,'Slovakia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SI',NULL,NULL,'Slovenia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SB',NULL,NULL,'Solomon Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SO',NULL,NULL,'Somalia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ZA',NULL,NULL,'South Africa'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GS',NULL,NULL,'South Georgia and the South Sandwich Island'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ES',NULL,NULL,'Spain'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'LK',NULL,NULL,'Sri Lanka'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SD',NULL,NULL,'Sudan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SR',NULL,NULL,'Suriname'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SJ',NULL,NULL,'Svalbard and Jan Mayen Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SZ',NULL,NULL,'Swaziland'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SE',NULL,NULL,'Sweden'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CH',NULL,NULL,'Switzerland'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'SY',NULL,NULL,'Syrian Arab Republic'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TW',NULL,NULL,'Taiwan, Republic of China'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TJ',NULL,NULL,'Tajikistan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TZ',NULL,NULL,'Tanzania, United Republic of'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TH',NULL,NULL,'Thailand'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TG',NULL,NULL,'Togo'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TK',NULL,NULL,'Tokelau'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TO',NULL,NULL,'Tonga'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TT',NULL,NULL,'Trinidad and Tobago'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TN',NULL,NULL,'Tunisia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TR',NULL,NULL,'Turkey'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TM',NULL,NULL,'Turkmenistan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TC',NULL,NULL,'Turks and Caicos Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'TV',NULL,NULL,'Tuvalu'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'UG',NULL,NULL,'Uganda'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'UA',NULL,NULL,'Ukraine'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'AE',NULL,NULL,'United Arab Emirates'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GB',NULL,NULL,'United Kingdom'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'UY',NULL,NULL,'Uruguay'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'UZ',NULL,NULL,'Uzbekistan'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'VU',NULL,NULL,'Vanuatu'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'VA',NULL,NULL,'Vatican City State (Holy See)'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'VE',NULL,NULL,'Venezuela'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'VN',NULL,NULL,'Viet Nam'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'VG',NULL,NULL,'Virgin Islands (British)'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'VI',NULL,NULL,'Virgin Islands (U.S.)'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'WF',NULL,NULL,'Wallis and Futuna Islands'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'EH',NULL,NULL,'Western Sahara'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'YE',NULL,NULL,'Yemen'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'YU',NULL,NULL,'Yugoslavia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ZR',NULL,NULL,'Zaire'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ZM',NULL,NULL,'Zambia'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ZW',NULL,NULL,'Zimbabwe'); lws_last_domain_id := d2k_api_util.create_domain('POSTAL_CODE' ,'VARCHAR2',10,NULL,10 ,'VARCHAR2',10,NULL,10 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'The postal code for this address.'); lws_last_domain_id := d2k_api_util.create_domain('PHONE_TYPE' ,'VARCHAR2',12,NULL,10 ,'VARCHAR2',12,NULL,10 ,'Y','NAME' ,NULL ,NULL,NULL,NULL,NULL,'The primary use of this phone.'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ADMIN',NULL,NULL,'Admin Asst'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'CELL',NULL,NULL,'Cellular'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'EMAIL',NULL,NULL,'E-Mail'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'FAX',NULL,NULL,'Fax'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'GENERAL',NULL,NULL,'General'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'HOME',NULL,NULL,'Home'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'OFFICE',NULL,NULL,'Office'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PAGER',NULL,NULL,'Pager'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PRIVATEFAX',NULL,NULL,'Private Fax'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'PRIVATEPHONE',NULL,NULL,'Private Phone'); -- d2k_api_util.create_domain_values(lws_last_domain_id, 1,'VOICEMAIL',NULL,NULL,'Voice Mail'); -- -- Numbers -- lws_last_domain_id := d2k_api_util.create_domain('NUMBER' ,'NUMBER',15,0,15 ,'NUMBER',15,0,15 ,'Y',NULL ,NULL,NULL,NULL,NULL,NULL,'An addable number.'); lws_last_domain_id := d2k_api_util.create_domain('NUMBER_ADDABLE' ,'NUMBER',15,0,15 ,'NUMBER',15,0,15 ,'Y','NUMBER',NULL,NULL,NULL,NULL,NULL,'An addable number.'); lws_last_domain_id := d2k_api_util.create_domain('PERCENTAGE' ,'NUMBER',6,3,4 ,'NUMBER',6,3,4 ,'Y','NUMBER',NULL,NULL,NULL,NULL,NULL,'A percentage'); lws_last_domain_id := d2k_api_util.create_domain('COUNT' ,'NUMBER',15,0,15 ,'NUMBER',15,0,15 ,'Y','NUMBER',NULL,NULL,NULL,NULL,NULL,'A number for counting'); lws_last_domain_id := d2k_api_util.create_domain('MONEY' ,'NUMBER',15,2,15 ,'NUMBER',15,2,15 ,'Y','NUMBER',NULL,NULL,NULL,NULL,NULL,'Some amount of money.'); lws_last_domain_id := d2k_api_util.create_domain('SEQ_IN_PARENT_HIDDEN' ,'NUMBER',NULL,NULL,NULL,'NUMBER',NULL,NULL,NULL ,'Y','NUMBER',NULL,NULL,NULL,NULL,NULL,'A hidden computer-generated general purpose sequence within a parent record.'); lws_last_domain_id := d2k_api_util.create_domain('UNIQUE_ID_HIDDEN' ,'NUMBER',NULL,NULL,NULL,'NUMBER',NULL,NULL,NULL ,'Y','NUMBER',NULL,NULL,NULL,NULL,NULL,'A hidden computer-generated unique id number.'); lws_last_domain_id := d2k_api_util.create_domain('SEQ_IN_PARENT_VISIBLE','NUMBER',NULL,NULL,NULL,'NUMBER',NULL,NULL,NULL ,'Y','NUMBER',NULL,NULL,NULL,NULL,NULL,'A computer-generated general purpose sequence within a parent record.'); lws_last_domain_id := d2k_api_util.create_domain('UNIQUE_ID_VISIBLE' ,'NUMBER',NULL,NULL,NULL,'NUMBER',NULL,NULL,NULL ,'Y','NUMBER',NULL,NULL,NULL,NULL,NULL,'A computer-generated unique id number.'); -- -- Yes/No and other flags -- lws_last_domain_id := d2k_api_util.create_domain('FLAG' ,'VARCHAR2',1,NULL,1 ,'VARCHAR2',1,NULL,1 ,'Y',NULL ,NULL,NULL,NULL,NULL,NULL,''); lws_last_domain_id := d2k_api_util.create_domain('ACTIVE_STATUS_IND' ,'VARCHAR2',1,NULL,1 ,'VARCHAR2',1,NULL,1 ,'Y','FLAG',NULL,NULL,NULL,NULL,NULL,'Is this record available for future use? Enter A or I.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'A',NULL,'A','Active. Can use for new data.'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'I',NULL,'I','Inactive. Do not use for new data.'); lws_last_domain_id := d2k_api_util.create_domain('YES_NO' ,'VARCHAR2',1,NULL,1 ,'VARCHAR2',1,NULL,1 ,'Y','FLAG',NULL,NULL,NULL,NULL,NULL,'Enter Y or N.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Y',NULL,'Y','Yes'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'N',NULL,'N','No'); lws_last_domain_id := d2k_api_util.create_domain('NO_YES' ,'VARCHAR2',1,NULL,1 ,'VARCHAR2',1,NULL,1 ,'Y','FLAG',NULL,NULL,NULL,NULL,NULL,'Enter Y or N.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'N',NULL,'N','No'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'Y',NULL,'Y','Yes'); lws_last_domain_id := d2k_api_util.create_domain('YES_NO_DEFAULT' ,'VARCHAR2',1,NULL,1 ,'VARCHAR2',1,NULL,1 ,'Y','FLAG','Y' ,NULL,NULL,NULL,NULL,'Enter Y or N. Default of Y.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'Y',NULL,'Y','Yes'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'N',NULL,'N','No'); lws_last_domain_id := d2k_api_util.create_domain('NO_YES_DEFAULT' ,'VARCHAR2',1,NULL,1 ,'VARCHAR2',1,NULL,1 ,'Y','FLAG','N' ,NULL,NULL,NULL,NULL,'Enter Y or N. Default of N.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'N',NULL,'N','No'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'Y',NULL,'Y','Yes'); -- -- Demographics -- lws_last_domain_id := d2k_api_util.create_domain('SSN_TAXID' ,'VARCHAR2',25,NULL,9 ,'VARCHAR2',25,NULL,9 ,'Y',NULL,NULL,NULL,NULL,NULL,NULL,'The Social Security number or Tax identifier.'); lws_last_domain_id := d2k_api_util.create_domain('GENDER' ,'VARCHAR2',1 ,NULL,1 ,'VARCHAR2',1 ,NULL,1 ,'Y',NULL,NULL,NULL,NULL,NULL,NULL,'Enter M or F.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'F',NULL,'F','Female'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'M',NULL,'M','Male'); lws_last_domain_id := d2k_api_util.create_domain('MARITAL_STATUS' ,'VARCHAR2',1 ,NULL,1 ,'VARCHAR2',1,NULL,1 ,'Y',NULL,NULL,NULL,NULL,NULL,NULL,'Current marital status.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'M',NULL,'M','Married'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'S',NULL,'S','Single'); d2k_api_util.create_domain_values(lws_last_domain_id, 3,'D',NULL,'D','Divorced'); lws_last_domain_id := d2k_api_util.create_domain('EDUCATION_LEVEL' ,'VARCHAR2',6,NULL,3 ,'VARCHAR2',6,NULL,3 ,'Y',NULL,NULL,NULL,NULL,NULL,NULL,'Highest level of education earned.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'HS',NULL,'HI','High School'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'SC',NULL,'SOM','Some College'); d2k_api_util.create_domain_values(lws_last_domain_id, 3,'CLG',NULL,'COL','College'); d2k_api_util.create_domain_values(lws_last_domain_id, 4,'MST',NULL,'MAS','Masters'); d2k_api_util.create_domain_values(lws_last_domain_id, 5,'DOC',NULL,'DOC','Doctorial'); lws_last_domain_id := d2k_api_util.create_domain('HOUSING' ,'VARCHAR2',1,NULL,1 ,'VARCHAR2',1,NULL,1 ,'Y',NULL,NULL,NULL,NULL,NULL,NULL,'Do you own or rent your dwelling.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'O',NULL,'O','Own'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'R',NULL,'R','Rent'); d2k_api_util.create_domain_values(lws_last_domain_id, 3,'N',NULL,'N','Neither'); lws_last_domain_id := d2k_api_util.create_domain('LANGUAGE' ,'VARCHAR2',3,NULL,3 ,'VARCHAR2',3,NULL,3 ,'Y',NULL,NULL,NULL,NULL,NULL,NULL,'The primary spoken language.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ENG',NULL,'EN','English'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'SPA',NULL,'SP','Spanish'); d2k_api_util.create_domain_values(lws_last_domain_id, 3,'FRE',NULL,'FR','French'); d2k_api_util.create_domain_values(lws_last_domain_id, 4,'CHI',NULL,'CH','Chinese'); d2k_api_util.create_domain_values(lws_last_domain_id, 5,'JAP',NULL,'JA','Japanese'); lws_last_domain_id := d2k_api_util.create_domain('OCCUPATION' ,'VARCHAR2',6,NULL,3 ,'VARCHAR2',6,NULL,3 ,'Y',NULL,NULL,NULL,NULL,NULL,NULL,'The occupation performed.'); d2k_api_util.create_domain_values(lws_last_domain_id, 1,'ACCT',NULL,NULL,'Accounting'); d2k_api_util.create_domain_values(lws_last_domain_id, 2,'ADV',NULL,NULL,'Advertising'); d2k_api_util.create_domain_values(lws_last_domain_id, 3,'AERO',NULL,NULL,'Aerospace'); d2k_api_util.create_domain_values(lws_last_domain_id, 4,'AGRI',NULL,NULL,'Agriculture'); d2k_api_util.create_domain_values(lws_last_domain_id, 5,'AUTO',NULL,NULL,'Automotive'); d2k_api_util.create_domain_values(lws_last_domain_id, 6,'BANK',NULL,NULL,'Banking'); d2k_api_util.create_domain_values(lws_last_domain_id, 7,'BIO',NULL,NULL,'Biotechnology'); d2k_api_util.create_domain_values(lws_last_domain_id, 8,'CHEM',NULL,NULL,'Chemicals'); d2k_api_util.create_domain_values(lws_last_domain_id, 9,'COMM',NULL,NULL,'Communications'); d2k_api_util.create_domain_values(lws_last_domain_id,10,'CONS',NULL,NULL,'Construction'); d2k_api_util.create_domain_values(lws_last_domain_id,11,'CPG',NULL,NULL,'Consumer Products'); d2k_api_util.create_domain_values(lws_last_domain_id,12,'EDU',NULL,NULL,'Education'); d2k_api_util.create_domain_values(lws_last_domain_id,13,'ENE',NULL,NULL,'Energy/Utility'); d2k_api_util.create_domain_values(lws_last_domain_id,14,'ENT',NULL,NULL,'Entertainment'); d2k_api_util.create_domain_values(lws_last_domain_id,15,'FIN',NULL,NULL,'Financial Services'); d2k_api_util.create_domain_values(lws_last_domain_id,16,'FOOD',NULL,NULL,'Food Services'); d2k_api_util.create_domain_values(lws_last_domain_id,17,'GOVFED',NULL,NULL,'Government-Federal'); d2k_api_util.create_domain_values(lws_last_domain_id,18,'GOVSTA',NULL,NULL,'Government-State'); d2k_api_util.create_domain_values(lws_last_domain_id,19,'GOVLOC',NULL,NULL,'Government-Local'); d2k_api_util.create_domain_values(lws_last_domain_id,20,'HLTH',NULL,NULL,'Healthcare'); d2k_api_util.create_domain_values(lws_last_domain_id,21,'INS',NULL,NULL,'Insurance'); d2k_api_util.create_domain_values(lws_last_domain_id,22,'LEASE',NULL,NULL,'Leasing'); d2k_api_util.create_domain_values(lws_last_domain_id,23,'LEGAL',NULL,NULL,'Legal'); d2k_api_util.create_domain_values(lws_last_domain_id,24,'MIL',NULL,NULL,'Military'); d2k_api_util.create_domain_values(lws_last_domain_id,25,'MFG',NULL,NULL,'Manufacturing'); d2k_api_util.create_domain_values(lws_last_domain_id,26,'NONP',NULL,NULL,'Non Profit'); d2k_api_util.create_domain_values(lws_last_domain_id,27,'NOTP',NULL,NULL,'Not for Profit'); d2k_api_util.create_domain_values(lws_last_domain_id,28,'OT',NULL,NULL,'Other'); d2k_api_util.create_domain_values(lws_last_domain_id,29,'PROF',NULL,NULL,'Professional Services'); d2k_api_util.create_domain_values(lws_last_domain_id,30,'REAL',NULL,NULL,'Real Estate'); d2k_api_util.create_domain_values(lws_last_domain_id,31,'RET',NULL,NULL,'Retail'); d2k_api_util.create_domain_values(lws_last_domain_id,32,'SOFT',NULL,NULL,'Software'); d2k_api_util.create_domain_values(lws_last_domain_id,33,'TELE',NULL,NULL,'Telecommunications'); d2k_api_util.create_domain_values(lws_last_domain_id,34,'TRV',NULL,NULL,'Travel'); d2k_api_util.create_domain_values(lws_last_domain_id,35,'UNK',NULL,NULL,'Unknown'); DBMS_OUTPUT.PUT_LINE('Domain program finished.'); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Error : ' || SQLCODE || ', ' || SQLERRM); DBMS_OUTPUT.PUT_LINE('Procedure aborted with errors!'); END; / ROLLBACK; SPOOL OFF