782: v_tl_colname VARCHAR2(30);
783: v_stmt VARCHAR2(32767);
784: v_stmt_no NUMBER;
785: CURSOR DISTINCT_COLUMN IS
786: SELECT DISTINCT DB_COL FROM MTH_TAG_READINGS_T_STG;
787:
788:
789: BEGIN
790:
794: v_colname := DBCOL.DB_COL;
795: v_stmt_no := 10;
796: v_stmt := 'MERGE INTO MTH_EQUIPMENTS_EXT_B ED
797: USING (
798: SELECT * FROM MTH_TAG_READINGS_T_STG,(SELECT NVL(FND_GLOBAL.User_Id,-1)l_updated_by,NVL(FND_GLOBAL.Login_Id,-1)l_last_update_login FROM DUAL )D
799: WHERE DB_COL = '||''''||v_colname||''''||') TS
800: ON (';
801:
802: v_stmt := v_stmt||'ED.EQUIPMENT_PK_KEY = TS.EQUIPMENT_FK_KEY AND