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_SNAPSHOTS_PKG

Source


1 PACKAGE AHL_SNAPSHOTS_PKG AUTHID CURRENT_USER as
2 /* $Header: AHLLSNPS.pls 115.1 2003/10/23 19:20:02 sikumar noship $ */
3 PROCEDURE INSERT_ROW (
4  X_SNAPSHOT_ID           IN  NUMBER,
5  X_OBJECT_VERSION_NUMBER IN NUMBER,
6  X_SNAPSHOT_NUMBER       IN NUMBER,
7  X_LAST_UPDATE_DATE      IN DATE,
8  X_LAST_UPDATED_BY       IN NUMBER,
9  X_CREATION_DATE         IN DATE,
10  X_CREATED_BY            IN NUMBER,
11  X_LAST_UPDATE_LOGIN     IN NUMBER,
12  X_VISIT_ID              IN NUMBER,
13  X_VISIT_TASK_ID         IN NUMBER,
14  X_MR_ID                 IN NUMBER,
15  X_ESTIMATED_PRICE       IN NUMBER,
16  X_ACTUAL_PRICE          IN NUMBER,
17  X_ESTIMATED_COST        IN NUMBER,
18  X_ACTUAL_COST           IN NUMBER,
19  X_ATTRIBUTE_CATEGORY    IN VARCHAR2,
20  X_ATTRIBUTE1            IN VARCHAR2,
21  X_ATTRIBUTE2            IN VARCHAR2,
22  X_ATTRIBUTE3            IN VARCHAR2,
23  X_ATTRIBUTE4            IN VARCHAR2,
24  X_ATTRIBUTE5            IN VARCHAR2,
25  X_ATTRIBUTE6            IN VARCHAR2,
26  X_ATTRIBUTE7            IN VARCHAR2,
27  X_ATTRIBUTE8            IN VARCHAR2,
28  X_ATTRIBUTE9            IN VARCHAR2,
29  X_ATTRIBUTE10           IN VARCHAR2,
30  X_ATTRIBUTE11           IN VARCHAR2,
31  X_ATTRIBUTE12           IN VARCHAR2,
32  X_ATTRIBUTE13           IN VARCHAR2,
33  X_ATTRIBUTE14           IN VARCHAR2,
34  X_ATTRIBUTE15           IN VARCHAR2
35  );
36 
37 PROCEDURE UPDATE_ROW (
38  X_SNAPSHOT_ID           IN  NUMBER,
39  X_OBJECT_VERSION_NUMBER IN NUMBER,
40  X_SNAPSHOT_NUMBER       IN NUMBER,
41  X_LAST_UPDATE_DATE      IN DATE,
42  X_LAST_UPDATED_BY       IN NUMBER,
43  --X_CREATION_DATE         IN DATE,
44  --X_CREATED_BY            IN NUMBER,
45  X_LAST_UPDATE_LOGIN     IN NUMBER,
46  X_VISIT_ID              IN NUMBER,
47  X_VISIT_TASK_ID         IN NUMBER,
48  X_MR_ID                 IN NUMBER,
49  X_ESTIMATED_PRICE       IN NUMBER,
50  X_ACTUAL_PRICE          IN NUMBER,
51  X_ESTIMATED_COST        IN NUMBER,
52  X_ACTUAL_COST           IN NUMBER,
53  X_ATTRIBUTE_CATEGORY    IN VARCHAR2,
54  X_ATTRIBUTE1            IN VARCHAR2,
55  X_ATTRIBUTE2            IN VARCHAR2,
56  X_ATTRIBUTE3            IN VARCHAR2,
57  X_ATTRIBUTE4            IN VARCHAR2,
58  X_ATTRIBUTE5            IN VARCHAR2,
59  X_ATTRIBUTE6            IN VARCHAR2,
60  X_ATTRIBUTE7            IN VARCHAR2,
61  X_ATTRIBUTE8            IN VARCHAR2,
62  X_ATTRIBUTE9            IN VARCHAR2,
63  X_ATTRIBUTE10           IN VARCHAR2,
64  X_ATTRIBUTE11           IN VARCHAR2,
65  X_ATTRIBUTE12           IN VARCHAR2,
66  X_ATTRIBUTE13           IN VARCHAR2,
67  X_ATTRIBUTE14           IN VARCHAR2,
68  X_ATTRIBUTE15           IN VARCHAR2
69  );
70 
71  PROCEDURE DELETE_ROW (
72   X_SNAPSHOT_ID in NUMBER
73 );
74 
75 END AHL_SNAPSHOTS_PKG;