APPS.HR_EMP_ERROR_UTILITY dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 120: from wf_item_attribute_values iav

116: -- transaction step id which is set to NULL
117: --
118: CURSOR csr_wf_count IS
119: select count(*)
120: from wf_item_attribute_values iav
121: where iav.item_type = p_item_type
122: and iav.item_key = p_item_key
123: and iav.name like p_type||':%';
124: CURSOR csr_wf_min_error_instance IS

Line 127: from wf_item_attribute_values iav

123: and iav.name like p_type||':%';
124: CURSOR csr_wf_min_error_instance IS
125: select min(to_number(substr(iav.name
126: ,instr(iav.name,':',1,2) + 1)))
127: from wf_item_attribute_values iav
128: where iav.item_type = p_item_type
129: and iav.item_key = p_item_key
130: and iav.name like p_type||':%'
131: and to_number(substr(iav.name

Line 143: l_aname wf_item_attribute_values.name%TYPE :=

139: -- ---------------------------------------------------------------------------
140: l_proc_name varchar2(71) := g_package||'set_transact_step_messages';
141: l_error_instance number;
142: l_count number;
143: l_aname wf_item_attribute_values.name%TYPE :=
144: p_type||':'||to_char(p_transaction_step_id)||':';
145: BEGIN
146: -- -------------------------------------------------------------------------
147: -- Test to see if any item attributes exist

Line 245: Modified the cursor to use the PK of the table wf_item_attribute_values and

241: --
242: CURSOR csr_wf_text is
243: -- fix for bug # 1577987
244: /*
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

Line 250: ,wf_item_attribute_values iav

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||':%'
254: and hats.activity_id = p_actid

Line 263: ,wf_item_attribute_values iav

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
267: and iav.name like p_type||':%'

Line 343: ,wf_item_attribute_values iav

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||':%'
347: and hats.activity_id = p_actid

Line 357: ,wf_item_attribute_values iav

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
361: and iav.name like p_type||':%'

Line 663: FROM wf_item_attribute_values iav,

659: -- for a given activity
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:%'

Line 679: from wf_item_attribute_values iav

675: AND hats.activity_id = p_actid;
676:
677: /*CURSOR csr_wf_attribute_name IS
678: select iav.name
679: from wf_item_attribute_values iav
680: where iav.item_type = p_item_type
681: and iav.item_key = p_item_key
682: and iav.name like 'ERROR_TEXT'||':%'
683: or iav.name like 'WARNING_TEXT'||':%'

Line 730: FROM wf_item_attribute_values iav

726: -- for a given transaction step
727: --
728: CURSOR csr_wf_attribute_name IS
729: SELECT iav.name
730: FROM wf_item_attribute_values iav
731: WHERE iav.item_type = p_item_type
732: AND iav.item_key = p_item_key
733: AND (iav.name LIKE 'ERROR_TEXT:%'
734: OR iav.name LIKE 'WARNING_TEXT:%')

Line 742: from wf_item_attribute_values iav

738: p_transaction_step_id;
739:
740: /*CURSOR csr_wf_attribute_name IS
741: select iav.name
742: from wf_item_attribute_values iav
743: where iav.item_type = p_item_type
744: and iav.item_key = p_item_key
745: and iav.name like 'ERROR_TEXT'||':%'
746: or iav.name like 'WARNING_TEXT'||':%'