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)
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)
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: )
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 694: from FA_ASSET_HIERARCHY

690: ,x_purpose_id in number)
691: return Boolean
692: is
693: Cursor C_name_insert is Select name
694: from FA_ASSET_HIERARCHY
695: where name = x_name
696: and decode(nvl(asset_id,0),0,'N','A') = decode(nvl(x_asset_id,0),0,'N','A')
697: and asset_hierarchy_purpose_id = x_purpose_id;
698: Cursor C_name_update is Select name

Line 699: from FA_ASSET_HIERARCHY

695: where name = x_name
696: and decode(nvl(asset_id,0),0,'N','A') = decode(nvl(x_asset_id,0),0,'N','A')
697: and asset_hierarchy_purpose_id = x_purpose_id;
698: Cursor C_name_update is Select name
699: from FA_ASSET_HIERARCHY
700: where name = x_name
701: and decode(nvl(asset_id,0),0,'N','A') = decode(nvl(x_asset_id,0),0,'N','A')
702: and asset_hierarchy_purpose_id = x_purpose_id
703: and asset_hierarchy_id <> nvl(x_asset_hierarchy_id,0);

Line 704: l_name fa_asset_hierarchy.name%TYPE;

700: where name = x_name
701: and decode(nvl(asset_id,0),0,'N','A') = decode(nvl(x_asset_id,0),0,'N','A')
702: and asset_hierarchy_purpose_id = x_purpose_id
703: and asset_hierarchy_id <> nvl(x_asset_hierarchy_id,0);
704: l_name fa_asset_hierarchy.name%TYPE;
705: Begin
706: if(x_event = 'INSERT') then
707: -- validate for name uniqueness if passed
708: -- x_err_stage := 'Validating name uniqueness';

Line 759: v_name FA_ASSET_HIERARCHY.name%TYPE;

755: */
756: l_old_err_stack varchar2(640);
757: v_book_class FA_BOOK_CONTROLS.book_class%TYPE;
758: v_book_type_code FA_BOOK_CONTROLS.book_type_code%TYPE;
759: v_name FA_ASSET_HIERARCHY.name%TYPE;
760: dummy number;
761: l_book_type_code varchar2(15);
762: v_mandatory_asset_flag varchar2(1);
763:

Line 780: select book_type_code from FA_ASSET_HIERARCHY_PURPOSE

776: Cursor C_BOOK is
777: Select book_class from FA_BOOK_CONTROLS
778: where book_type_code = x_book_type_code;
779: Cursor C_PARENT is
780: select book_type_code from FA_ASSET_HIERARCHY_PURPOSE
781: where asset_hierarchy_purpose_id = (Select asset_hierarchy_purpose_id
782: from fa_asset_hierarchy
783: where asset_hierarchy_id = x_parent_hierarchy_id);
784: Cursor C_RULE is

Line 782: from fa_asset_hierarchy

778: where book_type_code = x_book_type_code;
779: Cursor C_PARENT is
780: select book_type_code from FA_ASSET_HIERARCHY_PURPOSE
781: where asset_hierarchy_purpose_id = (Select asset_hierarchy_purpose_id
782: from fa_asset_hierarchy
783: where asset_hierarchy_id = x_parent_hierarchy_id);
784: Cursor C_RULE is
785: Select book_type_code from FA_HIERARCHY_RULE_SET
786: where hierarchy_rule_set_id = x_hierarchy_rule_set_id;

Line 788: from FA_ASSET_HIERARCHY_PURPOSE

784: Cursor C_RULE is
785: Select book_type_code from FA_HIERARCHY_RULE_SET
786: where hierarchy_rule_set_id = x_hierarchy_rule_set_id;
787: Cursor C_PURPOSE is select asset_hierarchy_purpose_id,mandatory_asset_flag
788: from FA_ASSET_HIERARCHY_PURPOSE
789: where book_type_code = x_book_type_code;
790:
791: Cursor C_PERMIT_LEVELS is
792: select nvl(permissible_levels,0)

Line 793: from FA_ASSET_HIERARCHY_PURPOSE

789: where book_type_code = x_book_type_code;
790:
791: Cursor C_PERMIT_LEVELS is
792: select nvl(permissible_levels,0)
793: from FA_ASSET_HIERARCHY_PURPOSE
794: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
795: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
796: purpose_rec C_PURPOSE%ROWTYPE;
797:

