DBA Data[Home] [Help]

APPS.FA_CUA_ASSET_WB_APIS_PKG dependencies on FA_CUA_ASSET_WB_APIS_PKG

Line 1: PACKAGE BODY FA_CUA_ASSET_WB_APIS_PKG AS

1: PACKAGE BODY FA_CUA_ASSET_WB_APIS_PKG AS
2: /* $Header: FACHRAWMB.pls 120.3 2002/11/13 04:34:08 glchen ship $*/
3:
4: FUNCTION Is_CRLFA_Enabled RETURN Boolean
5: IS

Line 309: fa_cua_asset_wb_apis_pkg.get_asset_parent(x_asset_id,

305: v_book_type_code varchar2(15);
306: Begin
307:
308: v_book_type_code := x_book_type_code;
309: fa_cua_asset_wb_apis_pkg.get_asset_parent(x_asset_id,
310: v_hierarchy_node_id,
311: v_hierarchy_node,
312: v_hierarchy_purpose_id,
313: v_hierarchy_purpose,

Line 542: 'NODE', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),

538: x_level_number in out nocopy varchar2 ) IS
539: x_derived_from_entity_id number;
540: cursor c is
541: Select fl.meaning, decode(derived_from_entity,
542: 'NODE', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
543: 'NODE-P', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
544: 'CATEGORY-LED', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
545: 'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
546: 'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),

Line 543: 'NODE-P', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),

539: x_derived_from_entity_id number;
540: cursor c is
541: Select fl.meaning, decode(derived_from_entity,
542: 'NODE', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
543: 'NODE-P', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
544: 'CATEGORY-LED', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
545: 'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
546: 'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),
547: 'ASSET', FA_CUA_ASSET_WB_APIS_PKG.get_asset_number(derived_from_entity_id),

Line 544: 'CATEGORY-LED', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),

540: cursor c is
541: Select fl.meaning, decode(derived_from_entity,
542: 'NODE', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
543: 'NODE-P', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
544: 'CATEGORY-LED', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
545: 'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
546: 'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),
547: 'ASSET', FA_CUA_ASSET_WB_APIS_PKG.get_asset_number(derived_from_entity_id),
548: null ), derived_from_entity_id

Line 545: 'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),

541: Select fl.meaning, decode(derived_from_entity,
542: 'NODE', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
543: 'NODE-P', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
544: 'CATEGORY-LED', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
545: 'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
546: 'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),
547: 'ASSET', FA_CUA_ASSET_WB_APIS_PKG.get_asset_number(derived_from_entity_id),
548: null ), derived_from_entity_id
549: from fa_life_derivation_info, fa_lookups fl

Line 546: 'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),

542: 'NODE', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
543: 'NODE-P', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
544: 'CATEGORY-LED', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
545: 'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
546: 'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),
547: 'ASSET', FA_CUA_ASSET_WB_APIS_PKG.get_asset_number(derived_from_entity_id),
548: null ), derived_from_entity_id
549: from fa_life_derivation_info, fa_lookups fl
550: where asset_id =x_asset_id

Line 547: 'ASSET', FA_CUA_ASSET_WB_APIS_PKG.get_asset_number(derived_from_entity_id),

543: 'NODE-P', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
544: 'CATEGORY-LED', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
545: 'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
546: 'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),
547: 'ASSET', FA_CUA_ASSET_WB_APIS_PKG.get_asset_number(derived_from_entity_id),
548: null ), derived_from_entity_id
549: from fa_life_derivation_info, fa_lookups fl
550: where asset_id =x_asset_id
551: and book_type_code = x_book_type_code

Line 600: END FA_CUA_ASSET_WB_APIS_PKG;

596: and ADJUSTMENT_TYPE not in ('COST', 'COST CLEARING');
597:
598: END remove_adjustments;
599:
600: END FA_CUA_ASSET_WB_APIS_PKG;