eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CUA_HIERARCHY_PKG dependencies on FA_ASSET_HIERARCHY

Line 11: from fa_asset_hierarchy_purpose

7: Function Validate_hierarchy_purpose(x_purpose_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
8: return Boolean
9: is
10: Cursor C_1 is select asset_hierarchy_purpose_id
11: from fa_asset_hierarchy_purpose
12: where asset_hierarchy_purpose_id = x_purpose_id;
13: l_purpose_id FA_ASSET_HIERARCHY_PURPOSE.asset_hierarchy_purpose_id%TYPE;
14: Begin
15: open C_1;

Line 13: l_purpose_id FA_ASSET_HIERARCHY_PURPOSE.asset_hierarchy_purpose_id%TYPE;

9: is
10: Cursor C_1 is select asset_hierarchy_purpose_id
11: from fa_asset_hierarchy_purpose
12: where asset_hierarchy_purpose_id = x_purpose_id;
13: l_purpose_id FA_ASSET_HIERARCHY_PURPOSE.asset_hierarchy_purpose_id%TYPE;
14: Begin
15: open C_1;
16: fetch C_1 into l_purpose_id;
17: if C_1%NOTFOUND then

Line 229: from fa_asset_hierarchy

225: ,x_purpose_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
226: return Boolean
227: is
228: Cursor C_NAME is select asset_hierarchy_id
229: from fa_asset_hierarchy
230: where name = x_name
231: and asset_hierarchy_purpose_id = x_purpose_id
232: and nvl(asset_id,0) = decode(x_node_type,'N',0,asset_id);
233: dummy number;

Line 279: cursor C is select ROWID from FA_ASSET_HIERARCHY

275: , X_ATTRIBUTE14 in varchar2
276: , X_ATTRIBUTE15 in varchar2
277: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
278: is
279: cursor C is select ROWID from FA_ASSET_HIERARCHY
280: where asset_hierarchy_id = X_asset_hierarchy_id ;
281:
282: CURSOR C1 is Select FA_ASSET_HIERARCHY_S.nextval from sys.dual;
283: l_name FA_ASSET_HIERARCHY.name%TYPE;

Line 282: CURSOR C1 is Select FA_ASSET_HIERARCHY_S.nextval from sys.dual;

278: is
279: cursor C is select ROWID from FA_ASSET_HIERARCHY
280: where asset_hierarchy_id = X_asset_hierarchy_id ;
281:
282: CURSOR C1 is Select FA_ASSET_HIERARCHY_S.nextval from sys.dual;
283: l_name FA_ASSET_HIERARCHY.name%TYPE;
284: begin
285: if X_asset_hierarchy_id is null then
286: open C1;

Line 283: l_name FA_ASSET_HIERARCHY.name%TYPE;

279: cursor C is select ROWID from FA_ASSET_HIERARCHY
280: where asset_hierarchy_id = X_asset_hierarchy_id ;
281:
282: CURSOR C1 is Select FA_ASSET_HIERARCHY_S.nextval from sys.dual;
283: l_name FA_ASSET_HIERARCHY.name%TYPE;
284: begin
285: if X_asset_hierarchy_id is null then
286: open C1;
287: fetch C1 into X_asset_hierarchy_id ;

Line 296: insert into FA_ASSET_HIERARCHY

292: AND x_name is null
293: ) then
294: l_name := to_char(x_asset_hierarchy_id);
295: end if;
296: insert into FA_ASSET_HIERARCHY
297: ( asset_hierarchy_purpose_id
298: , asset_hierarchy_id
299: , name
300: , level_number

Line 701: from FA_ASSET_HIERARCHY

697: ,x_purpose_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
698: return Boolean
699: is
700: Cursor C_name_insert is Select name
701: from FA_ASSET_HIERARCHY
702: where name = x_name
703: and decode(nvl(asset_id,0),0,'N','A') = decode(nvl(x_asset_id,0),0,'N','A')
704: and asset_hierarchy_purpose_id = x_purpose_id;
705: Cursor C_name_update is Select name

Line 706: from FA_ASSET_HIERARCHY

702: where name = x_name
703: and decode(nvl(asset_id,0),0,'N','A') = decode(nvl(x_asset_id,0),0,'N','A')
704: and asset_hierarchy_purpose_id = x_purpose_id;
705: Cursor C_name_update is Select name
706: from FA_ASSET_HIERARCHY
707: where name = x_name
708: and decode(nvl(asset_id,0),0,'N','A') = decode(nvl(x_asset_id,0),0,'N','A')
709: and asset_hierarchy_purpose_id = x_purpose_id
710: and asset_hierarchy_id <> nvl(x_asset_hierarchy_id,0);

Line 711: l_name fa_asset_hierarchy.name%TYPE;

707: where name = x_name
708: and decode(nvl(asset_id,0),0,'N','A') = decode(nvl(x_asset_id,0),0,'N','A')
709: and asset_hierarchy_purpose_id = x_purpose_id
710: and asset_hierarchy_id <> nvl(x_asset_hierarchy_id,0);
711: l_name fa_asset_hierarchy.name%TYPE;
712: Begin
713: if(x_event = 'INSERT') then
714: -- validate for name uniqueness if passed
715: -- x_err_stage := 'Validating name uniqueness';

Line 766: v_name FA_ASSET_HIERARCHY.name%TYPE;

762: */
763: l_old_err_stack varchar2(640);
764: v_book_class FA_BOOK_CONTROLS.book_class%TYPE;
765: v_book_type_code FA_BOOK_CONTROLS.book_type_code%TYPE;
766: v_name FA_ASSET_HIERARCHY.name%TYPE;
767: dummy number;
768: l_book_type_code varchar2(30);
769: v_mandatory_asset_flag varchar2(1);
770:

Line 787: select book_type_code from FA_ASSET_HIERARCHY_PURPOSE

783: Cursor C_BOOK is
784: Select book_class from FA_BOOK_CONTROLS
785: where book_type_code = x_book_type_code;
786: Cursor C_PARENT is
787: select book_type_code from FA_ASSET_HIERARCHY_PURPOSE
788: where asset_hierarchy_purpose_id = (Select asset_hierarchy_purpose_id
789: from fa_asset_hierarchy
790: where asset_hierarchy_id = x_parent_hierarchy_id);
791: Cursor C_RULE is

Line 789: from fa_asset_hierarchy

785: where book_type_code = x_book_type_code;
786: Cursor C_PARENT is
787: select book_type_code from FA_ASSET_HIERARCHY_PURPOSE
788: where asset_hierarchy_purpose_id = (Select asset_hierarchy_purpose_id
789: from fa_asset_hierarchy
790: where asset_hierarchy_id = x_parent_hierarchy_id);
791: Cursor C_RULE is
792: Select book_type_code from FA_HIERARCHY_RULE_SET
793: where hierarchy_rule_set_id = x_hierarchy_rule_set_id;

Line 795: from FA_ASSET_HIERARCHY_PURPOSE

791: Cursor C_RULE is
792: Select book_type_code from FA_HIERARCHY_RULE_SET
793: where hierarchy_rule_set_id = x_hierarchy_rule_set_id;
794: Cursor C_PURPOSE is select asset_hierarchy_purpose_id,mandatory_asset_flag
795: from FA_ASSET_HIERARCHY_PURPOSE
796: where book_type_code = x_book_type_code;
797:
798: Cursor C_PERMIT_LEVELS is
799: select nvl(permissible_levels,0)

Line 800: from FA_ASSET_HIERARCHY_PURPOSE

796: where book_type_code = x_book_type_code;
797:
798: Cursor C_PERMIT_LEVELS is
799: select nvl(permissible_levels,0)
800: from FA_ASSET_HIERARCHY_PURPOSE
801: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
802: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
803: purpose_rec C_PURPOSE%ROWTYPE;
804:

Line 802: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;

798: Cursor C_PERMIT_LEVELS is
799: select nvl(permissible_levels,0)
800: from FA_ASSET_HIERARCHY_PURPOSE
801: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
802: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
803: purpose_rec C_PURPOSE%ROWTYPE;
804:
805: Cursor C_PARENT_LEVEL is select level_number
806: from FA_ASSET_HIERARCHY

Line 806: from FA_ASSET_HIERARCHY

802: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
803: purpose_rec C_PURPOSE%ROWTYPE;
804:
805: Cursor C_PARENT_LEVEL is select level_number
806: from FA_ASSET_HIERARCHY
807: where asset_hierarchy_id = x_parent_hierarchy_id;
808: v_parent_level number;
809: Begin
810: x_err_code := '0';

Line 818: from fa_asset_hierarchy_purpose

814: x_err_stage := 'Validating Purpose ID';
815: If (nvl(x_asset_hierarchy_purpose_id,0) <> 0) then
816: Begin
817: select 1 into dummy
818: from fa_asset_hierarchy_purpose
819: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
820: Exception
821: when no_data_found then
822: raise INVALID_PURPOSE_ID;

Line 1122: x_err_stage := 'Inserting into FA_ASSET_HIERARCHY_VALES table';

1118: if(x_err_code <> '0') then
1119: rollback work;
1120: return;
1121: else
1122: x_err_stage := 'Inserting into FA_ASSET_HIERARCHY_VALES table';
1123: if (x_attribute_book_type_code is not null
1124: AND ( x_asset_category_id is not null
1125: OR x_lease_id is not null
1126: OR x_asset_key_ccid is not null

Line 1222: from FA_ASSET_HIERARCHY_PURPOSE

1218: , X_ATTRIBUTE15 in VARCHAR2 default null
1219: ,p_log_level_rec IN fa_api_types.log_level_rec_type)
1220: is
1221: Cursor C_PURPOSE_BOOK is select book_type_code
1222: from FA_ASSET_HIERARCHY_PURPOSE
1223: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
1224:
1225: CURSOR C_NAME1 is SELECT ASSET_HIERARCHY_ID
1226: FROM FA_ASSET_HIERARCHY

Line 1226: FROM FA_ASSET_HIERARCHY

1222: from FA_ASSET_HIERARCHY_PURPOSE
1223: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
1224:
1225: CURSOR C_NAME1 is SELECT ASSET_HIERARCHY_ID
1226: FROM FA_ASSET_HIERARCHY
1227: WHERE NAME = x_name
1228: AND NVL (ASSET_ID, 0) = 0
1229: AND ASSET_HIERARCHY_PURPOSE_ID = x_asset_hierarchy_purpose_id;
1230:

Line 1232: FROM FA_ASSET_HIERARCHY

1228: AND NVL (ASSET_ID, 0) = 0
1229: AND ASSET_HIERARCHY_PURPOSE_ID = x_asset_hierarchy_purpose_id;
1230:
1231: CURSOR C_NAME2 is SELECT ASSET_HIERARCHY_ID
1232: FROM FA_ASSET_HIERARCHY
1233: WHERE NAME = x_name
1234: AND ASSET_ID = x_asset_id
1235: AND ASSET_HIERARCHY_PURPOSE_ID = x_asset_hierarchy_purpose_id;
1236:

Line 1238: from FA_ASSET_HIERARCHY_PURPOSE

1234: AND ASSET_ID = x_asset_id
1235: AND ASSET_HIERARCHY_PURPOSE_ID = x_asset_hierarchy_purpose_id;
1236:
1237: Cursor C_PERMIT_LEVELS is select nvl(permissible_levels,0)
1238: from FA_ASSET_HIERARCHY_PURPOSE
1239: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
1240: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
1241: l_rowid varchar2(30);
1242: l_old_err_stack varchar2(240);

Line 1240: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;

1236:
1237: Cursor C_PERMIT_LEVELS is select nvl(permissible_levels,0)
1238: from FA_ASSET_HIERARCHY_PURPOSE
1239: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
1240: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
1241: l_rowid varchar2(30);
1242: l_old_err_stack varchar2(240);
1243: l_book_type_code varchar2(30);
1244: l_asset_hierarchy_purpose_id number;

Line 1468: from FA_ASSET_HIERARCHY

1464: , ATTRIBUTE12
1465: , ATTRIBUTE13
1466: , ATTRIBUTE14
1467: , ATTRIBUTE15
1468: from FA_ASSET_HIERARCHY
1469: where asset_hierarchy_id = x_asset_hierarchy_id
1470: and nvl(asset_hierarchy_purpose_id,1) = nvl(x_asset_hierarchy_purpose_id,1)
1471: for update of asset_hierarchy_id nowait;
1472: tlinfo c1%rowtype;

Line 1670: update FA_ASSET_HIERARCHY set

1666: , X_ATTRIBUTE14 in VARCHAR2
1667: , X_ATTRIBUTE15 in VARCHAR2
1668: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)is
1669: begin
1670: update FA_ASSET_HIERARCHY set
1671: name = x_name,
1672: --level_number = x_level_number, --Level number is Non Updateable
1673: hierarchy_rule_set_id = x_hierarchy_rule_set_id,
1674: description = x_description,

Line 1710: delete from FA_ASSET_HIERARCHY

1706: x_asset_hierarchy_purpose_id in number
1707: , X_asset_hierarchy_id in NUMBER
1708: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
1709: begin
1710: delete from FA_ASSET_HIERARCHY
1711: where asset_hierarchy_id = X_asset_hierarchy_id
1712: and nvl(asset_hierarchy_purpose_id,1) = nvl(x_asset_hierarchy_purpose_id,1);
1713: if (sql%notfound) then
1714: raise no_data_found;

Line 1723: select nvl(asset_id,0) from FA_ASSET_HIERARCHY

1719: return boolean
1720: is
1721: v_asset_id number;
1722: cursor C is
1723: select nvl(asset_id,0) from FA_ASSET_HIERARCHY
1724: where asset_hierarchy_id = x_asset_hierarchy_id;
1725: Begin
1726: open C;
1727: fetch C into v_asset_id;

Line 1772: select 1 into dummy from fa_asset_hierarchy

1768: return Boolean
1769: is
1770: dummy number;
1771: Begin
1772: select 1 into dummy from fa_asset_hierarchy
1773: where asset_hierarchy_id = x_asset_hierarchy_id
1774: and nvl(asset_id,0) = 0
1775: and not exists (Select 1
1776: from fa_asset_hierarchy a

Line 1776: from fa_asset_hierarchy a

1772: select 1 into dummy from fa_asset_hierarchy
1773: where asset_hierarchy_id = x_asset_hierarchy_id
1774: and nvl(asset_id,0) = 0
1775: and not exists (Select 1
1776: from fa_asset_hierarchy a
1777: where nvl(a.asset_id,0) = 0
1778: and a.parent_hierarchy_id = x_asset_hierarchy_id);
1779: return(TRUE);
1780: exception

Line 1789: from fa_asset_hierarchy

1785: Function check_asset_node(x_asset_hierarchy_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1786: return Boolean
1787: is
1788: cursor C is select nvl(asset_id,0)
1789: from fa_asset_hierarchy
1790: where asset_hierarchy_id = x_asset_hierarchy_id;
1791: v_asset_id number;
1792: dummy number;
1793: Begin

Line 1811: where exists (Select 1 from fa_asset_hierarchy

1807: dummy number;
1808: Begin
1809: select 1 into dummy
1810: from dual
1811: where exists (Select 1 from fa_asset_hierarchy
1812: where parent_hierarchy_id = x_asset_hierarchy_id
1813: and nvl(asset_id,0) <> 0);
1814: return (TRUE);
1815: Exception

Line 1826: where exists(select 1 from fa_asset_hierarchy

1822: is
1823: dummy number;
1824: begin
1825: select 1 into dummy from dual
1826: where exists(select 1 from fa_asset_hierarchy
1827: where parent_hierarchy_id = x_asset_hierarchy_id);
1828: return(TRUE);
1829: Exception
1830: when no_data_found then

Line 1841: from fa_asset_hierarchy

1837: dummy number;
1838: Begin
1839: select 1 into dummy from dual
1840: where exists ( select asset_hierarchy_id
1841: from fa_asset_hierarchy
1842: where nvl(asset_id,0) <> 0
1843: start with asset_hierarchy_id = x_node_id
1844: connect by prior asset_hierarchy_id = parent_hierarchy_id);
1845: return(TRUE);