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_OPEN_INTERFACE_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 5377: p_usage_item_name IN okx_system_items_v.name%TYPE,

5373: -- Called By:
5374: ------------------------------------------------------------------------------
5375: PROCEDURE get_usage_item_id(
5376: x_return_status OUT NOCOPY VARCHAR2,
5377: p_usage_item_name IN okx_system_items_v.name%TYPE,
5378: p_usage_item_id IN okx_system_items_v.id1%TYPE,
5379: p_org_id IN NUMBER,
5380: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,
5381: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE

Line 5378: p_usage_item_id IN okx_system_items_v.id1%TYPE,

5374: ------------------------------------------------------------------------------
5375: PROCEDURE get_usage_item_id(
5376: x_return_status OUT NOCOPY VARCHAR2,
5377: p_usage_item_name IN okx_system_items_v.name%TYPE,
5378: p_usage_item_id IN okx_system_items_v.id1%TYPE,
5379: p_org_id IN NUMBER,
5380: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,
5381: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE
5382: ) IS

Line 5380: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,

5376: x_return_status OUT NOCOPY VARCHAR2,
5377: p_usage_item_name IN okx_system_items_v.name%TYPE,
5378: p_usage_item_id IN okx_system_items_v.id1%TYPE,
5379: p_org_id IN NUMBER,
5380: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,
5381: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE
5382: ) IS
5383:
5384: l_proc_name VARCHAR2(35) := 'GET_USAGE_ITEM_ID';

Line 5381: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE

5377: p_usage_item_name IN okx_system_items_v.name%TYPE,
5378: p_usage_item_id IN okx_system_items_v.id1%TYPE,
5379: p_org_id IN NUMBER,
5380: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,
5381: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE
5382: ) IS
5383:
5384: l_proc_name VARCHAR2(35) := 'GET_USAGE_ITEM_ID';
5385: CURSOR uitem_csr (p_item_name VARCHAR2,

Line 5390: FROM okx_system_items_v

5386: p_item_id NUMBER,
5387: p_org_id NUMBER) IS
5388: SELECT id1,
5389: id2
5390: FROM okx_system_items_v
5391: WHERE usage_item_flag = 'Y'
5392: AND organization_id = p_org_id
5393: AND ((name = p_item_name
5394: AND

Line 5405: l_id1 okx_system_items_v.id1%TYPE;

5401: )
5402: );
5403:
5404: uitem_failed EXCEPTION;
5405: l_id1 okx_system_items_v.id1%TYPE;
5406: l_id2 okx_system_items_v.id2%TYPE;
5407:
5408: BEGIN
5409: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5406: l_id2 okx_system_items_v.id2%TYPE;

5402: );
5403:
5404: uitem_failed EXCEPTION;
5405: l_id1 okx_system_items_v.id1%TYPE;
5406: l_id2 okx_system_items_v.id2%TYPE;
5407:
5408: BEGIN
5409: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5410: OPEN uitem_csr(p_usage_item_name,

Line 6122: x_usage_item_id okx_system_items_v.id1%TYPE;

6118:
6119: x_lienholder_id NUMBER := NULL;
6120: x_title_issuer_id NUMBER := NULL;
6121: l_rgp_id NUMBER;
6122: x_usage_item_id okx_system_items_v.id1%TYPE;
6123: x_usage_id2 okx_system_items_v.id2%TYPE;
6124: x_base_uom_id okx_tuom_v.id1%TYPE;
6125: x_price_list_id okx_list_headers_v.id1%TYPE;
6126: x_stream_id okl_strmtyp_source_v.id1%TYPE;

Line 6123: x_usage_id2 okx_system_items_v.id2%TYPE;

6119: x_lienholder_id NUMBER := NULL;
6120: x_title_issuer_id NUMBER := NULL;
6121: l_rgp_id NUMBER;
6122: x_usage_item_id okx_system_items_v.id1%TYPE;
6123: x_usage_id2 okx_system_items_v.id2%TYPE;
6124: x_base_uom_id okx_tuom_v.id1%TYPE;
6125: x_price_list_id okx_list_headers_v.id1%TYPE;
6126: x_stream_id okl_strmtyp_source_v.id1%TYPE;
6127: l_payment_term_id okx_payables_terms_v.id1%TYPE;

Line 22875: FROM okx_system_items_v

22871: CURSOR service_item_csr (p_inventory_org_id NUMBER,
22872: p_inventory_item_id NUMBER,
22873: p_inventory_item_name VARCHAR2) IS
22874: SELECT id1
22875: FROM okx_system_items_v
22876: WHERE ((name = p_inventory_item_name
22877: AND
22878: p_inventory_item_name IS NOT NULL)
22879: OR

Line 24223: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,

24219: SELECT nvl(capital_amount , 0)
24220: from okl_k_lines
24221: where id = p_line_id;
24222:
24223: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,
24224: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS
24225: SELECT name
24226: FROM okx_system_items_v
24227: WHERE id1 = p_inv_item_id

Line 24224: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS

24220: from okl_k_lines
24221: where id = p_line_id;
24222:
24223: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,
24224: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS
24225: SELECT name
24226: FROM okx_system_items_v
24227: WHERE id1 = p_inv_item_id
24228: AND id2 = p_inv_org_id;

Line 24226: FROM okx_system_items_v

24222:
24223: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,
24224: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS
24225: SELECT name
24226: FROM okx_system_items_v
24227: WHERE id1 = p_inv_item_id
24228: AND id2 = p_inv_org_id;
24229:
24230: l_fee_vendor_name OKL_PARTY_ROLES_INTERFACE.FEES_VENDOR_NAME%TYPE;

Line 24233: l_service_item_name OKX_SYSTEM_ITEMS_V.NAME%TYPE;

24229:
24230: l_fee_vendor_name OKL_PARTY_ROLES_INTERFACE.FEES_VENDOR_NAME%TYPE;
24231: l_fee_vendor_id OKL_PARTY_ROLES_INTERFACE.FEES_VENDOR_ID%TYPE;
24232:
24233: l_service_item_name OKX_SYSTEM_ITEMS_V.NAME%TYPE;
24234:
24235: -- passthrough
24236: x_party_pmnt_hdr_tbl_out pphv_tbl_type;
24237: l_counter NUMBER;