APPS.CN_OBJ_COLUMNS_V_PKG dependencies on CN_OBJ_COLUMNS_V

Line 1: PACKAGE BODY cn_obj_columns_v_pkg as

1: PACKAGE BODY cn_obj_columns_v_pkg as
2: -- $Header: cnrecolb.pls 115.1 99/07/16 07:13:36 porting ship $
3:
4:
5: --

Line 47: FROM cn_obj_columns_v

43:
44: X_primary_key_id number;
45:
46: CURSOR C IS SELECT rowid
47: FROM cn_obj_columns_v
48: WHERE column_id = X_primary_key_id;
49:
50: CURSOR C2 IS SELECT cn_objects_s.nextval
51: FROM sys.dual;

Line 63: INSERT INTO cn_obj_columns_v(

59: else
60: X_primary_key_id := X_Column_Id;
61: end if;
62:
63: INSERT INTO cn_obj_columns_v(
64: row_id,
65: column_id,
66: last_update_date,
67: last_updated_by,

Line 159: UPDATE cn_obj_columns_v

155: X_column_type varchar2 default NULL,
156: X_seed_column_id number default NULL) IS
157:
158: BEGIN
159: UPDATE cn_obj_columns_v
160: SET
161:
162: row_id = X_row_id,
163: column_id = X_column_id,

Line 202: DELETE FROM cn_obj_columns_v

198: PROCEDURE delete_row(
199: X_Rowid varchar2) IS
200:
201: BEGIN
202: DELETE FROM cn_obj_columns_v
203: WHERE rowid = X_Rowid;
204:
205: if (SQL%NOTFOUND) then
206: RAISE NO_DATA_FOUND;

Line 212: END cn_obj_columns_v_pkg;

208:
209: END Delete_Row;
210:
211:
212: END cn_obj_columns_v_pkg;