APPS.UMX_REG_REQUESTS_PVT SQL Statements

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

Line: 12

      select PERSON_PARTY_ID
      from   FND_USER
      where  USER_ID = X_USER_ID
      and    nvl( END_DATE, sysdate+1) > sysdate;

Line: 19

      select URS.REG_SERVICE_TYPE, URS.WF_ROLE_NAME, URS.AME_APPLICATION_ID,
             URS.AME_TRANSACTION_TYPE_ID, URS.REG_FUNCTION_ID, WE.NAME,
             URS.EMAIL_VERIFICATION_FLAG
      from   UMX_REG_SERVICES_B URS, WF_EVENTS WE
      where  URS.REG_SERVICE_CODE = X_REG_SERVICE_CODE
      and    nvl(URS.END_DATE, sysdate+1) > sysdate
      and    URS.WF_NOTIFICATION_EVENT_GUID = WE.GUID;

Line: 29

      select URS.REG_SERVICE_TYPE, URS.REG_SERVICE_CODE, URS.AME_APPLICATION_ID,
             URS.AME_TRANSACTION_TYPE_ID, URS.REG_FUNCTION_ID, WE.NAME,
             URS.EMAIL_VERIFICATION_FLAG
      from   UMX_REG_SERVICES_B URS, WF_EVENTS WE
      where  URS.WF_ROLE_NAME = x_wf_role_name
      and    nvl(URS.END_DATE, sysdate+1) > sysdate
      and    URS.REG_SERVICE_TYPE = 'ADDITIONAL_ACCESS'
      and    URS.WF_NOTIFICATION_EVENT_GUID = WE.GUID;

Line: 147

      SELECT 'Y'
      FROM   fnd_lookup_values
      WHERE  lookup_type = p_lookup_type
        AND  lookup_code = p_column_value
        AND  ROWNUM      = 1;

Line: 213

  procedure update_reg_request (p_reg_request in out NOCOPY REG_REQUEST_TYPE) IS
  BEGIN
    if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
      FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
                      'fnd.plsql.UMXVRRSB.update_reg_request.begin', 'Begin');

Line: 220

    UMX_REG_REQUESTS_PKG.update_row (
                  X_REG_REQUEST_ID => p_reg_request.reg_request_id,
                  X_STATUS_CODE  => p_reg_request.status_code,
                  X_REQUESTED_BY_USER_ID  => fnd_global.user_id,
                  X_REQUESTED_FOR_USER_ID => p_reg_request.requested_for_user_id,
                  X_REQUESTED_FOR_PARTY_ID => p_reg_request.requested_for_party_id,
                  X_REQUESTED_USERNAME  => upper (p_reg_request.requested_username),
                  X_REQUESTED_START_DATE  => p_reg_request.requested_start_date,
                  X_REQUESTED_END_DATE  => p_reg_request.requested_end_date,
                  X_WF_ROLE_NAME    => p_reg_request.wf_role_name,
                  X_REG_SERVICE_CODE  => p_reg_request.reg_service_code,
                  X_AME_APPLICATION_ID => p_reg_request.ame_application_id,
                  X_AME_TRANSACTION_TYPE_ID => p_reg_request.ame_transaction_type_id,
                  X_JUSTIFICATION => p_reg_request.justification
    );

Line: 237

                      'fnd.plsql.UMXVRRSB.update_reg_request.end', 'End');

Line: 240

  END update_reg_request;

Line: 268

  procedure delete_reg_request (
    p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE
  ) is
  BEGIN
    if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
      FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
                      'fnd.plsql.UMXVRRSB.delete_reg_request.begin',
                      'regRequestId: ' || p_reg_request_id);

Line: 278

    UMX_REG_REQUESTS_PKG.DELETE_ROW (X_REG_REQUEST_ID => p_reg_request_id);

Line: 282

                      'fnd.plsql.UMXVRRSB.delete_reg_request.end', 'End');

Line: 285

  END delete_reg_request;

Line: 305

      select user_name
      from   fnd_user
      where  user_name = l_username;

Line: 406

      select requested_by_user_id
      from   umx_reg_requests
      where  reg_request_id = p_reg_request_id;

Line: 474

    UMX_REG_REQUESTS_PKG.update_row (
        X_REG_REQUEST_ID        => p_reg_request_id,
        X_REQUESTED_BY_USER_ID  => l_requested_by_user_id,
        X_REQUESTED_FOR_USER_ID => l_USER_ID,
        X_REQUESTED_USERNAME    => p_username,
        X_STATUS_CODE           => 'PENDING');

Line: 552

    fnd_user_pkg.UpdateUserParty (
        x_user_name        => p_username,
        x_owner            => NULL,
        x_person_party_id  => p_person_party_id);

Line: 558

    UMX_REG_REQUESTS_PKG.update_row (
        X_REG_REQUEST_ID => p_reg_request_id,
        X_STATUS_CODE  => 'APPROVED',
        X_REQUESTED_FOR_PARTY_ID => p_person_party_id);

Line: 610

      select requested_by_user_id
      from   umx_reg_requests
      where  reg_request_id = p_reg_request_id;

Line: 654

    UMX_REG_REQUESTS_PKG.update_row (
        X_REG_REQUEST_ID        => p_reg_request_id,
        X_STATUS_CODE           => p_status_code,
        X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
        X_REQUESTED_BY_USER_ID  => l_requested_by_user_id);

Line: 803

    UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,
                                     X_STATUS_CODE    => p_status_code);

Line: 979

      select ame_application_id, ame_transaction_type_id
      from umx_reg_requests
      where reg_request_id = p_reg_request_id;

Line: 1111

      select reg_request_id, status_code, ame_application_id,
             ame_transaction_type_id, requested_username, justification
      from   umx_reg_requests
      where  requested_for_user_id = p_user_id
      and    requested_username is not null;

Line: 1118

      select status_code, ame_application_id, ame_transaction_type_id, justification
      from   umx_reg_requests
      where  reg_request_id = p_reg_req_id;

Line: 1123

      select user_name
      from   fnd_user
      where  user_id = l_user_id;

Line: 1431

      select * from wf_items
      where parent_item_type = umx_registration_util.g_item_type
      and   parent_item_key  = p_reg_request_id;

Line: 1526

      select reg_request_id
      from   umx_reg_requests
      where  requested_for_user_id = l_user_id;