APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FA_MASS_ADDITIONS

Line 360: FROM fa_mass_additions mass_add

356: where mass_dist.mass_addition_id =
357: mass_add.mass_addition_id) as
358: fa_mass_add_dist_tbl) dists
359: into l_mass_add_rec
360: FROM fa_mass_additions mass_add
361: where mass_addition_id = px_group_asset_rec.mass_addition_id;
362:
363: l_akey_ccid := l_mass_add_rec.asset_key_ccid;
364: SELECT segment1,

Line 498: update fa_mass_additions

494: end loop;
495:
496: if (l_temp > 1) then
497: l_debug_str := 'Put the line to hold as multiple assets exists';
498: update fa_mass_additions
499: set posting_status = 'ON-HOLD', Queue_name = 'ON-HOLD'
500: where mass_addition_id = l_mass_add_rec.mass_addition_id;
501: elsif (l_temp = 0) then
502: l_debug_str := 'Parent asset does not exist';

Line 559: update fa_mass_additions

555: p_log_level_rec => p_log_level_rec);
556: end if;
557: else
558: l_mass_add_rec.group_asset_id := l_asset_hdr_rec.asset_id;
559: update fa_mass_additions
560: set posting_status = 'POST',
561: Queue_name = 'POST',
562: group_asset_id = l_mass_add_rec.group_asset_id
563: where mass_addition_id = l_mass_add_rec.mass_addition_id;

Line 574: update fa_mass_additions

570: l_debug_str,
571: '',
572: p_log_level_rec => p_log_level_rec);
573: end if;
574: update fa_mass_additions
575: set posting_status = 'POST',
576: Queue_name = 'POST',
577: group_asset_id = l_parent_asset_id
578: where mass_addition_id = l_mass_add_rec.mass_addition_id;