[Home] [Help]
79:
80: END;
81: -- End of UPDATE_TO_PRIMARY_KEY;
82:
83: PROCEDURE NTB_UPLOAD_STANDARD_WHO(P_EXT_TBL_NAME IN VARCHAR2, P_EXTENSION_ID IN NUMBER, P_IF_ROW_EXISTS IN NUMBER) IS
84: --initialize variables here
85: l_updated_by NUMBER := 15;
86: l_last_update_login NUMBER := 15;
87: v_stmt VARCHAR2(20000);
116: WHEN OTHERS THEN
117: RAISE_APPLICATION_ERROR(-20001,' in the procedure to update who columns');
118:
119: END;
120: -- End of NTB_UPLOAD_STANDARD_WHO;
121:
122: PROCEDURE NTB_UPLOADTL(P_ENTITY IN VARCHAR2, P_EXTID IN NUMBER, P_IF_ROW_EXISTS IN NUMBER) IS
123: --initialize variables here
124: v_pk_column VARCHAR2(30);
167:
168: ELSE
169: -- CALL to who upload column
170: --DBMS_OUTPUT.PUT_LINE('UPDating the who columns');
171: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname_tl,p_extId,p_if_row_exists);
172: END IF;
173:
174:
175:
468: mth_util_pkg.g_debug_indent_level := mth_util_pkg.g_debug_indent_level - 1;
469: mth_util_pkg.log_msg('Processed Row '||VAR, mth_util_pkg.G_DBG_VAR_VAL);
470:
471: /*
472: call procedure to update standard who columns
473: */
474: --DBMS_OUTPUT.PUT_LINE('calling who procedure');
475: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname,v_extId, v_if_row_exists);
476:
471: /*
472: call procedure to update standard who columns
473: */
474: --DBMS_OUTPUT.PUT_LINE('calling who procedure');
475: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname,v_extId, v_if_row_exists);
476:
477: /*
478: Call the procedure to update TL Table
479: */
653: v_l_stmt NUMBER; -- To track the line where the error has occcured
654: v_count NUMBER;
655: v_to_date DATE;
656: v_fact_table VARCHAR2(50) := UPPER(p_target); -- FACT Table Name
657: v_last_update_date DATE; -- Standard WHO column
658: v_last_update_system_id NUMBER; -- Standard WHO column
659: v_stmt VARCHAR2(500);
660:
661:
654: v_count NUMBER;
655: v_to_date DATE;
656: v_fact_table VARCHAR2(50) := UPPER(p_target); -- FACT Table Name
657: v_last_update_date DATE; -- Standard WHO column
658: v_last_update_system_id NUMBER; -- Standard WHO column
659: v_stmt VARCHAR2(500);
660:
661:
662: -- main body
747: CREATION_DATE will be same as v_last_update_date if the load is run for the first time,
748: else if the load is being run again, CREATION_DATE would already be populated, so there is no
749: need for this variable
750: */
751: v_last_update_date DATE; -- Standard WHO column
752: /*
753: CREATION_SYSTEM_ID will be same as LAST_UPDATE_SYSTEM_ID if the load is run for the first time,
754: else if the load is being run again, CREATION_SYSTEM_ID would already be populated, so there is no
755: need for this variable
753: CREATION_SYSTEM_ID will be same as LAST_UPDATE_SYSTEM_ID if the load is run for the first time,
754: else if the load is being run again, CREATION_SYSTEM_ID would already be populated, so there is no
755: need for this variable
756: */
757: v_last_update_system_id NUMBER; -- Standard WHO column
758: v_stmt VARCHAR2(500);
759: e_not_allowed EXCEPTION;
760:
761:
1055:
1056: ELSE
1057: -- CALL to who upload column
1058: --DBMS_OUTPUT.PUT_LINE('UPDating the who columns');
1059: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname_tl,p_extId,p_if_row_exists);
1060: END IF;
1061:
1062:
1063:
1352: --Commit after all the attributes for one group id is
1353: --updated
1354: COMMIT;
1355: /*
1356: call procedure to update standard who columns
1357: */
1358: --DBMS_OUTPUT.PUT_LINE('calling who procedure');
1359: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname,v_extId, v_if_row_exists);
1360:
1355: /*
1356: call procedure to update standard who columns
1357: */
1358: --DBMS_OUTPUT.PUT_LINE('calling who procedure');
1359: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname,v_extId, v_if_row_exists);
1360:
1361: /*
1362: Call the procedure to update TL Table
1363: */