eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_HR_RETIREMENT_DETAILS

Line 170: from fa_hr_retirement_details

166: CURSOR C_check_hr_retirement IS
167: select 1
168: from dual
169: where exists ( select 'X'
170: from fa_hr_retirement_details
171: -- where status_code = 'P' -- msiddiqu 15-feb-2001
172: where status_code IN ('P', 'IP')
173: and asset_id = nvl(x_asset_id, asset_id)
174: and book_type_code = x_book_type_code

Line 663: -- into FA_HR_RETIREMENT_DETAILS table

659: END insert_hr_retirement_hdrs;
660:
661: -- --------------------------------------------------
662: -- This function insert retirement details
663: -- into FA_HR_RETIREMENT_DETAILS table
664: -- --------------------------------------------------
665: PROCEDURE insert_hr_retirement_dtls(
666: x_batch_id IN NUMBER
667: , x_book_type_code IN VARCHAR2

Line 696: insert into fa_hr_retirement_details(

692: x_err_code := '0';
693: v_old_err_stack := x_err_stack;
694: x_err_stack := x_err_stack||'->'||'insert_fa_hr_retirement_dtls';
695:
696: insert into fa_hr_retirement_details(
697: batch_id
698: , book_type_code
699: , asset_id
700: , date_placed_in_service

Line 835: asset_id fa_hr_retirement_details.asset_id%TYPE default null,

831: v_asset_pos NUMBER;
832: v_asset_cor NUMBER;
833:
834: TYPE ret_asset_rec_type IS RECORD (
835: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
836: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
837: cost fa_hr_retirement_details.current_cost%TYPE default null,
838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
839: units fa_hr_retirement_details.current_units%TYPE default null,

Line 836: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,

832: v_asset_cor NUMBER;
833:
834: TYPE ret_asset_rec_type IS RECORD (
835: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
836: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
837: cost fa_hr_retirement_details.current_cost%TYPE default null,
838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
839: units fa_hr_retirement_details.current_units%TYPE default null,
840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,

Line 837: cost fa_hr_retirement_details.current_cost%TYPE default null,

833:
834: TYPE ret_asset_rec_type IS RECORD (
835: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
836: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
837: cost fa_hr_retirement_details.current_cost%TYPE default null,
838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
839: units fa_hr_retirement_details.current_units%TYPE default null,
840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,

Line 838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,

834: TYPE ret_asset_rec_type IS RECORD (
835: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
836: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
837: cost fa_hr_retirement_details.current_cost%TYPE default null,
838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
839: units fa_hr_retirement_details.current_units%TYPE default null,
840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
842: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,

Line 839: units fa_hr_retirement_details.current_units%TYPE default null,

835: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
836: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
837: cost fa_hr_retirement_details.current_cost%TYPE default null,
838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
839: units fa_hr_retirement_details.current_units%TYPE default null,
840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
842: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
843: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,

Line 840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,

836: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
837: cost fa_hr_retirement_details.current_cost%TYPE default null,
838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
839: units fa_hr_retirement_details.current_units%TYPE default null,
840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
842: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
843: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
844: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );

Line 841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,

837: cost fa_hr_retirement_details.current_cost%TYPE default null,
838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
839: units fa_hr_retirement_details.current_units%TYPE default null,
840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
842: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
843: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
844: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );
845:

Line 842: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,

838: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
839: units fa_hr_retirement_details.current_units%TYPE default null,
840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
842: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
843: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
844: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );
845:
846:

Line 843: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,

839: units fa_hr_retirement_details.current_units%TYPE default null,
840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
842: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
843: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
844: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );
845:
846:
847: TYPE ret_asset_tbl_type IS TABLE OF ret_asset_rec_type index by binary_integer;

Line 844: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );

840: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
841: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
842: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
843: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
844: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );
845:
846:
847: TYPE ret_asset_tbl_type IS TABLE OF ret_asset_rec_type index by binary_integer;
848:

Line 1383: update fa_hr_retirement_details

1379: update fa_hr_retirement_headers
1380: set status_code = 'IP'
1381: where batch_id = hrh_rec.batch_id;
1382:
1383: update fa_hr_retirement_details
1384: set status_code = 'IP'
1385: where batch_id = hrh_rec.batch_id;
1386:
1387: commit;

Line 1433: from fa_hr_retirement_details

1429:
1430: Begin
1431: select 'Y'
1432: into v_dummy
1433: from fa_hr_retirement_details
1434: where batch_id = hrh_rec.batch_id
1435: and status_code in ('IP','R')
1436: and rownum = 1;
1437: Exception

Line 1452: Update fa_hr_retirement_details

1448: , last_update_date = sysdate
1449: , last_update_login = fnd_global.login_id
1450: where batch_id = hrh_rec.batch_id;
1451:
1452: Update fa_hr_retirement_details
1453: set status_code = 'P'
1454: where status_code <> 'R'
1455: and batch_id = hrh_rec.batch_id;
1456: else

Line 1532: from fa_hr_retirement_details

1528: units_retired,
1529: book_type_code,
1530: status_code,
1531: retirement_convention_code
1532: from fa_hr_retirement_details
1533: where batch_id = x_batch_id
1534: order by date_placed_in_service asc;
1535:
1536: CURSOR c_dist_lines(x_book_type_code IN VARCHAR2

Line 1818: update fa_hr_retirement_details

1814: end if;
1815:
1816: END;
1817:
1818: update fa_hr_retirement_details
1819: set retirement_id = v_retirement_id
1820: where batch_id = hrd_rec.batch_id
1821: and asset_id = hrd_rec.asset_id;
1822:

Line 1830: UPDATE fa_hr_retirement_details

1826: rollback;
1827:
1828: FOR hrd_rec in c_hrd LOOP
1829: if v_error_tab.exists(hrd_rec.asset_id) then
1830: UPDATE fa_hr_retirement_details
1831: SET status_code = 'R'
1832: , rejection_reason = v_error_tab(hrd_rec.asset_id).rejection_reason
1833: , concurrent_request_id = x_conc_request_id
1834: , last_updated_by = v_user

Line 1843: UPDATE fa_hr_retirement_details

1839: end if;
1840: END LOOP;
1841: else
1842: -- if successfull
1843: UPDATE fa_hr_retirement_details
1844: SET status_code = 'A'
1845: , rejection_reason = null
1846: , concurrent_request_id = x_conc_request_id
1847: -- , retirement_id = v_retirement_id