[Home] [Help]
PACKAGE: APPS.MSC_CL_LOADERS
Source
1 PACKAGE MSC_CL_LOADERS AUTHID CURRENT_USER AS
2 /* $Header: MSCCLLDS.pls 120.7 2012/03/12 13:20:47 ramepai 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 -- NULL VALUE USED IN THE WHERE CLAUSE
19
20 NULL_DATE CONSTANT DATE:= SYSDATE-36500;
21 NULL_VALUE CONSTANT NUMBER:= -23453; -- null value for positive number
22 NULL_CHAR CONSTANT VARCHAR2(6):= '-23453';
23
24 -- ============ Task Control ================
25
26 PIPE_TIME_OUT CONSTANT NUMBER := 30; -- 30 secs
27 START_TIME DATE;
28
29
30
31 -- ================== Worker Status ===================
32
33 OK CONSTANT NUMBER := 1;
34 FAIL CONSTANT NUMBER := 0;
35
36 -- ================= Procedures ====================
37 PROCEDURE LAUNCH_MONITOR( ERRBUF OUT NOCOPY VARCHAR2,
38 RETCODE OUT NOCOPY NUMBER,
39 p_timeout IN NUMBER,
40 p_path_separator IN VARCHAR2 DEFAULT '/',
41 p_ctl_file_path IN VARCHAR2,
42 p_directory_path IN VARCHAR2,
43 p_total_worker_num IN NUMBER,
44 p_demand_class IN VARCHAR2 DEFAULT NULL,
45 p_bom_headers IN VARCHAR2 DEFAULT NULL,
46 p_bom_components IN VARCHAR2 DEFAULT NULL,
47 p_bom_comp_subs IN VARCHAR2 DEFAULT NULL,
48 p_items IN VARCHAR2 DEFAULT NULL,
49 p_routing_headers IN VARCHAR2 DEFAULT NULL,
50 p_routing_ops IN VARCHAR2 DEFAULT NULL,
51 p_routing_op_resources IN VARCHAR2 DEFAULT NULL,
52 p_resource_groups IN VARCHAR2 DEFAULT NULL,
53 p_dept_resources IN VARCHAR2 DEFAULT NULL,
54 p_resource_changes IN VARCHAR2 DEFAULT NULL,
55 p_resource_shifts IN VARCHAR2 DEFAULT NULL,
56 p_project_tasks IN VARCHAR2 DEFAULT NULL,
57 p_uoms IN VARCHAR2 DEFAULT NULL,
58 p_uom_class_convs IN VARCHAR2 DEFAULT NULL,
59 p_uom_convs IN VARCHAR2 DEFAULT NULL,
60 p_category_sets IN VARCHAR2 DEFAULT NULL,
61 p_item_categories IN VARCHAR2 DEFAULT NULL,
62 p_item_sourcings IN VARCHAR2 DEFAULT NULL,
63 p_calendars IN VARCHAR2 DEFAULT NULL,
64 p_workday_patterns IN VARCHAR2 DEFAULT NULL,
65 p_shift_times IN VARCHAR2 DEFAULT NULL,
66 p_calendar_exceptions IN VARCHAR2 DEFAULT NULL,
67 p_shift_exceptions IN VARCHAR2 DEFAULT NULL,
68 p_resource_requirements IN VARCHAR2 DEFAULT NULL,
69 p_item_suppliers IN VARCHAR2 DEFAULT NULL,
70 p_supplier_capacities IN VARCHAR2 DEFAULT NULL,
71 p_supplier_flexFences IN VARCHAR2 DEFAULT NULL,
72 p_safety_stocks IN VARCHAR2 DEFAULT NULL,
73 p_trading_partners IN VARCHAR2 DEFAULT NULL,
74 p_trading_partner_sites IN VARCHAR2 DEFAULT NULL,
75 p_loc_associations IN VARCHAR2 DEFAULT NULL,
76 p_sub_inventories IN VARCHAR2 DEFAULT NULL,
77 p_partner_contacts IN VARCHAR2 DEFAULT NULL,
78 p_ship_methods IN VARCHAR2 DEFAULT NULL,
79 p_supply_work_order IN VARCHAR2 DEFAULT NULL,
80 p_supply_requisitions IN VARCHAR2 DEFAULT NULL,
81 p_supply_onhand IN VARCHAR2 DEFAULT NULL,
82 p_supply_intransit IN VARCHAR2 DEFAULT NULL,
83 p_supply_PO IN VARCHAR2 DEFAULT NULL,
84 p_planOrder_designators IN VARCHAR2 DEFAULT NULL,
85 p_supply_plan_orders IN VARCHAR2 DEFAULT NULL,
86 p_supply_ASN IN VARCHAR2 DEFAULT NULL,
87 p_demand_SO IN VARCHAR2 DEFAULT NULL,
88 p_forecast_designators IN VARCHAR2 DEFAULT NULL,
89 p_demand_forecast IN VARCHAR2 DEFAULT NULL,
90 p_MDS_designators IN VARCHAR2 DEFAULT NULL,
91 p_demand_MDS IN VARCHAR2 DEFAULT NULL,
92 p_demand_WO_component IN VARCHAR2 DEFAULT NULL,
93 -- p_demand_flow_component IN VARCHAR2 DEFAULT NULL,
94 p_reservations IN VARCHAR2 DEFAULT NULL,
95 p_item_cst IN VARCHAR2 DEFAULT NULL,
96 p_sce_supp_dem IN VARCHAR2 DEFAULT NULL,
97 p_sce_comp_users IN VARCHAR2 DEFAULT NULL,
98 p_item_substitute IN VARCHAR2 DEFAULT NULL, -- Product Item Substitue
99 p_planners IN VARCHAR2 DEFAULT NULL,
100 p_operation_networks IN VARCHAR2 DEFAULT NULL,-- Operation Networks (OSFM)
101 p_co_products IN VARCHAR2 DEFAULT NULL,-- Co Products (OSFM)
102 p_ret_fcst IN VARCHAR2 DEFAULT NULL,
103
104 p_job_op_network IN VARCHAR2 DEFAULT NULL, -- Lot based Job details (OSFM)
105 p_job_operations IN VARCHAR2 DEFAULT NULL,
106 p_job_req_ops IN VARCHAR2 DEFAULT NULL,
107 p_job_op_resources IN VARCHAR2 DEFAULT NULL,
108 p_profiles IN VARCHAR2 DEFAULT NULL, -- profiles
109 p_calendar_assignments IN VARCHAR2 DEFAULT NULL, -- Calendar Assignment
110 p_regions IN VARCHAR2 DEFAULT NULL, -- Regions
111 p_zone_regions IN VARCHAR2 DEFAULT NULL,
112 p_region_locations IN VARCHAR2 DEFAULT NULL,
113 p_region_sites IN VARCHAR2 DEFAULT NULL,
114 p_iro_supplies IN VARCHAR2 DEFAULT NULL,
115 p_iro_demand IN VARCHAR2 DEFAULT NULL,
116 p_ero_supplies IN VARCHAR2 DEFAULT NULL,
117 p_ero_demand IN VARCHAR2 DEFAULT NULL,
118 p_sales_channel IN VARCHAR2 DEFAULT NULL,
119 p_fiscal_calendar IN VARCHAR2 DEFAULT NULL,
120
121 p_visits IN VARCHAR2 DEFAULT NULL,
122 p_milestones IN VARCHAR2 DEFAULT NULL,
123 p_WBS IN VARCHAR2 DEFAULT NULL,
124 p_WO_Attributes IN VARCHAR2 DEFAULT NULL,
125 p_WO_task_hierarchy IN VARCHAR2 DEFAULT NULL,
126 p_WO_operation_rel IN VARCHAR2 DEFAULT NULL); --- CMRO Proj bug 9135694
127
128
129 END MSC_CL_LOADERS;