APPS.PER_JP_SCHOOL_LOOKUPS_PKG SQL Statements

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

Line: 3

	PROCEDURE insert_row(
			p_rowid			OUT VARCHAR2,
			p_school_id		IN VARCHAR2,
			p_school_name		IN VARCHAR2,
			p_school_name_kana	IN VARCHAR2,
			p_major			IN VARCHAR2,
			p_major_kana		IN VARCHAR2,
			p_created_by		IN NUMBER,
			p_creation_date		IN DATE,
			p_last_updated_by	IN NUMBER,
			p_last_update_date	IN DATE,
			p_last_update_login	IN NUMBER)
	IS
		l_rowid	ROWID;

Line: 18

			select	rowid
			from	per_jp_school_lookups
			where	school_id=p_school_id;

Line: 22

		insert into per_jp_school_lookups(
			SCHOOL_ID,
			SCHOOL_NAME,
			SCHOOL_NAME_KANA,
			MAJOR,
			MAJOR_KANA,
			CREATED_BY,
			CREATION_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATE_LOGIN)
		values(	p_school_id,
			p_school_name,
			p_school_name_kana,
			p_major,
			p_major_kana,
			p_created_by,
			p_creation_date,
			p_last_updated_by,
			p_last_update_date,
			p_last_update_Login);

Line: 60

			select	*
			from	per_jp_school_lookups
			where	rowid=chartorowid(p_rowid)
			for update of school_id nowait;

Line: 70

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

Line: 87

	PROCEDURE update_row(
			p_rowid			IN VARCHAR2,
			p_school_id		IN VARCHAR2,
			p_school_name		IN VARCHAR2,
			p_school_name_kana	IN VARCHAR2,
			p_major			IN VARCHAR2,
			p_major_kana		IN VARCHAR2,
			p_created_by		IN NUMBER,
			p_creation_date		IN DATE,
			p_last_updated_by	IN NUMBER,
			p_last_update_date	IN DATE,
			p_last_update_login	IN NUMBER)
	IS
	BEGIN
		update	per_jp_school_lookups
		set	school_id		= p_school_id,
			school_name		= p_school_name,
			school_name_kana	= p_school_name_kana,
			major			= p_major,
			major_kana		= p_major_kana,
			created_by		= p_created_by,
			creation_date		= p_creation_date,
			last_updated_by		= p_last_updated_by,
			last_update_date	= p_last_update_date,
			last_update_login	= p_last_update_login
		where	rowid=chartorowid(p_rowid);