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_BILLING_CONTROLLER_PVT dependencies on OKL_CNSLD_AR_HDRS_V

Line 1860: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

1856: IS
1857:
1858: l_old_cnr_id NUMBER;
1859: l_old_lln_id NUMBER;
1860: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
1861: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
1862:
1863: BEGIN
1864:

Line 3059: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;

3055: l_stream_name VARCHAR2(150);
3056: i NUMBER;
3057: l_funct_return VARCHAR2(1);
3058:
3059: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
3060: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
3061: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
3062:
3063: l_update_tbl update_tbl_type;

Line 3060: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

3056: i NUMBER;
3057: l_funct_return VARCHAR2(1);
3058:
3059: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
3060: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
3061: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
3062:
3063: l_update_tbl update_tbl_type;
3064:

Line 3964: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;

3960: -- ssiruvol - Bug#5354130 - Added - End
3961:
3962: L_FETCH_SIZE NUMBER := 5000;
3963:
3964: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
3965: -- Billing performance fix
3966:
3967: CURSOR line_seq_csr(p_cnr_id NUMBER) IS
3968: SELECT *

Line 4096: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;

4092: l_err_cnt NUMBER;
4093: l_op_unit_name hr_operating_units.name%TYPE;
4094: lx_msg_data VARCHAR2(450);
4095: l_msg_index_out NUMBER :=0;
4096: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4097: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4098:
4099: -- -----------------------------
4100: -- New fields

Line 4097: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;

4093: l_op_unit_name hr_operating_units.name%TYPE;
4094: lx_msg_data VARCHAR2(450);
4095: l_msg_index_out NUMBER :=0;
4096: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4097: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4098:
4099: -- -----------------------------
4100: -- New fields
4101: -- -----------------------------

Line 4104: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

4100: -- New fields
4101: -- -----------------------------
4102: l_old_cnr_id NUMBER;
4103: l_old_lln_id NUMBER;
4104: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
4105: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
4106:
4107: x_cnrv_tbl Okl_Cnr_Pvt.cnrv_tbl_type;
4108: