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.OKL_CURE_VNDR_RFND_PVT dependencies on OKL_CURE_REFUNDS

Line 18: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;

14: l_api_name VARCHAR2(30) := 'create_cure_refund';
15: l_api_version CONSTANT NUMBER := 1.0;
16: i NUMBER;
17:
18: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
19: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
20: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;
21:
22: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;

Line 19: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;

15: l_api_version CONSTANT NUMBER := 1.0;
16: i NUMBER;
17:
18: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
19: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
20: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;
21:
22: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
23: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;

Line 20: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;

16: i NUMBER;
17:
18: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
19: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
20: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;
21:
22: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
23: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
24:

Line 25: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;

21:
22: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
23: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
24:
25: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
26: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
27:
28: lp_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
29: lx_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;

Line 26: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;

22: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
23: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
24:
25: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
26: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
27:
28: lp_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
29: lx_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
30:

Line 40: from OKL_CURE_REFUNDS

36: where cure_refund_header_id = l_cure_refund_header_id;
37:
38: Cursor get_hdr_amounts_csr(l_cure_refund_header_id NUMBER) is
39: select sum(received_amount),sum(offset_amount), sum(disbursement_amount)
40: from OKL_CURE_REFUNDS
41: where cure_refund_header_id = l_cure_refund_header_id;
42:
43: BEGIN
44:

Line 100: OKL_cure_refunds_pub.insert_cure_refunds(

96: END LOOP;
97:
98: -- refund lines info
99:
100: OKL_cure_refunds_pub.insert_cure_refunds(
101: p_api_version => p_api_version,
102: p_init_msg_list => p_init_msg_list,
103: x_return_status => x_return_status,
104: x_msg_count => x_msg_count,

Line 221: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;

217:
218: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
219: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
220:
221: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
222: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
223:
224: lp_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
225: lx_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;

Line 222: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;

218: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
219: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
220:
221: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
222: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
223:
224: lp_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
225: lx_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
226:

Line 229: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;

225: lx_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
226:
227: l_obj_vers_no NUMBER;
228:
229: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
230: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
231: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;
232:
233: Cursor get_obj_vers_no(l_cure_refund_header_id NUMBER) is

Line 230: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;

226:
227: l_obj_vers_no NUMBER;
228:
229: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
230: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
231: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;
232:
233: Cursor get_obj_vers_no(l_cure_refund_header_id NUMBER) is
234: select object_version_number

Line 231: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;

227: l_obj_vers_no NUMBER;
228:
229: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
230: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
231: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;
232:
233: Cursor get_obj_vers_no(l_cure_refund_header_id NUMBER) is
234: select object_version_number
235: from OKL_CURE_REFUND_HEADERS_B

Line 240: from OKL_CURE_REFUNDS

236: where cure_refund_header_id = l_cure_refund_header_id;
237:
238: Cursor get_hdr_amounts_csr(l_cure_refund_header_id NUMBER) is
239: select sum(received_amount),sum(offset_amount), sum(disbursement_amount)
240: from OKL_CURE_REFUNDS
241: where cure_refund_header_id = l_cure_refund_header_id;
242:
243: BEGIN
244:

Line 301: OKL_cure_refunds_pub.update_cure_refunds(

297: END LOOP;
298:
299: -- refund lines info
300:
301: OKL_cure_refunds_pub.update_cure_refunds(
302: p_api_version => p_api_version,
303: p_init_msg_list => p_init_msg_list,
304: x_return_status => x_return_status,
305: x_msg_count => x_msg_count,

Line 417: l_received_amount okl_cure_refunds.received_amount%type := 0;

413: l_api_name VARCHAR2(30) := 'delete_cure_refund';
414: l_api_version CONSTANT NUMBER := 1.0;
415: i NUMBER;
416:
417: l_received_amount okl_cure_refunds.received_amount%type := 0;
418: l_offset_amount okl_cure_refunds.offset_amount%type := 0;
419:
420: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
421: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;

Line 418: l_offset_amount okl_cure_refunds.offset_amount%type := 0;

414: l_api_version CONSTANT NUMBER := 1.0;
415: i NUMBER;
416:
417: l_received_amount okl_cure_refunds.received_amount%type := 0;
418: l_offset_amount okl_cure_refunds.offset_amount%type := 0;
419:
420: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
421: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
422:

Line 420: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;

416:
417: l_received_amount okl_cure_refunds.received_amount%type := 0;
418: l_offset_amount okl_cure_refunds.offset_amount%type := 0;
419:
420: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
421: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
422:
423: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
424: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;

Line 421: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;

417: l_received_amount okl_cure_refunds.received_amount%type := 0;
418: l_offset_amount okl_cure_refunds.offset_amount%type := 0;
419:
420: l_tot_received_amount okl_cure_refunds.received_amount%type := 0;
421: l_tot_offset_amount okl_cure_refunds.offset_amount%type := 0;
422:
423: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
424: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
425:

Line 426: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;

422:
423: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
424: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
425:
426: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
427: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
428:
429: lp_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
430: lx_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;

Line 427: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;

423: lp_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
424: lx_chdv_rec OKL_cure_rfnd_hdr_pub.chdv_rec_type;
425:
426: lp_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
427: lx_crfv_tbl OKL_cure_refunds_pub.crfv_tbl_type;
428:
429: lp_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
430: lx_crsv_tbl OKL_cure_rfnd_stage_pub.crsv_tbl_type;
431:

Line 441: from OKL_CURE_REFUNDS

437: where cure_refund_header_id = l_cure_refund_header_id;
438:
439: Cursor get_hdr_amounts_csr(l_cure_refund_header_id NUMBER) is
440: select sum(received_amount),sum(offset_amount)
441: from OKL_CURE_REFUNDS
442: where cure_refund_header_id = l_cure_refund_header_id;
443:
444: BEGIN
445:

Line 491: OKL_cure_refunds_pub.delete_cure_refunds(

487: END LOOP;
488:
489: -- refund lines info
490:
491: OKL_cure_refunds_pub.delete_cure_refunds(
492: p_api_version => p_api_version,
493: p_init_msg_list => p_init_msg_list,
494: x_return_status => x_return_status,
495: x_msg_count => x_msg_count,