APPS.OKL_VP_PARTY_PAYMENT_PVT SQL Statements

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

Line: 59

     SELECT dnz_chr_id
       FROM okc_k_party_roles_b
      WHERE id = cp_cpl_id;

Line: 79

     OKL_PYD_PVT.insert_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_srfvv_rec,
                            x_srfvv_rec);

Line: 365

   PROCEDURE delete_party_pymnt_dtls(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_srfvv_rec                    IN srfvv_rec_type
     ) IS
     l_api_name          CONSTANT VARCHAR2(30) := 'DELETE_PARTY_PYMNT_DTLS';

Line: 390

     OKL_PYD_PVT.delete_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_srfvv_rec);

Line: 431

   END delete_party_pymnt_dtls;

Line: 433

   PROCEDURE delete_party_pymnt_dtls(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_srfvv_tbl                    IN srfvv_tbl_type
     ) IS
     l_api_name          CONSTANT VARCHAR2(30) := 'DELETE_PARTY_PYMNT_DTLS';

Line: 451

         delete_party_pymnt_dtls(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_srfvv_tbl(i));

Line: 502

   END delete_party_pymnt_dtls;

Line: 504

   PROCEDURE update_party_pymnt_dtls(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_srfvv_rec                    IN srfvv_rec_type,
     x_srfvv_rec                    OUT NOCOPY srfvv_rec_type
     ) IS

     -- sjalasut, added cursor to derive the chr_id for flipping the agreement status to INCOMPLETE
     CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
     SELECT dnz_chr_id
       FROM okc_k_party_roles_b
      WHERE id = cp_cpl_id;

Line: 521

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

Line: 538

     OKL_PYD_PVT.update_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_srfvv_rec,
                            x_srfvv_rec);

Line: 609

   END update_party_pymnt_dtls;

Line: 611

   PROCEDURE update_party_pymnt_dtls(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_srfvv_tbl                    IN srfvv_tbl_type,
     x_srfvv_tbl                    OUT NOCOPY srfvv_tbl_type
     ) IS
     l_api_name          CONSTANT VARCHAR2(30) := 'UPDATE_PARTY_PYMNT_DTLS';

Line: 631

         update_party_pymnt_dtls(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_srfvv_tbl(i),
                            x_srfvv_tbl(i));

Line: 683

   END update_party_pymnt_dtls;