APPS.OE_PC_VTMPLT_COLS_PKG dependencies on OE_PC_VTMPLT_COLS

Line 1: PACKAGE BODY OE_PC_VTMPLT_COLS_PKG AS

1: PACKAGE BODY OE_PC_VTMPLT_COLS_PKG AS
2: /* $Header: OEXPCVCB.pls 120.0 2005/06/01 01:34:50 appldev noship $ */
3:
4:
5: PROCEDURE Insert_Row(

Line 19: CURSOR C IS SELECT oe_pc_vtmplt_cols_s.nextval FROM dual;

15: ,x_last_update_date in date
16: ,x_last_update_login in number
17: )
18: Is
19: CURSOR C IS SELECT oe_pc_vtmplt_cols_s.nextval FROM dual;
20: CURSOR CROWID IS SELECT rowid FROM oe_pc_vtmplt_cols
21: WHERE validation_tmplt_id = x_validation_tmplt_id
22: AND column_name = x_column_name;
23:

Line 20: CURSOR CROWID IS SELECT rowid FROM oe_pc_vtmplt_cols

16: ,x_last_update_login in number
17: )
18: Is
19: CURSOR C IS SELECT oe_pc_vtmplt_cols_s.nextval FROM dual;
20: CURSOR CROWID IS SELECT rowid FROM oe_pc_vtmplt_cols
21: WHERE validation_tmplt_id = x_validation_tmplt_id
22: AND column_name = x_column_name;
23:
24: Begin

Line 34: INSERT INTO oe_pc_vtmplt_cols (

30: RAISE NO_DATA_FOUND;
31: end if;
32: CLOSE C;
33:
34: INSERT INTO oe_pc_vtmplt_cols (
35: validation_tmplt_col_id
36: ,validation_tmplt_id
37: ,column_name
38: ,validation_op

Line 95: FROM oe_pc_vtmplt_cols

91: )
92: Is
93: CURSOR C IS
94: SELECT *
95: FROM oe_pc_vtmplt_cols
96: WHERE rowid = x_rowid
97: FOR UPDATE OF value_string NOWAIT;
98:
99: Recinfo C%ROWTYPE;

Line 149: UPDATE oe_pc_vtmplt_cols

145: )
146: Is
147: Begin
148:
149: UPDATE oe_pc_vtmplt_cols
150: SET
151: column_name = x_column_name
152: ,validation_op = x_validation_op
153: ,value_string = x_value_string

Line 176: DELETE FROM OE_PC_VTMPLT_COLS

172: )
173: Is
174: Begin
175:
176: DELETE FROM OE_PC_VTMPLT_COLS
177: WHERE rowid = x_rowid;
178: if (SQL%NOTFOUND) then
179: RAISE NO_DATA_FOUND;
180: end if;

Line 203: FROM oe_pc_vtmplt_cols

199:
200: -- onely one column for a validation tmplt
201: SELECT count(1)
202: INTO dummy
203: FROM oe_pc_vtmplt_cols
204: WHERE validation_tmplt_id = x_validation_tmplt_id
205: AND column_name = x_column_name
206: AND validation_op = x_validation_op
207: AND value_string = x_value_string

Line 217: END OE_PC_VTMPLT_COLS_PKG;

213: end if;
214: End Check_Unique;
215: ------------------------------------------------------------------------
216:
217: END OE_PC_VTMPLT_COLS_PKG;