eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_LINE_STYLES_PVT dependencies on OKC_LINE_STYLES_PUB

Line 32: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

28: x_msg_data OUT NOCOPY VARCHAR2,
29: p_lsev_rec IN lsev_rec_type) IS
30:
31: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
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

Line 33: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

29: p_lsev_rec IN lsev_rec_type) IS
30:
31: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
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

Line 46: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(

42: for l_rec in loc_bot_csr(p_lsev_rec.id) loop
43: IF l_rec.priced_yn=G_Yes and l_rec.id<>p_lsev_rec.id then
44: l_lsev_rec.id:=l_rec.id;
45: l_lsev_rec.priced_yn:=G_NO;
46: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
47: p_api_version,
48: p_init_msg_list,
49: x_return_status,
50: x_msg_count,

Line 82: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_lsev_rec IN lsev_rec_type) IS
80:
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

Line 83: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

79: p_lsev_rec IN lsev_rec_type) IS
80:
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;

Line 95: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(

91: for l_rec in loc_top_csr(p_lsev_rec.id) loop
92: IF l_rec.priced_yn=G_Yes and l_rec.id<>p_lsev_rec.id then
93: l_lsev_rec.id:=l_rec.id;
94: l_lsev_rec.priced_yn:=G_NO;
95: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
96: p_api_version,
97: p_init_msg_list,
98: x_return_status,
99: x_msg_count,

Line 132: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_lsev_rec IN lsev_rec_type) IS
130:
131: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
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

Line 133: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

129: p_lsev_rec IN lsev_rec_type) IS
130:
131: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
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

Line 146: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(

142: for l_rec in loc_bot_ip_csr(p_lsev_rec.id) loop
143: IF l_rec.item_to_price_yn=G_Yes and l_rec.id<>p_lsev_rec.id then
144: l_lsev_rec.id:=l_rec.id;
145: l_lsev_rec.item_to_price_yn:=G_NO;
146: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
147: p_api_version,
148: p_init_msg_list,
149: x_return_status,
150: x_msg_count,

Line 183: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_lsev_rec IN lsev_rec_type) IS
181:
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

Line 184: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

180: p_lsev_rec IN lsev_rec_type) IS
181:
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;

Line 196: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(

192: for l_rec in loc_top_ip_csr(p_lsev_rec.id) loop
193: IF l_rec.item_to_price_yn=G_Yes and l_rec.id<>p_lsev_rec.id then
194: l_lsev_rec.id:=l_rec.id;
195: l_lsev_rec.item_to_price_yn:=G_NO;
196: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
197: p_api_version,
198: p_init_msg_list,
199: x_return_status,
200: x_msg_count,

Line 231: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_lsev_rec IN lsev_rec_type) IS
229:
230: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
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

Line 232: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

228: p_lsev_rec IN lsev_rec_type) IS
229:
230: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
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

Line 245: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(

241: for l_rec in loc_bot_pb_csr(p_lsev_rec.id) loop
242: IF l_rec.price_basis_yn = G_Yes and l_rec.id<>p_lsev_rec.id then
243: l_lsev_rec.id:=l_rec.id;
244: l_lsev_rec.price_basis_yn:=G_NO;
245: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
246: p_api_version,
247: p_init_msg_list,
248: x_return_status,
249: x_msg_count,

Line 282: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_lsev_rec IN lsev_rec_type) IS
280:
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

Line 283: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

279: p_lsev_rec IN lsev_rec_type) IS
280:
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;

Line 295: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(

291: for l_rec in loc_top_pb_csr(p_lsev_rec.id) loop
292: IF l_rec.price_basis_yn = G_Yes and l_rec.id<>p_lsev_rec.id then
293: l_lsev_rec.id:=l_rec.id;
294: l_lsev_rec.price_basis_yn :=G_NO;
295: OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
296: p_api_version,
297: p_init_msg_list,
298: x_return_status,
299: x_msg_count,

Line 447: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;

443: x_msg_data OUT NOCOPY VARCHAR2,
444: p_lsev_rec IN lsev_rec_type) IS
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

Line 454: OKC_LINE_STYLES_PUB.DELETE_LINE_STYLES(

450:
451: BEGIN
452: for l_rec in c1(p_lsev_rec.id) loop
453: l_lsev_rec.id:=l_rec.id;
454: OKC_LINE_STYLES_PUB.DELETE_LINE_STYLES(
455: p_api_version,
456: p_init_msg_list,
457: x_return_status,
458: x_msg_count,

Line 487: l_lssv_rec OKC_LINE_STYLES_PUB.lssv_rec_type;

483: x_msg_data OUT NOCOPY VARCHAR2,
484: p_lsev_rec IN lsev_rec_type) IS
485:
486: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
487: l_lssv_rec OKC_LINE_STYLES_PUB.lssv_rec_type;
488: CURSOR c1(p_id IN NUMBER) is
489: select lse_id,jtot_object_code from okc_line_style_sources where lse_id=p_id;
490:
491: BEGIN

Line 495: OKC_LINE_STYLES_PUB.DELETE_LINE_STYLE_SOURCES(

491: BEGIN
492: for l_rec in c1(p_lsev_rec.id) loop
493: l_lssv_rec.lse_id:=l_rec.lse_id;
494: l_lssv_rec.jtot_object_code:=l_rec.jtot_object_code;
495: OKC_LINE_STYLES_PUB.DELETE_LINE_STYLE_SOURCES(
496: p_api_version,
497: p_init_msg_list,
498: x_return_status,
499: x_msg_count,

Line 528: l_vlov_rec OKC_LINE_STYLES_PUB.vlov_rec_type;

524: x_msg_data OUT NOCOPY VARCHAR2,
525: p_lsev_rec IN lsev_rec_type) IS
526:
527: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
528: l_vlov_rec OKC_LINE_STYLES_PUB.vlov_rec_type;
529: CURSOR c1(p_id IN NUMBER) is
530: select lse_id from okc_val_line_operations where lse_id=p_id;
531:
532: BEGIN

Line 535: OKC_LINE_STYLES_PUB.DELETE_VAL_LINE_OPERATION(

531:
532: BEGIN
533: for l_rec in c1(p_lsev_rec.id) loop
534: l_vlov_rec.lse_id:=l_rec.lse_id;
535: OKC_LINE_STYLES_PUB.DELETE_VAL_LINE_OPERATION(
536: p_api_version,
537: p_init_msg_list,
538: x_return_status,
539: x_msg_count,