APPS.CN_IMP_MAPS_PVT dependencies on CN_IMP_MAP_FIELDS

Line 60: l_imp_map_field CN_IMP_MAP_FIELDS_PKG.imp_map_fields_rec_type;

56:
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

Line 131: DELETE FROM cn_imp_map_fields

127: WHERE imp_map_id = p_imp_map.imp_map_id
128: ;
129: x_imp_map_id := p_imp_map.imp_map_id;
130: -- delete map_fields of old mapping
131: DELETE FROM cn_imp_map_fields
132: WHERE imp_map_id = p_imp_map.imp_map_id;
133: END IF;
134: -- ----------------------
135: -- CREATE MAPPING FIELDS

Line 149: SELECT cn_imp_map_fields_s.nextval

145: ;
146:
147: FOR i IN p_target_fields.first .. p_target_fields.last LOOP
148: -- get imp_map_field_id
149: SELECT cn_imp_map_fields_s.nextval
150: INTO l_imp_map_field.imp_map_field_id
151: FROM sys.dual ;
152:
153: -- get target_object_id

Line 176: -- insert into cn_imp_map_fields

172: END IF;
173:
174: l_imp_map_field.source_user_column := p_source_fields(i).text;
175:
176: -- insert into cn_imp_map_fields
177: cn_imp_map_fields_pkg.insert_row
178: (p_imp_map_fields_rec => l_imp_map_field);
179:
180: END LOOP;

Line 177: cn_imp_map_fields_pkg.insert_row

173:
174: l_imp_map_field.source_user_column := p_source_fields(i).text;
175:
176: -- insert into cn_imp_map_fields
177: cn_imp_map_fields_pkg.insert_row
178: (p_imp_map_fields_rec => l_imp_map_field);
179:
180: END LOOP;
181: -- ----------------------

Line 193: AND NOT exists (SELECT 'X' FROM cn_imp_map_fields i

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')
193: AND NOT exists (SELECT 'X' FROM cn_imp_map_fields i
194: WHERE i.imp_map_id = l_imp_map.imp_map_id
195: AND i.target_object_id = o.object_id
196: )
197: AND o.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 352: (SELECT 'X' FROM cn_imp_map_fields i

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
352: (SELECT 'X' FROM cn_imp_map_fields i
353: WHERE i.imp_map_id = c_imp_map_id
354: AND i.target_object_id = o.object_id)
355: AND o.ORG_ID = p_org_id
356: ORDER BY o.nullable, o.user_name

Line 729: DELETE FROM cn_imp_map_fields

725: RAISE FND_API.G_EXC_ERROR ;
726: END IF;
727:
728: -- delete imp_map_fields
729: DELETE FROM cn_imp_map_fields
730: WHERE imp_map_id = l_imp_map.imp_map_id;
731:
732: IF x_return_status <> FND_API.g_ret_sts_success THEN
733: RAISE FND_API.G_EXC_ERROR;