DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_HELPER dependencies on WF_ITEMS

Line 463: (p_item_type in wf_items.item_type%type,

459: END is_approver_supervisor;
460: -----------------------------------------------------------------------------------------------------------
461:
462: PROCEDURE get_notif_attribute_values
463: (p_item_type in wf_items.item_type%type,
464: p_item_key in wf_item_activity_statuses.item_key%type,
465: p_app_bb_id in number,
466: p_notif_action_code out nocopy varchar2,
467: p_notif_recipient_code out nocopy varchar2,

Line 597: (p_item_type in wf_items.item_type%type,

593:
594: ---------------------------------------------------------------------------------------------------------------
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:

Line 643: (p_item_type in wf_items.item_type%type,

639:
640: END notification_with_details;
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:

Line 722: l_item_key wf_items.item_key%type;

718: l_result boolean;
719: l_dummy varchar2(1) := 'N';
720: l_app_bb_id hxc_time_building_blocks.time_building_block_id%type;
721: l_timecard_fyi varchar2(1000);
722: l_item_key wf_items.item_key%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;