APPS.FA_MASS_RET_PUB dependencies on FA_MASS_RETIREMENTS

Line 36: l_retirement_type_code fa_mass_retirements.retirement_type_code%TYPE;

32: l_per_close_date fa_deprn_periods.calendar_period_close_date%TYPE;
33: l_book fa_book_controls.book_type_code%TYPE;
34:
35: l_category_id fa_categories.category_id%TYPE;
36: l_retirement_type_code fa_mass_retirements.retirement_type_code%TYPE;
37: l_retirement_date date;
38: l_status fa_lookups_b.lookup_code%TYPE;
39: l_location_id fa_locations.location_id%TYPE;
40: l_employee_id number;

Line 41: l_asset_key_id fa_mass_retirements.asset_key_id%TYPE;

37: l_retirement_date date;
38: l_status fa_lookups_b.lookup_code%TYPE;
39: l_location_id fa_locations.location_id%TYPE;
40: l_employee_id number;
41: l_asset_key_id fa_mass_retirements.asset_key_id%TYPE;
42: l_from_asset_no fa_additions_b.asset_number%TYPE;
43: l_to_asset_no fa_additions_b.asset_number%TYPE;
44:
45: l_msg_data varchar2(200);

Line 342: Insert into fa_mass_retirements (

338: end if;
339: end if;
340:
341:
342: Insert into fa_mass_retirements (
343: MASS_RETIREMENT_ID,
344: BOOK_TYPE_CODE,
345: RETIRE_SUBCOMPONENTS_FLAG,
346: STATUS,