DBA Data[Home] [Help]

APPS.OKS_BRL_PVT SQL Statements

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

Line: 102

    SELECT
            BATCH_ID,
            BATCH_TYPE,
            BATCH_SOURCE,
            TRANSACTION_DATE,
            CREDIT_OPTION,
            TERMINATION_REASON_CODE,
            BILLING_PROFILE_ID,
            RETAIN_CONTRACT_NUMBER_FLAG,
            CONTRACT_MODIFIER,
            CONTRACT_STATUS,
            TRANSFER_NOTES_FLAG,
            TRANSFER_ATTACHMENTS_FLAG,
            BILL_LINES_FLAG,
            TRANSFER_OPTION_CODE,
            BILL_ACCOUNT_ID,
            SHIP_ACCOUNT_ID,
            BILL_ADDRESS_ID,
            SHIP_ADDRESS_ID,
            BILL_CONTACT_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            SECURITY_GROUP_ID,
            OBJECT_VERSION_NUMBER,
            REQUEST_ID
      FROM Oks_Batch_Rules_V
     WHERE oks_batch_rules_v.batch_id = p_batch_id;
Line: 160

              l_oks_batch_rules_v_rec.last_updated_by,
              l_oks_batch_rules_v_rec.last_update_date,
              l_oks_batch_rules_v_rec.last_update_login,
              l_oks_batch_rules_v_rec.security_group_id,
              l_oks_batch_rules_v_rec.object_version_number,
              l_oks_batch_rules_v_rec.request_id;
Line: 207

    SELECT
            BATCH_ID,
            BATCH_TYPE,
            BATCH_SOURCE,
            TRANSACTION_DATE,
            CREDIT_OPTION,
            TERMINATION_REASON_CODE,
            BILLING_PROFILE_ID,
            RETAIN_CONTRACT_NUMBER_FLAG,
            CONTRACT_MODIFIER,
            CONTRACT_STATUS,
            TRANSFER_NOTES_FLAG,
            TRANSFER_ATTACHMENTS_FLAG,
            BILL_LINES_FLAG,
            TRANSFER_OPTION_CODE,
            BILL_ACCOUNT_ID,
            SHIP_ACCOUNT_ID,
            BILL_ADDRESS_ID,
            SHIP_ADDRESS_ID,
            BILL_CONTACT_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            OBJECT_VERSION_NUMBER,
            REQUEST_ID
      FROM Oks_Batch_Rules
     WHERE oks_batch_rules.batch_id = p_batch_id;
Line: 264

              l_obtr_rec.last_updated_by,
              l_obtr_rec.last_update_date,
              l_obtr_rec.last_update_login,
              l_obtr_rec.object_version_number,
              l_obtr_rec.request_id;
