APPS.CN_COLUMN_MAPS_V_PKG dependencies on CN_COLUMN_MAPS

Line 1: PACKAGE BODY cn_column_maps_v_pkg AS

1: PACKAGE BODY cn_column_maps_v_pkg AS
2: -- $Header: cncocmvb.pls 120.1 2005/06/27 19:26:42 appldev ship $
3:
4:
5: --

Line 28: INSERT INTO cn_column_maps(

24: x_created_by number) IS
25:
26: BEGIN
27:
28: INSERT INTO cn_column_maps(
29: column_map_id,
30: source_column_id,
31: destination_column_id,
32: table_map_id,

Line 70: UPDATE cn_column_maps SET

66: x_last_updated_by number) IS
67:
68: BEGIN
69:
70: UPDATE cn_column_maps SET
71: source_column_id = x_source_column_id,
72: destination_column_id = x_dest_column_id,
73: table_map_id = x_table_map_id,
74: driving_column_id = x_foreign_key_mapping_id,

Line 97: FROM cn_column_maps

93: temp := NULL;
94:
95: SELECT column_map_id
96: INTO temp
97: FROM cn_column_maps
98: WHERE column_map_id = x_column_map_id
99: FOR UPDATE ;
100:
101: END lock_row;

Line 112: DELETE cn_column_maps

108:
109: PROCEDURE delete_row (x_column_map_id IN NUMBER) IS
110: BEGIN
111:
112: DELETE cn_column_maps
113: WHERE column_map_id = x_column_map_id ;
114:
115: END delete_row;
116:

Line 127: SELECT cn_column_maps_s.nextval

123: PROCEDURE Default_Row (x_column_map_id IN OUT NOCOPY number) IS
124: BEGIN
125:
126: IF x_column_map_id IS NULL THEN
127: SELECT cn_column_maps_s.nextval
128: INTO x_column_map_id
129: FROM sys.dual ;
130: END IF;
131:

Line 134: END cn_column_maps_v_pkg;

130: END IF;
131:
132: END Default_Row;
133:
134: END cn_column_maps_v_pkg;