APPS.FA_RX_PARAMETERS_PKG SQL Statements

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

Line: 4

  procedure insert_row (X_rowid  in out nocopy varchar2,
	X_report_id    number,
	X_lov_id	number,
	X_name		varchar2,
	X_required	varchar2,
	X_max_length	number,
	X_datatype	varchar2,
	X_relop		varchar2,
	X_last_update_date date,
	X_last_updated_by  number,
	X_created_by   number,
	X_creation_date  date,
	X_last_update_login  number,
	X_parameter_counter  number,
	X_column_name	varchar2,
	X_calling_fn	varchar2) is

  cursor c is select rowid from fa_rx_rep_parameters
	where report_id = X_report_id and name = X_name;

Line: 27

    insert into fa_rx_rep_parameters (
	report_id,	lov_id,	name,	required,
	max_length,	datatype,	relational_op, last_update_date,
	last_updated_by,	created_by,	creation_date,
	last_update_login,	parameter_counter,	column_name)
	values (	X_report_id,	X_lov_id,	X_name,	X_required,
	X_max_length,	X_datatype,	X_relop, X_last_update_date,
	X_last_updated_by,	X_created_by,	X_creation_date,
	X_last_update_login,	X_parameter_counter,	X_column_name);

Line: 47

                        (Called_Fn      => 'FA_RX_PARAMETERS_PKG.Insert_Row',
                        Calling_Fn      => X_Calling_Fn);

Line: 50

  end insert_row;

Line: 65

 SELECT *
 FROM FA_RX_REP_parameters
 WHERE ROWID = X_ROWID
 FOR UPDATE OF REPORT_ID, name NOWAIT;

Line: 77

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

Line: 102

  procedure update_row (X_rowid  in out nocopy varchar2,
	X_report_id    number,
	X_lov_id	number,
	X_name		varchar2,
	X_required	varchar2,
	X_max_length	number,
	X_datatype	varchar2,
	X_relop		varchar2,
	X_last_update_date date,
	X_last_updated_by  number,
	X_last_update_login  number,
	X_parameter_counter  number,
	X_column_name	varchar2,
	X_calling_fn	varchar2) is

  begin

  update fa_rx_rep_parameters set
	report_id = X_report_id,
	lov_id = X_lov_id,
	name = X_name,
	required = X_required,
	max_length = X_max_length,
	datatype = X_datatype,
	relational_op = X_relop,
	last_update_date = X_last_update_date,
	last_updated_by = X_last_updated_by,
	last_update_login = X_last_update_login,
	parameter_counter = X_parameter_counter,
	column_name = X_column_name
  where rowid = X_rowid;

Line: 140

                        (Called_Fn      => 'FA_RX_PARAMETERS_PKG.Update_Row',
                        Calling_Fn      => X_Calling_Fn);

Line: 144

  end update_row;

Line: 146

  procedure delete_row (X_rowid	varchar2,
	X_report_id	number,
	X_name		varchar2,
	X_calling_fn	varchar2) is
  begin

    if x_rowid is not null then
	delete from fa_rx_rep_parameters
	where rowid = X_rowid;

Line: 165

                        (Called_Fn      => 'FA_RX_PARAMETERS_PKG.Delete_Row',
                        Calling_Fn      => X_Calling_Fn);

Line: 167

  end delete_row;