APPS.IGW_WORKFLOW SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

procedure select_persons_to_notify(itemtype    in   varchar2,
                           itemkey     in   varchar2,
                           actid       in   number,
                           funcmode    in   varchar2,
                           result      out  nocopy varchar2) is

cursor get_notification_role is
select  distinct
        ppms.wf_role_name
from    igw_prop_maps ppm,
        igw_prop_map_stops ppms
where   ppm.prop_map_id = ppms.prop_map_id
and     ppm.run_id = to_number(itemkey)
and     ppm.map_type = 'N'
and     ppms.submission_date is null;

Line: 40

end select_persons_to_notify;

Line: 43

procedure select_approver(itemtype    in   varchar2,
                           itemkey     in   varchar2,
                           actid       in   number,
                           funcmode    in   varchar2,
                           result      out  nocopy varchar2) is

begin
  null;

Line: 51

end select_approver;

Line: 79

procedure update_approval_status(itemtype    in   varchar2,
                                  itemkey     in   varchar2,
                                  actid       in   number,
                                  funcmode    in   varchar2,
                                  result      out  nocopy varchar2) is



begin


  null;

Line: 91

end update_approval_status;

Line: 96

procedure delete_approval_roles(l_proposal_id    in   number) is




begin

  null;

Line: 104

end delete_approval_roles;

Line: 108

procedure update_rejection_status(itemtype    in   varchar2,
                                  itemkey     in   varchar2,
                                  actid       in   number,
                                  funcmode    in   varchar2,
                                  result      out  nocopy varchar2) is

  cursor select_responder(l_forward_to_username varchar2) is
  select wn.responder,wna.text_value
  from   wf_notification_attributes  wna,
         wf_notifications wn
  where  wn.notification_id = wna.notification_id
  and    wna.name = 'NOTE'
  and    wn.recipient_role = l_forward_to_username
  and    wn.responder is not null
  and    wn.message_name = 'NOTIFY_APPROVER';

Line: 133

end update_rejection_status;