APPS.HR_OWNER_DEFINITIONS_PKG SQL Statements

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

Line: 8

      select '1'
      from   hr_owner_definitions hod,
	     fnd_application_vl   app
      where  hod.product_short_name      = app.application_short_name
      and    upper(app.application_name) = upper(p_application_name)
      and    hod.session_id              = p_session_id
      and    ( p_rowid is null or
		( p_rowid is not null and p_rowid <> hod.rowid ) ) ;

Line: 30

  procedure insert_row(p_rowid                in out varchar2,
		       p_session_id	      in number ,
		       p_product_short_name   in varchar2 ) is
  --
  cursor c1 is
      select rowid
      from   hr_owner_definitions
      where  session_id         = p_session_id
      and    product_short_name = p_product_short_name ;

Line: 42

    insert into HR_OWNER_DEFINITIONS
	   ( SESSION_ID,
	     PRODUCT_SHORT_NAME )
    values ( p_session_id,
             p_product_short_name) ;

Line: 52

  end insert_row ;

Line: 54

  procedure delete_row(p_rowid   in varchar2) is
  --
  begin
  --
    delete from HR_OWNER_DEFINITIONS
    where  ROWID = p_rowid;

Line: 61

  end delete_row;