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 HR_OPERATING_UNITS

Line 60: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;

56: l_cust_reported NUMBER := 0;
57: l_cust_not_reported NUMBER := 0;
58: l_syndicate_flag VARCHAR2(1) := 'N';
59:
60: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
61:
62: CURSOR l_report_all_csr(cp_organization_id IN NUMBER) IS
63: SELECT id
64: FROM okc_k_headers_v

Line 456: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;

452: l_rows_processed NUMBER := 0;
453: l_rows_failed NUMBER := 0;
454:
455: l_case_passed VARCHAR2(1) := Okc_Api.G_TRUE;
456: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
457:
458: CURSOR l_oin_pend_csr(cp_case_number IN VARCHAR2
459: ,cp_organization_id IN NUMBER) IS
460: SELECT OIN.ID,

Line 2001: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;

1997: l_task_name JTF_TASKS_VL.TASK_NAME%TYPE;
1998: l_description JTF_TASKS_VL.DESCRIPTION%TYPE;
1999: l_start_date Date;
2000:
2001: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
2002: l_party_passed VARCHAR2(1) := Okc_Api.G_TRUE;
2003: l_case_passed VARCHAR2(1) := Okc_Api.G_TRUE;
2004:
2005: CURSOR l_notify_csr(cp_case_number IN VARCHAR2

Line 2282: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_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;
2281:
2282: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
2283: l_case_passed VARCHAR2(1) := Okc_Api.G_TRUE;
2284: l_ext_agncy_passed VARCHAR2(1) := Okc_Api.G_TRUE;
2285:
2286: CURSOR l_recall_csr(cp_case_number IN VARCHAR2

Line 2593: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;

2589: l_from VARCHAR2(2000);
2590: l_agent_id NUMBER;
2591: l_request_id NUMBER;
2592:
2593: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
2594: l_ext_agncy_passed VARCHAR2(1) := Okc_Api.G_TRUE;
2595: l_case_passed VARCHAR2(1) := Okc_Api.G_TRUE;
2596:
2597: CURSOR l_notify_csr(cp_case_number IN VARCHAR2

Line 2825: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;

2821: l_iohv_rec iohv_rec_type;
2822: lp_iohv_rec iohv_rec_type;
2823: lx_iohv_rec iohv_rec_type;
2824:
2825: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
2826: l_case_passed VARCHAR2(1) := Okc_Api.G_TRUE;
2827: l_ext_agncy_passed VARCHAR2(1) := Okc_Api.G_TRUE;
2828:
2829: CURSOR l_recall_csr(cp_case_number IN VARCHAR2