APPS.TAPI_DEV_KIT SQL Statements

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

Line: 148

	x_last_update_date	IN OUT DATE,
	x_last_updated_by	IN OUT NUMBER,
	x_last_update_login	IN OUT NUMBER
) IS
BEGIN
	x_creation_date  := SYSDATE;

Line: 154

	x_last_update_date := SYSDATE;

Line: 156

	x_last_update_login := FND_GLOBAL.login_id;

Line: 158

	x_last_updated_by := FND_GLOBAL.user_id;

Line: 162

	x_last_update_date	IN OUT DATE,
	x_last_updated_by	IN OUT NUMBER,
	x_last_update_login	IN OUT NUMBER
) IS
	l_creation_date		DATE;

Line: 171

			x_last_update_date	=> x_last_update_date,
			x_last_updated_by	=> x_last_updated_by,
			x_last_update_login	=> x_last_update_login);

Line: 180

	l_last_update_date		DATE;

Line: 181

	l_last_updated_by		NUMBER;

Line: 182

	l_last_update_login		NUMBER;

Line: 186

			x_last_update_date	=> l_last_update_date,
			x_last_updated_by	=> l_last_updated_by,
			x_last_update_login	=> l_last_update_login);

Line: 237

	v_sql_stmt :=   'Select ' || p_seq_name  || '.nextval seq  into :x_id from dual' ;