APPS.HR_TRANSACTION_API dependencies on HR_API_TRANSACTION_STEPS

Line 25: from hr_api_transaction_steps hats

21: --
22: cursor csr_hats is
23: select hats.transaction_step_id
24: ,hats.object_version_number
25: from hr_api_transaction_steps hats
26: where hats.item_type = p_item_type
27: and hats.item_key = p_item_key
28: and hats.activity_id = p_activity_id;
29: --

Line 71: from hr_api_transaction_steps hats

67: -- -------------------------------------------------------------------
68: cursor csr_hats is
69: select hats.transaction_step_id
70: ,hats.object_version_number
71: from hr_api_transaction_steps hats
72: where hats.item_type = p_item_type
73: and hats.item_key = p_item_key
74: and hats.activity_id = p_activity_id
75: order by hats.transaction_step_id, hats.object_version_number;

Line 116: from hr_api_transaction_steps hats

112: -- -------------------------------------------------------------------
113: cursor csr_hats is
114: select hats.transaction_step_id
115: ,hats.object_version_number
116: from hr_api_transaction_steps hats
117: where hats.item_type = p_item_type
118: and hats.item_key = p_item_key
119: order by hats.transaction_step_id, hats.object_version_number;
120: --

Line 160: from hr_api_transaction_steps hats

156: cursor csr_hats is
157: select hats.item_type
158: ,hats.item_key
159: ,hats.activity_id
160: from hr_api_transaction_steps hats
161: where hats.transaction_step_id = p_transaction_step_id;
162: --
163: begin
164: g_debug := hr_utility.debug_enabled;

Line 206: from hr_api_transaction_steps hats

202: -- -------------------------------------------------------------------
203: cursor csr_hapi is
204: select hats.transaction_step_id
205: ,hats.api_name
206: from hr_api_transaction_steps hats
207: where hats.item_type = p_item_type
208: and hats.item_key = p_item_key
209: and hats.activity_id = p_activity_id
210: order by hats.transaction_step_id, hats.object_version_number;

Line 215: from hr_api_transaction_steps hats

211: --
212: cursor csr_hapi_nAct is
213: select hats.transaction_step_id
214: ,hats.api_name
215: from hr_api_transaction_steps hats
216: where hats.item_type = p_item_type
217: and hats.item_key = p_item_key
218: order by hats.transaction_step_id, hats.object_version_number;
219: --

Line 271: l_object_version_number hr_api_transaction_steps.object_version_number%type;

267: -- --------------------------------------------------------------------------
268: -- declare local variables
269: -- --------------------------------------------------------------------------
270: l_proc constant varchar2(100) := g_package || ' transaction_step_exist';
271: l_object_version_number hr_api_transaction_steps.object_version_number%type;
272: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
273: l_return boolean := true;
274: --
275: begin

Line 272: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

268: -- declare local variables
269: -- --------------------------------------------------------------------------
270: l_proc constant varchar2(100) := g_package || ' transaction_step_exist';
271: l_object_version_number hr_api_transaction_steps.object_version_number%type;
272: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
273: l_return boolean := true;
274: --
275: begin
276: g_debug := hr_utility.debug_enabled;

Line 311: from hr_api_transaction_steps hats

307: l_transaction_id hr_api_transactions.transaction_id%type;
308: -- cursor to select the transaction_id of the step
309: cursor csr_hats is
310: select hats.transaction_id
311: from hr_api_transaction_steps hats
312: where hats.transaction_step_id = p_transaction_step_id;
313:
314: begin
315:

Line 1899: from hr_api_transaction_steps trs

1895: -- cursor to select all transaction steps for a transaction
1896: cursor csr_trs is
1897: select trs.transaction_step_id
1898: ,trs.object_version_number
1899: from hr_api_transaction_steps trs
1900: where trs.transaction_id = p_transaction_id;
1901: --
1902: cursor csr_hist is
1903: select action