[Home] [Help]
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,
468: p_approval_comp_id out nocopy number,
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:
602: l_dummy varchar2(1);
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:
648: is
769: from wf_notifications wn,
770: wf_notification_attributes wna1,
771: wf_notification_attributes wna2,
772: wf_notification_attributes wna3,
773: wf_item_activity_statuses wias
774: where wn.message_name = 'HXC_GENERIC_NOTIF_MESSAGE'
775: and wn.message_type = 'HXCEMP'
776: and (wn.recipient_role = p_recipient_role OR wn.original_recipient = p_recipient_role)
777: and wna1.notification_id = wn.notification_id