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

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 1021: if l_asg_term_date = hr_api.g_eot then

1017:
1018: if l_asg_term_date is null then
1019: select max(EFFECTIVE_end_DATE) into l_asg_term_date
1020: from per_all_assignments_f where assignment_id = p_assignment_id;
1021: if l_asg_term_date = hr_api.g_eot then
1022: l_asg_term_date := null;
1023: end if;
1024: end if;
1025:

Line 1256: HR_API.SET_LEGISLATION_CONTEXT(p_legCode);

1252: l_secGrpId := 0;
1253: l_enableSecGrp := getEnableSecurityGroups;
1254:
1255: IF p_legCode IS NOT NULL THEN
1256: HR_API.SET_LEGISLATION_CONTEXT(p_legCode);
1257: END IF;
1258:
1259:
1260: IF (p_bgId IS NOT NULL AND l_enableSecGrp = 'Y' ) THEN

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 1701: , hr_api_transaction_steps hats

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
1704: WHERE hat.transaction_id = l_source_pk1_value
1705: AND hats.transaction_id = hat.transaction_id

Line 1702: , hr_api_transaction_values hatv1

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
1704: WHERE hat.transaction_id = l_source_pk1_value
1705: AND hats.transaction_id = hat.transaction_id
1706: AND hats.api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'

Line 1703: , hr_api_transaction_values hatv2

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
1704: WHERE hat.transaction_id = l_source_pk1_value
1705: AND hats.transaction_id = hat.transaction_id
1706: AND hats.api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'
1707: AND hatv1.transaction_step_id = hats.transaction_step_id

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 1812: fetch csr_trans_rec into lr_hr_api_transaction_rec;

1808: --so in such case return false.
1809: --Other products can also have such kind of scenarios.
1810:
1811: open csr_trans_rec;
1812: fetch csr_trans_rec into lr_hr_api_transaction_rec;
1813: if (csr_trans_rec%NOTFOUND) then
1814: CLOSE csr_trans_rec;
1815: hr_utility.set_location('Transaction not found',5);
1816: return false;

Line 1822: if( lr_hr_api_transaction_rec.transaction_document is not null) then

1818: close csr_trans_rec;
1819:
1820: l_save_attach := false;
1821:
1822: if( lr_hr_api_transaction_rec.transaction_document is not null) then
1823:
1824: rootNode := xmldom.makeNode(hr_transaction_swi.convertCLOBtoXMLElement(lr_hr_api_transaction_rec.transaction_document));
1825: l_TransCtx_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCtx');
1826:

Line 1824: rootNode := xmldom.makeNode(hr_transaction_swi.convertCLOBtoXMLElement(lr_hr_api_transaction_rec.transaction_document));

1820: l_save_attach := false;
1821:
1822: if( lr_hr_api_transaction_rec.transaction_document is not null) then
1823:
1824: rootNode := xmldom.makeNode(hr_transaction_swi.convertCLOBtoXMLElement(lr_hr_api_transaction_rec.transaction_document));
1825: l_TransCtx_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCtx');
1826:
1827: IF (xmldom.getLength(l_TransCtx_NodeList) > 0) THEN
1828: l_TransCtx_Node :=xmldom.item(l_TransCtx_NodeList,0);

Line 1837: l_save_attachment_old := wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,

1833: l_Attach_Node := xmldom.getFirstChild(l_Attach_Node);
1834: l_save_attachment_new :=xmldom.getNodeValue(l_Attach_Node);
1835: else
1836:
1837: l_save_attachment_old := wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1838: lr_hr_api_transaction_rec.item_key,
1839: 'SAVE_ATTACHMENT',true);
1840: end if;
1841:

Line 1838: lr_hr_api_transaction_rec.item_key,

1834: l_save_attachment_new :=xmldom.getNodeValue(l_Attach_Node);
1835: else
1836:
1837: l_save_attachment_old := wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1838: lr_hr_api_transaction_rec.item_key,
1839: 'SAVE_ATTACHMENT',true);
1840: end if;
1841:
1842: if( (l_save_attachment_old is not null) AND (l_save_attachment_old = 'Y') )then

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 1889: from hr_api_transaction_steps

1885: /*Added following variables as a part of ER#9879782 Ends*/
1886:
1887: cursor csr_hat_steps is
1888: select *
1889: from hr_api_transaction_steps
1890: where transaction_id=p_transaction_id;
1891:
1892: step_row csr_hat_steps%ROWTYPE;
1893:

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 1907: FROM hr_api_transaction_values hatv1, hr_api_transaction_values hatv2

