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 172: from fa_hr_retirement_details

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

Line 667: -- into FA_HR_RETIREMENT_DETAILS table

663: END insert_hr_retirement_hdrs;
664:
665: -- --------------------------------------------------
666: -- This function insert retirement details
667: -- into FA_HR_RETIREMENT_DETAILS table
668: -- --------------------------------------------------
669: PROCEDURE insert_hr_retirement_dtls(
670: x_batch_id IN NUMBER
671: , x_book_type_code IN VARCHAR2

Line 700: insert into fa_hr_retirement_details(

696: x_err_code := '0';
697: v_old_err_stack := x_err_stack;
698: x_err_stack := x_err_stack||'->'||'insert_fa_hr_retirement_dtls';
699:
700: insert into fa_hr_retirement_details(
701: batch_id
702: , book_type_code
703: , asset_id
704: , date_placed_in_service

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

835: v_asset_pos NUMBER;
836: v_asset_cor NUMBER;
837:
838: TYPE ret_asset_rec_type IS RECORD (
839: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
840: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
841: cost fa_hr_retirement_details.current_cost%TYPE default null,
842: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
843: units fa_hr_retirement_details.current_units%TYPE default null,

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

836: v_asset_cor NUMBER;
837:
838: TYPE ret_asset_rec_type IS RECORD (
839: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
840: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
841: cost fa_hr_retirement_details.current_cost%TYPE default null,
842: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
843: units fa_hr_retirement_details.current_units%TYPE default null,
844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,

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

837:
838: TYPE ret_asset_rec_type IS RECORD (
839: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
840: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
841: cost fa_hr_retirement_details.current_cost%TYPE default null,
842: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
843: units fa_hr_retirement_details.current_units%TYPE default null,
844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
845: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,

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

838: TYPE ret_asset_rec_type IS RECORD (
839: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
840: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
841: cost fa_hr_retirement_details.current_cost%TYPE default null,
842: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
843: units fa_hr_retirement_details.current_units%TYPE default null,
844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
845: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
846: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,

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

839: asset_id fa_hr_retirement_details.asset_id%TYPE default null,
840: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
841: cost fa_hr_retirement_details.current_cost%TYPE default null,
842: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
843: units fa_hr_retirement_details.current_units%TYPE default null,
844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
845: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
846: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
847: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,

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

840: dpis fa_hr_retirement_details.date_placed_in_service%TYPE default null,
841: cost fa_hr_retirement_details.current_cost%TYPE default null,
842: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
843: units fa_hr_retirement_details.current_units%TYPE default null,
844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
845: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
846: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
847: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
848: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );

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

841: cost fa_hr_retirement_details.current_cost%TYPE default null,
842: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
843: units fa_hr_retirement_details.current_units%TYPE default null,
844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
845: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
846: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
847: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
848: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );
849:

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

842: cost_retired fa_hr_retirement_details.cost_retired%TYPE default null,
843: units fa_hr_retirement_details.current_units%TYPE default null,
844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
845: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
846: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
847: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
848: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );
849:
850:

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

843: units fa_hr_retirement_details.current_units%TYPE default null,
844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
845: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
846: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
847: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
848: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );
849:
850:
851: TYPE ret_asset_tbl_type IS TABLE OF ret_asset_rec_type index by binary_integer;

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

844: units_retired fa_hr_retirement_details.units_retired%TYPE default null,
845: prorate_percent fa_hr_retirement_details.prorate_percent%TYPE default null,
846: ret_prorate_conv fa_hr_retirement_details.retirement_convention_code%TYPE default null,
847: proceeds_of_sale fa_hr_retirement_details.proceeds_of_sale%TYPE default null,
848: cost_of_removal fa_hr_retirement_details.cost_of_removal%TYPE default null );
849:
850:
851: TYPE ret_asset_tbl_type IS TABLE OF ret_asset_rec_type index by binary_integer;
852:

Line 1389: update fa_hr_retirement_details

1385: update fa_hr_retirement_headers
1386: set status_code = 'IP'
1387: where batch_id = hrh_rec.batch_id;
1388:
1389: update fa_hr_retirement_details
1390: set status_code = 'IP'
1391: where batch_id = hrh_rec.batch_id;
1392:
1393: commit;

Line 1440: from fa_hr_retirement_details

1436:
1437: Begin
1438: select 'Y'
1439: into v_dummy
1440: from fa_hr_retirement_details
1441: where batch_id = hrh_rec.batch_id
1442: and status_code in ('IP','R')
1443: and rownum = 1;
1444: Exception

Line 1459: Update fa_hr_retirement_details

1455: , last_update_date = sysdate
1456: , last_update_login = fnd_global.login_id
1457: where batch_id = hrh_rec.batch_id;
1458:
1459: Update fa_hr_retirement_details
1460: set status_code = 'P'
1461: where status_code <> 'R'
1462: and batch_id = hrh_rec.batch_id;
1463: else

Line 1539: from fa_hr_retirement_details

1535: units_retired,
1536: book_type_code,
1537: status_code,
1538: retirement_convention_code
1539: from fa_hr_retirement_details
1540: where batch_id = x_batch_id
1541: order by date_placed_in_service asc;
1542:
1543: CURSOR c_dist_lines(x_book_type_code IN VARCHAR2

Line 1824: update fa_hr_retirement_details

1820: end if;
1821:
1822: END;
1823:
1824: update fa_hr_retirement_details
1825: set retirement_id = v_retirement_id
1826: where batch_id = hrd_rec.batch_id
1827: and asset_id = hrd_rec.asset_id;
1828:

Line 1836: UPDATE fa_hr_retirement_details

1832: rollback;
1833:
1834: FOR hrd_rec in c_hrd LOOP
1835: if v_error_tab.exists(hrd_rec.asset_id) then
1836: UPDATE fa_hr_retirement_details
1837: SET status_code = 'R'
1838: , rejection_reason = v_error_tab(hrd_rec.asset_id).rejection_reason
1839: , concurrent_request_id = x_conc_request_id
1840: , last_updated_by = v_user

Line 1849: UPDATE fa_hr_retirement_details

1845: end if;
1846: END LOOP;
1847: else
1848: -- if successfull
1849: UPDATE fa_hr_retirement_details
1850: SET status_code = 'A'
1851: , rejection_reason = null
1852: , concurrent_request_id = x_conc_request_id
1853: -- , retirement_id = v_retirement_id