APPS.DDR_ETL_UTIL_PKG dependencies on DDR_U_MV_RFRSH_LOG

Line 902: INSERT INTO ddr_u_mv_rfrsh_log(refresh_job_id

898: v_seq NUMBER;
899: BEGIN
900:
901: SELECT ddr_u_mv_rfrsh_seq.nextval INTO v_seq FROM DUAL;
902: INSERT INTO ddr_u_mv_rfrsh_log(refresh_job_id
903: ,refresh_sequence
904: ,mv_name
905: ,refresh_method
906: ,error_message

Line 924: UPDATE ddr_u_mv_rfrsh_log

920: DBMS_MVIEW.REFRESH(p_list, p_method, p_rollback_seg, p_push_deferred_rpc,
921: p_refresh_after_errors, p_purge_option,
922: p_parallelism, p_heap_size, p_atomic_refresh);
923:
924: UPDATE ddr_u_mv_rfrsh_log
925: SET end_date = SYSDATE
926: WHERE refresh_job_id = p_job_id
927: AND refresh_sequence = v_seq
928: AND mv_name = p_list;

Line 938: UPDATE ddr_u_mv_rfrsh_log

934: WHEN OTHERS THEN
935: x_out := 'F';
936: x_message := SQLERRM;
937:
938: UPDATE ddr_u_mv_rfrsh_log
939: SET end_date = SYSDATE,
940: error_message = x_message
941: WHERE refresh_job_id = p_job_id
942: AND refresh_sequence = v_seq

Line 964: INSERT INTO ddr_u_mv_rfrsh_log(refresh_job_id

960: v_seq NUMBER;
961: BEGIN
962:
963: SELECT ddr_u_mv_rfrsh_seq.nextval INTO v_seq FROM DUAL;
964: INSERT INTO ddr_u_mv_rfrsh_log(refresh_job_id
965: ,refresh_sequence
966: ,mv_name
967: ,refresh_method
968: ,error_message

Line 984: UPDATE ddr_u_mv_rfrsh_log

980: COMMIT;
981:
982: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||p_mv_log_name||' DROP STORAGE';
983:
984: UPDATE ddr_u_mv_rfrsh_log
985: SET end_date = SYSDATE
986: WHERE refresh_job_id = p_job_id
987: AND refresh_sequence = v_seq
988: AND mv_name = p_mv_log_name;

Line 997: UPDATE ddr_u_mv_rfrsh_log

993: EXCEPTION
994: WHEN OTHERS THEN
995: x_out := 'F';
996: x_message := SQLERRM;
997: UPDATE ddr_u_mv_rfrsh_log
998: SET end_date = SYSDATE,
999: error_message = x_message
1000: WHERE refresh_job_id = p_job_id
1001: AND refresh_sequence = v_seq