DBA Data[Home] [Help]

APPS.OKC_ACTIONS_PVT SQL Statements

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

Line: 172

  PROCEDURE UPDATE_ACTIONS(
    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_acnv_rec	            IN acnv_rec_type,
    p_aaev_tbl	            IN aaev_tbl_type,
    x_acnv_rec              OUT NOCOPY acnv_rec_type,
    x_aaev_tbl              OUT NOCOPY aaev_tbl_type) IS

    --l_api_vsersion          CONSTANT NUMBER := 1;
Line: 188

    update_actions(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_acnv_rec,
    x_acnv_rec);
Line: 206

    update_act_atts(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aaev_tbl,
    x_aaev_tbl);
Line: 236

  END UPDATE_ACTIONS;
Line: 310

    okc_acn_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_acnv_rec,
    x_acnv_rec);
Line: 332

    okc_acn_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_acnv_tbl,
    x_acnv_tbl);
Line: 381

  PROCEDURE UPDATE_ACTIONS(
    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_acnv_rec		    IN acnv_rec_type,
    x_acnv_rec              OUT NOCOPY acnv_rec_type) IS
    l_aaev_tbl              OKC_ACTIONS_PUB.aaev_tbl_type;
Line: 399

   SELECT *
   FROM okc_action_attributes_V
   WHERE acn_id = p_acnv_rec.id;
Line: 404

    SELECT application_id INTO l_app_id1
    FROM OKC_ACTIONS_B
    WHERE id = p_acnv_rec.id;
Line: 408

    okc_acn_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_acnv_rec,
    x_acnv_rec);
Line: 419

       l_aaev_tbl.delete;
Line: 420

       v_aaev_tbl.delete;
Line: 461

        l_aaev_tbl(l_cnt).LAST_UPDATED_BY := l_aaev_rec.LAST_UPDATED_BY;
Line: 464

        l_aaev_tbl(l_cnt).LAST_UPDATE_DATE := l_aaev_rec.LAST_UPDATE_DATE;
Line: 465

        l_aaev_tbl(l_cnt).LAST_UPDATE_LOGIN := l_aaev_rec.LAST_UPDATE_LOGIN;
Line: 470

  okc_actions_pub.update_act_atts (
     p_api_version      => l_api_version
    ,p_init_msg_list    => l_init_msg_list
    ,x_return_status    => l_return_status
    ,x_msg_count        => l_msg_count
    ,x_msg_data         => l_msg_data
    ,p_aaev_tbl         => l_aaev_tbl
    ,x_aaev_tbl         => v_aaev_tbl
    );
Line: 482

  END UPDATE_ACTIONS;
Line: 486

  PROCEDURE UPDATE_ACTIONS(
    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_acnv_tbl		    IN acnv_tbl_type,
    x_acnv_tbl              OUT NOCOPY acnv_tbl_type) IS
BEGIN
    okc_acn_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_acnv_tbl,
    x_acnv_tbl);
Line: 503

  END UPDATE_ACTIONS;
Line: 506

  PROCEDURE DELETE_ACTIONS(
    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_acnv_rec		    IN acnv_rec_type) IS

    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 519

    SELECT aae.id
    FROM   okc_action_attributes_v aae
    WHERE  aae.acn_id = p_acnv_rec.id;
Line: 533

      okc_actions_pvt.delete_act_atts(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aaev_tbl);
Line: 550

    okc_acn_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_acnv_rec);
Line: 579

  END DELETE_ACTIONS;
Line: 581

  PROCEDURE DELETE_ACTIONS(
    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_acnv_tbl		    IN acnv_tbl_type) IS
    i                       NUMBER := 0;
Line: 598

           delete_actions(
                          p_api_version
                         ,p_init_msg_list
                         ,x_return_status
                         ,x_msg_count
                         ,x_msg_data
                         ,p_acnv_tbl(i));
Line: 631

  END DELETE_ACTIONS;
Line: 684

   SELECT application_id into l_app_id
   FROM OKC_ACTIONS_B
   WHERE ID = l_aaev_rec.acn_id;
Line: 688

    okc_aae_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_aaev_rec,
    x_aaev_rec);
Line: 708

    okc_aae_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aaev_tbl,
    x_aaev_tbl);
Line: 757

  PROCEDURE UPDATE_ACT_ATTS(
    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_aaev_rec		    IN aaev_rec_type,
    x_aaev_rec              OUT NOCOPY aaev_rec_type) IS
  BEGIN
    okc_aae_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aaev_rec,
    x_aaev_rec);
Line: 775

  END UPDATE_ACT_ATTS;
Line: 777

  PROCEDURE UPDATE_ACT_ATTS(
    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_aaev_tbl		    IN aaev_tbl_type,
    x_aaev_tbl              OUT NOCOPY aaev_tbl_type) IS

  BEGIN
    okc_aae_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aaev_tbl,
    x_aaev_tbl);
Line: 796

  END UPDATE_ACT_ATTS;
Line: 798

  PROCEDURE DELETE_ACT_ATTS(
    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_aaev_rec		    IN aaev_rec_type) IS

  BEGIN
    okc_aae_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aaev_rec);
Line: 815

  END DELETE_ACT_ATTS;
Line: 817

  PROCEDURE DELETE_ACT_ATTS(
    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_aaev_tbl		    IN aaev_tbl_type) IS

  BEGIN
    okc_aae_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aaev_tbl);
Line: 834

  END DELETE_ACT_ATTS;