APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 44: gv_effective_date wf_item_attribute_values.text_value%TYPE;

40: gv_language_code VARCHAR2(200) DEFAULT NULL;
41: gv_approvals_mode wf_activity_attr_values.text_value%TYPE;
42: gv_update_mode wf_activity_attr_values.text_value%TYPE
43: DEFAULT 'OFF';
44: gv_effective_date wf_item_attribute_values.text_value%TYPE;
45: gv_APPROVALS_ACTIVITY_NAME CONSTANT
46: wf_item_activity_statuses_v.activity_name%TYPE
47: DEFAULT 'HR_DYNAMIC_APPROVALS';
48: gv_process_name wf_process_activities.process_name%TYPE

Line 143: from wf_item_attribute_values wiav

139: ,p_item_key in varchar2
140: ,p_name in varchar2)
141: IS
142: select 1
143: from wf_item_attribute_values wiav
144: where wiav.item_type = p_item_type
145: and wiav.item_key = p_item_key
146: and wiav.name = p_name;
147:

Line 606: -- wf_item_attribute_values table and creates other item_attributes if not exist.

602: -- |------------------------------< COMMIT_DATA>-------------------|
603: -- ----------------------------------------------------------------------------
604: --
605: -- This procedure will write the approvers and notifiers data to the
606: -- wf_item_attribute_values table and creates other item_attributes if not exist.
607: --
608: PROCEDURE COMMIT_DATA(
609: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
610: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,