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 5209: p_usage_item_name IN okx_system_items_v.name%TYPE,

5205: -- Called By:
5206: ------------------------------------------------------------------------------
5207: PROCEDURE get_usage_item_id(
5208: x_return_status OUT NOCOPY VARCHAR2,
5209: p_usage_item_name IN okx_system_items_v.name%TYPE,
5210: p_usage_item_id IN okx_system_items_v.id1%TYPE,
5211: p_org_id IN NUMBER,
5212: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,
5213: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE

Line 5210: p_usage_item_id IN okx_system_items_v.id1%TYPE,

5206: ------------------------------------------------------------------------------
5207: PROCEDURE get_usage_item_id(
5208: x_return_status OUT NOCOPY VARCHAR2,
5209: p_usage_item_name IN okx_system_items_v.name%TYPE,
5210: p_usage_item_id IN okx_system_items_v.id1%TYPE,
5211: p_org_id IN NUMBER,
5212: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,
5213: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE
5214: ) IS

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

5208: x_return_status OUT NOCOPY VARCHAR2,
5209: p_usage_item_name IN okx_system_items_v.name%TYPE,
5210: p_usage_item_id IN okx_system_items_v.id1%TYPE,
5211: p_org_id IN NUMBER,
5212: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,
5213: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE
5214: ) IS
5215:
5216: l_proc_name VARCHAR2(35) := 'GET_USAGE_ITEM_ID';

Line 5213: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE

5209: p_usage_item_name IN okx_system_items_v.name%TYPE,
5210: p_usage_item_id IN okx_system_items_v.id1%TYPE,
5211: p_org_id IN NUMBER,
5212: x_usage_item_id OUT NOCOPY okx_system_items_v.id1%TYPE,
5213: x_usage_id2 OUT NOCOPY okx_system_items_v.id2%TYPE
5214: ) IS
5215:
5216: l_proc_name VARCHAR2(35) := 'GET_USAGE_ITEM_ID';
5217: CURSOR uitem_csr (p_item_name VARCHAR2,

Line 5222: FROM okx_system_items_v

5218: p_item_id NUMBER,
5219: p_org_id NUMBER) IS
5220: SELECT id1,
5221: id2
5222: FROM okx_system_items_v
5223: WHERE usage_item_flag = 'Y'
5224: AND organization_id = p_org_id
5225: AND ((name = p_item_name
5226: AND

Line 5237: l_id1 okx_system_items_v.id1%TYPE;

5233: )
5234: );
5235:
5236: uitem_failed EXCEPTION;
5237: l_id1 okx_system_items_v.id1%TYPE;
5238: l_id2 okx_system_items_v.id2%TYPE;
5239:
5240: BEGIN
5241: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5238: l_id2 okx_system_items_v.id2%TYPE;

5234: );
5235:
5236: uitem_failed EXCEPTION;
5237: l_id1 okx_system_items_v.id1%TYPE;
5238: l_id2 okx_system_items_v.id2%TYPE;
5239:
5240: BEGIN
5241: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5242: OPEN uitem_csr(p_usage_item_name,

Line 5954: x_usage_item_id okx_system_items_v.id1%TYPE;

5950:
5951: x_lienholder_id NUMBER := NULL;
5952: x_title_issuer_id NUMBER := NULL;
5953: l_rgp_id NUMBER;
5954: x_usage_item_id okx_system_items_v.id1%TYPE;
5955: x_usage_id2 okx_system_items_v.id2%TYPE;
5956: x_base_uom_id okx_tuom_v.id1%TYPE;
5957: x_price_list_id okx_list_headers_v.id1%TYPE;
5958: x_stream_id okl_strmtyp_source_v.id1%TYPE;

Line 5955: x_usage_id2 okx_system_items_v.id2%TYPE;

5951: x_lienholder_id NUMBER := NULL;
5952: x_title_issuer_id NUMBER := NULL;
5953: l_rgp_id NUMBER;
5954: x_usage_item_id okx_system_items_v.id1%TYPE;
5955: x_usage_id2 okx_system_items_v.id2%TYPE;
5956: x_base_uom_id okx_tuom_v.id1%TYPE;
5957: x_price_list_id okx_list_headers_v.id1%TYPE;
5958: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5959: l_payment_term_id okx_payables_terms_v.id1%TYPE;

Line 22686: FROM okx_system_items_v

22682: CURSOR service_item_csr (p_inventory_org_id NUMBER,
22683: p_inventory_item_id NUMBER,
22684: p_inventory_item_name VARCHAR2) IS
22685: SELECT id1
22686: FROM okx_system_items_v
22687: WHERE ((name = p_inventory_item_name
22688: AND
22689: p_inventory_item_name IS NOT NULL)
22690: OR

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

24012: SELECT nvl(capital_amount , 0)
24013: from okl_k_lines
24014: where id = p_line_id;
24015:
24016: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,
24017: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS
24018: SELECT name
24019: FROM okx_system_items_v
24020: WHERE id1 = p_inv_item_id

Line 24017: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS

24013: from okl_k_lines
24014: where id = p_line_id;
24015:
24016: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,
24017: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS
24018: SELECT name
24019: FROM okx_system_items_v
24020: WHERE id1 = p_inv_item_id
24021: AND id2 = p_inv_org_id;

Line 24019: FROM okx_system_items_v

24015:
24016: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,
24017: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS
24018: SELECT name
24019: FROM okx_system_items_v
24020: WHERE id1 = p_inv_item_id
24021: AND id2 = p_inv_org_id;
24022:
24023: l_fee_vendor_name OKL_PARTY_ROLES_INTERFACE.FEES_VENDOR_NAME%TYPE;

Line 24026: l_service_item_name OKX_SYSTEM_ITEMS_V.NAME%TYPE;

24022:
24023: l_fee_vendor_name OKL_PARTY_ROLES_INTERFACE.FEES_VENDOR_NAME%TYPE;
24024: l_fee_vendor_id OKL_PARTY_ROLES_INTERFACE.FEES_VENDOR_ID%TYPE;
24025:
24026: l_service_item_name OKX_SYSTEM_ITEMS_V.NAME%TYPE;
24027:
24028: -- passthrough
24029: x_party_pmnt_hdr_tbl_out pphv_tbl_type;
24030: l_counter NUMBER;