APPS.CN_IMP_MAPS_PVT dependencies on CN_OBJECTS

Line 61: l_nullable cn_objects.nullable%TYPE := 'N';

57: l_imp_map imp_maps_rec_type;
58: l_temp NUMBER;
59: l_target_fields v_tbl_type;
60: l_imp_map_field CN_IMP_MAP_FIELDS_PKG.imp_map_fields_rec_type;
61: l_nullable cn_objects.nullable%TYPE := 'N';
62: l_obj_type cn_objects.object_type%TYPE := 'COL';
63:
64: BEGIN
65: -- Standard Start of API savepoint

Line 62: l_obj_type cn_objects.object_type%TYPE := 'COL';

58: l_temp NUMBER;
59: l_target_fields v_tbl_type;
60: l_imp_map_field CN_IMP_MAP_FIELDS_PKG.imp_map_fields_rec_type;
61: l_nullable cn_objects.nullable%TYPE := 'N';
62: l_obj_type cn_objects.object_type%TYPE := 'COL';
63:
64: BEGIN
65: -- Standard Start of API savepoint
66: SAVEPOINT Create_Mapping;

Line 157: FROM cn_objects

153: -- get target_object_id
154: SELECT object_id,name
155: INTO l_imp_map_field.target_object_id,
156: l_imp_map_field.target_column_name
157: FROM cn_objects
158: WHERE table_id = l_imp_map_field.target_table_id
159: AND object_id = p_target_fields(i)
160: AND object_type = 'COL' AND ORG_ID = p_org_id
161: ;

Line 188: FROM cn_objects o

184: BEGIN
185: l_temp := 0 ;
186: SELECT COUNT(1)
187: INTO l_temp
188: FROM cn_objects o
189: WHERE o.table_id = l_imp_map_field.target_table_id
190: AND o.nullable = l_nullable
191: AND object_type = l_obj_type
192: AND o.name NOT IN ('IMP_LINE_ID','LAST_UPDATE_DATE','LAST_UPDATED_BY','CREATION_DATE','CREATED_BY','LAST_UPDATE_LOGIN','OBJECT_VERSION_NUMBER','IMP_HEADER_ID','STATUS_CODE','ERROR_CODE','ERROR_MSG','RECORD_NUM','IMPORT_TYPE_CODE')

Line 322: FROM cn_objects

318:
319: CURSOR c_def_target_csr (c_table_id NUMBER) IS
320: SELECT object_id value,name colname,nullable,
321: Decode(Nvl(nullable,'Y'),'N','* ','') || user_name text
322: FROM cn_objects
323: WHERE table_id = c_table_id
324: AND object_type = 'COL'
325: AND name NOT IN ('IMP_LINE_ID','LAST_UPDATE_DATE','LAST_UPDATED_BY','CREATION_DATE','CREATED_BY','LAST_UPDATE_LOGIN','OBJECT_VERSION_NUMBER','IMP_HEADER_ID','STATUS_CODE','ERROR_CODE','ERROR_MSG','RECORD_NUM','IMPORT_TYPE_CODE')
326: AND ORG_ID = p_org_id

Line 337: FROM cn_imp_map_fields i, cn_objects o

333: i.source_column || ' : ' || o.name m_colname,
334: i.source_user_column || ' : ' ||
335: Decode(Nvl(o.nullable,'Y'),'N','* ','') || o.user_name m_text,
336: i.source_user_column s_text, i.source_column s_value
337: FROM cn_imp_map_fields i, cn_objects o
338: WHERE i.imp_map_id = c_imp_map_id
339: AND i.target_object_id = o.object_id
340: AND o.ORG_ID = p_org_id
341: ;

Line 347: FROM cn_objects o

343:
344: CURSOR c_unmap_target_csr (c_table_id NUMBER,c_imp_map_id NUMBER) IS
345: SELECT o.object_id value,o.name colname,o.nullable,
346: Decode(Nvl(o.nullable,'Y'),'N','* ','') || o.user_name text
347: FROM cn_objects o
348: WHERE o.table_id = c_table_id
349: AND o.object_type = 'COL'
350: AND o.name NOT IN ('IMP_LINE_ID','LAST_UPDATE_DATE','LAST_UPDATED_BY','CREATION_DATE','CREATED_BY','LAST_UPDATE_LOGIN','OBJECT_VERSION_NUMBER','IMP_HEADER_ID','STATUS_CODE','ERROR_CODE','ERROR_MSG','RECORD_NUM','IMPORT_TYPE_CODE')
351: AND NOT exists