DBA Data[Home] [Help]

PACKAGE: APPS.MSD_CL_LOADERS

Source


1 PACKAGE MSD_CL_LOADERS AS -- specification
2 /* $Header: MSDCLLDS.pls 120.5 2007/11/05 13:22:28 vrepaka ship $ */
3 
4   ----- ARRAY DATA TYPE --------------------------------------------------
5 
6    TYPE NumTblTyp IS TABLE OF NUMBER;
7    TYPE VarcharTblTyp IS TABLE OF VARCHAR2(1000);
8 
9   ----- CONSTANTS --------------------------------------------------------
10 
11    SYS_YES                      CONSTANT NUMBER := 1;
12    SYS_NO                       CONSTANT NUMBER := 2;
13 
14    G_SUCCESS                    CONSTANT NUMBER := 0;
15    G_WARNING                    CONSTANT NUMBER := 1;
16    G_ERROR                      CONSTANT NUMBER := 2;
17 
18 
19    -- ============ Task Control ================
20 
21    PIPE_TIME_OUT         CONSTANT NUMBER := 30;      -- 30 secs
22    START_TIME            DATE;
23 
24 
25 
26    -- ================== Worker Status ===================
27 
28     OK                    		CONSTANT NUMBER := 1;
29     FAIL                  		CONSTANT NUMBER := 0;
30 
31    --  ================= Procedures ====================
32    PROCEDURE LAUNCH_MONITOR( ERRBUF          OUT NOCOPY VARCHAR2,
33 	         RETCODE                     OUT NOCOPY NUMBER,
34 	         p_instance_id               IN  NUMBER DEFAULT NULL,
35 	         p_timeout                   IN  NUMBER,
36                  p_path_separator            IN  VARCHAR2 DEFAULT '/',
37                  p_ctl_file_path             IN  VARCHAR2,
38 	         p_directory_path            IN  VARCHAR2,
39 	         p_total_worker_num          IN  NUMBER,
40 	         p_calendars                 IN  VARCHAR2 DEFAULT NULL,
41 	         p_workday_patterns          IN  VARCHAR2 DEFAULT NULL,
42 	         p_shift_times               IN  VARCHAR2 DEFAULT NULL,
43 	         p_calendar_exceptions       IN  VARCHAR2 DEFAULT NULL,
44 	         p_shift_exceptions          IN  VARCHAR2 DEFAULT NULL,
45                  p_demand_class              IN  VARCHAR2 DEFAULT NULL,
46 	         p_trading_partners          IN  VARCHAR2 DEFAULT NULL,
47 	         p_trading_partner_sites     IN  VARCHAR2 DEFAULT NULL,
48                  p_price_list                IN  VARCHAR2 DEFAULT NULL,
49                  p_category_set              IN  VARCHAR2 DEFAULT NULL,
50                  p_items                     IN  VARCHAR2 DEFAULT NULL,
51                  p_item_categories           IN  VARCHAR2 DEFAULT NULL,
52                  p_bom_headers               IN  VARCHAR2 DEFAULT NULL,
53                  p_bom_components            IN  VARCHAR2 DEFAULT NULL,
54                  p_uom                       IN  VARCHAR2 DEFAULT NULL,
55                  p_uom_conv                  IN  VARCHAR2 DEFAULT NULL,
56                  p_currency_conv             IN  VARCHAR2 DEFAULT NULL,
57                  p_setup_parameters          IN  VARCHAR2 DEFAULT NULL,
58                  p_fiscal_cal                IN  VARCHAR2 DEFAULT NULL,
59                  p_composite_cal             IN  VARCHAR2 DEFAULT NULL,
60 	         p_level_value               IN  VARCHAR2 DEFAULT NULL,
61 	         p_level_associations        IN  VARCHAR2 DEFAULT NULL,
62                  p_booking_data              IN  VARCHAR2 DEFAULT NULL,
63                  p_shipment_data             IN  VARCHAR2 DEFAULT NULL,
64                  p_mfg_forecast              IN  VARCHAR2 DEFAULT NULL,
65                  p_cs_data                   IN  VARCHAR2 DEFAULT NULL,
66                  p_level_org_asscns          IN  VARCHAR2 DEFAULT NULL,
67                  p_item_relationships        IN  VARCHAR2 DEFAULT NULL,
68                  p_sales_history             IN  VARCHAR2 DEFAULT NULL,
69                  p_auto_run_download         IN  NUMBER   DEFAULT NULL,
70                  p_install_base_history      IN  VARCHAR2 DEFAULT NULL,
71 		 p_fld_ser_usg_history       IN  VARCHAR2 DEFAULT NULL,
72 		 p_dpt_rep_usg_history       IN  VARCHAR2 DEFAULT NULL,
73 		 p_ser_part_ret_history      IN  VARCHAR2 DEFAULT NULL,
74 		 p_failure_rates             IN  VARCHAR2 DEFAULT NULL,
75                  p_prd_ret_history           IN  VARCHAR2 DEFAULT NULL,
76                  p_forecast_data             IN  VARCHAR2 DEFAULT NULL);
77 
78 
79 
80 END MSD_CL_LOADERS;