PACKAGE: APPS.CSI_IEA_VALUES_PKG

Source

1 PACKAGE CSI_IEA_VALUES_PKG AUTHID CURRENT_USER as
2 /* $Header: csitcivs.pls 115.12 2003/09/04 00:18:03 sguthiva ship $ */
3 
4 PROCEDURE Insert_Row(
5           px_ATTRIBUTE_VALUE_ID   IN OUT NOCOPY NUMBER,
6           p_ATTRIBUTE_ID    NUMBER,
7           p_INSTANCE_ID    NUMBER,
8           p_ATTRIBUTE_VALUE    VARCHAR2,
9           p_ACTIVE_START_DATE    DATE,
10           p_ACTIVE_END_DATE    DATE,
11           p_CONTEXT    VARCHAR2,
12           p_ATTRIBUTE1    VARCHAR2,
13           p_ATTRIBUTE2    VARCHAR2,
14           p_ATTRIBUTE3    VARCHAR2,
15           p_ATTRIBUTE4    VARCHAR2,
16           p_ATTRIBUTE5    VARCHAR2,
17           p_ATTRIBUTE6    VARCHAR2,
18           p_ATTRIBUTE7    VARCHAR2,
19           p_ATTRIBUTE8    VARCHAR2,
20           p_ATTRIBUTE9    VARCHAR2,
21           p_ATTRIBUTE10    VARCHAR2,
22           p_ATTRIBUTE11    VARCHAR2,
23           p_ATTRIBUTE12    VARCHAR2,
24           p_ATTRIBUTE13    VARCHAR2,
25           p_ATTRIBUTE14    VARCHAR2,
26           p_ATTRIBUTE15    VARCHAR2,
27           p_CREATED_BY    NUMBER,
28           p_CREATION_DATE    DATE,
29           p_LAST_UPDATED_BY    NUMBER,
30           p_LAST_UPDATE_DATE    DATE,
31           p_LAST_UPDATE_LOGIN    NUMBER,
32           p_OBJECT_VERSION_NUMBER    NUMBER);
33 
34 PROCEDURE Update_Row(
35           p_ATTRIBUTE_VALUE_ID    NUMBER,
36           p_ATTRIBUTE_ID    NUMBER,
37           p_INSTANCE_ID    NUMBER,
38           p_ATTRIBUTE_VALUE    VARCHAR2,
39           p_ACTIVE_START_DATE    DATE,
40           p_ACTIVE_END_DATE    DATE,
41           p_CONTEXT    VARCHAR2,
42           p_ATTRIBUTE1    VARCHAR2,
43           p_ATTRIBUTE2    VARCHAR2,
44           p_ATTRIBUTE3    VARCHAR2,
45           p_ATTRIBUTE4    VARCHAR2,
46           p_ATTRIBUTE5    VARCHAR2,
47           p_ATTRIBUTE6    VARCHAR2,
48           p_ATTRIBUTE7    VARCHAR2,
49           p_ATTRIBUTE8    VARCHAR2,
50           p_ATTRIBUTE9    VARCHAR2,
51           p_ATTRIBUTE10    VARCHAR2,
52           p_ATTRIBUTE11    VARCHAR2,
53           p_ATTRIBUTE12    VARCHAR2,
54           p_ATTRIBUTE13    VARCHAR2,
55           p_ATTRIBUTE14    VARCHAR2,
56           p_ATTRIBUTE15    VARCHAR2,
57           p_CREATED_BY    NUMBER,
58           p_CREATION_DATE    DATE,
59           p_LAST_UPDATED_BY    NUMBER,
60           p_LAST_UPDATE_DATE    DATE,
61           p_LAST_UPDATE_LOGIN    NUMBER,
62           p_OBJECT_VERSION_NUMBER    NUMBER);
63 
64 PROCEDURE Lock_Row(
65           p_ATTRIBUTE_VALUE_ID    NUMBER,
66           p_ATTRIBUTE_ID    NUMBER,
67           p_INSTANCE_ID    NUMBER,
68           p_ATTRIBUTE_VALUE    VARCHAR2,
69           p_ACTIVE_START_DATE    DATE,
70           p_ACTIVE_END_DATE    DATE,
71           p_CONTEXT    VARCHAR2,
72           p_ATTRIBUTE1    VARCHAR2,
73           p_ATTRIBUTE2    VARCHAR2,
74           p_ATTRIBUTE3    VARCHAR2,
75           p_ATTRIBUTE4    VARCHAR2,
76           p_ATTRIBUTE5    VARCHAR2,
77           p_ATTRIBUTE6    VARCHAR2,
78           p_ATTRIBUTE7    VARCHAR2,
79           p_ATTRIBUTE8    VARCHAR2,
80           p_ATTRIBUTE9    VARCHAR2,
81           p_ATTRIBUTE10    VARCHAR2,
82           p_ATTRIBUTE11    VARCHAR2,
83           p_ATTRIBUTE12    VARCHAR2,
84           p_ATTRIBUTE13    VARCHAR2,
85           p_ATTRIBUTE14    VARCHAR2,
86           p_ATTRIBUTE15    VARCHAR2,
87           p_CREATED_BY    NUMBER,
88           p_CREATION_DATE    DATE,
89           p_LAST_UPDATED_BY    NUMBER,
90           p_LAST_UPDATE_DATE    DATE,
91           p_LAST_UPDATE_LOGIN    NUMBER,
92           p_OBJECT_VERSION_NUMBER    NUMBER);
93 
94 PROCEDURE Delete_Row(
95     p_ATTRIBUTE_VALUE_ID  NUMBER);
96 End CSI_IEA_VALUES_PKG;