[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: -- BUG # 7229419 commented the NOAC's related to 8XX and 7XX as these
75: -- need to be reported in EHRI Dynamics Report
1072: -- Note: some formating is done in the report, but if possible it should be done here!
1073: ---------------------------------------------------------------------------------------------
1074: --
1075: ---------------------------------------------------------------------------------------------
1076: -- This function takes the standard ni format ie 999-99-9999
1077: -- and returns it without the -'s
1078: ---------------------------------------------------------------------------------------------
1079: FUNCTION format_ni(p_ni IN VARCHAR2)
1080: RETURN VARCHAR2 IS
1082: RETURN(REPLACE(p_ni,'-') );
1083: END format_ni;
1084: --
1085: ---------------------------------------------------------------------------------------------
1086: -- This function takes the standard possibly 4 char noa code and
1087: -- if it is 4 long returns the last three chars!
1088: ---------------------------------------------------------------------------------------------
1089: FUNCTION format_noac(p_noac IN VARCHAR2)
1090: RETURN VARCHAR2 IS