APPS.MTH_UDA_PKG dependencies on MTH_RUN_LOG

Line 642: FROM MTH_RUN_LOG

638:
639: -- Check whether the pre map operation has been run or not
640: v_l_stmt := 40;
641: SELECT COUNT(FACT_TABLE) INTO v_count
642: FROM MTH_RUN_LOG
643: WHERE FACT_TABLE = v_fact_table;
644:
645: -- DBMS_OUTPUT.PUT_LINE('THE COUNT IS '||v_count);
646:

Line 652: FROM MTH_RUN_LOG

648:
649: -- Another check
650: v_l_stmt := 45;
651: SELECT TO_DATE INTO v_to_date
652: FROM MTH_RUN_LOG
653: WHERE FACT_TABLE = v_fact_table;
654:
655: -- DBMS_OUTPUT.PUT_LINE('THE TO_DATE IS '||v_to_date);
656:

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

663: ELSE
664: -- Update TO_DATE to SYSDATE, LAST_UPDATE_DATE, and LAST_UPDATE_SYSTEM_ID
665:
666:
667: v_stmt := 'UPDATE MTH_RUN_LOG SET FROM_DATE = TO_DATE, LAST_UPDATE_DATE = :1, LAST_UPDATE_SYSTEM_ID =:2 WHERE
668: FACT_TABLE =:3';
669:
670: -- DBMS_OUTPUT.PUT_LINE('UPDATING THE LOG TABLE '||v_stmt);
671:

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

674: v_l_stmt := 65;
675: COMMIT;
676:
677: v_l_stmt := 70;
678: v_stmt := 'UPDATE MTH_RUN_LOG SET TO_DATE = NULL WHERE
679: FACT_TABLE =:1';
680:
681: -- DBMS_OUTPUT.PUT_LINE('UPDATING THE LOG TABLE '||v_stmt);
682:

Line 743: FROM MTH_RUN_LOG

739:
740: -- Check whether the load is being run for the first time or not
741: v_l_stmt := 20;
742: SELECT COUNT(FACT_TABLE) INTO v_cnt
743: FROM MTH_RUN_LOG
744: WHERE FACT_TABLE = v_fact_table;
745:
746: -- DBMS_OUTPUT.PUT_LINE('Count of the fact table '||v_cnt);
747:

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

748: v_l_stmt := 30;
749: IF v_cnt = 0 THEN
750: -- Log is being run for the first time
751:
752: v_stmt := 'INSERT INTO MTH_RUN_LOG (FACT_TABLE, FROM_DATE, TO_DATE, CREATION_DATE,
753: LAST_UPDATE_DATE, CREATION_SYSTEM_ID, LAST_UPDATE_SYSTEM_ID) VALUES (:1, :2, :3, :4, :5, :6, :7)';
754: v_l_stmt := 40;
755: -- DBMS_OUTPUT.PUT_LINE('Inserting'||v_stmt);
756: EXECUTE IMMEDIATE v_stmt USING v_fact_table, v_from_date, v_to_date, v_last_update_date,

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

759: COMMIT;
760: ELSE
761: -- Update TO_DATE to SYSDATE, LAST_UPDATE_DATE, and LAST_UPDATE_SYSTEM_ID
762:
763: v_stmt := 'UPDATE MTH_RUN_LOG SET TO_DATE = :1, LAST_UPDATE_DATE = :2, LAST_UPDATE_SYSTEM_ID =:3 WHERE
764: FACT_TABLE =:4';
765: v_l_stmt := 50;
766: -- DBMS_OUTPUT.PUT_LINE('Updating'||v_stmt);
767: EXECUTE IMMEDIATE v_stmt USING v_to_date, v_last_update_date, v_last_update_system_id, v_fact_table;