desktop_task_schedule/code/db/pkg/telsale_bi_utils.pck

CREATE OR REPLACE PACKAGE TELSALE_BI_UTILS IS

    -- Author  : WANGWEI-202
    -- Created : 2023/10/12 15:31:13
    -- Purpose : bi<62><69><EFBFBD>ݱ<EFBFBD><DDB1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>صĹ<D8B5><C4B9><EFBFBD>

    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>;

    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>;

    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>;

    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>;

END TELSALE_BI_UTILS;
/
CREATE OR REPLACE PACKAGE BODY TELSALE_BI_UTILS IS

    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD> IS
    BEGIN
        EXECUTE IMMEDIATE 'truncate table BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>';
    END;

    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD> IS
    BEGIN
        --EXECUTE IMMEDIATE 'truncate table BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>';
        EXECUTE IMMEDIATE 'truncate table "BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>-24<32><34>"';
    END;

    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD> IS
    BEGIN
        EXECUTE IMMEDIATE 'truncate table BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>';
    END;

    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD> IS
    BEGIN
        --EXECUTE IMMEDIATE 'truncate table BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¸<EFBFBD><C2B8><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>';
        EXECUTE IMMEDIATE 'truncate table "BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>-24<32><34>"';
    END;

BEGIN
    -- Initialization
    NULL;
END TELSALE_BI_UTILS;
/
-												续保率报表格式修改，还未完成。

											
										
										
											2024-01-10 10:24:10 +00:00
+								CREATE OR REPLACE PACKAGE TELSALE_BI_UTILS IS
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
 								    -- Author  : WANGWEI-202
 								    -- Created : 2023/10/12 15:31:13
 								    -- Purpose : bi<62><69><EFBFBD>ݱ<EFBFBD><DDB1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>صĹ<D8B5><C4B9><EFBFBD>
-												变更报表内容。

											
										
										
											2023-10-26 10:46:32 +00:00
+								    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>;
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
-												变更报表内容。

											
										
										
											2023-10-26 10:46:32 +00:00
+								    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>;
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
-												加入BI机构当月个车续保率跟踪表上传导入功能。

											
										
										
											2023-10-24 07:53:24 +00:00
+								    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>;
 								    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>;
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
-												续保率报表格式修改，还未完成。

											
										
										
											2024-01-10 10:24:10 +00:00
+								END TELSALE_BI_UTILS;
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								/
-												续保率报表格式修改，还未完成。

											
										
										
											2024-01-10 10:24:10 +00:00
+								CREATE OR REPLACE PACKAGE BODY TELSALE_BI_UTILS IS
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
-												变更报表内容。

											
										
										
											2023-10-26 10:46:32 +00:00
+								    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD> IS
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								    BEGIN
-												变更报表内容。

											
										
										
											2023-10-26 10:46:32 +00:00
+								        EXECUTE IMMEDIATE 'truncate table BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>';
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								    END;
-												变更报表内容。

											
										
										
											2023-10-26 10:46:32 +00:00
+								    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD> IS
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								    BEGIN
-												修改bug。

											
										
										
											2024-01-11 10:46:08 +00:00
+								        --EXECUTE IMMEDIATE 'truncate table BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>';
 								        EXECUTE IMMEDIATE 'truncate table "BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϯ<EFBFBD><CFAF><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>-24<32><34>"';
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								    END;
-												加入BI机构当月个车续保率跟踪表上传导入功能。

											
										
										
											2023-10-24 07:53:24 +00:00
+								    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD> IS
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								    BEGIN
-												变更报表内容。

											
										
										
											2023-10-26 10:46:32 +00:00
+								        EXECUTE IMMEDIATE 'truncate table BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͸<EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>';
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								    END;
-												加入BI机构当月个车续保率跟踪表上传导入功能。

											
										
										
											2023-10-24 07:53:24 +00:00
+								    PROCEDURE <20><><EFBFBD><EFBFBD>BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD> IS
 								    BEGIN
-												修改bug。

											
										
										
											2024-01-11 10:46:08 +00:00
+								        --EXECUTE IMMEDIATE 'truncate table BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¸<EFBFBD><C2B8><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>';
 								        EXECUTE IMMEDIATE 'truncate table "BI<42><49><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʸ<EFBFBD><CAB8>ٱ<EFBFBD>-24<32><34>"';
-												加入BI机构当月个车续保率跟踪表上传导入功能。

											
										
										
											2023-10-24 07:53:24 +00:00
+								    END;
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								BEGIN
 								    -- Initialization
 								    NULL;
-												续保率报表格式修改，还未完成。

											
										
										
											2024-01-10 10:24:10 +00:00
+								END TELSALE_BI_UTILS;
-												完成mybatis导入函数。

											
										
										
											2023-10-12 10:24:28 +00:00
+								/