APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 584: --updating the wf_notification_attributes with Archival=Yes URL param

580: RETURN TRUE;
581:
582: END incompatibility_pg_running;
583:
584: --updating the wf_notification_attributes with Archival=Yes URL param
585: --while cancelling the notification via archival.
586: --Gets called from hxc_find_notify_aprs_pkg.cancel_notifications procedure.
587:
588: PROCEDURE upd_wf_notif_attributes(p_item_type in varchar2,

Line 592: l_timecard_url wf_notification_attributes.TEXT_VALUE%TYPE;

588: PROCEDURE upd_wf_notif_attributes(p_item_type in varchar2,
589: p_item_key in varchar2) is
590:
591: l_notification_id NUMBER;
592: l_timecard_url wf_notification_attributes.TEXT_VALUE%TYPE;
593: l_temp_timecard_url wf_notification_attributes.TEXT_VALUE%TYPE;
594: l_pos NUMBER;
595:
596:

Line 593: l_temp_timecard_url wf_notification_attributes.TEXT_VALUE%TYPE;

589: p_item_key in varchar2) is
590:
591: l_notification_id NUMBER;
592: l_timecard_url wf_notification_attributes.TEXT_VALUE%TYPE;
593: l_temp_timecard_url wf_notification_attributes.TEXT_VALUE%TYPE;
594: l_pos NUMBER;
595:
596:
597: CURSOR c_notif_id(p_item_key in varchar2,p_item_type in varchar2 ) is

Line 605: FROM wf_notification_attributes

601: AND ITEM_TYPE = p_item_type;
602:
603: CURSOR c_timecard_url_value(p_notification_id in varchar2) is
604: SELECT text_value
605: FROM wf_notification_attributes
606: WHERE notification_id = p_notification_id
607: and name = 'TIMECARD';
608:
609: BEGIN

Line 634: update wf_notification_attributes set

630: l_timecard_url :=
631: l_temp_timecard_url||'&Archived=Yes'||substr(l_timecard_url,(l_pos-1));
632:
633: --Updating the Workflow Notification Attributes.
634: update wf_notification_attributes set
635: text_value = l_timecard_url
636: where notification_id = l_notification_id
637: and name = 'TIMECARD';
638: