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_TRANSACTION_STEPS

Line 1329: from hr_api_transaction_steps

1325: and attribute.number_value = p_current_person_id);*/
1326:
1327: cursor csr_hats is
1328: select 1
1329: from hr_api_transaction_steps
1330: where item_type = p_item_type
1331: and item_key = l_active_item_key;
1332:
1333: cursor csr_wfactname is

Line 1513: from hr_api_transaction_steps

1509: and attribute.number_value = p_current_person_id);*/
1510:
1511: cursor csr_hats is
1512: select 1
1513: from hr_api_transaction_steps
1514: where item_type = p_item_type
1515: and item_key = l_active_item_key;
1516:
1517: cursor csr_wfactname is

Line 1599: ,p_api_name in hr_api_transaction_steps.api_name%type

1595: FUNCTION get_active_wf_items
1596: (p_item_type in wf_items.item_type%type
1597: ,p_process_name in wf_process_activities.process_name%type
1598: ,p_current_person_id in per_people_f.person_id%type
1599: ,p_api_name in hr_api_transaction_steps.api_name%type
1600: ,p_activity_result_code in varchar2 default null
1601: ,p_address_context in varchar2 default null
1602: )
1603: return active_wf_trans_items_list is

Line 1684: from hr_api_transaction_steps

1680: ------------------------------------------------------------------------------
1681: cursor csr_hats (csr_p_api_name in varchar2
1682: ,csr_p_item_key in varchar2) is
1683: select transaction_step_id, activity_id
1684: from hr_api_transaction_steps
1685: where item_type = p_item_type
1686: and item_key = csr_p_item_key
1687: and upper(api_name) = csr_p_api_name;
1688:

Line 1708: from hr_api_transaction_steps step

1704: ,csr_p_item_key in varchar2
1705: ,csr_p_primary_flag in varchar2
1706: ) is
1707: select step.transaction_step_id, step.activity_id
1708: from hr_api_transaction_steps step
1709: ,hr_api_transaction_values value
1710: where item_type = p_item_type
1711: and item_key = csr_p_item_key
1712: and upper(api_name) = csr_p_api_name

Line 1721: api_name_in hr_api_transaction_steps.api_name%type default null;

1717:
1718: l_activity_result_code wf_item_activity_statuses.activity_result_code%type;
1719: l_activity_result_code_in wf_item_activity_statuses.activity_result_code%type
1720: default null;
1721: api_name_in hr_api_transaction_steps.api_name%type default null;
1722: l_trans_step_id hr_api_transaction_steps.transaction_step_id%type
1723: default null;
1724: l_address_primary_flag per_addresses.primary_flag%type default null;
1725: l_use_csr_addr_hats varchar2(1) default null;

Line 1722: l_trans_step_id hr_api_transaction_steps.transaction_step_id%type

1718: l_activity_result_code wf_item_activity_statuses.activity_result_code%type;
1719: l_activity_result_code_in wf_item_activity_statuses.activity_result_code%type
1720: default null;
1721: api_name_in hr_api_transaction_steps.api_name%type default null;
1722: l_trans_step_id hr_api_transaction_steps.transaction_step_id%type
1723: default null;
1724: l_address_primary_flag per_addresses.primary_flag%type default null;
1725: l_use_csr_addr_hats varchar2(1) default null;
1726:

Line 2036: -- hr_api_transaction_steps table

2032:
2033: -- end bug 5990955
2034:
2035: -- csr_wfdfctrans check if the Itemkey is present in the
2036: -- hr_api_transaction_steps table
2037: cursor csr_wfdfctrans is
2038: select hats.transaction_id
2039: from hr_api_transaction_steps hats
2040: where hats.item_type = itemtype

Line 2039: from hr_api_transaction_steps hats

2035: -- csr_wfdfctrans check if the Itemkey is present in the
2036: -- hr_api_transaction_steps table
2037: cursor csr_wfdfctrans is
2038: select hats.transaction_id
2039: from hr_api_transaction_steps hats
2040: where hats.item_type = itemtype
2041: and hats.item_key = l_item_key;
2042:
2043: --

Line 2049: FROM hr_api_transaction_steps hats

2045: -- executing this defunct process
2046: --
2047: CURSOR defunct_tx_ids IS
2048: /* SELECT distinct hats.transaction_id
2049: FROM hr_api_transaction_steps hats
2050: WHERE NOT EXISTS (SELECT 'Y'
2051: FROM wf_items wi
2052: WHERE wi.item_type = hats.item_type
2053: AND wi.item_key = hats.item_key);

Line 2102: from hr_api_transaction_steps ts

2098: and t1.item_type = itemtype
2099: )
2100: and (wi.item_key) not in (
2101: select ts.item_key
2102: from hr_api_transaction_steps ts
2103: where ts.item_type = wi.item_type
2104: and ts.item_key = wi.item_key
2105: and ts.item_type = itemtype
2106: )

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 2600: from hr_api_transaction_steps ts

2596: l_item_type wf_items.item_type%type;
2597: begin
2598: select ts.item_type
2599: into getItemType.l_item_type
2600: from hr_api_transaction_steps ts
2601: where ts.transaction_id=getItemType.p_transaction_id
2602: and ts.item_type is not null and rownum <=1;
2603: return getItemType.l_item_type;
2604: end getItemType;

Line 2612: from hr_api_transaction_steps ts

2608: l_item_key wf_items.item_key%type;
2609: begin
2610: select ts.item_key
2611: into getItemkey.l_item_key
2612: from hr_api_transaction_steps ts
2613: where getItemkey.p_transaction_id = ts.transaction_id
2614: and ts.item_key is not null and rownum <=1;
2615: return getItemkey.l_item_key;
2616: end getItemKey;