APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_CNSLD_AR_HDRS_V

Line 1924: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

1920: IS
1921:
1922: l_old_cnr_id NUMBER;
1923: l_old_lln_id NUMBER;
1924: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
1925: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
1926:
1927: BEGIN
1928:

Line 3123: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;

3119: l_stream_name VARCHAR2(150);
3120: i NUMBER;
3121: l_funct_return VARCHAR2(1);
3122:
3123: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
3124: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
3125: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
3126:
3127: l_update_tbl update_tbl_type;

Line 3124: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

3120: i NUMBER;
3121: l_funct_return VARCHAR2(1);
3122:
3123: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
3124: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
3125: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
3126:
3127: l_update_tbl update_tbl_type;
3128:

Line 4028: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;

4024: -- ssiruvol - Bug#5354130 - Added - End
4025:
4026: L_FETCH_SIZE NUMBER := 5000;
4027:
4028: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
4029: -- Billing performance fix
4030:
4031: CURSOR line_seq_csr(p_cnr_id NUMBER) IS
4032: SELECT *

Line 4160: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;

4156: l_err_cnt NUMBER;
4157: l_op_unit_name hr_operating_units.name%TYPE;
4158: lx_msg_data VARCHAR2(450);
4159: l_msg_index_out NUMBER :=0;
4160: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4161: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4162:
4163: -- -----------------------------
4164: -- New fields

Line 4161: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;

4157: l_op_unit_name hr_operating_units.name%TYPE;
4158: lx_msg_data VARCHAR2(450);
4159: l_msg_index_out NUMBER :=0;
4160: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4161: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4162:
4163: -- -----------------------------
4164: -- New fields
4165: -- -----------------------------

Line 4168: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

4164: -- New fields
4165: -- -----------------------------
4166: l_old_cnr_id NUMBER;
4167: l_old_lln_id NUMBER;
4168: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
4169: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
4170:
4171: x_cnrv_tbl Okl_Cnr_Pvt.cnrv_tbl_type;
4172: