[Home] [Help]
67: ELSE
68: l_noac := format_noac(p_first_noac);
69: END IF;
70: --
71: -- The NOACs not to be printed as per OPM standards are added to the list
72: -- These NOACs are added under due to reference of NOACs as 7% and 8% under EHRI code changes.
73: --
74: IF (l_noac BETWEEN '900' and '999') or
75: (l_noac IN ( '850','855','750','782','800','805','806','880','881','882','883')) THEN
780: -- Note: some formating is done in the report, but if possible it should be done here!
781: ---------------------------------------------------------------------------------------------
782: --
783: ---------------------------------------------------------------------------------------------
784: -- This function takes the standard ni format ie 999-99-9999
785: -- and returns it without the -'s
786: ---------------------------------------------------------------------------------------------
787: FUNCTION format_ni(p_ni IN VARCHAR2)
788: RETURN VARCHAR2 IS
790: RETURN(REPLACE(p_ni,'-') );
791: END format_ni;
792: --
793: ---------------------------------------------------------------------------------------------
794: -- This function takes the standard possibly 4 char noa code and
795: -- if it is 4 long returns the last three chars!
796: ---------------------------------------------------------------------------------------------
797: FUNCTION format_noac(p_noac IN VARCHAR2)
798: RETURN VARCHAR2 IS