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.IEX_OPEN_INTERFACE_PUB dependencies on OKL_OPEN_INT

Line 111: okl_open_interface_pub.insert_pending_int(

107:
108: IF (l_jtot_object1_code = 'OKX_LEASE') THEN
109: --processing for 'contracts'
110: --insert into open interface table
111: okl_open_interface_pub.insert_pending_int(
112: p_api_version => l_api_version,
113: p_init_msg_list => l_init_msg_list,
114: p_contract_id => to_number(l_object1_id1),
115: x_oinv_rec => lx_oinv_rec,

Line 211: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

207: p_case_number IN VARCHAR2) AS
208:
209: lx_errbuf VARCHAR2(2000);
210: lx_retcode NUMBER;
211: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
212: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
213:
214: BEGIN
215:

Line 252: l_interface_id OKL_OPEN_INT.ID%TYPE;

248: l_return_status VARCHAR2(1);
249: l_msg_count NUMBER ;
250: l_msg_data VARCHAR2(2000);
251:
252: l_interface_id OKL_OPEN_INT.ID%TYPE;
253: l_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE;
254: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
255:
256: BEGIN

Line 253: l_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE;

249: l_msg_count NUMBER ;
250: l_msg_data VARCHAR2(2000);
251:
252: l_interface_id OKL_OPEN_INT.ID%TYPE;
253: l_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE;
254: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
255:
256: BEGIN
257:

Line 338: l_interface_id OKL_OPEN_INT.ID%TYPE;

334: l_return_status VARCHAR2(1);
335: l_msg_count NUMBER ;
336: l_msg_data VARCHAR2(2000);
337:
338: l_interface_id OKL_OPEN_INT.ID%TYPE;
339: l_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE;
340: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
341:
342: BEGIN

Line 339: l_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE;

335: l_msg_count NUMBER ;
336: l_msg_data VARCHAR2(2000);
337:
338: l_interface_id OKL_OPEN_INT.ID%TYPE;
339: l_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE;
340: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
341:
342: BEGIN
343:

Line 424: l_interface_id OKL_OPEN_INT.ID%TYPE;

420: l_return_status VARCHAR2(1);
421: l_msg_count NUMBER ;
422: l_msg_data VARCHAR2(2000);
423:
424: l_interface_id OKL_OPEN_INT.ID%TYPE;
425: l_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE;
426: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
427: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
428:

Line 425: l_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE;

421: l_msg_count NUMBER ;
422: l_msg_data VARCHAR2(2000);
423:
424: l_interface_id OKL_OPEN_INT.ID%TYPE;
425: l_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE;
426: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
427: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
428:
429: BEGIN

Line 598: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

594:
595: lx_errbuf VARCHAR2(2000);
596: lx_retcode NUMBER;
597: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
598: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
599: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
600: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
601: l_subject VARCHAR2(2000);
602: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;

Line 650: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

646:
647: lx_errbuf VARCHAR2(2000);
648: lx_retcode NUMBER;
649: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
650: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
651:
652: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
653: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
654: BEGIN

Line 695: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

691: p_email IN VARCHAR2) AS
692:
693: lx_errbuf VARCHAR2(2000);
694: lx_retcode NUMBER;
695: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
696: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
697:
698: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
699: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

Line 749: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

745: p_comments IN VARCHAR2) AS
746:
747: lx_errbuf VARCHAR2(2000);
748: lx_retcode NUMBER;
749: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
750: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
751:
752: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
753: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;