DBA Data[Home] [Help]

APPS.OKC_LSE_PVT dependencies on OKC_LINE_STYLES_PUB

Line 879: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

875: x_return_status OUT NOCOPY VARCHAR2,
876: p_lsev_rec IN lsev_rec_type) IS
877:
878: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
879: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
880: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
881:
882: CURSOR loc_bot_csr (p_id IN NUMBER) is
883: select id, priced_yn, item_to_price_yn, price_basis_yn from okc_line_styles_b

Line 880: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

876: p_lsev_rec IN lsev_rec_type) IS
877:
878: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
879: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
880: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
881:
882: CURSOR loc_bot_csr (p_id IN NUMBER) is
883: select id, priced_yn, item_to_price_yn, price_basis_yn from okc_line_styles_b
884: Connect by prior id = lse_parent_id