APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on OKL_SETUPPRODUCTS_PVT

Line 684: OKL_SETUPPRODUCTS_PVT.update_product_status(

680: END LOOP;
681: -- Need to invalidate all the products which use this SGT.
682: FOR pdt_rec IN pdt_for_active_sgt_csr( l_sgt_set_id )
683: LOOP
684: OKL_SETUPPRODUCTS_PVT.update_product_status(
685: p_api_version => p_api_version,
686: p_init_msg_list => p_init_msg_list,
687: x_return_status => l_return_Status,
688: x_msg_count => x_msg_count,

Line 690: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,

686: p_init_msg_list => p_init_msg_list,
687: x_return_status => l_return_Status,
688: x_msg_count => x_msg_count,
689: x_msg_data => x_msg_data,
690: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,
691: p_pdt_id => pdt_rec.pdt_id );
692: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
694: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 4721: OKL_SETUPPRODUCTS_PVT.update_product_status(

4717: -- end changes by bkatraga
4718:
4719: FOR pdt_rec IN pdt_for_active_sgt_csr( l_sgt_set_id )
4720: LOOP
4721: OKL_SETUPPRODUCTS_PVT.update_product_status(
4722: p_api_version => p_api_version,
4723: p_init_msg_list => p_init_msg_list,
4724: x_return_status => l_return_Status,
4725: x_msg_count => x_msg_count,

Line 4727: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,

4723: p_init_msg_list => p_init_msg_list,
4724: x_return_status => l_return_Status,
4725: x_msg_count => x_msg_count,
4726: x_msg_data => x_msg_data,
4727: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,
4728: p_pdt_id => pdt_rec.pdt_id );
4729: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4730: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4731: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 5062: OKL_SETUPPRODUCTS_PVT.update_product_status(

5058: END LOOP;
5059: -- Need to invalidate all the products which use this SGT.
5060: FOR pdt_rec IN pdt_for_active_sgt_csr( l_sgt_set_id )
5061: LOOP
5062: OKL_SETUPPRODUCTS_PVT.update_product_status(
5063: p_api_version => p_api_version,
5064: p_init_msg_list => p_init_msg_list,
5065: x_return_status => l_return_Status,
5066: x_msg_count => x_msg_count,

Line 5068: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,

5064: p_init_msg_list => p_init_msg_list,
5065: x_return_status => l_return_Status,
5066: x_msg_count => x_msg_count,
5067: x_msg_data => x_msg_data,
5068: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,
5069: p_pdt_id => pdt_rec.pdt_id );
5070: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5072: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN