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_UTIL_MISC_SS dependencies on HR_API_TRANSACTIONS

Line 406: l_item_type hr_api_transactions.item_type%type;

402: RETURN VARCHAR2
403: IS
404: l_proc varchar2(72) := g_package||' check_term_access';
405: l_status VARCHAR2(10):= 'N';
406: l_item_type hr_api_transactions.item_type%type;
407: l_temp VARCHAR2(100);
408: l_function_name fnd_form_functions.function_name%Type;
409:
410: -- Local Cursors

Line 623: l_item_type hr_api_transactions.item_type%type;

619: IS
620: l_proc varchar2(72) := g_package||'check_cwk_access';
621: l_status VARCHAR2(10):= 'C';
622: l_npw_status VARCHAR2(30);
623: l_item_type hr_api_transactions.item_type%type;
624: l_temp VARCHAR2(100);
625: l_function_name fnd_form_functions.function_name%Type;
626:
627: -- Local Cursors

Line 1647: l_item_type hr_api_transactions.item_type%type := null;

1643:
1644: l_rowid varchar2(50);
1645: l_proc varchar2(72) := g_package ||'merge_attachments';
1646: l_source_pk1_value varchar2(100) := null;
1647: l_item_type hr_api_transactions.item_type%type := null;
1648: l_item_key hr_api_transactions.item_key%type := null;
1649: /*Added following variables as a part of ER#9879782 Starts*/
1650: l_person_id NUMBER := null;
1651: l_irc_doc_id NUMBER := null;

Line 1648: l_item_key hr_api_transactions.item_key%type := null;

1644: l_rowid varchar2(50);
1645: l_proc varchar2(72) := g_package ||'merge_attachments';
1646: l_source_pk1_value varchar2(100) := null;
1647: l_item_type hr_api_transactions.item_type%type := null;
1648: l_item_key hr_api_transactions.item_key%type := null;
1649: /*Added following variables as a part of ER#9879782 Starts*/
1650: l_person_id NUMBER := null;
1651: l_irc_doc_id NUMBER := null;
1652: /*Added following variables as a part of ER#9879782 Ends*/

Line 1668: from hr_api_transactions

1664: WHERE attached_document_id = X_attached_document_id;
1665:
1666: cursor csr_get_itemkey(source_pk1_value in varchar2) is
1667: select item_type, item_key
1668: from hr_api_transactions
1669: where transaction_id = source_pk1_value;
1670:
1671: begin
1672: savepoint merge_attachments;

Line 1699: FROM hr_api_transactions hat

1695: /*Added following code as a part of ER#9879782 Starts*/
1696: BEGIN
1697: SELECT hat.SELECTED_PERSON_ID, hatv2.number_value irc_doc_id
1698: INTO l_person_id,l_irc_doc_id
1699: FROM hr_api_transactions hat
1700: , fnd_attached_documents fads
1701: , hr_api_transaction_steps hats
1702: , hr_api_transaction_values hatv1
1703: , hr_api_transaction_values hatv2

Line 1781: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1777: return boolean
1778: is
1779:
1780: c_proc constant varchar2(30) := 'getAttachToEntity';
1781: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1782: l_save_attachment_old varchar2(30) := null;
1783: l_save_attachment_new varchar2(30) := null;
1784: l_save_attach boolean;
1785: rootNode xmldom.DOMNode;

Line 1793: from hr_api_transactions

1789: l_Attach_NodeList xmldom.DOMNodeList;
1790:
1791: cursor csr_trans_rec is
1792: select *
1793: from hr_api_transactions
1794: where transaction_id = p_transaction_id;
1795:
1796:
1797: begin

Line 1868: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1864: ,p_return_status out nocopy varchar2)
1865: is
1866:
1867: c_proc constant varchar2(30) := 'saveAttachment';
1868: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1869: l_api_name varchar2(100) := null;
1870: l_entity_name varchar2(30) := null;
1871: l_dest_pk1_val varchar2(30) := null;
1872: l_return_status varchar2(30) := null;

Line 1899: from hr_api_transactions hat

1895: select hat.transaction_id,
1896: hat.assignment_id,
1897: hat.selected_person_id,
1898: hat.transaction_ref_id
1899: from hr_api_transactions hat
1900: where hat.transaction_id =p_transaction_id;
1901:
1902: trans_row csr_hat%rowtype;
1903: /*Added following cursor as a part of ER#9879782 Starts*/

Line 2644: select 'x' into dummy from hr_api_transactions

2640: raise;
2641: end;
2642:
2643: begin
2644: select 'x' into dummy from hr_api_transactions
2645: where item_key = lv_item_key
2646: and item_type = lv_item_type
2647: and status <> 'AC';
2648:

Line 2679: FROM hr_api_transactions

2675: c_proc constant varchar2(30) := 'setApprSFLResponseContext';
2676: c_transaction_id varchar2(25);
2677: CURSOR csr_txn (p_txn_id IN NUMBER)IS
2678: SELECT transaction_ref_table, transaction_ref_id
2679: FROM hr_api_transactions
2680: WHERE transaction_id = p_txn_id;
2681: l_transaction_ref_table VARCHAR2(50);
2682: l_transaction_ref_id NUMBER;
2683: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

Line 2834: select 'X' into dummy from hr_api_transaction_steps ts, hr_api_transactions hat

2830:
2831: begin
2832:
2833:
2834: select 'X' into dummy from hr_api_transaction_steps ts, hr_api_transactions hat
2835: where hat.item_type = itemtype
2836: and hat.item_key = itemkey
2837: and ts.transaction_id = hat.transaction_id
2838: and rownum <= 1;