APPS.PAY_JP_SWOT_NUMBERS_PKG SQL Statements

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

Line: 10

PROCEDURE insert_row
(
	x_rowid                 in out nocopy varchar2,
	x_organization_id       in            number,
	x_district_code         in            varchar2,
	x_report_district_code  in            varchar2,
	x_swot_number           in            varchar2,
  x_efile_exclusive_flag  in            varchar2,
  x_output_file_name      in            varchar2,
  x_import_exclusive_flag in            varchar2,
  x_input_file_name       in            varchar2,
	x_last_update_date      in            date,
	x_last_updated_by       in            number,
	x_last_update_login     in            number,
	x_created_by            in            number,
	x_creation_date         in            date
)IS
	--
	cursor cur_row is
		select rowidtochar(rowid)
		from pay_jp_swot_numbers
		where organization_id = x_organization_id
		and district_code = x_district_code;

Line: 36

	insert into pay_jp_swot_numbers
	(
		organization_id,
		district_code,
		report_district_code,
		swot_number,
    efile_exclusive_flag,
    output_file_name,
    import_exclusive_flag,
    input_file_name,
		last_update_date,
		last_updated_by,
		last_update_login,
		created_by,
		creation_date
	)
	values
	(
		x_organization_id,
		x_district_code,
		x_report_district_code,
		x_swot_number,
    x_efile_exclusive_flag,
    x_output_file_name,
    x_import_exclusive_flag,
    x_input_file_name,
		x_last_update_date,
		x_last_updated_by,
		x_last_update_login,
		x_created_by,
		x_creation_date
	);

Line: 79

END insert_row;

Line: 98

	x_last_update_date      in  date,
	x_last_updated_by       in  number,
	x_last_update_login     in  number,
	x_created_by            in  number,
	x_creation_date         in  date
)IS
	--
	cursor cur_row is
		select
			organization_id,
			district_code,
			report_district_code,
			swot_number,
      efile_exclusive_flag,
      output_file_name,
      import_exclusive_flag,
      input_file_name,
			last_update_date,
			last_updated_by,
			last_update_login,
			created_by,
			creation_date
		from
			pay_jp_swot_numbers
		where
			rowid = chartorowid(x_rowid)
		for update of
			organization_id,
			district_code,
			report_district_code,
			swot_number,
      efile_exclusive_flag,
      output_file_name,
      import_exclusive_flag,
      input_file_name
		nowait;

Line: 144

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

Line: 173

		l_cur_row.last_update_date = x_last_update_date
		and
		l_cur_row.last_updated_by = x_last_updated_by
		and
		(
			l_cur_row.last_update_login = x_last_update_login
			or
			(
				l_cur_row.last_update_login is null
				and
				x_last_update_login is null
			)
		)
		and
		l_cur_row.created_by = x_created_by
		and
		l_cur_row.creation_date = x_creation_date
	then
		return;

Line: 205

PROCEDURE update_row
(
	x_rowid                 in  varchar2,
	x_organization_id       in  number,
	x_district_code         in  varchar2,
	x_report_district_code  in  varchar2,
	x_swot_number           in  varchar2,
  x_efile_exclusive_flag  in  varchar2,
  x_output_file_name      in  varchar2,
  x_import_exclusive_flag in  varchar2,
  x_input_file_name       in  varchar2,
	x_last_update_date      in  date,
	x_last_updated_by       in  number,
	x_last_update_login     in  number,
	x_created_by            in  number,
	x_creation_date         in  date
)IS
BEGIN
	--
	update
		pay_jp_swot_numbers
	set
		organization_id       = x_organization_id,
		district_code         = x_district_code,
		report_district_code  = x_report_district_code,
		swot_number           = x_swot_number,
    efile_exclusive_flag  = x_efile_exclusive_flag,
    output_file_name      = x_output_file_name,
    import_exclusive_flag = x_import_exclusive_flag,
    input_file_name       = x_input_file_name,
		last_update_date      = x_last_update_date,
		last_updated_by       = x_last_updated_by,
		last_update_login     = x_last_update_login,
		created_by            = x_created_by,
		creation_date         = x_creation_date
	where
		rowid = chartorowid(x_rowid);

Line: 247

END update_row;

Line: 255

PROCEDURE delete_row(x_rowid in varchar2)IS
BEGIN
	--
	delete from pay_jp_swot_numbers
	where rowid = chartorowid(x_rowid);

Line: 265

END delete_row;