APPS.FA_CUA_HIERARCHY_PURPOSE_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_asset_hierarchy_purpose_id in out nocopy number
                         , x_name               	in varchar2
			 , x_purpose_type		in varchar2
			 , x_book_type_code		in varchar2
                         , x_default_rule_set_id        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
                         , x_description          	in varchar2
                         , x_mandatory_asset_flag  	in varchar2
                         , x_rule_set_level    	        in varchar2
			 , x_permissible_levels		in number
        )
is
 cursor C is select ROWID from FA_ASSET_HIERARCHY_PURPOSE
      where asset_hierarchy_purpose_id = X_asset_hierarchy_purpose_id ;

Line: 24

      CURSOR C1 is Select FA_ASSET_HIERARCHY_PURPOSE_S.nextval from sys.dual;

Line: 31

     insert into FA_ASSET_HIERARCHY_PURPOSE
    (      asset_hierarchy_purpose_id
         , name
	 , purpose_type
         , book_type_code
         , default_rule_set_id
         , CREATION_DATE
         , CREATED_BY
         , LAST_UPDATE_DATE
         , LAST_UPDATED_BY
         , LAST_UPDATE_LOGIN
         , description
         , mandatory_asset_flag
         , rule_set_level
	 , permissible_levels
    )Values
   (	   x_asset_hierarchy_purpose_id
         , x_name
         , x_purpose_type
         , x_book_type_code
         , x_default_rule_set_id
         , x_CREATION_DATE
         , x_CREATED_BY
         , x_LAST_UPDATE_DATE
         , x_LAST_UPDATED_BY
         , x_LAST_UPDATE_LOGIN
         , x_description
         , x_mandatory_asset_flag
         , x_rule_set_level
	 , x_permissible_levels
   );

Line: 69

end INSERT_ROW;

Line: 83

  cursor c1 is select
  name
, purpose_type
, book_type_code
, default_rule_set_id
, description
, mandatory_asset_flag
, rule_set_level
, permissible_levels
  from FA_ASSET_HIERARCHY_PURPOSE
    where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id
    for update of asset_hierarchy_purpose_id nowait;

Line: 131

procedure UPDATE_ROW (
 			   x_rowid                      in out nocopy varchar2
                         , x_asset_hierarchy_purpose_id in  number
                         , x_name                       in varchar2
                         , x_purpose_type               in varchar2
                         , x_book_type_code             in varchar2
                         , x_default_rule_set_id        in number
                         , X_LAST_UPDATE_DATE           in date
                         , X_LAST_UPDATED_BY            in number
                         , X_LAST_UPDATE_LOGIN          in number
                         , x_description                in varchar2
                         , x_mandatory_asset_flag       in varchar2
                         , x_rule_set_level             in varchar2
			 , x_permissible_levels		in number
  )
is
begin
   update FA_ASSET_HIERARCHY_PURPOSE
set
        name = x_name,
	purpose_type = x_purpose_type,
        book_type_code = x_book_type_code,
        default_rule_set_id  = x_default_rule_set_id,
        description = x_description,
        mandatory_asset_flag = x_mandatory_asset_flag,
        rule_set_level = x_rule_set_level,
	permissible_levels = x_permissible_levels
 where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;

Line: 162

end UPDATE_ROW;

Line: 165

procedure DELETE_ROW (
  x_asset_hierarchy_purpose_id in number
)
is
 begin
  delete from FA_ASSET_HIERARCHY_PURPOSE
  where asset_hierarchy_purpose_id = X_asset_hierarchy_purpose_id;

Line: 175

end DELETE_ROW;