[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
827: -- Note: some formating is done in the report, but if possible it should be done here!
828: ---------------------------------------------------------------------------------------------
829: --
830: ---------------------------------------------------------------------------------------------
831: -- This function takes the standard ni format ie 999-99-9999
832: -- and returns it without the -'s
833: ---------------------------------------------------------------------------------------------
834: FUNCTION format_ni(p_ni IN VARCHAR2)
835: RETURN VARCHAR2 IS
837: RETURN(REPLACE(p_ni,'-') );
838: END format_ni;
839: --
840: ---------------------------------------------------------------------------------------------
841: -- This function takes the standard possibly 4 char noa code and
842: -- if it is 4 long returns the last three chars!
843: ---------------------------------------------------------------------------------------------
844: FUNCTION format_noac(p_noac IN VARCHAR2)
845: RETURN VARCHAR2 IS