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.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on HR_API_TRANSACTIONS

Line 161: item_key hr_api_transactions.item_key%type default '';

157: where orig_system_id = p_person_id
158: and orig_system = 'PER';
159:
160: item_key_number number;
161: item_key hr_api_transactions.item_key%type default '';
162: item_type hr_api_transactions.item_type%type default 'HRWPM';
163: mgr_name per_all_people_f.global_name%TYPE;
164: mgr_role wf_local_roles.name%TYPE;
165:

Line 162: item_type hr_api_transactions.item_type%type default 'HRWPM';

158: and orig_system = 'PER';
159:
160: item_key_number number;
161: item_key hr_api_transactions.item_key%type default '';
162: item_type hr_api_transactions.item_type%type default 'HRWPM';
163: mgr_name per_all_people_f.global_name%TYPE;
164: mgr_role wf_local_roles.name%TYPE;
165:
166: l_sc_latest_ovn_list varchar2(1000) default null;

Line 342: select transaction_id from hr_api_transactions

338: and sysdate between people.effective_start_date and people.effective_end_date;
339: -- to be see that the cursor retreives only one id
340: cursor get_score_card_txn(p_score_card_id number, txn_owner per_all_people_f.person_id%TYPE)
341: IS
342: select transaction_id from hr_api_transactions
343: where transaction_ref_id = p_score_card_id
344: and transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
345: and creator_person_id = txn_owner;
346: