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 IEX_OPEN_INT_HST

Line 57: l_object1_id1 IEX_OPEN_INT_HST.OBJECT1_ID1%TYPE;

53:
54: lp_oinv_rec oinv_rec_type;
55: lx_oinv_rec oinv_rec_type;
56:
57: l_object1_id1 IEX_OPEN_INT_HST.OBJECT1_ID1%TYPE;
58: l_object1_id2 IEX_OPEN_INT_HST.OBJECT1_ID2%TYPE;
59: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;
61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;

Line 58: l_object1_id2 IEX_OPEN_INT_HST.OBJECT1_ID2%TYPE;

54: lp_oinv_rec oinv_rec_type;
55: lx_oinv_rec oinv_rec_type;
56:
57: l_object1_id1 IEX_OPEN_INT_HST.OBJECT1_ID1%TYPE;
58: l_object1_id2 IEX_OPEN_INT_HST.OBJECT1_ID2%TYPE;
59: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;
61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;
62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;

Line 59: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;

55: lx_oinv_rec oinv_rec_type;
56:
57: l_object1_id1 IEX_OPEN_INT_HST.OBJECT1_ID1%TYPE;
58: l_object1_id2 IEX_OPEN_INT_HST.OBJECT1_ID2%TYPE;
59: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;
61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;
62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;

Line 60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;

56:
57: l_object1_id1 IEX_OPEN_INT_HST.OBJECT1_ID1%TYPE;
58: l_object1_id2 IEX_OPEN_INT_HST.OBJECT1_ID2%TYPE;
59: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;
61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;
62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;

Line 61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;

57: l_object1_id1 IEX_OPEN_INT_HST.OBJECT1_ID1%TYPE;
58: l_object1_id2 IEX_OPEN_INT_HST.OBJECT1_ID2%TYPE;
59: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;
61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;
62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;
65: l_recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE;

Line 62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;

58: l_object1_id2 IEX_OPEN_INT_HST.OBJECT1_ID2%TYPE;
59: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;
61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;
62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;
65: l_recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE;
66: l_automatic_recall_flag IEX_OPEN_INT_HST.AUTOMATIC_RECALL_FLAG%TYPE;

Line 63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;

59: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;
61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;
62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;
65: l_recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE;
66: l_automatic_recall_flag IEX_OPEN_INT_HST.AUTOMATIC_RECALL_FLAG%TYPE;
67: l_review_before_recall_flag IEX_OPEN_INT_HST.REVIEW_BEFORE_RECALL_FLAG%TYPE;

Line 64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;

60: l_action IEX_OPEN_INT_HST.ACTION%TYPE;
61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;
62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;
65: l_recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE;
66: l_automatic_recall_flag IEX_OPEN_INT_HST.AUTOMATIC_RECALL_FLAG%TYPE;
67: l_review_before_recall_flag IEX_OPEN_INT_HST.REVIEW_BEFORE_RECALL_FLAG%TYPE;
68:

Line 65: l_recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE;

61: l_status IEX_OPEN_INT_HST.STATUS%TYPE;
62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;
65: l_recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE;
66: l_automatic_recall_flag IEX_OPEN_INT_HST.AUTOMATIC_RECALL_FLAG%TYPE;
67: l_review_before_recall_flag IEX_OPEN_INT_HST.REVIEW_BEFORE_RECALL_FLAG%TYPE;
68:
69: BEGIN

Line 66: l_automatic_recall_flag IEX_OPEN_INT_HST.AUTOMATIC_RECALL_FLAG%TYPE;

62: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;
63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;
65: l_recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE;
66: l_automatic_recall_flag IEX_OPEN_INT_HST.AUTOMATIC_RECALL_FLAG%TYPE;
67: l_review_before_recall_flag IEX_OPEN_INT_HST.REVIEW_BEFORE_RECALL_FLAG%TYPE;
68:
69: BEGIN
70:

Line 67: l_review_before_recall_flag IEX_OPEN_INT_HST.REVIEW_BEFORE_RECALL_FLAG%TYPE;

63: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
64: l_review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE;
65: l_recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE;
66: l_automatic_recall_flag IEX_OPEN_INT_HST.AUTOMATIC_RECALL_FLAG%TYPE;
67: l_review_before_recall_flag IEX_OPEN_INT_HST.REVIEW_BEFORE_RECALL_FLAG%TYPE;
68:
69: BEGIN
70:
71: SAVEPOINT insert_pending;

Line 212: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;

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:
216: l_jtot_object1_code := p_jtot_object1_code;

Line 254: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;

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:
258: SAVEPOINT complete_report_cb;

Line 340: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;

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:
344: SAVEPOINT complete_transfer;

Line 426: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;

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
430:

Line 427: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;

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
430:
431: SAVEPOINT recall_transfer;

Line 597: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;

593: p_email IN VARCHAR2) AS
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);

Line 649: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;

645: p_comments IN VARCHAR2) AS
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;

Line 652: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;

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
655:
656: l_jtot_object1_code := p_jtot_object1_code;

Line 653: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;

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
655:
656: l_jtot_object1_code := p_jtot_object1_code;
657: l_case_number := p_case_number;

Line 696: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;

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;
700: l_subject VARCHAR2(2000);

Line 698: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;

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;
700: l_subject VARCHAR2(2000);
701: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;
702: l_from VARCHAR2(2000);

Line 750: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;

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;
754: BEGIN

Line 752: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;

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;
754: BEGIN
755:
756: l_jtot_object1_code := p_jtot_object1_code;

Line 753: l_comments IEX_OPEN_INT_HST.COMMENTS%TYPE;

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;
754: BEGIN
755:
756: l_jtot_object1_code := p_jtot_object1_code;
757: l_case_number := p_case_number;