APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FA_MASS_ADDITIONS

Line 587: FROM fa_mass_additions mass_add

583: l_mass_add_rec.NEW_USED,
584: l_mass_add_rec.ASSET_ID,
585: l_mass_add_rec.MATERIAL_INDICATOR_FLAG,
586: l_mass_add_rec.distributions_table
587: FROM fa_mass_additions mass_add
588: WHERE mass_addition_id = px_group_asset_rec.mass_addition_id;
589:
590: l_category_id := l_mass_add_rec.asset_category_id;
591:

Line 962: UPDATE fa_mass_additions

958: l_debug_str := 'Put the line to hold as multiple assets exists';
959: l_mass_add_rec.posting_status := 'ON-HOLD';
960: l_mass_add_rec.queue_name := 'ON-HOLD';
961:
962: UPDATE fa_mass_additions
963: SET posting_status = 'ON-HOLD', Queue_name = 'ON-HOLD'
964: WHERE mass_addition_id = l_mass_add_rec.mass_addition_id;
965: ELSIF (l_temp = 0) THEN
966: BEGIN

Line 1046: UPDATE fa_mass_additions

1042: END IF;
1043: ELSE
1044: l_mass_add_rec.group_asset_id := l_asset_hdr_rec.asset_id;
1045:
1046: UPDATE fa_mass_additions
1047: SET posting_status = 'POST',
1048: Queue_name = 'POST',
1049: group_asset_id = l_mass_add_rec.group_asset_id
1050: WHERE mass_addition_id = l_mass_add_rec.mass_addition_id;

Line 1062: UPDATE fa_mass_additions

1058: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
1059: p_log_level_rec => p_log_level_rec);
1060: END IF;
1061:
1062: UPDATE fa_mass_additions
1063: SET posting_status = 'POST',
1064: Queue_name = 'POST',
1065: group_asset_id = l_parent_asset_id
1066: WHERE mass_addition_id = l_mass_add_rec.mass_addition_id;