APPS.FA_CUA_HR_DISTRIBUTION_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_distribution_id    in out nocopy number
             , x_dist_set_id      in number
             , x_book_type_code in varchar2
             , x_distribution_line_percentage  in number
             , x_code_combination_id in number
             , x_location_id    in number
             , x_assigned_to    in number
             , X_CREATION_DATE  in date
             , X_CREATED_BY     in number
             , X_LAST_UPDATE_DATE   in date
             , X_LAST_UPDATED_BY    in number
             , X_LAST_UPDATE_LOGIN  in number
    )
 is
 Cursor C1 is Select ROWID from FA_HIERARCHY_DISTRIBUTIONS
    where distribution_id = x_distribution_id;

Line: 21

 CURSOR C is Select FA_HIERARCHY_DISTRIBUTIONS_S.nextval from sys.dual;

Line: 28

    insert into FA_HIERARCHY_DISTRIBUTIONS
                     (      distribution_id
                 ,  dist_set_id
                         ,  book_type_code
                         ,  distribution_line_percentage
                         ,  code_combination_id
                         ,  location_id
                         ,  assigned_to
                         ,  CREATION_DATE
                         ,  CREATED_BY
                         ,  LAST_UPDATE_DATE
                         ,  LAST_UPDATED_BY
                         ,  LAST_UPDATE_LOGIN
                      ) Values
                      (    x_distribution_id
                 , x_dist_set_id
                         , x_book_type_code
                         , x_distribution_line_percentage
                         , x_code_combination_id
                         , x_location_id
                         , x_assigned_to
                         , X_CREATION_DATE
                         , X_CREATED_BY
                         , X_LAST_UPDATE_DATE
                         , X_LAST_UPDATED_BY
                         , X_LAST_UPDATE_LOGIN
            );

Line: 63

   end INSERT_ROW;

Line: 78

   Select
          book_type_code
        , distribution_id
        , dist_set_id
        , distribution_line_percentage
        , code_combination_id
        , location_id
        , assigned_to
   from FA_HIERARCHY_DISTRIBUTIONS
   where rowid = x_rowid
   FOR UPDATE NOWAIT;

Line: 94

    FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 124

procedure UPDATE_ROW (    x_rowid       in  varchar2
             , x_distribution_id    in  number
         , x_dist_set_id        in number
             , x_book_type_code in varchar2
             , x_distribution_line_percentage  in number
             , x_code_combination_id in number
             , x_location_id    in number
             , x_assigned_to    in number
             , X_LAST_UPDATE_DATE   in date
             , X_LAST_UPDATED_BY    in number
             , X_LAST_UPDATE_LOGIN  in number
            )
is
Begin
update FA_HIERARCHY_DISTRIBUTIONS
  set
       book_type_code = x_book_type_code
     , distribution_line_percentage = x_distribution_line_percentage
     , code_combination_id = x_code_combination_id
     , location_id = x_location_id
     , assigned_to =  x_assigned_to
     , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
     , LAST_UPDATED_BY = X_LAST_UPDATED_BY
     , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where rowid = x_rowid;

Line: 152

End update_row;

Line: 154

procedure DELETE_ROW (
                         x_rowid      in varchar2
            )
is
Begin
 delete from FA_HIERARCHY_DISTRIBUTIONS
 where rowid = x_rowid;

Line: 164

End delete_row;