533: CREATION_DATE,
534: LAST_UPDATED_BY,
535: LAST_UPDATE_DATE,
536: LAST_UPDATE_LOGIN
537: from FA_HIERARCHY_CONTROLS
538: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id
539: and level_number = x_level_number;
540: mand_controlrec C_MANDT_CONTROLS%ROWTYPE;
541: l_old_err_stack varchar2(640);
1731: ,x_attribute_name in varchar2)
1732: return Boolean
1733: is
1734: Cursor C is select 1
1735: from fa_hierarchy_controls
1736: where asset_hierarchy_purpose_id = x_hierarchy_purpose_id
1737: and level_number = x_level_number
1738: and nvl(decode(x_attribute_name,'CATEGORY',category_mandatory_flag
1739: ,'LEASE',lease_mandatory_flag