[Home] [Help]
1028:
1029: FUNCTION get_asset_cat_rec
1030: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1031: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
1032: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
1033: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
1034: ) RETURN BOOLEAN IS
1035:
1036: l_asset_category_id FA_ADDITIONS.asset_category_id%TYPE;
1105: px_asset_cat_rec.desc_flex.attribute30,
1106: px_asset_cat_rec.desc_flex.attribute_category_code,
1107: px_asset_cat_rec.desc_flex.context
1108: from fa_additions_b ad,
1109: fa_asset_history ah
1110: where ad.asset_id = p_asset_hdr_rec.asset_id
1111: and ad.asset_id = ah.asset_id
1112: and ((p_date_effective is null and
1113: ah.date_ineffective is null) or
1136:
1137: FUNCTION get_asset_type_rec
1138: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1139: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
1140: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
1141: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
1142: ) RETURN BOOLEAN IS
1143:
1144: BEGIN
1145:
1146: select ah.asset_type
1147: into px_asset_type_rec.asset_type
1148: from fa_additions_b ad,
1149: fa_asset_history ah
1150: where ad.asset_id = p_asset_hdr_rec.asset_id
1151: and ad.asset_id = ah.asset_id
1152: and (ah.date_effective = nvl(p_date_effective, to_date('01/01/0001', 'DD/MM/YYYY')) or
1153: ah.date_ineffective is null);
1901: BEGIN
1902:
1903: select units
1904: into x_current_units
1905: from fa_asset_history
1906: where asset_id = p_asset_id
1907: and date_ineffective is null;
1908:
1909: return TRUE;
1917: name => 'FA_SHARED_ACTION_TABLE',
1918: token1 => 'ACTION',
1919: value1 => 'SELECT',
1920: token2 => 'TABLE',
1921: value2 => 'FA_ASSET_HISTORY', p_log_level_rec => p_log_level_rec);
1922:
1923: return FALSE;
1924:
1925: END get_current_units;