'4THRS_CATEGORYMODULE1DEFAULT&SMARTBARAMERICAN_AMERICA.WE8ISO8859P11 $ )P0_20_NOV_200023_52_16Tͫͫͫͫͫͫͫw SYSSTANDARD FTREE $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T7ͫͫͫͫͫͫͫ0D 88!0 H<&'$!||\C_TREE.SUB_TREENO  08(<D+7 41 $ P1_20_NOV_200023_52_16a>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T1ͫͫͫͫͫͫͫ0D 22k &'&'&'GEGE $4!00 md1md1 $ P0_19_JUN_200317_00_46aWͫͫͫͫͫͫͫ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_200317_00_46Wͫͫͫͫͫͫͫ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;"HTREE"ID"NODE_VALUE""#&(.135      (8 ͫͫͫͫͫͫͫ0D T (8&'@$+@()P&'&'(PGE$ XX$ (X8&'8t;4tp;pLl&'dGILl $&'d$;&'$/&'|$;)&'&'(GE` $$!\4\  &)*&)*C_TREE.SUB_TREEid = '' RS_CATEGORYC_TREEP((8@(PXt(  :{ x4Ld |1 $ =P5_23_NOV_200014_15_23ͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS FORMS4C FTREE $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D Kx H`L B&'$;&'&'G E$$&'0$;G =H&'`$&'&'GE$!, YES RS_CATEGORYC_TREENOC_TREE.SUB_TREE  08(<D%6Pax    ( 08HD`LRS_CATEGORYRS_CATEGORYID=Ftree.NODE_VALUEIDIdPARENT_IDF9 to select a new parent for this category. Delete ID to make a Main CategoryParent Id1 $ P6_20_NOV_200023_52_16Isͫͫͫͫͫͫͫw SYSSTANDARD xh 'MFS RS_CATEGORYSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    & ͫͫͫͫͫͫͫ0P . t &' 0$K0h `#[w`u y<  .&'&'G E$Fshs! r{t gdgdtgd !<< `BB8@T'PARENT ID IS NOT IN THE CATEGORY TABLE. PRIMARY_CUR' TX\h0lp 8P = C W kBSELECT ''x'' FROM RS_CATEGORY WHERE ID = :b1"\'TITLETitle1 $ ]P7_20_NOV_200023_52_16Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss < &' 4$B4G  9 ; <&'&'<GE$Fh!dTitle is required - &(4 @|2 ?mr  DELETE CATEGORY1 $ P0_09_APR_200221_11_26Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D v &'$ !DD4 DELETE_RECORD  1 $ P4_20_NOV_200023_52_16eͫͫͫͫͫͫͫw SYSSTANDARD xh 'MFS RS_CATEGORYSQLFORMS xh (MFSRS_ISSUE_CATEGORY$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08##p>"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:BHJPSTZ]^`bdfhjln  !   "(0LT,-&S& ͫͫͫͫͫͫͫ0\ yy/H-S0b d0 &' D$KDb Z#w(`0u( 0y(6 .&'&'G E$Fs(hs(T &' h$Khb Z#wL`TuL TyL6 .&'&'G E$FsLhsL&'$0! r{t$gd(gd(tgd( ! r{tXgdLgdLtgdL !ll``BB<DXBBpx%Can not delete a parent of a subtree.,Cannot delete category.. It has ITEMS in it.YES   PRIMARY_CURT@ PRIMARY_CURP (((0(D (L(T(h p  = C W e"#$%&' (*,- 1,25B[BSELECT ''x'' FROM RS_CATEGORY WHERE PARENT_ID = :b1"SELECT ''x'' FROM RS_ISSUE_CATEGORY WHERE RS_CATEGORY_ID = :b1"/ %,01 $ P4_23_NOV_200014_15_23}Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  $(!PP@YES   1 $ P9_23_NOV_200014_15_23Ikͫͫͫͫͫͫͫw SYSSTANDARD FORMS40 FORMS4C $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tbͫͫͫͫͫͫͫ0D cc/H& lD&'&'G I88 $48( 00$$!$p RS_CATEGORYCHANGEDYES+8dh LT($X`JVb 00<1 $ P1_09_NOV_200116_41_08ͫͫͫͫͫͫͫw SYSSTANDARD p <<MFSDUAL xh0-PUBLICDUALxh0-SYSDUALSEQ_ID xh 'MFSSEQ_ID$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 - <"PKG INIT"""""$')+    @ͫͫͫͫͫͫͫ0D AA 8T+q{t  w t !p`BB8@T 04,@SELECT SEQ_ID.NEXTVAL FROM DUAL"TREE_CHANGEDSAVE_CATEGORY S(SSSST<CANVAS2DSx  RS_CATEGORY\SWINDOW1L PARENT_IDX SROWID8ID LOV_PICK_PARENTS SUB_TREETITLET\PBDELETE C_TREE   8     | p (``8 R2 dHp t1 7  PPS"0%<<S %rXUq$XU&`P  [UF![U# ]U]]||9FRAME3  [U[pq 4][U0<XTahomaCategory  (rXYU(XY@(rX(rXYUXr0TEXT209TahomaDouble click a category above to edit or delete it below.  r4kU4j@r4kr4kUr0TEXT23F9 to pick Parent  (w{U(v{@(w(w{UXr0GRAPHIC26 KClick in the category tree above to save changes and select a new category.?S   X@ L$T( \(  x (T p  x x     S  S<| p|| d( l(@xp( )c .@  4S D,3834D3   X8L\x Sx <S<p =6 X3\3@x PhSl3< p}T =6 `3,3@3nLx 3x SX<p}2=X2X9`9@nx h9(x `T<| p<CO<<@<Z\x <x8&L &2&x ??x LH>x  KRx N<l 8L\0RRA08''AL'RRRRRRS(S,SDSHS`SxSSSSSSSSTT T(48<@DHLPTx$t8<@Th L4<dTD\<   $ , < @ x X p t  ` $ 8 T h p t x | DHLPTXd8@DXLTX`dl ,d@8<PX\dht| <h Pd $@h0