'L PS_PERSONMODULE1DEFAULT&SMARTBARAMERICAN_AMERICA.WE8ISO8859P11 $ P0_27_DEC_200120_33_35a>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T1ͫͫͫͫͫͫͫ0D 22k &'&'&'GEGE $4!00 11 $ %P1_27_DEC_200120_33_35xͫͫͫͫͫͫͫw SYSSTANDARD /NSPC38/SET_UP_LISTSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T(ͫͫͫͫͫͫͫ0D ))!0 '$&'$/!d$dLps_phone_type_id rg_phone_type BB(B 8 1 $ P2_27_DEC_200120_33_35eVͫͫͫͫͫͫͫ /NSPC38/CLEAR_ALL_MASTER_DETAILS$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D T '$!88 nn n1 $ P30_19_JUN_200313_11_07aWͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08; ,"PKG INIT""MSGNUM"MSGTXT"MSGTYP""%()/23579  P   << ͫͫͫͫͫͫͫ0D ==W` H&' $,&'(($-(&'PP$.P<.d d  6.l l  .t t  .| |  .    b.(   G;<0 ;;H;&'&'GE$F!   Н֝םѝ՝ԝ-: w   0P(48(<<HPLP(dTl(lp(t(|((<Y    << $(, 0(408H@1 $ P31_19_JUN_200313_11_07Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08; ,"PKG INIT""MSGNUM"MSGTXT"MSGTYP""%()/23579  P   <[ ͫͫͫͫͫͫͫ0D \\ex) &' $G&'(($H(&'PP$IP<.d d  6.l l  .t t  .| |  .    .( 5 +&'&'0GE$FG; O k \`d(@1 $ (CHECK_PACKAGE_FAILUREWͫͫͫͫͫͫͫSQLFORMS w SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!"PKG INIT"CHECK_PACKAGE_FAILURE""T8ͫͫͫͫͫͫͫ0D 99  `&'$:   h!tP0CHECK_PACKAGE_FAILURE381 $ QUERY_MASTER_DETAILSͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 SQLFORMS /NSPC38/CHECK_PACKAGE_FAILURE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08K?"PKG INIT"QUERY_MASTER_DETAILS"REL_ID"ID"DETAIL"OLDMSG"RELDEF""#&(.17:;ADEGI     $8  ͫͫͫͫͫͫͫ0D *Lp &'&'%GILL $?L8$8T J&'%$;'$4&'$/$5&'&'&'%GIGI $ $jk!4l  &)*&)*QUERY_MASTER_DETAILSvFALSE105($lx(8|L `h? K [lu 41 $ _CLEAR_ALL_MASTER_DETAILSͫͫͫͫͫͫͫw SYSSTANDARD FORMS40 FORMS4C SQLFORMS /NSPC38/CHECK_PACKAGE_FAILURE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08DD"PKG INIT"CLEAR_ALL_MASTER_DETAILS"MASTBLK"COORDOP"TRIGBLK"STARTITM"FRMSTAT"CURBLK"CURREL"CURDTL"FIRST_CHANGED_BLOCK_BELOW"MASTER"RETBLK"" &)*034:=>DGHNQRX[\befntw} ?7 8  9:=;< = !>#" C &')*,@.- 0A21 4B65$8~%($  +/3ͫͫͫͫͫͫͫ0P Kx  $$88LL``(   ؄0 ,,#s,&'@$B@ y&'$;'$&'&'G E$``H8  (tt`   h&'&'G I<HH $4H&'\$B\  &'&'G Idd $@d&'&'G Ixx $4x`b W&'$;'$&'&'G E($tt`  h&'&'G I $@LL*  &'$F'$6LL! &'$Fjk! %&'&'G I<LL $4L$&'$`$B`  &'&'$G Ihh $@h&'&'G I|| $4|0! %# 8&'8$B 8%S7&'&'$G I $@$% hg!80`P0CLEAR_ALL_MASTER_DETAILS CLEAR_RECORDSYNCHRONIZE_BLOCKSCHANGEDQUERYNEWFIRST_CHANGED_BLOCK_BELOW((<(@h(l=(ظ(* ( *, T ,X \ *@` d Hh l *\p t dx | x  (($(8(L(`(tz ($((8,TLX\(``dhhl|ptx|((@A&B2C>DJJqNSTYZ[\ `DbOPmnop"q4r=sWtnusx~$)Z~!"'+<,M1~9:` t0H`VA_LOV#POPUPHINT#PersonRG_PHONE_TYPESelect id, id from ps_phone_type order by 1IDICRGGQ_0RG_ADDRESS_TYPEselect id from ps_address_type where id not in (select ps_address_type_id from ps_address where ps_person_id = :PS_PERSON.ID ) order by idIDRG_MEM_ORGSELECT ALL PS_ORGANIZATION.ID, PS_ORGANIZATION.NAME FROM PS_ORGANIZATION order by nameIDNAMERG_LOV_MEM_POSSELECT ALL PS_POSITION_TYPE.ID, PS_POSITION_TYPE.POSITION FROM PS_POSITION_TYPE order by 1IDPOSITIONRG_LOV_MAIL_TYPESELECT ALL PS_MAIL_TYPE.ID, PS_MAIL_TYPE.LIST_TYPE, PS_MAIL_TYPE.DESCRIPTION FROM PS_MAIL_TYPE order by 1IDLIST_TYPEDESCRIPTIONRG_ADDRESS_TYPE_MAIL_LISTSELECT ALL PS_ADDRESS.PS_ADDRESS_TYPE_ID FROM PS_ADDRESS where PS_ADDRESS.PS_PERSON_ID = :PS_PERSON.IDPS_ADDRESS_TYPE_IDRG_COUNTYSELECT ALL SY_COUNTY.ID, SY_COUNTY.NAME, SY_COUNTY.STATE, SY_COUNTY.COUNTY_NUMBER FROM SY_COUNTY order by IDIDNAMESTATECOUNTY_NUMBERLOV79SELECT PS_ORGANIZATION.NAME, PS_MEMBERSHIP.ID, PS_MEMBERSHIP.PS_POSITION_TYPE_ID FROM PS_ORGANIZATION, PS_MEMBERSHIP WHERE (PS_MEMBERSHIP.PS_ORGANIZATION_ID = PS_ORGANIZATION.ID) and PS_MEMBERSHIP.PS_PERSON_ID=:PS_PERSON.ID NAMEIDPS_POSITION_TYPE_IDSelect Main MembershipNamePs_Position_Type_IdIdPick Address TypeTypePick Address Type for MailingAddress TypePick Mailing ListIdList_TypeDescriptionPick PositionIdPositionPick OrganizationNameIdSelect COUNTY of RESIDENCEIdNameStateCounty_Number????= = = ?zzz??(((??@??????@??????@??????@??????@?????????333333?p=p=p=?GGG?QQQ?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?????(\(\(\?ffffff?ppp?zzz??@??????@??????@??????@??????@??????????\\\??ףףף??@??????@??????@??????@??????@??????????QQQ????@??????@??????@??????@??????@????????? ?GGG????@??????@??????@??????@??????@?????TahomaTahomaps_personps_personupper(last_name),upper(first_name),idMMP IDSEQ_ID.NEXTVALId1 $ ]P7_27_DEC_200120_33_35lͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""THͫͫͫͫͫͫͫ0D II!0 (H ' &'$k&'$1!$`TRUEmy_seqnum seq=EMPNO_SEQ $%<HH ,ACTIVEYESActive MemberYESNO1 $ .P12_27_DEC_200120_33_35Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D /H ld4   ` V P  @  ;0 8&'&'8GE$Fh  &' <$B<G  9  ;0 D&'&'DGE$Fh!YESNO-WHEN-VALIDATE-ITEM trigger failed on field - &(""Tͫͫͫͫͫͫͫ0D !0; l  &' ($B(,    00       &' DD$, D:  *&'&'GE$Fh  &' X$BXD  6&'&'GE$F&'$h! Alternate ID must be all CAPS Alternate ID is a REQUIRED field9(0DX `  ?W    D FIRST_NAMEFirstTahoma1 $ ^P21_19_JUN_200313_11_07Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Toͫͫͫͫͫͫͫ0D pp LD &'  $B D  6&'&'GE$F&'$h!`First name is a REQUIRED field DH (@?^jo MIDDLE_NAMEMiddleLAST_NAMELast1 $ ^P22_19_JUN_200313_11_07Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Toͫͫͫͫͫͫͫ0D pp TD &'  $B D  6&'&'GE$F&'$h!`LAST NAME is a REQUIRED field LP (H?^jo SUFFIXSuffixTahomaPhones1 $ P1_23_JAN_200218_39_29Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D r &'$;!@@0PS_PHONE   Addresses1 $ P14_27_DEC_200120_33_35Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D z &'$;!HH8V_PS_PERSON_ADDRESS   Memberships1 $ P16_27_DEC_200120_33_35Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D ~ &'$;!LL<V_PS_PERSON_MEMBERSHIP   Mailing Lists1 $ P15_27_DEC_200120_33_35Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  &'$;!PP@V_PS_PERSON_MAILING_LIST   Training1 $ P1_10_JUL_200314_52_23Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T&ͫͫͫͫͫͫͫ0D '' &'$;&'$/!LL4V_CL_TRANSCRIPT BB&B MAIN_MEMBERSHIPMain Membership1 $ P0_17_AUG_200416_15_08Yuͫͫͫͫͫͫͫw SYSSTANDARD xh !MFS PS_MEMBERSHIPSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    & ͫͫͫͫͫͫͫ0P 8 t &' 0$K0h `#[w`u y<  .&'&'G E$Fshs! r{t gdgdtgd !DD `@8@T,Membership ID not found in Membership Table. PRIMARY_CUR' TX\h0lp 8P = C W k@SELECT ''x'' FROM PS_MEMBERSHIP WHERE ID = :b1"\,1 $ P1_17_AUG_200416_15_08Iͫͫͫͫͫͫͫw SYSSTANDARD xh MFSPS_ORGANIZATIONxh !MFS PS_MEMBERSHIP$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D T"PKG INIT""""""$'(.069:<>@B  d  d4Pg  ͫͫͫͫͫͫͫ0D hh xq{t$4w4<4t4<<q{tXPwP PtP  !``@d<DdX@px: 4 "PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B     (& ͫͫͫͫͫͫͫ0P T x( &' <$B<h `#[w `(u  (y <  .&'&'G E$Fs hs ! r{t gd gd tgd !`` `@8@TDForeign key value does not currently exist in the primary key table. PRIMARY_CUR) X\(`l"LIST_ID"ID""#&(*    ͫͫͫͫͫͫͫ0D   8d} &',$,&'<$J<%  &'$&'D$D&'T&'4GE T$&'&'&'LG E$G E, $u&'$!4$4 &)*&)* cert_listP_PS_IDCT_CERTIFICATE_ISSUE4,<DTh6`q      x 4L1 $ BP14_19_JUN_200313_11_07vͫͫͫͫͫͫͫ w SYSSTANDARD xh 'MFS RS_COMMENTSQLFORMS xh ,#MFSCT_CERTIFICATExh  9MFS PS_ADDRESSxh !MFSPS_MAILING_LISTxh &MFSPS_PHONExh 'MFS CL_INSTRUCTORxh MFS CL_ENROLLMENTxh !MFS PS_MEMBERSHIPxh (%MFSRS_RESERVATIONxh ( MFSRS_LOAN$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ089>"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:BHJPSTZ]^flntwx~ "(+,256>DFLOPVYZbhjpstz}~$|r  } ~st "$#' )u+*-/.2 4v658 :9= ?wA@C EDH JxLKN PO SUyWVY[Z ^`zbadfe ik{mloqp8@\d4<X`XY&&&&''?'f***(3>IT_j %0;FQ\g !&,17<BGMRX]chnͫͫͫͫͫͫͫ0  YL?fPi  &' 0$K0b Z#w`u y6 .&'&'G E$Fshs@ &' T$KTb Z#w8`@u8 @y86 .&'&'G E$Fs8hs8d &' x$Kxb Z#bw\`du\ dy\6 .&'&'0G E$Fs\hs\ &' $Kb Z#w`u y6 .&'&'HG E$Fshs &' $Kb Z#w`u y6 .&'&'`G E$Fshs &' $Kb Z#Lw`u y6 .&'&'xG E$Fshs &' $Kc Z#w`u y6 .&'&'G E$Fshs &' ,$K,j a#w`u y8 /&'&'G E$Fshs< &' P$KPj a#,w4`<u4 <y48 /&'&'G E$Fs4hs4` &' t$Ktj a#wX``uX `yX8 /&'&'G E$FsXhsX&'$! r{t4gdgdtgd ! r{thgd8gd8tgd8 ! r{tgd\gd\tgd\ ! r {tgdgdtgd ! r{xgdgdtgd ! r{x8gdgdtgd ! r{xlgdgdtgd ! r{xghghtgh ! r {xgh4gh4tgh4 ! r${xghXghXtghX !@ X @ f ``````````BBLThBBBBBBBB$8BBPXlBBBBBBBB (< =Cannot delete PERSON when they have COMMENTS in the database.ACannot delete PERSON when they have CERTIFICATES in the database.DCannot delete PERSON when they have ADDRESS records in the database.9Cannot PERSON when they are subscribed to a mailing list.BCannot delete PERSON when they have PHONE records in the database.1Cannot delete PERSON when they are an INSTRUCTOR.KCannot delete PERSON when they have ENROLLMENT information in the database.KCannot delete PERSON when they have MEMBERSHIP information in the database.2Cannot delete PERSON when they have a RESERVATION.+Cannot delete PERSON when they have a LOAN. PRIMARY_CUR<( PRIMARY_CURp\ PRIMARY_CUR PRIMARY_CUR PRIMARY_CUR  PRIMARY_CUR@, PRIMARY_CURt` PRIMARY_CUR PRIMARY_CUR PRIMARY_CUR# (((0 (8(@(T (\(d(x (( ( (( ,(04 (8<(@L(PT (X\(`l*pt *x|**, *4*<*P *X*`*t( | = C W e"#$%&' (*,:C;I<]=k>?@BDRSTUV WXZ\jIkOlcmqnoprt $QWky#(-27dj=BGLLXaBB6BNBfB ~BGBnBBBSELECT ''x'' FROM RS_COMMENT WHERE PS_PERSON_ID = :b1"SELECT ''x'' FROM CT_CERTIFICATE WHERE PS_PERSON_ID = :b1"SELECT ''x'' FROM PS_ADDRESS WHERE PS_PERSON_ID = :b1"SELECT ''x'' FROM PS_MAILING_LIST WHERE PS_PERSON_ID = :b1"SELECT ''x'' FROM PS_PHONE WHERE PS_PERSON_ID = :b1"SELECT ''x'' FROM CL_INSTRUCTOR WHERE ID = :b1"SELECT ''x'' FROM CL_ENROLLMENT WHERE PS_PERSON_ID = :b1"SELECT ''x'' FROM PS_MEMBERSHIP WHERE PS_PERSON_ID = :b1"SELECT ''x'' FROM RS_RESERVATION WHERE PS_PERSON_ID = :b1"SELECT ''x'' FROM RS_LOAN WHERE PS_PERSON_ID = :b1"0D=A0DH9`\Bx1K,K|2+1 $ P4_27_DEC_200120_33_35}Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  (( !PP@YES$   1 $ P5_27_DEC_200120_33_35ͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 /NSPC38/QUERY_MASTER_DETAILS/NSPC38/CHECK_PACKAGE_FAILURE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D 2"PKG INIT""RECSTAT"STARTITM"REL_ID"ID"" &)*017:<>@B   = <Pd  ͫͫͫͫͫͫͫ0D    g    <  Pd<  <4  4&'4t$KtD <&'L|$-|d'dd$4&'4$KD <&'|$-d'd$4&'4$KD <&'$-d'd$4&'4$KD <&'$-d'd$  P*  &'P$F'$!4  &)*&)*NEWINSERTPS_PERSON.PS_PERSON_PS_PHONEPS_PHONE'PS_PERSON.PS_PERSON_V_PS_PERSON_ADDRESSV_PS_PERSON_ADDRESS"PS_PERSON.PS_PERSON_V_PS_PERSON_MEV_PS_PERSON_MEMBERSHIP"PS_PERSON.PS_PERSON_V_PS_PERSON_MAV_PS_PERSON_MAILING_LISTz (<((P,t=d(tx||((( ( (4++QW !"*D+g,z456<=> @ E x4Ld|'",H"p1 $ iP6_27_DEC_200120_33_35 )ͫͫͫͫͫͫͫw SYSSTANDARD xh &MFSPS_PHONExh )%MFSV_PS_PERSON_ADDRESSxh )%MFSV_PS_PERSON_MEMBERSHIPxh )'MFSV_PS_PERSON_MAILING_LISTSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 **"PKG INIT""DUMMY_DEFINE"PS_PHONE_CUR""V_PS_PERSON_ADDRESS_CUR"V_PS_PERSON_MEMBERSHIP_CUR"V_PS_PERSON_MAILING_LIST_CUR"" (.069AGIORZ`bhksy{     % & ! '"(#)$ (08@&&&&   ͫͫͫͫͫͫͫ0t ##Dx D@#yw(Hu(H/HPPy(6 .&'&'GE$Fs(hs(#Aw0du0d/dlly06 .&'&'GE$Fs0hs0# w8u8/y86 .&'&'GE$Fs8hs8#w@u@/y@6 .&'&'GE$Fs@hs@! r{t(gd(gd(tgd( ! r{t\gd0gd0tgd0 ! r{tgd8gd8tgd8 ! r {tgd@gd@tgd@ !"````@@H\@t|@@?Cannot delete master record when matching detail records exist.hT PS_PHONE_CURV_PS_PERSON_ADDRESS_CURV_PS_PERSON_MEMBERSHIP_CUR0 V_PS_PERSON_MAILING_LIST_CUR  ( 0 8 @(HP (dl ($(,0(48<@ 5667D8c9g:l<pCvDEFGHJQRSTU#V(X,_2`Pa^b}cdfjo @@@&@SELECT 1 FROM PS_PHONE P WHERE P.PS_PERSON_ID = :b1"SELECT 1 FROM V_PS_PERSON_ADDRESS V WHERE V.PS_PERSON_ID = :b1"SELECT 1 FROM V_PS_PERSON_MEMBERSHIP V WHERE V.PS_PERSON_ID = :b1"SELECT 1 FROM V_PS_PERSON_MAILING_LIST V WHERE V.PS_PERSON_ID = :b1"$?1 $ rP18_27_DEC_200120_33_351Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" dT &' ($K(G  9 ;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((\` 4L PX?mr  -1 $ vP19_27_DEC_200120_33_355Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss& dT &' 4$B4G  9  ; <&'&'<GE$Fh!|-WHEN-VALIDATE-ITEM trigger failed on field - &(4\` @L PX?mr  -1 $ vP20_27_DEC_200120_33_355Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss& dT &' 4$B4G  9  ; <&'&'<GE$Fh!|-WHEN-VALIDATE-ITEM trigger failed on field - &(4\` @L PX?mr  -1 $ vP21_27_DEC_200120_33_355Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss& hT &' 4$B4G  9  ; <&'&'<GE$Fh!|-WHEN-VALIDATE-ITEM trigger failed on field - &(4`d @P T\?mr  -1 $ P22_27_DEC_200120_33_35Iuͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh 'MFS PS_PHONE_TYPE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    @H& ͫͫͫͫͫͫͫ0P ""!0  &' 4$B4G  9  ; <&'&'<GE$FhH &' \$B\h `#[w@`Hu@ Hy@<  .&'&'GE$Fs@hs@! r{t gd@gd@tgd@ !P`@8@T-WHEN-VALIDATE-ITEM trigger failed on field - DForeign key value does not currently exist in the primary key table. PRIMARY_CUR@(4 (@(H(\ dx  |?mv#@SELECT ''x'' FROM PS_PHONE_TYPE WHERE ID = :b1"!T-D1 $ P17_27_DEC_200120_33_35Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D    D$/!TTD<@,8  Ps Person IdSY_ADDRESS_IDSy Address IdPS_ADDRESS_TYPE_IDAddress TypeSTREET_1Street 11 $ ]P2_23_JAN_200219_25_21Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Toͫͫͫͫͫͫͫ0D pp hD &'  $B D  6&'$&'&'GE$Fh!`Street 1 is a REQUIRED field `d (\(?Kjo STREET_2Street 2City1 $ YP0_23_JAN_200219_25_21Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Toͫͫͫͫͫͫͫ0D pp  \@ &'  $B D  6&'$&'&'GE$Fh!\City is a REQUIRED field TX (P?Kjo  STATEState1 $ YP1_23_JAN_200219_25_21Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Toͫͫͫͫͫͫͫ0D pp  @@ &'  $B D  6&'$&'&'GE$Fh!\State is a REQUIRED field 8< (4?Kjo ZIPZip1 $ UP4_23_JAN_200219_25_21Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Toͫͫͫͫͫͫͫ0D pp H< &'  $B D  6&'$&'&'GE$Fh!XZIP is a REQUIRED field @D (< ?Kjo ATTENTIONAttention1 $ P6_23_JAN_200219_25_21}Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  ((!PP@MT$  V_PS_PERSON_MEMBERSHIPV_PS_PERSON_MEMBERSHIP HduIDIdPS_ORGANIZATION_IDPs Organization IdPS_PERSON_IDPs Person IdPS_POSITION_TYPE_IDPs Position Type IdNAMEOrganizationPOSITIONPositionJOINEDDate JoinedMM/DD/RRRRMM/DD/RRRRLEFTDate LeftMM/DD/RRRRMM/DD/RRRRV_PS_PERSON_MAILING_LISTV_PS_PERSON_MAILING_LISTps_mail_type_id8r(FPS_PERSON_IDPs Person IdPS_MAIL_TYPE_IDList IDDESCRIPTIONDescriptionLIST_TYPEList TypePS_ADDRESS_TYPE_IDAddress TypeEXPIRATION_DATEExpiration DateMM/DD/RRRRMM/DD/RRRRV_CL_TRANSCRIPTV_CL_TRANSCRIPTps_person_id= :1offered,cl_course_idHH}CL_SESSION_IDCl Session IdPS_PERSON_IDPs Person IdCL_COURSE_IDIdCOURSE_NAMECourse NameOFFEREDDateMM/DD/RRRRMM/DD/RRRRHOURSHoursCOSTCostGRADEGradeTotal HoursPrint Cert1 $ P1_16_SEP_200312_46_00yiͫͫͫͫͫͫͫw SYSSTANDARD TOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 , ""PKG INIT""LIST_ID"ID""#&(*   $Aͫͫͫͫͫͫͫ0D BBF| $&'4$4$&'$D$JD%  &'$$&'L$L$&'\&'$4GE \$&'p&'$LGE p$&'&'&'dG E$G E, $$u&'$$!t$t  &)*&)*corscert_select_listP_PARTICIPANT_ID P_SESSION_IDCL_SESSION_PRINTC$4DL\ȠpР6`q    0 AA x4L dPrint Transcript1 $ P0_10_JUL_200317_21_59Miͫͫͫͫͫͫͫw SYSSTANDARD TOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 , ""PKG INIT""LIST_ID"ID""#&(*   <ͫͫͫͫͫͫͫ0D ~ <&'L$L<&'<\$J\%  &'<$!  4"  L ! &'d$d<&'44t&'<dGE t$&'! &'<|GE  $&'&'<GE $&'&'&'&'&'GEGE` GElGE<$ &'<$!$4 &)*&)*transcript_select_listYNP_PS_ID P_SHOW_HOURS PARAMFORMNOTranscript_certD<L\dtԠ !46`q    "K x4Ld|  NShow Hours on TranscriptYNUSING_TRANSACTIONAL_TRIGGERSlL|<l8Pl,H\ H|4Xp,D\|4X$X| COURSE_NAME8D% ALTERNATE_ID1 $ P2_21_AUG_200414_46_49}Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  (("!PP@N$" t CHECK_PACKAGE_FAILURE|GPS_PERSON_V_PS_PERSON_ADDRESS3MAIN_MEMBERSHIPdoLEFTT SET_UP_LIST} s8eTH|!ROWIDx CAN_PHONE,9 BIRTHDATE_ZIP CAN_COURSES@ CLEAR_ALL_MASTER_DETAILShYSTREET_1f\"ID+SUFFIXxHXPS_ADDRESS_TYPE_ID0N IDENTIFIERGRADE7EMAILGPS_PERSON_V_PS_PERSON_MAPCOST  CAN_ADDRESS LOV_MEM_POS LOV79}V_CL_TRANSCRIPTLABTN_CERTp> SY_COUNTY_IDthUI PS_PERSON_IDOFFERED) LAST_NAME6OLD_NAME& FIRST_NAME8rV_PS_PERSON_MAILING_LISTnJOINEDjPS_POSITION_TYPE_ID, LOV_ADDRESS_MAIL_LISTw LIST_TYPEx\CITYxv DESCRIPTIONPHOURSGPS_PHONE CAN_ORGANIZATION LOV_ADDRESS_TYPETuPS_MAIL_TYPE_ID:PASSWORDGPS_PERSON_V_PS_PERSON_ME`;GENDERO EXTENSION#ACTIVET CL_COURSE_ID LOV_MAIL_TYPE LOV_MEM_ORG V SY_ADDRESS_IDHdV_PS_PERSON_MEMBERSHIPBDSP_MEMBERSHIP_TYPE,PB_PHONE( MIDDLE_NAME`GPS_PERSON_PS_PHONEp5DSP_MEMBERSHIPLHRS_TTL KPREFIXhkNAMECAN_MAINxPERSONLEXCHANGERUN_TRANSCRIPTlgPS_ORGANIZATION_IDd2 BTN_TRANSBTN_PRINT_COURSEP  PS_PERSONt. PB_ADDRESS$zEXPIRATION_DATE QUERY_MASTER_DETAILSx~ CL_SESSION_IDSV_PS_PERSON_ADDRESS?NOTES QPS_PHONE_TYPE_ID CAN_MAIL_LIST ^STATE$[STREET_2<lPOSITION LOV_COUNTY/MEMBERSHIP_BUTTON1MAIL_LIST_BUTTONa ATTENTION< SHOW_HOURS @T8 tx-P7(``8" 2 p Hd+1 7 `PtXt@$#`1h1x8"02 >t1x   x<? I(p  It 9FRAME5l  q  U I pq q q  U0 TahomaPerson  !HRQb !rT!rTU=rTU=k!kFRAME28  p&HR U&Q pq &rT&HR U0Gender  ;9*Ur;)U4@@rX9*;9*Ur0 TEXT86,HdTahomaID of organizationxZ"k*2 o4D H  "k*2 o4  "k0"ǍǍ6"6 9FRAME32   H ,Us+pq d ,,U0l   Phone Numbers\x Z+K~N\ `   +K~N  UIUUOO 9FRAME34   ` q + U pq | q Uq + U0  Addressx$ ȐZǽC~Fl p  $ ǽC~F ǽArHrH9FRAME39   p q *U +pq q q *U0Organization MembershipsxDؐZ9*2e94  D9*2e94$ 90UU7709FRAME53  q U epq q q U0 Mailing Listsx\ ZdrOrQ  \drOrQ< rLrPrPH9FRAME34   d UV pq   d U0Courses|1d|.1+ !1 ||1" d1"1(%d2 h2t2V I22/d2PhP2ZPD3hhH32PT3,Yh3iD_3,3 ,3%2 3" 4g@t4 4TZ4l a5l5T5=l5A (50`05|6dH`6|`0 6H,46(L60p52$HP6"`d6hH3$h6d|6JHX $6pD6 Jx $6T6$)Tu$6 t/w$6 X,v2$x6 86X"Pj$6Xhl2$6(l 7<^hkd$7lg$H7P07 )Tp>$p47l87@7 "L L P GSHd8r} !@GMPGLL !LCP P |!\"#D%&()+,t./1d23p567,9:;p>?LABP P `#t#8M$W 3Q 4M<#HM@g\"P LM#P $@%P$}DP$P@P PPn#P P%P H&&$MU$&U@nD%P $U&P  (($}34lY'Y'Y n&P Yp(P )|$}4l,])8]'P *\|+$}4@]*L]'n)P T]L+P ,$}4/``,`P (.dp.-$<*I9.'` `@`Z,P `@.P x// -$<vI9T/c@c Zt.P c/P 0d1 -$<I90xf@|f Z/P f0P 2`2 -$< I91Xi@\i Z1P li02P h33 -$<XI9D3@l@DlZd2P Pl3P 4$h5 $} J]; ,o4;<{@P t??$})X{P?h{@np>P }?P @$}J+t{@|{@0P PBB-$<I9,B{@{ ZLAP hBP C@$T2k02|C{@'\"C&#D&D%@D&&pD&(D&)D&+E&30E&62`E&7E&,9 E&:E&; F&p>PF&?&P fP 08P oP ԲFFFG`G|GGGP GP S,P Hd P 8rHS{{{HxRGG HI KL0NO QGGJ(K\"$ Q {xJ{@nIG@JG$LLx$}U'|L|n KGtLGMP,Nx$}p'|M$|nLG,MG4OOx$}'"(|O4|n0NGOGPlx$}'"8|PD|G RtRx $? 'J P|Qd|0Rl|p|n QGDRIR& KR&LS&0N8S&OhS& Q &fGST Dd|$x||T|dbSS TUVHXY$[x\^_aSSV(\"$A Q |Vl@SW$A Q |W@SLY F$} GJ (Y@SZL [ F$}(G"/(|Z@nYSZS(\ F$}(G0/(8\D@S|]T] F$}G>|X]P@nx\SX]S__ F$}>^@n^ST_S` a F$} ,>J  h`$@n_S(`Sb F $}GLa@Ub&Vb&HX b&Y($c&$[(Tc&x\c&^c&_ c&a&fSde ,XpepHdHd 8eflghjhklndoHdHdgt$A Q f@Hdph$A Q Lh@Hdi(\"$A Q i@Hdk$A" j @Hdll  /$}dCXd4Hl<@Hdm0 /$}2C+X2LmX@Hdo / $} C9F dnl@xHdhpD / $} U9F Dp@fp&lgq&hHq&jxq&hkdq&l2q&n r&do &s4rx{8r8r  stTuvwx$z8r8ru(\"$A Q 8tH@8rXv$}()X4vh8rwh$U27(2pw|8rx8$U(/x8ry$} .(J y,8r({  $} {(2 {t{&Tu{&v2|&w8|&x h|&$z & \"h$@H}  H  |0||}~TPL<}}d$A Q ||}($A Q @}X$} 3 4'}$}dBd'}D $} / ܄'}T$}&#0}H$}M! (}$}v0؈8}P H$,&#P,@@}| -$<+LP Z} \}h8 -$<ǦZ} 0}@ '$|~&Ȏ&T &d(& X&P&&&g} `G|GGG\"#D%&()+,t./1d23p567,9:;p>?LAB KL0NO QHXY$[x\^_ahklndoTuvwx$zTPL<!$" AAAAAA\"'#' A  A D%' &')'3'p5'3'B'p>' K'I'L'0N' Q'^'Y'x\'_''~'<'!<'" MMM M{{{{||||I HLPT$(,08<H\hlptx|  (4<DTXdpx|<Phpx@DX`|<@Tlp <Tp0L\`| $HLd8\pt0H`|8X\|$(@\(048<@DHLPTx8@DHLPTXltx(tx0\t,t\4@Hx|8 D L | 4 d l P \ d  L | ` l t \ $4|$<LDdpt| 048X0P\`hx  $,<LPTt4T`dlx|0<@HTX`px|(,DLTdh,4<DTt| $TX`pt 8<DTX (8<px  PTlpt 8 < @ D H L P T h t ! !$!(!,!0!4!8!>D>H>L>p>x>|>>>>>0?4?P???????@@@d@@@@LATAXAdAlAAAB,BXBxB|BBBBBBBC`C|CCCCCCD D@DPDpDDDDDDEE0E@E`EpEEEEEEF F0FPFFFFFFG$G8G@GDGHGLGPGTGXG\G`GhGpG|GGGGGGGGGGGGGH HH$H@HLHXH\HHHHHHHHHHIIIIIJXJ\JxJJKKK K(K,K8K@KKKKLLLLLLLLLLMhMlMM NN$N,N0N8N