eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AHL_UNIT_EFFECTIVITIES_PKG

Source


1 package AHL_UNIT_EFFECTIVITIES_PKG AUTHID CURRENT_USER as
2 /* $Header: AHLLUEFS.pls 120.2.12020000.2 2012/12/06 23:51:38 sareepar ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_UNIT_EFFECTIVITY_ID in out NOCOPY NUMBER,
6   X_MANUALLY_PLANNED_FLAG in VARCHAR2,
7   X_LOG_SERIES_CODE in VARCHAR2,
8   X_LOG_SERIES_NUMBER in NUMBER,
9   X_FLIGHT_NUMBER in VARCHAR2,
10   X_MEL_CDL_TYPE_CODE in VARCHAR2,
11   X_POSITION_PATH_ID in NUMBER,
12   X_ATA_CODE in VARCHAR2,
13   --X_CLEAR_STATION_ORG_ID in NUMBER,
14   --X_CLEAR_STATION_DEPT_ID in NUMBER,
15   X_UNIT_CONFIG_HEADER_ID in NUMBER,
16   X_QA_COLLECTION_ID in NUMBER,
17   X_CS_INCIDENT_ID in NUMBER,
18   X_OBJECT_TYPE in VARCHAR2,
19   X_APPLICATION_USG_CODE in VARCHAR2,
20   X_COUNTER_ID in NUMBER,
21   X_EARLIEST_DUE_DATE in DATE,
22   X_LATEST_DUE_DATE in DATE,
23   X_FORECAST_SEQUENCE in NUMBER,
24   X_REPETITIVE_MR_FLAG in VARCHAR2,
25   X_TOLERANCE_FLAG in VARCHAR2,
26   X_MESSAGE_CODE in VARCHAR2,
27   X_DATE_RUN in DATE,
28   X_PRECEDING_UE_ID in NUMBER,
29   X_SET_DUE_DATE in DATE,
30   X_ACCOMPLISHED_DATE in DATE,
31   X_SERVICE_LINE_ID in NUMBER,
32   X_PROGRAM_MR_HEADER_ID in NUMBER,
33   X_CANCEL_REASON_CODE in VARCHAR2,
34   X_ATTRIBUTE_CATEGORY in VARCHAR2,
35   X_ATTRIBUTE1 in VARCHAR2,
36   X_ATTRIBUTE2 in VARCHAR2,
37   X_ATTRIBUTE3 in VARCHAR2,
38   X_ATTRIBUTE4 in VARCHAR2,
39   X_ATTRIBUTE5 in VARCHAR2,
40   X_ATTRIBUTE6 in VARCHAR2,
41   X_ATTRIBUTE7 in VARCHAR2,
42   X_ATTRIBUTE8 in VARCHAR2,
43   X_ATTRIBUTE9 in VARCHAR2,
44   X_ATTRIBUTE10 in VARCHAR2,
45   X_ATTRIBUTE11 in VARCHAR2,
46   X_ATTRIBUTE12 in VARCHAR2,
47   X_ATTRIBUTE13 in VARCHAR2,
48   X_ATTRIBUTE14 in VARCHAR2,
49   X_ATTRIBUTE15 in VARCHAR2,
50   X_OBJECT_VERSION_NUMBER in NUMBER,
51   X_CSI_ITEM_INSTANCE_ID in NUMBER,
52   X_MR_HEADER_ID in NUMBER,
53   X_MR_EFFECTIVITY_ID in NUMBER,
54   X_MR_INTERVAL_ID in NUMBER,
55   X_STATUS_CODE in VARCHAR2,
56   X_DUE_DATE in DATE,
57   X_DUE_COUNTER_VALUE in NUMBER,
58   X_DEFER_FROM_UE_ID in NUMBER,
59   X_ORIG_DEFERRAL_UE_ID in NUMBER,
60   X_REMARKS in VARCHAR2,
61   X_CREATION_DATE in DATE,
62   X_CREATED_BY in NUMBER,
63   X_LAST_UPDATE_DATE in DATE,
64   X_LAST_UPDATED_BY in NUMBER,
65   X_LAST_UPDATE_LOGIN in NUMBER,
66   -- JKJain, NR Analysis and Forecasting
67   X_FLEET_HEADER_ID IN NUMBER := NULL);
68 procedure LOCK_ROW (
69   X_UNIT_EFFECTIVITY_ID in NUMBER,
70   X_MANUALLY_PLANNED_FLAG in VARCHAR2,
71   X_LOG_SERIES_CODE in VARCHAR2,
72   X_LOG_SERIES_NUMBER in NUMBER,
73   X_FLIGHT_NUMBER in VARCHAR2,
74   X_MEL_CDL_TYPE_CODE in VARCHAR2,
75   X_POSITION_PATH_ID in NUMBER,
76   X_ATA_CODE in VARCHAR2,
77   --X_CLEAR_STATION_ORG_ID in NUMBER,
78   --X_CLEAR_STATION_DEPT_ID in NUMBER,
79   X_UNIT_CONFIG_HEADER_ID in NUMBER,
80   X_QA_COLLECTION_ID in NUMBER,
81   X_CS_INCIDENT_ID in NUMBER,
82   X_OBJECT_TYPE in VARCHAR2,
83   X_APPLICATION_USG_CODE in VARCHAR2,
84   X_COUNTER_ID in NUMBER,
85   X_EARLIEST_DUE_DATE in DATE,
86   X_LATEST_DUE_DATE in DATE,
87   X_FORECAST_SEQUENCE in NUMBER,
88   X_REPETITIVE_MR_FLAG in VARCHAR2,
89   X_TOLERANCE_FLAG in VARCHAR2,
90   X_MESSAGE_CODE in VARCHAR2,
91   X_DATE_RUN in DATE,
92   X_PRECEDING_UE_ID in NUMBER,
93   X_SET_DUE_DATE in DATE,
94   X_ACCOMPLISHED_DATE in DATE,
95   X_SERVICE_LINE_ID in NUMBER,
96   X_PROGRAM_MR_HEADER_ID in NUMBER,
97   X_CANCEL_REASON_CODE in VARCHAR2,
98   X_ATTRIBUTE_CATEGORY in VARCHAR2,
99   X_ATTRIBUTE1 in VARCHAR2,
100   X_ATTRIBUTE2 in VARCHAR2,
101   X_ATTRIBUTE3 in VARCHAR2,
102   X_ATTRIBUTE4 in VARCHAR2,
103   X_ATTRIBUTE5 in VARCHAR2,
104   X_ATTRIBUTE6 in VARCHAR2,
105   X_ATTRIBUTE7 in VARCHAR2,
106   X_ATTRIBUTE8 in VARCHAR2,
107   X_ATTRIBUTE9 in VARCHAR2,
108   X_ATTRIBUTE10 in VARCHAR2,
109   X_ATTRIBUTE11 in VARCHAR2,
110   X_ATTRIBUTE12 in VARCHAR2,
111   X_ATTRIBUTE13 in VARCHAR2,
112   X_ATTRIBUTE14 in VARCHAR2,
113   X_ATTRIBUTE15 in VARCHAR2,
114   X_OBJECT_VERSION_NUMBER in NUMBER,
115   X_CSI_ITEM_INSTANCE_ID in NUMBER,
116   X_MR_HEADER_ID in NUMBER,
117   X_MR_EFFECTIVITY_ID in NUMBER,
118   X_MR_INTERVAL_ID in NUMBER,
119   X_STATUS_CODE in VARCHAR2,
120   X_DUE_DATE in DATE,
121   X_DUE_COUNTER_VALUE in NUMBER,
122   X_DEFER_FROM_UE_ID in NUMBER,
123   X_ORIG_DEFERRAL_UE_ID in NUMBER,
124   X_REMARKS in VARCHAR2
125 );
126 procedure UPDATE_ROW (
127   X_UNIT_EFFECTIVITY_ID in NUMBER,
128   X_MANUALLY_PLANNED_FLAG in VARCHAR2,
129   X_LOG_SERIES_CODE in VARCHAR2,
130   X_LOG_SERIES_NUMBER in NUMBER,
131   X_FLIGHT_NUMBER in VARCHAR2,
132   X_MEL_CDL_TYPE_CODE in VARCHAR2,
133   X_POSITION_PATH_ID in NUMBER,
134   X_ATA_CODE in VARCHAR2,
135   --X_CLEAR_STATION_ORG_ID in NUMBER,
136   --X_CLEAR_STATION_DEPT_ID in NUMBER,
137   X_UNIT_CONFIG_HEADER_ID in NUMBER,
138   X_QA_COLLECTION_ID in NUMBER,
139   X_CS_INCIDENT_ID in NUMBER,
140   X_OBJECT_TYPE in VARCHAR2,
141   X_APPLICATION_USG_CODE in VARCHAR2,
142   X_COUNTER_ID in NUMBER,
143   X_EARLIEST_DUE_DATE in DATE,
144   X_LATEST_DUE_DATE in DATE,
145   X_FORECAST_SEQUENCE in NUMBER,
146   X_REPETITIVE_MR_FLAG in VARCHAR2,
147   X_TOLERANCE_FLAG in VARCHAR2,
148   X_MESSAGE_CODE in VARCHAR2,
149   X_DATE_RUN in DATE,
150   X_PRECEDING_UE_ID in NUMBER,
151   X_SET_DUE_DATE in DATE,
152   X_ACCOMPLISHED_DATE in DATE,
153   X_SERVICE_LINE_ID in NUMBER,
154   X_PROGRAM_MR_HEADER_ID in NUMBER,
155   X_CANCEL_REASON_CODE in VARCHAR2,
156   X_ATTRIBUTE_CATEGORY in VARCHAR2,
157   X_ATTRIBUTE1 in VARCHAR2,
158   X_ATTRIBUTE2 in VARCHAR2,
159   X_ATTRIBUTE3 in VARCHAR2,
160   X_ATTRIBUTE4 in VARCHAR2,
161   X_ATTRIBUTE5 in VARCHAR2,
162   X_ATTRIBUTE6 in VARCHAR2,
163   X_ATTRIBUTE7 in VARCHAR2,
164   X_ATTRIBUTE8 in VARCHAR2,
165   X_ATTRIBUTE9 in VARCHAR2,
166   X_ATTRIBUTE10 in VARCHAR2,
167   X_ATTRIBUTE11 in VARCHAR2,
168   X_ATTRIBUTE12 in VARCHAR2,
169   X_ATTRIBUTE13 in VARCHAR2,
170   X_ATTRIBUTE14 in VARCHAR2,
171   X_ATTRIBUTE15 in VARCHAR2,
172   X_OBJECT_VERSION_NUMBER in NUMBER,
173   X_CSI_ITEM_INSTANCE_ID in NUMBER,
174   X_MR_HEADER_ID in NUMBER,
175   X_MR_EFFECTIVITY_ID in NUMBER,
176   X_MR_INTERVAL_ID in NUMBER,
177   X_STATUS_CODE in VARCHAR2,
178   X_DUE_DATE in DATE,
179   X_DUE_COUNTER_VALUE in NUMBER,
180   X_DEFER_FROM_UE_ID in NUMBER,
181   X_ORIG_DEFERRAL_UE_ID in NUMBER,
182   X_REMARKS in VARCHAR2,
183   X_LAST_UPDATE_DATE in DATE,
184   X_LAST_UPDATED_BY in NUMBER,
185   X_LAST_UPDATE_LOGIN in NUMBER,
186   -- JKJain, NR Analysis and Forecasting
187   X_FLEET_HEADER_ID IN NUMBER := NULL
188 );
189 procedure DELETE_ROW (
190   X_UNIT_EFFECTIVITY_ID in NUMBER
191 );
192 procedure ADD_LANGUAGE;
193 end AHL_UNIT_EFFECTIVITIES_PKG;