APPS.OKL_TMPT_SET_PVT dependencies on OKL_AVL_PVT

Line 446: l_ae_template_tbl OKL_AVL_PVT.avlv_tbl_type;

442: FROM okl_ae_templates
443: WHERE aes_id = p_aes_id;
444:
445:
446: l_ae_template_tbl OKL_AVL_PVT.avlv_tbl_type;
447:
448: i NUMBER := 0;
449: j NUMBER := 0;
450:

Line 604: okl_avl_pvt.insert_row(

600: x_msg_data OUT NOCOPY VARCHAR2,
601: p_avlv_rec IN avlv_rec_type,
602: x_avlv_rec OUT NOCOPY avlv_rec_type) IS
603: BEGIN
604: okl_avl_pvt.insert_row(
605: p_api_version,
606: p_init_msg_list,
607: x_return_status,
608: x_msg_count,

Line 671: okl_avl_pvt.lock_row(

667: x_msg_count OUT NOCOPY NUMBER,
668: x_msg_data OUT NOCOPY VARCHAR2,
669: p_avlv_rec IN avlv_rec_type) IS
670: BEGIN
671: okl_avl_pvt.lock_row(
672: p_api_version,
673: p_init_msg_list,
674: x_return_status,
675: x_msg_count,

Line 730: OKL_AVL_PVT.update_row(

726: p_avlv_rec IN avlv_rec_type,
727: x_avlv_rec OUT NOCOPY avlv_rec_type) IS
728: BEGIN
729:
730: OKL_AVL_PVT.update_row(
731: p_api_version,
732: p_init_msg_list,
733: x_return_status,
734: x_msg_count,

Line 825: okl_avl_pvt.delete_row(

821: l_atlv_tbl);
822:
823: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
824:
825: okl_avl_pvt.delete_row(
826: p_api_version,
827: p_init_msg_list,
828: x_return_status,
829: x_msg_count,

Line 886: okl_avl_pvt.validate_row(

882: x_msg_count OUT NOCOPY NUMBER,
883: x_msg_data OUT NOCOPY VARCHAR2,
884: p_avlv_rec IN avlv_rec_type) IS
885: BEGIN
886: okl_avl_pvt.validate_row(
887: p_api_version,
888: p_init_msg_list,
889: x_return_status,
890: x_msg_count,