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