DBA Data[Home] [Help]

PACKAGE: APPS.EAM_ASSET_ACTIVITIES_PVT

Source


1 PACKAGE EAM_ASSET_ACTIVITIES_PVT AUTHID CURRENT_USER as
2 /* $Header: EAMVASOS.pls 120.0.12020000.2 2013/01/04 06:17:08 shengywa ship $ */
3  -- Start of comments
4  -- API name    : EAM_ASSET_ACTIVITIES_PVT
5  -- Type     : Private
6  -- Function :
7  -- Pre-reqs : None.
8  -- Parameters  :
9  -- IN       P_API_VERSION                 IN NUMBER       REQUIRED
10  --          P_INIT_MSG_LIST               IN VARCHAR2     OPTIONAL
11  --             DEFAULT = FND_API.G_FALSE
12  --          P_COMMIT                      IN VARCHAR2     OPTIONAL
13  --             DEFAULT = FND_API.G_FALSE
14  --          P_VALIDATION_LEVEL            IN NUMBER       OPTIONAL
15  --             DEFAULT = FND_API.G_VALID_LEVEL_FULL
16  --          P_ROWID                       IN OUT VARCHAR2 REQUIRED
17  --          P_ACTIVITY_ASSOCIATION_ID     IN OUT NUMBER   REQUIRED
18  --          P_ORGANIZATION_ID             IN  NUMBER      REQUIRED
19  --          P_ASSET_ACTIVITY_ID           IN  NUMBER      REQUIRED
20  --          P_INVENTORY_ITEM_ID           IN  NUMBER      REQUIRED
21  --          P_SERIAL_NUMBER               IN  VARCHAR2    OPTIONAL
22  --          P_START_DATE_ACTIVE           IN  DATE        OPTIONAL
23  --          P_END_DATE_ACTIVE             IN  DATE        OPTIONAL
24  --          P_PRIORITY_CODE               IN  VARCHAR2    OPTIONAL
25  --          P_ACTIVITY_CAUSE_CODE         IN  VARCHAR2    OPTIONAL
26  --          P_ACTIVITY_TYPE_CODE          IN  VARCHAR2    OPTIONAL
27  --          P_OWNING_DEPARTMENT_ID        IN  NUMBER      REQUIRED
28  --          P_LAST_UPDATE_DATE            IN  DATE        REQUIRED
29  --          P_LAST_UPDATED_BY             IN  NUMBER      REQUIRED
30  --          P_CREATION_DATE               IN  DATE        REQUIRED
31  --          P_CREATED_BY                  IN  NUMBER      REQUIRED
32  --          P_LAST_UPDATE_LOGIN           IN  NUMBER      REQUIRED
33  --          P_ATTRIBUTE_CATEGORY          IN  VARCHAR2    OPTIONAL
34  --          P_ATTRIBUTE1                  IN  VARCHAR2    OPTIONAL
35  --          P_ATTRIBUTE2                  IN  VARCHAR2    OPTIONAL
36  --          P_ATTRIBUTE3                  IN  VARCHAR2    OPTIONAL
37  --          P_ATTRIBUTE4                  IN  VARCHAR2    OPTIONAL
38  --          P_ATTRIBUTE5                  IN  VARCHAR2    OPTIONAL
39  --          P_ATTRIBUTE6                  IN  VARCHAR2    OPTIONAL
40  --          P_ATTRIBUTE7                  IN  VARCHAR2    OPTIONAL
41  --          P_ATTRIBUTE8                  IN  VARCHAR2    OPTIONAL
42  --          P_ATTRIBUTE9                  IN  VARCHAR2    OPTIONAL
43  --          P_ATTRIBUTE10                 IN  VARCHAR2    OPTIONAL
44  --          P_ATTRIBUTE11                 IN  VARCHAR2    OPTIONAL
45  --          P_ATTRIBUTE12                 IN  VARCHAR2    OPTIONAL
46  --          P_ATTRIBUTE13                 IN  VARCHAR2    OPTIONAL
47  --          P_ATTRIBUTE14                 IN  VARCHAR2    OPTIONAL
48  --          P_ATTRIBUTE15                 IN  VARCHAR2    OPTIONAL
49  --          P_REQUEST_ID                  IN  NUMBER DEFAULT NULL OPTIONAL
50  --          P_PROGRAM_APPLICATION_ID      IN  NUMBER DEFAULT NULL OPTIONAL
51  --          P_PROGRAM_ID                  IN  NUMBER DEFAULT NULL OPTIONAL
52  --          P_PROGRAM_UPDATE_DATE         IN  DATE DEFAULT NULL
53  -- OUT      X_RETURN_STATUS               OUT VARCHAR2(1)
54  --          X_MSG_COUNT                   OUT NUMBER
55  --          X_MSG_DATA                    OUT VARCHAR2(2000)
56  --
57  -- Version  Current version 115.0
58  --
59  -- Notes    : Note text
60  --
61  -- End of comments
62 
63 
64 PROCEDURE INSERT_ROW(
65   P_API_VERSION IN NUMBER,
66   P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
67   P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
68   P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69   P_ROWID                         IN OUT NOCOPY VARCHAR2,
70   P_ACTIVITY_ASSOCIATION_ID       IN OUT NOCOPY NUMBER,
71   P_ORGANIZATION_ID               NUMBER,
72   P_ASSET_ACTIVITY_ID             NUMBER,
73   P_INVENTORY_ITEM_ID             NUMBER,
74   P_SERIAL_NUMBER                 VARCHAR2,
75   P_START_DATE_ACTIVE             DATE,
76   P_END_DATE_ACTIVE               DATE,
77   P_PRIORITY_CODE                 VARCHAR2,
78   P_ACTIVITY_CAUSE_CODE           VARCHAR2,
79   P_ACTIVITY_TYPE_CODE            VARCHAR2,
80   P_ACTIVITY_SOURCE_CODE          VARCHAR2,
81   P_WORK_ORDER_TYPE               NUMBER,
82   P_PLANNER                       NUMBER,
83   P_FIRM                          IN  NUMBER,
84   P_PLANNED                       IN  VARCHAR2,
85   P_NOTIFICATION_REQUIRED         IN  VARCHAR2,
86   P_CLASS_CODE                    VARCHAR2,
87   P_OWNING_DEPARTMENT_ID          NUMBER,
88   P_TAGGING_REQUIRED_FLAG         VARCHAR2,
89   P_SHUTDOWN_TYPE_CODE            VARCHAR2,
90   P_LAST_UPDATE_DATE              DATE,
91   P_LAST_UPDATED_BY               NUMBER,
92   P_CREATION_DATE                 DATE,
93   P_CREATED_BY                    NUMBER,
94   P_LAST_UPDATE_LOGIN             NUMBER,
95   P_ATTRIBUTE_CATEGORY            VARCHAR2,
96   P_ATTRIBUTE1                    VARCHAR2,
97   P_ATTRIBUTE2                    VARCHAR2,
98   P_ATTRIBUTE3                    VARCHAR2,
99   P_ATTRIBUTE4                    VARCHAR2,
100   P_ATTRIBUTE5                    VARCHAR2,
101   P_ATTRIBUTE6                    VARCHAR2,
102   P_ATTRIBUTE7                    VARCHAR2,
103   P_ATTRIBUTE8                    VARCHAR2,
104   P_ATTRIBUTE9                    VARCHAR2,
105   P_ATTRIBUTE10                   VARCHAR2,
106   P_ATTRIBUTE11                   VARCHAR2,
107   P_ATTRIBUTE12                   VARCHAR2,
108   P_ATTRIBUTE13                   VARCHAR2,
109   P_ATTRIBUTE14                   VARCHAR2,
110   P_ATTRIBUTE15                   VARCHAR2,
111   P_REQUEST_ID                    NUMBER DEFAULT NULL,
112   P_PROGRAM_APPLICATION_ID        NUMBER DEFAULT NULL,
113   P_PROGRAM_ID                    NUMBER DEFAULT NULL,
114   P_PROGRAM_UPDATE_DATE           DATE DEFAULT NULL,
115   P_TMPL_FLAG			VARCHAR2,
116   P_MAINTENANCE_OBJECT_ID	NUMBER,
117   P_MAINTENANCE_OBJECT_TYPE	NUMBER,
118   P_CREATION_ORGANIZATION_ID	NUMBER,
119   X_RETURN_STATUS OUT NOCOPY VARCHAR2,
120   X_MSG_COUNT OUT NOCOPY NUMBER,
121   X_MSG_DATA OUT NOCOPY VARCHAR2);
122 
123 
124 
125 PROCEDURE LOCK_ROW(
126   P_API_VERSION IN NUMBER,
127   P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
128   P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
129   P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130   P_ROWID                         VARCHAR2,
131   P_ACTIVITY_ASSOCIATION_ID       NUMBER,
132   P_ORGANIZATION_ID               NUMBER,
133   P_ASSET_ACTIVITY_ID             NUMBER,
134   P_INVENTORY_ITEM_ID             NUMBER,
135   P_SERIAL_NUMBER                 VARCHAR2,
136   P_START_DATE_ACTIVE             DATE,
137   P_END_DATE_ACTIVE               DATE,
138   P_PRIORITY_CODE                 VARCHAR2,
139   P_ACTIVITY_CAUSE_CODE           VARCHAR2,
140   P_ACTIVITY_TYPE_CODE            VARCHAR2,
141   P_ACTIVITY_SOURCE_CODE          VARCHAR2,
142   P_CLASS_CODE                    VARCHAR2,
143   P_OWNING_DEPARTMENT_ID          NUMBER,
144   P_TAGGING_REQUIRED_FLAG         VARCHAR2,
145   P_SHUTDOWN_TYPE_CODE            VARCHAR2,
146   P_ATTRIBUTE_CATEGORY            VARCHAR2,
147   P_ATTRIBUTE1                    VARCHAR2,
148   P_ATTRIBUTE2                    VARCHAR2,
149   P_ATTRIBUTE3                    VARCHAR2,
150   P_ATTRIBUTE4                    VARCHAR2,
151   P_ATTRIBUTE5                    VARCHAR2,
152   P_ATTRIBUTE6                    VARCHAR2,
153   P_ATTRIBUTE7                    VARCHAR2,
154   P_ATTRIBUTE8                    VARCHAR2,
155   P_ATTRIBUTE9                    VARCHAR2,
156   P_ATTRIBUTE10                   VARCHAR2,
157   P_ATTRIBUTE11                   VARCHAR2,
158   P_ATTRIBUTE12                   VARCHAR2,
159   P_ATTRIBUTE13                   VARCHAR2,
160   P_ATTRIBUTE14                   VARCHAR2,
161   P_ATTRIBUTE15                   VARCHAR2,
162   P_REQUEST_ID                    NUMBER DEFAULT NULL,
163   P_PROGRAM_APPLICATION_ID        NUMBER DEFAULT NULL,
164   P_PROGRAM_ID                    NUMBER DEFAULT NULL,
165   P_PROGRAM_UPDATE_DATE           DATE DEFAULT NULL,
166   P_MAINTENANCE_OBJECT_ID	NUMBER,
167   P_MAINTENANCE_OBJECT_TYPE	NUMBER,
168   X_RETURN_STATUS OUT NOCOPY VARCHAR2,
169   X_MSG_COUNT OUT NOCOPY NUMBER,
170   X_MSG_DATA OUT NOCOPY VARCHAR2);
171 
172 
173 PROCEDURE UPDATE_ROW(
174   P_API_VERSION IN NUMBER,
175   P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
176   P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
177   P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178   P_ROWID                         VARCHAR2,
179   P_ACTIVITY_ASSOCIATION_ID       NUMBER,
180   P_ORGANIZATION_ID               NUMBER,
181   P_ASSET_ACTIVITY_ID             NUMBER,
182   P_INVENTORY_ITEM_ID             NUMBER,
183   P_SERIAL_NUMBER                 VARCHAR2,
184   P_START_DATE_ACTIVE             DATE,
185   P_END_DATE_ACTIVE               DATE,
186   P_PRIORITY_CODE                 VARCHAR2,
187   P_ACTIVITY_CAUSE_CODE           VARCHAR2,
188   P_ACTIVITY_TYPE_CODE            VARCHAR2,
189   P_ACTIVITY_SOURCE_CODE          VARCHAR2,
190   P_WORK_ORDER_TYPE               NUMBER,
191   P_PLANNER                       NUMBER,
192   P_FIRM                          IN  NUMBER,
193   P_PLANNED                       IN  VARCHAR2,
194   P_NOTIFICATION_REQUIRED         IN  VARCHAR2,
195   P_CLASS_CODE                    VARCHAR2,
196   P_OWNING_DEPARTMENT_ID          NUMBER,
197   P_TAGGING_REQUIRED_FLAG         VARCHAR2,
198   P_SHUTDOWN_TYPE_CODE            VARCHAR2,
199   P_LAST_UPDATE_DATE              DATE,
200   P_LAST_UPDATED_BY               NUMBER,
201   P_LAST_UPDATE_LOGIN             NUMBER,
202   P_ATTRIBUTE_CATEGORY            VARCHAR2,
203   P_ATTRIBUTE1                    VARCHAR2,
204   P_ATTRIBUTE2                    VARCHAR2,
205   P_ATTRIBUTE3                    VARCHAR2,
206   P_ATTRIBUTE4                    VARCHAR2,
207   P_ATTRIBUTE5                    VARCHAR2,
208   P_ATTRIBUTE6                    VARCHAR2,
209   P_ATTRIBUTE7                    VARCHAR2,
210   P_ATTRIBUTE8                    VARCHAR2,
211   P_ATTRIBUTE9                    VARCHAR2,
212   P_ATTRIBUTE10                   VARCHAR2,
213   P_ATTRIBUTE11                   VARCHAR2,
214   P_ATTRIBUTE12                   VARCHAR2,
215   P_ATTRIBUTE13                   VARCHAR2,
216   P_ATTRIBUTE14                   VARCHAR2,
217   P_ATTRIBUTE15                   VARCHAR2,
218   P_REQUEST_ID                    NUMBER DEFAULT NULL,
219   P_PROGRAM_APPLICATION_ID        NUMBER DEFAULT NULL,
220   P_PROGRAM_ID                    NUMBER DEFAULT NULL,
221   P_PROGRAM_UPDATE_DATE           DATE DEFAULT NULL,
222   P_MAINTENANCE_OBJECT_ID	NUMBER,
223   P_MAINTENANCE_OBJECT_TYPE	NUMBER,
224   X_RETURN_STATUS OUT NOCOPY VARCHAR2,
225   X_MSG_COUNT OUT NOCOPY NUMBER,
226   X_MSG_DATA OUT NOCOPY VARCHAR2);
227 
228 
229 END EAM_ASSET_ACTIVITIES_PVT;