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_PAY_CURE_REFUNDS_PVT dependencies on OKL_CURE_REFUNDS

Line 132: l_cure_refund_id okl_cure_refunds.cure_refund_id%type;

128: l_msg_data VARCHAR2(32627);
129: l_message VARCHAR2(32627);
130:
131:
132: l_cure_refund_id okl_cure_refunds.cure_refund_id%type;
133: l_cure_refund_number okl_cure_refunds.refund_number%type;
134: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_REFUND';
135: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'
136: || l_api_name;

Line 133: l_cure_refund_number okl_cure_refunds.refund_number%type;

129: l_message VARCHAR2(32627);
130:
131:
132: l_cure_refund_id okl_cure_refunds.cure_refund_id%type;
133: l_cure_refund_number okl_cure_refunds.refund_number%type;
134: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_REFUND';
135: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'
136: || l_api_name;
137:

Line 199: from okl_cure_refunds

195: l_khr_id number;
196:
197: cursor chk_refund_number(p_refund_number IN VARCHAR2) IS
198: select refund_number
199: from okl_cure_refunds
200: where refund_number =p_refund_number;
201:
202: CURSOR c_app
203: IS

Line 547: p_object => 'RECORD IN OKL_CURE_REFUNDS ',

543: --set error message,so this will be prefixed before the
544: --actual message, so it makes more sense than displaying an
545: -- OKL message.
546: AddfailMsg(
547: p_object => 'RECORD IN OKL_CURE_REFUNDS ',
548: p_operation => 'CREATE' );
549:
550: OKL_cure_refunds_pub.insert_cure_refunds(
551: p_api_version => 1.0

Line 550: OKL_cure_refunds_pub.insert_cure_refunds(

546: AddfailMsg(
547: p_object => 'RECORD IN OKL_CURE_REFUNDS ',
548: p_operation => 'CREATE' );
549:
550: OKL_cure_refunds_pub.insert_cure_refunds(
551: p_api_version => 1.0
552: ,p_init_msg_list => 'F'
553: ,x_return_status => l_return_status
554: ,x_msg_count => l_msg_count

Line 559: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : OKL_cure_refunds_pub.insert_cure_refunds : '||l_return_status);

555: ,x_msg_data => l_msg_data
556: ,p_crfv_rec => lp_crfv_rec
557: ,x_crfv_rec => lx_crfv_rec);
558:
559: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : OKL_cure_refunds_pub.insert_cure_refunds : '||l_return_status);
560:
561: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
562: Get_Messages (l_msg_count,l_message);
563: IF PG_DEBUG < 11 THEN

Line 675: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;

671:
672: TYPE c_getcontractsCurTyp IS REF CURSOR;
673: c_getcontracts c_getcontractsCurTyp; -- declare cursor variable
674:
675: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;
676: l_contract_number okl_cure_refunds_dtls_uv.contract_number%TYPE;
677: l_idx INTEGER;
678: l_amount_past_due NUMBER;
679: BEGIN

Line 676: l_contract_number okl_cure_refunds_dtls_uv.contract_number%TYPE;

672: TYPE c_getcontractsCurTyp IS REF CURSOR;
673: c_getcontracts c_getcontractsCurTyp; -- declare cursor variable
674:
675: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;
676: l_contract_number okl_cure_refunds_dtls_uv.contract_number%TYPE;
677: l_idx INTEGER;
678: l_amount_past_due NUMBER;
679: BEGIN
680:

Line 881: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;

877:
878: TYPE c_getcontractsCurTyp IS REF CURSOR;
879: c_getcontracts c_getcontractsCurTyp; -- declare cursor variable
880:
881: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;
882: l_refund_amount_due okl_cure_refunds_dtls_uv.refund_amount_due%TYPE;
883:
884: BEGIN
885: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 882: l_refund_amount_due okl_cure_refunds_dtls_uv.refund_amount_due%TYPE;

878: TYPE c_getcontractsCurTyp IS REF CURSOR;
879: c_getcontracts c_getcontractsCurTyp; -- declare cursor variable
880:
881: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;
882: l_refund_amount_due okl_cure_refunds_dtls_uv.refund_amount_due%TYPE;
883:
884: BEGIN
885: IF (G_DEBUG_ENABLED = 'Y') THEN
886: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 898: from okl_cure_refunds_dtls_uv

894: IF p_pay_cure_refunds_rec.REFUND_TYPE ='VENDOR_SITE' THEN
895: OPEN c_getcontracts
896: FOR
897: select contract_id,refund_amount_due
898: from okl_cure_refunds_dtls_uv
899: where vendor_site_id =p_pay_cure_refunds_rec.vendor_site_id and
900: contract_currency_code =p_pay_cure_refunds_rec.currency;
901:
902: elsif p_pay_cure_refunds_rec.REFUND_TYPE ='ACROSS_SITES' THEN

Line 906: from okl_cure_refunds_dtls_uv

902: elsif p_pay_cure_refunds_rec.REFUND_TYPE ='ACROSS_SITES' THEN
903: OPEN c_getcontracts
904: FOR
905: select contract_id,refund_amount_due
906: from okl_cure_refunds_dtls_uv
907: where vendor_id =p_pay_cure_refunds_rec.vendor_id and
908: contract_currency_code =p_pay_cure_refunds_rec.currency;
909:
910:

Line 975: l_cure_refund_id okl_cure_refunds.cure_refund_id%type;

971: l_return_status VARCHAR2(1);
972: l_msg_count NUMBER ;
973: l_msg_data VARCHAR2(32627);
974: l_message VARCHAR2(32627);
975: l_cure_refund_id okl_cure_refunds.cure_refund_id%type;
976: l_cure_refund_header_id okl_cure_refund_headers_b.cure_refund_header_id%type;
977: l_cure_refund_header_number okl_cure_refund_headers_b.refund_header_number%type;
978: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_REFUND_HDR';
979: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'

Line 1242: from okl_cure_refunds a, okl_trx_ap_invoices_b b

1238: select a.tap_id,
1239: a.cure_refund_id,
1240: a.object_version_number,
1241: b.invoice_number
1242: from okl_cure_refunds a, okl_trx_ap_invoices_b b
1243: where cure_refund_header_id =p_cure_refund_header_id
1244: and a.tap_id =b.id;
1245:
1246: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is

Line 1336: p_object => 'RECORD IN OKL_CURE_REFUNDS ',

1332: --set error message,so this will be prefixed before the
1333: --actual message, so it makes more sense than displaying an
1334: -- OKL message.
1335: AddfailMsg(
1336: p_object => 'RECORD IN OKL_CURE_REFUNDS ',
1337: p_operation => 'UPDATE' );
1338:
1339: OKL_cure_refunds_pub.update_cure_refunds(
1340: p_api_version => 1.0

Line 1339: OKL_cure_refunds_pub.update_cure_refunds(

1335: AddfailMsg(
1336: p_object => 'RECORD IN OKL_CURE_REFUNDS ',
1337: p_operation => 'UPDATE' );
1338:
1339: OKL_cure_refunds_pub.update_cure_refunds(
1340: p_api_version => 1.0
1341: ,p_init_msg_list => 'F'
1342: ,x_return_status => l_return_status
1343: ,x_msg_count => l_msg_count

Line 1348: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : OKL_cure_refunds_pub.update_cure_refunds : '||l_return_status);

1344: ,x_msg_data => l_msg_data
1345: ,p_crfv_tbl => lp_crfv_tbl
1346: ,x_crfv_tbl => lx_crfv_tbl);
1347:
1348: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : OKL_cure_refunds_pub.update_cure_refunds : '||l_return_status);
1349:
1350: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1351: Get_Messages (l_msg_count,l_message);
1352: IF PG_DEBUG < 11 THEN

Line 1475: from okl_cure_refunds crf,

1471: select crf.tap_id,
1472: crf.cure_refund_id,
1473: crf.object_version_number,
1474: til.id til_id
1475: from okl_cure_refunds crf,
1476: okl_txl_ap_inv_lns_b til
1477: where cure_refund_header_id =p_cure_refund_header_id
1478: and til.tap_id =crf.tap_id;
1479:

Line 1608: p_object => 'RECORD IN OKL_CURE_REFUNDS ',

1604: --set error message,so this will be prefixed before the
1605: --actual message, so it makes more sense than displaying an
1606: -- OKL message.
1607: AddfailMsg(
1608: p_object => 'RECORD IN OKL_CURE_REFUNDS ',
1609: p_operation => 'DELETE' );
1610:
1611: OKL_cure_refunds_pub.delete_cure_refunds(
1612: p_api_version => 1.0

Line 1611: OKL_cure_refunds_pub.delete_cure_refunds(

1607: AddfailMsg(
1608: p_object => 'RECORD IN OKL_CURE_REFUNDS ',
1609: p_operation => 'DELETE' );
1610:
1611: OKL_cure_refunds_pub.delete_cure_refunds(
1612: p_api_version => 1.0
1613: ,p_init_msg_list => 'F'
1614: ,x_return_status => l_return_status
1615: ,x_msg_count => l_msg_count

Line 1618: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : OKL_cure_refunds_pub.delete_cure_refunds : '||l_return_status);

1614: ,x_return_status => l_return_status
1615: ,x_msg_count => l_msg_count
1616: ,x_msg_data => l_msg_data
1617: ,p_crfv_tbl => lp_crfv_tbl);
1618: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : OKL_cure_refunds_pub.delete_cure_refunds : '||l_return_status);
1619:
1620: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1621: Get_Messages (l_msg_count,l_message);
1622: IF PG_DEBUG < 11 THEN

Line 1767: okl_cure_refunds crf

1763: tai.currency_code
1764: from
1765: okl_trx_ar_invoices_b tai,
1766: okl_txl_ar_inv_lns_b til,
1767: okl_cure_refunds crf
1768: where tai.id =til.tai_id
1769: and tai.id =crf.tai_id
1770: and crf.cure_refund_header_id =p_refund_header_id;*/
1771:

Line 1784: okl_cure_refunds crf

1780: tai.currency_code currency_code
1781: from okl_trx_ar_invoices_b tai,
1782: okl_txl_ar_inv_lns_b til,
1783: okl_txd_ar_ln_dtls_b txd,
1784: okl_cure_refunds crf
1785: where crf.cure_refund_header_id = p_refund_header_id
1786: and tai.id = crf.tai_id
1787: and tai.id = til.tai_id
1788: and til.id = txd.til_id_details ;

Line 2188: from okl_cure_refunds crf,okl_trx_ap_invoices_b tap

2184: select crf.tap_id,tap.invoice_number,
2185: crs.object_version_number
2186: ,crs.cure_refund_Stage_id
2187: ,crf.tai_id
2188: from okl_cure_refunds crf,okl_trx_ap_invoices_b tap
2189: ,okl_cure_refund_stage crs
2190: where crf.cure_refund_header_id =p_cure_refund_header_id
2191: and crf.tap_id =tap.id
2192: and crs.cure_refund_stage_id =crf.cure_refund_stage_id;

Line 2215: okl_cure_refunds crf

2211: tap.currency_code currency_code,
2212: til.khr_id khr_id
2213: from okl_trx_ap_invoices_b tap,
2214: okl_txl_ap_inv_lns_b til,
2215: okl_cure_refunds crf
2216: where crf.cure_refund_header_id = p_cure_refund_header_id
2217: and tap.id = til.tap_id
2218: and crf.tap_id = tap.id;
2219:

Line 2807: okl_cure_refunds crl

2803: pos.email_address,
2804: crh.cure_refund_header_id
2805: from po_vendor_sites pos,
2806: okl_cure_refund_headers_b crh,
2807: okl_cure_refunds crl
2808: where crh.vendor_site_id =pos.vendor_site_id
2809: and crh.cure_refund_header_id=p_refund_header_id
2810: and rownum <2;
2811:

Line 3034: from okl_cure_refunds

3030: -- getrole if there are offset contracts
3031: --jsanju 10/31
3032:
3033: select count(*) into l_offset_count
3034: from okl_cure_refunds
3035: where offset_contract is not null
3036: and cure_refund_header_id =p_refund_header_id;
3037:
3038: IF l_offset_count >0 THEN

Line 3402: select object_version_number from okl_cure_refunds

3398:
3399: l_btc_id NUMBER;
3400:
3401: cursor c_getobj_ver(p_cure_refund_id IN NUMBER ) is
3402: select object_version_number from okl_cure_refunds
3403: where cure_refund_id =p_cure_refund_id;
3404: lp_crfv_rec okl_crf_pvt.crfv_rec_type;
3405: lx_crfv_rec okl_crf_pvt.crfv_rec_type;
3406:

Line 3832: p_object => 'RECORD IN OKL_CURE_REFUNDS ',

3828: --set error message,so this will be prefixed before the
3829: --actual message, so it makes more sense than displaying an
3830: -- OKL message.
3831: AddfailMsg(
3832: p_object => 'RECORD IN OKL_CURE_REFUNDS ',
3833: p_operation => 'UPDATE' );
3834:
3835:
3836: lp_crfv_rec.cure_refund_id := p_cure_refund_id;

Line 3844: OKL_cure_refunds_pub.update_cure_refunds(

3840: FETCH c_getobj_ver INTO lp_crfv_rec.object_version_number;
3841: CLOSE c_getobj_ver;
3842:
3843:
3844: OKL_cure_refunds_pub.update_cure_refunds(
3845: p_api_version => 1.0
3846: ,p_init_msg_list => 'F'
3847: ,x_return_status => l_return_status
3848: ,x_msg_count => l_msg_count

Line 3852: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : OKL_cure_refunds_pub.update_cure_refunds : '||l_return_status);

3848: ,x_msg_count => l_msg_count
3849: ,x_msg_data => l_msg_data
3850: ,p_crfv_rec => lp_crfv_rec
3851: ,x_crfv_rec => lx_crfv_rec);
3852: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : OKL_cure_refunds_pub.update_cure_refunds : '||l_return_status);
3853: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3854: Get_Messages (l_msg_count,l_message);
3855: IF PG_DEBUG < 11 THEN
3856: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3967: okl_cure_refunds crf

3963: crh.currency_code,
3964: crh.refund_due_date
3965:
3966: from okl_cure_refund_headers_b crh,
3967: okl_cure_refunds crf
3968: where crh.cure_refund_header_id =p_cure_refund_header_id
3969: and crh.cure_refund_header_id =crf.cure_refund_header_id;
3970:
3971: CURSOR product_csr (p_chr_id IN NUMBER) IS

Line 4341: p_object => 'RECORD IN OKL_CURE_REFUNDS ',

4337: --set error message,so this will be prefixed before the
4338: --actual message, so it makes more sense than displaying an
4339: -- OKL message.
4340: AddfailMsg(
4341: p_object => 'RECORD IN OKL_CURE_REFUNDS ',
4342: p_operation => 'UPDATE' );
4343:
4344:
4345: lp_crfv_rec.cure_refund_id := i.cure_refund_id;

Line 4349: OKL_cure_refunds_pub.update_cure_refunds(

4345: lp_crfv_rec.cure_refund_id := i.cure_refund_id;
4346: lp_crfv_rec.tap_id := lx_tapv_rec.id;
4347: lp_crfv_rec.object_version_number :=i.object_version_number;
4348:
4349: OKL_cure_refunds_pub.update_cure_refunds(
4350: p_api_version => 1.0
4351: ,p_init_msg_list => 'F'
4352: ,x_return_status => l_return_status
4353: ,x_msg_count => l_msg_count

Line 4357: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : OKL_cure_refunds_pub.update_cure_refunds : '||x_return_status);

4353: ,x_msg_count => l_msg_count
4354: ,x_msg_data => l_msg_data
4355: ,p_crfv_rec => lp_crfv_rec
4356: ,x_crfv_rec => lx_crfv_rec);
4357: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : OKL_cure_refunds_pub.update_cure_refunds : '||x_return_status);
4358: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4359: Get_Messages (l_msg_count,l_message);
4360: IF PG_DEBUG < 11 THEN
4361: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4501: select count(cure_refund_id) from okl_cure_refunds where

4497: next_row integer;
4498: c_check_dtls_ctr NUMBER :=0;
4499:
4500: cursor c_check_dtls (p_refund_header_id IN NUMBER) is
4501: select count(cure_refund_id) from okl_cure_refunds where
4502: cure_refund_header_id =p_refund_header_id;
4503:
4504:
4505: BEGIN

Line 4739: from okl_cure_refunds crf,

4735: cursor c_get_refunds (p_refund_header_id IN NUMBER)
4736: is select crf.cure_refund_stage_id,
4737: crf.tai_id, crf.tap_id,
4738: crs.object_version_number
4739: from okl_cure_refunds crf,
4740: okl_cure_refund_stage crs
4741: where crf.cure_refund_header_id =p_refund_header_id
4742: and crs.cure_refund_stage_id=crf.cure_refund_stage_id;
4743:

Line 5315: l_cure_refund_id okl_cure_refunds.cure_refund_id%type;

5311: l_return_status VARCHAR2(1);
5312: l_msg_count NUMBER ;
5313: l_msg_data VARCHAR2(32627);
5314: l_message VARCHAR2(32627);
5315: l_cure_refund_id okl_cure_refunds.cure_refund_id%type;
5316: l_cure_refund_header_id okl_cure_refund_headers_b.cure_refund_header_id%type;
5317: l_cure_refund_header_number okl_cure_refund_headers_b.refund_header_number%type;
5318: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_REFUND_HEADERS';
5319: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'

Line 5471: from okl_cure_refunds a, okl_trx_ap_invoices_b b

5467: select a.tap_id,
5468: a.cure_refund_id,
5469: a.object_version_number,
5470: b.invoice_number
5471: from okl_cure_refunds a, okl_trx_ap_invoices_b b
5472: where cure_refund_header_id =p_cure_refund_header_id
5473: and a.tap_id =b.id;
5474:
5475: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is

Line 5660: from okl_cure_refunds b, okc_k_headers_b a

5656: CURSOR c_emps (p_cure_refund_header_id IN NUMBER)
5657: IS
5658: select a.contract_number,
5659: b.offset_amount
5660: from okl_cure_refunds b, okc_k_headers_b a
5661: where a.id =b.offset_contract
5662: and b.cure_refund_header_id =p_cure_refund_header_id;
5663:
5664: c_emps_rec c_emps%ROWTYPE;