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.HXC_APPROVAL_WF_HELPER dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 359: (p_recipient_code in wf_item_attribute_values.text_value%type,

355: END find_worker_role;
356:
357: -----------------------------------------------------------------------------------------------------
358: FUNCTION find_role_for_recipient
359: (p_recipient_code in wf_item_attribute_values.text_value%type,
360: p_timecard_id in number,
361: p_timecard_ovn in number)
362: Return wf_local_roles.name%type
363:

Line 599: p_name in wf_item_attribute_values.name%type)

595: --This FUNCTION simply checks that the item attribute value name passed exists for the supplied item type and item key
596: FUNCTION item_attribute_value_exists
597: (p_item_type in wf_items.item_type%type,
598: p_item_key in wf_item_activity_statuses.item_key%type,
599: p_name in wf_item_attribute_values.name%type)
600: return boolean is
601:
602: l_dummy varchar2(1);
603:

Line 608: from wf_item_attribute_values

604: BEGIN
605:
606: select 'Y'
607: into l_dummy
608: from wf_item_attribute_values
609: where item_type = p_item_type
610: and item_key = p_item_key
611: and name = p_name;
612:

Line 645: p_notif_action_code in wf_item_attribute_values.text_value%type,

641: ---------------------------------------------------------------------------------------------------------------
642: PROCEDURE set_notif_attribute_values
643: (p_item_type in wf_items.item_type%type,
644: p_item_key in wf_item_activity_statuses.item_key%type,
645: p_notif_action_code in wf_item_attribute_values.text_value%type,
646: p_notif_recipient_code in wf_item_attribute_values.text_value%type)
647:
648: is
649:

Line 646: p_notif_recipient_code in wf_item_attribute_values.text_value%type)

642: PROCEDURE set_notif_attribute_values
643: (p_item_type in wf_items.item_type%type,
644: p_item_key in wf_item_activity_statuses.item_key%type,
645: p_notif_action_code in wf_item_attribute_values.text_value%type,
646: p_notif_recipient_code in wf_item_attribute_values.text_value%type)
647:
648: is
649:
650: BEGIN

Line 708: p_action_code in wf_item_attribute_values.text_value%type,

704: END set_notif_attribute_values;
705:
706: FUNCTION send_notification
707: (p_approval_comp_id in number,
708: p_action_code in wf_item_attribute_values.text_value%type,
709: p_recipient_code in wf_item_attribute_values.text_value%type,
710: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
711: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
712: p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,

Line 709: p_recipient_code in wf_item_attribute_values.text_value%type,

705:
706: FUNCTION send_notification
707: (p_approval_comp_id in number,
708: p_action_code in wf_item_attribute_values.text_value%type,
709: p_recipient_code in wf_item_attribute_values.text_value%type,
710: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
711: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
712: p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
713: p_app_period_ovn in hxc_time_building_blocks.object_version_number%type)

Line 727: l_recipient_action_code wf_item_attribute_values.text_value%type;

723: l_tc_url varchar2(1000);
724: l_block_index PLS_INTEGER := 1;
725: l_tk_audit_item_key hxc_timecard_summary.tk_audit_item_key%type;
726: l_resource_id hxc_time_building_blocks.resource_id%type;
727: l_recipient_action_code wf_item_attribute_values.text_value%type;
728: l_action_code wf_item_attribute_values.text_value%type;
729: l_notification_id wf_notifications.notification_id%type;
730: l_recipient_role wf_local_roles.name%type;
731: l_app_mech varchar2(30);

Line 728: l_action_code wf_item_attribute_values.text_value%type;

724: l_block_index PLS_INTEGER := 1;
725: l_tk_audit_item_key hxc_timecard_summary.tk_audit_item_key%type;
726: l_resource_id hxc_time_building_blocks.resource_id%type;
727: l_recipient_action_code wf_item_attribute_values.text_value%type;
728: l_action_code wf_item_attribute_values.text_value%type;
729: l_notification_id wf_notifications.notification_id%type;
730: l_recipient_role wf_local_roles.name%type;
731: l_app_mech varchar2(30);
732: l_app_start_date date;

Line 740: p_action_code in wf_item_attribute_values.text_value%type,

736: l_proc constant varchar2(61) := g_pkg ||'send_notification';
737:
738:
739: CURSOR c_is_notification_exists(p_approval_comp_id in number,
740: p_action_code in wf_item_attribute_values.text_value%type,
741: p_retrieval_code in wf_item_attribute_values.text_value%type)
742: is
743: select 'Y'
744: from hxc_app_comp_notifications hacn,

Line 741: p_retrieval_code in wf_item_attribute_values.text_value%type)

737:
738:
739: CURSOR c_is_notification_exists(p_approval_comp_id in number,
740: p_action_code in wf_item_attribute_values.text_value%type,
741: p_retrieval_code in wf_item_attribute_values.text_value%type)
742: is
743: select 'Y'
744: from hxc_app_comp_notifications hacn,
745: hxc_app_comp_notif_usages hacnu

Line 1702: from wf_item_attribute_values

1698:
1699: CURSOR get_result
1700: is
1701: select text_value
1702: from wf_item_attribute_values
1703: where item_type = itemtype
1704: and item_key = itemkey
1705: and name = 'RESULT';
1706: