[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;