Line 795: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;

791: Cursor C_PERMIT_LEVELS is
792: select nvl(permissible_levels,0)
793: from FA_ASSET_HIERARCHY_PURPOSE
794: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
795: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
796: purpose_rec C_PURPOSE%ROWTYPE;
797:
798: Cursor C_PARENT_LEVEL is select level_number
799: from FA_ASSET_HIERARCHY

Line 799: from FA_ASSET_HIERARCHY

795: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
796: purpose_rec C_PURPOSE%ROWTYPE;
797:
798: Cursor C_PARENT_LEVEL is select level_number
799: from FA_ASSET_HIERARCHY
800: where asset_hierarchy_id = x_parent_hierarchy_id;
801: v_parent_level number;
802: Begin
803: x_err_code := '0';

Line 811: from fa_asset_hierarchy_purpose

807: x_err_stage := 'Validating Purpose ID';
808: If (nvl(x_asset_hierarchy_purpose_id,0) <> 0) then
809: Begin
810: select 1 into dummy
811: from fa_asset_hierarchy_purpose
812: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
813: Exception
814: when no_data_found then
815: raise INVALID_PURPOSE_ID;

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

1111: if(x_err_code <> '0') then
1112: rollback work;
1113: return;
1114: else
1115: x_err_stage := 'Inserting into FA_ASSET_HIERARCHY_VALES table';
1116: if (x_attribute_book_type_code is not null
1117: AND ( x_asset_category_id is not null
1118: OR x_lease_id is not null
1119: OR x_asset_key_ccid is not null

Line 1215: from FA_ASSET_HIERARCHY_PURPOSE

1211: , X_ATTRIBUTE15 in VARCHAR2 default null
1212: )
1213: is
1214: Cursor C_PURPOSE_BOOK is select book_type_code
1215: from FA_ASSET_HIERARCHY_PURPOSE
1216: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
1217:
1218: CURSOR C_NAME1 is SELECT ASSET_HIERARCHY_ID
1219: FROM FA_ASSET_HIERARCHY

Line 1219: FROM FA_ASSET_HIERARCHY

1215: from FA_ASSET_HIERARCHY_PURPOSE
1216: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
1217:
1218: CURSOR C_NAME1 is SELECT ASSET_HIERARCHY_ID
1219: FROM FA_ASSET_HIERARCHY
1220: WHERE NAME = x_name
1221: AND NVL (ASSET_ID, 0) = 0
1222: AND ASSET_HIERARCHY_PURPOSE_ID = x_asset_hierarchy_purpose_id;
1223:

Line 1225: FROM FA_ASSET_HIERARCHY

1221: AND NVL (ASSET_ID, 0) = 0
1222: AND ASSET_HIERARCHY_PURPOSE_ID = x_asset_hierarchy_purpose_id;
1223:
1224: CURSOR C_NAME2 is SELECT ASSET_HIERARCHY_ID
1225: FROM FA_ASSET_HIERARCHY
1226: WHERE NAME = x_name
1227: AND ASSET_ID = x_asset_id
1228: AND ASSET_HIERARCHY_PURPOSE_ID = x_asset_hierarchy_purpose_id;
1229:

Line 1231: from FA_ASSET_HIERARCHY_PURPOSE

1227: AND ASSET_ID = x_asset_id
1228: AND ASSET_HIERARCHY_PURPOSE_ID = x_asset_hierarchy_purpose_id;
1229:
1230: Cursor C_PERMIT_LEVELS is select nvl(permissible_levels,0)
1231: from FA_ASSET_HIERARCHY_PURPOSE
1232: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
1233: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
1234: l_rowid varchar2(30);
1235: l_old_err_stack varchar2(240);

Line 1233: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;

1229:
1230: Cursor C_PERMIT_LEVELS is select nvl(permissible_levels,0)
1231: from FA_ASSET_HIERARCHY_PURPOSE
1232: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id;
1233: v_permit_levels FA_ASSET_HIERARCHY_PURPOSE.permissible_levels%TYPE;
1234: l_rowid varchar2(30);
1235: l_old_err_stack varchar2(240);
1236: l_book_type_code varchar2(15);
1237: l_asset_hierarchy_purpose_id number;

Line 1460: from FA_ASSET_HIERARCHY

1456: , ATTRIBUTE12
1457: , ATTRIBUTE13
1458: , ATTRIBUTE14
1459: , ATTRIBUTE15
1460: from FA_ASSET_HIERARCHY
1461: where asset_hierarchy_id = x_asset_hierarchy_id
1462: and nvl(asset_hierarchy_purpose_id,1) = nvl(x_asset_hierarchy_purpose_id,1)
1463: for update of asset_hierarchy_id nowait;
1464: tlinfo c1%rowtype;

Line 1662: update FA_ASSET_HIERARCHY set

1658: , X_ATTRIBUTE14 in VARCHAR2
1659: , X_ATTRIBUTE15 in VARCHAR2
1660: )is
1661: begin
1662: update FA_ASSET_HIERARCHY set
1663: name = x_name,
1664: --level_number = x_level_number, --Level number is Non Updateable
1665: hierarchy_rule_set_id = x_hierarchy_rule_set_id,
1666: description = x_description,

