1 PACKAGE BODY EAM_PM_ENGINE AS
2 /* $Header: EAMPMEGB.pls 120.3 2006/03/16 02:33:28 kmurthy ship $ */
3
4 /**
5 * This is a wrapper on top of the Java stored procedure to invoke the pm scheduler.
6 */
7 procedure run_pm_scheduler(runMode in number,
8 nonSched in varchar2,
9 startDate in date,
10 endDate in date,
11 groupID in number,
12 orgID in number,
13 userID in number,
14 locationID in number,
15 categoryID in number,
16 deptID in number,
17 itemType in number,
18 theAssetGroupID in number,
19 assetNumber in varchar2,
20 p_set_name_id in number ) as
21 language java name 'oracle.apps.eam.pm.scheduling.PMEngine.execute(
22 java.lang.Integer,
23 java.lang.String,
24 java.sql.Timestamp,
25 java.sql.Timestamp,
26 java.lang.Long,
27 java.lang.Long,
28 java.lang.Long,
29 java.lang.Long,
30 java.lang.Long,
31 java.lang.Long,
32 java.lang.Long,
33 java.lang.Long,
34 java.lang.String,
35 java.lang.Long )';
36
37
38 /**
39 * This is a wrapper on top of the Java stored procedure to invoke the pm scheduler to
40 * do the forecast for a given set of asset numbers only.
41 */
42 function do_forecast(nonSched in varchar2,
43 startDate in date,
44 endDate in date,
45 orgID in number,
46 userID in number,
47 selectStmt in varchar2,
48 setname_id in number,
49 combine_default in varchar2) return number as
50 language java name 'oracle.apps.eam.pm.scheduling.PMEngine.forecastWorkOrders(
51 java.lang.String,
52 java.sql.Timestamp,
53 java.sql.Timestamp,
54 long,
55 long,
56 java.lang.String,
57 long,
58 java.lang.String) return long';
59
60 procedure do_forecast2(nonSched in varchar2,
61 startDate in date,
62 endDate in date,
63 orgID in number,
64 userID in number,
65 selectStmt in varchar2,
66 setname_id in number,
67 combine_default in varchar2,
68 group_id in number,
69 source_button in varchar2
70 ) as
71 language java name 'oracle.apps.eam.pm.scheduling.PMEngine.forecastWorkOrders2(
72 java.lang.String,
73 java.sql.Timestamp,
74 java.sql.Timestamp,
75 long,
76 long,
77 java.lang.String,
78 java.lang.Long,
79 java.lang.String,
80 long,
81 java.lang.String)';
82
83 procedure do_forecast3(nonSched in varchar2,
84 startDate in date,
85 endDate in date,
86 orgID in number,
87 userID in number,
88 objectID in number,
89 objectType in number,
90 setname_id in number,
91 combine_default in varchar2,
92 group_id in number) as
93 language java name 'oracle.apps.eam.pm.scheduling.PMEngine.forecastWorkOrders3(
94 java.lang.String,
95 java.sql.Timestamp,
96 java.sql.Timestamp,
97 long,
98 long,
99 long,
100 int,
101 long,
102 java.lang.String,
103 long)';
104
105 END eam_pm_engine;