demo_project_basic_data

create or replace package demo_projects_data_pkg as
  function varchar2_to_blob(p_varchar2_tab in dbms_sql.varchar2_table) return blob;
  procedure load_sample_data;
  procedure remove_sample_data;
end demo_projects_data_pkg;
/

create or replace package body demo_projects_data_pkg as
  function varchar2_to_blob(p_varchar2_tab in dbms_sql.varchar2_table)
    return blob
  is
    l_blob blob;
    l_raw  raw(500);
    l_size number;
  begin
    dbms_lob.createtemporary(l_blob, true, dbms_lob.session);
    for i in 1 .. p_varchar2_tab.count loop
      l_size := length(p_varchar2_tab(i)) / 2;
      dbms_lob.writeappend(l_blob, l_size, hextoraw(p_varchar2_tab(i)));
    end loop;
    return l_blob;
  exception
    when others then
      dbms_lob.close(l_blob);
  end varchar2_to_blob;

  procedure load_sample_data is
    i               dbms_sql.varchar2_table;
    j               dbms_sql.varchar2_table default wwv_flow_api.empty_varchar2_table;
    l_blob          blob;
    l_full_name         varchar2(255);
    l_email             varchar2(255);
    l_add_days          number;
    l_project_id        number;
    l_milestone_id      number;
  begin
    -- Remove any data currenlty in the tables
    remove_sample_data;

    ----------------------------------------
    --<< Load 12 Team Members >>--
    ----------------------------------------
    -- Load Team Member 1
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400910000020203010000000000000000000000050604070002';
    i(3) := '030110000201030301060207050606030000000102030004110512213106132241516132711423428191A1B1526272C1D1072433347382152543A2B2C2E1F0F1010003010100000000000000000000000000020301041100020202020105010101000000';
    i(4) := '00000000010211032112314122325171816191F0FFDA000C03010002110311003F006FBACF72067ED0FD6884E733DB2FBE687CFCA28FDE5FD6884E3FBDDB52C41852B2B2B2980F0F4AD7CEB6270326A0DD6AB616BFE2CCAA7F13F9516976156499658E25';
    i(5) := 'DD21C01514EAB620E1A4DB9E9B86284DD76AB4591FB959FC58F8B0702874D3690589594333F2CE1F91ED9E4D4A596BDB43AC7F3635A6A166FF000CCA7EFA92AE8CB95606ABA78ACAE67D96B74F1BAF223DC08247BF5CD7786FF58B56CC53472C5F088F77';
    i(6) := '208F239039A166F946BC7F0C7FAF474A5BD27B511CE7BAB81DDC8BF129F2A638DD5D0321CA9E84552324FA11A6BB36ACACACAD30CACACACA005B907F879FDB5FD688CF8FA65B54097AC63F7D7F5A997248BD83D81FE54B10616AE734D1C11B4921DAAA32';
    i(7) := '49F6AE941F59265C42794F89C7FE23F9D12952B362ADD01756ED0DEDD2B1B41DD5B29C77ADC64FEEAF9D2E892EEE998431B48E78321624E7F4A31A9D9C9712C56A9F6CF8BD154797DF46ACF4F82DA358E250A00F2AE75CA6DFF0E8F4C50A10765B509641';
    i(8) := '25CCA235EB85E4D4BB8ECDDB18CEC62B2918DE3C3FA533CD1ED526874CDC62B5C54413B135FB392E9ACB3C13B3346DBFDBA8C8346EF2313471DD47F0CA4C72E3A1CFC0F522EA30C841E9E62A1D8DC88CBDABF207880F6C83C7E148E566B5AB07A5CCCCDB';
    i(9) := 'C12B3438271E6B9DBF88229BFB35ADE5962639864FFB5BFA1A4BB9945ADFF0729DF3A37F038DC2BBD94E6CEE8A67A31C63D3E218FCEA90D6C9C95A2D9ACA87A4DF25ED947329C92304FCAA657422265656565002E4A3EB21FF005054DBAFF3D07F09FD45';
    i(10) := '4371F5D07FA82A55C73A945E9B7F98A58F9061627099F4141EEDB2FBDBED1CA8F5F4A217F70B05B333798C003A9A4DD4F5FEE27EECF8EEE4E8BF66143C7DEC6A59E6968A638B6C991BFF007E2D270C4ED1F75195F87355ECDDA286D6F966B9768EDA3601';
    i(11) := 'E5DA48E790A31D59BAE2982D7B6F0DE026C34ABF9E00A585D18B64470338079EB4B83516DFD8F916D241B9C9208A197585E475E8680DEF6D2F0F8C5ACF6C790639ADCB818F5689C9FCABCD33B516FA9298AE5E282E01E54B6DCFC83E0D6CF66C1576139B';
    i(12) := 'F222815EAC914DDF467053240F5A91A8F68AC2CE12A2449A7190AAAC1B3E9F0E680C9AAEA372D9757C9F8426C8D47DEFC9A48C1B1DC975D9BDE4AB39665E37F3F2603915244EB2C36977E6711CA3D1A33FCD4D0B95350037C9001BB92CACA73F3DA715AD';
    i(13) := 'BDC3AC52A14655DC1B9E81C71FA1AAA8E8937B2CAEC45E08EC51256C2BCB22A93D063FF9A70AACB4A30CD0D969D333471C8195E443820B9F8BF1A73D1AEEF2D663A36A8774F18CDADC794D18FF00D97CC53C1DA2725B0D5662B2B6A7145D1CCF003FB752';
    i(14) := '5D0B6A8BE8AA0FE06A3AFF0099807EFF00F2A9BD2FD8FAA0029174047D6E561033AF2CA31183D371E99F9557D7714768D2CF2B190264966FB6FF00FEF14FD7BF587C7CE4ED8D7DFAB1FBAAB4ED95F2FD34DA43F0838E3DAB9732729A3A71695036F6F355';
    i(15) := 'D4ED88902BD9D808DEE02A81E1DC11DBF3AB0B5DB7D52E2DA2B6D3F12A1F178DCA47B40F0EEDB8E3D1475A05FD9F5BDB4FF4B866512472C463950F465738607E74C8BA6EB3A75925A5B490DF410F8227B8678A5110F8118A2B872BD33564DB8AF3463D4B';
    i(16) := 'E040BED1B51B6BD91CC92342B82AEC553C5E7811E401F7D4C7D2A7D622D36C660A2EEEA662B72572E96D12E666278C8E98F7A37716FAAAC9DFC96560AC0E774F3CB228F7DBB1688F67AD65C5C6AD7727D2AF268FBA8E554EEE14854FF8702F3C13D49EB4';
    i(17) := '72B96EB5E1035E9D27F6C43B8D121D2359FA3C32192295185BCCE0643AF241C79915C8E9B34F20DCC339CB724668DEB76E93CB2432EE0090F1B27C48C3A32D40861D448CC73C3718E09742ADF7ED6AC591F77B19E3AB55A34B4B59EDEE4C6C43C0C385CE';
    i(18) := 'EC66A0EA2E23BE728488B7AAB7A7840CD185B4D45BE39E3833C6628FC43E45D8D44D76DE282CE2441C29C027963907249F535B19ABAF91658DF1FAF90BE9B2ACAABE65795C1FFEF9539DC6A226ECE1BE73BAEB4C74757F33B580DDFEE5383553693A94D0';
    i(19) := '8084E53A0F9535DB6A4F259C903B1FA35C2ED940F300E6B53E2FF8235C9169C722CB1A4A9CABA8653EC466B7A0FA06AB6571690DA472E6786355D8DC160A31B97D68C0E9554EC900100FA541EBB8FE9521589D55D7CB62FE66A3C640BB87239E6A423635';
    i(20) := '351E720E7E4B58BA038DFC6D0CB24EE7C31AED887BB753553F6A2DE48751591BFEA20901F724FF004AB8F50885C3ED3F02F5F9D577DBDB5426178BAC276903D2B9F2AA959D189F839F601BB8D54447ACD103F96EA7DBEB8586124F95577D9D9A38F5BD3E';
    i(21) := '4466044CB04CAE410778755298030079E69CFB41BCDB32AFC47815B09541B1A494B2242DDC4971ABEA02D2163B5CF8C8E8147534CC96E2D2DE306594456F1F76B06EFAB23F871D69574DD52EF47B43751591B832C8B0C97073B611BB6EF7032D814D8DA7';
    i(22) := '497684BEA5DF0F8BEAC28038C8C01EF598E2F8F2F2C7C925CA9BE3188A3AADA5D2CFF4812111C9F0E08FCF8A896E121983B7C2DC3E3F5A25A8E932C2826B9D500561C06C0018B050AA33D3D681BDD486F64B481D6EE051E2B8036853E43DCD2B8491BCE2';
    i(23) := 'DE9DFE06E555E08E41F3A5FED438325BC23F64B7E2714761E2DA346396EB9A5BED0B96D5923032563518FE2C9A31FBBE8CC9ED2188D638F39C1E981D68FF00672132C0CED823700AA7A1E7041A1305A963E22377993E5F21FD68F690563D3AE1A0E62B49';
    i(24) := '237932793B9B1B80AA49D91AA2D586081E18711AFD585287038C0F2352682767AEA66D3A0999BBDB79070DF6A36CE36B7A8A360E791578BB488BEC5E67DB7701F2C9FD2BAC2E92EA8B22107BB521867A1F7FC6A2CCDBA68F1C119A19D9B9125D4EFE262C';
    i(25) := '25322B3E790553278F4F2A4BAFF412B19AEA411C581CB1FCD8D26EB3A73EA375796C8771B78577B0E9DFE7784F985EB4CF7906A176EDDC38B78C021A6FB4079ECCF19F7A1B717761A6DAFF00C3B4F8C492E7748E1B7EDE72599B1C9351CB4F6F497FDA2B';
    i(26) := '8ED75B65722496D2666418962749D33D7744D9C5592F716DAC69D05FDAB6F86E143A91E47CD4FBA9E291B5BB5376B7D7762A18DB49B8A0EA6371E2C7CAB4FECEF52B9B4BB92C1E4DF6972864101F275C78D7D38EBEB4B8DA71765657C935DA2C2B3B74B7';
    i(27) := '8DF0A36BB1623CBC5F1544D688920DB1858DFC9C2F38F4C8A270BC722ED06A36A11471C04F05874CFBD55EA3A160DF34C43BCB066C23C81D57D074FC6BC82254C24630A2885FE0658705BA0F2A8F0ED5C3374A83968E8936FB3B2948D0C9236C8E3059D8';
    i(28) := 'F400724D2B457AB7BA9CD7A57702FE043FB0A30B527B557929B348632562771DE0FDA03A668269ECEB3E14707A9F4F7AA638545CBE48649FA92F80F18DE0B2EFE53F5939C81D7271924D4EB4120D3574BB284DD6A774E2695A2C9289C011C9E58E3773D2';
    i(29) := 'A04104FA8DE436D180656C471A74C9E9F77BD5BDD9ED06C746B158ADD019180334F8F148DD4B31F4F414F08F2B2737547BD9DD3E4B1D3638E6509232AF78839F10182689C6C4E47A57BB8795646857AD5D2A54445F440D77129E9835EC56F6F06A8F142B';
    i(30) := 'B5E48F7B91D4FD91CFB5640DFF00308D7F758D6C2453AF7778F1F72307DB278A4AD7E81EDD2B48042E19998E238C1DA09C72588A5CD6AD16DC3648C1C6C48C7058F931F3F90A6AD46DBBC68883B496DB9F2048F0E7E7D2835DC1DE6A4CD73F56B6710EEE';
    i(31) := '3F20CE32CF9F5E0D736685DDAFA674639555083752DFA4EB6D688CD3292C234E7DF3211FA56BD9DD36E20D44CC5B0F1C6F20C0E324A8603DB9A3DA86A96369673D95828FA65EF865B90C01519CED1E7E78AD6C6E6C922568DF64962CF0CD1B1C6F8DB891';
    i(32) := 'D33C1C100D24552A4FB5B28DF96BC8CF692EE88379E39AEB3C71CEA3BC2769EA01C543B4601060E411C1AEA65C06427E54EBA15AD80B54B511DC98F39897941EC7D687B00060516BF7DEF83E983428FC5ED495B1D742FF00685775ABA9F890061F71E6A1';
    i(33) := '59DC5BD9C07003CEE38CF414535C4568646F351416D62EF6DD66C720ED3CD5E3EDFD272F77E1D2D6F27B7BA5BD62E5E36DC8554EDDC3F7AAC8ECF7F691A73A777A96F8E63C071E28FF00AAFDF49568E161FAA7C2B865600FAF1E21F09EB5E41A56993EA9';
    i(34) := '15B999AD6178B749220DFB58784719E86B796F5A62B8EB65CFA66A7677A3BC826490313B4210D81EF8A2555459767AEF4F944DA4DD25DB7D994CC919539C8DA8769CFCE9A74CD53B4915AA9D42581653C88A504C8067ED14C0AAC65AD9292DE827F46861';
    i(35) := 'B9170646CAA91B481D0F9F1CD7345B51A89D43BFDCC1360880E7EFCD6D339453B46E63D49E9F3A0F7DB95F7E4961CE7181492971F0118D86AF2FA3991E265CAB0C7A1FC695355875795B369334DB07C52E37003C8951E21CF9D11594ECC6327A549B650A';
    i(36) := '4F19622A72F5F6517A4AAEFA6B81791FD223EE258415254677E3A1CAF5C51BECD3477F772D9104A11DEF7AC4008EA396F173CF4C51AED25882AD7F1461EE6D14B0523875239C81D71D6B9761F4F8ADFBBBC94E249419A50CDB57B9070AE7FDD9348A0AEB';
    i(37) := 'F0A73F4D9AC37D2E97792DBDC9FEECAE17791B7631E303CC8A2D74C4C5DEA107CF2284B44D7924A65C4A2476F01390493C13BB8DA7D6B2C2592D4BD9CA77DA63EAC83B8C67A6D63E9E959FC37FA64970254DDE64F4A86E4804D78331C8CA7A66A547686E';
    i(38) := '15D40EA3F0A121AC55D6AE1DCF711825D88C28E4927A0A26DA5C76905ADB9CC52F7599A3C8DDBFD73D3CEB9DBE9B7169AAC979770F7B6E9BA3195C96661D533D197C8D6D773CA19AE40381952A7C6CA40E0E1BDF9A76F4921177646D274582FAEEF56399';
    i(39) := 'C244C9B5E3C01B8825873C7951AB6ECF456B233333C8ED8DCEE724D4FECA690D61A6A19D765C5D1334CA7A8CF08A7EEE68AC96FBF71C7853807D49E4D6B4C9F20741638518208F3C54BB385C4322B312D1BE0679E08045696CC637313039CE578E38A271';
    i(40) := '460994018CE1C1FCAB10367FFFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  1
       , 'Lucille Beatie'
       , 'lbeatie'
       , 'lucy.beattie@email.com'
       , 'I have extensive experience running development teams. If I can''t bring in a project on time and on budget it can''t be done.'
       , 'team_member_01.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 2
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400860000010501010000000000000000000000000203040506';
    i(3) := '010710000202010203070204020B00000000000102000304051112213106132241516171328114334291235207152425346272A1A2C1D1010101010101000000000000000000000000030102041100020202020202030000000000000000000102110321';
    i(4) := '314112221332516171FFDA000C03010002110311003F00F53842100210840084225DD514B390AA3A93C84015094B99DABD2F18950DDE11E9D2571EDE62F7840A58AFFBC0357095DA56B589A953DE56E15C7D4848DC49EAE8E37460C3D41DE00A84210021';
    i(5) := '084010E3CE26387988D99A8C63B084261A1084200D6464558F535B69D95661B5BED15F9CED5A1E0A10F251E7F32EB5ECB6B99AB53E0AF703E7D662B3AC5AF895799132CE9221E4E49DC92772647191B73318BAC3CC9EA647EF8F41F733A4C5162B96E0F8';
    i(6) := '588F70658E9FAF67E11FECF7B2A9EAA798DFE0CCF0B765D84EA5C78A6E99947AEF66BB469AAD5DD5C42E520E63F987A897B3C634DD4EDC1CCAF2696E16AC83F3ED3D7B4ECDAF3F0AACBACF86D507E0F989C98498421002218738B9C61B8840EC2108011B';
    i(7) := 'BDFBBA5DFD01DA3923E7FF0084B3E218329AADBC1491FA9BA998FCF7E27207DE6A75975141DFA9994B96CB9FBBA94BBB9D801276552D15760363EC4ECA23D85A4E4E6D9B54A56BF373355A5F63D5145FA81E36EA2BF212C32BBAC4A48A9428036004C949';
    i(8) := 'A46A8A6CC5E6E96B4DAB8F5F361F518FD3A52AEDC5CCCB5C5C27B2D7C8BBAB7ACEDED4A36C580F69C7C8FA29E08CFE5D0687DC749B6FE8E7590EB6E996B731FC4A41FF0090998D46B5BE9210EE473913B2D996636BD89B1D8F7CAA7E18F0FF00DCAC2568';
    i(9) := '9648D1ED909C1CC6F3B3B241084200421080119CC1BE3583FCA4FED1E88B578EB75FE6523F7100C066AD99B96B8E9D0CB7C0D1317013BD2BC56FA990B47A5BFAEDD187E5A93BFB932EF5237776569E4C7A13E527FB2ABA4536A9AE3636EBC1F1B9DA46C1';
    i(10) := 'B9B5252C40E5E52975AD0B32DB7BC6C87B1C9DC8E825D76534EC8C55FE26E77936ADF255525C15FAD64DD89BD43C24F4946751A6AFAD5AEB0F9CD376D30CEF5DCA3D8CA3C5C34B17C4262A8DA674ADA4D08C4C94BDF9295DFCA41BD0E06B34DBFA43AB8F';
    i(11) := 'B1DE5E9A29A57C239C8BA8E2AE4DB86075B2D5AF7FF53013612F6D1CE48FAECF5CA583D4AC3A100C5C45282BA9507450045CF41E5084210021393B0021084033828FC26B2E48E570DD4FDFA49F72868AD571B88A642FD551DFEDE710CDBD6187989C3D59';
    i(12) := '45BA29B541554A58F946FB3FA9D5926C1BEC2B3B4ABED5E6F74BC1BEDC5CA2BB3471BF0FC38FFC4B4F373EF229DCB5D1E869786FB2676A6EACD1CCEE3CA646ACA7AAC057E8F3134FADE06A5929C2B58DBCB9CCBE6E165E0D4CF732EE3A28E712849BBA11';
    i(13) := '94524AD164D62DB5861CC1EB2769183F8ECFC342A592AB458C4797078B9CA3D29ADB71D9ECE5E826F3B0D50FC15D711CDACE107D80998D5CEBF032CBD0D34EC213D478C21084038BF48F89D8DD0C5AA527AED1C8010842008B543A153D08957B70F1527F';
    i(14) := '4FD3F12D8C839D5F8EB75F5D8FC19CC968D8BA6657B43A52E5A6FC3BB298BD33495C4A96DC626B623C4BEB2F322904F3895AD457B2C9462E326CBF9DA48A2D5B597C75E02AC5FD872993CC7BB3ADDDD484EBCE6CB53C7A482F66DCA67728D406C9399CDD';
    i(15) := 'D15828D6A233854D9615C5A1789EC3C2A07BCF4ED234F4D3B02AC55EA83C47D58F32666BB118151B6CCB61C4EA005F6DE6CA778615727CB219A76FC570821084B1108421006F1C6D528F68E46E9FCA5F88E400842100237622B2EC62CB28EA63166429F0';
    i(16) := 'AFDCCC6E82443C81B6F2B6EB9D092A659647494D98C474909B2D04566A99165C853623D650D84F105F497397616DC894CE0F192645B765E3C1BAEC2A7F75D961EAF691BFB00269267BB12E8746EEC7D4963061F3CE6867B31FD11E49FD9FF421084E8E42';
    i(17) := '10840114FE52FC45C651C2560798118BF2980E5CA0CB489365F5D6399E7E920DFA89DF85394AEBF2AC2FB6F22D99055C6F31BA33C8B56B98F3279C6D72406D899132B23BAEEEDFD27937DE359AC500B10F26993568465522C5F2148DB79539CE39C8AF9E';
    i(18) := 'C8766FDE47C8CA2E37DE79672E99EC8AED11B25F6DF9CAF27731EC8724ED23EC64ACA22C348D732B49C82D4ECD559B7795B743B79CDA69DDABD3331471377367EA56FF00D9E705BD62AA735D81C1E5E72D0CAE3AE89E4C69A6FB3D6ABCAC7B7F2EC56F82';
    i(19) := '0C7679B2E4B8D9EA728DD410659E0F6BB36922AC85168F263C8CF429DF28F2BA36D094F83DA5C1C9615B9EE6C3D0374FDE5B8208DC7306749A60FFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  2
       , 'Nina Herschel'
       , 'nina'
       , 'nina.herschel@email.com'
       , 'I''m a consumate team player who likes to explore and learn new things. My belief is to work hard and play hard.'
       , 'team_member_02.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 3
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400800000000701010000000000000000000000000102040506';
    i(3) := '07030810000201030303020405040301000000000102030004110512213141510613223261710742528191233362D11424437201010101010100000000000000000000000001030204110101000203010002030000000000000000010211122131031341';
    i(4) := '516171FFDA000C03010002110311003F00D4EB9A0F8C9A5D223E7340BA3A22401927007526AA9EA7F570B3905A5930DFD649872063B0A096D42F2D6C0B35CC811739FAF355F9FD7FA3437460DB23A8EB22D52F50D526BD94CB752B11264EE6F03F48A84B';
    i(5) := 'FBE5056381703BB1E49A6CE2D4ADBD7DE9C99996595ADCAF4DE3A8FA62A42C7D51A05E5C2436B7A8F31236A74CFD0562A043B46E24B1E8696269ED991EDC9478DB287B8239CD0D47A27B668EB26F4F7E27EA705CAC5AC7F5E06C066C00CA3CF15AAC13C3';
    i(6) := '730A4F0309229006471D08341D2850A2A004714C586D765FDC53EA6D74B860FF00B1A2571A14285543F63853488BA1A5B720D217E1563D3009A8E95DF5C6B3269BA7EC8C8065F9893CED1D7159AEA37C96B6EB23BEF9A41B8478E02B77CF7A94D7EEEE35';
    i(7) := '5B995666F7D83B88F3F2800E2A2F50789ED446F1A992DB037F9FA5162224B837AA5B9254640E98C78A688649898369DEB9C0F14FD6E16381582A19A56DB101D79F34D6659ECE570F8324A325878A04489B51428F8D3F3F4A4492C808393F7AE6EEDD739C';
    i(8) := 'D0C971CF4C511D3DD919839E48E9574F41FAA2FB4FBC86D5A4696C67608616E761638CAD5188280739CD4FFA532B7F0B9E551D64607C29C93456F3458A28E449635910864700A91E2954415739977464574A06823C74A3A39176C8C3CF228AAB93F3D299';
    i(9) := 'EAAD2269972D17CFB0E3F8A78471489231242F19E8EA47F351D30D93518E07DB3E5527CAEE5E8A7775A17966CB038197007B9128E77678E6B8EBD6B2DAEB32E9E1065A429116EDB8F5A98D4A0FF80B05B40E56E6D9177BF50477A95D441DB2C368897130';
    i(10) := '2D2F263503804FFAA8C9A669A76776CB377FA5596DC59EA8BEC30DB3A9CBF6561E7E9507AB5835B4ACB18000EBF4FB536691F2300DC1E9DE90B2763C81D052D6DEE253B5549F269D45A54B8E6A5CA426169B6779CE318E829FDADE35BAA94CE7B9A35B05';
    i(11) := '5C64F34F2D92053EDC83286B9E72BAFC7576FC3EF573994697764986438818FE53E3EC6B463F7AC4A1D16E6397DFB26CB20DE157AF1CF15ADFA73524D47498270DB9F680FE722BB95CE53492A142855726D74BD1FC75AE34F255DC8453219E87A8E2AA54';
    i(12) := '813C501D2851D45406BDE94D2F519975178F6DDDBFC6AEBDF1FAAB37F50BC8F7922019700927ED5B24AA5A3651D4822B1EF5642D6FA8B3B92179057B9352AC47E952AA209A35CCE1B6B96191B7ED5343408AF2412CA0ED703ED93503A4CC56EB6939463C';
    i(13) := '1C76FB55F2D555610E3A1E9F4AE2DEDA49D6D1D73A35AA5BEC8902941D875AAE5C43ED315AB5DF4E402BE4557EEE3DE0B9E3CD659FAD70F110E2B964673DC53B740491E6B84B16D52DE3AD48B625B42D5258B50B765E70E030F20F06B43F495B359DCEA5';
    i(14) := '681710A4DBE13E5641BC7F19AC712E66F701886C03F31E2B61F47DCDC5DDB5BDD3BE434223957CB270ADFC56F879DB0FA7F3165A147455DB3034CA65DB29F079A7B4DEE97E10DFA6894E6850A1450AA27E20E92CE9EF2A06493F301C86ABDD42FAB6F6CA';
    i(15) := 'C746926BB19C9090A8E4991BE51532F167AC874883DBBF114AA7613C1EE2B44B7B5FFACA833507158DADE48B340163BB550D2C24F46EFC559ED9B102923903A7D4567356EDADDC9A57FD4375069901223F7A623804E00FBD51AEB5CBD9D8825114F61563';
    i(16) := 'F55C17BA8DDC71DB212BFF00A963B40FDEAB3716B6B67AA7F595A7B455F93E5CB63A71DB35352EFC5EE6BD76B6999C609CB7D28EE66F6A324F5F14AD0EC9A5BC3204F6E1CFC284F41E39A77ADD8AC52038FE9B571AD577BB620EC9E37BC0F7A8D3443931';
    i(17) := 'A1C03E067B5687F87FA8A41AB0B086567B79D37FB6DCEC7EEAA7C0AA108151B0BC8F3560F463987D4766DD0336DFE6B5C72ED9E58756B67A2A33D68AB4621489177291E69744681542850A014D752D3ADB52B47B4BA50D1BE083DD594E5587D41A754283';
    i(18) := '229F40D43D2BAA3EA939F7AD04FB481F390FF2B1F2B57149D2481658FA380C07DEAC5A869965A95B9B7BC8C491B71E08FDC5433E849A6C02281DA4841250BF2CBFE359F0E3BD78D6FD396B97B103A8E9ED748CABC127AD54EFEC23B472B2619AAEB3CE2D';
    i(19) := '849EE1C291C1AA16BD2C8B3966CB03C83E735967AEB5FB6B87F6E9A65CE75182D63193336DCF603CD4EFA91AC0DB08448AD245C6011D6AB1A46992DD96B924A043F36718FDEB96A105A997113B492772A4D35D68B7BDBBB47A78B60BBD9EF9C1D91A1E17';
    i(20) := '9E19FF00D576F4EDD7B3ADD9893B4A003F5AE7A1698DEF9BD75DB05B29959E41F092BCEDFDE9FE9367A8EAFEA4B2BA9AD96DE3B99D6450830A1179AD718CF2BEB68A2A33D68568C45447AD1D11A0550A1428050A1428052268C4B1321EE38FBD2E889C73';
    i(21) := '414CD5605963917B8CA9FA11548D56D032189BE65F91BED56EF58CB35ADC1BDB26DBBF8914FCAD8F354BB9D7A098E2EA3689BF52FC4BFEEBCD9CBCBA7A7E77AEDC2CE19A4062F75A1F88332A9E0E2ACADAC69F6691B476303CABC962307A63EB50D01B6B';
    i(22) := '98F75BCAAD20F079FE29B5D4258E1CE08EB4E576EB8CFF005DB53D66E7515F6246482D776EF663E073E7CD5EBD0D7515DA19517115A2ADBC4C473C0F88D66D6BA74F7974B6B688659A438555AD5FD39A30D134C4B52C1A627DC99874DC7B0FB56DF397D6';
    i(23) := '3F5B3CF1661475CE16DC80D74AED90A88D2A92681542850A01428511200C9E0501D31D4AFA2B689896C1C7F14AB9BF8A25C9F8476DDC66AB1EA747D56CDE3B393DBBB519453C07FF00135CE5948EB1C76AE6A9AB8BB59A16ECC4AD542ED14B934725CDD4';
    i(24) := '770D0DCAB453C676BA3706B8CEECCDB874AC32BDBD12493A72542877292A7C8E2BB8B8B83C3485BFFAE6B906CF22BA704034178FC3670F7B700A8DE911F880E79357DACBBF0FF515B3D6E4DFFDB963D8DFB9E2B4C86EADE7FED481B24803EA0E08FDAB7F';
    i(25) := '9D9C63CFF497953EB37EAB4EEA3A162928CF1D8D4803915DD7107493D695496E9515FFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  3
       , 'Tameka Hall'
       , 'thall'
       , 'tamika.hall@email.com'
       , 'I am all business and thrive on developing the lowest-level code. Point me at some obtuse security bug or framework API, step back, send in pizza and coke (not diet coke - YUK) occassionally, and consider it done!'
       , 'team_member_03.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 4
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400850000010501010100000000000000000000030002040506';
    i(3) := '070108100001030303020306030803000000000001000203040511122131065113224132426171819107145215232462A1B1C1D1336372010100030101000000000000000000000000010203040511000202020203010100000000000000000001021103';
    i(4) := '1221312241815132FFDA000C03010002110311003F00EAA92492012492F09402CAF0B804C7397982501E9795E64AF4353259E9A000CD23580EC351C201DBA582A033A8EC6F95F136AD9AE3D9C3FD1525B73B738E054333F138FEE80360A5829E0B5C039A';
    i(5) := '41078237096100CC14B7444880500C0E21101CA111829EC2807A492480F131E53CA11DCA010195EBDEC8985EF21AD6F24AF460024EC06E563FA9AF2E7B1CD69D30B7D91C65002EA9EB714D13A2A07E24E0382E735B79B9D73F5D4D43E4EC0938194EB94D';
    i(6) := '24CF2F79F2F23E2AB8B8F2A0B2448656D4B0F95E40F5C14496EF58F1BC8E3918392A1907403DD09E704A921A34565EB2BC5B266F833973323544F3A9847C8AEAFD39D49497DA62F8C785511FFCD093B8F88EE17040E3957DD337D9ED95F0D4C6EC169D2F';
    i(7) := '1E8E69F42828EEABD41A5A88EAA9E2A888E6395A1ED3F028E8403785E30EE9EF1B218E50064924900D77087EA88FE10C72808779A914F40F717690E3A49EC3D5737BACF2564E0907C21ECB7D36EEB49D715F3995B46CCB628DBA9C7B93FE964A7B8434F4';
    i(8) := 'DAA5F34B28D318EC3D4A864A28EE1AA491C7DC69C347C540735DDB3DBE39539F5B1D449B8C431E4347AB9C794F688232C9A5E479B1E981C0516588F353399A5876D0D1907B950A66799D8EFF00D94DA8ADF1DC5C0E5CF392A23CEA7642060C34E5A08F92';
    i(9) := 'F5AE31B8E3D139E77F9213864E5490761FC35BEFE76DDF9091D99201AA3FFCFA8FA15B55C3FF000FEE6EA2BF41E6C31CFD0E1FCAFF002FF75DBC222188F0847628C84EE54901524924035FC218E511FC21671BA0325D68EA6126243FBD78F234760173AF';
    i(10) := 'D9178BF55B9B41113145E474CED98DFAFAADEDFA829EBEB594E6A735C0BDC07386BB96FC15874FDBBF675B1B4A4EA76A717B87A9CAA6FB75E8D3471EFD99FB7F4558ED74C26AF71A899A3CDBE1A0FC02CEDE85A5F348E0E3146366340E07C96F2BA91CE7';
    i(11) := '9701ADBEAD3C2CEDE20A67534B4F0C7F9674C312F8607987C562E54F9746AA3C70ACC9535BE8AB1E23A79F4BCED976DFD15A49D235AC6BA5058210C1A1F9E5C874F68AB925821A7601E11F2BC0C388CFBD85B2BAC52C1622C71F3340557925DA7C513A2E';
    i(12) := '135C9CDE4B25C2319F2B8938C03E9DD0A4B4D5B29DD2BBDA6F2C1F0532BA7AD2E0C88FAEE02133F3EC3198CBE471CF8AD2361BABC6736BB455C229D5301612F3768030E1C5EDFE857D1519263693C9033F65C5BA43A7EA2B3AAE99CE662169FCC48EC6C1';
    i(13) := 'ADF4FA95DA870B78BB56612EEBF0F509FCA2A1BF9524044978BCD41009FC218DD39E535BCA032F5D6D868EE6FBA35C754AED2F63B8031B90AD22D3E0873770E1907E6BCACA3A6AE8E68A6739A6373B042752C0D868638C38BC31B80E3C90B2507194B8F1';
    i(14) := '7CFD3573DA31B7E4B8F80666B44449592BB42D73C9CE02D057CEFC686959AB91924A88A9633AA598E034738F52B973BB6923A712A5C93FA6290BB5C8D1900E3254EEA68BF812C69C83CA14342CA5A7313F3A5C30FC1C67ECAA6F15D11A034947964719C6';
    i(15) := 'A07247DD4F50D5F64773D974514D4A239304641DC14310B358F4CFF9468E525AC64AFD7A76D4792891B04B531451EE5EE007DD52DDA4694A9B6751B052434F6E81CC680F746D05D8DC80AD546A367854D0C5FA5A0292BD15D23CE7D890DE8886F4039E76';
    i(16) := '431CA73CA68407AE29ABDE522A4143D4129A3A4AB9DB905CC2463B9D91E8242FB3D33C9C9742C27ECA1F5DBBC2B04D28E7668F993B2974113A0B5D140FF6994F1B5FF3D216722D12B2A482E39F45949FA7E5BBD74B378EFA73192D85EC241056C2AA3C3C';
    i(17) := 'E420C74A1A5E583DAF37D57253DACEAB545655C6FA08182AD8E91819A4CD13B2491EF16B9662E1514A75BA1A87E90760E8C8710B5D756BA5874B8918F4594AAA7D4E2DCEC3EEA5E48DF46905E3DB4CAC86BA57CCD89D09D0789783F657D63A692A2ED4D1';
    i(18) := 'B772E9071D86E540642D760346CDE4F65BCE8BB1981BFB4E76E97BDBA6069F469E5DF5538E3B4D52A48CF2CF58B576D9AD6346AF80444D60C0F9A72EC38C498F09EBCC2006EE578885A9841CA03C012013DA36DD47ACAEA3A284CF572B6189BCB9C71F6E';
    i(19) := 'E80A2EAD2CA99AD7693B9ACA90F737FEB87CEF27E0AC2A5FBEDF454166AE8AF3D515B7579C0A781B050447911B8932498EEE215E4C460ACB2BF4698D7B215512F67F30E15636F1153BCC75198FB38F0A7CEE3BE1662F6F7E4E065724F253E0E88C53265D';
    i(20) := '6E513D9AA270901FD272A8A764923DBA00D47927603E65573A391E4E096FC902A9CDA788BE790E9EC4F2A1549FEB6697AA3A574E74BD13E961AA9A46CEC3E6D2DE1C477F82D6B1801000C34701727E80EB5F06E469AADC23A39C3226349D985BB35FF5F5';
    i(21) := '5D69A47D0AF4231518AA47049B7276EC7A4924A48124924808CEAE801C67FA84C37087DDC13F3540244E0F2ABB13444EB3EABB8DB218A3A1D2C92A0380988C8696E30003EA5736A8BD5755C9E25C677D44E33E679E33D9BC05D2AF169179B6C9479D328F';
    i(22) := 'DE40F3EEC8DF67E9DD729BAD355B277C3531186B60D9ECF470EEDEEAD1655A2E282F33DBEA60B845B984E2468F7A33ED3574C656415B491D553383E295A1CD23B15C6E8653237C370393B2D07485F26B6CCEB75464D33DDE4CFBA4ACB3F5B7C66B87BAFA';
    i(23) := '6DA77E01547708BC4CF756B51335C72D3CF0AA6EF5D050D2BEAA73868E07A93D82F3DA72952E4EA4D256CA6B84B4F6F80CB31C761EA4F60B175D5F256CC6479C347B2DEC13EE771AAB95419A5C81EE33D1A144F0DC3720AEFC387456F991CF972ECE97F2';
    i(24) := '398FC71B7C5754FC35EBAA895CDB2DD1CE958D1FC3549192D03DC90F6EC5730A3A2A9ADA965353465F2C870D1FE4AEADD3FD330596D8583CF5536F34BEB9EC3E0B572A32A3A2472C720D51BC3DBDDA7288B174D14D08D503DD1BFBB4AB7A4BB5646436A0';
    i(25) := '78ADFD58C150A41A2F5251E1AEA69B66BC077E93B15215883FFFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  4
       , 'Eva Jelinek'
       , 'eva'
       , 'eva.jelinek@email.com'
       , 'I will tell you directly what I think and expect you to tell me the same. If you are sensitive then may be best you don''t talk to me. '
       , 'team_member_04.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 5
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400850000020301010100000000000000000000030401020506';
    i(3) := '00071000020103030204040503030500000000010203000411122131054113225161067181B114324291A123527215C1E1338283D1F101000301010000000000000000000000000001020304110101000202020202030000000000000000010211122103';
    i(4) := '31417151A12261F0FFDA000C03010002110311003F00D8AF5152095BF2A9A32F4EB87ED8A4CCAD7B35A5174727F3B5351F4BB74E46683D311558F009A6ED209BC656D24015A1752D8F4FB77B8947923196D23271F2AE6AFBE3CB5490C5671927F4920D07';
    i(5) := '31AEA6FA21716C62CE32306B3AD7A0C28A32DAB1EF5C85C7C69D47567C41EC30284BF17F576756D4C0739031B7BD1CA2B8BE871D8DB443802AE65B5886E40AE153E2596E95478CCAD8F36FF6A5A69EE18E2595DF3FDC719A365A7753F5DE9F07E6917F7A';
    i(6) := 'CF9FE2DB71B42ACE7D8571E668C7CEBDF8A5ED4761D04DF135F49FF4D020F5269297AA75097F3CE547A2ED594D74DDAA9E33B500FBDCB9FCEE5FFC8E6A9F8953CAD27A8F7AF07A5C67E03E9AD736708DD80C5253FC45D3E1DB5827D06F5C4C933B9CC8EC';
    i(7) := 'FF00326A86451C0A367A75337C5C9B88519BF8ACFB9F8A6FDC1D01507BEE6B0A49D80DA828EF24A324E06E696C68FDCF52BBBB0CB24ACCBC691B64D085BDB787E65048D8B1193F4A52EAE8440C99DD78527BFBE2976BD608A84924F9893D89A5BED7AE8F';
    i(8) := 'FE02239291AA0CEED8CEFF005E4D5A4B18B3E10071C331DC93FA893ED42B7EA68AA10F2371F3F5A0C9D5F27CBC8F2A9F9F7AA9A4D351DA5BF8BC60260823D78C534444B1B447040DD47B1F4F4AC81D4000547A6F426BF2CCBB9FFED3E88D4A06A383B0FE';
    i(9) := '2A9BD01A73AB58FAD191C38C8A528B1704D5941A8A9CD3258E3151519A8CD00C8556DC1A8643DABC8AA9CD4B4AA38A9D281656271B6FDCEC28B0DB98F70725C64FA0C50CC849DA88CED0DBB93904F27DA80C9BBC3C9A33FAB7C7B52B73365F6E327F8A31';
    i(10) := '505D4E79249A466186DBB77A98AABC92B46AC7F539C28F4143473A864F1BD0D8BC84601DB614FDA747BC99D40898E4649C636FAD3DC85AB4B1918E00E49ABA6B0549E4735D074FE81024A5AF16456FD008F2EAF52453971F0B8718B720E8DCFBE7BD4DCE';
    i(11) := '2B85734A58C67EA7F6A982E4A36FD8F1ED5B517449ADEDE459A3324CFE58D53D33C93EF5913F4DBB843BBC6408F01BBD1322B8B414EA008E0D5B07140B19354214F2BB6F4D815A4A8A10AB800D799707352B8A09054F7A835773B0CD54E28529920E455E';
    i(12) := 'E2537112A91A481B9F5C57BCA29E8EC6CCD809A694ACB20263451918E06A63EB539592774F196DEA6DCFC70B3CAA39D3D86F49CD1169CA229639E07B56C7873B4A0924A9007A0C7C8545842249EE3CB9624053E8067353BF95F1DF4258F4C862B7F160C4';
    i(13) := 'B778055251E41EA3B56CC7D57A7D8C49F8B93C49CA077541C67D02D52DAC2360048CC87B14A7A2F876D0F9955189EEEBA8D67CB7EFF4D38EA75FB0ADBE21E917AE23589E3CEC0B6D93CF6269DB46FEBE94CB0901C29C6401C9F95310F4508B93DB80AA14';
    i(14) := '7FCD52D2D9A2EA3E26391A48ED8F6A2FB13D33AEFAB8B39A4530B4CC8405890649DB3927B73423D587518E6B57B27B56910E897074EAED93A462BA0B8E99024ECEE36971E7048E38E286D6B6F183A1C927D589A3D42D6EB85B499BC36121D4490013B907';
    i(15) := 'BFDA99A0F598058F593020C46EC251FF0093B0F91CD1C29ADB0BB8C73F6F632287C1A36863DAA0C0C793548025274D0B51A2CA76A06AA554B124D6C74F941E932B9C111623391C6E581FAE6B1324F15A3D12ED20964B6B93A6DEE80566FED607CA77FDAA';
    i(16) := '33C778FD76BF1E5C72FBEAAF6211E2DF7652CB8F6519FE695B17315FC8BC86CE3EF5AD77691DBDCF8D6F088E1E0953B6DC9C52ED6812F7528CFEB5F7F51594BEDAD9DECCDBC850E09E6B56D2E186D9AC68C6B6F2FD0569DAB2AE3353F2BF869C97822859';
    i(17) := 'DF2748CE2B2A1EA561B3DD4845C4875261B007B607FBD12FAE412231C11B9A456CED99C6A7183DB9AAF64E824BF8E5811646C391FD32BB9C819AA4379E346322968FFD32D90389323F5120E00F73DABD6F8477C7E4CF948A2DA524FC39FF008BA00FD5AC';
    i(18) := '9D7F54786FFB5FFE6A9A9168FD65FC7EA67FB604083E67CC7EF4A1535B78E6B18E7F25FE5562FE82AACED515524D68805C2E9DE8398C55E4421B14128476A636B1957B0A82EEDC0A2468AC714CADBA81B5206269E58ADADE7CEA8C105D0E082072B5A574';
    i(19) := 'B18F0A488F971943EAAC2B1DD18A3459F2B03B76AD0B725BA4C193931EA8F3FE278ACBC98C9DC6DE3CADEAA62016534EC7E6DAB3239B0C33C8A704F8C30E0F3F3AC2B767751BBBC8662E88934635064933804F0DB734F748EAF74EEBAAD2DB4AB160232D';
    i(20) := 'AB718ECA6BDE1A5CB919F37F0698B5E9A81B023C37B55E37FA4D93E76375596E2FAC93A6AC31C30DC6D3B0CEAD3A8300B9039ABC282DE03ACE1210773E8B4D5B582C4E1B4007D6B2BAEDD0CFE1233C9D52E3D3B0FF007A3572CA42B71C65B3FD59418BBB';
    i(21) := 'C8DF9A462C7EB50CDBD785477AE8934E5B7754A82289A7276E6A9202A704530116064AB945614203CF45C1AA200C655BCB478CC806F502360F9721073E6E7F6E6A93755B780794788E090723006D9A5A09BABD8ED5434BBB9FC89DCFB9F6A1F47EA1E35B';
    i(22) := '5EDBB6CCB22CC9EDA8696FB0AC49E669AE5A590967639C9AB59CE6D6F91F3E49728FF26E3F9A9F24DE35785D651D1A3EB3EFDE9A4660B83B8348C390C0D68C7B2035C95D5130AB2B647079C56C5B4AC1776CE383DE938220D8603069B0BA172780327E94';
    i(23) := 'B675EBDEAEB6C846AD7391E44F4F76F6AC28C34D233C8753B1CB13DC9A5958B92EC72CC7249E77A6AD88CEF5D7861C7EDC99E772FA5E6895576A509C53B72C021C738ACF55763BD56902C52E96E2ACECAC738A9484F615716CDE9419558605F3B397FF00';
    i(24) := '1D87EE6BC6E9231FD3014FB6E7F735CF25ECF16F92C9DD7DA9E4992550EBC1ED57349D1C79B2A4F73C9EF5853331B9913E47EF5A4D305524EC05645E4E55BC78D75A9F2BE391E868A70431E48F950E753818E455A09E294028C0E39F51F3AB4BA73EA6A4';
    i(25) := 'E37BA54BE3C4A7BE0647DEB7A0894C58EF5CAFC3927F5DA23DBCC3E5C1AEA6073E2683F4AE3F263ACAC75F8EEF194E40A02FBD0FAC5C7E17A55DCFDD226C7CC8D23EF468C8073E941EA56E6EFA55CDB8DCCD1B01F3C6D533DCFB3BEAB9CE9F7915C40A76';
    i(26) := 'D4A006C7DEB4628830CA1C8F6AE43A6CD245ECCA74B0AD787A9489279763C9FF00D577471D6FFE1C11E634258D0498AA5B751498696D9AAC14F8D9A548DAA281538F6A80C146F55370A280FFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  5
       , 'Mei Yu'
       , 'meiyu'
       , 'mei.yu@email.com'
       , 'I have extensive exprience in all aspects of application development. If you need help then come and see me.'
       , 'team_member_05.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 6
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC4008D0000010501010000000000000000000000050002030406';
    i(3) := '010710000201030301070301060505000000000102030004111221310506132241516171328191141523244292B133437282A1445262C1F10100030101010000000000000000000000010203040005110002020103030305010000000000000000010211';
    i(4) := '21031231044151618191132271A1D192FFDA000C03010002110311003F00D5E4D3A4CF70DF14CA7BFF0080DF15145595ED49C0DEAD02479D54B6DD46455AAAA119723CE81BD3DFE6A34FF0D69B77711409A9CFC0F33440936E912070A324E07BD481C693';
    i(5) := 'BE2B257FDACB4566B667EEB27058788EDBD01BDEB7DA296E3B8495522660A81460B12350CE78F0F348F511AA1D1C9A5BBED3D412EE01852E01F9A74922EC41041F3AF2587AADEA9944CC445130479D1885241C6DABDE8AAF5FBE4BCB7852625492591B24';
    i(6) := '32AF207DB715CB57CA1E5D0BAFB65F27A1FEA117CF34C6BD51C502B7EA2D70AAD82356E314A4BA2A7C471E94EA56649E9383A6177BE3EB8AAF25E1F5A14F7A31B1CD566BA9643A6352DF0335D62D0525BD206C6A8CF7FE7AA98BD3FAADC1D90A2FAB6D53';
    i(7) := 'C7D9876F15CCF8F50A3FF6685868B74F3BC4DF14D229DFE537C1A921CAD6F228514F7B955A1B14A7814C9E723726A898B414FDA0D80A0E3D283769BA8B436E016F111E7E5525BCBF5CCC090832B9F5A03DA790BCF8393A0AE07ABB0DBF14B397634F4DA7';
    i(8) := '4F730149329959A4E2262C73EC0125BE3D3ED45FA75E096ECC8FE1D1165B3B952FE2C7FA8ED9FC5029C16711019850879DBCDB0765FBB5693A2F4E91A5459064B1EF273EA4FD2BF039A9B66C727CBE1138B4EFE15674EEEDA421238B9DB39666F534F9ED';
    i(9) := 'D2D62670BA8AB9D3804E3BCC2802B451D845294DB4247B015753A2C3243A73F5306627DA8AC8ABA88C79665E2B8912631172AA802AE9CA8240E036E7EF463A6D88EA486479B214E96230483E9B6DFF001557AAF4826E5D5711BE352381A8AE49C7F6A87B';
    i(10) := '35712233ADC4D872ECB206DB254E9463B798C514F22EBC633D36D735B8D2C5D23A6C1F57EF0FFE473560496F10C45181F6C5489647197702BBFA7B65E496AA1E6D959EEA53F4E147B540E26939D4D4434C43E88FF35C2246E30BF15C7034F1489FDCBFC1';
    i(11) := 'AEB715240E02E3009F5A98E05B6B0BD97E9888CF9B6D5717B3D2C9BCF2841E8373461589F3A64BB9A60640D7F6315AC290C449466CC8C79206E6B31DA03A4F7C795064FF00738D29F8AD7F5A0CB60CC83C7A5B1F8AC9F6862794C10A0D4F70E8028E4851';
    i(12) := 'B8FCB5248D9A0EE2BDC13D3ECCDE1B78554E92C2594FB20F083F7AD959DA770BA98788EE687423A8F4E8C22A5B424E0124966C0F2C0AB50DF5D4884CDA0B7918CF9549C879C9CB0B80D4122799A210CB08183228F92280FE9A49EDFBCC95461B9538340A';
    i(13) := '5ED0F48E9B7A966B19B89C90B9397393E5FF00CA78B7E0CF28AF26DEF228A646950862469D437ACFDF5A24577134642A14605B1FCC4E00DBD688F4BEA769D41310A889D7EA41C1FC549140922491B0DD18B0F5A6EE3E9C9A59EC5AE8F37EA2C636901122';
    i(14) := '8D2E0EFB8DAAFE9F6C557E9D66B0440C7B07DD8676CD5E1183E64FC5515D197536EF7B78B212290C7CD4E21F45FCD3C40DEC28D313067DB8AEC3CD71B8A50F353285C4A768CEE69B1D4A28A0153A8C0B25AE83E791F91593B85FE3AC6E0EE6289801E8C4';
    i(15) := 'D6D2ED4FE8DD8729E21F6A0315883D4DB23C21352FDE84D60D1A124A2EFB598BEA1D1FAB5E869A77922769331C63E9EEFD739E68C740E8F756F312CEC60036573935A696D63CEE38F335C592253DC2635E09C7B0F3A8B93781BD5725DE9D02BDA3438D85';
    i(16) := '67E5EC959C579DF04DD64EF5093C3139DB6A3FD26E233AA30C3239A57B771ADD0858E188CAFB8AA2ADA89E549A196F636CAC6648C2CEFBCB20E58FAB7AD73053A815FE59109FBEF56E065036A6CF1867D63EAC607DE8BF218BA65BE8AA5ADB5B8F365D38';
    i(17) := 'E349C7FCD11AAF61198ED6353B9C6FF3566AD1E17E0CD37726FD454A952A229986E2945CD75B8A508DEA054B71D4AB51A7152A5320326081A120F9D0D9A016B7713EE464A6C09F0B9DBF19A2A322024552EA504D268962708F1EFE219076A66B07465B5B';
    i(18) := 'F5295FA321247159E104D34B3BF78D1B48A6352BC806B577CA1E365E750C83F3589EA27AB09DED6C34277832F2C848D23CF18F3ACF38D48D5A52B8D047A759E9CDB5E37EA2DA61A2472D87057046B2A41DE8E5D58DB4D6E318223C687072463DEB0F616F';
    i(19) := '3C53E97963EF07858E1CE73EC58569E2ECFDA4D6D9FD55C091D7C41242884E31BAA6334D1580EA2A69B6D056DD580009CE3CE9D2ADDFED180AC6F25B346C18A0C8126469D5ED8CD2B48CA4488C7254004FAE28BDB29106FE7BD520ACCFA92A44C830807B';
    i(20) := '53AB8BC576AA4054A952AE38CD30A50F34E61B57221BD40A96E3E2A44E0D449522F14C80CBB10FDCD47783C1F6A921FF000299763C1F6AA7610A05755BA0CF88640FB501BDB52CECEBB1CEF45EF0B2592B6770C71F8ACFDC7539D189C07FEF59F51ABA66';
    i(21) := '9D152AB4558ACE05B80D21CB039AD458080C63BBD87A56366B859AE049E38CFF00DBCEF5A8E8D6CEE819890847AD2C0A6AF16D862040F2A8FE5CE09A2A400B81C50FB7004C8ABC03440F15A20B0CC937912F15DAE2F15DA71054A952AE38CE9E2B917D46';
    i(22) := '9B2C891A17918222EECCC7000AC9DCF6F05BDE3C50DB2C90F11CA588C9F7C0A8A8B7C1549F836CB4F2C140D440CF1938AF35BEED8F59BB528AC2DD3D213A49FF0076334127BABBB86D52C92100F0497FBE49A750637D37DF07B9C2716D93B7B9AA77FD4E';
    i(23) := 'CE31A03F78F8C6177FF9AF35ECCF599C5C3D8DCCECEB363BA2E4ECC3F977F5AD0387539E69352728E12F73A1A29E5BF6417EA172AF668A0EE7248ACDDC23B1253CAACCF77A5304EFE94DB2612139FB545BDCED9A231D91C03E389A57C0186AD674332080';
    i(24) := '46FCAD0BB7B3559C9C51AB2511FCF14F1426A4AD5052C8666CFB1ABCC70286C0E50EA0706AD0BAC8C38FB8AB45AAA334D3B2C21C8A7551B8EAFD32C828BBB8480370D26557FA8ED562DEEED6E4136F324C073A18363F14E2135736AED72B8E3C53B4BDA5';
    i(25) := '97A8B0B723B8894ED1677CFAB7BD055D4CA573AD4F91E687C9346D9CF3EFCFE6B915C3C67C2723D0D726684D2EDEF0C3F80AC6D03C60B2946E1B19E46C69D95FE497F3BD51B7BE6D2F807EA3B7E0D3DFA82038643F8A7194A3E57F971FDA2D319B918246';
    i(26) := 'E083839AD5F40ED1C774AB67D4C886E7609336CAFF00EA3E4DFDEB143A9DB0E623F6C8A77ED4B16D9D2403E696518C95339B5CA967F3FD48F4EBCE90DA43AEE0FA55782D9A171E5595E91DAF9AC90476B744C43FE9EE06B4C7B1E47DAB476BDB5E937202';
    i(27) := 'DFC0D6EC7FCC88F789F8D9BFBD45F4F2E639FC03EAD624D7CD9A0860D481BF9AA5B7C9974F18A674DEABD1EE620B05EC3230E0160ADFD2D8353C2BFC610082A467237A0D35CAA05DD96D78A90714C2748E2A85EF58B0B65FE26EA2817CF2C357F48C9A2B';
    i(28) := 'D32296A775955E2D21D08C38619523D0D60239874EEA8FFB39CA4713BE8D27185F41EDAAAF759ED9C5340D69D2558A36CF70C31FD239FCD6656E201B19591CF278156D3D369EE9631540B4E962AEEDE3E2CF40E9DDB7923654EA31968CEDDEA0DC7C81B1';
    i(29) := 'AD4457D6F7112CD6F209627E194E6BC7D671A4689F57B1DE8AF67FAF5D74EBADFC7093FBC41C11F14D28F80CB4AD5AFEAFD1FFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  6
       , 'Madison Smith'
       , 'mady'
       , 'madison.smith@email.com'
       , 'Mady to my friends - I love being creative and coming up with beautiful solutions.'
       , 'team_member_06.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 7
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400800000020301010100000000000000000000000501040607';
    i(3) := '030210000103030303030203080300000000000100020304051112213106416113225114714252910715233233A1B1C172819201010003010000000000000000000000000001020304110003010002020301010000000000000000010211032112313241';
    i(4) := '516122FFDA000C03010002110311003F00EA108C4318F8681FD97DA803031F0A5002108400850E735AD2E71000DC9291DC3AAA8A989643FC570EE38403D50E7068C9380B0359D5978949F472C676D2123ACBA5E27CFA92CA5A7B64E146A2719D5FD463B8';
    i(5) := '20A02E3D0DEEF146FD515448D23B1391FA14FACBFB42AA8DED65C9A2466777B7638FB2921AC3A3A17851D6D35753B2A695E2489E32085EE801084200421080108420042157AE94C703837F99DB04025B9D4545C67753424B29A3D9CE1F88AA22CB4D17B8';
    i(6) := '8D4EF29A53C618D3B72A646642CA9B66B290A9D4D1346034054E7819F0309A4CC2016BA67765855346CA50A6A29227E72C095CF6D8F396FB7C2D0BC0C14BEAB014CF23FD0F8D32C7485D66B4567A13BCFD0CFB786B8F057496B839A1C370785C958F1C1D';
    i(7) := 'F2BA0749DC7EB6D61AE39969CFA6FF00B0FE53FA2E88BF230E48F163B4210AE6608421002108400AAD561CE0D3D82B2AA4E7F8C47808C151EDD3C2F8D5B1CAF778CE52EACAD829585D21E3B059D746B3D913386E12BA8D8AA7375650FA85A7503F65F4CB';
    i(8) := '8415803A2390B9B937F0DE33D12E07097558298CEE11B727659FB9DEA28DFE9B46A3E1578E5B7D176D25D9F5C1F0B4FD0D3B995F2C79F6CACDC790561E3BA39E72633A4AD8F44B83EE2D23BB495D109CD2D30E569CBC3A021085B9CE0842100285284046';
    i(9) := '72AA547F58790AC4CFD119236278549BA9CF2E7BB511B286C94BECF398B834E319F2B35577181B2988B3D4909C63B653CB842641DF1F19482AE30C6968601E561C9493ECDF8E5B4666E1738456BA9DF006B86E48C14E6C0D8EA18E7C6C181CFF00DAA125';
    i(10) := 'A23A9A82EFC6793DD6A2CF6B6515386B4792A9B0FD69A6525DE08BA87EA69C7B86187821645D5B1B642746B23B95D03A998DA8A72C0370B08FA36890823753C752B7454D62C27F78BB0D718B0D77C2DA7454903AAE22240C7E0939DB3E16522A53A34E36';
    i(11) := '56EDD0C8DA86B19900F61F657573BD14A8A73DB3B087070CB4E47C852B37D0F2C8EB7D444F24FA33B9A33DB21AEFF6B48B64F52673D4F8B6BF01084292010A14A02B5764461C3F09DD2CB6CD24E6691C7DBACB5A3C04DEA181F0BDBE12CA186389AF11F0';
    i(12) := 'E7127EE55293F25F8692D7852FBD47B48D69072B3F75D0C04829DD4BF4B4F958FEA49E66370CE5C70163CED661AF02EF74A91571FA911C7BB89DF0B674F341053B5F33C0C8E0ACBD86CA626FAF36F23B7DD36A9820D3AA56EAD3C656712E569A5D2A782D';
    i(13) := 'EA0AA8C3CCBC465652496395DEA30A71799FEB2231B07B5AB3ED8FD3240EEA257B7F65B7D21A533F2CF2ADD9C075C1B9DB9FF09453CE43B4FCA636D974D6B0F182A65650A7FE59B6E880EF4AE24F1F5471FF0096AD3ACEF464D4EEA5AA8E3703289DCE91';
    i(14) := 'BDF70307FB2D12EB9F8A38AFE4C10842B150421420070D408F9547E90539739AE2438E7055E5E337B861435A4A6C57547DAB35D414FAE10F1CB4E42D1D4F707B2557167A94CF1CECB9F97BD3A38DE19F8AFF007261632960F5870427AC68ABA7D550F742';
    i(15) := 'F2376918C25FD3F4C227973C77D939BAD4C6CA627483B2886BC7B25FCBAE8CE575042D1218E7D87EAB2F5D23D8FD300D7BF2537A8A9797B8018694B64193B8DD154FD22F9FD6144C2FF73F62394DACD486B2E94F4FB8123F0E23903929542F2DCF6CAD9F';
    i(16) := 'ECF2DCF9AA65B9C8DC4710F4E2CF771E48FB0485B48AF2578CB35D6DB1DB6D8F7C9491689250048F249271F7298210BAB0E4DD042108010842020AF278DD7A954AB6B23A5607BF8270A502A57370E242592B73907829D4AC8EA23D6D3B11904251531CB0';
    i(17) := '9396EA67C858F271BF68D62D6615A089A0168D8F6454D2EB84FA8ED82F092A1AD765AE19F82A9DCAE4F34E58321DE16399D61AADD1554451B8BB078E12B9400E39ECBE4D5CAC9497E71F0ABBA77B9C7E1554B2EE8B9414725757434716CE9DE199F80792';
    i(18) := 'BB1DBE869EDF4715253B74C713703E4FC93F75CC7A264A78EFD4AE9DC017170693F98B4E95D5D74F12EB4E6E56DB04210B43304210801413852BC64998DC927840134AC8E3748F386B46492B2951788EBAA1DA4E626ECDF3E5797565F9CE028E03A187FA';
    i(19) := 'A4EC48F803959C86A58C6E187729A0D153DE5D6C983253AA8DE79EEC27FD279EAC53C6248DC1EC70C82160A6ABCB4B6439076C2F3B55F6A2D13E89497513CEC3F2E55E59069EE76F8AA01FC0EECE1B2C9DCA0BC51125A7D7887EB85B41510D5442689C1C';
    i(20) := 'D70C821529DBAB23190A6B8A6BDAECB4DB473C92AA499D870D2E1CE57C8273EE2B5172B2D34F9786E87FE60B355F6EADA2F711AA2FCCB9EF86A7FA8D95E91F56E8E5618CE240E1A48E4105772B5558ADB753D4E72648DA5DFF002C6FFDD70BB4D2BE694C';
    i(21) := 'F2B7DADD9AB6947D55358A9A09B4FAB4AD768A88FBE93F89BE42985852FB3A5A157A0AFA4B8D247594720960946A6B87F83E5585733042141407FFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  7
       , 'Tyson King'
       , 'tking'
       , 'alonso.king@email.com'
       , 'No problem too big, no problem too small!'
       , 'team_member_07.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 8
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400890000010501010100000000000000000000000102030506';
    i(3) := '04070810000103020404050107040300000000000100020304110512213106134151223261718114072333425291A11543B1C17282E101010003010100000000000000000000000001020304051100020202010303050000000000000000000102110321';
    i(4) := '4112315104227113324261C1FFDA000C03010002110311003F00F534210801084200421239C1A0B9C6C06E4EC80542CD633C7784617998C0EAA9869923B5AFEAED965EA3ED63130EFB8C3E1637B48F738DBFEB95281E9A85E670FDAED535CDFA9C39859F';
    i(5) := '98C521BFC073568687ED2B862B086BA49299E7A4ACB0BF6BB49406AD0A2A5AA82AE06CF4EF0F8DE2ED7052A0042108063C754D521D428CA9443254210A09042151716E293D05065A607992DC39C0795A806E33C5D4387668A1FBF9C69A7941FF006B0D8C';
    i(6) := 'F156278812D9252D8BA44CF0B7E6CABEA2626F2CAE2E71FF002AAA692491E6DF015E9204B512B1F96EDF101675BAAE47CACB11972FAA89E4B6F771BFA289F2B4696BFAA86D122BC8F851917D47F09BCC036052179ECA960D6705F18BF039DCCAA2E7D239';
    i(7) := 'BAB06BE2E96BAF5BC27138315A08ABA9C111CA2F95DB8F75F3A97382B0C2F1FC570E99AFA39DF1E4372DCC729F76EC96451F432166B82B8A99C4387B9EF0195301C93301BFB387A15A4BDD481531C354F48E170880A8421002C4FDA156BA211401DA3879';
    i(8) := '2FBFA95B65E77C754EE9F1C00E8D6C6D373D91032DCA123338370372755D8DE1AA97527364BB5CFF002C7D403DD58E0F42D7100C632DEE2FD6CB4E21396C468B39CDF06B18AE4C13384A5F3480DBA0520E188468F67CADC65696D88D970D446D17E8B094';
    i(9) := 'A5E4DA2A3E0CA1C069997193F85CF2E0708E8B4C435CE3E8A0958D37B2AA9CBC96E95E0C9C98331A4E9A7454F57466092C763B2DA4CC05DA6CA8F1BA7063B81B2D2191DD3293C6AAD0FE00C65F84F11D382FCB4F5679130BE9E2F293EC57B887106CBE75';
    i(10) := 'C3E58A0C429A699B9E28E663A46F76870BAFA2839AE8DAF66AD7005A7D085D28E56878374AA303AA7837402A108400B0DC42EE6E3B367176B1AD6B41F40B655B54DA4A592A1C2F905C0EE7A2CA635472C9522A9CED486BA46F60555C92D168C5BDF03F0A';
    i(11) := 'C29F904D21B076A02B47C5A5829210042C036B04C9DC4B7247BF52AAD2A2CACE491AC17D6C57055B7427F65C58CB8539B9AE6C6FFD1985EEB8A9ABAAA5B379AD9877EAB1951B46C9E3CDCC2C3F09B3B72FB94E99E61B4AE160AAAAF13A9924E5523039C4';
    i(12) := 'F98ACD2BE4D1B249416EA02AEAD8B9D139A06B6D14B3458996932C8D07B029699B21FC4B661D7BA9AE9DA7645DF7463AA227B26746410E06D65F416012544982513AAADCEE4B3391B13946ABC4F198A3871C6E6697B486B8B5BB95ED7C3F5D4B5F83D3D4';
    i(13) := '5282D8B2E4CAEDDA5BE12D3ECBAE0ED2F8397245A6FC161D128DD37AA51E60AE663D0912A824E5C4E9FEA28A58BA9171F06EB338955D44B5EFA28800DC9775FA8B2D7917165495D84B0D499C8B7848649D4159658B74E3E55FC1B619C55A96D53AF962D2';
    i(14) := '5DD47177C83FC2E3AE839A32C8F788CF99AC396FF2355DF4CCE5C0C8EF7CA2D751D4C632136492B4445ECC6F12605415A20E535EDFA7D1AC60BDFF00E4772A1C1B07A98EAF98E05B1922CCF4571592BA379B6CBA3039592CCECC412D58DB93A66F5D316D';
    i(15) := '11F12C0D8F0E040B158E86273CEFE1B1CC2DD4E83F65BBE2904E1E40171D1622966CB2E5BEFA1093D4B421B8ECE08F037439B2CEE91EE370F0082177D3C53C60735D73DFAAB76DB2DEDB85C530CCFB2ACA4E5DCB28A5D8AEAA8633C405F28D22801683DC';
    i(16) := '85E99C114B2D370EC1CD195D339F3007A35E6EDFE162A8B069715E25C805E2CACE61ECC68D6FEFB2F516B5AD6B6360B35A000074016F8A3EE72E12E94639A494143993EA7FC16C4EC95A0EE5284AB639C46F947B2551C0E2E89A4EF65220114350C1234C';
    i(17) := '6ED8F653A69683BA0385F1363B319A35A2C17355BAD1156154DB10475D155D6825842CE6EACD21BA3218AD59E7646DCB89B00AC7062FA1A6909839D23FC4D00DAE7B5CAA8C55CCA2AE6D44ED73E2602ECAD1724FB2BBC3AB59895036AA8607C8D71B06BA';
    i(18) := 'CD208EE16104DB6CE8949524263F89838634CAD11C8743103720AC58735E038332480DC9EEB4388D16292CF77D13AE41CA33023E567AB054D242EA8A88846C61CB96E2E4FA052D49BEC4C5C52AB45BD2CD9A105DB8DD42E95BCFCDF9415CD8397D4C2E9C';
    i(19) := '831B5C3C8EDD3DB1BE6A86C31789F23831A3D49B2A2EF44B7AB3D1F86B0F652D089B474B57691CE035B11E16FC2B902CA2A5804104510FEDB1ADFD8594CBB52A5471376DB6084210823A71689A3D148A387F09BECA44008421011CCD0E8C83A7507D554D';
    i(20) := '40CC0F7EAB83880623FD6B0BC42199DFD3A198C55708D80702D6C87E558D40D4B9AB3C8CBE36525661ED9DE1EF1E5D94CCA586180BA0BC2FFCD90DAE7BAEF1CB9343A15C956DC9A6C0E84AC96B6B9374EF465B10C47178E52D6CF23801604E559F929A49';
    i(21) := '653254B8BCDEE038DD69AAA38DCE7177986CAA656B0B88ECAAF248D697848745372A03974BE8B4BC1381493540C5AA199618EFF4E1DBB9DFABD82CDD0C51D4D6C34EFD6227C43BDB5B2F54C3C814EC63406B5AD01A06C0057C10BB93E0C33CEBDAB93AD0';
    i(22) := '842E839C108420190FE1B7D93D2016000E8950028EA24E5C2E70DC0D135F55131DCBBE692D7CA3FDAAEA7C5A2AB9EA299C5B9A23A341DDA7AFEE855C976BD9538963B4F87BDB04E3332A34907E969D3328FEBA7A101B25EA281E2F1CEDF11603D1F6DC7A';
    i(23) := 'ACB6370573B18929A4697CD23BEECF42D3B5BD16B3016B282919413BB3B5DF98EA013F97D9747AAF4F8A18614EF2495E8CB166FA6E98FF00A98DF67C4F041D8829956E9A48881672A7C7A925C127FAAA425D4721FBC846B909EA3D1329F1B6C8C1E2BAF2';
    i(24) := 'A5D51D35DCF420D492923871174F1CC5EF63B516006CAA8731F258DC02568AB6AE19203701C551699AF6B2AA6CD5323AA99F4548FAA8CDA58AC587D6EBD4385B158B15C229AB99A17B72C8DFD2F1A382F21E21A8228CC43791C02D97D98D7B63A6761D21';
    i(25) := '0D79D433D47FE2E8C0E96FF267367FB97E8F47426B0DDA1396E640842101FFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  8
       , 'Daniel James Lee'
       , 'dj'
       , 'daniel.lee@email.com'
       , 'I am a DJ I am what I say. If you ask me a question and I don''t answer, it is not because I''m rude, it is probably because I have my earbuds in and am rocking out to some gangsta rap.'
       , 'team_member_08.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 9
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400840000020301010101000000000000000000040502030607';
    i(3) := '0100081000020103020503020406020300000000010203000411052106123141511322613271071442B123245262819116A13353C10100030101010000000000000000000000010203040005110002020105010003000000000000000000010211210312';
    i(4) := '314151041361C1FFDA000C03010002110311003F00E9A16BE65F69A90F1522B918A6B144F20C3B0F068BB5B9CA7293B8AAEEE164939B190D40CD7315AFBE57080F93441D8D4B06CD4156938E2AD1613CB3DD227C9A9371970C47826FE3DFC6F42D068720';
    i(5) := '62869DF2714BFF00E63C38FB477A8C4F4A0A7E2BD2BD41C9287407DCC0F4A16BD05335D07FE25FB559545A4B1CB6E9246C191802A41CE41ABE80C8ADC7B850B2FD6451846F9A12E061C9A28123DB5D9CD147A1A1A0752C31D68A3D2B828C5DC0E4E2297E';
    i(6) := '483FF55A38240A549ED59ED507A7C41CC760C01A791EE14D7200C97EA156D45540A950184DC4BAC2E9B6CA117D4B894FF0D47603A935CE350D5E7BA669198FA99E8DDA9FF1C5FC53DFA4713106DC6E40272C6B29797B0CE9C8623CF8F70E841F22964C68';
    i(7) := 'C45B35E3ACA1AE9BD481F66D8654D0BA8410A9CAAE55B752BDC578E6577684A9747180DDEAD5B3BC36D1426324C4490DF149B90FB58A799E39151B747FA5AA7EACF1165C9F6F5FB51371632058FDA410E4FF008AA9EDA762C4A9DF635DB91DB5F81BA771';
    i(8) := '3EB1A6B0FCB5D48AA06D1924AE3EC6B57A17E286A115CA0D48196CCECE507B87F76FD6B02D1B8392A476DEAC47E518068EE15C133F44695AC69FAC5A8BAB0984D11D8F6653E1876AF6E47B8D713E15E24BED0F528E4B621D27611CB139F63027F715DB0B';
    i(9) := 'FA88B2118E65071F7A78BB27354516E196719E94CA814079C1A3874A6672323C50BC9A9DBB8DB23F634DECF78549F14B78B862E2D5FE48A3ECDBF8087E2B80C775E5785ABE2C31406307AEC51C777713CF84527A0EA680B0E167BCE5BB58BD24639064EA';
    i(10) := '47DA9AEA964B7FC531DB4CA7F2D09121CF4773BE3EC2B5324602F28D80E8054E4ADB29174919C1C37A6A05CC4A1D7B8154DDE9B00521540A793AE0D0728C919DEA524562211A2DA81CCC809A1AE6C6D546C833F6DA9DDD3051B52A94F3641A84ECB468CF';
    i(11) := '6A3A545346DC8B838276AC8CD118E52A7620E37AE8338E58D8D62F5451EA96237269F464F8626AC5728111D91D5C6FC84363CE0E6BBF695791DF693697316CB244A71FE2BF3EABF29C575DFC33D496E74136A4E64B572BBFF49DC56A863065D457936B1C';
    i(12) := '60A66AE1D2AA8A550B835683919A71119AE305F6DBB787A26C8E6D53ED55F182FF00291B78715E698F9B45FB514063E26A7818A8559DA80C25D45952FE221464756A35DB2334BF5B6315CC6F8D9F607E451B1E4C6A4F8A47CB19708A271DE819451D7240';
    i(13) := '14B669D15BAFC54A6CB4016E2266D80DBC9A0A6842E70451377A8C31292E718ED59AB9E2459AE3D28936CF5359E59E0B2745F7113B1393B567B57D31E552F1EE7B8A75F9D247D6A4FF004E6A1CE1B7C7F8A116E2EC6694953304E8D1B9561823CD6EBF09';
    i(14) := 'EF39757B8B6270258F20792A690EA1A7ACBA8A28180FD698DAC2749B886EECFD92C0E0E47707A8AD2B556199FF000B7B97876A851797A55A287B197D5B68E43D5D437FB14456833A11716AE74ECF860687D14735AAFDA8CE295E6D2E4F8C1FFBA0F403FC';
    i(15) := 'A2D142B3446A63A5448A90E940600D56D92E6DF0C3DC8C190FC8A848E56DC15D8E28BB988CB0BA0D891B507CA268590F6F69A590D1FE9CFB89F89192568AD1E69DD0F2B7A2A7901F1CDDEACE14B8BFD4E722F62648D3A31DB7AD8C9A6DB88BD2445441D8';
    i(16) := '015ED969D6F6FEE8C609A83D3B6ACBA9D2325C630244E823FD5D4567A3D016E9B9DA56084744D8D6A78CA0E599250723B8A53A7DD2F3E01DC76A94AE3275E954AE29F38048B85A38F0503EDFAD8EF449B358472824E3BD3A33868F73834A2F1C02467AD2';
    i(17) := '49B7DD862ABA146A0989A2901C107AD7DEF4BE8E22C64121048F00D4AF97D48B63B8EF46F0F598BEBF81231CCC483237855A68A78EFA0B695B78C59D5F4F18B78D7C28FDA883D6A9B6C0F68EC31569EB5BCF3859C44BCDA64C3FB734B3875B36C3E29B6B';
    i(18) := '639B4E9C7F61A45C3B21F48AF834572066C2BCAF6A06451406258141CB188E47E5FD7BD106427A556EBCFF007AE68E4F22F772720D41275473CE7000C9AB5D40908343828AECC7193E6A4ECB2AA10F195C5B3DBABE720EE08EF5898EF9A460234E4E53B3';
    i(19) := '1EF5B1E2BB3FCD47106758903743B6D598BC5D320B82B685E5551EE7C7B73F1519C6E4FBB2F06F6AF0656D72648F0C77A12F5886F8E942596A114F3B4102B617EA246D9A2AF010AB9EB5269A791D3066018729E87AD748E1AD22CAC34D8A482302595433';
    i(20) := 'BF739AE6AE71BD758D250AE996C0FF00EB5FDAB47CEB2CCFF4B7490643B1CD5B9C9AA94EF530726B499503EA639ACE51E50FED48B86A0E6859FE715A0BD1CD6EE3CA9FDA92F0A1FE148BE18D71CCD2382460552C08D8D5EC7009F15433731AE41678A77A';
    i(21) := '974A88DABDCD70016E97079C77D8D67B567BD32471D9B0472DBB11900569E550CA41A4D776EC25CF71D2A3AB17D16D292ECCFDEE81CCC6E6EEF649A6C7EAC041F6148AE61D3E2464694CB20C855CEC3E76ADACF6EB2AF249F49EB48AEF4FD3E37F4E38C0';
    i(22) := '3D7353726BAA34C649FECCFD8C7E9B654614EF9E99AFAEA5249DF61D28ABA290E4038F14A647776201CD4A9B6DB0B91366C8AE9FC2DAADADEE97040B2AFE66140248B3EE18EF8F15CC2343B6698E8DEB43AE5BDE404810A9F57E54F634FA73DB35E327AB';
    i(23) := '0DD1BED1D5C75A9AF5A59A6EB565A8C8D142F89E319785B6603CFDA9981BD6C4D3CA32553A642E066261F069170B3624B84F0E7F7A7D2EE87ED59FE1B045FDDAF873FBD7019A795B0BF7AA06C2AC90E4D566B82784D7AA73506206E4E07934AAFF0089B4';
    i(24) := 'EB1C807D7907E94E9FEEB80386E9415DA8273D73DE952710DCCF6935D4C8208D14B041B9F8C9A6F1219B4F85BF5940DFEC6684E36A868BA626D405CAC64C2BEA1F02B2B7EFAAC6E5DEDDA307A135B7825432321D9D7EA53D450BAE2A9B56720600EF59E4';
    i(25) := 'B17E1A22E9D1CE6579666F76DE6A2B10518EF477A285988E955244F34E23452EDFD23FFB53B6F08A576C8AC2E79513DCEDD00A77676C2D62E4CE643BC8DF3E2A569622D973F54BDDBC7C0AB0EDD6AD0D2DAADF2465AB6E97029D76E6E74D96D756B17F4A';
    i(26) := 'E607E5E61D0A9FD2C3B8AD7F0DFE20E9BAC72DB5EF2D95F74C31C46E7FB58FED58DE2705B4E1BE007159AE452BBD14DC4128A91FA018732646E0F71B8ACDE8D21875BBC8CF76CD732B2D6F58B1216D2F258D7FA79895FF00469DE8FC67716777EBDF47F9';
    i(27) := '80DF5B2ECDF7AA29F1827283E8FFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  9
       , 'Brock Shilling'
       , 'thebrock'
       , 'brock.shilling@email.com'
       , 'I am your man! Let me solve that for you.'
       , 'team_member_09.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 10
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC400910000020301010100000000000000000000000503040607';
    i(3) := '020110000201030204020704080407000000000102030004110521061231411351142232617181C1072342914452627273A1B1D1152463E12533368292A2B201000301010000000000000000000000000001030204110002020104010403010000000000';
    i(4) := '000000010211310312214151133242612271A191FFDA000C03010002110311003F00EA9451903A9AF25D075603E7401EA957141C68971FF6FF00F429919E01D6451F16148B8BB50B55D1E4852557965650A8A413B10C49C7C285903C705366C661E4FF00';
    i(5) := '415A3AC7F03DFDB470CF0CD2AA3B10CAAC719006F4FF0050E20D2EC2D9EE259D0F2025501DD88FC22879018D1919C7715CCAF3ED3AE675956D545BB123C3CFAD8E5F6813EFAA36FC61A9FA58BA17456575E5C49ECFC3C8FB8D143A3ADD15CC74FE2BD5AD';
    i(6) := '6E5247733000868CEEA416CFC88ED5B0D3F8B2CAE2106E3EEE43FABBA907A1F3145050FA8A4D73C57A4DB4A6299995C007A0E87B8DEA06E37D1867058E3E1FDE8A11A0A2B34DC77A58E88C7E62A27E3FD3C7B3113F3FF6A2981AAA2B1EFF006876E3D983';
    i(7) := '3F33FDAA17FB465DB92DC6FE79A2805ED65C46C49F45988FDD342E8DC4926E2DA419FD6007F5AE8D453B039C0E1BE2493F472BFBC547D6AA6ABA06B9A74226B98FEE9885251836E7A038AEA54BB5F447D38871CCBE24671F060451B98CE70E8748D3DA59';
    i(8) := '8817328DFA828ADF87DC6B2775A85C4AA6291CB286247CE986BB757135CCB1CCC485761D7DF4A046EC76527CEB366BE888BE362723B1EF409F2394F4ED9ED527A34C5B9421C9ED8AB36FA25F4E46232A3CC8C52724B2C145BC20B5D4E5460C0E181DE9EE';
    i(9) := '9F7F15C480630B91965D9918F63FB27B1A4D26857B09C95CF7C8A96DE331CEACE1A2CFAAC41C75D8FCA929AE98DC64B28DD456D05C72DB5E278F08071274743E40F51FD29CC3C07A13A2C81E6756008F580D8FCAB033EA77366F1A2B09554679BA3820E7';
    i(10) := '070771F4ADF7026B0350D3E587047A33FAB93BE1B7C7CAB7661961782340518F0DCFC5CD48383787C7E8E4FC58D3BA28B109D7847879463D101CF9B37F7AF6BC2DC3E3F428C91DCE4FD69AD140051451400550D6A38E4B06126C819598E71B29CD5FA55C';
    i(11) := '539FF01BCC1C1F0CEE2931AC9CEEDB49835DD62E660B8B656259BCFCB14FD345D3ED139638976EE46F517084623D195B1EB3B3163F3C5329B2C0E2A332F11635AC01B21147CABC488AB561D4E6A09D0E6A0CBC4AEC88DD466A396C2DE64F5863E15ED811';
    i(12) := '5247CC7D5F3A6872104F612CD72563C6DB1627A0FAD31E0B9CE9FC551C24315B8568863CFAE4F37C3B50394DD346DB0077A87918EB3653C039889D3192463046C4D74C1F08E49AE59D6E8A28AA120A28A2800A28A2800AA1AE056D32646D848393FF002D';
    i(13) := 'AAFD50D6D15EC4F3FB2AE8C40DB3CAC1B1FCA93C31ACA31DC3EC967A3734EDCABE2385F91C7D2A61AE58B9E45E7CF994603F3C559B38120D36232264F3CAF80327776D8521D52F35C13A8F428960277224CB28F79DB7F9542474450D5A40C39874EB54EE';
    i(14) := '2E3D5CA8E66ECBE75369A5A7B76322F29233CA7720F96452F9DA55793C0C0900C465812A0F99C548B2EFE88A4BCD4013FE54728EE5A9868F7B1CD21B79E231BB0F51BAE0F952986DB54F58DCEA064240C058C6063AF5F3AB96F0DC06570C9CCA766195FE';
    i(15) := '4738A769781536B9B435D47465103DDC4B878CE5BDEB4A34A758EF964950C88240E71D1429EA4D6E2D617B8B22926C654C1EF8C8ACCDD4296B34B6F11CFA3901DB18E62055A4F646D11D38FA93DACDCDA5DC37902CF09251BCF6208EC6A6A57C391F2695';
    i(16) := '1B7694971F03D29A5522DB8A6FB23A8929C92C27C0514515A321451450014AB89E578345B89D3DA8B95C0F3C30C8A6B4A78A86787AFBF87F51498D64A520E6B58C28E55C7D696496A8CFEC83F1DEA7D3B534BFD16DEE011E272F2CAA3B3AEC73F1EB54BC';
    i(17) := '79A4B908A70AA72D5CDA8B948EAD3E5365E112A40DCA31B525910A3E4ED9A67757B1451C8A10A96EE371FCA9149AB4C1CAC51E7B066C8ACC9748DC3B65B8E7B7762818161D6AC4491BBA827049D88A4C81412E767624E7DE6A7B7BAFBE404F43BD6769B3';
    i(18) := '71A72BC2862E6E64EA9EEF3159A9966B9BC9A145D9D9FD71ED3316D94538D16F8CF71344770A7D5A6F69A2D95ACBE3282F2E490CC7A13E43A55DC77A8D61339E3A9E94A4DFB9AE09B4DB77B6B08207F691402076F7559A28AB254A8E76EDB7E428A28A62';
    i(19) := '0A28A2800A57C5071C3F7DFC3FA8A694AF8A3FE9FBEFE11FEB40189E08859EDEFC8DC272311F98ABF7732D846D726369157D6654F688F215F3ECD0066BE52320AA023DD934CB56B3304C626198DBD643E6BE5F2A8EB2AFC917D197C58BA27BAD56CA2BAB';
    i(20) := '7B5E586E17994330E7032460E3BED555F48D4F1CEB0A28E52C031C9D8F4F8D5F920B982157B0B992D8024945E564C9DCE5181A477DFE257788EEAFA6755CEC988C1E6EA08402B0D472CB477FC76D7F4ABAAFA5DADD25B878A47661944072177CB1DF6E95';
    i(21) := '3222A4808EDBFCEBCC3630DAA16030C73EF3BF52C7BD496D0B4B20037E6358935D1B4BCB347C2B1133990FE2AD8D67F43856DE5483F18196F8F95682BA349544E3D67720A28A2A84C28A28A0028A28A002957149C70F5F9FF48D35A41C59A9D945A5CB6F';
    i(22) := '32BCB14D88E531301CA09EEC41C50067BECC58FA45E2FF00A6A7F9D3CD56F9AF6E2E628C2FA3D8720E7FC4D2BE723E016975949A5E9361E269B17A3BCEB876662EC479966FA543C353ACD73A9DAC9BF8BC928F78C143F4A251B4D791C5D493F04F231317';
    i(23) := 'AA72A4528946189AB1A82DD584A63EA8DEC3763FEF4A279AECE761BF715C4EEE9F0CEE8555AE532C105CE09DCEC29CE976F0C00DC49D106547D6B2F14B70AFB2EFE677AD65B44F368EDCDB484669ACFF00453C7EF82EF0EDC78F772CEE7001CE7DD5A8EB';
    i(24) := 'B8AC8E8188BC283ABCF2631FB0BEB39FA559E18D625BAB39ED59B9AE74E9A481C75256362AA77F70AE8D1E6272EB7B8D2D14B86B11280651EA1DBC45DD73EFF2AB71DDDBCA328E0D5299326A28041E9BD1401813F6A1233F870E9BCEE4E154484927DC02';
    i(25) := '53ED2F5AE20BC026BDD3E3D3ADBCE590994FC230A3FF006C54773AA2C249B78522C670E1403F9D20D4756964E62D29C9CF7DAB4A3E42CD06ADC4D6D0A940F8CEDB0AC3EAFC4707DE340D287618607014823BA906AA5F4BE2125A4CF97E74927E67748C9E';
    i(26) := '6E660286E970091A517BCCBC83611AA2A8DF6C28DAA4D3F52165AB4174C796373E14C7F65F6CFC8E0D298A51CC4F6249FA0EF5F6EA40D0EE3AFC295F033A35D471CF198E550E8DD8FF005A4177A74D6E4B479962F2FC63E23BD4DC2FAB9BED2D165399ED';
    i(27) := 'FEE9C9EFCBEC9F98A64F1CAFD76ACCF4E335CFFA521A928631E0CD19631BE3A5314D4D61D3DF99B03181EE1562EB4786E72DFF002E53D1D7BFEF0EF4B34DD30DF4FCD33AB5AC0FEC2E4872A76CE7A2E47CEB9DE8C94A977D97F56328DBEBA343C310C981';
    i(28) := '7F7039649801121EAB1F5FCDBAD63346D7DB4CE2FD4DB76826BA90B81E4CC4E6B7F1B98E39253B08D4E07BEB935E23C1C41739CE1F0DCDEF3BD7424A2925D1CD26E4DB674ED504A9FF0012D3889229579A6B73ECBFBC7EAB52B8B548E4065B3728C9BC90';
    i(29) := '1D993E5E55574FD5A78ACE48428930A1BC33B86524648C77A526EACD75282705ADBEF007CFACA037AAC038EDFBC2B774628D7D9712E48576DFCE9B2EA50DCAF84EC4730C7AAC54FC994835CD659C73928D9193B8E86AED9EA4E3954B1D8EC73BD16828FF';
    i(30) := 'D9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  10
       , 'Miyazaki Yokohama'
       , 'miyazaki'
       , 'miyazaki.yokohama@email.com'
       , 'My motto is to lead by example. I run a tight ship where everyone knows where we are heading.'
       , 'team_member_10.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 11
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC4008F0000010501010100000000000000000000050102030406';
    i(3) := '0700081000020103020304070504090500000000010203000411052112314106135161222332718191A1071452B1E14292B2D11516336282A2C1F0F124253472D20100030101000000000000000000000000000102030411000202020203000300000000';
    i(4) := '000000000001021121310312224151617181FFDA000C03010002110311003F0039939A424F8D2F53498AC0D469CF8D46C4E0EF52106A36077A0656958E0EF55A063DF9DEACCA2ABDBA335D600DBA9F0A4B636178C9E21EEA7B64A36F5E86091B040DB1CE';
    i(5) := 'A416D338655524D6841A5D37FF000A1FFD455850C06E686C77D1D958A09012EA02F08F1A8E4D797BAF571979BF09D803E66B5320AB48AAB963803A9A1977AE41192B09EF1BC472ACC6A47B417F2112CA047CC449955FD6870D3F54032B9F9D4393F48A4B';
    i(6) := 'E9A49AFE59CE646DBC072A609C78D678DB6B71E3009CF9D2675D519EE891536FE32B06904A3C69CB20F1ACC8BCD6154936EE71D40A60D63515DDAD9F03C8D1DBF0180E75A5A4EA696A4A10D46D4F351B52023484CD27760E09E5F0E744EC7474477623DB';
    i(7) := '00EFBE06738AA568BC3711CDCD51C7111D01E746EE6F22B6B70388271AE50F4DAAA096C526F48ABA96A969A7621247101C58E671F0F1AA4FDA18A3B569514A9DB3E3BE71E3E140755963BBBB49525E2915830C024EC796DD3DF4A96B031658662CA41564';
    i(8) := '6C865E2DC73F03CA9B9FC1288FD47B5F2DB81DDE2573B9076037C73ABFA7EB62EE352F1E24382DC3B9DFE5F2ACAB691713DF157C844D80181D73CAB4169A5359A02D2388F18381B8F8834BB32BA9A18F0CC48E58EB4917B3556D3822546825EF5399C9C1';
    i(9) := '19E791D6ADC4C8C5B87A1E5571764B458C03C3EEA5455E11B520E4BEEA747ECFC6A891D146A51B6A54862EECFA22961F65A9C87D5D3100FAD7A933BD7B3581A886A334F634C3D69302F6924012B01C4CAA763D7341B59BD796E58B0181B2273A2297A2D7';
    i(10) := '4DBA9387F0A291CF89B90FA134122EF1905CCC32EE7D13E18A272A860AE38F690C83449A7713C87849DFCE8B45A680E3BC3C6DECE4F3C799A4B59C95C0157637EA40C63C6B9D4ECE8714BD093E9F0B11E86F8F6B9D5730C683824C61B62576A231CE4A8C';
    i(11) := 'E36DB9D32548DC10C39D5B78C1096728CEDD8FB84D1C81BD51380C3903E144ACA4992E56451C514E012390C9EA0D2DDD8C73C0D10DB3C874CD47A3319ACDA23ED439F448E5C3B7D6AB8A4C8E58A5A0FA8D852C7B0F8D36160F1238EA338A7272F8D751CE';
    i(12) := '491726A54FECE922E6D4A9EC1A6201E37AF629B9DE96B9CD4F114C2295A999A00B96F0C72E93725972636E203C4F0E07E74366B76FB95B3630AA0E4F21CE8C696A1B4DBCDF2572787FC3B1FA566FB52CF0CB0DBF7A6182DE15E3C7E26DCD39AF0FDAA2B8';
    i(13) := 'DF9FF6C23692DB210BC684F87335782C2573B0FD6B9BBEA1696D70122697BCC839707193BD6ABB397F71A8ABA2F38BDA279561D1C7D1BF6EDEC3B1B5B21C49C200E64D48ED038CC4EA479500D5EE2042C27DC8E6A3F4A19A76A7A61BA284BC3267077FCF';
    i(14) := '7A2AD684F7766ACE78A99A7DB325C4E53D9719C7BCD2AE70003C58DC378E6A5B6668C81CB7CE7DDD29F12F22395DC4BB6A9DDC7C19CE09E5C8795489D7DF4D80E501F1269CBD7DF5D6B48E664B10F49ABD1FB2D5E8FDB6F75793D935420075A5CD373B9A';
    i(15) := '535CECD446E54CA7B62A3EB4022CE8F76CBA9AD9A8F55342DDE93D5B24AFF0D05D62DD350D4E5330668D589E11B648D864F955D82E60B6D66C647382A198FF0089BBBFA0A6DF4C23D4678D40C719C1F8D4CE550FD3358457658DC4193F672C27F5850F78';
    i(16) := '060396DFE945FB31671D95ACC918E6725CF33B62A2BA9D1620AAC10BFED78789A974CD42CD331249946042B673CBAE6B3ECDFB3571493C135E68D6B74E676525F6C8CE320552FEAAE9B2DC3DCB2BA4CFB96D88CF88A356F730BA8915C3467F69771F4A95';
    i(17) := 'B857D24E4798AA4F043D94EDE0EE235873C4B18C063D4530C8EC244887AC0D95CEC370399A9E6938467C6AACAAE21EF01E0E39151BC873A852A6E86E3749FB614D3EE229A1C2307689B8242397175C55853BB0F3AA3A35A8B6B77EA6599DC9F79DAAE03E';
    i(18) := '9B0AEC836E116F7472F224A724B49922B62423C45393D96A8C1F59EF14F4E46AC833F9049C10690CB12F3751EF602B9B99DB2C38C8C9DF73E351B4A08C1DCD65D0BEC7496B9B61CE68FF00797F9D33BF83A489FBC2B9BF783AED9FF9A5E303AE71D3FDF9';
    i(19) := 'D1D3F21D8DD6A72C620EF51E32E08518C160325BE46BDAAB96D4D9872238C9F7E2B0EB3BA86EEC940460F0F515BCB98809125971BC08CD8F101723E7513878BFE1AC392DAFAACADA8AE2C89CFA6E3047509FA9A09A77791CA2DD5B2B3B7060E36F134977';
    i(20) := '717935CB90155338532677F3AB5A6DAEA8A43412D9E49C8673B839E9B564960DBC99AAD22D60B6B6781482B273D82A83FDDC72AB28CEB989CE5936CF88E8684A2EB2A8415B699B1906272873E182B8A256EED3431CCFB3F0F0BAF518A4C594F3EC7CBBA6';
    i(21) := '4FC29C908923591D4B2A9E244F127A9A8E670A8491B01922B0F75DAED4A5B396D158223B11DE8CF1F067D918E5E19A708393265351DB3A3BDDDB5959ACD7522C31AF36638DCF878D66EFFB7D670BB7DCE069CF20EE7817E5CEB052DE4AE305D8E3C4E7F3';
    i(22) := 'AACF2B3733BD76691C976ECDAAFDA0EA6D3822DA1E1E5C3E979733C5D7956A7B39DA4B5D6E291554C1770FF6D6EC7240FC4A7AAD729B32E093CF20EDB7BF3F0C7D28B767AF5ED7B556732E51669442EBCBD171DD918DBAE284C006EE788FBCD34BF88A57';
    i(23) := 'D98FBCD3581EB4804E3F7D7B8CE2931B57B18A009AD834B71145CBBC754FDE2056D92EFEF4B716FCBB9909561CFBB76FF423EB403B1DA4FF0048EAC24907FD3DA0EFA527916E51AFC5BF2AB305D9B1D4668AEC70E43C4EDD373B1FF5ACF92F1F1DD9B712';
    i(24) := '552FB8A0D5DE946E1477785C6092D9C63EB56ADB4431A8512C6CBCF707355A3BD7781042C1BA646F91E5562DB519B0015E59F98E958CA2D68D632C642D6D68D17A200C1E646F4E9156397854FB5BE292DAEF8E30DC97A93542E6F95262788176D9533923';
    i(25) := 'CE8EB4856DBA22ED05F7DDF4FB871EDF76D8F2C8C0FCEB99C921E1553BEF9AE9375A15DEA7613F7A4C31B2973236C4F08E201779F4EB5CC1DB2C0F956DC516936D55B32E66AD24EE90FC9C578649F752676A55E75A1897ED98C68CF9C708246FBE790FAF';
    i(26) := 'E95369619F5ED3D4678BEF3080080B8F497A0C81502FA3110C41CE063AFC3E03F21E344FB1B6E6E3B5764A3D2489DA638181845241C74DF1401A68BECAC193371A8FA39C911C401F9B31FCA8A43F671D9A89712A4D70DF89E423E9185AD412739A50734E';
    i(27) := '8A31B79F66BA0C9BDBC9716DE418483FCE33F5A1D75F66F6283D55E4E3CD915BE8386BA195CD67FB41AC5EDB2B5AE8F6AD757C7632953DCC39EAEDC99BFBA3E345060ADA669BA3F6574B31CF7186B96EF19E5C71B9C602AA28E238AC5F68750B2BCBCEF6';
    i(28) := 'D15959766EFD781241E5D411E74FB6B2B86B996FB51B937370DB493925863AA29FE550EAB2D93C2D146849E8D8A9924F1B1C64D6B03ACED75065E34B66891B054F1AF09F318CD16B55BD2EB10396F02C5BF9505ECD6AAD0CFF00D1F3E4DB487D5B9E51B7';
    i(29) := 'FF0026B75636622264E1DFA50B8D21BE46C4B7D325740B752B153FB2A787F8688D9D85A407D4C2A87AB637F9F3A582DA57391F5ABD0C0CBCC6F5692F4896DFD21BF5FF00B7DC8EBDCC9FC26B830DEBE829A3E38991B9302A7E3B5712D63B35AC68D70F1D';
    i(30) := 'DDB3F74A7D0B8505A2607961C0C7C28648300A9A3504EFCBFDFF00BFF8A6AC6E7F64FCAA68E27E8BF31450136400BCD82FA5C3B74CE31CFC76FD456AFECC6CCC9A8DEDF30C8862112B1FC521E26FA2D646657008C631C86373E39F9EFF002E95D3BECFF4';
    i(31) := 'E365A046EE3125DB19DBC707D14FF28A407FFFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  11
       , 'Bernard Jackman'
       , 'bernie'
       , 'bernard.jackman@email.com'
       , 'I am a great believer in the fact there is no "i" in TEAM.'
       , 'team_member_11.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    -- Load Team Member 12
    i := j;
    i(1) := 'FFD8FFE000104A46494600010100000100010000FFDB0084000C08080809080C09090C110B0A0B11150F0C0C0F15181313151313181712141414141217171B1C1E1C1B1724242727242435333333353B3B3B3B3B3B3B3B3B3B010D0B0B0D0E0D100E0E10';
    i(2) := '140E0F0E141410111110141D14141514141D251A171717171A2520231E1E1E232028282525282832323032323B3B3B3B3B3B3B3B3B3BFFC00011080080008003012200021101031101FFC4008C0000010501010000000000000000000000050002030406';
    i(3) := '01071000020103030204050204050500000000010203000411051221314106132251143261718123914252A1D1336282B1C124437292E1010003010101000000000000000000000000020301040511000202000601040203000000000000000001021103';
    i(4) := '12213141510413226171429181A1C1FFDA000C03010002110311003F00F4C906086A89FDEAC30CAE2A16195FB506A20BB5DF6E71D46686432EF8C73EA1C1145F1BA365A01223ACF228E306925C1A896E9FD21077E6A389F1DEB8B1B39CB734E4F2C1C938';
    i(5) := '00E327DE919A895739C8C9A64D1CDF15130076AB0CFE6A482E2D55F707DC54F4FAD4925F990670AA53920F6FB7DE8CCBB372BE8B762A7E318F6087FDE89567A2D60C12B4AA9E6C7260103AAFE6AE41AEC37120445C0DFB4B139E338AAC649EC2CA2D6E15';
    i(6) := 'A55041796F3BBA44E19E23871DC54D5A29DA54A9500707071513839A949C1149C71401DA8CAF352D35FB1A00882D08B88C0BB6CF19C5196E0D0BBE65F3095E4E3FDA927A21A3B95DA48E3CE78C7BD67F57D46340DB080D9C9008E4549AB5DCD1C6431E0E';
    i(7) := '7F1590D42E965C7661C13EFF005A9A4E4574885AD7C482271BD46C2C71EC0D5CBAF114623F321DB8E9264E0F4F49158DDCA23C364E79C542D2480FF97B56FA4AC33B35ABE2771179301246E258B003239E33F4A1F71A8BC444F6D336490CD9E39CE791DE';
    i(8) := '8089C8E471DAA659464338CE3A532856A8572BDCD7E8BE2D961959DC65E4237B038EBD4B7BD6F34DD6AD2FC058D879873C020F4AF1469B0095E828B683ACCB672968F196F4E4F38FB535B5B8B953D8F66AED0DD0F518EF6C6260D99146D704E4E477A234';
    i(9) := 'C9D8822334ABB485002AE1E95DA6B8C8A008A724AFA3E6A0BA9CA3CB63228DC01E41F6157F509668D7F4B918F50C73F8AC8EB1AA048D9655241E036EC102A588F82B86B9333AAEB32B4CE80E4741FBD54B0D36EF5594AC2A485E59BB0AAB74C5E462A0E0';
    i(10) := '9E09EF5E9BA0E95169FA5450A8FD475DF2BF7248CD6D52A41BBD763212787553E76CB01CD529F4950719AD8EA117522825D2F3C8A867927B9D6A116B64679F4BFE5E0D30E9F70A870A5A8EA440B0A256F6F116000C922B7D5921258313052C840319183D';
    i(11) := 'E9F0484631C11D28CF8A34D48409D46D6271C504894E3918C77ABC64A51B39A51CB2A3D17C017D2B4DF0EFEA420B06CE31F73ED5BF15E43E13D452DAE76CC1CC4E307676E41FF8AF55D3E7866B6530E422F183FDEB63D0B3DECB54A952A61455C63815DA';
    i(12) := '6BFCA6802ACE88E0871902B23E21481A376C1057E5F63F7AD8AFA9B06B37AE58C72C721CAEFC92B93939FA8A8E2F0CAE17279EBA179977F765CE7B02715EA850470281D940FE95E597DFF4D2AA39FD66E76F3CE0E3FDC56D2EFC4EDE447F036B34EC5402';
    i(13) := '5D4A007F6269F80E6892F6542C57A505B93926AADC6BF77E6EEBBB46857DF07FB526D5AC0A643E4B741839CFDAB9E5095EC75C271ADFF67577678ABDA6976B80A7BF4FC567E6BFD464602DA27C1E41DB91FB9E2A6B1D435A826591EDDA6507951B41FC73';
    i(14) := '5BE9BED7EC57889F0FEE825E318775BC7C746EB593D840C8E4FB568F52D49F58963B086DE586E98F0B2E00E84F247DAB3F708F1B98E45F5AB61B1D38AAE1A695339E6ED843414737F0A2BAAB48C0296E809F7E0D7B0E9A245B55494A965EEB8231F80057';
    i(15) := '947856DE33A9C0673B630D93819CD7AD59AC6B1663E14F4E7B76A68EEC49F058A54A953882A6499C714FA6BFCB40114609249ED426FA2DD23BA8CF07F87A1CF7A319DB1B37D284191B21981C39E47BD2622B43C254ECC96A7A2B49ADE9D13B836F70C51F';
    i(16) := '0A0306C963EAC67041E28ADF406DA336D02E577A8695D802A01EC3A9AB7ACD8B5D247E548D0BC53218A54C655F2023107A81CD09F120D506D5996DE665382D1974CFD76B06C7EF53AD35E0B47755F95B74069AEAE44DE590C12400A230C919EA73FCB40A';
    i(17) := '4B23E47C61188BCC668D47740719AD0596977FA8C8624C4509216690649087A8CF62454DA9DA869440802C318D9181D028E05666AD57253266F6BB79573F20BBDB96987E936D898ABC2A47001EA09F63DAA4B5925888732271C85C1249F618E2A8B5A5ED';
    i(18) := 'BB7E9B0F273B5370C819ED9157A187513B63DF120CF5D85BAFFAA86D715A828BAD6F40A58593EA1E21B69C66216B6FE6C8ABD198B1540DF4E4D52BEB45175E42FA6EE55790EE1C33EE3E95FBE2B59E1ED3BE0E392692569E7B8DBBE470070A30A8AABC05';
    i(19) := '19A0F242BAA6B2E546F8ED4FE973B71286FA7247A6B1BD8582599B655F0ED9B0B88A2DA18BF42067031D71F9AF48B68041108C12D8EE7AD0ED2B4AB68C094A7A8105474E7DE8BD5B0E35ABE4E7C4926F4D854A952A71054C734E2714D1C9A0082F6431DB';
    i(20) := '311D718FDE87E0B46A08AB7A93FCB1FB9C9FC557C12005A591A862AC6F8494164C8FE8723F6A13E225F5838C924E07D68B7953EEE14FED506A768F240599487C12B91CF4A8CE3ED68BE0CEA6ACCA41AAC16D1C91F9C56390E5C26776471C1C550BDF1189';
    i(21) := '15E3446DC0EDDC38623F9BA55DD1EDF55B5B591C6D92CD49F322C289327BABE33564CDA04872E6747C1DC3673C74F528A5A54B4CDFC9D55276DBAFA8D99C3AC8963114D9D8A77608E723DCD13B29E39CA18DB774E299753ABA325840C49EAF3052071CF1';
    i(22) := 'CD73C3F62639CB30F94E73D064D124AAF6F816E49B4F55DB546E6CC858D53D80EBEF5774CD06CAC3128F5CED92D27D4F27140A6BD16F6373724FF851B3FF00EA3354F50D59DF4B32063E5BC4AC003C8DC38E9EC6AB8294AFE0E4C66E2EBB376060002BB5';
    i(23) := '89D1BC5CABA646D34F89117D608DDF2F07AD72CBC757B7D7170B1A2470C28591B196247BD5F2B2366DEB8C70A4D07D13C496DA9DB6F7C47321C4807201F7A2EC432654E41EE2959A84F5C4EE69C466A26BAB68DC46641BFB81CE31EFED4014AE21633497';
    i(24) := '13FA2DE15C973EC3938ACB0D66E758D5174EB4B816509279048381CF2472C6ADF8BBC42935BB59599CA7FDD907723F8456374C9BE17508A7233B7713F5F4914D155F6FFA069B3D06D6E23DD2C96C5BC98066E2F1F991F1FC31FB6686695AECB35D6A53DD';
    i(25) := 'B6E8C491AAC7D955996318FB03402E75CBAB889A356F2E1639F2D385A658D86A13497B14313959E20F1CA46D8F7020E0BB617B512A699B18D51B06896D5E54C7E9484F3DB359AD42748A7F23E1F927E7078C7ED46E6BDB58E15F88B8569D9479D0C5FA80';
    i(26) := '3639C3F0B412E278EE64DBBF613D24619FB020570C953D36EBA3D2C29B4ADDA7DF646D34691945032C3E51D6A7B17548307873CB2F719AA17969756D189616F383B6CDD8C6382411827DAADC2A23801CFA88F51F73471BD8B26E52DB425BFB863A3EA1BB';
    i(27) := 'A7C3C800FBAD67DAF49F0F5BE4F3E52C67FD2C6ACEBF7E20D2A6841F5CE3601F43D684DE0F2F4CB1B61F338C91F9CFFCD7478A9D49F67279559A28884EC96EB083FE21DEFF006EC2ADE9D72F6E2461D1B87EFC50E5219D9FA81C2FD87156603E920F735D';
    i(28) := '04033A4EA46D2E5A643B436720F008F6AD1699E2478D8867CAE73F6AC623050475ED4EF33D4A0707B9A0C68F4FD52F049A5CF756D3348832F83E929C81B48F6AC8DC6A173244803968F9214703279ABD7F79E419217C9B7986D940FA746FC50892DFCBB6';
    i(29) := '6C10CAAE0A30E855875AD94696810D5EA5794EF560D9C91D68786659918F2030FEB5755C8241FB543247BD4638CF0290ABD82BE18B48A6D465927C186CA3795C30C8C8E138EFC9CD49717B14B293309A519E374B8FE81689F8534E3269778EDE937722C7';
    i(30) := 'BFFCB12F3FD5A856AF05B4374F142A7647C724927EA6B9BC86ED7474F8ED53EFFC2098C121F4218D7EAE4FF6A87C8B7CE73CFF00E47FBD4423B7CE78FC9FFED744168E707613F7A896B082C8D6B1C1363CCB5998C7321390187231ED91D299A9B1B47DB9';
    i(31) := 'CA30DF1B7BA9E86ADD8C51ADAFC2BA80B74AE1549C8DE9828C33D39ACBEADAC49791C302A05F2772A8072C4B11FDA9A31BD0CB4AD94AEE492FEF52207233934FD525DD7BB47CB6D1851F72314D884D67776D1C637CD21DF7000C9C7F2FE055766323339E';
    i(32) := 'B2B96FC0E95D9871CB1A3831659A563E0004407B55A8F85E3DEA0897D247D6AC2F0BF6F6A7429301CF5C52895A49D5179624018F73C5461BA9F6A7C570F6B878C0F39F3B58F3B4742C07BFB56D18CFFFD9';
    l_blob := varchar2_to_blob(i);

    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  12
       , 'Harold Youngblood'
       , 'harry'
       , 'harold.youngblood@email.com'
       , 'Providing I have my soy latte, falafel, and my MacBook - Bring It!'
       , 'team_member_12.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );

    --------------------------------------------------
    --<< Load person running the script as a user >>--
    --------------------------------------------------
    -- Determine if the username contains a '@' indicating an email address format
    if instr(nvl(wwv_flow.g_user, user), '@') > 0 then
      l_full_name := substr(nvl(wwv_flow.g_user, user), 1, instr(nvl(wwv_flow.g_user, user), '@') - 1);
      l_email := nvl(wwv_flow.g_user, user);
    else
      l_full_name := nvl(wwv_flow.g_user, user);
      l_email := null;
    end if;
    l_full_name := initcap(replace(replace(l_full_name, '_', ' '), '.', ' '));

    -- Load the default image for this person
    i := j;
    i(1) := '89504E470D0A1A0A0000000D4948445200000080000000800800000000E6553E170000047C494441547801EDDB09A7F34E1B80F1E7FB7F9A2B2346082118CB38861027448C2AB154A9200891FB59FFCF7EB2BD337DB773D96BFB35E936F7AD1FAEFFE63E';
    i(2) := '5CFECD7DB85EFEAD5DDF01E701EF8077C03BE01DF00EF08D33B956289D1BD7F827037C5526FC5C5256FE7980CE2A409BFA7A7B0C8FDBB5361A50B67B0EC0DB04747D5BE447CBADD69058FF04409D42719DE5F7E66B01691D1BE00D649745FED672C9C0F8';
    i(3) := 'A8802E0337CB5BCD0EB22E22A04D497B59AB4F49DB688056910DB2DE90A1DA488056514CB2D554A0DA2800AFC927D96ECAD13E02C017E851F6346A0A1F1E6049EEB2AF7B820D0E68C1CBDE3CB481013EC7C8FE0CB90F0B70A851F6372A5C508057B472A4';
    i(4) := '16E543021C7A9623CD1A1710E0155E8EE5513E1CA046CF72AC59538703E4D472B49A3C18A083518E3642170AE028E578252E1420A795E3B5E481001E0639DE003E0CA041CB99344D1880C3C8992C2E0CA0A49533B594610019BD9CA9270B038041CE3440';
    i(5) := '10808749CE34810F01E840CE055D08408B967369DA1080E63420A30903C8CE03FE276E410B722EC2003CCC72A6197C18C0F90FA220808B3EFD51ACFF47BE8C2C56CE64B1610035999C29A30E03F030CAF146F06100978C4E8EE7C92E81001623C733D850';
    i(6) := '80966492A34D096D28C025A391A335649760808A6C96632D192EE8F1FC2AC7BA063D9E5F2CF9C101458E0D3CA2F141E7132786547A92FD4D1A17784CA7B1B23F8BF6610197067AD95B0F4DF051AD410DB2AF4161220CAB73F249F634E5E43E3CE0D2A594';
    i(7) := 'B36C3797A45DAC8585D916CC26CAC2E24B8DA21865BDB140359738802F82EC2E6BDD335413736DA7499A45DE6A69127417777159427193BF772BA0F4B157B79502F337C2CD80AA9EB0BC6E018A6E949F1B7D01D05E9E0068C00014CEDF86699A869B7705';
    i(8) := '8081E619800AFDE85DC6AF65AE7FA454CF00BC500C8FC7A37FB585024015F6B5FFF4C850F0F20C80C12ED3F8F8D2FD76BBDD1F5F1AA7C5629E0128A945E49361181E5F1B86715A44A4A67C0620C7CBB7E6AFC9B73AF26700527AF97B3D697CC0DAC06400';
    i(9) := '1F1FD0BC3D329AA08D0FA8D0F2569A3A3EC052CA5B15BCC4071438792B47191DD025F4EB07C2C88072EDA03C6B4C64805D3F9F7450C50474253859693124D64702F8AA54E016596B2A41DB363CA0738502F455369A6B056853FB8080C6E600CA5E67D96E';
    i(10) := 'AC730055BA2E04C057467FFBC533CBDE86CE2400B96DF603562E3C45F390834DBDD300DA547E1DB079E18D1FE554CBBD2E0054F1D21E05F8DA7CF56F5FF8F5466F1440666ABF1FD09914A0A8EF8BFCEBCDB72A03D0C6EF04546AE5C29F6B68CB04D26A17';
    i(11) := 'C041E62709DDD469703B00359849623419927A13E035E52C719A4BB4DF0238D428B11A156E0B50E0245E8E620B90D24BBC7AD20D4007A3C46B846E1DD0C02CF19AA1590754688999A65A07BC504ACC4A5ED601062B31B3987540492531AB28D701399DC4';
    i(12) := 'AC235F07687A89598F5E0724DC256677921540D0CFA1954FA215C02BC922315B125ED7001599C42DA35A03584A895B895D0318ACC4CD62D60025B5C4ADA6FC15F0E61032529EFCB73FBFFF92A697B8F5E8EBCF7D042C723226C80BEC8A0000000049454E';
    i(13) := '44AE426082';
    l_blob := varchar2_to_blob(i);

    -- Insert into Demo_Team_Members
    insert into demo_team_members
      (  id
       , full_name
       , username
       , email
       , profile
       , photo_filename
       , photo_blob
       , photo_mimetype
       , photo_last_updated
      )
    values
      (  13
       , l_full_name
       , nvl(wwv_flow.g_user, user)
       , l_email
       , 'I''m the one who ran this data script to populate these demo tables.'
       , 'app_user.jpg'
       , l_blob
       , 'image/jpeg'
       , systimestamp
      );


    --*******************************************--
    --*** Load Projects, Milestones and Tasks ***--
    --*******************************************--
    -- Need to insert a project and all of its releated child records at once and then move to the next project

        -----------------------------------
    --<< Determine the data offset >>--
    -----------------------------------
    l_add_days := sysdate - to_date('20170101','YYYYMMDD');

    --------------------------
    --<< Insert Project 1 >>--
    --------------------------
    insert into demo_projects
      (  id
       , name
       , description
       , project_lead
       , completed_date
       , status
      )
      values
      (  1
       , 'Configure Web Development Tool Environment'
       , 'Determine the hardware and software required to develop with Web development tool.'
       , 13
       , to_date('20161205', 'YYYYMMDD') + l_add_days
       , 'Completed'
      );

    -- Insert Tasks for Project 1
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  51
       , 1
       , 13
       , 'Identify Server Requirements'
       , 'Determine which databases will be used to install Web development tool for Development, QA, and Production.
          Also specify which Web Listeners will be used for the three environments.'
       , null
       , 'Y'
       , to_date('20161201', 'YYYYMMDD') + l_add_days
       , to_date('20161202', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  52
       , 1
       , 5
       , 'Install Web development tool'
       , 'Install the latest version of Web development tool from the vendor into the databases for Development, QA, and Production.
          Note: For QA and Production, Web development tool should be configured as "run time" only.'
       , null
       , 'Y'
       , to_date('20161203', 'YYYYMMDD') + l_add_days
       , to_date('20161203', 'YYYYMMDD') + l_add_days
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  1
       , 1
       , 52
       , 13
       , 'Download tool from vendor'
       , 'Download the latest available version of the Web development tool from the vendor site.'
       , 'Y'
      );

    insert into demo_links
      (  id
       , project_id
       , task_id
       , link_type
       , url
       , application_id
       , application_page
       , description
      )
    values
      (  1
       , 1
       , 52
       , 'URL'
       , 'http://Web-tool.download.com'
       , null
       , null
       , 'Ficticous download page for Web development tool'
      );

    insert into demo_links
      (  id
       , project_id
       , task_id
       , link_type
       , url
       , application_id
       , application_page
       , description
      )
    values
      (  2
       , 1
       , 52
       , 'URL'
       , 'http://Web-tool.install.com'
       , null
       , null
       , 'Ficticous installation guide for Web development tool'
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  53
       , 1
       , 12
       , 'Configure Web Listeners'
       , 'Configure the three Web Listeners for Web development tool to support the Dev, QA, and Prod environments.'
       , null
       , 'Y'
       , to_date('20161203', 'YYYYMMDD') + l_add_days
       , to_date('20161203', 'YYYYMMDD') + l_add_days
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  2
       , 1
       , 53
       , 12
       , 'Download Web Listener from vendor'
       , 'Download the latest available version of the Web Listener from the vendor site.'
       , 'Y'
      );

    insert into demo_links
      (  id
       , project_id
       , task_id
       , link_type
       , url
       , application_id
       , application_page
       , description
      )
    values
      (  3
       , 1
       , 53
       , 'URL'
       , 'http://Web-Listener.download.com'
       , null
       , null
       , 'Ficticous download page for Web Listener'
      );

    insert into demo_links
      (  id
       , project_id
       , task_id
       , link_type
       , url
       , application_id
       , application_page
       , description
      )
    values
      (  4
       , 1
       , 53
       , 'URL'
       , 'http://Web-Listener.install.com'
       , null
       , null
       , 'Ficticous installation guide for Web Listener'
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  54
       , 1
       , 11
       , 'Configure Web development tool Instance Administration Settings'
       , 'Set the appropriate security and configuration settings for the development instance using specified tools.
          Also set instance settings for QA and Production using the available APIs.'
       , null
       , 'Y'
       , to_date('20161204', 'YYYYMMDD') + l_add_days
       , to_date('20161204', 'YYYYMMDD') + l_add_days
      );

    insert into demo_links
      (  id
       , project_id
       , task_id
       , link_type
       , url
       , application_id
       , application_page
       , description
      )
    values
      (  6
       , 1
       , 54
       , 'URL'
       , 'https://Web-tool.admin.com'
       , null
       , null
       , 'Ficticous administration guide for Web development tool'
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  55
       , 1
       , 5
       , 'Define Workspaces'
       , 'Define workspaces needed for different application development teams.
          It is important that access be granted to the necessary schemas and/or new schemas created as appropriate.
          Then export these workspaces and import them into QA and Production environments.'
       , null
       , 'Y'
       , to_date('20161205', 'YYYYMMDD') + l_add_days
       , to_date('20161205', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  56
       , 1
       , 12
       , 'Assign Workspace Administrators'
       , 'In development assign a minimum of two Workspace administators to each workspace.
          These administrators will then be responsible for maintaining developer access within their own workspaces.'
       , null
       , 'N'
       , to_date('20161205', 'YYYYMMDD') + l_add_days
       , to_date('20161205', 'YYYYMMDD') + l_add_days
      );


    --------------------------
    --<< Insert Project 2 >>--
    --------------------------
    insert into demo_projects
      (  id
       , name
       , description
       , project_lead
       , completed_date
       , status
      )
      values
      (  2
       , 'Train Developers on Web development tool'
       , 'Ensure all developers who will be developing with the new tool get the appropriate training.'
       , 1
       , to_date('20161220', 'YYYYMMDD') + l_add_days
       , 'Completed'
      );

    -- Insert Milestone 1 for Project 2
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  11
       , 2
       , 'Train the Trainers'
       , 'Rather than all developers being trained centrally, a select group will be trained.
          These people will then be responsible for training other developers in their group.'
       , to_date('20161211', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 2 / Milestone 1
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  57
       , 2
       , 6
       , 'Prepare Course Outline'
       , 'Creation of the training syllabus'
       , 11
       , 'Y'
       , to_date('20161201', 'YYYYMMDD') + l_add_days
       , to_date('20161205', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  58
       , 2
       , 6
       , 'Write Training Guide'
       , 'Produce the powerpoint deck (with notes) for the training instructor.'
       , 11
       , 'N'
       , to_date('20161206', 'YYYYMMDD') + l_add_days
       , to_date('20161208', 'YYYYMMDD') + l_add_days
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  4
       , 2
       , 58
       , 6
       , 'Review the online examples hosted by the vendor'
       , 'Run through the numerous examples available from the vendor to get course content.'
       , 'Y'
      );

    insert into demo_links
      (  id
       , project_id
       , task_id
       , link_type
       , url
       , application_id
       , application_page
       , description
      )
    values
      (  7
       , 2
       , 58
       , 'URL'
       , 'https://Web-tool.examples.com'
       , null
       , null
       , 'Ficticous examples page for Web development tool'
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  59
       , 2
       , 6
       , 'Develop Training Exercises'
       , 'Create scripts for sample data and problem statements with solutions.'
       , 11
       , 'Y'
       , to_date('20161202', 'YYYYMMDD') + l_add_days
       , to_date('20161208', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  60
       , 2
       , 13
       , 'Conduct Train-the-Trainer session'
       , 'Give the training material to the selected developers.'
       , 11
       , 'Y'
       , to_date('20161209', 'YYYYMMDD') + l_add_days
       , to_date('20161211', 'YYYYMMDD') + l_add_days
      );

    -- Insert Milestone 2 for Project 2
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  12
       , 2
       , 'All Developers Trained'
       , 'Train the Trainers will have successfully trained the remaining development team members.'
       , to_date('20161215', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 2 / Milestone 2
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  61
       , 2
       , 7
       , 'Train Developers I'
       , 'Give the training to developers within your group.'
       , 12
       , 'Y'
       , to_date('20161212', 'YYYYMMDD') + l_add_days
       , to_date('20161214', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  62
       , 2
       , 8
       , 'Train Developers II'
       , 'Give the training to developers within your group.'
       , 12
       , 'Y'
       , to_date('20161214', 'YYYYMMDD') + l_add_days
       , to_date('20161216', 'YYYYMMDD') + l_add_days
      );


    --------------------------
    --<< Insert Project 3 >>--
    --------------------------
    insert into demo_projects
      (  id
       , name
       , description
       , project_lead
       , completed_date
       , status
      )
      values
      (  3
       , 'Migrate Legacy Applications'
       , 'Move the data and redevelop the applications currently running on top of legacy servers'
       , 10
       , null
       , 'In-Progress'
      );

    -- Insert Milestone 1 for Project 3
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  13
       , 3
       , 'Move Data Structures'
       , 'Move all of the tables and program logic across to the new database'
       , to_date('20161220', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 3 / Milestone 1
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  63
       , 3
       , 3
       , 'Create New Tables'
       , 'Create table scripts to replicate the legacy tables'
       , 13
       , 'Y'
       , to_date('20161214', 'YYYYMMDD') + l_add_days
       , to_date('20161214', 'YYYYMMDD') + l_add_days
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  5
       , 3
       , 63
       , 3
       , 'Reverse engineer the legacy tables into the data modeling tool'
       , 'Connect the data modeling tool to the legacy dev instance and suck in all of the required DB objects.'
       , 'Y'
      );

    insert into demo_links
      (  id
       , project_id
       , task_id
       , link_type
       , url
       , application_id
       , application_page
       , description
      )
    values
      (  8
       , 3
       , 63
       , 'URL'
       , 'http://Web-data-modeler.info.com'
       , null
       , null
       , 'Ficticous information site for the data mdoeling tool'
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  6
       , 3
       , 63
       , 3
       , 'Add proper integrity constraints to the entities'
       , 'Add foreign keys as needed to correctly integrate referential integrity.'
       , 'Y'
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  7
       , 3
       , 63
       , 3
       , 'Generate DDL Scripts for new tables'
       , 'Generate the DDL scripts from the data modeling tool to create the DB objects in the new database.'
       , 'Y'
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  64
       , 3
       , 2
       , 'Migrate data from Legacy Server'
       , 'Develop scripts to populate the new database tables from the legacy database.'
       , 13
       , 'Y'
       , to_date('20161215', 'YYYYMMDD') + l_add_days
       , to_date('20161218', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  65
       , 3
       , 3
       , 'Convert transaction logic'
       , 'Convert the legacy database transactional objects across to the new database'
       , 13
       , 'Y'
       , to_date('20161215', 'YYYYMMDD') + l_add_days
       , to_date('20161217', 'YYYYMMDD') + l_add_days
      );

    -- Insert Milestone 2 for Project 3
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  14
       , 3
       , 'Redevelop HR Applications'
       , 'Build applications to replace the HR functionality currently implemented in older technologies'
       , to_date('20161228', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 3 / Milestone 2
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  66
       , 3
       , 4
       , 'Redevelop Timesheet App'
       , 'Develop desktop and mobile app for entering timesheets'
       , 14
       , 'Y'
       , to_date('20161217', 'YYYYMMDD') + l_add_days
       , to_date('20161222', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  67
       , 3
       , 8
       , 'Create Shift Schedule App'
       , 'Create an app for defining when people are scheduled to work different shifts.'
       , 14
       , 'Y'
       , to_date('20161217', 'YYYYMMDD') + l_add_days
       , to_date('20161225', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  68
       , 3
       , 8
       , 'Reengineer Employee App'
       , 'Create an app for employee details and benefits.'
       , 14
       , 'N'
       , to_date('20161226', 'YYYYMMDD') + l_add_days
       , to_date('20161228', 'YYYYMMDD') + l_add_days
      );

    -- Insert Milestone 3 for Project 3
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  15
       , 3
       , 'Redevelop Project Tracking Applications'
       , 'Build applications to replace the project tracking functionality currently running on legacy servers'
       , to_date('20170103', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 3 / Milestone 3
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  69
       , 3
       , 9
       , 'Customize Customer Tracker Packaged App'
       , 'Install Customer Tracker and use flex fields to meet requirements.'
       , 15
       , 'Y'
       , to_date('20161228', 'YYYYMMDD') + l_add_days
       , to_date('20161228', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  70
       , 3
       , 9
       , 'Migrate data into Customer Tracker tables'
       , 'Move previous project tracking data into the Customer Tracker EBA_CUST_xxx tables.'
       , 15
       , 'Y'
       , to_date('20161229', 'YYYYMMDD') + l_add_days
       , to_date('20161230', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  71
       , 3
       , 11
       , 'Pilot new Customer Tracker application'
       , 'Use Customer Tracker to ensure it meets requirements.'
       , 15
       , 'N'
       , to_date('20161231', 'YYYYMMDD') + l_add_days
       , to_date('20170109', 'YYYYMMDD') + l_add_days
      );



    --------------------------
    --<< Insert Project 4 >>--
    --------------------------
    insert into demo_projects
      (  id
       , name
       , description
       , project_lead
       , completed_date
       , status
      )
      values
      (  4
       , 'Develop Partner Portal POC'
       , 'Develop a proof of concept that partners can use to work more collaboratively with us.'
       , 13
       , null
       , 'In-Progress'
      );

    -- Insert Milestone 1 for Project 4
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  16
       , 4
       , 'Define Requirements'
       , 'Work with key stakeholders to define the scope of the project, and design screen flow and data requirements.'
       , to_date('20170106', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 4 / Milestone 1
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  72
       , 4
       , 13
       , 'Define scope of Partner Portal App.'
       , 'Meet with internal and external SMEs and define the requirements'
       , 16
       , 'N'
       , to_date('20161228', 'YYYYMMDD') + l_add_days
       , to_date('20170104', 'YYYYMMDD') + l_add_days
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  8
       , 4
       , 72
       , 13
       , 'Meet key Partners for input'
       , 'Determine the most important functionality for Partners.'
       , 'Y'
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  9
       , 4
       , 72
       , 13
       , 'Meet internal Partner liason reps'
       , 'Determine the most important functionality for internal stakeholders.'
       , 'Y'
      );

    insert into demo_to_dos
      (  id
       , project_id
       , task_id
       , assignee
       , name
       , description
       , is_complete_yn
      )
    values
      (  10
       , 4
       , 72
       , 13
       , 'Develop inital screen designs'
       , 'Prototype new screens using Web development tool to get buy-in from SMEs.'
       , 'Y'
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  73
       , 4
       , 8
       , 'Define Partner App Data Structures'
       , 'Design the data model for new and existing entities required to support the Partner Portal.'
       , 16
       , 'N'
       , to_date('20170104', 'YYYYMMDD') + l_add_days
       , to_date('20170107', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  74
       , 4
       , 6
       , 'Design User Experience'
       , 'Define how partners will interact with the application.'
       , 16
       , 'N'
       , to_date('20170105', 'YYYYMMDD') + l_add_days
       , to_date('20170106', 'YYYYMMDD') + l_add_days
      );


    -- Insert Milestone 2 for Project 4
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  17
       , 4
       , 'Build Proof-of-Concept'
       , 'Create the initial screens and populate with data so key stakeholders can review proposed solution.'
       , to_date('20170113', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 4 / Milestone 2
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  75
       , 4
       , 2
       , 'Develop Admin Screens for Partner Portal'
       , 'Develop the screens needed to maintain all of the base tables for the Partner Portal app.'
       , 17
       , 'N'
       , to_date('20170108', 'YYYYMMDD') + l_add_days
       , to_date('20170110', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  76
       , 4
       , 12
       , 'Populate Data Structures for Partner Portal'
       , 'Upload sample data provided by key partner, and ensure existing tables accessible.'
       , 17
       , 'N'
       , to_date('20170108', 'YYYYMMDD') + l_add_days
       , to_date('20170109', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  77
       , 4
       , 6
       , 'Design first-cut of main Partner Portal app'
       , 'Implement the major functional areas and ensure navigation between pages is working correctly.'
       , 17
       , 'N'
       , to_date('20170107', 'YYYYMMDD') + l_add_days
       , to_date('20170111', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  78
       , 4
       , 13
       , 'Present POC to Key Stakeholders'
       , 'Walk key stakeholders through the proof of concept and obtain their feedback.'
       , 17
       , 'N'
       , to_date('20170112', 'YYYYMMDD') + l_add_days
       , to_date('20170112', 'YYYYMMDD') + l_add_days
      );


    --------------------------
    --<< Insert Project 5 >>--
    --------------------------
    insert into demo_projects
      (  id
       , name
       , description
       , project_lead
       , completed_date
       , status
      )
      values
      (  5
       , 'Develop Production Partner Portal'
       , 'Develop the production app that partners can use to work more collaboratively with us.'
       , 1
       , null
       , 'Assigned'
      );

    -- Insert Milestone 1 for Project 5
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  18
       , 5
       , 'Define Production App Scope'
       , 'Based on the results of the POC, define the requirements for the production app.'
       , to_date('20170114', 'YYYYMMDD') + l_add_days
     );

    -- Insert Tasks for Project 5 / Milestone 1
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  79
       , 5
       , 13
       , 'Define production scope of Partner Portal App.'
       , 'Define the scope and timelines for the development of the production app.'
       , 18
       , 'N'
       , to_date('20170113', 'YYYYMMDD') + l_add_days
       , to_date('20170114', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  80
       , 5
       , 8
       , 'Finalize Partner App Data Model'
       , 'Refine the data model for new and existing entities required to support the Partner Portal.'
       , 18
       , 'N'
       , to_date('20170113', 'YYYYMMDD') + l_add_days
       , to_date('20170114', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  81
       , 5
       , 6
       , 'Finalize User Experience'
       , 'Write developer standards on UX and development standards on how partners will interact with the application.'
       , 18
       , 'N'
       , to_date('20170113', 'YYYYMMDD') + l_add_days
       , to_date('20170114', 'YYYYMMDD') + l_add_days
      );


    -- Insert Milestone 2 for Project 5
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  19
       , 5
       , 'Build Phase 1 of Production Partner Portal App'
       , 'Develop the modules defined in the first phase of the application.'
       , to_date('20170121', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 5 / Milestone 2
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  82
       , 5
       , 6
       , 'Refine Admin Screens for Partner Portal'
       , 'Refine screens developed in the POC to be fully operational to maintain all of the base tables for the Partner Portal app.'
       , 19
       , 'N'
       , to_date('20170115', 'YYYYMMDD') + l_add_days
       , to_date('20170118', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  83
       , 5
       , 5
       , 'Populate Data Structures for Production Partner Portal'
       , 'Upload actual data provided by key partner, and ensure existing tables accessible.'
       , 19
       , 'N'
       , to_date('20170115', 'YYYYMMDD') + l_add_days
       , to_date('20170117', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  84
       , 5
       , 7
       , 'Design production screens for main Partner Portal app'
       , 'Implement fully functional and complete screens to cover the major functional areas in Phase 1.'
       , 19
       , 'N'
       , to_date('20170117', 'YYYYMMDD') + l_add_days
       , to_date('20170123', 'YYYYMMDD') + l_add_days
      );

    -- Insert Milestone 3 for Project 5
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  20
       , 5
       , 'Perform Beta testing with select Partners'
       , 'Work with a few key partners to trial Phase 1 of the Partner Portal app.'
       , to_date('20170129', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 5 / Milestone 3
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  85
       , 5
       , 10
       , 'Train Partners'
       , 'Train selected partners in how to use the Partner Portal app.'
       , 20
       , 'N'
       , to_date('20170122', 'YYYYMMDD') + l_add_days
       , to_date('20170122', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  86
       , 5
       , 4
       , 'Monitor Partners'
       , 'Monitor partners selected for the Beta and provide assistance as necessary.'
       , 20
       , 'N'
       , to_date('20170123', 'YYYYMMDD') + l_add_days
       , to_date('20170128', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  87
       , 5
       , 13
       , 'Review Beta Feedback'
       , 'Analyse feedback from the partners who participated in the Beta program.'
       , 20
       , 'N'
       , to_date('20170129', 'YYYYMMDD') + l_add_days
       , to_date('20170129', 'YYYYMMDD') + l_add_days
      );

    -- Insert Milestone 4 for Project 5
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  21
       , 5
       , 'Complete Phase 1 Development of Partner Portal app'
       , 'Based on the results of the Beta program, enhance the application to make production ready.'
       , to_date('20170225', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 5 / Milestone 4
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  88
       , 5
       , 5
       , 'Improve existing feature functions'
       , 'Enhance existing features based on responses from Beta partners.'
       , 21
       , 'N'
       , to_date('20170201', 'YYYYMMDD') + l_add_days
       , to_date('20170220', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  89
       , 5
       , 3
       , 'Add required feature functions'
       , 'Add missing features outlined in responses from Beta partners.'
       , 21
       , 'N'
       , to_date('20170201', 'YYYYMMDD') + l_add_days
       , to_date('20170220', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  90
       , 5
       , 12
       , 'Load full production data'
       , 'Ensure all data required for production roll out are inserted and maintained.'
       , 11
       , 'N'
       , to_date('20170215', 'YYYYMMDD') + l_add_days
       , to_date('20170220', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  91
       , 5
       , 8
       , 'Test Production Partner Portal'
       , 'Do full scale testing on the Partner Portal application.'
       , 21
       , 'N'
       , to_date('20170221', 'YYYYMMDD') + l_add_days
       , to_date('20170225', 'YYYYMMDD') + l_add_days
      );

    -- Insert Milestone 5 for Project 5
    insert into demo_milestones
      (  id
       , project_id
       , name
       , description
       , due_date
      )
    values
      (  22
       , 5
       , 'Roll out Phase 1 of Partner Portal app'
       , 'Go-Live for the Partner Portal application to all partners.'
       , to_date('20170301', 'YYYYMMDD') + l_add_days
      );

    -- Insert Tasks for Project 5 / Milestone 5
    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  92
       , 5
       , 3
       , 'Install Partner Portal app onto Production Server'
       , 'Install the database objects and application(s) into the production environment.'
       , 22
       , 'N'
       , to_date('20170226', 'YYYYMMDD') + l_add_days
       , to_date('20170226', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  93
       , 5
       , 12
       , 'Configure production data load procedures'
       , 'Install and test data load procedures from internal and external data sources into production environment.'
       , 22
       , 'N'
       , to_date('20170227', 'YYYYMMDD') + l_add_days
       , to_date('20170228', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  94
       , 5
       , 13
       , 'Provide user credentials for partners'
       , 'Define user credentials for each partner to allow access to the Partner Portal app.'
       , 22
       , 'N'
       , to_date('20170228', 'YYYYMMDD') + l_add_days
       , to_date('20170228', 'YYYYMMDD') + l_add_days
      );

    insert into demo_tasks
      (  id
       , project_id
       , assignee
       , name
       , description
       , milestone_id
       , is_complete_yn
       , start_date
       , end_date
      )
    values
      (  95
       , 5
       , 1
       , 'Announce Partner Portal app to all partners'
       , 'Email or call partners to inform them of the new application and instructions on how to get started.'
       , 22
       , 'N'
       , to_date('20170301', 'YYYYMMDD') + l_add_days
       , to_date('20170301', 'YYYYMMDD') + l_add_days
      );

  end load_sample_data;

  procedure remove_sample_data is
  begin
    delete from demo_projects where id < 10;
      -- Cascade delete will delete Milestones, Tasks, To Dos, and Links records
    delete from demo_team_members where id < 15;
  end remove_sample_data;

end demo_projects_data_pkg;
/