APPS.OKC_K_REL_OBJS_PUB SQL Statements

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

Line: 165

/* loop in pvt insert does not check every record for status so do rows individually as above
		OKC_K_REL_OBJS_PUB.create_row
			(
			p_api_version		=>	l_api_version
			,p_init_msg_list	=>	OKC_API.G_FALSE
--			,x_return_status	=>	l_return_status
			,x_return_status	=>	x_return_status
			,x_msg_count		=>	x_msg_count
			,x_msg_data		=>	x_msg_data
			,p_crjv_tbl		=>	l_crjv_tbl
			,x_crjv_tbl		=>	l_x_crjv_tbl
			);

Line: 2046

		OKC_CRJ_PVT.insert_row
			(
			p_api_version		=> 1
			,p_init_msg_list	=> OKC_API.G_FALSE
			,x_return_status	=> x_return_status
			,x_msg_count		=> x_msg_count
			,x_msg_data		=> x_msg_data
			,p_crjv_rec		=> p_crjv_rec
			,x_crjv_rec		=> x_crjv_rec
			)
		;

Line: 2133

		OKC_CRJ_PVT.insert_row
			(
			p_api_version		=> 1
			,p_init_msg_list	=> OKC_API.G_FALSE
			,x_return_status	=> x_return_status
			,x_msg_count		=> x_msg_count
			,x_msg_data		=> x_msg_data
			,p_crjv_tbl		=> p_crjv_tbl
			,x_crjv_tbl		=> x_crjv_tbl
			)
		;

Line: 2344

  PROCEDURE update_row(
    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_crjv_rec                     IN crjv_rec_type,
    x_crjv_rec                     OUT NOCOPY crjv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2354

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 2373

	/* update_row
	*/
	OKC_CRJ_PVT.update_row
		(
		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_crjv_rec		=> p_crjv_rec
		,x_crjv_rec		=> x_crjv_rec
		);

Line: 2422

  END update_row;

Line: 2426

  PROCEDURE update_row(
    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_crjv_tbl                     IN crjv_tbl_type,
    x_crjv_tbl                     OUT NOCOPY crjv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2436

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 2452

	/* update_rows
	*/
	OKC_CRJ_PVT.update_row
		(
		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_crjv_tbl		=> p_crjv_tbl
		,x_crjv_tbl		=> x_crjv_tbl
		);

Line: 2501

  END update_row;

Line: 2506

  PROCEDURE delete_row(
    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_crjv_rec                     IN crjv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2515

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 2532

	/* delete_row
	*/
	OKC_CRJ_PVT.delete_row
		(
		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_crjv_rec		=> p_crjv_rec
		);

Line: 2580

  END delete_row;

Line: 2584

  PROCEDURE delete_row(
    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_crjv_tbl                     IN crjv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2593

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 2609

	/* delete_rows
	*/
	OKC_CRJ_PVT.delete_row
		(
		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_crjv_tbl		=> p_crjv_tbl
		);

Line: 2657

  END delete_row;