DBA Data[Home] [Help]

APPS.OKC_LINE_STYLES_PVT SQL Statements

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

Line: 36

	 select id, priced_yn from okc_line_styles_b
	 Connect by prior id = lse_parent_id
	 start with id = p_id;
Line: 46

				 OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_lsev_rec,
                                 lx_lsev_rec);
Line: 85

	 select id, priced_yn from okc_line_styles_b
	 connect by prior lse_parent_id = id
	 start with id = p_id;
Line: 95

				 OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_lsev_rec,
                                 lx_lsev_rec);
Line: 136

         select id, item_to_price_yn from okc_line_styles_b
         Connect by prior id = lse_parent_id
         start with id = p_id;
Line: 146

                                 OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_lsev_rec,
                                 lx_lsev_rec);
Line: 186

         select id, item_to_price_yn from okc_line_styles_b
         connect by prior lse_parent_id = id
         start with id = p_id;
Line: 196

                                 OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_lsev_rec,
                                 lx_lsev_rec);
Line: 235

         select id, price_basis_yn from okc_line_styles_b
         Connect by prior id = lse_parent_id
         start with id = p_id;
Line: 245

                                 OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_lsev_rec,
                                 lx_lsev_rec);
Line: 285

         select id, price_basis_yn from okc_line_styles_b
         connect by prior lse_parent_id = id
         start with id = p_id;
Line: 295

                                 OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_lsev_rec,
                                 lx_lsev_rec);
Line: 329

	 select OKC_API.G_RET_STS_ERROR from okc_k_lines_b where lse_id=p_id;
Line: 355

	 select OKC_API.G_RET_STS_ERROR from okc_line_style_roles where lse_id=p_id;
Line: 357

	 select OKC_API.G_RET_STS_ERROR from okc_lse_rule_groups where lse_id=p_id;
Line: 359

	 select OKC_API.G_RET_STS_ERROR from okc_subclass_top_line where lse_id=p_id;
Line: 403

	 select OKC_API.G_RET_STS_ERROR from okc_line_style_sources where lse_id=p_id;
Line: 405

	 select OKC_API.G_RET_STS_ERROR from okc_val_line_operations where lse_id=p_id;
Line: 438

PROCEDURE DELETE_SUB_LINES(
    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_return_status               VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
Line: 449

	 select id from okc_line_styles_b where lse_parent_id=p_id;
Line: 454

				 OKC_LINE_STYLES_PUB.DELETE_LINE_STYLES(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_lsev_rec);
Line: 475

 END DELETE_SUB_LINES;
Line: 478

PROCEDURE DELETE_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_lsev_rec		        IN lsev_rec_type) IS

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

	 select lse_id,jtot_object_code from okc_line_style_sources where lse_id=p_id;
Line: 495

				 OKC_LINE_STYLES_PUB.DELETE_LINE_STYLE_SOURCES(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_lssv_rec);
Line: 516

 END DELETE_SOURCES;
Line: 519

PROCEDURE DELETE_VAL_OPS(
    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_return_status               VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
Line: 530

	 select lse_id from okc_val_line_operations where lse_id=p_id;
Line: 535

				 OKC_LINE_STYLES_PUB.DELETE_VAL_LINE_OPERATION(
                                 p_api_version,
                                 p_init_msg_list,
                                 x_return_status,
                                 x_msg_count,
                                 x_msg_data,
                                 l_vlov_rec);
Line: 556

 END DELETE_VAL_OPS;
Line: 568

    okc_lse_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_lsev_rec,
    x_lsev_rec);
Line: 622

  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_excp_error            EXCEPTION;
Line: 642

             DELETE_SOURCES(
                 p_api_version,
                 p_init_msg_list,
                 x_return_status,
                 x_msg_count,
                 x_msg_data,
                 p_lsev_rec);
Line: 656

    okc_lse_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_lsev_rec,
    x_lsev_rec);
Line: 673

		--If the updated line has priced_yn set to 'Y' then set its parent's to 'N'
          CHANGE_PRICED_FOR_PARENT(
                        p_api_version,
                        p_init_msg_list,
                        x_return_status,
                        x_msg_count,
                        x_msg_data,
                        x_lsev_rec);
Line: 733

END UPDATE_LINE_STYLES;
Line: 735

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_excp_error            EXCEPTION;
Line: 758

    DELETE_SUB_LINES(
                 p_api_version,
                 p_init_msg_list,
                 x_return_status,
                 x_msg_count,
                 x_msg_data,
                 p_lsev_rec);
Line: 769

    DELETE_VAL_OPS(
                 p_api_version,
                 p_init_msg_list,
                 x_return_status,
                 x_msg_count,
                 x_msg_data,
                 p_lsev_rec);
Line: 781

    DELETE_SOURCES(
                 p_api_version,
                 p_init_msg_list,
                 x_return_status,
                 x_msg_count,
                 x_msg_data,
                 p_lsev_rec);
Line: 793

    okc_lse_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_lsev_rec);
Line: 813

END DELETE_LINE_STYLES;
Line: 862

    okc_lss_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_lssv_rec,
    x_lssv_rec);
Line: 872

  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
  BEGIN
    okc_lss_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_lssv_rec,
    x_lssv_rec);
Line: 889

  END UPDATE_LINE_STYLE_SOURCES;
Line: 891

  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
  BEGIN
    okc_lss_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_lssv_rec);
Line: 906

  END DELETE_LINE_STYLE_SOURCES;
Line: 958

    okc_vlo_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_vlov_rec,
    x_vlov_rec);
Line: 968

  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
  BEGIN
    okc_vlo_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_vlov_rec,
    x_vlov_rec);
Line: 985

  END UPDATE_VAL_LINE_OPERATION;
Line: 987

  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
  BEGIN
    okc_vlo_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_vlov_rec);
Line: 1002

  END DELETE_VAL_LINE_OPERATION;