APPS.CS_REPAIRS_CSXDRWIP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

	select *
	from cs_repairs
	where rowid = p_rowid
	for update nowait;

Line: 32

	--select job_completion_date,diagnosis_id
	--from cs_estimates
	--where repair_line_id = p_repair_line_id
	--for update nowait;

Line: 44

		fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 94

procedure update_row
(
	p_rowid                         varchar2,
	p_last_update_date              date,
	p_last_updated_by               number,
	p_last_update_login             number,
	p_status                        varchar2,
	p_wip_entity_id                 number,
	p_group_id                      number
) is
begin
	update cs_repairs
	set
		status = p_status,
		wip_entity_id = p_wip_entity_id,
		group_id = p_group_id,
		last_update_date = p_last_update_date,
		last_updated_by = p_last_updated_by,
		last_update_login = p_last_update_login
	where rowid = p_rowid;

Line: 119

	insert into cs_repair_history
	(
		repair_history_id,
		repair_line_id,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		status,
		transaction_date
	)
	select
		cs_repair_history_s.nextval,
		repair_line_id,
		last_update_date,
		last_updated_by,
		last_update_date,
		last_updated_by,
		last_update_login,
		status,
		last_update_date
	from cs_repairs
	where rowid = p_rowid;

Line: 143

end update_row;