I.1 <INFODOM>_LEAF_REGISTRATION_PFT_EXT (Leaf Registration Procedure)

To enable Banking and Insurance applications to co-exist in the same environment, a new Leaf Registration Procedure is introduced for adding new Key Dimension Columns to the Dimensions metadata registry.

Executing Leaf Registration Procedure

You can execute this procedure either from SQL*Plus or from within a PL/SQL block or from Batch Maintenance window within OFSAAI framework. To run the procedure from SQL*Plus, login to SQL*Plus as the Schema Owner. The function requires 21 parameters. The syntax for calling the function is:

function rev_leaf_registration_pft_ext(batch_run_id  varchar2,
mis_date varchar2,
memDataType varchar2,
dimName varchar2,
description varchar2,
memberBTableName varchar2,
memberTLTableName varchar2,
hierarchyTableName varchar2,
attributeTableName varchar2,
memberCol varchar2,
memberDispCodeCol varchar2,
memberNameCol varchar2,
memberDescCol varchar2,
dimTypeCode varchar2,
simpleDimFlag varchar2,
keyDimFlag char,
writeFlag  varchar2,
catalogTableType char,
flattenedTableName in varchar2,
membercodecol in varchar2,
appId in varchar2 default null)

Example for Registering a Key Dimension

DECLARE
RESULT NUMBER;

BEGIN
        RESULT := REV_LEAF_REGISTRATION_PFT_EXT('LOB ID REGISTRATION',
                TO_CHAR(SYSDATE, 'YYYYMMDD'),
                'NUMBER',
                'Line of Business',
                'Line of Business',
                'DIM_LOB_B',
                'DIM_LOB_TL',
                'DIM_LOB_HIER',
                'DIM_LOB_ATTR',
                'LOB_ID',
                'LOB_DISPLAY_CODE',
                'LOB_NAME',
                'DESCRIPTION',
                'OTHER',
                'N',
                'Y',
                'Y',
                'B',
                'LOB_FLATTEN',
                'LOB_CODE',
                'OFS_PFT_INS');
        END;
/