APPS.PSP_AUTO_NA_BYPASS_PKG SQL Statements

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

Line: 3

PROCEDURE insert_row
	(p_rowid		IN OUT NOCOPY	VARCHAR2,
	p_natural_account	IN	VARCHAR2,
	p_segment_num		IN	NUMBER,
	p_business_group_id	IN	NUMBER,
	p_set_of_books_id	IN	NUMBER,
	p_mode			IN	VARCHAR2	DEFAULT 'R') IS
CURSOR	row_id_cur IS
SELECT	rowid
FROM	psp_auto_na_bypass
WHERE	natural_account = p_natural_account
AND	segment_num = p_segment_num;

Line: 16

l_last_update_date	DATE;

Line: 17

l_last_updated_by	NUMBER;

Line: 18

l_last_update_login	NUMBER;

Line: 21

	l_last_update_date := SYSDATE;

Line: 23

		l_last_updated_by := 1;

Line: 24

		l_last_update_login := 0;

Line: 26

		l_last_updated_by := fnd_global.user_id;

Line: 27

		IF l_last_updated_by IS NULL THEN
			l_last_updated_by := -1;

Line: 30

		l_last_update_login :=fnd_global.login_id;

Line: 31

		IF l_last_update_login IS null THEN
			l_last_update_login := -1;

Line: 38

	INSERT INTO psp_auto_na_bypass
		(natural_account,	segment_num,		business_group_id,	set_of_books_id,
		creation_date,		created_by,		last_update_date,	last_updated_by,
		last_update_login)
	VALUES	(p_natural_account,	p_segment_num,		p_business_group_id,	p_set_of_books_id,
		l_last_update_date,	l_last_updated_by,	l_last_update_date,	l_last_updated_by,
		l_last_update_login);

Line: 54

END insert_row;

Line: 60

SELECT	*
FROM	psp_auto_na_bypass
WHERE	rowid = p_rowid
FOR UPDATE OF natural_account NOWAIT;

Line: 92

PROCEDURE update_row
	(p_rowid		IN OUT NOCOPY	VARCHAR2,
	p_natural_account	IN	VARCHAR2,
	p_segment_num		IN	NUMBER,
	p_mode			IN	VARCHAR2	DEFAULT 'R') IS
l_last_update_date	DATE;

Line: 98

l_last_updated_by	NUMBER;

Line: 99

l_last_update_login	NUMBER;

Line: 102

	l_last_update_date := SYSDATE;

Line: 104

		l_last_updated_by := 1;

Line: 105

		l_last_update_login := 0;

Line: 107

		l_last_updated_by := fnd_global.user_id;

Line: 108

		IF (l_last_updated_by IS NULL) THEN
			l_last_updated_by := -1;

Line: 111

		l_last_update_login :=fnd_global.login_id;

Line: 112

		IF (l_last_update_login IS NULL) THEN
			l_last_update_login := -1;

Line: 120

	UPDATE	psp_auto_na_bypass
	SET	natural_account = p_natural_account,
		segment_num = p_segment_num,
		last_update_date = l_last_update_date,
		last_updated_by = l_last_updated_by,
		last_update_login = l_last_update_login
	WHERE	rowid = p_rowid;

Line: 135

END update_row;

Line: 138

PROCEDURE delete_row
	(p_rowid	IN OUT NOCOPY	VARCHAR2) IS
BEGIN
	DELETE FROM psp_auto_na_bypass
	WHERE	rowid = p_rowid;

Line: 152

END delete_row;