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')
2009: and t.transaction_ref_table <> 'PER_APPRAISALS'
2010: ) a, -- bug 3635925 , bug 5357274, bug 5990955

Line 2028: from hr_api_transactions t

2024: from (select transaction_id,
2025: status,
2026: nvl(item_type,hr_workflow_service.getItemType(t.transaction_id)) item_type,
2027: nvl(item_key,hr_workflow_service.getItemKey(t.transaction_id)) item_key
2028: from hr_api_transactions t
2029: where t.last_update_date <= sysdate - c_transaction_age
2030: and t.status not in ('Y', 'YS')
2031: and t.transaction_ref_table <> 'PER_APPRAISALS'
2032: and t.item_key is null

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

2040: -- start bug 5990955
2041:
2042: --Only the appraisals with a System status (appraisal_system_status in
2043: -- PER_APPRAISALS) as "COMPLETED" or "DELETED", irrespective of status in
2044: -- HR_API_TRANSACTIONS table will be deleted. So looking for the
2045: -- APPRAISAL_SYSTEM_STATUS in the cursor
2046:
2047: CURSOR csr_wfdfctitmsapprs (c_transaction_age in number) is
2048: SELECT t.item_type, t.item_key, t.transaction_id

Line 2049: FROM hr_api_transactions t, per_appraisals a

2045: -- APPRAISAL_SYSTEM_STATUS in the cursor
2046:
2047: CURSOR csr_wfdfctitmsapprs (c_transaction_age in number) is
2048: SELECT t.item_type, t.item_key, t.transaction_id
2049: FROM hr_api_transactions t, per_appraisals a
2050: WHERE t.transaction_ref_table = 'PER_APPRAISALS'
2051: AND t.last_update_date <= sysdate - c_transaction_age
2052: AND t.transaction_ref_id = a.appraisal_id
2053: AND a.appraisal_system_status IN ('DELETED','COMPLETED');

Line 2079: FROM hr_api_transactions hat

2075: AND wi.item_key = hats.item_key);
2076: */
2077: -- Fix for bug#3322644
2078: SELECT hat.transaction_id
2079: FROM hr_api_transactions hat
2080: WHERE NOT EXISTS (SELECT 'Y'
2081: FROM wf_items wi
2082: WHERE wi.item_type = nvl(hat.item_type,hr_workflow_service.getItemType(hat.transaction_id))
2083: AND wi.item_key = nvl(hat.item_key,hr_workflow_service.getItemKey(hat.transaction_id))

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

2087: and w.user_key = hat.transaction_id)
2088: and hat.item_key is not null;
2089: --
2090: -- to fetch orphan records from wf tables which do not have an entry
2091: -- in the hr_api_transactions. This could cause from SSHR transaction
2092: -- not using hr_api_transactions and for WF process started without
2093: -- an entry to the hr_api_transactions. Possible causes, user started
2094: -- new transaction and closed the web browser.
2095:

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

2088: and hat.item_key is not null;
2089: --
2090: -- to fetch orphan records from wf tables which do not have an entry
2091: -- in the hr_api_transactions. This could cause from SSHR transaction
2092: -- not using hr_api_transactions and for WF process started without
2093: -- an entry to the hr_api_transactions. Possible causes, user started
2094: -- new transaction and closed the web browser.
2095:
2096: -- fix for bug#2838117

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

2089: --
2090: -- to fetch orphan records from wf tables which do not have an entry
2091: -- in the hr_api_transactions. This could cause from SSHR transaction
2092: -- not using hr_api_transactions and for WF process started without
2093: -- an entry to the hr_api_transactions. Possible causes, user started
2094: -- new transaction and closed the web browser.
2095:
2096: -- fix for bug#2838117
2097: -- fetch all the records from wf_items for given item type which

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

2094: -- new transaction and closed the web browser.
2095:
2096: -- fix for bug#2838117
2097: -- fetch all the records from wf_items for given item type which
2098: -- not in hr_api_transactions and icx session is disabled or does
2099: -- not exist.
2100:
2101: -- 4287117
2102: --5076290

Line 2117: from hr_api_transactions t1

2113: and s.disabled_flag(+) = 'Y'
2114: and (
2115: (wi.item_key) not in (
2116: select t1.item_key
2117: from hr_api_transactions t1
2118: where wi.item_type = t1.item_type
2119: and wi.item_key = t1.item_key
2120: and t1.item_type = itemtype
2121: )

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

2133: from wf_items wi
2134: where wi.item_type = itemtype
2135: and wi.begin_date <= trunc(sysdate)
2136: and wi.end_date is null
2137: and not exists (select 'e' from hr_api_transactions t
2138: where
2139: t.item_type is not null
2140: and t.item_key is not null
2141: and wi.item_type = t.item_type

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

2140: and t.item_key is not null
2141: and wi.item_type = t.item_type
2142: and wi.item_key = t.item_key
2143: )
2144: and not exists (select 'e' from hr_api_transactions t, hr_api_transaction_steps ts
2145: where
2146: t.item_type is null
2147: and t.item_key is null
2148: and t.transaction_id = ts.transaction_id

Line 2167: from hr_api_transactions hat,

2163: cursor csrOfferDetails(c_transaction_id in number) is
2164: select hat.transaction_ref_id,
2165: hat.assignment_id,
2166: iof.offer_status
2167: from hr_api_transactions hat,
2168: irc_offers iof
2169: where hat.transaction_ref_table='IRC_OFFERS' and
2170: hat.transaction_ref_id = iof.offer_id and
2171: hat.transaction_id = c_transaction_id and

Line 2179: and not exists (select transaction_id from hr_api_transactions

2175: CURSOR defunct_wfsfl_ids IS
2176: select wi.item_key
2177: from wf_items wi
2178: where wi.item_type = 'HRSFL'
2179: and not exists (select transaction_id from hr_api_transactions
2180: where transaction_id = wi.user_key);
2181: --
2182:
2183: l_offer_id number;

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

2629: retcode := '2';
2630: end TotalConcurrent;
2631:
2632:
2633: function getItemType(p_transaction_id in hr_api_transactions.transaction_id%type)
2634: return wf_items.item_type%type is
2635: l_item_type wf_items.item_type%type;
2636: begin
2637: select ts.item_type

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

2641: and ts.item_type is not null and rownum <=1;
2642: return getItemType.l_item_type;
2643: end getItemType;
2644:
2645: function getItemKey(p_transaction_id in hr_api_transactions.transaction_id%type)
2646: return wf_items.item_key%type is
2647: l_item_key wf_items.item_key%type;
2648: begin
2649: select ts.item_key