DBA Data[Home] [Help]

APPS.OKC_OPER_INST_PVT SQL Statements

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

Line: 23

  G_NO_UPDATE_ALLOWED_EXCEPTION exception;
Line: 24

  G_NO_UPDATE_ALLOWED CONSTANT VARCHAR2(200) := 'OKC_NO_UPDATE_ALLOWED';
Line: 43

       OKC_COP_PVT.Insert_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_copv_rec		=> l_copv_rec,
            x_copv_rec		=> x_copv_rec);
Line: 65

    OKC_COP_PVT.Insert_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_copv_tbl		=> p_copv_tbl,
      x_copv_tbl		=> x_copv_tbl);
Line: 76

  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 OKC_COP_PVT.copv_rec_type,
    x_copv_rec                     OUT NOCOPY OKC_COP_PVT.copv_rec_type) IS

  BEGIN

    OKC_COP_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_copv_rec			=> p_copv_rec,
      x_copv_rec			=> x_copv_rec);
Line: 96

  END Update_Class_Operation;
Line: 98

  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 OKC_COP_PVT.copv_tbl_type,
    x_copv_tbl                     OUT NOCOPY OKC_COP_PVT.copv_tbl_type) IS

  BEGIN

    OKC_COP_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_copv_tbl			=> p_copv_tbl,
      x_copv_tbl			=> x_copv_tbl);
Line: 118

  END Update_Class_Operation;
Line: 120

  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 OKC_COP_PVT.copv_rec_type) IS

  BEGIN
       OKC_COP_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_copv_rec		=> p_copv_rec);
Line: 137

  END Delete_Class_Operation;
Line: 139

  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 OKC_COP_PVT.copv_tbl_type) IS

  BEGIN

    OKC_COP_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_copv_tbl		=> p_copv_tbl);
Line: 157

  END Delete_Class_Operation;
Line: 253

       OKC_OIE_PVT.Insert_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_oiev_rec		=> l_oiev_rec,
            x_oiev_rec		=> x_oiev_rec);
Line: 275

    OKC_OIE_PVT.Insert_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_oiev_tbl		=> p_oiev_tbl,
      x_oiev_tbl		=> x_oiev_tbl);
Line: 286

  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 OKC_OIE_PVT.oiev_rec_type,
    x_oiev_rec                     OUT NOCOPY OKC_OIE_PVT.oiev_rec_type) IS

  BEGIN

    OKC_OIE_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_oiev_rec			=> p_oiev_rec,
      x_oiev_rec			=> x_oiev_rec);
Line: 306

  END Update_Operation_Instance;
Line: 308

  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 OKC_OIE_PVT.oiev_tbl_type,
    x_oiev_tbl                     OUT NOCOPY OKC_OIE_PVT.oiev_tbl_type) IS

  BEGIN

    OKC_OIE_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_oiev_tbl			=> p_oiev_tbl,
      x_oiev_tbl			=> x_oiev_tbl);
Line: 328

  END Update_Operation_Instance;
Line: 330

  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 OKC_OIE_PVT.oiev_rec_type) IS

    l_olev_tbl 			   OKC_OPER_INST_PUB.olev_tbl_type;
Line: 344

		 SELECT id
		 FROM okc_operation_lines
		 WHERE oie_id = p_oiev_rec.id;
Line: 349

		 SELECT id
		 FROM okc_masschange_req_dtls
		 WHERE oie_id = p_oiev_rec.id;
Line: 355

	  -- Delete all children (operation lines) before deleting instance
	  --
	  FOR ole_rec IN ole_csr
	  LOOP
		 i := i + 1;
Line: 364

            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_tbl		     => l_olev_tbl);
Line: 375

	-- Delete all children (masschange) before deleting instance
	--

        If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
           FOR oie_rec IN ole1_csr
           LOOP
	       j := j + 1;
Line: 388

               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_tbl		     => l_mrdv_tbl);
Line: 400

              OKC_OIE_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_oiev_rec		=> p_oiev_rec);
Line: 408

  END Delete_Operation_Instance;
Line: 410

  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 OKC_OIE_PVT.oiev_tbl_type) IS

  BEGIN

    OKC_OIE_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_oiev_tbl		=> p_oiev_tbl);
