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.1 2010/12/06 08:48:40 ckasera ship $ */
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 182: FROM OE_PC_VTMPLT_COLS

178: last_updated_by = FND_GLOBAL.USER_ID
179: ,last_update_date = sysdate
180: ,last_update_login = FND_GLOBAL.LOGIN_ID
181: WHERE validation_tmplt_id = (SELECT validation_tmplt_id
182: FROM OE_PC_VTMPLT_COLS
183: WHERE rowid = x_rowid );
184: if (SQL%NOTFOUND) then
185: NULL;
186: end if;

Line 190: DELETE FROM OE_PC_VTMPLT_COLS

186: end if;
187: ---End bug# 10189253,10362212
188:
189:
190: DELETE FROM OE_PC_VTMPLT_COLS
191: WHERE rowid = x_rowid;
192: if (SQL%NOTFOUND) then
193: RAISE NO_DATA_FOUND;
194: end if;

Line 217: FROM oe_pc_vtmplt_cols

213:
214: -- onely one column for a validation tmplt
215: SELECT count(1)
216: INTO dummy
217: FROM oe_pc_vtmplt_cols
218: WHERE validation_tmplt_id = x_validation_tmplt_id
219: AND column_name = x_column_name
220: AND validation_op = x_validation_op
221: AND value_string = x_value_string

Line 231: END OE_PC_VTMPLT_COLS_PKG;

227: end if;
228: End Check_Unique;
229: ------------------------------------------------------------------------
230:
231: END OE_PC_VTMPLT_COLS_PKG;