APPS.FA_CUA_HIERARCHY_PKG dependencies on FA_ASSET_HIERARCHY_PURPOSE

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 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 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 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 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 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;