APPS.AMW_GEN_APPROVAL_PVT SQL Statements

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

Line: 41

      select   employee_id
      into   l_employee_id
      from   FND_USER
      where   user_id   = p_user_id ;

Line: 82

      select   employee_id
      from   FND_USER
      where   user_id   = p_user_id  ;

Line: 273

   SELECT 1 -- resource_id ,employee_id source_id,full_name resource_name change
   FROM dual ;

Line: 634

                                   aname      =>  'UPDATE_GEN_STATUS' ) ;

Line: 642

        AME_API.updateApprovalStatus2(
                    applicationIdIn    => 242,
                        transactionIdIn    => l_OBJECT_id,
                        approvalStatusIn   => AME_UTIL.approvedStatus,
                        approverPersonIdIn => l_object_approver_id,
                        approverUserIdIn   => NULL,
                        transactionTypeIn  => l_OBJECT_type ) ;

Line: 698

                                aname      =>  'UPDATE_GEN_STATUS',
                                avalue     =>   'APPROVED'  );

Line: 711

                                aname      =>  'UPDATE_GEN_STATUS',
                                avalue     =>   'APPROVED'  );

Line: 1066

                               aname    => 'UPDATE_GEN_STATUS',
                               avalue   => 'ERROR');

Line: 1069

     Update_Status(itemtype      => itemtype,
                   itemkey       => itemkey,
                   actid         => actid,
                   funcmode      => funcmode,
                   resultout     => resultout);

Line: 1208

     SELECT package_name, procedure_name
       FROM amw_OBJECT_rules
      WHERE rule_used_by = rule_used_by_in
        AND object_type = rule_used_by_type_in
        AND rule_type = rule_type_in
   AND nvl(APPROVAL_TYPE, 'N') = nvl(appr_type_in, 'N');

Line: 1713

PROCEDURE Update_Status(itemtype IN varchar2,
                        itemkey  IN varchar2,
                        actid           in  number,
                        funcmode        in  varchar2,
                        resultout       OUT NOCOPY varchar2    )
IS
   l_pkg_name  varchar2(80);

Line: 1744

                 'UPDATE',
                 l_approval_type,
                 l_pkg_name,
                 l_proc_name,
                 l_return_stat);

Line: 1754

END Update_Status;

Line: 1778

PROCEDURE Approved_Update_Status(itemtype IN varchar2,
                        itemkey  IN varchar2,
                        actid           in  number,
                        funcmode        in  varchar2,
                        resultout       OUT NOCOPY varchar2    )
IS
BEGIN
    -- The Object is Approved. Set the item attribute UPDATE_GEN_STATUS to 'APPROVED'
    WF_ENGINE.SetItemAttrText(itemtype   =>  itemtype ,
                             itemkey    =>  itemkey,
                             aname      =>  'UPDATE_GEN_STATUS',
                             avalue     =>   'APPROVED'  );

Line: 1792

   Update_Status(itemtype => itemtype,
                        itemkey => itemkey,
                        actid => actid,
                        funcmode => funcmode,
                        resultout => resultout);

Line: 1798

END Approved_Update_Status;

Line: 1822

PROCEDURE Reject_Update_Status(itemtype IN varchar2,
                        itemkey  IN varchar2,
                        actid           in  number,
                        funcmode        in  varchar2,
                        resultout       OUT NOCOPY varchar2    )
IS

   l_OBJECT_id           NUMBER;

Line: 1845

                       aname      =>  'UPDATE_GEN_STATUS',
                       avalue     =>  'REJECTED');

Line: 1889

   Update_Status(itemtype => itemtype,
                     itemkey => itemkey,
                     actid => actid,
                     funcmode => funcmode,
                     resultout => resultout);

Line: 1934

END Reject_Update_Status;