PL/SQL Function to Fetch CC ID

PL/SQL Function to fetch the new cc id based on the old cc id

=============================================

1) Create following mapping table based on the data given by the accounting department

　
Name Null? Type
------------------------------- -------- ----
OLD_SEGMENT1 VARCHAR2(10)
OLD_SEGMENT2 VARCHAR2(10)
OLD_SEGMENT3 VARCHAR2(10)
NEW_SEGMENT1 VARCHAR2(10)
NEW_SEGMENT2 VARCHAR2(10)
NEW_SEGMENT3 VARCHAR2(10)
NEW_SEGMENT4 VARCHAR2(10)
NEW_SEGMENT5 VARCHAR2(10)
NEW_SEGMENT6 VARCHAR2(10)
NEW_SEGMENT7 VARCHAR2(10)
NEW_SEGMENT8 VARCHAR2(10)
OLD_CCID NUMBER(15)
NEW_CCID NUMBER(15)
DETAIL_POSTING_ALLOWED_FLAG VARCHAR2(1)
DETAIL_BUDGETING_ALLOWED_FLAG VARCHAR2(1)
OLD_ACCOUNT_TYPE VARCHAR2(1)
OLD_ENABLED_FLAG VARCHAR2(1)
OLD_SUMMARY_FLAG VARCHAR2(1)
NEW_ACCOUNT_TYPE VARCHAR2(1)
CREATED_BY NUMBER
CREATION_DATE DATE
LAST_UPDATE_DATE DATE

2) Create the function to fetch the new CC id

create or replace
function GET_CCID (CCID in number) return number
is
NEW_CCID number;
Begin
select new_ccid into NEW_CCID
from mscs_code_combinations_mapping
where
old_ccid = ccid
and rownum < 2;
return( NEW_CCID );
exception
when no_data_found
then
return(null);
when others
then
return(null);
end GET_CCID;