APPS.OKL_LESSEE_AS_VENDOR_PVT SQL Statements

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

Line: 21

  IF (p_mode = G_INSERT_MODE) THEN

    -- column is required:
    IF (p_ppydv_rec.vendor_id IS NULL) OR
       (p_ppydv_rec.vendor_id = OKL_API.G_MISS_NUM)
    THEN
      OKL_API.Set_Message(p_app_name     => G_APP_NAME,
                          p_msg_name     => G_REQUIRED_VALUE,
                          p_token1       => G_COL_NAME_TOKEN,
                          p_token1_value => 'Pay As Vendor');

Line: 34

  ELSIF (p_mode = G_UPDATE_MODE) THEN

    -- column is required:
    IF (p_ppydv_rec.vendor_id IS NULL)
    THEN
      OKL_API.Set_Message(p_app_name     => G_APP_NAME,
                          p_msg_name     => G_REQUIRED_VALUE,
                          p_token1       => G_COL_NAME_TOKEN,
                          p_token1_value => 'Pay As Vendor');

Line: 77

  IF (p_mode = G_INSERT_MODE) THEN

    -- column is required:
    IF (p_ppydv_rec.pay_site_id IS NULL) OR
       (p_ppydv_rec.pay_site_id = OKL_API.G_MISS_NUM)
    THEN
      OKL_API.Set_Message(p_app_name     => G_APP_NAME,
                          p_msg_name     => G_REQUIRED_VALUE,
                          p_token1       => G_COL_NAME_TOKEN,
                          p_token1_value => 'Pay Site');

Line: 90

  ELSIF (p_mode = G_UPDATE_MODE) THEN

    -- column is required:
    IF (p_ppydv_rec.pay_site_id IS NULL)
    THEN
      OKL_API.Set_Message(p_app_name     => G_APP_NAME,
                          p_msg_name     => G_REQUIRED_VALUE,
                          p_token1       => G_COL_NAME_TOKEN,
                          p_token1_value => 'Pay Site');

Line: 133

  IF (p_mode = G_INSERT_MODE) THEN

    -- column is required:
    IF (p_ppydv_rec.payment_term_id IS NULL) OR
       (p_ppydv_rec.payment_term_id = OKL_API.G_MISS_NUM)
    THEN
      OKL_API.Set_Message(p_app_name     => G_APP_NAME,
                          p_msg_name     => G_REQUIRED_VALUE,
                          p_token1       => G_COL_NAME_TOKEN,
                          p_token1_value => 'Payment Term');

Line: 146

  ELSIF (p_mode = G_UPDATE_MODE) THEN

    -- column is required:
    IF (p_ppydv_rec.payment_term_id IS NULL)
    THEN
      OKL_API.Set_Message(p_app_name     => G_APP_NAME,
                          p_msg_name     => G_REQUIRED_VALUE,
                          p_token1       => G_COL_NAME_TOKEN,
                          p_token1_value => 'Payment Term');

Line: 255

select kpr.id
from okc_k_party_roles_b kpr
where kpr.rle_code = 'LESSEE'
and kpr.dnz_chr_id = p_chr_id
;

Line: 292

    l_return_status := validate_header_attributes(lp_ppydv_rec, G_INSERT_MODE);

Line: 301

      okl_pyd_pvt.insert_row(
          p_api_version    => p_api_version,
          p_init_msg_list  => p_init_msg_list,
          x_return_status  => x_return_status,
          x_msg_count      => x_msg_count,
          x_msg_data       => x_msg_data,
          p_ppydv_rec       => lp_ppydv_rec,
          x_ppydv_rec       => x_ppydv_rec);

Line: 365

 PROCEDURE update_lessee_as_vendor(
    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_ppydv_rec                    IN  ppydv_rec_type
   ,x_ppydv_rec                    OUT NOCOPY ppydv_rec_type
 )
is
  l_api_name         CONSTANT VARCHAR2(30) := 'update_lessee_as_vendor';

Line: 384

  SAVEPOINT update_lessee_as_vendor;

Line: 406

    l_return_status := validate_header_attributes(lp_ppydv_rec, G_UPDATE_MODE);

Line: 415

      okl_pyd_pvt.update_row(
          p_api_version    => p_api_version,
          p_init_msg_list  => p_init_msg_list,
          x_return_status  => x_return_status,
          x_msg_count      => x_msg_count,
          x_msg_data       => x_msg_data,
          p_ppydv_rec       => lp_ppydv_rec,
          x_ppydv_rec       => x_ppydv_rec);

Line: 440

    ROLLBACK TO update_lessee_as_vendor;

Line: 447

    ROLLBACK TO update_lessee_as_vendor;

Line: 454

	ROLLBACK TO update_lessee_as_vendor;

Line: 466

end update_lessee_as_vendor;