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

Line 1960: l_transaction_id hr_api_transactions.transaction_id%type;

1956: ,resultout out nocopy varchar2) is
1957: --
1958: l_item_key wf_items.item_key%type;
1959: l_dummy INTEGER;
1960: l_transaction_id hr_api_transactions.transaction_id%type;
1961: l_transaction_age number default 30;
1962: l_transaction_status varchar2(5) ;
1963: l_transaction_status_to_delete varchar2(10);
1964: c_status varchar2(10);

Line 2006: from hr_api_transactions t

2002: from (select transaction_id,
2003: status,
2004: nvl(item_type,hr_workflow_service.getItemType(t.transaction_id)) item_type,
2005: nvl(item_key,hr_workflow_service.getItemKey(t.transaction_id)) item_key
2006: from hr_api_transactions t
2007: where t.last_update_date <= sysdate - c_transaction_age
2008: and t.status not in ('Y', 'YS','W')
2009: and t.transaction_ref_table <> 'PER_APPRAISALS'
2010: ) a, -- bug 3635925 , bug 5357274, bug 5990955

Line 2022: -- HR_API_TRANSACTIONS table will be deleted. So looking for the

2018: -- start bug 5990955
2019:
2020: --Only the appraisals with a System status (appraisal_system_status in
2021: -- PER_APPRAISALS) as "COMPLETED" or "DELETED", irrespective of status in
2022: -- HR_API_TRANSACTIONS table will be deleted. So looking for the
2023: -- APPRAISAL_SYSTEM_STATUS in the cursor
2024:
2025: CURSOR csr_wfdfctitmsapprs (c_transaction_age in number) is
2026: SELECT t.item_type, t.item_key, t.transaction_id

Line 2027: FROM hr_api_transactions t, per_appraisals a

2023: -- APPRAISAL_SYSTEM_STATUS in the cursor
2024:
2025: CURSOR csr_wfdfctitmsapprs (c_transaction_age in number) is
2026: SELECT t.item_type, t.item_key, t.transaction_id
2027: FROM hr_api_transactions t, per_appraisals a
2028: WHERE t.transaction_ref_table = 'PER_APPRAISALS'
2029: AND t.last_update_date <= sysdate - c_transaction_age
2030: AND t.transaction_ref_id = a.appraisal_id
2031: AND a.appraisal_system_status IN ('DELETED','COMPLETED');

Line 2057: FROM hr_api_transactions hat

2053: AND wi.item_key = hats.item_key);
2054: */
2055: -- Fix for bug#3322644
2056: SELECT hat.transaction_id
2057: FROM hr_api_transactions hat
2058: WHERE NOT EXISTS (SELECT 'Y'
2059: FROM wf_items wi
2060: WHERE wi.item_type = nvl(hat.item_type,hr_workflow_service.getItemType(hat.transaction_id))
2061: AND wi.item_key = nvl(hat.item_key,hr_workflow_service.getItemKey(hat.transaction_id))

Line 2069: -- in the hr_api_transactions. This could cause from SSHR transaction

2065: and w.user_key = hat.transaction_id)
2066: and hat.item_key is not null;
2067: --
2068: -- to fetch orphan records from wf tables which do not have an entry
2069: -- in the hr_api_transactions. This could cause from SSHR transaction
2070: -- not using hr_api_transactions and for WF process started without
2071: -- an entry to the hr_api_transactions. Possible causes, user started
2072: -- new transaction and closed the web browser.
2073:

Line 2070: -- not using hr_api_transactions and for WF process started without

2066: and hat.item_key is not null;
2067: --
2068: -- to fetch orphan records from wf tables which do not have an entry
2069: -- in the hr_api_transactions. This could cause from SSHR transaction
2070: -- not using hr_api_transactions and for WF process started without
2071: -- an entry to the hr_api_transactions. Possible causes, user started
2072: -- new transaction and closed the web browser.
2073:
2074: -- fix for bug#2838117

Line 2071: -- an entry to the hr_api_transactions. Possible causes, user started

2067: --
2068: -- to fetch orphan records from wf tables which do not have an entry
2069: -- in the hr_api_transactions. This could cause from SSHR transaction
2070: -- not using hr_api_transactions and for WF process started without
2071: -- an entry to the hr_api_transactions. Possible causes, user started
2072: -- new transaction and closed the web browser.
2073:
2074: -- fix for bug#2838117
2075: -- fetch all the records from wf_items for given item type which

Line 2076: -- not in hr_api_transactions and icx session is disabled or does

2072: -- new transaction and closed the web browser.
2073:
2074: -- fix for bug#2838117
2075: -- fetch all the records from wf_items for given item type which
2076: -- not in hr_api_transactions and icx session is disabled or does
2077: -- not exist.
2078:
2079: -- 4287117
2080: --5076290

Line 2095: from hr_api_transactions t1

2091: and s.disabled_flag(+) = 'Y'
2092: and (
2093: (wi.item_key) not in (
2094: select t1.item_key
2095: from hr_api_transactions t1
2096: where wi.item_type = t1.item_type
2097: and wi.item_key = t1.item_key
2098: and t1.item_type = itemtype
2099: )

Line 2115: and not exists (select 'e' from hr_api_transactions t

2111: from wf_items wi
2112: where wi.item_type = itemtype
2113: and wi.begin_date <= trunc(sysdate)
2114: and wi.end_date is null
2115: and not exists (select 'e' from hr_api_transactions t
2116: where
2117: t.item_type is not null
2118: and t.item_key is not null
2119: and wi.item_type = t.item_type

Line 2122: and not exists (select 'e' from hr_api_transactions t, hr_api_transaction_steps ts

2118: and t.item_key is not null
2119: and wi.item_type = t.item_type
2120: and wi.item_key = t.item_key
2121: )
2122: and not exists (select 'e' from hr_api_transactions t, hr_api_transaction_steps ts
2123: where
2124: t.item_type is null
2125: and t.item_key is null
2126: and t.transaction_id = ts.transaction_id

Line 2145: from hr_api_transactions hat,

2141: cursor csrOfferDetails(c_transaction_id in number) is
2142: select hat.transaction_ref_id,
2143: hat.assignment_id,
2144: iof.offer_status
2145: from hr_api_transactions hat,
2146: irc_offers iof
2147: where hat.transaction_ref_table='IRC_OFFERS' and
2148: hat.transaction_ref_id = iof.offer_id and
2149: hat.transaction_id = c_transaction_id and

Line 2157: and not exists (select transaction_id from hr_api_transactions

2153: CURSOR defunct_wfsfl_ids IS
2154: select wi.item_key
2155: from wf_items wi
2156: where wi.item_type = 'HRSFL'
2157: and not exists (select transaction_id from hr_api_transactions
2158: where transaction_id = wi.user_key);
2159: --
2160:
2161: l_offer_id number;

Line 2594: function getItemType(p_transaction_id in hr_api_transactions.transaction_id%type)

2590: retcode := '2';
2591: end TotalConcurrent;
2592:
2593:
2594: function getItemType(p_transaction_id in hr_api_transactions.transaction_id%type)
2595: return wf_items.item_type%type is
2596: l_item_type wf_items.item_type%type;
2597: begin
2598: select ts.item_type

Line 2606: function getItemKey(p_transaction_id in hr_api_transactions.transaction_id%type)

2602: and ts.item_type is not null and rownum <=1;
2603: return getItemType.l_item_type;
2604: end getItemType;
2605:
2606: function getItemKey(p_transaction_id in hr_api_transactions.transaction_id%type)
2607: return wf_items.item_key%type is
2608: l_item_key wf_items.item_key%type;
2609: begin
2610: select ts.item_key