APPS.FA_CUA_HR_RULE_DETAILS_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_hierarchy_rule_set_id    		in number
                         , x_attribute_name           		in varchar2
			 , x_book_type_code			in varchar2
                         , x_include_hierarchy_flag   		in varchar2
                         , x_include_level            		in varchar2
                         , x_include_asset_catg_life_flag   	in varchar2
                         , x_include_catg_end_date_flag  	in varchar2
                         , x_include_asset_end_date_flag 	in varchar2
                         , x_include_lease_end_date_flag 	in varchar2
                         , x_basis_code			   	in varchar2
                         , x_precedence_level			in varchar2
                         , x_override_allowed_flag		in varchar2
                         , x_target_flag			in varchar2
                         , 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
        , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type  default null)
	is
	   cursor C is select ROWID from FA_HIERARCHY_RULE_DETAILS
         where hierarchy_rule_set_id = X_hierarchy_rule_set_id
	   and attribute_name = x_attribute_name
	   and book_type_code = x_book_type_code ;

Line: 30

         Insert into FA_HIERARCHY_RULE_DETAILS
			 ( hierarchy_rule_set_id
                         , attribute_name
			 , book_type_code
                         , include_hierarchy_flag
                         , include_level
                         , include_asset_catg_life_flag
                         , include_catg_end_date_flag
                         , include_asset_end_date_flag
                         , include_lease_end_date_flag
                         , basis_code
                         , precedence_level
                         , override_allowed_flag
                         , target_flag
                         , CREATION_DATE
                         , CREATED_BY
                         , LAST_UPDATE_DATE
                         , LAST_UPDATED_BY
                         , LAST_UPDATE_LOGIN   )
		Values (   x_hierarchy_rule_set_id
                         , x_attribute_name
			 , x_book_type_code
                         , x_include_hierarchy_flag
                         , x_include_level
                         , x_include_asset_catg_life_flag
                         , x_include_catg_end_date_flag
                         , x_include_asset_end_date_flag
                         , x_include_lease_end_date_flag
                         , x_basis_code
                         , x_precedence_level
                         , x_override_allowed_flag
                         , x_target_flag
                         , X_CREATION_DATE
                         , X_CREATED_BY
                         , X_LAST_UPDATE_DATE
                         , X_LAST_UPDATED_BY
                         , X_LAST_UPDATE_LOGIN   );

Line: 74

end INSERT_ROW;

Line: 96

select hierarchy_rule_set_id
      	, attribute_name
 	, book_type_code
        , include_hierarchy_flag
        , include_level
        , include_asset_catg_life_flag
        , include_catg_end_date_flag
        , include_asset_end_date_flag
        , include_lease_end_date_flag
        , basis_code
        , precedence_level
        , override_allowed_flag
        , target_flag
from fa_hierarchy_rule_details
where rowid = x_rowid
for update of hierarchy_rule_set_id nowait;

Line: 167

procedure UPDATE_ROW (
   			   x_rowid          		in varchar2
                         , x_hierarchy_rule_set_id    	in number
                         , x_attribute_name           	in varchar2
			 , x_book_type_code		in varchar2
                         , x_include_hierarchy_flag   	in varchar2
                         , x_include_level            	in varchar2
                         , x_include_asset_catg_life_flag   in varchar2
                         , x_include_catg_end_date_flag	in varchar2
                         , x_include_asset_end_date_flag in varchar2
                         , x_include_lease_end_date_flag in varchar2
                         , x_basis_code			in varchar2
                         , x_precedence_level		in varchar2
                         , x_override_allowed_flag	in varchar2
                         , x_target_flag		in varchar2
                         , X_LAST_UPDATE_DATE   	in date
                         , X_LAST_UPDATED_BY    	in number
                         , X_LAST_UPDATE_LOGIN  	in number
  , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type   default null)
  is
  begin
	update fa_hierarchy_rule_details
	set 	  hierarchy_rule_set_id = x_hierarchy_rule_set_id
      		, attribute_name = x_attribute_name
		, book_type_code = x_book_type_code
		, include_hierarchy_flag = x_include_hierarchy_flag
		, include_level = x_include_level
		, include_asset_catg_life_flag = x_include_asset_catg_life_flag
		, include_catg_end_date_flag = x_include_catg_end_date_flag
		, include_asset_end_date_flag = x_include_asset_end_date_flag
		, include_lease_end_date_flag = x_include_lease_end_date_flag
		, basis_code = x_basis_code
		, precedence_level = x_precedence_level
		, override_allowed_flag = x_override_allowed_flag
		, target_flag = x_target_flag
		, 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: 209

end UPDATE_ROW;

Line: 213

procedure DELETE_ROW (
  x_rowid          			in varchar2
, p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type   default null) is
begin
  delete from FA_HIERARCHY_RULE_DETAILS
  where rowid = x_rowid;

Line: 222

end DELETE_ROW;