APPS.PO_ASL_AUTHORIZATIONS_THS SQL Statements

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

Line: 6

  PROCEDURE NAME:	insert_row()

============================================================================*/

procedure insert_row(
	x_using_organization_id			NUMBER,
	x_reference_id		  		NUMBER,
	x_reference_type		  	VARCHAR2,
	x_authorization_code   			VARCHAR2,
	x_authorization_sequence		NUMBER,
	x_last_update_date	  		DATE,
	x_last_updated_by	  		NUMBER,
	x_creation_date		  		DATE,
	x_created_by		  		NUMBER,
	x_last_update_login			NUMBER,
	x_purchasing_unit_of_measure		VARCHAR2,
	x_timefence_days			NUMBER,
	x_rowid				IN OUT	NOCOPY VARCHAR2) is

  cursor row_id is 	SELECT rowid
			FROM   CHV_AUTHORIZATIONS
    		   	WHERE  reference_id = x_reference_id
			AND    reference_type = x_reference_type
			AND    using_organization_id = x_using_organization_id
			AND    authorization_sequence = x_authorization_sequence;

Line: 54

    INSERT INTO CHV_AUTHORIZATIONS(
	using_organization_id		,
	reference_id			,
	reference_type			,
	authorization_code		,
	authorization_sequence		,
	last_update_date		,
	last_updated_by	  		,
	creation_date			,
	created_by			,
	last_update_login		,
	purchasing_unit_of_measure	,
	timefence_days
     )  VALUES 			(
	x_using_organization_id		,
	x_reference_id			,
	x_reference_type		,
	x_authorization_code		,
	x_authorization_sequence	,
	x_last_update_date	  	,
	x_last_updated_by	 	,
	x_creation_date		  	,
	x_created_by		  	,
	x_last_update_login		,
	x_purchasing_unit_of_measure	,
	x_timefence_days
	);

Line: 90

end insert_row;

Line: 95

  PROCEDURE NAME:	update_row()

=============================================================================*/
procedure update_row(
	x_using_organization_id			NUMBER,
	x_reference_id		  		NUMBER,
	x_reference_type		  	VARCHAR2,
	x_authorization_code   			VARCHAR2,
	x_authorization_sequence		NUMBER,
	x_last_update_date	  		DATE,
	x_last_updated_by	  		NUMBER,
	x_creation_date		  		DATE,
	x_created_by		  		NUMBER,
	x_last_update_login			NUMBER,
	x_purchasing_unit_of_measure		VARCHAR2,
	x_timefence_days			NUMBER,
	x_rowid					VARCHAR2) is
begin

    UPDATE CHV_AUTHORIZATIONS
    SET
	using_organization_id	   = x_using_organization_id		,
	reference_id		   = x_reference_id			,
	reference_type		   = x_reference_type			,
	authorization_code	   = x_authorization_code		,
	authorization_sequence     = x_authorization_sequence		,
	last_update_date	   = x_last_update_date			,
	last_updated_by	  	   = x_last_updated_by			,
	creation_date		   = x_creation_date			,
	created_by		   = x_created_by			,
	last_update_login	   = x_last_update_login		,
	purchasing_unit_of_measure = x_purchasing_unit_of_measure	,
	timefence_days		   = x_timefence_days
     WHERE rowid = x_rowid;

Line: 134

end update_row;

Line: 152

  cursor auth_row is	SELECT *
			FROM   CHV_AUTHORIZATIONS
			WHERE  rowid = x_rowid
			FOR UPDATE NOWAIT;

Line: 165

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