1: PACKAGE BODY MSC_CL_PULL AS -- body
2: /* $Header: MSCCLFAB.pls 120.62.12020000.3 2013/01/24 02:35:24 beitang ship $ */
3:
4:
5:
543: IS
544: BEGIN
545:
546: /* initialize the database pipe name */
547: v_pipe_task_que := 'MSC_CL_PULL_TQ'||TO_CHAR(pINSTANCE_ID);
548: v_pipe_wm := 'MSC_CL_PULL_WM'||TO_CHAR(pINSTANCE_ID);
549: v_pipe_mw := 'MSC_CL_PULL_MW'||TO_CHAR(pINSTANCE_ID);
550: v_pipe_status := 'MSC_CL_PULL_ST'||TO_CHAR(pINSTANCE_ID);
551:
544: BEGIN
545:
546: /* initialize the database pipe name */
547: v_pipe_task_que := 'MSC_CL_PULL_TQ'||TO_CHAR(pINSTANCE_ID);
548: v_pipe_wm := 'MSC_CL_PULL_WM'||TO_CHAR(pINSTANCE_ID);
549: v_pipe_mw := 'MSC_CL_PULL_MW'||TO_CHAR(pINSTANCE_ID);
550: v_pipe_status := 'MSC_CL_PULL_ST'||TO_CHAR(pINSTANCE_ID);
551:
552: -- Initializes Level 2 Global Variables used in Data Pull
545:
546: /* initialize the database pipe name */
547: v_pipe_task_que := 'MSC_CL_PULL_TQ'||TO_CHAR(pINSTANCE_ID);
548: v_pipe_wm := 'MSC_CL_PULL_WM'||TO_CHAR(pINSTANCE_ID);
549: v_pipe_mw := 'MSC_CL_PULL_MW'||TO_CHAR(pINSTANCE_ID);
550: v_pipe_status := 'MSC_CL_PULL_ST'||TO_CHAR(pINSTANCE_ID);
551:
552: -- Initializes Level 2 Global Variables used in Data Pull
553:
546: /* initialize the database pipe name */
547: v_pipe_task_que := 'MSC_CL_PULL_TQ'||TO_CHAR(pINSTANCE_ID);
548: v_pipe_wm := 'MSC_CL_PULL_WM'||TO_CHAR(pINSTANCE_ID);
549: v_pipe_mw := 'MSC_CL_PULL_MW'||TO_CHAR(pINSTANCE_ID);
550: v_pipe_status := 'MSC_CL_PULL_ST'||TO_CHAR(pINSTANCE_ID);
551:
552: -- Initializes Level 2 Global Variables used in Data Pull
553:
554: END INITIALIZE_PULL_GLOBALS;
2836: COMMIT;
2837:
2838: end if;
2839:
2840: /* initialize the MSC_CL_PULL_WORKER package */
2841: /* get the total task number */
2842: INITIALIZE
2843: ( v_refresh_id,
2844: lv_total_task_number);
3635: pPO_RECEIPTS_ENABLED IN NUMBER := MSC_UTIL.SYS_NO
3636: ) is
3637: BEGIN
3638:
3639: MSC_CL_PULL.LAUNCH_WORKER(
3640: ERRBUF ,
3641: RETCODE ,
3642: pMONITOR_REQUEST_ID ,
3643: pINSTANCE_ID ,
3732:
3733: is
3734: BEGIN
3735:
3736: MSC_CL_PULL.LAUNCH_MONITOR(ERRBUF,
3737: RETCODE,
3738: pINSTANCE_ID,
3739: pORG_GROUP,
3740: pTotalWorkerNum,
7156: END ANALYZE_ST_TABLE;
7157:
7158: /* ds_plan: change end */
7159:
7160: END MSC_CL_PULL;