BBH- InterestClaims-Update Package Script with Schema

• Make sure below line is added in the beginning just after value for nls_length_semantics is set

alter session set current_schema= ICLAIMAPP;

• Find an replace below one by one.
• ALTER TABLE MRT_CMCLAIMS >> ALTER TABLE ICLAIMAPP.MRT_CMCLAIMS
• CREATE TABLE MRT_CMCLAIMS >> CREATE TABLE ICLAIMAPP.MRT_CMCLAIMS
• CREATE SEQUENCE MRT_CMCLAIMS >> CREATE SEQUENCE ICLAIMAPP.MRT_CMCLAIMS
• CREATE OR REPLACE TRIGGER MRT_CMCLAIMS >> CREATE OR REPLACE TRIGGER ICLAIMAPP.MRT_CMCLAIMS
• BEFORE INSERT ON MRT_CMCLAIMS >> BEFORE INSERT ON ICLAIMAPP.MRT_CMCLAIMS
• CREATE INDEX I_CM >> CREATE INDEX ICLAIMAPP.I_CM ----------> same line -----------> ON MRT_CMCLAIMS >> ON ICLAIMAPP.MRT_CMCLAIMS
• FUNCTION FIXFLDCM(fld VARCHAR2) >> FUNCTION ICLAIMAPP.FIXFLDCM(fld VARCHAR2)
• FUNCTION ValidateChecksumStringCM(inputstr VARCHAR2) >> FUNCTION ICLAIMAPP.ValidateChecksumStringCM(inputstr VARCHAR2)
• create or replace view MRT_CMCLAIMS >> create or replace view ICLAIMAPP.MRT_CMCLAIMS
• PROCEDURE MRT_LKCM >> PROCEDURE ICLAIMAPP.MRT_LKCM