APPS.HR_EMP_ERROR_UTILITY dependencies on HR_API_TRANSACTION_STEPS

Line 249: from hr_api_transaction_steps hats

245: Modified the cursor to use the PK of the table wf_item_attribute_values and
246: avoid a full table scan so as to enhance performance.
247: */
248: select iav.text_value
249: from hr_api_transaction_steps hats
250: ,wf_item_attribute_values iav
251: where iav.item_type = p_item_type
252: and iav.item_key = p_item_key
253: and iav.name like p_type||':%'

Line 262: from hr_api_transaction_steps hats

258: ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));
259:
260:
261: /* select iav.text_value
262: from hr_api_transaction_steps hats
263: ,wf_item_attribute_values iav
264: where hats.activity_id = p_actid
265: and hats.item_type = p_item_type
266: and hats.item_key = p_item_key

Line 332: ,p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE

328: FUNCTION exists_messages
329: (p_item_type IN wf_items.item_type%TYPE
330: ,p_item_key IN wf_items.item_key%TYPE
331: ,p_actid IN wf_process_activities.instance_id%TYPE
332: ,p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE
333: ,p_type IN varchar2) RETURN BOOLEAN IS
334: -- --------------------------------------------------------------------------
335: -- local cursor definitions
336: -- --------------------------------------------------------------------------

Line 342: from hr_api_transaction_steps hats

338: --
339: CURSOR csr_wf_text is
340: -- fix for bug # 1577987
341: select iav.text_value
342: from hr_api_transaction_steps hats
343: ,wf_item_attribute_values iav
344: where iav.item_type = p_item_type
345: and iav.item_key = p_item_key
346: and iav.name like p_type||':%'

Line 356: from hr_api_transaction_steps hats

352: ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));
353:
354:
355: /*select iav.text_value
356: from hr_api_transaction_steps hats
357: ,wf_item_attribute_values iav
358: where hats.activity_id = p_actid
359: and hats.item_type = p_item_type
360: and hats.item_key = p_item_key

Line 664: hr_api_transaction_steps hats

660: --
661: CURSOR csr_wf_attribute_name IS
662: SELECT iav.name
663: FROM wf_item_attribute_values iav,
664: hr_api_transaction_steps hats
665: WHERE iav.item_type = hats.item_type
666: AND iav.item_key = hats.item_key
667: AND (iav.name LIKE 'ERROR_TEXT:%'
668: OR iav.name LIKE 'WARNING_TEXT:%')

Line 691: from hr_api_transaction_steps hats

687: ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1
688: )
689: ) in
690: (select hats.transaction_step_id
691: from hr_api_transaction_steps hats
692: where hats.item_type = p_item_type
693: and hats.item_key = p_item_key
694: and hats.activity_id = p_actid);*/
695: -- ---------------------------------------------------------------------------

Line 814: ,p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE) RETURN BOOLEAN IS

810: FUNCTION exists_error_text
811: (p_item_type IN wf_items.item_type%TYPE
812: ,p_item_key IN wf_items.item_key%TYPE
813: ,p_actid IN wf_process_activities.instance_id%TYPE
814: ,p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE) RETURN BOOLEAN IS
815: -- ---------------------------------------------------------------------------
816: -- Local variable declarations
817: -- ---------------------------------------------------------------------------
818: l_proc_name varchar2(61) := g_package||'exists_error_text';

Line 872: ,p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE) RETURN BOOLEAN IS

868: FUNCTION exists_warning_text
869: (p_item_type IN wf_items.item_type%TYPE
870: ,p_item_key IN wf_items.item_key%TYPE
871: ,p_actid IN wf_process_activities.instance_id%TYPE
872: ,p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE) RETURN BOOLEAN IS
873: -- ---------------------------------------------------------------------------
874: -- Local variable declarations
875: -- ---------------------------------------------------------------------------
876: l_proc_name varchar2(61) := g_package||'exists_warning_text';