Line 1702: delete from FA_ASSET_HIERARCHY

1698: x_asset_hierarchy_purpose_id in number
1699: , X_asset_hierarchy_id in NUMBER
1700: ) is
1701: begin
1702: delete from FA_ASSET_HIERARCHY
1703: where asset_hierarchy_id = X_asset_hierarchy_id
1704: and nvl(asset_hierarchy_purpose_id,1) = nvl(x_asset_hierarchy_purpose_id,1);
1705: if (sql%notfound) then
1706: raise no_data_found;

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

1711: return boolean
1712: is
1713: v_asset_id number;
1714: cursor C is
1715: select nvl(asset_id,0) from FA_ASSET_HIERARCHY
1716: where asset_hierarchy_id = x_asset_hierarchy_id;
1717: Begin
1718: open C;
1719: fetch C into v_asset_id;

Line 1764: select 1 into dummy from fa_asset_hierarchy

1760: return Boolean
1761: is
1762: dummy number;
1763: Begin
1764: select 1 into dummy from fa_asset_hierarchy
1765: where asset_hierarchy_id = x_asset_hierarchy_id
1766: and nvl(asset_id,0) = 0
1767: and not exists (Select 1
1768: from fa_asset_hierarchy a

Line 1768: from fa_asset_hierarchy a

1764: select 1 into dummy from fa_asset_hierarchy
1765: where asset_hierarchy_id = x_asset_hierarchy_id
1766: and nvl(asset_id,0) = 0
1767: and not exists (Select 1
1768: from fa_asset_hierarchy a
1769: where nvl(a.asset_id,0) = 0
1770: and a.parent_hierarchy_id = x_asset_hierarchy_id);
1771: return(TRUE);
1772: exception

Line 1781: from fa_asset_hierarchy

1777: Function check_asset_node(x_asset_hierarchy_id in number)
1778: return Boolean
1779: is
1780: cursor C is select nvl(asset_id,0)
1781: from fa_asset_hierarchy
1782: where asset_hierarchy_id = x_asset_hierarchy_id;
1783: v_asset_id number;
1784: dummy number;
1785: Begin

Line 1803: where exists (Select 1 from fa_asset_hierarchy

1799: dummy number;
1800: Begin
1801: select 1 into dummy
1802: from dual
1803: where exists (Select 1 from fa_asset_hierarchy
1804: where parent_hierarchy_id = x_asset_hierarchy_id
1805: and nvl(asset_id,0) <> 0);
1806: return (TRUE);
1807: Exception

Line 1818: where exists(select 1 from fa_asset_hierarchy

1814: is
1815: dummy number;
1816: begin
1817: select 1 into dummy from dual
1818: where exists(select 1 from fa_asset_hierarchy
1819: where parent_hierarchy_id = x_asset_hierarchy_id);
1820: return(TRUE);
1821: Exception
1822: when no_data_found then

Line 1833: from fa_asset_hierarchy

1829: dummy number;
1830: Begin
1831: select 1 into dummy from dual
1832: where exists ( select asset_hierarchy_id
1833: from fa_asset_hierarchy
1834: where nvl(asset_id,0) <> 0
1835: start with asset_hierarchy_id = x_node_id
1836: connect by prior asset_hierarchy_id = parent_hierarchy_id);
1837: return(TRUE);