DBA Data[Home] [Help]

APPS.CN_COLUMN_MAPS_PKG dependencies on CN_COLUMN_MAPS_ALL

Line 234: update cn_column_maps_all set

230: ELSE
231: USER_ID := 0;
232: END IF;
233:
234: update cn_column_maps_all set
235: DESTINATION_COLUMN_ID = to_number(x_DESTINATION_COLUMN_ID),
236: TABLE_MAP_ID = to_number(x_TABLE_MAP_ID),
237: LAST_UPDATE_DATE = to_date(x_LAST_UPDATE_DATE, 'DD-MM-YYYY'),
238: LAST_UPDATED_BY = to_number(x_LAST_UPDATED_BY),

Line 261: insert into cn_column_maps_all

257: and ORG_ID = x_ORG_ID;
258:
259: IF (SQL%NOTFOUND) THEN
260: -- Insert new record to CN_OBJECTS_TABLE table
261: insert into cn_column_maps_all
262: (COLUMN_MAP_ID,
263: DESTINATION_COLUMN_ID,
264: TABLE_MAP_ID,
265: LAST_UPDATE_DATE,