DBA Data[Home] [Help]

PACKAGE: APPS.IEX_CASE_DEFINITIONS_PKG

Source


1 PACKAGE IEX_CASE_DEFINITIONS_PKG as
2 /* $Header: iextcdfs.pls 120.0 2004/01/24 03:21:21 appldev noship $*/
3 -- Start of Comments
4 -- Package name     : IEX_CASE_DEFINITIONS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           X_ROWID                   in out NOCOPY VARCHAR2,
12           x_CASE_DEFINITION_ID      IN  NUMBER,
13           x_TABLE_NAME              IN  VARCHAR2,
14           x_COLUMN_NAME             IN  VARCHAR2,
15           x_COLUMN_VALUE            IN  VARCHAR2,
16           x_ACTIVE_FLAG             IN  VARCHAR2,
17           x_OBJECT_VERSION_NUMBER   IN  NUMBER,
18           x_CAS_ID                  IN  NUMBER,
19           X_REQUEST_ID              in  NUMBER,
20           X_PROGRAM_APPLICATION_ID  in  NUMBER,
21           X_PROGRAM_ID              in  NUMBER,
22           X_PROGRAM_UPDATE_DATE     in  DATE,
23           X_ATTRIBUTE_CATEGORY      in VARCHAR2,
24           X_ATTRIBUTE1              in VARCHAR2,
25           X_ATTRIBUTE2              in VARCHAR2,
26           X_ATTRIBUTE3              in VARCHAR2,
27           X_ATTRIBUTE4              in VARCHAR2,
28           X_ATTRIBUTE5              in VARCHAR2,
29           X_ATTRIBUTE6              in VARCHAR2,
30           X_ATTRIBUTE7              in VARCHAR2,
31           X_ATTRIBUTE8              in VARCHAR2,
32           X_ATTRIBUTE9              in VARCHAR2,
33           X_ATTRIBUTE10             in VARCHAR2,
34           X_ATTRIBUTE11             in VARCHAR2,
35           X_ATTRIBUTE12             in VARCHAR2,
36           X_ATTRIBUTE13             in VARCHAR2,
37           X_ATTRIBUTE14             in VARCHAR2,
38           X_ATTRIBUTE15             in VARCHAR2,
39           X_CREATION_DATE           in DATE,
40           X_CREATED_BY              in NUMBER,
41           X_LAST_UPDATE_DATE        in DATE,
42           X_LAST_UPDATED_BY         in NUMBER,
43           X_LAST_UPDATE_LOGIN       in NUMBER);
44 
45 PROCEDURE Update_Row(
46           x_CASE_DEFINITION_ID      IN  NUMBER,
47           x_TABLE_NAME              IN  VARCHAR2,
48           x_COLUMN_NAME             IN  VARCHAR2,
49           x_COLUMN_VALUE            IN  VARCHAR2,
50           x_ACTIVE_FLAG             IN  VARCHAR2,
51           x_OBJECT_VERSION_NUMBER   IN  NUMBER,
52           x_CAS_ID                  IN  NUMBER,
53           X_REQUEST_ID              in  NUMBER,
54           X_PROGRAM_APPLICATION_ID  in  NUMBER,
55           X_PROGRAM_ID              in  NUMBER,
56           X_PROGRAM_UPDATE_DATE     in  DATE,
57           X_ATTRIBUTE_CATEGORY      in VARCHAR2,
58           X_ATTRIBUTE1              in VARCHAR2,
59           X_ATTRIBUTE2              in VARCHAR2,
60           X_ATTRIBUTE3              in VARCHAR2,
61           X_ATTRIBUTE4              in VARCHAR2,
62           X_ATTRIBUTE5              in VARCHAR2,
63           X_ATTRIBUTE6              in VARCHAR2,
64           X_ATTRIBUTE7              in VARCHAR2,
65           X_ATTRIBUTE8              in VARCHAR2,
66           X_ATTRIBUTE9              in VARCHAR2,
67           X_ATTRIBUTE10             in VARCHAR2,
68           X_ATTRIBUTE11             in VARCHAR2,
69           X_ATTRIBUTE12             in VARCHAR2,
70           X_ATTRIBUTE13             in VARCHAR2,
71           X_ATTRIBUTE14             in VARCHAR2,
72           X_ATTRIBUTE15             in VARCHAR2,
73           X_LAST_UPDATE_DATE        in DATE,
74           X_LAST_UPDATED_BY         in NUMBER,
75           X_LAST_UPDATE_LOGIN       in NUMBER);
76 
77 /*PROCEDURE Lock_Row(
78  x_CASE_DEFINITION_ID      IN  NUMBER,
79           x_TABLE_NAME              IN  VARCHAR2,
80           x_COLUMN_NAME             IN  VARCHAR2,
81           x_COLUMN_VALUE            IN  VARCHAR2,
82           x_ACTIVE_FLAG             IN  VARCHAR2,
83           x_OBJECT_VERSION_NUMBER   IN  NUMBER,
84           x_CAS_ID                  IN  NUMBER,
85           X_REQUEST_ID              in  NUMBER,
86           X_PROGRAM_APPLICATION_ID  in  NUMBER,
87           X_PROGRAM_ID              in  NUMBER,
88           X_PROGRAM_UPDATE_DATE     in  DATE,
89           X_ATTRIBUTE_CATEGORY      in VARCHAR2,
90           X_ATTRIBUTE1              in VARCHAR2,
91           X_ATTRIBUTE2              in VARCHAR2,
92           X_ATTRIBUTE3              in VARCHAR2,
93           X_ATTRIBUTE4              in VARCHAR2,
94           X_ATTRIBUTE4              in VARCHAR2,
95           X_ATTRIBUTE5              in VARCHAR2,
96           X_ATTRIBUTE6              in VARCHAR2,
97           X_ATTRIBUTE7              in VARCHAR2,
98           X_ATTRIBUTE8              in VARCHAR2,
99           X_ATTRIBUTE9              in VARCHAR2,
100           X_ATTRIBUTE10             in VARCHAR2,
101           X_ATTRIBUTE11             in VARCHAR2,
102           X_ATTRIBUTE12             in VARCHAR2,
103           X_ATTRIBUTE13             in VARCHAR2,
104           X_ATTRIBUTE14             in VARCHAR2,
105           X_ATTRIBUTE15             in VARCHAR2,
106           X_CREATION_DATE           in DATE,
107           X_CREATED_BY              in NUMBER,
108           X_LAST_UPDATE_DATE        in DATE,
109           X_LAST_UPDATED_BY         in NUMBER,
110           X_LAST_UPDATE_LOGIN       in NUMBER);
111 */
112 procedure LOCK_ROW (
113   x_CASE_DEFINITION_ID IN NUMBER,
114   X_OBJECT_VERSION_NUMBER in NUMBER);
115 
116 PROCEDURE Delete_Row(
117        x_CASE_DEFINITION_ID IN NUMBER);
118 
119 End IEX_CASE_DEFINITIONS_PKG;