DBA Data[Home] [Help]

APPS.OKL_SETUPPOPTIONS_PVT dependencies on OKL_PDT_OPT_VALS_PUB

Line 642: l_del_povv_tbl Okl_Pdt_Opt_Vals_Pub.povv_tbl_type;

638: ,p_ponv_rec IN ponv_rec_type) IS
639:
640: i PLS_INTEGER :=0;
641: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
642: l_del_povv_tbl Okl_Pdt_Opt_Vals_Pub.povv_tbl_type;
643:
644: CURSOR pov_csr IS
645: SELECT povv.id
646: FROM okl_pdt_opt_vals_v povv

Line 658: Okl_Pdt_Opt_Vals_Pub.delete_pdt_opt_vals(p_api_version => p_api_version,

654: l_del_povv_tbl(i).id := pov_rec.id;
655: END LOOP;
656: IF l_del_povv_tbl.COUNT > 0 THEN
657: /* public api to delete product option values */
658: Okl_Pdt_Opt_Vals_Pub.delete_pdt_opt_vals(p_api_version => p_api_version,
659: p_init_msg_list => p_init_msg_list,
660: x_return_status => l_return_status,
661: x_msg_count => x_msg_count,
662: x_msg_data => x_msg_data,

Line 718: l_del_povv_tbl Okl_Pdt_Opt_Vals_Pub.povv_tbl_type;

714: ,p_pdtv_rec IN pdtv_rec_type
715: ,p_ponv_tbl IN ponv_tbl_type
716: ) IS
717:
718: l_del_povv_tbl Okl_Pdt_Opt_Vals_Pub.povv_tbl_type;
719: l_loop_ctr NUMBER := 1;
720: l_api_version CONSTANT NUMBER := 1;
721: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS; --TCHGS
722: i PLS_INTEGER :=0;