Line: 373

    IF (l_oks_batch_rules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_oks_batch_rules_v_rec.last_updated_by := NULL;
Line: 376

    IF (l_oks_batch_rules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_oks_batch_rules_v_rec.last_update_date := NULL;
Line: 379

    IF (l_oks_batch_rules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_oks_batch_rules_v_rec.last_update_login := NULL;
Line: 467

  		select 'x'
		from FND_LOOKUPS
		where lookup_code = p_credit_option
                and lookup_type = 'OKS_CREDIT_AMOUNT'
		and sysdate between nvl(start_date_active,sysdate)
					 and nvl(end_date_active,sysdate)
                and enabled_flag = 'Y';
Line: 583

  		select 'x'
		from FND_LOOKUPS
		where lookup_code = p_termination_reason_code
                and lookup_type = 'OKC_TERMINATION_REASON'
		and sysdate between nvl(start_date_active,sysdate)
					 and nvl(end_date_active,sysdate)
                and enabled_flag = 'Y';
Line: 701

  		select 'x'
		from FND_LOOKUPS
		where lookup_code = p_transfer_option_code
                and lookup_type = 'OKS_TRANSFER_RULES'
		and sysdate between nvl(start_date_active,sysdate)
					 and nvl(end_date_active,sysdate)
                and enabled_flag = 'Y';
Line: 930

    p_to.last_updated_by := p_from.last_updated_by;
Line: 931

    p_to.last_update_date := p_from.last_update_date;
Line: 932

    p_to.last_update_login := p_from.last_update_login;
Line: 961

    p_to.last_updated_by := p_from.last_updated_by;
Line: 962

    p_to.last_update_date := p_from.last_update_date;
Line: 963

    p_to.last_update_login := p_from.last_update_login;
Line: 1211

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_obtr_rec                     IN obtr_rec_type,
    x_obtr_rec                     OUT NOCOPY obtr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1220

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';
Line: 1256

    INSERT INTO OKS_BATCH_RULES(
      batch_id,
      batch_type,
      batch_source,
      transaction_date,
      credit_option,
      termination_reason_code,
      billing_profile_id,
      retain_contract_number_flag,
      contract_modifier,
      contract_status,
      transfer_notes_flag,
      transfer_attachments_flag,
      bill_lines_flag,
      transfer_option_code,
      bill_account_id,
      ship_account_id,
      bill_address_id,
      ship_address_id,
      bill_contact_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      object_version_number,
      request_id)
    VALUES (
      l_obtr_rec.batch_id,
      l_obtr_rec.batch_type,
      l_obtr_rec.batch_source,
      l_obtr_rec.transaction_date,
      l_obtr_rec.credit_option,
      l_obtr_rec.termination_reason_code,
      l_obtr_rec.billing_profile_id,
      l_obtr_rec.retain_contract_number_flag,
      l_obtr_rec.contract_modifier,
      l_obtr_rec.contract_status,
      l_obtr_rec.transfer_notes_flag,
      l_obtr_rec.transfer_attachments_flag,
      l_obtr_rec.bill_lines_flag,
      l_obtr_rec.transfer_option_code,
      l_obtr_rec.bill_account_id,
      l_obtr_rec.ship_account_id,
      l_obtr_rec.bill_address_id,
      l_obtr_rec.ship_address_id,
      l_obtr_rec.bill_contact_id,
      l_obtr_rec.created_by,
      l_obtr_rec.creation_date,
      l_obtr_rec.last_updated_by,
      l_obtr_rec.last_update_date,
      l_obtr_rec.last_update_login,
      l_obtr_rec.object_version_number,
      l_obtr_rec.request_id);
Line: 1345

  END insert_row;
Line: 1349

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_rec        IN oks_batch_rules_v_rec_type,
    x_oks_batch_rules_v_rec        OUT NOCOPY oks_batch_rules_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1359

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 1375

      l_oks_batch_rules_v_rec.LAST_UPDATE_DATE := l_oks_batch_rules_v_rec.CREATION_DATE;
Line: 1376

      l_oks_batch_rules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1377

      l_oks_batch_rules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1441

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_obtr_rec,
      lx_obtr_rec
    );
Line: 1490

  END insert_row;
Line: 1494

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_tbl        IN oks_batch_rules_v_tbl_type,
    x_oks_batch_rules_v_tbl        OUT NOCOPY oks_batch_rules_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1505

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 1519

          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_oks_batch_rules_v_rec        => p_oks_batch_rules_v_tbl(i),
            x_oks_batch_rules_v_rec        => x_oks_batch_rules_v_tbl(i));
Line: 1587

  END insert_row;
Line: 1594

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_tbl        IN oks_batch_rules_v_tbl_type,
    x_oks_batch_rules_v_tbl        OUT NOCOPY oks_batch_rules_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1604

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 1611

      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_oks_batch_rules_v_tbl        => p_oks_batch_rules_v_tbl,
        x_oks_batch_rules_v_tbl        => x_oks_batch_rules_v_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1653

  END insert_row;
Line: 1671

    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BATCH_RULES
     WHERE BATCH_ID = p_obtr_rec.batch_id
       AND OBJECT_VERSION_NUMBER = p_obtr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1678

    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BATCH_RULES
     WHERE BATCH_ID = p_obtr_rec.batch_id;
Line: 1719

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1728

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 2008

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_obtr_rec                     IN obtr_rec_type,
    x_obtr_rec                     OUT NOCOPY obtr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2017

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';
Line: 2121

        IF (x_obtr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_obtr_rec.last_updated_by := l_obtr_rec.last_updated_by;
Line: 2125

        IF (x_obtr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_obtr_rec.last_update_date := l_obtr_rec.last_update_date;
Line: 2129

        IF (x_obtr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_obtr_rec.last_update_login := l_obtr_rec.last_update_login;
Line: 2183

    UPDATE OKS_BATCH_RULES
    SET BATCH_TYPE = l_def_obtr_rec.batch_type,
        BATCH_SOURCE = l_def_obtr_rec.batch_source,
        TRANSACTION_DATE = l_def_obtr_rec.transaction_date,
        CREDIT_OPTION = l_def_obtr_rec.credit_option,
        TERMINATION_REASON_CODE = l_def_obtr_rec.termination_reason_code,
        BILLING_PROFILE_ID = l_def_obtr_rec.billing_profile_id,
        RETAIN_CONTRACT_NUMBER_FLAG = l_def_obtr_rec.retain_contract_number_flag,
        CONTRACT_MODIFIER = l_def_obtr_rec.contract_modifier,
        CONTRACT_STATUS = l_def_obtr_rec.contract_status,
        TRANSFER_NOTES_FLAG = l_def_obtr_rec.transfer_notes_flag,
        TRANSFER_ATTACHMENTS_FLAG = l_def_obtr_rec.transfer_attachments_flag,
        BILL_LINES_FLAG = l_def_obtr_rec.bill_lines_flag,
        TRANSFER_OPTION_CODE = l_def_obtr_rec.transfer_option_code,
        BILL_ACCOUNT_ID = l_def_obtr_rec.bill_account_id,
        SHIP_ACCOUNT_ID = l_def_obtr_rec.ship_account_id,
        BILL_ADDRESS_ID = l_def_obtr_rec.bill_address_id,
        SHIP_ADDRESS_ID = l_def_obtr_rec.ship_address_id,
        BILL_CONTACT_ID = l_def_obtr_rec.bill_contact_id,
        CREATED_BY = l_def_obtr_rec.created_by,
        CREATION_DATE = l_def_obtr_rec.creation_date,
        LAST_UPDATED_BY = l_def_obtr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_obtr_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_obtr_rec.last_update_login,
        OBJECT_VERSION_NUMBER = l_def_obtr_rec.object_version_number,
        REQUEST_ID = l_def_obtr_rec.request_id
    WHERE BATCH_ID = l_def_obtr_rec.batch_id;
Line: 2245

  END update_row;
Line: 2249

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_rec        IN oks_batch_rules_v_rec_type,
    x_oks_batch_rules_v_rec        OUT NOCOPY oks_batch_rules_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2259

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 2274

      l_oks_batch_rules_v_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2275

      l_oks_batch_rules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2276

      l_oks_batch_rules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2379

        IF (x_oks_batch_rules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_batch_rules_v_rec.last_updated_by := l_db_oks_batch_rules_v_rec.last_updated_by;
Line: 2383

        IF (x_oks_batch_rules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_batch_rules_v_rec.last_update_date := l_db_oks_batch_rules_v_rec.last_update_date;
Line: 2387

        IF (x_oks_batch_rules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_batch_rules_v_rec.last_update_login := l_db_oks_batch_rules_v_rec.last_update_login;
Line: 2480

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_obtr_rec,
      lx_obtr_rec
    );
Line: 2528

  END update_row;
Line: 2532

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_tbl        IN oks_batch_rules_v_tbl_type,
    x_oks_batch_rules_v_tbl        OUT NOCOPY oks_batch_rules_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2543

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 2557

          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_oks_batch_rules_v_rec        => p_oks_batch_rules_v_tbl(i),
            x_oks_batch_rules_v_rec        => x_oks_batch_rules_v_tbl(i));
Line: 2625

  END update_row;
Line: 2632

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_tbl        IN oks_batch_rules_v_tbl_type,
    x_oks_batch_rules_v_tbl        OUT NOCOPY oks_batch_rules_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2642

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 2649

      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_oks_batch_rules_v_tbl        => p_oks_batch_rules_v_tbl,
        x_oks_batch_rules_v_tbl        => x_oks_batch_rules_v_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2691

  END update_row;
Line: 2699

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_obtr_rec                     IN obtr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2707

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';
Line: 2722

    DELETE FROM OKS_BATCH_RULES
     WHERE BATCH_ID = p_obtr_rec.batch_id;
Line: 2758

  END delete_row;
Line: 2762

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_rec        IN oks_batch_rules_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2771

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 2795

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_obtr_rec
    );
Line: 2840

  END delete_row;
Line: 2844

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_tbl        IN oks_batch_rules_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2854

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 2868

          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_oks_batch_rules_v_rec        => p_oks_batch_rules_v_tbl(i));
Line: 2935

  END delete_row;
Line: 2940

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_oks_batch_rules_v_tbl        IN oks_batch_rules_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2949

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 2956

      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_oks_batch_rules_v_tbl        => p_oks_batch_rules_v_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2997

  END delete_row;