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_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: 32

	insert into pay_jp_swot_numbers
	(
		organization_id,
		district_code,
		report_district_code,
		swot_number,
		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_last_update_date,
		x_last_updated_by,
		x_last_update_login,
		x_created_by,
		x_creation_date
	);

Line: 67

END insert_row;

Line: 82

	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,
			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
		nowait;

Line: 120

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

Line: 149

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

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_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,
		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: 215

END update_row;

Line: 223

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

Line: 233

END delete_row;