[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT decode(nvl(p_txn_org_assgn_rec.preserve_detail_flag,fnd_api.g_miss_char),
fnd_api.g_miss_char, 'Y', p_txn_org_assgn_rec.preserve_detail_flag)
INTO l_preserve_detail_flag
FROM sys.dual;
p_api_name => 'insert_row',
p_pkg_name => 'csi_t_org_assignments_pkg');
csi_t_org_assignments_pkg.insert_row(
px_txn_operating_unit_id => l_txn_operating_unit_id,
p_txn_line_detail_id => p_txn_org_assgn_rec.txn_line_detail_id,
p_operating_unit_id => p_txn_org_assgn_rec.operating_unit_id,
p_relationship_type_code => p_txn_org_assgn_rec.relationship_type_code,
p_active_start_date => p_txn_org_assgn_rec.active_start_date,
p_active_end_date => p_txn_org_assgn_rec.active_end_date,
p_preserve_detail_flag => l_preserve_detail_flag,
p_instance_ou_id => p_txn_org_assgn_rec.instance_ou_id,
p_attribute1 => p_txn_org_assgn_rec.attribute1,
p_attribute2 => p_txn_org_assgn_rec.attribute2,
p_attribute3 => p_txn_org_assgn_rec.attribute3,
p_attribute4 => p_txn_org_assgn_rec.attribute4,
p_attribute5 => p_txn_org_assgn_rec.attribute5,
p_attribute6 => p_txn_org_assgn_rec.attribute6,
p_attribute7 => p_txn_org_assgn_rec.attribute7,
p_attribute8 => p_txn_org_assgn_rec.attribute8,
p_attribute9 => p_txn_org_assgn_rec.attribute9,
p_attribute10 => p_txn_org_assgn_rec.attribute10,
p_attribute11 => p_txn_org_assgn_rec.attribute11,
p_attribute12 => p_txn_org_assgn_rec.attribute12,
p_attribute13 => p_txn_org_assgn_rec.attribute13,
p_attribute14 => p_txn_org_assgn_rec.attribute14,
p_attribute15 => p_txn_org_assgn_rec.attribute15,
p_created_by => g_user_id,
p_creation_date => sysdate,
p_last_updated_by => g_user_id,
p_last_update_date => sysdate,
p_last_update_login => g_login_id,
p_object_version_number => 1.0,
p_context => p_txn_org_assgn_rec.context);
'csi_t_org_assignments_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
PROCEDURE update_txn_org_assgn_dtls(
p_api_version IN NUMBER
,p_commit IN VARCHAR2 := fnd_api.g_false
,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
,p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'update_txn_org_assgn_dtls';
SELECT *
FROM csi_t_org_assignments
WHERE txn_operating_unit_id = l_txn_ou_id;
SAVEPOINT update_txn_org_assgn_dtls;
l_ou_rec.last_updated_by := g_user_id;
l_ou_rec.last_update_date := sysdate;
l_ou_rec.last_update_login := g_login_id;
p_api_name => 'update_row');
csi_t_org_assignments_pkg.update_row(
p_txn_operating_unit_id => l_ou_rec.txn_operating_unit_id,
p_txn_line_detail_id => l_ou_rec.txn_line_detail_id,
p_operating_unit_id => l_ou_rec.operating_unit_id,
p_relationship_type_code=> l_ou_rec.relationship_type_code,
p_active_start_date => l_ou_rec.active_start_date,
p_active_end_date => l_ou_rec.active_end_date,
p_preserve_detail_flag => l_ou_rec.preserve_detail_flag,
p_instance_ou_id => l_ou_rec.instance_ou_id,
p_attribute1 => l_ou_rec.attribute1,
p_attribute2 => l_ou_rec.attribute2,
p_attribute3 => l_ou_rec.attribute3,
p_attribute4 => l_ou_rec.attribute4,
p_attribute5 => l_ou_rec.attribute5,
p_attribute6 => l_ou_rec.attribute6,
p_attribute7 => l_ou_rec.attribute7,
p_attribute8 => l_ou_rec.attribute8,
p_attribute9 => l_ou_rec.attribute9,
p_attribute10 => l_ou_rec.attribute10,
p_attribute11 => l_ou_rec.attribute11,
p_attribute12 => l_ou_rec.attribute12,
p_attribute13 => l_ou_rec.attribute13,
p_attribute14 => l_ou_rec.attribute14,
p_attribute15 => l_ou_rec.attribute15,
p_created_by => l_ou_rec.created_by,
p_creation_date => l_ou_rec.creation_date,
p_last_updated_by => l_ou_rec.last_updated_by,
p_last_update_date => l_ou_rec.last_update_date,
p_last_update_login => l_ou_rec.last_update_login,
p_object_version_number => l_ou_rec.object_version_number,
p_context => l_ou_rec.context);
'csi_t_org_assignments_pkg.update_row failed. '||substr(sqlerrm,1,200));
ROLLBACK TO update_txn_org_assgn_dtls;
ROLLBACK TO update_txn_org_assgn_dtls;
ROLLBACK TO update_txn_org_assgn_dtls;
END update_txn_org_assgn_dtls;
PROCEDURE delete_txn_org_assgn_dtls(
p_api_version IN NUMBER
,p_commit IN VARCHAR2 := fnd_api.g_false
,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
,p_txn_org_assgn_ids_tbl IN csi_t_datastructures_grp.txn_org_assgn_ids_tbl
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_txn_org_assgn_dtls';
SELECT txn_operating_unit_id
FROM csi_t_org_assignments
WHERE txn_line_detail_id = p_line_dtl_id;
SAVEPOINT delete_txn_org_assgn_dtls;
p_api_name => 'delete_row',
p_pkg_name => 'csi_t_org_assignments_pkg');
csi_t_org_assignments_pkg.delete_row(
p_txn_operating_unit_id => l_txn_ou_id);
p_api_name => 'delete_row',
p_pkg_name => 'csi_t_org_assignments_pkg');
csi_t_org_assignments_pkg.delete_row(
p_txn_operating_unit_id => ou_rec.txn_operating_unit_id);
ROLLBACK TO delete_txn_org_assgn_dtls;
ROLLBACK TO delete_txn_org_assgn_dtls;
ROLLBACK TO delete_txn_org_assgn_dtls;
END delete_txn_org_assgn_dtls;
l_select_stmt varchar2(2000);
l_select_stmt :=
'select txn_operating_unit_id, txn_line_detail_id, instance_ou_id, '||
' operating_unit_id, relationship_type_code, active_start_date, active_end_date, '||
' preserve_detail_flag, context, attribute1, attribute2, attribute3, attribute4, '||
' attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, '||
' attribute11, attribute12, attribute13, attribute14, attribute15, object_version_number '||
'from csi_t_org_assignments '||
'where txn_line_detail_id = :line_dtl_id';
dbms_sql.parse(l_oa_cur_id, l_select_stmt , dbms_sql.native);
l_tmp_oa_tbl.delete;