APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on OKL_SETUPPRODUCTS_PVT

Line 698: OKL_SETUPPRODUCTS_PVT.update_product_status(

694: END LOOP;
695: -- Need to invalidate all the products which use this SGT.
696: FOR pdt_rec IN pdt_for_active_sgt_csr( l_sgt_set_id )
697: LOOP
698: OKL_SETUPPRODUCTS_PVT.update_product_status(
699: p_api_version => p_api_version,
700: p_init_msg_list => p_init_msg_list,
701: x_return_status => l_return_Status,
702: x_msg_count => x_msg_count,

Line 704: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,

700: p_init_msg_list => p_init_msg_list,
701: x_return_status => l_return_Status,
702: x_msg_count => x_msg_count,
703: x_msg_data => x_msg_data,
704: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,
705: p_pdt_id => pdt_rec.pdt_id );
706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 4736: OKL_SETUPPRODUCTS_PVT.update_product_status(

4732: -- end changes by bkatraga
4733:
4734: FOR pdt_rec IN pdt_for_active_sgt_csr( l_sgt_set_id )
4735: LOOP
4736: OKL_SETUPPRODUCTS_PVT.update_product_status(
4737: p_api_version => p_api_version,
4738: p_init_msg_list => p_init_msg_list,
4739: x_return_status => l_return_Status,
4740: x_msg_count => x_msg_count,

Line 4742: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,

4738: p_init_msg_list => p_init_msg_list,
4739: x_return_status => l_return_Status,
4740: x_msg_count => x_msg_count,
4741: x_msg_data => x_msg_data,
4742: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,
4743: p_pdt_id => pdt_rec.pdt_id );
4744: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4746: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 5077: OKL_SETUPPRODUCTS_PVT.update_product_status(

5073: END LOOP;
5074: -- Need to invalidate all the products which use this SGT.
5075: FOR pdt_rec IN pdt_for_active_sgt_csr( l_sgt_set_id )
5076: LOOP
5077: OKL_SETUPPRODUCTS_PVT.update_product_status(
5078: p_api_version => p_api_version,
5079: p_init_msg_list => p_init_msg_list,
5080: x_return_status => l_return_Status,
5081: x_msg_count => x_msg_count,

Line 5083: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,

5079: p_init_msg_list => p_init_msg_list,
5080: x_return_status => l_return_Status,
5081: x_msg_count => x_msg_count,
5082: x_msg_data => x_msg_data,
5083: p_pdt_status => OKL_SETUPPRODUCTS_PVT.G_PDT_STS_INVALID,
5084: p_pdt_id => pdt_rec.pdt_id );
5085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN