APPS.OKL_AM_SHIPPING_INSTR_PVT SQL Statements

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

Line: 29

      SELECT  KLE.chr_id      khr_id,
              KLE.id          kle_id,
              ART.floor_price floor_price
      FROM    OKL_K_LINES_FULL_V    KLE,
              OKL_ASSET_RETURNS_V   ART
      WHERE   ART.id = p_art_id
      AND     ART.kle_id = KLE.id;

Line: 40

     select   CPLB.OBJECT1_ID1,
              CPLB.JTOT_OBJECT1_CODE
     from     OKC_K_PARTY_ROLES_B CPLB
     where    CPLB.RLE_CODE = 'LESSEE'
     and      CPLB.DNZ_CHR_ID = CPLB.CHR_ID
     and      CPLB.DNZ_CHR_ID = p_khr_id;

Line: 93

    SELECT SYSDATE INTO l_sysdate FROM DUAL;

Line: 205

    OKL_RELOCATE_ASSETS_PUB.insert_relocate_assets(
             p_api_version                  => p_api_version,
             p_init_msg_list                => OKL_API.G_FALSE,
             x_return_status                => l_return_status,
             x_msg_count                    => x_msg_count,
             x_msg_data                     => x_msg_data,
             p_rasv_rec                     => lp_rasv_rec,
             x_rasv_rec                     => lx_rasv_rec);

Line: 366

  PROCEDURE update_shipping_instr(
    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_rasv_rec                      IN rasv_rec_type,
    x_rasv_rec                      OUT NOCOPY rasv_rec_type) AS

    lp_rasv_rec                      rasv_rec_type := p_rasv_rec;

Line: 433

    OKL_RELOCATE_ASSETS_PUB.update_relocate_assets(
             p_api_version                  => p_api_version,
             p_init_msg_list                => OKL_API.G_FALSE,
             x_return_status                => l_return_status,
             x_msg_count                    => x_msg_count,
             x_msg_data                     => x_msg_data,
             p_rasv_rec                     => lp_rasv_rec,
             x_rasv_rec                     => lx_rasv_rec);

Line: 486

  END update_shipping_instr;

Line: 498

  PROCEDURE update_shipping_instr(
    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_rasv_tbl                      IN rasv_tbl_type,
    x_rasv_tbl                      OUT NOCOPY rasv_tbl_type) AS

    l_return_status                VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line: 518

        update_shipping_instr(
          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_rasv_rec                     => p_rasv_tbl(i),
          x_rasv_rec                     => x_rasv_tbl(i));

Line: 571

  END update_shipping_instr;

Line: 619

      SELECT SYSDATE INTO lp_rasv_rec.date_shipping_instructions_sen FROM DUAL;

Line: 624

    update_shipping_instr(
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => l_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_rasv_rec                     => lp_rasv_rec,
          x_rasv_rec                     => lx_rasv_rec);