APPS.MTH_UDA_PKG dependencies on MTH_RUN_LOG

Line 683: FROM MTH_RUN_LOG

679:
680: -- Check whether the pre map operation has been run or not
681: v_l_stmt := 40;
682: SELECT COUNT(FACT_TABLE) INTO v_count
683: FROM MTH_RUN_LOG
684: WHERE FACT_TABLE = v_fact_table;
685:
686: -- DBMS_OUTPUT.PUT_LINE('THE COUNT IS '||v_count);
687:

Line 693: FROM MTH_RUN_LOG

689:
690: -- Another check
691: v_l_stmt := 45;
692: SELECT TO_DATE INTO v_to_date
693: FROM MTH_RUN_LOG
694: WHERE FACT_TABLE = v_fact_table;
695:
696: -- DBMS_OUTPUT.PUT_LINE('THE TO_DATE IS '||v_to_date);
697:

Line 708: v_stmt := 'UPDATE MTH_RUN_LOG SET FROM_DATE = TO_DATE, LAST_UPDATE_DATE = :1, LAST_UPDATE_SYSTEM_ID =:2 WHERE

704: ELSE
705: -- Update TO_DATE to SYSDATE, LAST_UPDATE_DATE, and LAST_UPDATE_SYSTEM_ID
706:
707:
708: v_stmt := 'UPDATE MTH_RUN_LOG SET FROM_DATE = TO_DATE, LAST_UPDATE_DATE = :1, LAST_UPDATE_SYSTEM_ID =:2 WHERE
709: FACT_TABLE =:3';
710:
711: -- DBMS_OUTPUT.PUT_LINE('UPDATING THE LOG TABLE '||v_stmt);
712:

Line 719: v_stmt := 'UPDATE MTH_RUN_LOG SET TO_DATE = NULL WHERE

715: v_l_stmt := 65;
716: COMMIT;
717:
718: v_l_stmt := 70;
719: v_stmt := 'UPDATE MTH_RUN_LOG SET TO_DATE = NULL WHERE
720: FACT_TABLE =:1';
721:
722: -- DBMS_OUTPUT.PUT_LINE('UPDATING THE LOG TABLE '||v_stmt);
723:

Line 784: FROM MTH_RUN_LOG

780:
781: -- Check whether the load is being run for the first time or not
782: v_l_stmt := 20;
783: SELECT COUNT(FACT_TABLE) INTO v_cnt
784: FROM MTH_RUN_LOG
785: WHERE FACT_TABLE = v_fact_table;
786:
787: -- DBMS_OUTPUT.PUT_LINE('Count of the fact table '||v_cnt);
788:

Line 793: v_stmt := 'INSERT INTO MTH_RUN_LOG (FACT_TABLE, FROM_DATE, TO_DATE, CREATION_DATE,

789: v_l_stmt := 30;
790: IF v_cnt = 0 THEN
791: -- Log is being run for the first time
792:
793: v_stmt := 'INSERT INTO MTH_RUN_LOG (FACT_TABLE, FROM_DATE, TO_DATE, CREATION_DATE,
794: LAST_UPDATE_DATE, CREATION_SYSTEM_ID, LAST_UPDATE_SYSTEM_ID) VALUES (:1, :2, :3, :4, :5, :6, :7)';
795: v_l_stmt := 40;
796: -- DBMS_OUTPUT.PUT_LINE('Inserting'||v_stmt);
797: EXECUTE IMMEDIATE v_stmt USING v_fact_table, v_from_date, v_to_date, v_last_update_date,

Line 804: v_stmt := 'UPDATE MTH_RUN_LOG SET TO_DATE = :1, LAST_UPDATE_DATE = :2, LAST_UPDATE_SYSTEM_ID =:3 WHERE

800: COMMIT;
801: ELSE
802: -- Update TO_DATE to SYSDATE, LAST_UPDATE_DATE, and LAST_UPDATE_SYSTEM_ID
803:
804: v_stmt := 'UPDATE MTH_RUN_LOG SET TO_DATE = :1, LAST_UPDATE_DATE = :2, LAST_UPDATE_SYSTEM_ID =:3 WHERE
805: FACT_TABLE =:4';
806: v_l_stmt := 50;
807: -- DBMS_OUTPUT.PUT_LINE('Updating'||v_stmt);
808: EXECUTE IMMEDIATE v_stmt USING v_to_date, v_last_update_date, v_last_update_system_id, v_fact_table;