APPS.PAY_USER_COLUMN_INSTANCES_PKG SQL Statements

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

Line: 5

  procedure insert_row(p_rowid			 in out varchar2,
                       p_user_column_instance_id in out number,
                       p_effective_start_date    in date,
                       p_effective_end_date      in date,
                       p_user_row_id             in number,
                       p_user_column_id          in number,
                       p_business_group_id       in number,
                       p_legislation_code        in varchar2,
                       p_legislation_subgroup    in varchar2,
                       p_value                   in varchar2 )  is
  --
  cursor c1 is
      select pay_user_column_instances_s.nextval
      from   sys.dual ;

Line: 21

      select rowid
      from   pay_user_column_instances_f
      where  user_column_instance_id  = p_user_column_instance_id ;

Line: 31

    insert into PAY_USER_COLUMN_INSTANCES_F
    ( USER_COLUMN_INSTANCE_ID,
      EFFECTIVE_START_DATE,
      EFFECTIVE_END_DATE,
      USER_ROW_ID,
      USER_COLUMN_ID,
      BUSINESS_GROUP_ID,
      LEGISLATION_CODE,
      LEGISLATION_SUBGROUP,
      VALUE )
    values ( p_user_column_instance_id ,
             p_effective_start_date ,
             p_effective_end_date ,
             p_user_row_id ,
             p_user_column_id ,
             p_business_group_id ,
             p_legislation_code ,
             p_legislation_subgroup ,
             p_value ) ;

Line: 56

  end insert_row ;

Line: 58

  procedure update_row(p_rowid			 in varchar2,
                       p_user_column_instance_id in number,
                       p_effective_start_date    in date,
                       p_effective_end_date      in date,
                       p_user_row_id             in number,
                       p_user_column_id          in number,
                       p_business_group_id       in number,
                       p_legislation_code        in varchar2,
                       p_legislation_subgroup    in varchar2,
                       p_value                   in varchar2 )  is
  begin
  --
   update PAY_USER_COLUMN_INSTANCES_F
   set    USER_COLUMN_INSTANCE_ID = p_user_column_instance_id,
          EFFECTIVE_START_DATE    = p_effective_start_date ,
          EFFECTIVE_END_DATE      = p_effective_end_date ,
          USER_ROW_ID		  = p_user_row_id,
          USER_COLUMN_ID	  = p_user_column_id,
          BUSINESS_GROUP_ID       = p_business_group_id,
          LEGISLATION_CODE        = p_legislation_code ,
          LEGISLATION_SUBGROUP    = p_legislation_subgroup,
          VALUE                   = p_value
   where  ROWID = p_rowid;

Line: 82

  end update_row;

Line: 84

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

Line: 91

  end delete_row;

Line: 104

    cursor C is select *
                from   PAY_USER_COLUMN_INSTANCES_F
                where  rowid = p_rowid
                for update of USER_COLUMN_INSTANCE_ID NOWAIT ;

Line: 155

   select max(effective_end_date)
   from   pay_user_rows_f
   where  user_row_id = p_user_row_id ;