Line: 428

  END Delete_Operation_Instance;
Line: 524

       OKC_OLE_PVT.Insert_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_olev_rec		=> l_olev_rec,
            x_olev_rec		=> x_olev_rec);
Line: 546

    OKC_OLE_PVT.Insert_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_olev_tbl		=> p_olev_tbl,
      x_olev_tbl		=> x_olev_tbl);
Line: 557

  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 OKC_OLE_PVT.olev_rec_type,
    x_olev_rec                     OUT NOCOPY OKC_OLE_PVT.olev_rec_type) IS

  BEGIN

    OKC_OLE_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_olev_rec			=> p_olev_rec,
      x_olev_rec			=> x_olev_rec);
Line: 577

  END Update_Operation_Line;
Line: 579

  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 OKC_OLE_PVT.olev_tbl_type,
    x_olev_tbl                     OUT NOCOPY OKC_OLE_PVT.olev_tbl_type) IS

  BEGIN

    OKC_OLE_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_olev_tbl			=> p_olev_tbl,
      x_olev_tbl			=> x_olev_tbl);
Line: 599

  END Update_Operation_Line;
Line: 601

  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 OKC_OLE_PVT.olev_rec_type) IS

    l_mrdv_tbl                     OKC_MRD_PVT.mrdv_tbl_type;
Line: 613

		SELECT object_chr_id, subject_chr_id, object_cle_id, subject_cle_id
		FROM okc_operation_lines
		WHERE id = p_olev_rec.ID
		AND active_yn = 'Y';
Line: 619

		 SELECT id
		 FROM okc_masschange_req_dtls
		 WHERE ole_id = p_olev_rec.ID;
Line: 632

		    UPDATE okc_k_lines_b
		    SET date_renewed = null
		    WHERE id = ole_rec.object_cle_id;
Line: 637

		    UPDATE okc_k_headers_b
		    SET date_renewed = null
		    WHERE id = ole_rec.object_chr_id;
Line: 646

	-- Delete all children (masschange) before deleting operation line
	--

        FOR oie_rec IN ole1_csr
	  LOOP
	     j := j + 1;
Line: 658

            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_tbl		     => l_mrdv_tbl);
Line: 669

            OKC_OLE_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_olev_rec		=> p_olev_rec);
Line: 677

  END Delete_Operation_Line;
Line: 679

  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 OKC_OLE_PVT.olev_tbl_type) IS

  BEGIN

    OKC_OLE_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_olev_tbl		=> p_olev_tbl);
Line: 697

  END Delete_Operation_Line;
Line: 793

       OKC_MRD_PVT.Insert_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_mrdv_rec		=> l_mrdv_rec,
            x_mrdv_rec		=> x_mrdv_rec);
Line: 815

    OKC_MRD_PVT.Insert_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_mrdv_tbl	=> p_mrdv_tbl,
      x_mrdv_tbl	=> x_mrdv_tbl);
Line: 826

  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 OKC_MRD_PVT.mrdv_rec_type,
    x_mrdv_rec                     OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS

  BEGIN

    OKC_MRD_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_mrdv_rec		=> p_mrdv_rec,
      x_mrdv_rec		=> x_mrdv_rec);
Line: 846

  END Update_Masschange_Dtls;
Line: 848

  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 OKC_MRD_PVT.mrdv_tbl_type,
    x_mrdv_tbl                     OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS

  BEGIN

    OKC_MRD_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_mrdv_tbl		=> p_mrdv_tbl,
      x_mrdv_tbl		=> x_mrdv_tbl);
Line: 868

  END Update_Masschange_Dtls;
Line: 870

  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 OKC_MRD_PVT.mrdv_rec_type) IS

  BEGIN
       OKC_MRD_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_mrdv_rec		=> p_mrdv_rec);
Line: 887

  END Delete_Masschange_Dtls;
Line: 889

  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 OKC_MRD_PVT.mrdv_tbl_type) IS

  BEGIN

    OKC_MRD_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_mrdv_tbl	=> p_mrdv_tbl);
Line: 907

  END Delete_Masschange_Dtls;