APPS.FA_CUA_HIERARCHY_PURPOSE_PKG dependencies on FA_ASSET_HIERARCHY_PURPOSE

Line 21: cursor C is select ROWID from FA_ASSET_HIERARCHY_PURPOSE

17: , x_rule_set_level in varchar2
18: , x_permissible_levels in number
19: )
20: is
21: cursor C is select ROWID from FA_ASSET_HIERARCHY_PURPOSE
22: where asset_hierarchy_purpose_id = X_asset_hierarchy_purpose_id ;
23:
24: CURSOR C1 is Select FA_ASSET_HIERARCHY_PURPOSE_S.nextval from sys.dual;
25: begin

Line 24: CURSOR C1 is Select FA_ASSET_HIERARCHY_PURPOSE_S.nextval from sys.dual;

20: is
21: cursor C is select ROWID from FA_ASSET_HIERARCHY_PURPOSE
22: where asset_hierarchy_purpose_id = X_asset_hierarchy_purpose_id ;
23:
24: CURSOR C1 is Select FA_ASSET_HIERARCHY_PURPOSE_S.nextval from sys.dual;
25: begin
26: if X_asset_hierarchy_purpose_id is null then
27: open C1;
28: fetch C1 into X_asset_hierarchy_purpose_id ;

Line 31: insert into FA_ASSET_HIERARCHY_PURPOSE

27: open C1;
28: fetch C1 into X_asset_hierarchy_purpose_id ;
29: close C1;
30: end if;
31: insert into FA_ASSET_HIERARCHY_PURPOSE
32: ( asset_hierarchy_purpose_id
33: , name
34: , purpose_type
35: , book_type_code

Line 92: from FA_ASSET_HIERARCHY_PURPOSE

88: , description
89: , mandatory_asset_flag
90: , rule_set_level
91: , permissible_levels
92: from FA_ASSET_HIERARCHY_PURPOSE
93: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id
94: for update of asset_hierarchy_purpose_id nowait;
95: tlinfo c1%rowtype;
96: begin

Line 148: update FA_ASSET_HIERARCHY_PURPOSE

144: , x_permissible_levels in number
145: )
146: is
147: begin
148: update FA_ASSET_HIERARCHY_PURPOSE
149: set
150: name = x_name,
151: purpose_type = x_purpose_type,
152: book_type_code = x_book_type_code,

Line 170: delete from FA_ASSET_HIERARCHY_PURPOSE

166: x_asset_hierarchy_purpose_id in number
167: )
168: is
169: begin
170: delete from FA_ASSET_HIERARCHY_PURPOSE
171: where asset_hierarchy_purpose_id = X_asset_hierarchy_purpose_id;
172: if (sql%notfound) then
173: raise no_data_found;
174: end if;