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_VISIT_TASKS_PKG

Source


1 PACKAGE AHL_VISIT_TASKS_PKG AUTHID CURRENT_USER as
2 /* $Header: AHLLTSKS.pls 120.3.12020000.2 2012/12/06 23:47:17 sareepar ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_VISIT_TASK_ID in NUMBER,
6   X_DEPARTMENT_ID in NUMBER,
7   X_PRICE_LIST_ID in NUMBER,
8   X_STATUS_CODE in VARCHAR2,
9   X_ESTIMATED_PRICE in NUMBER,
10   X_ACTUAL_PRICE in NUMBER,
11   X_ACTUAL_COST in NUMBER,
12   X_STAGE_ID in NUMBER,
13   X_END_DATE_TIME in DATE,
14   X_START_DATE_TIME in DATE,
15   --SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Add past dates too
16   X_PAST_TASK_START_DATE in DATE,
17   X_PAST_TASK_END_DATE in DATE,
18   X_INVENTORY_ITEM_ID in NUMBER,
19   X_INSTANCE_ID in NUMBER,
20   X_PRIMARY_VISIT_TASK_ID in NUMBER,
21   X_SUMMARY_TASK_FLAG in VARCHAR2,
22   X_ORIGINATING_TASK_ID in NUMBER,
23   X_VISIT_TASK_NUMBER in NUMBER,
24   X_ITEM_ORGANIZATION_ID in NUMBER,
25   X_SERVICE_REQUEST_ID in NUMBER,
26   X_TASK_TYPE_CODE in VARCHAR2,
27   -- AVIKUKUM :: FP:PIE ::13-OCT-2010 :: new SERVICE_TYPE_CODE attribute
28   X_SERVICE_TYPE_CODE in VARCHAR2,
29   -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063  :: Added below two more parameters
30   X_STAGE_TYPE_CODE IN VARCHAR2 := null,
31   X_RETURN_TO_SUPPLY_FLAG IN VARCHAR2 := 'N',
32   --VWPE :: tchimira :: 10-MAY -2011
33   X_ORIGINATING_MR_HEADER_ID IN NUMBER := NULL,
34   --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
35   X_TARGET_QTY in NUMBER := null,
36   X_ATTRIBUTE_CATEGORY in VARCHAR2,
37   X_ATTRIBUTE1 in VARCHAR2,
38   X_ATTRIBUTE2 in VARCHAR2,
39   X_ATTRIBUTE3 in VARCHAR2,
40   X_ATTRIBUTE4 in VARCHAR2,
41   X_ATTRIBUTE5 in VARCHAR2,
42   X_ATTRIBUTE6 in VARCHAR2,
43   X_ATTRIBUTE7 in VARCHAR2,
44   X_ATTRIBUTE8 in VARCHAR2,
45   X_ATTRIBUTE9 in VARCHAR2,
46   X_ATTRIBUTE10 in VARCHAR2,
47   X_ATTRIBUTE11 in VARCHAR2,
48   X_ATTRIBUTE12 in VARCHAR2,
49   X_ATTRIBUTE13 in VARCHAR2,
50   X_ATTRIBUTE14 in VARCHAR2,
51   X_ATTRIBUTE15 in VARCHAR2,
52   X_OBJECT_VERSION_NUMBER in NUMBER,
53   X_VISIT_ID in NUMBER,
54   X_PROJECT_TASK_ID in NUMBER,
55   X_COST_PARENT_ID in NUMBER,
56   X_MR_ROUTE_ID in NUMBER,
57   X_MR_ID in NUMBER,
58   X_DURATION in NUMBER,
59   X_UNIT_EFFECTIVITY_ID in NUMBER,
60   X_START_FROM_HOUR in NUMBER,
61   X_VISIT_TASK_NAME in VARCHAR2,
62   X_DESCRIPTION in VARCHAR2,
63   X_QUANTITY in NUMBER, -- Added by rnahata for Issue 105
64   X_CREATION_DATE in DATE,
65   X_CREATED_BY in NUMBER,
66   X_LAST_UPDATE_DATE in DATE,
67   X_LAST_UPDATED_BY in NUMBER,
68   X_LAST_UPDATE_LOGIN in NUMBER,
69   X_REPAIR_BATCH_NAME in VARCHAR2  := NULL  --PRAKKUM :: 11/06/2012 :: Bug 14068468
70   );
71 procedure LOCK_ROW (
72   X_VISIT_TASK_ID in NUMBER,
73   X_DEPARTMENT_ID in NUMBER,
74   X_PRICE_LIST_ID in NUMBER,
75   X_STATUS_CODE in VARCHAR2,
76   X_ESTIMATED_PRICE in NUMBER,
77   X_ACTUAL_PRICE in NUMBER,
78   X_ACTUAL_COST in NUMBER,
79   X_STAGE_ID in NUMBER,
80   X_END_DATE_TIME in DATE,
81   X_START_DATE_TIME in DATE,
82   --SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Add past dates too
83   X_PAST_TASK_START_DATE in DATE,
84   X_PAST_TASK_END_DATE in DATE,
85   X_INVENTORY_ITEM_ID in NUMBER,
86   X_INSTANCE_ID in NUMBER,
87   X_PRIMARY_VISIT_TASK_ID in NUMBER,
88   X_SUMMARY_TASK_FLAG in VARCHAR2,
89   X_ORIGINATING_TASK_ID in NUMBER,
90   X_VISIT_TASK_NUMBER in NUMBER,
91   X_ITEM_ORGANIZATION_ID in NUMBER,
92   X_SERVICE_REQUEST_ID in NUMBER,
93   X_TASK_TYPE_CODE in VARCHAR2,
94   -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
95   X_SERVICE_TYPE_CODE in VARCHAR2,
96   --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
97   X_TARGET_QTY in NUMBER,
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_VISIT_ID in NUMBER,
116   X_PROJECT_TASK_ID in NUMBER,
117   X_COST_PARENT_ID in NUMBER,
118   X_MR_ROUTE_ID in NUMBER,
119   X_MR_ID in NUMBER,
120   X_DURATION in NUMBER,
121   X_UNIT_EFFECTIVITY_ID in NUMBER,
122   X_START_FROM_HOUR in NUMBER,
123   X_VISIT_TASK_NAME in VARCHAR2,
124   X_DESCRIPTION in VARCHAR2
125 );
126 procedure UPDATE_ROW (
127   X_VISIT_TASK_ID in NUMBER,
128   X_DEPARTMENT_ID in NUMBER,
129   X_PRICE_LIST_ID in NUMBER,
130   X_STATUS_CODE in VARCHAR2,
131   X_ESTIMATED_PRICE in NUMBER,
132   X_ACTUAL_PRICE in NUMBER,
133   X_ACTUAL_COST in NUMBER,
134   X_STAGE_ID in NUMBER,
135   X_END_DATE_TIME in DATE,
136   X_START_DATE_TIME in DATE,
137   --SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Add past dates too
138   X_PAST_TASK_START_DATE in DATE,
139   X_PAST_TASK_END_DATE in DATE,
140   X_INVENTORY_ITEM_ID in NUMBER,
141   X_INSTANCE_ID in NUMBER,
142   X_PRIMARY_VISIT_TASK_ID in NUMBER,
143   X_SUMMARY_TASK_FLAG in VARCHAR2,
144   X_ORIGINATING_TASK_ID in NUMBER,
145   X_VISIT_TASK_NUMBER in NUMBER,
146   X_ITEM_ORGANIZATION_ID in NUMBER,
147   X_SERVICE_REQUEST_ID in NUMBER,
148   X_TASK_TYPE_CODE in VARCHAR2,
149   -- AVIKUKUM :: FP:PIE ::13-OCT-2010 :: new SERVICE_TYPE_CODE attribute
150   X_SERVICE_TYPE_CODE in VARCHAR2,
151   --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
152   X_TARGET_QTY in NUMBER,
153   X_ATTRIBUTE_CATEGORY in VARCHAR2,
154   X_ATTRIBUTE1 in VARCHAR2,
155   X_ATTRIBUTE2 in VARCHAR2,
156   X_ATTRIBUTE3 in VARCHAR2,
157   X_ATTRIBUTE4 in VARCHAR2,
158   X_ATTRIBUTE5 in VARCHAR2,
159   X_ATTRIBUTE6 in VARCHAR2,
160   X_ATTRIBUTE7 in VARCHAR2,
161   X_ATTRIBUTE8 in VARCHAR2,
162   X_ATTRIBUTE9 in VARCHAR2,
163   X_ATTRIBUTE10 in VARCHAR2,
164   X_ATTRIBUTE11 in VARCHAR2,
165   X_ATTRIBUTE12 in VARCHAR2,
166   X_ATTRIBUTE13 in VARCHAR2,
167   X_ATTRIBUTE14 in VARCHAR2,
168   X_ATTRIBUTE15 in VARCHAR2,
169   X_OBJECT_VERSION_NUMBER in NUMBER,
170   X_VISIT_ID in NUMBER,
171   X_PROJECT_TASK_ID in NUMBER,
172   X_COST_PARENT_ID in NUMBER,
173   X_MR_ROUTE_ID in NUMBER,
174   X_MR_ID in NUMBER,
175   X_DURATION in NUMBER,
176   X_UNIT_EFFECTIVITY_ID in NUMBER,
177   X_START_FROM_HOUR in NUMBER,
178   X_VISIT_TASK_NAME in VARCHAR2,
179   X_DESCRIPTION in VARCHAR2,
180   X_QUANTITY in NUMBER, -- Added by rnahata for Issue 105
181   X_LAST_UPDATE_DATE in DATE,
182   X_LAST_UPDATED_BY in NUMBER,
183   X_LAST_UPDATE_LOGIN in NUMBER
184 );
185 procedure DELETE_ROW (
186   X_VISIT_TASK_ID in NUMBER
187 );
188 procedure ADD_LANGUAGE;
189 end AHL_VISIT_TASKS_PKG;