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_ROUTES_PKG

Source


1 package AHL_ROUTES_PKG as
2 /* $Header: AHLLROUS.pls 120.0.12010000.3 2008/11/23 14:23:56 bachandr ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ROUTE_ID in NUMBER,
6   X_QA_INSPECTION_TYPE in VARCHAR2,
7   X_ENABLED_FLAG in VARCHAR2,
8   X_SUMMARY_FLAG in VARCHAR2,
9   X_START_DATE_ACTIVE in DATE,
10   X_END_DATE_ACTIVE in DATE,
11   X_SEGMENT15 in VARCHAR2,
12   X_OPERATOR_PARTY_ID in NUMBER,
13   X_TIME_SPAN in NUMBER,
14   X_SERVICE_ITEM_ID in NUMBER,
15   X_SERVICE_ITEM_ORG_ID in NUMBER,
16   X_TASK_TEMPLATE_GROUP_ID in NUMBER,
17   X_ACCOUNTING_CLASS_CODE in VARCHAR2,
18   X_ACCOUNTING_CLASS_ORG_ID in NUMBER,
19   X_SUB_ZONE_CODE in VARCHAR2,
20   X_SEGMENT1 in VARCHAR2,
21   X_SEGMENT2 in VARCHAR2,
22   X_SEGMENT3 in VARCHAR2,
23   X_SEGMENT4 in VARCHAR2,
24   X_SEGMENT5 in VARCHAR2,
25   X_SEGMENT6 in VARCHAR2,
26   X_SEGMENT7 in VARCHAR2,
27   X_SEGMENT8 in VARCHAR2,
28   X_SEGMENT9 in VARCHAR2,
29   X_SEGMENT10 in VARCHAR2,
30   X_SEGMENT11 in VARCHAR2,
31   X_SEGMENT12 in VARCHAR2,
32   X_SEGMENT13 in VARCHAR2,
33   X_SEGMENT14 in VARCHAR2,
34   X_OBJECT_VERSION_NUMBER in NUMBER,
35   X_ROUTE_NO in VARCHAR2,
36   X_APPLICATION_USG_CODE  IN  VARCHAR2,
37   X_REVISION_NUMBER in NUMBER,
38   X_REVISION_STATUS_CODE in VARCHAR2,
39   X_UNIT_RECEIPT_UPDATE_FLAG in VARCHAR2,
40   X_PRODUCT_TYPE_CODE in VARCHAR2,
41   --bachandr Enigma Phase I changes -- start
42   X_MODEL_CODE in VARCHAR2,
43   X_ENIGMA_PUBLISH_DATE in DATE,
44   X_ENIGMA_DOC_ID in VARCHAR2,
45   X_ENIGMA_ROUTE_ID in VARCHAR2,
46   X_FILE_ID in NUMBER,
47   --bachandr Enigma Phase I changes -- end
48   X_ZONE_CODE in VARCHAR2,
49   X_ROUTE_TYPE_CODE in VARCHAR2,
50   X_PROCESS_CODE in VARCHAR2,
51   X_ATTRIBUTE_CATEGORY in VARCHAR2,
52   X_ATTRIBUTE1 in VARCHAR2,
53   X_ATTRIBUTE2 in VARCHAR2,
54   X_ATTRIBUTE3 in VARCHAR2,
55   X_ATTRIBUTE4 in VARCHAR2,
56   X_ATTRIBUTE5 in VARCHAR2,
57   X_ATTRIBUTE6 in VARCHAR2,
58   X_ATTRIBUTE7 in VARCHAR2,
59   X_ATTRIBUTE8 in VARCHAR2,
60   X_ATTRIBUTE9 in VARCHAR2,
61   X_ATTRIBUTE10 in VARCHAR2,
62   X_ATTRIBUTE11 in VARCHAR2,
63   X_ATTRIBUTE12 in VARCHAR2,
64   X_ATTRIBUTE13 in VARCHAR2,
65   X_ATTRIBUTE14 in VARCHAR2,
66   X_ATTRIBUTE15 in VARCHAR2,
67   X_TITLE in VARCHAR2,
68   X_REMARKS in VARCHAR2,
69   X_REVISION_NOTES in VARCHAR2,
70   X_CREATION_DATE in DATE,
71   X_CREATED_BY in NUMBER,
72   X_LAST_UPDATE_DATE in DATE,
73   X_LAST_UPDATED_BY in NUMBER,
74   X_LAST_UPDATE_LOGIN in NUMBER);
75 procedure LOCK_ROW (
76   X_ROUTE_ID in NUMBER,
77   X_QA_INSPECTION_TYPE in VARCHAR2,
78   X_ENABLED_FLAG in VARCHAR2,
79   X_SUMMARY_FLAG in VARCHAR2,
80   X_START_DATE_ACTIVE in DATE,
81   X_END_DATE_ACTIVE in DATE,
82   X_SEGMENT15 in VARCHAR2,
83   X_OPERATOR_PARTY_ID in NUMBER,
84   X_TIME_SPAN in NUMBER,
85   X_SERVICE_ITEM_ID in NUMBER,
86   X_SERVICE_ITEM_ORG_ID in NUMBER,
87   X_TASK_TEMPLATE_GROUP_ID in NUMBER,
88   X_ACCOUNTING_CLASS_CODE in VARCHAR2,
89   X_ACCOUNTING_CLASS_ORG_ID in NUMBER,
90   X_SUB_ZONE_CODE in VARCHAR2,
91   X_SEGMENT1 in VARCHAR2,
92   X_SEGMENT2 in VARCHAR2,
93   X_SEGMENT3 in VARCHAR2,
94   X_SEGMENT4 in VARCHAR2,
95   X_SEGMENT5 in VARCHAR2,
96   X_SEGMENT6 in VARCHAR2,
97   X_SEGMENT7 in VARCHAR2,
98   X_SEGMENT8 in VARCHAR2,
99   X_SEGMENT9 in VARCHAR2,
100   X_SEGMENT10 in VARCHAR2,
101   X_SEGMENT11 in VARCHAR2,
102   X_SEGMENT12 in VARCHAR2,
103   X_SEGMENT13 in VARCHAR2,
104   X_SEGMENT14 in VARCHAR2,
105   X_OBJECT_VERSION_NUMBER in NUMBER,
106   X_ROUTE_NO in VARCHAR2,
107   X_APPLICATION_USG_CODE  IN  VARCHAR2,
108   X_REVISION_NUMBER in NUMBER,
109   X_REVISION_STATUS_CODE in VARCHAR2,
110   X_UNIT_RECEIPT_UPDATE_FLAG in VARCHAR2,
111   X_PRODUCT_TYPE_CODE in VARCHAR2,
112   --bachandr Enigma Phase I changes -- start
113   X_MODEL_CODE in VARCHAR2,
114   --bachandr Enigma Phase I changes -- end
115   X_ZONE_CODE in VARCHAR2,
116   X_ROUTE_TYPE_CODE in VARCHAR2,
117   X_PROCESS_CODE in VARCHAR2,
118   X_ATTRIBUTE_CATEGORY in VARCHAR2,
119   X_ATTRIBUTE1 in VARCHAR2,
120   X_ATTRIBUTE2 in VARCHAR2,
121   X_ATTRIBUTE3 in VARCHAR2,
122   X_ATTRIBUTE4 in VARCHAR2,
123   X_ATTRIBUTE5 in VARCHAR2,
124   X_ATTRIBUTE6 in VARCHAR2,
125   X_ATTRIBUTE7 in VARCHAR2,
126   X_ATTRIBUTE8 in VARCHAR2,
127   X_ATTRIBUTE9 in VARCHAR2,
128   X_ATTRIBUTE10 in VARCHAR2,
129   X_ATTRIBUTE11 in VARCHAR2,
130   X_ATTRIBUTE12 in VARCHAR2,
131   X_ATTRIBUTE13 in VARCHAR2,
132   X_ATTRIBUTE14 in VARCHAR2,
133   X_ATTRIBUTE15 in VARCHAR2,
134   X_TITLE in VARCHAR2,
135   X_REMARKS in VARCHAR2,
136   X_REVISION_NOTES in VARCHAR2
137 );
138 procedure UPDATE_ROW (
139   X_ROUTE_ID in NUMBER,
140   X_QA_INSPECTION_TYPE in VARCHAR2,
141   X_ENABLED_FLAG in VARCHAR2,
142   X_SUMMARY_FLAG in VARCHAR2,
143   X_START_DATE_ACTIVE in DATE,
144   X_END_DATE_ACTIVE in DATE,
145   X_SEGMENT15 in VARCHAR2,
146   X_OPERATOR_PARTY_ID in NUMBER,
147   X_TIME_SPAN in NUMBER,
148   X_SERVICE_ITEM_ID in NUMBER,
149   X_SERVICE_ITEM_ORG_ID in NUMBER,
150   X_TASK_TEMPLATE_GROUP_ID in NUMBER,
151   X_ACCOUNTING_CLASS_CODE in VARCHAR2,
152   X_ACCOUNTING_CLASS_ORG_ID in NUMBER,
153   X_SUB_ZONE_CODE in VARCHAR2,
154   X_SEGMENT1 in VARCHAR2,
155   X_SEGMENT2 in VARCHAR2,
156   X_SEGMENT3 in VARCHAR2,
157   X_SEGMENT4 in VARCHAR2,
158   X_SEGMENT5 in VARCHAR2,
159   X_SEGMENT6 in VARCHAR2,
160   X_SEGMENT7 in VARCHAR2,
161   X_SEGMENT8 in VARCHAR2,
162   X_SEGMENT9 in VARCHAR2,
163   X_SEGMENT10 in VARCHAR2,
164   X_SEGMENT11 in VARCHAR2,
165   X_SEGMENT12 in VARCHAR2,
166   X_SEGMENT13 in VARCHAR2,
167   X_SEGMENT14 in VARCHAR2,
168   X_OBJECT_VERSION_NUMBER in NUMBER,
169   X_ROUTE_NO in VARCHAR2,
170   X_REVISION_NUMBER in NUMBER,
171   X_REVISION_STATUS_CODE in VARCHAR2,
172   X_UNIT_RECEIPT_UPDATE_FLAG in VARCHAR2,
173   X_PRODUCT_TYPE_CODE in VARCHAR2,
174   --bachandr Enigma Phase I changes -- start
175   X_MODEL_CODE in VARCHAR2,
176   X_FILE_ID in NUMBER,
177   --bachandr Enigma Phase I changes -- end
178   X_ZONE_CODE in VARCHAR2,
179   X_ROUTE_TYPE_CODE in VARCHAR2,
180   X_PROCESS_CODE in VARCHAR2,
181   X_ATTRIBUTE_CATEGORY in VARCHAR2,
182   X_ATTRIBUTE1 in VARCHAR2,
183   X_ATTRIBUTE2 in VARCHAR2,
184   X_ATTRIBUTE3 in VARCHAR2,
185   X_ATTRIBUTE4 in VARCHAR2,
186   X_ATTRIBUTE5 in VARCHAR2,
187   X_ATTRIBUTE6 in VARCHAR2,
188   X_ATTRIBUTE7 in VARCHAR2,
189   X_ATTRIBUTE8 in VARCHAR2,
190   X_ATTRIBUTE9 in VARCHAR2,
191   X_ATTRIBUTE10 in VARCHAR2,
192   X_ATTRIBUTE11 in VARCHAR2,
193   X_ATTRIBUTE12 in VARCHAR2,
194   X_ATTRIBUTE13 in VARCHAR2,
195   X_ATTRIBUTE14 in VARCHAR2,
196   X_ATTRIBUTE15 in VARCHAR2,
197   X_TITLE in VARCHAR2,
198   X_REMARKS in VARCHAR2,
199   X_REVISION_NOTES in VARCHAR2,
200   X_LAST_UPDATE_DATE in DATE,
201   X_LAST_UPDATED_BY in NUMBER,
202   X_LAST_UPDATE_LOGIN in NUMBER
203 );
204 procedure DELETE_ROW (
205   X_ROUTE_ID in NUMBER
206 );
207 procedure ADD_LANGUAGE;
208 end AHL_ROUTES_PKG;