1903: /*Added following cursor as a part of ER#9879782 Starts*/
1904: cursor csr_apl_hire_txn_vals(x_transaction_step_id NUMBER)
1905: is
1906: SELECT hatv1.NUMBER_VALUE IRC_DOC_ID, hatv2.NUMBER_VALUE FND_DOC_ID
1907: FROM hr_api_transaction_values hatv1, hr_api_transaction_values hatv2
1908: WHERE hatv1.transaction_step_id = x_transaction_step_id
1909: and hatv1.NAME like 'P_IRC_DOC_ID%'
1910: and hatv1.NUMBER_VALUE is not null
1911: and hatv2.transaction_step_id = hatv1.transaction_step_id

Line 1981: hr_api_transaction_values

1977:
1978: elsif(l_api_name = 'HR_TERMINATION_SS.PROCESS_API') then
1979:
1980: select number_value into l_period_of_serv_id from
1981: hr_api_transaction_values
1982: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
1983: and NAME = 'P_PERIOD_OF_SERVICE_ID';
1984:
1985: l_entity_name := 'PER_PERIODS_OF_SERVICE';

Line 1991: hr_api_transaction_values

1987:
1988: elsif(l_api_name = 'HR_REVTERMINATION_SS.PROCESS_API') then
1989:
1990: select number_value into l_period_of_serv_id from
1991: hr_api_transaction_values
1992: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
1993: and NAME = 'P_PERIODS_OF_SERVICE_ID';
1994:
1995: l_entity_name := 'PER_PERIODS_OF_SERVICE';

Line 2015: FROM hr_api_transaction_values

2011: THEN
2012: BEGIN
2013: SELECT COUNT(1)
2014: INTO l_apl_flag
2015: FROM hr_api_transaction_values
2016: WHERE transaction_step_id = step_row.TRANSACTION_STEP_ID
2017: AND NAME = 'P_APPLICANT_NUMBER'
2018: AND VARCHAR2_VALUE IS NOT NULL;
2019: EXCEPTION WHEN OTHERS THEN

Line 2025: hr_api_transaction_values

2021: END;
2022: IF l_apl_flag <> 0 THEN
2023: BEGIN
2024: select number_value into l_person_id from
2025: hr_api_transaction_values
2026: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
2027: and NAME = 'P_PERSON_ID';
2028: EXCEPTION WHEN OTHERS
2029: THEN

Line 2034: hr_api_transaction_values

2030: l_person_id := null;
2031: END;
2032: BEGIN
2033: select date_value into l_doc_upload_date from
2034: hr_api_transaction_values
2035: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
2036: and NAME = 'P_EFFECTIVE_DATE';
2037: EXCEPTION WHEN OTHERS
2038: THEN

Line 2043: hr_api_transaction_values

2039: l_doc_upload_date := null;
2040: END;
2041: BEGIN
2042: select number_value into l_assignment_id from
2043: hr_api_transaction_values
2044: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
2045: and NAME = 'P_APPL_ASSIGNMENT_ID';
2046: EXCEPTION WHEN OTHERS
2047: THEN

Line 2102: lv_is_upgrade hr_api_transaction_steps.Information30%type;

2098: function getUpgradeCheck(p_transaction_id in number) return varchar2
2099:
2100: IS
2101: c_proc constant varchar2(30) := 'getUpgradeCheck';
2102: lv_is_upgrade hr_api_transaction_steps.Information30%type;
2103: begin
2104: g_debug := hr_utility.debug_enabled;
2105: if g_debug then
2106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 2113: from hr_api_transaction_steps

2109: if(p_transaction_id is not null) then
2110: begin
2111: select Information30
2112: into lv_is_upgrade
2113: from hr_api_transaction_steps
2114: where transaction_id=p_transaction_id;
2115:
2116: exception
2117: when others then

Line 2243: from hr_api_transaction_steps trs

2239: l_eth_dff_exists varchar2(30):= null;
2240:
2241: cursor csr_txn_step_id is
2242: select trs.transaction_step_id
2243: from hr_api_transaction_steps trs
2244: where trs.transaction_id = hr_transaction_ss.get_transaction_id
2245: (itemtype ,itemkey )
2246: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';
2247:

Line 2290: l_leg_code := hr_api.return_legislation_code(l_business_grp_id);

2286: hr_utility.set_location('l_business_grp_Id: ' || l_business_grp_Id,6);
2287: end if;
2288:
2289:
2290: l_leg_code := hr_api.return_legislation_code(l_business_grp_id);
2291:
2292: hr_utility.set_location('l_leg_code: ' || l_leg_code,5);
2293:
2294:

Line 2342: l_leg_code := hr_api.return_legislation_code(l_business_group_id);

2338: person_id = p_person_id and trunc(sysdate) between effective_start_date and effective_end_date;
2339:
2340: hr_utility.set_location('l_business_group_id: ' || l_business_group_id,6);
2341:
2342: l_leg_code := hr_api.return_legislation_code(l_business_group_id);
2343:
2344: hr_utility.set_location('l_leg_code: ' || l_leg_code,5);
2345:
2346:

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;