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_REFUND_HEADERS_B

Line 976: l_cure_refund_header_id okl_cure_refund_headers_b.cure_refund_header_id%type;

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 || '.'
980: || l_api_name;

Line 977: l_cure_refund_header_number okl_cure_refund_headers_b.refund_header_number%type;

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 || '.'
980: || l_api_name;
981:

Line 990: from okl_cure_refund_headers_b

986:
987: l_pay_cure_refunds_rec pay_cure_refunds_rec_type;
988: cursor chk_refund_number(p_refund_header_number IN VARCHAR2) IS
989: select refund_header_number
990: from okl_cure_refund_headers_b
991: where refund_header_number =p_refund_header_number;
992:
993: x_contract_number okc_k_headers_b.contract_number%TYPE;
994:

Line 1247: select object_version_number from okl_cure_refund_headers_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
1247: select object_version_number from okl_cure_refund_headers_b
1248: where cure_refund_header_id =p_cure_refund_header_id;
1249:
1250:
1251:

Line 1482: select object_version_number from okl_cure_refund_headers_b

1478: and til.tap_id =crf.tap_id;
1479:
1480:
1481: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is
1482: select object_version_number from okl_cure_refund_headers_b
1483: where cure_refund_header_id =p_cure_refund_header_id;
1484:
1485:
1486:

Line 2195: select object_version_number from okl_cure_refund_headers_b

2191: and crf.tap_id =tap.id
2192: and crs.cure_refund_stage_id =crf.cure_refund_stage_id;
2193:
2194: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is
2195: select object_version_number from okl_cure_refund_headers_b
2196: where cure_refund_header_id =p_cure_refund_header_id;
2197:
2198: next_row integer;
2199: tai_next_row integer;

Line 2806: okl_cure_refund_headers_b crh,

2802: pos.vendor_site_code,
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;

Line 2931: from okl_cure_refund_headers_b crh,

2927: cursor c_get_ref_details (p_refund_header_id IN NUMBER)
2928: is select crh.refund_header_number
2929: ,crh.disbursement_amount
2930: ,pov.vendor_name
2931: from okl_cure_refund_headers_b crh,
2932: po_vendors pov,
2933: po_vendor_sites_All povs
2934: where crh.vendor_site_id =povs.vendor_site_id
2935: and pov.vendor_id =povs.vendor_id

Line 2938: l_refund_amount okl_cure_refund_headers_b.disbursement_amount%TYPE;

2934: where crh.vendor_site_id =povs.vendor_site_id
2935: and pov.vendor_id =povs.vendor_id
2936: and crh.cure_refund_header_id =p_refund_header_id;
2937:
2938: l_refund_amount okl_cure_refund_headers_b.disbursement_amount%TYPE;
2939: l_refund_number okl_cure_refund_headers_b.refund_header_number%TYPE;
2940:
2941: l_vendor_name po_vendors.vendor_name%TYPE;
2942: l_notification_agent varchar2(100) := 'SYSADMIN';

Line 2939: l_refund_number okl_cure_refund_headers_b.refund_header_number%TYPE;

2935: and pov.vendor_id =povs.vendor_id
2936: and crh.cure_refund_header_id =p_refund_header_id;
2937:
2938: l_refund_amount okl_cure_refund_headers_b.disbursement_amount%TYPE;
2939: l_refund_number okl_cure_refund_headers_b.refund_header_number%TYPE;
2940:
2941: l_vendor_name po_vendors.vendor_name%TYPE;
2942: l_notification_agent varchar2(100) := 'SYSADMIN';
2943:

Line 3948: select object_version_number from okl_cure_refund_headers_b

3944: lp_chdv_rec okl_chd_pvt.chdv_rec_type;
3945: lx_chdv_rec okl_chd_pvt.chdv_rec_type;
3946:
3947: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is
3948: select object_version_number from okl_cure_refund_headers_b
3949: where cure_refund_header_id =p_cure_refund_header_id;
3950:
3951: next_row integer;
3952:

Line 3966: from okl_cure_refund_headers_b crh,

3962: crh.payment_method,
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:

Line 4491: from okl_cure_refund_headers_b

