DBA Data[Home] [Help]

APPS.OKC_LINE_STYLES_PUB SQL Statements

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

Line: 26

    l_lsev_rec.last_updated_by := p_lsev_rec1.last_updated_by;
Line: 27

    l_lsev_rec.last_update_date := p_lsev_rec1.last_update_date;
Line: 28

    l_lsev_rec.last_update_login := p_lsev_rec1.last_update_login;
Line: 211

  PROCEDURE UPDATE_LINE_STYLES(
    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_lsev_rec	            IN lsev_rec_type,
    x_lsev_rec              OUT NOCOPY lsev_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_LINE_STYLES';
Line: 241

    OKC_LINE_STYLES_PVT.UPDATE_LINE_STYLES(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_lsev_rec,
       x_lsev_rec);
Line: 289

  END UPDATE_LINE_STYLES;
Line: 291

  PROCEDURE UPDATE_LINE_STYLES(
    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_lsev_tbl                     IN lsev_tbl_type,
    x_lsev_tbl                     OUT NOCOPY lsev_tbl_type) IS
    i			         NUMBER := 0;
Line: 306

        UPDATE_LINE_STYLES(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_lsev_tbl(i),
	    x_lsev_tbl(i));
Line: 337

  END UPDATE_LINE_STYLES;
Line: 339

  PROCEDURE DELETE_LINE_STYLES(
    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_lsev_rec              IN lsev_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_LINE_STYLES';
Line: 367

    OKC_LINE_STYLES_PVT.DELETE_LINE_STYLES(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_lsev_rec);
Line: 413

  END DELETE_LINE_STYLES;
Line: 415

  PROCEDURE DELETE_LINE_STYLES(
    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_lsev_tbl                     IN lsev_tbl_type) IS
    i			         NUMBER := 0;
Line: 429

        DELETE_LINE_STYLES(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_lsev_tbl(i));
Line: 459

  END DELETE_LINE_STYLES;
Line: 723

    l_lssv_rec.last_updated_by := p_lssv_rec1.last_updated_by;
Line: 724

    l_lssv_rec.last_update_date := p_lssv_rec1.last_update_date;
Line: 725

    l_lssv_rec.last_update_login := p_lssv_rec1.last_update_login;
Line: 883

  PROCEDURE UPDATE_LINE_STYLE_SOURCES(
    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_lssv_rec	            IN lssv_rec_type,
    x_lssv_rec              OUT NOCOPY lssv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_LINE_STYLE_SOURCES';
Line: 913

    OKC_LINE_STYLES_PVT.UPDATE_LINE_STYLE_SOURCES(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_lssv_rec,
       x_lssv_rec);
Line: 961

  END UPDATE_LINE_STYLE_SOURCES;
Line: 963

  PROCEDURE UPDATE_LINE_STYLE_SOURCES(
    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_lssv_tbl                     IN lssv_tbl_type,
    x_lssv_tbl                     OUT NOCOPY lssv_tbl_type) IS
    i			         NUMBER := 0;
Line: 978

        UPDATE_LINE_STYLE_SOURCES(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_lssv_tbl(i),
	    x_lssv_tbl(i));
Line: 1009

  END UPDATE_LINE_STYLE_SOURCES;
Line: 1011

  PROCEDURE DELETE_LINE_STYLE_SOURCES(
    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_lssv_rec              IN lssv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_LINE_STYLE_SOURCES';
Line: 1039

    OKC_LINE_STYLES_PVT.DELETE_LINE_STYLE_SOURCES(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_lssv_rec);
Line: 1085

  END DELETE_LINE_STYLE_SOURCES;
Line: 1087

  PROCEDURE DELETE_LINE_STYLE_SOURCES(
    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_lssv_tbl                     IN lssv_tbl_type) IS
    i			         NUMBER := 0;
Line: 1101

        DELETE_LINE_STYLE_SOURCES(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_lssv_tbl(i));
Line: 1131

  END DELETE_LINE_STYLE_SOURCES;
Line: 1273

    l_vlov_rec.last_updated_by := p_vlov_rec1.last_updated_by;
Line: 1274

    l_vlov_rec.last_update_date := p_vlov_rec1.last_update_date;
Line: 1275

    l_vlov_rec.last_update_login := p_vlov_rec1.last_update_login;
Line: 1407

  PROCEDURE UPDATE_VAL_LINE_OPERATION(
    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_vlov_rec	            IN vlov_rec_type,
    x_vlov_rec              OUT NOCOPY vlov_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_VAL_LINE_OPERATION';
Line: 1437

    OKC_LINE_STYLES_PVT.UPDATE_VAL_LINE_OPERATION(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_vlov_rec,
       x_vlov_rec);
Line: 1485

  END UPDATE_VAL_LINE_OPERATION;
Line: 1487

  PROCEDURE UPDATE_VAL_LINE_OPERATION(
    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_vlov_tbl                     IN vlov_tbl_type,
    x_vlov_tbl                     OUT NOCOPY vlov_tbl_type) IS
    i			         NUMBER := 0;
Line: 1502

        UPDATE_VAL_LINE_OPERATION(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_vlov_tbl(i),
	    x_vlov_tbl(i));
Line: 1533

  END UPDATE_VAL_LINE_OPERATION;
Line: 1535

  PROCEDURE DELETE_VAL_LINE_OPERATION(
    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_vlov_rec              IN vlov_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_VAL_LINE_OPERATION';
Line: 1563

    OKC_LINE_STYLES_PVT.DELETE_VAL_LINE_OPERATION(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_vlov_rec);
Line: 1609

  END DELETE_VAL_LINE_OPERATION;
Line: 1611

  PROCEDURE DELETE_VAL_LINE_OPERATION(
    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_vlov_tbl                     IN vlov_tbl_type) IS
    i			         NUMBER := 0;
Line: 1625

        DELETE_VAL_LINE_OPERATION(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_vlov_tbl(i));
Line: 1655

  END DELETE_VAL_LINE_OPERATION;