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_TUOM_V

Line 2796: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,

2792: x_return_status OUT NOCOPY VARCHAR2,
2793: x_msg_count OUT NOCOPY NUMBER,
2794: x_msg_data OUT NOCOPY VARCHAR2,
2795: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
2796: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,
2797: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE
2798: ) IS
2799: /*
2800: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS

Line 2797: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE

2793: x_msg_count OUT NOCOPY NUMBER,
2794: x_msg_data OUT NOCOPY VARCHAR2,
2795: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
2796: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,
2797: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE
2798: ) IS
2799: /*
2800: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2801: SELECT id1,

Line 2803: FROM okx_tuom_v

2799: /*
2800: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2801: SELECT id1,
2802: uom_code
2803: FROM okx_tuom_v
2804: WHERE uom_class = 'OKL-TIME'
2805: AND base_uom_flag = 'N'
2806: AND name = p_payment_freq_code;
2807: */

Line 2814: l_id1 okx_tuom_v.id1%TYPE;

2810: id1
2811: FROM okl_time_units_v
2812: WHERE name = p_payment_freq_code;
2813:
2814: l_id1 okx_tuom_v.id1%TYPE;
2815: l_uom_code okx_tuom_v.uom_code%TYPE;
2816:
2817: BEGIN
2818:

Line 2815: l_uom_code okx_tuom_v.uom_code%TYPE;

2811: FROM okl_time_units_v
2812: WHERE name = p_payment_freq_code;
2813:
2814: l_id1 okx_tuom_v.id1%TYPE;
2815: l_uom_code okx_tuom_v.uom_code%TYPE;
2816:
2817: BEGIN
2818:
2819: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2903: x_id1 okx_tuom_v.id1%TYPE;

2899: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2900: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2901: ) IS
2902:
2903: x_id1 okx_tuom_v.id1%TYPE;
2904: x_id2 okl_strmtyp_source_v.id1%TYPE;
2905: x_uom_code okx_tuom_v.uom_code%TYPE;
2906: payment_failed EXCEPTION;
2907:

Line 2905: x_uom_code okx_tuom_v.uom_code%TYPE;

2901: ) IS
2902:
2903: x_id1 okx_tuom_v.id1%TYPE;
2904: x_id2 okl_strmtyp_source_v.id1%TYPE;
2905: x_uom_code okx_tuom_v.uom_code%TYPE;
2906: payment_failed EXCEPTION;
2907:
2908: l_return_status VARCHAR2(1);
2909: l_proc_name VARCHAR2(35) := 'check_payment_record';

Line 5275: p_base_uom_code IN okx_tuom_v.id1%TYPE,

5271: -- Called By:
5272: ------------------------------------------------------------------------------
5273: PROCEDURE get_base_uom_id(
5274: x_return_status OUT NOCOPY VARCHAR2,
5275: p_base_uom_code IN okx_tuom_v.id1%TYPE,
5276: x_base_uom_id OUT NOCOPY okx_tuom_v.id1%TYPE
5277: ) IS
5278: l_proc_name VARCHAR2(35) := 'GET_BASE_UOM_ID';
5279: CURSOR uom_csr (p_base_uom_code VARCHAR2) IS

Line 5276: x_base_uom_id OUT NOCOPY okx_tuom_v.id1%TYPE

5272: ------------------------------------------------------------------------------
5273: PROCEDURE get_base_uom_id(
5274: x_return_status OUT NOCOPY VARCHAR2,
5275: p_base_uom_code IN okx_tuom_v.id1%TYPE,
5276: x_base_uom_id OUT NOCOPY okx_tuom_v.id1%TYPE
5277: ) IS
5278: l_proc_name VARCHAR2(35) := 'GET_BASE_UOM_ID';
5279: CURSOR uom_csr (p_base_uom_code VARCHAR2) IS
5280: SELECT id1

Line 5281: FROM okx_tuom_v

5277: ) IS
5278: l_proc_name VARCHAR2(35) := 'GET_BASE_UOM_ID';
5279: CURSOR uom_csr (p_base_uom_code VARCHAR2) IS
5280: SELECT id1
5281: FROM okx_tuom_v
5282: WHERE uom_code = p_base_uom_code;
5283:
5284: uom_failed EXCEPTION;
5285: l_id okx_tuom_v.id1%TYPE;

Line 5285: l_id okx_tuom_v.id1%TYPE;

5281: FROM okx_tuom_v
5282: WHERE uom_code = p_base_uom_code;
5283:
5284: uom_failed EXCEPTION;
5285: l_id okx_tuom_v.id1%TYPE;
5286:
5287: BEGIN
5288: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5289: OPEN uom_csr(p_base_uom_code);

Line 5565: x_base_uom_id okx_tuom_v.id1%TYPE;

5561:
5562: x_lienholder_id NUMBER := NULL;
5563: x_title_issuer_id NUMBER := NULL;
5564: l_rgp_id NUMBER;
5565: x_base_uom_id okx_tuom_v.id1%TYPE;
5566: x_price_list_id okx_list_headers_v.id1%TYPE;
5567: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5568: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5569: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;

Line 6124: x_base_uom_id okx_tuom_v.id1%TYPE;

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;
6128: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;

Line 22638: x_id1 okx_tuom_v.ID1%TYPE;

22634: p_rgp_id IN NUMBER
22635: ) IS
22636:
22637: l_proc_name VARCHAR2(35) := 'CREATE_PAYMENT_OTHER_RULES';
22638: x_id1 okx_tuom_v.ID1%TYPE;
22639: x_uom_code okx_tuom_v.uom_code%TYPE;
22640: pay_other_failed EXCEPTION;
22641:
22642: l_rulv_rec rulv_rec_type;

Line 22639: x_uom_code okx_tuom_v.uom_code%TYPE;

22635: ) IS
22636:
22637: l_proc_name VARCHAR2(35) := 'CREATE_PAYMENT_OTHER_RULES';
22638: x_id1 okx_tuom_v.ID1%TYPE;
22639: x_uom_code okx_tuom_v.uom_code%TYPE;
22640: pay_other_failed EXCEPTION;
22641:
22642: l_rulv_rec rulv_rec_type;
22643: x_rulv_rec rulv_rec_type;

Line 27558: x_pmnt_freq_id okx_tuom_v.id1%TYPE;

27554: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;
27555: l_pmnt_sch_num_prev NUMBER;
27556: l_start_date_prev DATE;
27557: l_number_of_periods_prev NUMBER;
27558: x_pmnt_freq_id okx_tuom_v.id1%TYPE;
27559: x_uom_code okx_tuom_v.uom_code%TYPE;
27560: l_mult_factor NUMBER;
27561: l_current_start_date DATE;
27562: x_install_site_id okx_party_site_uses_v.id1%TYPE;

Line 27559: x_uom_code okx_tuom_v.uom_code%TYPE;

27555: l_pmnt_sch_num_prev NUMBER;
27556: l_start_date_prev DATE;
27557: l_number_of_periods_prev NUMBER;
27558: x_pmnt_freq_id okx_tuom_v.id1%TYPE;
27559: x_uom_code okx_tuom_v.uom_code%TYPE;
27560: l_mult_factor NUMBER;
27561: l_current_start_date DATE;
27562: x_install_site_id okx_party_site_uses_v.id1%TYPE;
27563: l_rule_create_flag VARCHAR2(1) := 'Y';