'0p.CL_SESSION_PRINTMODULE2DEFAULT&SMARTBARAMERICAN_AMERICA.WE8ISO8859P11 $ 9P9_26_JUL_200217_43_30ͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS FORMS4C FORMS40 /NSPC34/SET_UP_LIST$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D g &'$;&'$;)&'H$KH &'&'0G ILH $&'$/*&'P$KPE =`  'x$*XX4+4!D4D BLK_CONTROL CL_SESSION cl_sessionID=:PARAMETER.P_SESSION_IDSELECTEDblk_CONTROL.LST_PARTICIPANTS RG_ENROLL>HPXl 4+0[  0 0@ HP`px 1 $ P10_26_JUL_200217_43_30a>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T1ͫͫͫͫͫͫͫ0D 22k &'&'&'GEGE $4!00 md1md1 $ P0_19_JUN_200316_31_22aWͫͫͫͫͫͫͫ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 $ P1_19_JUN_200316_31_22Wͫͫͫͫͫͫͫ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;""Tͫͫͫͫͫͫͫ0D T '$!88 qq q1 $ " SET_UP_LISTͫͫͫͫͫͫͫw SYSSTANDARD FORMS4G FORMS4W SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ085 -"PKG INIT"SET_UP_LIST"PLIST"PGROUP"VERRFLAG""%(.13     / ͫͫͫͫͫͫͫ0D 00k 3 . &'% $. = 3&'%$`&'%%$ZE. 5 +&'&'GE$F i;(%,;,@(;(%$&'&'$GE$FkI;X%<; O k (\`d(|@Xp1 $ (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 /NSPC34/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 /NSPC34/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#Print Class CertificatesRG_COURSESELECT ALL CL_COURSE.ID, CL_COURSE.NAME FROM CL_COURSE order by 1IDNAMERG_ENROLLselect NAME,to_char(ID) from v_ps_pick_person where id in (select ps_person_id from cl_enrollment where cl_session_id = :CL_SESSION.ID) order by UNAMENAMEICRGGQ_0Pick COURSEIdName????= = = ?zzz??(((??@??????@??????@??????@??????@?????????333333?p=p=p=?GGG?QQQ?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?????(\(\(\?ffffff?ppp?zzz??@??????@??????@??????@??????@??????????\\\??ףףף??@??????@??????@??????@??????@??????????QQQ????@??????@??????@??????@??????@????????? ?GGG????@??????@??????@??????@??????@?????TahomaTahomaCL_SESSIONCL_SESSIONIDSession IdCL_COURSE_IDCourse Id1 $ P0_07_OCT_200217_15_19[ͫͫͫͫͫͫͫw SYSSTANDARD xh *MFS CL_COURSE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08E T"PKG INIT""""""$'()/17:;=?AC     dd4Dg  ͫͫͫͫͫͫͫ0D hh q{t$4w4<4#t4"RECSTAT"STARTITM"REL_ID"ID"" &)*017:<>@B   = <Pd ͫͫͫͫͫͫͫ0D F| 8   <  Pd<  <4  !4&'4t$KtD <&'L|$-|d'dd$  P*  &'P$F'$!4 $ &)*&)*NEWINSERT$CL_SESSION.CL_SESSION_V_CL_SESSION_IV_CL_SESSION_INSTRUCTORP(<(P,=d(t04| ( (4++QW "' x4L$d1 $ P5_15_SEP_200316_33_45qͫͫͫͫͫͫͫw SYSSTANDARD xh )'MFSV_CL_SESSION_INSTRUCTORSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08C M"PKG INIT""DUMMY_DEFINE"V_CL_SESSION_INSTRUCTOR_CUR""" (.069;=?A     (pq&  ͫͫͫͫͫͫͫ0P qF #_w(0u(0/088y(6 .&'&'G E$Fs(hs(! r{t gd(gd(!tgd( !dd ` 8@T?Cannot delete master record when matching detail records exist.V_CL_SESSION_INSTRUCTOR_CUR0ht (x|08 Ld6Dcgl!p%p*y SELECT 1 FROM V_CL_SESSION_INSTRUCTOR V WHERE V.CL_SESSION_ID = :b1"\?V_CL_SESSION_INSTRUCTORV_CL_SESSION_INSTRUCTOR\\`8CL_SESSION_IDCl Session IdINSTRUCTOR_IDInstructor IdFIRST_NAMEFirst NameLAST_NAMELast NameIDIdTahomaPrint Certificates1 $ P0_16_SEP_200309_46_34jͫͫͫͫͫͫͫw SYSSTANDARD TOOLS SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ088 &"PKG INIT""RES"LIST_ID"ID"" &'-0246     l ͫͫͫͫͫͫͫ0D l l   l%44l!HH]&'&'4G E$F&'&'LG E$F&'d$;h  |c Y%44L&'&'G E$F&'&'LG E$Fh&'$&'!HH&'GE $&'&'GE $&'&P&' GE P$&''dd&'$GE $&'&'<GE l$&'&'&'&'&'GETGE` GElGE$ &'$!$ &)*&)*ALLSelect a course session! CL_SESSIONSELECTEDSelect a participantcourse_cert_select_listP_COURSE_SESSION_ID PARAMFORMNOP_HOURSP_INSTRUCTOR_IDP_PARTICIPANT_IDCourseCertificatez(l|(Ȱ(ܸ (40 (H4L(PP\(d`x.9 EUt6k !"%#y$%' x4Ld | ( 0$<<PThYESRB_YESYes, print the hoursYESBT_NONO, Don't print the hoursNOALLRB_ALL_PARTICIPANTSALL ParticipantsALLRB_INDIVIDUALSelected ParticipantSELECTED1 $ P2_16_SEP_200309_46_34mͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 /NSPC34/SET_UP_LIST$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08#"PKG INIT""NUM""z! $ͫͫͫͫͫͫͫ0D Kx t$&'&'&'GIGI $(c Y&'&'&'GIGI $'0H$&'`$F!,BLK_CONTROL.LST_PARTICIPANTSSELECTEDblk_CONTROL.LST_PARTICIPANTS RG_ENROLLLST_PARTICIPANTS$Xp,TAX    (L0\H `12!lmDmdmmm n(n@n|nnnn oHo`oooooV_CL_SESSION_INSTRUCTOR (mIDL CL_SESSION INSTRUCTOR_IDmx P_PARTICIPANT_IDCL_SESSION_V_CL_SESSION_Im$*LST_PARTICIPANTS'RG_PARTICIPANTS LAST_NAME$ CL_COURSE_ID%RG_HOURS\nX" BLK_CONTROLDSP_COURSE_NAMEOFFEREDnl FIRST_NAMEHOURS LOV_COURSEo P_SESSION_ID CL_SESSION_IDt CHECK_PACKAGE_FAILURECANVAS2 CLEAR_ALL_MASTER_DETAILS$PB_PRINTT SET_UP_LIST QUERY_MASTER_DETAILS8#0pROWIDxWND_SESSION_ADD@T+@tp p p  $50``8 +Ll2 dPp 1 07  +Pto,oolo%\4d4xp#62@p4Toxtd+ @ -(lP  ,  tr**-r,l r(,,x9FRAME3d  q UU -ppq q q UU0TahomaCourse Session  tH.+-~. r0)r0ǥr0ǥ9Z9Z9FRAME31  (q H.U -pq Dq r0q H.U0L` Instructors  t9 _LU ^L 9V_9 _LULr TEXT34 /TahomaSelect the course session and instructor above.  tg4U9gU5 ;gg4U4r TEXT40"Print course hours on certificate?  trxU!Ux!  9&rxrxU!UU!r GRAPHIC46   Print certificates for?  ttsFsw|  vsvuvuljlj UFRAME47t    tUspq  vtU0   Participants  t+cUcbU  UeU9UeqUeqss UFRAME48   , +cUbpq H Ue+cU0P d  Show Hoursx  pm n 4< T 4Al  74 T T 4"d< 4 w4 4555M( n5 ` 5J< $ $5T K K LX"4m$K0K 0$LpL m$ b9