APPS.OKC_LINE_STYLES_PVT dependencies on OKC_LINE_STYLES_B

Line 36: select id, priced_yn from okc_line_styles_b

32: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
33: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
34:
35: CURSOR loc_bot_csr (p_id IN NUMBER) is
36: select id, priced_yn from okc_line_styles_b
37: Connect by prior id = lse_parent_id
38: start with id = p_id;
39:
40: BEGIN

Line 85: select id, priced_yn from okc_line_styles_b

81: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
82: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
83: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
84: CURSOR loc_top_csr (p_id IN NUMBER) is
85: select id, priced_yn from okc_line_styles_b
86: connect by prior lse_parent_id = id
87: start with id = p_id;
88:
89: BEGIN

Line 136: select id, item_to_price_yn from okc_line_styles_b

132: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
133: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
134:
135: CURSOR loc_bot_ip_csr (p_id IN NUMBER) is
136: select id, item_to_price_yn from okc_line_styles_b
137: Connect by prior id = lse_parent_id
138: start with id = p_id;
139:
140: BEGIN

Line 186: select id, item_to_price_yn from okc_line_styles_b

182: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
183: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
184: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
185: CURSOR loc_top_ip_csr (p_id IN NUMBER) is
186: select id, item_to_price_yn from okc_line_styles_b
187: connect by prior lse_parent_id = id
188: start with id = p_id;
189:
190: BEGIN

Line 235: select id, price_basis_yn from okc_line_styles_b

231: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
232: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
233:
234: CURSOR loc_bot_pb_csr (p_id IN NUMBER) is
235: select id, price_basis_yn from okc_line_styles_b
236: Connect by prior id = lse_parent_id
237: start with id = p_id;
238:
239: BEGIN

Line 285: select id, price_basis_yn from okc_line_styles_b

281: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
282: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
283: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
284: CURSOR loc_top_pb_csr (p_id IN NUMBER) is
285: select id, price_basis_yn from okc_line_styles_b
286: connect by prior lse_parent_id = id
287: start with id = p_id;
288:
289: BEGIN

Line 449: select id from okc_line_styles_b where lse_parent_id=p_id;

445:
446: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
447: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
448: CURSOR c1(p_id IN NUMBER) is
449: select id from okc_line_styles_b where lse_parent_id=p_id;
450:
451: BEGIN
452: for l_rec in c1(p_lsev_rec.id) loop
453: l_lsev_rec.id:=l_rec.id;