APPS.UMX_REGISTRATION_UTIL SQL Statements

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

Line: 82

      select user_name
      from fnd_user
      where user_id = l_requested_by_user_id
      and  nvl (start_date, SYSDATE) <= SYSDATE
      and nvl (end_date, SYSDATE + 1) > SYSDATE ;

Line: 213

      select user_name
      from fnd_user
      where user_id = p_user_id;

Line: 294

        UMX_REG_REQUESTS_PKG.UPDATE_ROW (X_REG_REQUEST_ID => to_number (item_key),
                                         X_STATUS_CODE => 'APPROVED');

Line: 465

        UMX_REG_REQUESTS_PKG.update_row (
                             X_REG_REQUEST_ID => item_key,
                             X_STATUS_CODE => 'VERIFYING');

Line: 688

      UMX_REG_REQUESTS_PKG.insert_row (
        x_reg_request_id   => l_reg_request_id ,
        x_reg_service_type => l_reg_service_type,
        x_status_code => l_request_status_code,
        x_requested_by_user_id => l_requested_by_user_id,
        x_requested_for_user_id => l_requested_for_user_id,
        x_requested_for_party_id => l_requested_for_party_id,
        x_requested_username => l_requested_username,
        x_requested_start_date => nvl (l_requested_start_date,sysdate),
        x_requested_end_date => l_requested_end_date,
        x_wf_role_name => l_wf_role_name,
        x_reg_service_code => l_reg_service_code,
        x_ame_application_id => l_ame_application_id,
        x_ame_transaction_type_id => l_ame_transaction_type_id,
        x_justification => l_justification);

Line: 1072

        select UMX_EVENTS_S.nextval into l_temp_event_key from dual;

Line: 1074

        select UMX_REG_REQUESTS_S.nextval into l_temp_event_key from dual;

Line: 1254

  procedure update_reg_request (p_item_type    in  varchar2,
                                p_item_key     in  varchar2,
                                p_activity_id  in  number,
                                p_command      in  varchar2,
                                p_resultout    out NOCOPY varchar2) is

    CURSOR getRegRequest (p_reg_request_id in number) is

      select  STATUS_CODE
      from   UMX_REG_REQUESTS
      where  REG_REQUEST_ID = p_reg_request_id;

Line: 1276

                'fnd.plsql.UMXUTILB.updateregrequest.begin',
                'itemkey: '||p_item_key);

Line: 1303

        raise_application_error ('-20000','Invalid reg_request_id in update regrequest');

Line: 1383

        UMX_REG_REQUESTS_PVT.update_reg_request (p_reg_request => l_reg_request);

Line: 1391

                'fnd.plsql.UMXUTILB.updateregrequests.end',
                'itemkey: '||p_item_key);

Line: 1397

      Wf_Core.Context ('UMX_REGISTRATION_UTIL', 'Update_Reg_request', p_item_type, p_item_key);

Line: 1400

  END update_reg_request;

Line: 1433

        select UMX_EVENTS_S.nextval into l_event_key from dual;

Line: 1491

      select UMX_EVENTS_S.nextval into l_event_key from dual;

Line: 1686

          select user_name into l_user_name
          from fnd_user
          where user_id = l_requested_for_user_id;

Line: 1884

procedure update_user_status (p_item_type    in  varchar2,
                                 p_item_key     in  varchar2,
                                 p_activity_id  in  number,
                                 p_command      in  varchar2,
                                 p_resultout    out NOCOPY varchar2) is
    l_userid FND_USER.user_id%type;

Line: 1894

                'fnd.plsql.UMXUTILB.updateuserstatus.begin',
                'itemkey: '||p_item_key);

Line: 1906

      UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => to_number (p_item_key),
                                        X_STATUS_CODE => 'PENDING');

Line: 1913

                'fnd.plsql.UMXUTILB.updateuserstatus.end',
                'itemkey: '||p_item_key);

Line: 1917

 End update_user_status;

Line: 1977

          select UMX_EVENTS_S.nextval into l_event_key from dual;