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_OPI_PVT dependencies on OKL_OPEN_INT

Line 551: FROM Okl_Open_Int OIN

547: IOH.PROCESS_DATE,
548: IOH.EXT_AGNCY_ID,
549: IOH.REVIEW_DATE,
550: IOH.RECALL_DATE
551: FROM Okl_Open_Int OIN
552: ,Iex_Open_Int_Hst IOH
553: WHERE OIN.khr_id = TO_NUMBER(IOH.OBJECT1_ID1)
554: AND IOH.JTOT_OBJECT1_CODE = 'OKX_LEASE'
555: AND ((l_case_passed = Okc_Api.G_FALSE) OR

Line 673: okl_open_interface_pub.process_pending_int(p_api_version => l_api_version

669: l_iohv_rec.review_date,
670: l_iohv_rec.recall_date;
671: EXIT WHEN l_oin_pend_csr%NOTFOUND;
672: --dbms_output.put_line('Processing krd_id : ' || l_oinv_rec.khr_id);
673: okl_open_interface_pub.process_pending_int(p_api_version => l_api_version
674: ,p_init_msg_list => l_init_msg_list
675: ,p_oinv_rec => l_oinv_rec
676: ,p_iohv_rec => l_iohv_rec
677: ,x_oinv_rec => lx_oinv_rec

Line 751: FROM okl_open_int oin

747: ,ioh.id
748: ,ioh.object1_id1
749: ,ioh.object1_id2
750: ,ioh.jtot_object1_code
751: FROM okl_open_int oin
752: ,iex_open_int_hst ioh
753: WHERE oin.id = cp_interface_id
754: AND oin.khr_id = TO_NUMBER(ioh.object1_id1)
755: AND ioh.jtot_object1_code = 'OKX_LEASE'

Line 801: okl_open_int_pub.update_open_int(p_api_version => l_api_version

797:
798: l_iohv_rec.action := ACTION_REPORT_CB;
799: l_iohv_rec.status := STATUS_COMPLETE;
800:
801: okl_open_int_pub.update_open_int(p_api_version => l_api_version
802: ,p_init_msg_list => p_init_msg_list
803: ,x_return_status => l_return_status
804: ,x_msg_count => x_msg_count
805: ,x_msg_data => x_msg_data

Line 935: okl_open_int_pub.update_open_int(p_api_version => l_api_version

931:
932: l_iohv_rec.status := STATUS_COMPLETE;
933: l_iohv_rec.process_date := p_notification_date;
934:
935: okl_open_int_pub.update_open_int(p_api_version => l_api_version
936: ,p_init_msg_list => p_init_msg_list
937: ,x_return_status => l_return_status
938: ,x_msg_count => x_msg_count
939: ,x_msg_data => x_msg_data

Line 1037: FROM okl_open_int oin

1033: ,ioh.id
1034: ,ioh.object1_id1
1035: ,ioh.object1_id2
1036: ,ioh.jtot_object1_code
1037: FROM okl_open_int oin
1038: ,iex_open_int_hst ioh
1039: WHERE oin.id = cp_interface_id
1040: AND oin.khr_id = TO_NUMBER(ioh.object1_id1)
1041: AND ioh.jtot_object1_code = 'OKX_LEASE'

Line 1090: okl_open_int_pub.update_open_int(p_api_version => l_api_version

1086: --l_iohv_rec.transfer_days := null;
1087: --l_iohv_rec.extend_days := null;
1088:
1089:
1090: okl_open_int_pub.update_open_int(p_api_version => l_api_version
1091: ,p_init_msg_list => p_init_msg_list
1092: ,x_return_status => l_return_status
1093: ,x_msg_count => x_msg_count
1094: ,x_msg_data => x_msg_data

Line 1228: okl_open_int_pub.update_open_int(p_api_version => l_api_version

1224: l_iohv_rec.status := STATUS_COMPLETE;
1225: l_iohv_rec.process_date := p_notification_date;
1226:
1227: /*
1228: okl_open_int_pub.update_open_int(p_api_version => l_api_version
1229: ,p_init_msg_list => p_init_msg_list
1230: ,x_return_status => l_return_status
1231: ,x_msg_count => x_msg_count
1232: ,x_msg_data => x_msg_data

Line 1339: FROM okl_open_int oin

1335: ,ioh.object1_id1
1336: ,ioh.object1_id2
1337: ,ioh.jtot_object1_code
1338: ,ioh.ext_agncy_id
1339: FROM okl_open_int oin
1340: ,iex_open_int_hst ioh
1341: WHERE oin.id = cp_interface_id
1342: AND oin.khr_id = TO_NUMBER(ioh.object1_id1)
1343: AND ioh.jtot_object1_code = 'OKX_LEASE'

Line 1384: okl_open_int_pub.update_open_int(p_api_version => l_api_version

1380: l_iohv_rec.status := STATUS_RECALLED;
1381: l_iohv_rec.process_date := p_recall_date;
1382:
1383: l_oinv_rec.referral_number := nvl(l_oinv_rec.referral_number, 0) + 1;
1384: okl_open_int_pub.update_open_int(p_api_version => l_api_version
1385: ,p_init_msg_list => p_init_msg_list
1386: ,x_return_status => l_return_status
1387: ,x_msg_count => x_msg_count
1388: ,x_msg_data => x_msg_data

Line 1689: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;

1685: l_customer_id number;
1686: l_address_id number;
1687: l_start_date date;
1688:
1689: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
1690: l_contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE;
1691:
1692: v_miss_task_assign_tbl Jtf_Tasks_Pub.TASK_ASSIGN_TBL;
1693: v_miss_task_depends_tbl Jtf_Tasks_Pub.TASK_DEPENDS_TBL;

Line 1690: l_contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE;

1686: l_address_id number;
1687: l_start_date date;
1688:
1689: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
1690: l_contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE;
1691:
1692: v_miss_task_assign_tbl Jtf_Tasks_Pub.TASK_ASSIGN_TBL;
1693: v_miss_task_depends_tbl Jtf_Tasks_Pub.TASK_DEPENDS_TBL;
1694: v_miss_task_rsrc_req_tbl Jtf_Tasks_Pub.TASK_RSRC_REQ_TBL;

Line 1704: FROM OKL_OPEN_INT

1700:
1701: CURSOR l_oin_csr(cp_contract_id IN NUMBER) IS
1702: SELECT contract_number
1703: ,party_id
1704: FROM OKL_OPEN_INT
1705: WHERE khr_id = cp_contract_id;
1706:
1707: CURSOR l_task_type_csr IS
1708: SELECT TASK_TYPE_ID,

Line 1988: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

1984:
1985: l_oinv_rec oinv_rec_type;
1986: l_iohv_rec iohv_rec_type;
1987:
1988: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
1989: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
1990: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1991: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
1992: l_subject VARCHAR2(2000);

Line 1989: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;

1985: l_oinv_rec oinv_rec_type;
1986: l_iohv_rec iohv_rec_type;
1987:
1988: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
1989: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
1990: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1991: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
1992: l_subject VARCHAR2(2000);
1993: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;

Line 2014: FROM Okl_Open_Int OIN

2010: OIN.CAS_ID,
2011: OIN.PARTY_ID,
2012: OIN.PARTY_NAME,
2013: IOH.ID
2014: FROM Okl_Open_Int OIN
2015: ,Iex_Open_Int_Hst IOH
2016: WHERE OIN.khr_id = TO_NUMBER(IOH.object1_id1)
2017: AND IOH.jtot_object1_code = 'OKX_LEASE'
2018: AND (IOH.ACTION = ACTION_NOTIFY_CUST)

Line 2276: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

2272: l_iohv_rec iohv_rec_type;
2273: lp_iohv_rec iohv_rec_type;
2274: lx_iohv_rec iohv_rec_type;
2275:
2276: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
2277: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
2278: --l_extend_days IEX_OPEN_INT_HST.EXTEND_DAYS%TYPE;
2279: l_task_name JTF_TASKS_VL.TASK_NAME%TYPE;
2280: l_description JTF_TASKS_VL.DESCRIPTION%TYPE;

Line 2302: FROM Okl_Open_Int OIN

2298: IOH.REQUEST_DATE,
2299: IOH.PROCESS_DATE,
2300: IOH.EXT_AGNCY_ID,
2301: IOH.REVIEW_BEFORE_RECALL_FLAG
2302: FROM Okl_Open_Int OIN
2303: ,Iex_Open_Int_Hst IOH
2304: WHERE OIN.khr_id = TO_NUMBER(IOH.object1_id1)
2305: AND IOH.jtot_object1_code = 'OKX_LEASE'
2306: AND (IOH.ACTION = ACTION_TRANSFER_EXT_AGNCY)

Line 2583: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

2579:
2580: l_oinv_rec oinv_rec_type;
2581: l_iohv_rec iohv_rec_type;
2582:
2583: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
2584: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
2585: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
2586: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
2587: l_subject VARCHAR2(2000);

Line 2584: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;

2580: l_oinv_rec oinv_rec_type;
2581: l_iohv_rec iohv_rec_type;
2582:
2583: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
2584: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
2585: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
2586: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
2587: l_subject VARCHAR2(2000);
2588: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;

Line 2604: FROM Okl_Open_Int OIN

2600: SELECT OIN.ID,
2601: OIN.KHR_ID,
2602: IOH.ID,
2603: IOH.EXT_AGNCY_ID
2604: FROM Okl_Open_Int OIN
2605: ,Iex_Open_Int_Hst IOH
2606: WHERE OIN.khr_id = TO_NUMBER(IOH.object1_id1)
2607: AND IOH.jtot_object1_code = 'OKX_LEASE'
2608: AND (IOH.ACTION = ACTION_NOTIFY_EXT_AGNCY)

Line 2812: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;

2808: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2809: lx_msg_count NUMBER ;
2810: lx_msg_data VARCHAR2(2000);
2811:
2812: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
2813: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
2814: l_ext_agncy_id HZ_PARTIES.PARTY_ID%TYPE;
2815:
2816: l_contracts_recalled NUMBER := 0;

Line 2813: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;

2809: lx_msg_count NUMBER ;
2810: lx_msg_data VARCHAR2(2000);
2811:
2812: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
2813: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
2814: l_ext_agncy_id HZ_PARTIES.PARTY_ID%TYPE;
2815:
2816: l_contracts_recalled NUMBER := 0;
2817: l_rows_failed NUMBER := 0;

Line 2839: FROM Okl_Open_Int OIN

2835: IOH.OBJECT1_ID1,
2836: IOH.OBJECT1_ID2,
2837: IOH.JTOT_OBJECT1_CODE,
2838: IOH.EXT_AGNCY_ID
2839: FROM Okl_Open_Int OIN
2840: ,Iex_Open_Int_Hst IOH
2841: WHERE OIN.khr_id = TO_NUMBER(IOH.object1_id1)
2842: AND IOH.jtot_object1_code = 'OKX_LEASE'
2843: AND (IOH.ACTION = ACTION_TRANSFER_EXT_AGNCY)