4487: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is
4488: select object_version_number,
4489: refund_header_number,
4490: refund_status
4491: from okl_cure_refund_headers_b
4492: where cure_refund_header_id =p_cure_refund_header_id;
4493: l_refund_header_number okl_cure_refund_headers_b.refund_header_number%TYPE;
4494:
4495: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;

Line 4493: l_refund_header_number okl_cure_refund_headers_b.refund_header_number%TYPE;

4489: refund_header_number,
4490: refund_status
4491: from okl_cure_refund_headers_b
4492: where cure_refund_header_id =p_cure_refund_header_id;
4493: l_refund_header_number okl_cure_refund_headers_b.refund_header_number%TYPE;
4494:
4495: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;
4496:
4497: next_row integer;

Line 4495: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;

4491: from okl_cure_refund_headers_b
4492: where cure_refund_header_id =p_cure_refund_header_id;
4493: l_refund_header_number okl_cure_refund_headers_b.refund_header_number%TYPE;
4494:
4495: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;
4496:
4497: next_row integer;
4498: c_check_dtls_ctr NUMBER :=0;
4499:

Line 4731: select object_version_number from okl_cure_refund_headers_b

4727: lp_crsv_tbl okl_crs_pvt.crsv_tbl_type;
4728: xp_crsv_tbl okl_crs_pvt.crsv_tbl_type;
4729:
4730: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is
4731: select object_version_number from okl_cure_refund_headers_b
4732: where cure_refund_header_id =p_cure_refund_header_id;
4733:
4734:
4735: cursor c_get_refunds (p_refund_header_id IN NUMBER)

Line 5045: --okl_cure_refund_headers_b.cure_refund_header_id%TYPE;

5041: l_msg_data VARCHAR2(32627);
5042: l_message VARCHAR2(32627) :=NULL;
5043:
5044: l_refund_header_id VARCHAR2(32627);
5045: --okl_cure_refund_headers_b.cure_refund_header_id%TYPE;
5046: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;
5047: l_nid NUMBER;
5048: l_role_name VARCHAR2(30);
5049:

Line 5046: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;

5042: l_message VARCHAR2(32627) :=NULL;
5043:
5044: l_refund_header_id VARCHAR2(32627);
5045: --okl_cure_refund_headers_b.cure_refund_header_id%TYPE;
5046: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;
5047: l_nid NUMBER;
5048: l_role_name VARCHAR2(30);
5049:
5050: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is

Line 5051: select object_version_number from okl_cure_refund_headers_b

5047: l_nid NUMBER;
5048: l_role_name VARCHAR2(30);
5049:
5050: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is
5051: select object_version_number from okl_cure_refund_headers_b
5052: where cure_refund_header_id =p_cure_refund_header_id;
5053:
5054: lp_chdv_rec okl_chd_pvt.chdv_rec_type;
5055: lx_chdv_rec okl_chd_pvt.chdv_rec_type;

Line 5229: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;

5225: l_msg_data VARCHAR2(32627);
5226: l_message VARCHAR2(32627);
5227:
5228: l_refund_header_id VARCHAR2(32627);
5229: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;
5230:
5231:
5232: BEGIN
5233: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_reject_status : START ');

Line 5316: l_cure_refund_header_id okl_cure_refund_headers_b.cure_refund_header_id%type;

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 || '.'
5320: || l_api_name;

Line 5317: l_cure_refund_header_number okl_cure_refund_headers_b.refund_header_number%type;

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 || '.'
5320: || l_api_name;
5321:

Line 5330: from okl_cure_refund_headers_b

5326:
5327: l_pay_cure_refunds_rec pay_cure_refunds_rec_type;
5328: cursor chk_refund_number(p_refund_header_number IN VARCHAR2) IS
5329: select refund_header_number
5330: from okl_cure_refund_headers_b
5331: where refund_header_number =p_refund_header_number;
5332:
5333: x_contract_number okc_k_headers_b.contract_number%TYPE;
5334:

Line 5476: select object_version_number from okl_cure_refund_headers_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
5476: select object_version_number from okl_cure_refund_headers_b
5477: where cure_refund_header_id =p_cure_refund_header_id;
5478:
5479:
5480: