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 2058: -- hr_api_transaction_steps table

2054:
2055: -- end bug 5990955
2056:
2057: -- csr_wfdfctrans check if the Itemkey is present in the
2058: -- hr_api_transaction_steps table
2059: cursor csr_wfdfctrans is
2060: select hats.transaction_id
2061: from hr_api_transaction_steps hats
2062: where hats.item_type = itemtype

Line 2061: from hr_api_transaction_steps hats

2057: -- csr_wfdfctrans check if the Itemkey is present in the
2058: -- hr_api_transaction_steps table
2059: cursor csr_wfdfctrans is
2060: select hats.transaction_id
2061: from hr_api_transaction_steps hats
2062: where hats.item_type = itemtype
2063: and hats.item_key = l_item_key;
2064:
2065: --

Line 2071: FROM hr_api_transaction_steps hats

2067: -- executing this defunct process
2068: --
2069: CURSOR defunct_tx_ids IS
2070: /* SELECT distinct hats.transaction_id
2071: FROM hr_api_transaction_steps hats
2072: WHERE NOT EXISTS (SELECT 'Y'
2073: FROM wf_items wi
2074: WHERE wi.item_type = hats.item_type
2075: AND wi.item_key = hats.item_key);

Line 2124: from hr_api_transaction_steps ts

2120: and t1.item_type = itemtype
2121: )
2122: and (wi.item_key) not in (
2123: select ts.item_key
2124: from hr_api_transaction_steps ts
2125: where ts.item_type = wi.item_type
2126: and ts.item_key = wi.item_key
2127: and ts.item_type = itemtype
2128: )

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

2635: l_item_type wf_items.item_type%type;
2636: begin
2637: select ts.item_type
2638: into getItemType.l_item_type
2639: from hr_api_transaction_steps ts
2640: where ts.transaction_id=getItemType.p_transaction_id
2641: and ts.item_type is not null and rownum <=1;
2642: return getItemType.l_item_type;
2643: end getItemType;

Line 2651: from hr_api_transaction_steps ts

2647: l_item_key wf_items.item_key%type;
2648: begin
2649: select ts.item_key
2650: into getItemkey.l_item_key
2651: from hr_api_transaction_steps ts
2652: where getItemkey.p_transaction_id = ts.transaction_id
2653: and ts.item_key is not null and rownum <=1;
2654: return getItemkey.l_item_key;
2655: end getItemKey;