1 PACKAGE OE_PC_VTMPLT_COLS_PKG AS
2 /* $Header: OEXPCVCS.pls 120.0 2005/06/01 00:55:10 appldev noship $ */
3
4 -- Start of Comments
5 -- API name Insert_Row
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20
21 PROCEDURE Insert_Row(
22 x_rowid in out NOCOPY /* file.sql.39 change */ varchar2
23 ,x_validation_tmplt_col_id in out NOCOPY /* file.sql.39 change */ number
24 ,x_validation_tmplt_id in number
25 ,x_column_name in varchar2
26 ,x_validation_op in varchar2
27 ,x_value_string in varchar2
28 ,x_created_by in number
29 ,x_creation_date in date
30 ,x_last_updated_by in number
31 ,x_last_update_date in date
32 ,x_last_update_login in number
33 );
34
35 ---------------------------------------------------
36
37 -- Start of Comments
38 -- API name Lock_Row
39 -- Type Private
40 -- Function
41 --
42 -- Pre-reqs
43 --
44 -- Parameters
45 --
46 -- Version Current version = 1.0
47 -- Initial version = 1.0
48 --
49 -- Notes
50 --
51 -- End of Comments
52
53
54 PROCEDURE Lock_Row(
55 x_rowid in varchar2
56 ,x_validation_tmplt_col_id in number
57 ,x_validation_tmplt_id in number
58 ,x_column_name in varchar2
59 ,x_validation_op in varchar2
60 ,x_value_string in varchar2
61 ,x_created_by in number
62 ,x_creation_date in date
63 ,x_last_updated_by in number
64 ,x_last_update_date in date
65 ,x_last_update_login in number
66 );
67
68 ---------------------------------------------------
69 -- Start of Comments
70 -- API name Update_Row
71 -- Type Private
72 -- Function
73 --
74 -- Pre-reqs
75 --
76 -- Parameters
77 --
78 -- Version Current version = 1.0
79 -- Initial version = 1.0
80 --
81 -- Notes
82 --
83 -- End of Comments
84
85
86 PROCEDURE Update_Row(
87 x_rowid in varchar2
88 ,x_validation_tmplt_col_id in number
89 ,x_validation_tmplt_id in number
90 ,x_column_name in varchar2
91 ,x_validation_op in varchar2
92 ,x_value_string in varchar2
93 ,x_created_by in number
94 ,x_creation_date in date
95 ,x_last_updated_by in number
96 ,x_last_update_date in date
97 ,x_last_update_login in number
98 );
99 ---------------------------------------------------
100 -- Start of Comments
101 -- API name Delete_Row
102 -- Type Private
103 -- Function
104 --
105 -- Pre-reqs
106 --
107 -- Parameters
108 --
109 -- Version Current version = 1.0
110 -- Initial version = 1.0
111 --
112 -- Notes
113 --
114 -- End of Comments
115
116
117 PROCEDURE Delete_Row(
118 x_rowid in varchar2
119 );
120
121 ----------------------------------------------------
122 -- Start of Comments
123 -- API name Check_Unique
124 -- Type Private
125 -- Function
126 --
127 -- Pre-reqs
128 --
129 -- Parameters
130 --
131 -- Version Current version = 1.0
132 -- Initial version = 1.0
133 --
134 -- Notes
135 --
136 -- End of Comments
137 -- Added 2 parameters to fix #2050546 to include column_name,validation_op and
138 -- value_string to check for the unique
139
140 PROCEDURE Check_Unique(
141 x_rowid in varchar2
142 ,x_validation_tmplt_id in number
143 ,x_column_name in varchar2
144 ,x_validation_op in varchar2
145 ,x_value_string in varchar2
146 );
147
148 End OE_PC_VTMPLT_COLS_PKG;