[Home] [Help]
PACKAGE: APPS.FA_MAINTENANCE_PKG
Source
1 PACKAGE FA_MAINTENANCE_PKG as
2 /* $Header: FAXMTSCS.pls 120.2 2004/06/23 20:44:28 lson ship $ */
3
4
5 TYPE event_rec_type is RECORD
6 (
7 SCHEDULE_ID NUMBER(15),
8 EVENT_NAME VARCHAR2(50),
9 DESCRIPTION VARCHAR2(80),
10 FREQUENCY_IN_DAYS NUMBER(15),
11 MAINTENANCE_DATE DATE,
12 COST NUMBER,
13 EMPLOYEE_ID NUMBER(15),
14 VENDOR_ID NUMBER(15),
15 created_by number(15),
16 creation_date date,
17 last_updated_by number(15),
18 last_update_login number(15),
19 last_update_date date,
20 attribute1 varchar2(150),
21 attribute2 varchar2(150),
22 attribute3 varchar2(150),
23 attribute4 varchar2(150),
24 attribute5 varchar2(150),
25 attribute6 varchar2(150),
26 attribute7 varchar2(150),
27 attribute8 varchar2(150),
28 attribute9 varchar2(150),
29 attribute10 varchar2(150),
30 attribute11 varchar2(150),
31 attribute12 varchar2(150),
32 attribute13 varchar2(150),
33 attribute14 varchar2(150),
34 attribute15 varchar2(150),
35 attribute_category varchar2(30)
36 );
37
38
39 TYPE events_tbl_type is TABLE OF event_rec_type
40 INDEX BY BINARY_INTEGER;
41
42
43 procedure do_schedule(
44 errbuf out nocopy varchar2,
45 retcode out nocopy varchar2,
46 argument1 in varchar2, -- schedule_id
47 argument2 in varchar2 default null,
48 argument3 in varchar2 default null,
49 argument4 in varchar2 default null,
50 argument5 in varchar2 default null,
51 argument6 in varchar2 default null,
52 argument7 in varchar2 default null,
53 argument8 in varchar2 default null,
54 argument9 in varchar2 default null,
55 argument10 in varchar2 default null,
56 argument11 in varchar2 default null,
57 argument12 in varchar2 default null,
58 argument13 in varchar2 default null,
59 argument14 in varchar2 default null,
60 argument15 in varchar2 default null,
61 argument16 in varchar2 default null,
62 argument17 in varchar2 default null,
63 argument18 in varchar2 default null,
64 argument19 in varchar2 default null,
65 argument20 in varchar2 default null,
66 argument21 in varchar2 default null,
67 argument22 in varchar2 default null,
68 argument23 in varchar2 default null,
69 argument24 in varchar2 default null,
70 argument25 in varchar2 default null,
71 argument26 in varchar2 default null,
72 argument27 in varchar2 default null,
73 argument28 in varchar2 default null,
74 argument29 in varchar2 default null,
75 argument30 in varchar2 default null,
76 argument31 in varchar2 default null,
77 argument32 in varchar2 default null,
78 argument33 in varchar2 default null,
79 argument34 in varchar2 default null,
80 argument35 in varchar2 default null,
81 argument36 in varchar2 default null,
82 argument37 in varchar2 default null,
83 argument38 in varchar2 default null,
84 argument39 in varchar2 default null,
85 argument40 in varchar2 default null,
86 argument41 in varchar2 default null,
87 argument42 in varchar2 default null,
88 argument43 in varchar2 default null,
89 argument44 in varchar2 default null,
90 argument45 in varchar2 default null,
91 argument46 in varchar2 default null,
92 argument47 in varchar2 default null,
93 argument48 in varchar2 default null,
94 argument49 in varchar2 default null,
95 argument50 in varchar2 default null,
96 argument51 in varchar2 default null,
97 argument52 in varchar2 default null,
98 argument53 in varchar2 default null,
99 argument54 in varchar2 default null,
100 argument55 in varchar2 default null,
101 argument56 in varchar2 default null,
102 argument57 in varchar2 default null,
103 argument58 in varchar2 default null,
104 argument59 in varchar2 default null,
105 argument60 in varchar2 default null,
106 argument61 in varchar2 default null,
107 argument62 in varchar2 default null,
108 argument63 in varchar2 default null,
109 argument64 in varchar2 default null,
110 argument65 in varchar2 default null,
111 argument66 in varchar2 default null,
112 argument67 in varchar2 default null,
113 argument68 in varchar2 default null,
114 argument69 in varchar2 default null,
115 argument70 in varchar2 default null,
116 argument71 in varchar2 default null,
117 argument72 in varchar2 default null,
118 argument73 in varchar2 default null,
119 argument74 in varchar2 default null,
120 argument75 in varchar2 default null,
121 argument76 in varchar2 default null,
122 argument77 in varchar2 default null,
123 argument78 in varchar2 default null,
124 argument79 in varchar2 default null,
125 argument80 in varchar2 default null,
126 argument81 in varchar2 default null,
127 argument82 in varchar2 default null,
128 argument83 in varchar2 default null,
129 argument84 in varchar2 default null,
130 argument85 in varchar2 default null,
131 argument86 in varchar2 default null,
132 argument87 in varchar2 default null,
133 argument88 in varchar2 default null,
134 argument89 in varchar2 default null,
135 argument90 in varchar2 default null,
136 argument91 in varchar2 default null,
137 argument92 in varchar2 default null,
138 argument93 in varchar2 default null,
139 argument94 in varchar2 default null,
140 argument95 in varchar2 default null,
141 argument96 in varchar2 default null,
142 argument97 in varchar2 default null,
143 argument98 in varchar2 default null,
144 argument99 in varchar2 default null,
145 argument100 in varchar2 default null);
146
147 procedure upd_status(
148 p_sch_id in number,
149 p_msg_name in varchar2);
150
151 procedure insert_to_fa_maint_events(
152 p_asset_id in number,
153 p_book_type_code in varchar2,
154 p_event_rec in event_rec_type,
155 p_maint_date in date,
156 p_succeed out nocopy boolean);
157
158 procedure load_events_records(
159 p_schedule_id in number,
160 p_events_tbl in out nocopy events_tbl_type,
161 p_succeed out nocopy boolean);
162
163 END FA_MAINTENANCE_PKG;