create or replace PACKAGE "MIGRATION_REPORT" AS
--get status
FUNCTION getCaptureStatus(srcid IN NUMBER) RETURN VARCHAR2;
FUNCTION getConvertStatus(srcid IN NUMBER,convert_conn_id IN NUMBER) RETURN VARCHAR2;
FUNCTION getGenerateStatus(srcid IN NUMBER,convert_conn_id IN NUMBER) RETURN VARCHAR2;
--migration details
FUNCTION getDetails(capture_conn_id IN NUMBER,convert_conn_id IN NUMBER) RETURN MIGR_REPORT_DETAIL_TABLE PIPELINED;
--migration summary
FUNCTION getSum(capture_conn_id IN NUMBER,convert_conn_id IN NUMBER) RETURN MIGR_REPORT_SUM_TABLE PIPELINED;
END MIGRATION_REPORT; |