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 228: FROM hr_api_transactions

224: --
225: PROCEDURE process_attachments(p_transaction_id IN NUMBER) IS
226: CURSOR csr_clob(p_transaction_id IN NUMBER) IS
227: SELECT transaction_document
228: FROM hr_api_transactions
229: WHERE transaction_id = p_transaction_id;
230: txnClob CLOB;
231: txnXml xmldom.DOMElement;
232: nl xmldom.DOMNodeList;

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

550: where orig_system_id = p_person_id
551: and orig_system = 'PER';
552:
553: item_key_number number;
554: item_key hr_api_transactions.item_key%type default '';
555: item_type hr_api_transactions.item_type%type default 'HRWPM';
556: mgr_name per_all_people_f.global_name%TYPE;
557: mgr_role wf_local_roles.name%TYPE;
558:

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

551: and orig_system = 'PER';
552:
553: item_key_number number;
554: item_key hr_api_transactions.item_key%type default '';
555: item_type hr_api_transactions.item_type%type default 'HRWPM';
556: mgr_name per_all_people_f.global_name%TYPE;
557: mgr_role wf_local_roles.name%TYPE;
558:
559: l_sc_latest_ovn_list varchar2(1000) default null;

Line 735: select transaction_id from hr_api_transactions

731: and trunc(sysdate) between people.effective_start_date and people.effective_end_date;
732: -- to be see that the cursor retreives only one id
733: cursor get_score_card_txn(p_score_card_id number, txn_owner per_all_people_f.person_id%TYPE)
734: IS
735: select transaction_id from hr_api_transactions
736: where transaction_ref_id = p_score_card_id
737: and transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
738: and creator_person_id = txn_owner;
739: