[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_LAST_UPDATE_DATE DATE := sysdate ;
G_LAST_UPDATED_BY NUMBER := fnd_global.user_id ;
G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id ;
SELECT cn_calc_ext_tables_s.NEXTVAL
INTO l_id
FROM dual;
SELECT calc_ext_table_id
INTO l_mapping_id
FROM cn_calc_ext_tables
WHERE name = Ltrim(Rtrim(p_mapping_name));
x_loading_status := 'CN_INSERTED';
cn_calc_ext_tables_pkg.insert_row(x_rowid => l_rowid,
x_calc_ext_table_id => l_calc_ext_table_id ,
x_schema => p_table_mapping_rec.schema ,
x_name => p_table_mapping_rec.name ,
x_description => p_table_mapping_rec.description ,
x_internal_table_id => p_table_mapping_rec.internal_table_id ,
x_external_table_id => p_table_mapping_rec.external_table_id ,
x_used_flag => p_table_mapping_rec.used_flag ,
x_external_table_name => p_table_mapping_rec.external_table_name ,
x_alias => p_table_mapping_rec.alias ,
x_attribute_category => p_table_mapping_rec.attribute_category ,
x_attribute1 => p_table_mapping_rec.attribute1 ,
x_attribute2 => p_table_mapping_rec.attribute2 ,
x_attribute3 => p_table_mapping_rec.attribute3 ,
x_attribute4 => p_table_mapping_rec.attribute4 ,
x_attribute5 => p_table_mapping_rec.attribute5 ,
x_attribute6 => p_table_mapping_rec.attribute6 ,
x_attribute7 => p_table_mapping_rec.attribute7 ,
x_attribute8 => p_table_mapping_rec.attribute8 ,
x_attribute9 => p_table_mapping_rec.attribute9 ,
x_attribute10 => p_table_mapping_rec.attribute10 ,
x_attribute11 => p_table_mapping_rec.attribute11 ,
x_attribute12 => p_table_mapping_rec.attribute12 ,
x_attribute13 => p_table_mapping_rec.attribute13 ,
x_attribute14 => p_table_mapping_rec.attribute14 ,
x_attribute15 => p_table_mapping_rec.attribute15 ,
x_creation_date => g_creation_date ,
x_created_by => g_created_by ,
x_last_update_date => g_last_update_date ,
x_last_updated_by => g_last_updated_by ,
x_last_update_login => g_last_update_login ) ;
cn_calc_ext_tbl_dtls_pkg.insert_row
(x_rowid => l_rowid,
x_calc_ext_tbl_dtl_id => NULL,
x_external_column_id => p_column_mapping_tbl(i).external_column_id,
x_calc_ext_table_id => l_calc_ext_table_id,
x_internal_column_id => p_column_mapping_tbl(i).internal_column_id,
x_attribute_category => p_column_mapping_tbl(i).attribute_category,
x_attribute1 => p_column_mapping_tbl(i).attribute1,
x_attribute2 => p_column_mapping_tbl(i).attribute2,
x_attribute3 => p_column_mapping_tbl(i).attribute3,
x_attribute4 => p_column_mapping_tbl(i).attribute4,
x_attribute5 => p_column_mapping_tbl(i).attribute5,
x_attribute6 => p_column_mapping_tbl(i).attribute6,
x_attribute7 => p_column_mapping_tbl(i).attribute7,
x_attribute8 => p_column_mapping_tbl(i).attribute8,
x_attribute9 => p_column_mapping_tbl(i).attribute9,
x_attribute10 => p_column_mapping_tbl(i).attribute10,
x_attribute11 => p_column_mapping_tbl(i).attribute11,
x_attribute12 => p_column_mapping_tbl(i).attribute12,
x_attribute13 => p_column_mapping_tbl(i).attribute13,
x_attribute14 => p_column_mapping_tbl(i).attribute14,
x_attribute15 => p_column_mapping_tbl(i).attribute15,
x_creation_date => g_creation_date,
x_created_by => g_created_by,
x_last_update_date => g_last_update_date,
x_last_updated_by => g_last_updated_by,
x_last_update_login => g_last_update_login);