APPS.UMX_NOTIFICATION_UTIL SQL Statements

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

Line: 246

      select user_name
      from fnd_user where user_id = l_user_id;

Line: 501

      select fu.user_name, fu.email_address, hzp.Person_first_name,
             hzp.Person_last_name, hzp.Person_middle_name, hzp.person_Name_suffix,
             hzp.person_pre_name_adjunct
      from fnd_user fu, hz_parties hzp
      where fu.user_id = p_user_id
      and   hzp.party_id(+) = fu.person_party_id;

Line: 734

  procedure UpdateApprovalStatus (item_type    in  varchar2,
                                  item_key     in  varchar2,
                                  activity_id  in  number,
                                  command      in  varchar2,
                                  resultout    out NOCOPY varchar2) IS

    l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line: 751

                        'fnd.plsql.UMXNTFSB.updateapprovalstatus.begin', 'Begin');

Line: 781

                        'fnd.plsql.UMXNTFSB.updateapprovalstatus',
                        'approver username:'|| l_current_approver.name);

Line: 784

                        'fnd.plsql.UMXNTFSB.updateapprovalstatus',
                        'Before calling ame_api2.updateapprovalstatus (' ||
                        l_ame_application_id || ',' || l_ame_transaction_type_id || ',' ||
                        l_reg_request_id || ',' || l_current_approver.name || ')');

Line: 791

      ame_api2.updateapprovalstatus (applicationIdIn   => l_ame_application_id,
                                     transactionTypeIn => l_ame_transaction_type_id,
                                     transactionIdIn   => l_reg_request_id,
                                     approverIn        => l_current_approver);

Line: 798

                        'fnd.plsql.UMXNTFSB.updateapprovalstatus',
                        'After calling ame_api2.updateapprovalstatus.');

Line: 804

                        'fnd.plsql.UMXNTFSB.updateapprovalstatus.end', 'End');

Line: 811

     Wf_Core.Context ('UMX_NOTIFICATION_UTIL', 'updateApprovalStatus', item_type, item_key);

Line: 814

  END UpdateApprovalStatus;

Line: 816

  procedure UpdateRejectedStatus (item_type   in  varchar2,
                                  item_key    in  varchar2,
                                  activity_id in  number,
                                  command     in  varchar2,
                                  resultout   out NOCOPY varchar2) IS

    l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line: 836

                        'fnd.plsql.UMXNTFSB.updateRejectedStatus.begin', 'Begin');

Line: 865

                        'fnd.plsql.UMXNTFSB.updateRejectedStatus',
                        'approver username:'|| l_current_approver.name);

Line: 868

                        'fnd.plsql.UMXNTFSB.updateRejectedStatus',
                        'Before calling ame_api2.updateapprovalstatus (' ||
                        l_ame_application_id || ',' || l_ame_transaction_type_id || ',' ||
                        l_reg_request_id || ',' || l_current_approver.name || ')');

Line: 875

      ame_api2.updateapprovalstatus (applicationIdIn   => l_ame_application_id,
                                     transactionTypeIn => l_ame_transaction_type_id,
                                     transactionIdIn   => l_reg_request_id,
                                     approverIn        => l_current_approver);

Line: 882

                        'fnd.plsql.UMXNTFSB.updateRejectedStatus',
                        'After calling ame_api2.updateapprovalstatus.');

Line: 904

                        'fnd.plsql.UMXNTFSB.updaterejectedstatus.end', 'End');

Line: 911

      wf_core.context ('UMX_NOTIFICATION_UTIL', 'UpdateRejectedStatus', item_type, item_key);

Line: 913

  END UpdateRejectedStatus;

Line: 954

          select display_name into l_role_display_name
          from wf_all_roles_vl
          where name = l_role_name;