DBA Data[Home] [Help]

APPS.OKC_ACTIONS_PUB SQL Statements

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

Line: 17

    l_acnv_rec.last_updated_by       := p_acnv_rec1.last_updated_by;
Line: 18

    l_acnv_rec.last_update_date      := p_acnv_rec1.last_update_date;
Line: 19

    l_acnv_rec.last_update_login     := p_acnv_rec1.last_update_login;
Line: 61

    l_aaev_rec.last_updated_by       := p_aaev_rec1.last_updated_by;
Line: 62

    l_aaev_rec.last_update_date      := p_aaev_rec1.last_update_date;
Line: 63

    l_aaev_rec.last_update_login     := p_aaev_rec1.last_update_login;
Line: 250

  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_name            CONSTANT VARCHAR2(30) := 'update_actions';
Line: 277

       okc_actions_pvt.update_actions(p_api_version
                                     ,p_init_msg_list
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data
                                     ,p_acnv_rec
                                     ,p_aaev_tbl
                                     ,x_acnv_rec
                                     ,x_aaev_tbl);
Line: 319

    END update_actions;
Line: 662

  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

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

            update_actions(
                         p_api_version
                        ,p_init_msg_list
                        ,l_return_status
                        ,x_msg_count
                        ,x_msg_data
                        ,p_acnv_tbl(i)
                        ,x_acnv_tbl(i));
Line: 714

    END update_actions;
Line: 716

  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_api_name            CONSTANT VARCHAR2(30) := 'update_actions';
Line: 755

       okc_actions_pvt.update_actions(p_api_version
                                     ,p_init_msg_list
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data
                                     ,l_acnv_rec
                                     ,x_acnv_rec);
Line: 811

    END update_actions;
Line: 813

  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

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

            delete_actions(
                           p_api_version
                          ,p_init_msg_list
                          ,l_return_status
                          ,x_msg_count
                          ,x_msg_data
                          ,p_acnv_tbl(i));
Line: 863

    END delete_actions;
Line: 865

  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_api_name            CONSTANT VARCHAR2(30) := 'delete_actions';
Line: 903

       okc_actions_pvt.delete_actions(p_api_version
                                     ,p_init_msg_list
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data
                                     ,l_acnv_rec);
Line: 958

    END delete_actions;
Line: 1379

  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
    l_return_status       VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1397

            update_act_atts(
                            p_api_version
                           ,p_init_msg_list
                           ,l_return_status
                           ,x_msg_count
                           ,x_msg_data
                           ,p_aaev_tbl(i)
                           ,x_aaev_tbl(i));
Line: 1430

    END update_act_atts;
Line: 1432

  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

    l_api_name            CONSTANT VARCHAR2(30) := 'update_act_atts';
Line: 1471

       okc_actions_pvt.update_act_atts(p_api_version
                                      ,p_init_msg_list
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data
                                      ,l_aaev_rec
                                      ,x_aaev_rec);
Line: 1527

    END update_act_atts;
Line: 1529

  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

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

            delete_act_atts(
                            p_api_version
                           ,p_init_msg_list
                           ,l_return_status
                           ,x_msg_count
                           ,x_msg_data
                           ,p_aaev_tbl(i));
Line: 1579

    END delete_act_atts;
Line: 1581

  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

    l_api_name            CONSTANT VARCHAR2(30) := 'delete_act_atts';
Line: 1619

       okc_actions_pvt.delete_act_atts(p_api_version
                                      ,p_init_msg_list
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data
                                      ,l_aaev_rec);
Line: 1674

    END delete_act_atts;