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 2631: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,

2627: x_return_status OUT NOCOPY VARCHAR2,
2628: x_msg_count OUT NOCOPY NUMBER,
2629: x_msg_data OUT NOCOPY VARCHAR2,
2630: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
2631: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,
2632: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE
2633: ) IS
2634: /*
2635: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS

Line 2632: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE

2628: x_msg_count OUT NOCOPY NUMBER,
2629: x_msg_data OUT NOCOPY VARCHAR2,
2630: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
2631: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,
2632: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE
2633: ) IS
2634: /*
2635: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2636: SELECT id1,

Line 2638: FROM okx_tuom_v

2634: /*
2635: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2636: SELECT id1,
2637: uom_code
2638: FROM okx_tuom_v
2639: WHERE uom_class = 'OKL-TIME'
2640: AND base_uom_flag = 'N'
2641: AND name = p_payment_freq_code;
2642: */

Line 2649: l_id1 okx_tuom_v.id1%TYPE;

2645: id1
2646: FROM okl_time_units_v
2647: WHERE name = p_payment_freq_code;
2648:
2649: l_id1 okx_tuom_v.id1%TYPE;
2650: l_uom_code okx_tuom_v.uom_code%TYPE;
2651:
2652: BEGIN
2653:

Line 2650: l_uom_code okx_tuom_v.uom_code%TYPE;

2646: FROM okl_time_units_v
2647: WHERE name = p_payment_freq_code;
2648:
2649: l_id1 okx_tuom_v.id1%TYPE;
2650: l_uom_code okx_tuom_v.uom_code%TYPE;
2651:
2652: BEGIN
2653:
2654: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2738: x_id1 okx_tuom_v.id1%TYPE;

2734: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2735: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2736: ) IS
2737:
2738: x_id1 okx_tuom_v.id1%TYPE;
2739: x_id2 okl_strmtyp_source_v.id1%TYPE;
2740: x_uom_code okx_tuom_v.uom_code%TYPE;
2741: payment_failed EXCEPTION;
2742:

Line 2740: x_uom_code okx_tuom_v.uom_code%TYPE;

2736: ) IS
2737:
2738: x_id1 okx_tuom_v.id1%TYPE;
2739: x_id2 okl_strmtyp_source_v.id1%TYPE;
2740: x_uom_code okx_tuom_v.uom_code%TYPE;
2741: payment_failed EXCEPTION;
2742:
2743: l_return_status VARCHAR2(1);
2744: l_proc_name VARCHAR2(35) := 'check_payment_record';

Line 5107: p_base_uom_code IN okx_tuom_v.id1%TYPE,

5103: -- Called By:
5104: ------------------------------------------------------------------------------
5105: PROCEDURE get_base_uom_id(
5106: x_return_status OUT NOCOPY VARCHAR2,
5107: p_base_uom_code IN okx_tuom_v.id1%TYPE,
5108: x_base_uom_id OUT NOCOPY okx_tuom_v.id1%TYPE
5109: ) IS
5110: l_proc_name VARCHAR2(35) := 'GET_BASE_UOM_ID';
5111: CURSOR uom_csr (p_base_uom_code VARCHAR2) IS

Line 5108: x_base_uom_id OUT NOCOPY okx_tuom_v.id1%TYPE

5104: ------------------------------------------------------------------------------
5105: PROCEDURE get_base_uom_id(
5106: x_return_status OUT NOCOPY VARCHAR2,
5107: p_base_uom_code IN okx_tuom_v.id1%TYPE,
5108: x_base_uom_id OUT NOCOPY okx_tuom_v.id1%TYPE
5109: ) IS
5110: l_proc_name VARCHAR2(35) := 'GET_BASE_UOM_ID';
5111: CURSOR uom_csr (p_base_uom_code VARCHAR2) IS
5112: SELECT id1

Line 5113: FROM okx_tuom_v

5109: ) IS
5110: l_proc_name VARCHAR2(35) := 'GET_BASE_UOM_ID';
5111: CURSOR uom_csr (p_base_uom_code VARCHAR2) IS
5112: SELECT id1
5113: FROM okx_tuom_v
5114: WHERE uom_code = p_base_uom_code;
5115:
5116: uom_failed EXCEPTION;
5117: l_id okx_tuom_v.id1%TYPE;

Line 5117: l_id okx_tuom_v.id1%TYPE;

5113: FROM okx_tuom_v
5114: WHERE uom_code = p_base_uom_code;
5115:
5116: uom_failed EXCEPTION;
5117: l_id okx_tuom_v.id1%TYPE;
5118:
5119: BEGIN
5120: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5121: OPEN uom_csr(p_base_uom_code);

Line 5397: x_base_uom_id okx_tuom_v.id1%TYPE;

5393:
5394: x_lienholder_id NUMBER := NULL;
5395: x_title_issuer_id NUMBER := NULL;
5396: l_rgp_id NUMBER;
5397: x_base_uom_id okx_tuom_v.id1%TYPE;
5398: x_price_list_id okx_list_headers_v.id1%TYPE;
5399: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5400: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5401: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;

Line 5956: x_base_uom_id okx_tuom_v.id1%TYPE;

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

Line 22451: x_id1 okx_tuom_v.ID1%TYPE;

22447: p_rgp_id IN NUMBER
22448: ) IS
22449:
22450: l_proc_name VARCHAR2(35) := 'CREATE_PAYMENT_OTHER_RULES';
22451: x_id1 okx_tuom_v.ID1%TYPE;
22452: x_uom_code okx_tuom_v.uom_code%TYPE;
22453: pay_other_failed EXCEPTION;
22454:
22455: l_rulv_rec rulv_rec_type;

Line 22452: x_uom_code okx_tuom_v.uom_code%TYPE;

22448: ) IS
22449:
22450: l_proc_name VARCHAR2(35) := 'CREATE_PAYMENT_OTHER_RULES';
22451: x_id1 okx_tuom_v.ID1%TYPE;
22452: x_uom_code okx_tuom_v.uom_code%TYPE;
22453: pay_other_failed EXCEPTION;
22454:
22455: l_rulv_rec rulv_rec_type;
22456: x_rulv_rec rulv_rec_type;

Line 27286: x_pmnt_freq_id okx_tuom_v.id1%TYPE;

27282: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;
27283: l_pmnt_sch_num_prev NUMBER;
27284: l_start_date_prev DATE;
27285: l_number_of_periods_prev NUMBER;
27286: x_pmnt_freq_id okx_tuom_v.id1%TYPE;
27287: x_uom_code okx_tuom_v.uom_code%TYPE;
27288: l_mult_factor NUMBER;
27289: l_current_start_date DATE;
27290: x_install_site_id okx_party_site_uses_v.id1%TYPE;

Line 27287: x_uom_code okx_tuom_v.uom_code%TYPE;

27283: l_pmnt_sch_num_prev NUMBER;
27284: l_start_date_prev DATE;
27285: l_number_of_periods_prev NUMBER;
27286: x_pmnt_freq_id okx_tuom_v.id1%TYPE;
27287: x_uom_code okx_tuom_v.uom_code%TYPE;
27288: l_mult_factor NUMBER;
27289: l_current_start_date DATE;
27290: x_install_site_id okx_party_site_uses_v.id1%TYPE;
27291: l_rule_create_flag VARCHAR2(1) := 'Y';