DBA Data[Home] [Help]

APPS.OKC_OPER_INST_PUB SQL Statements

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

Line: 223

  PROCEDURE Update_Class_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_copv_rec                     IN copv_rec_type,
    x_copv_rec                     OUT NOCOPY copv_rec_type) IS

    l_copv_rec		copv_rec_type;
Line: 233

    l_api_name		CONSTANT VARCHAR2(30) := 'Update_Class_Operation';
Line: 277

    OKC_OPER_INST_PVT.Update_Class_Operation(
	 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_copv_rec			=> l_copv_rec,
      x_copv_rec			=> x_copv_rec);
Line: 339

  END Update_Class_Operation;
Line: 341

  PROCEDURE Update_Class_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_copv_tbl                     IN copv_tbl_type,
    x_copv_tbl                     OUT NOCOPY copv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Update_Class_Operation';
Line: 378

		OKC_OPER_INST_PUB.Update_Class_Operation(
			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_copv_rec		=> p_copv_tbl(i),
			x_copv_rec		=> x_copv_tbl(i));
Line: 437

  END Update_Class_Operation;
Line: 439

  PROCEDURE Delete_Class_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_copv_rec                     IN copv_rec_type) IS

    l_copv_rec		copv_rec_type;
Line: 448

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Class_Operation';
Line: 492

    OKC_OPER_INST_PVT.Delete_Class_Operation(
	 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_copv_rec		=> l_copv_rec);
Line: 550

  END Delete_Class_Operation;
Line: 552

  PROCEDURE Delete_Class_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_copv_tbl                     IN copv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Class_Operation';
Line: 588

		OKC_OPER_INST_PUB.Delete_Class_Operation(
			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_copv_rec		=> p_copv_tbl(i));
Line: 646

  END Delete_Class_Operation;
Line: 1282

  PROCEDURE Update_Operation_Instance(
    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_oiev_rec                     IN oiev_rec_type,
    x_oiev_rec                     OUT NOCOPY oiev_rec_type) IS

    l_oiev_rec		oiev_rec_type;
Line: 1292

    l_api_name		CONSTANT VARCHAR2(30) := 'Update_Operation_Instance';
Line: 1336

    OKC_OPER_INST_PVT.Update_Operation_Instance(
	 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_oiev_rec			=> l_oiev_rec,
      x_oiev_rec			=> x_oiev_rec);
Line: 1398

  END Update_Operation_Instance;
Line: 1400

  PROCEDURE Update_Operation_Instance(
    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_oiev_tbl                     IN oiev_tbl_type,
    x_oiev_tbl                     OUT NOCOPY oiev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Update_Operation_Instance';
Line: 1437

		OKC_OPER_INST_PUB.Update_Operation_Instance(
			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_oiev_rec		=> p_oiev_tbl(i),
			x_oiev_rec		=> x_oiev_tbl(i));
Line: 1496

  END Update_Operation_Instance;
Line: 1498

  PROCEDURE Delete_Operation_Instance(
    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_oiev_rec                     IN oiev_rec_type) IS

    l_oiev_rec		oiev_rec_type;
Line: 1507

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Operation_Instance';
Line: 1551

    OKC_OPER_INST_PVT.Delete_Operation_Instance(
	 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_oiev_rec		=> l_oiev_rec);
Line: 1609

  END Delete_Operation_Instance;
Line: 1611

  PROCEDURE Delete_Operation_Instance(
    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_oiev_tbl                     IN oiev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Operation_Instance';
Line: 1647

		OKC_OPER_INST_PUB.Delete_Operation_Instance(
			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_oiev_rec		=> p_oiev_tbl(i));
Line: 1705

  END Delete_Operation_Instance;
Line: 2341

  PROCEDURE Update_Operation_Line(
    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_olev_rec                     IN olev_rec_type,
    x_olev_rec                     OUT NOCOPY olev_rec_type) IS

    l_olev_rec		olev_rec_type;
Line: 2351

    l_api_name		CONSTANT VARCHAR2(30) := 'Update_Operation_Line';
Line: 2395

    OKC_OPER_INST_PVT.Update_Operation_Line(
	 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_olev_rec			=> l_olev_rec,
      x_olev_rec			=> x_olev_rec);
Line: 2457

  END Update_Operation_Line;
Line: 2459

  PROCEDURE Update_Operation_Line(
    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_olev_tbl                     IN olev_tbl_type,
    x_olev_tbl                     OUT NOCOPY olev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Update_Operation_Line';
Line: 2496

		OKC_OPER_INST_PUB.Update_Operation_Line(
			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_olev_rec		=> p_olev_tbl(i),
			x_olev_rec		=> x_olev_tbl(i));
Line: 2555

  END Update_Operation_Line;
Line: 2557

  PROCEDURE Delete_Operation_Line(
    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_olev_rec                     IN olev_rec_type) IS

    l_olev_rec		olev_rec_type;
Line: 2566

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Operation_Line';
Line: 2610

    OKC_OPER_INST_PVT.Delete_Operation_Line(
	 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_olev_rec		=> l_olev_rec);
Line: 2668

  END Delete_Operation_Line;
Line: 2670

  PROCEDURE Delete_Operation_Line(
    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_olev_tbl                     IN olev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Operation_Line';
Line: 2706

		OKC_OPER_INST_PUB.Delete_Operation_Line(
			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_olev_rec		=> p_olev_tbl(i));
Line: 2764

  END Delete_Operation_Line;
Line: 3400

  PROCEDURE Update_Masschange_Dtls(
    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_mrdv_rec                     IN mrdv_rec_type,
    x_mrdv_rec                     OUT NOCOPY mrdv_rec_type) IS

    l_mrdv_rec		mrdv_rec_type;
Line: 3410

    l_api_name		CONSTANT VARCHAR2(30) := 'Update_Masschange_Dtls';
Line: 3454

    OKC_OPER_INST_PVT.Update_Masschange_Dtls(
      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_mrdv_rec		=> l_mrdv_rec,
      x_mrdv_rec		=> x_mrdv_rec);
Line: 3516

  END Update_Masschange_Dtls;
Line: 3518

  PROCEDURE Update_Masschange_Dtls(
    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_mrdv_tbl                     IN mrdv_tbl_type,
    x_mrdv_tbl                     OUT NOCOPY mrdv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Update_Masschange_Dtls';
Line: 3555

		OKC_OPER_INST_PUB.Update_Masschange_Dtls(
			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_mrdv_rec		=> p_mrdv_tbl(i),
			x_mrdv_rec		=> x_mrdv_tbl(i));
Line: 3614

  END Update_Masschange_Dtls;
Line: 3616

  PROCEDURE Delete_Masschange_Dtls(
    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_mrdv_rec                     IN mrdv_rec_type) IS

    l_mrdv_rec		mrdv_rec_type;
Line: 3625

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Masschange_Dtls';
Line: 3669

    OKC_OPER_INST_PVT.Delete_Masschange_Dtls(
      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_mrdv_rec	=> l_mrdv_rec);
Line: 3727

  END Delete_Masschange_Dtls;
Line: 3729

  PROCEDURE Delete_Masschange_Dtls(
    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_mrdv_tbl                     IN mrdv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Masschange_Dtls';
Line: 3765

		OKC_OPER_INST_PUB.Delete_Masschange_Dtls(
			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_mrdv_rec		=> p_mrdv_tbl(i));
Line: 3823

  END Delete_Masschange_Dtls;