APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_CNSLD_AR_LINES_V

Line 1925: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

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:
1929: -- rmunjulu R12 Fixes -- comment out entire code and put NULL

Line 2182: -- in okl_cnsld_ar_lines_v.This function is called when the

2178: p_msg_name => G_OTHERS);
2179: END create_new_invoice;
2180:
2181: --This function checks for the existence of an consolidated invoice line
2182: -- in okl_cnsld_ar_lines_v.This function is called when the
2183: -- group_by_assets flag is set to 'Y'
2184: PROCEDURE line_exist (p_cnr_id IN NUMBER,
2185: p_khr_id IN NUMBER,
2186: p_kle_id IN NUMBER,

Line 2228: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');

2224: g_lln_tbl(n).ilt_id = p_ilt_id and
2225: g_lln_tbl(n).sequence_number = p_sequence_number
2226: then
2227: PRINT_TO_LOG( '====> Using SQL in check_line1 ');
2228: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');
2229: PRINT_TO_LOG('=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
2230: PRINT_TO_LOG('=***********> khr_id = '||p_khr_id||' AND ');
2231: PRINT_TO_LOG('=***********> ilt_id = '||p_ilt_id||' AND ');
2232: PRINT_TO_LOG('=***********> sequence_number = '||p_sequence_number||';');

Line 2246: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');

2242: g_lln_tbl(n).ilt_id = p_ilt_id and
2243: g_lln_tbl(n).sequence_number = p_sequence_number
2244: then
2245: PRINT_TO_LOG( '====> Using SQL in check_line2 ');
2246: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');
2247: PRINT_TO_LOG('=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
2248: PRINT_TO_LOG('=***********> khr_id = '||p_khr_id||' AND ');
2249: PRINT_TO_LOG('=***********> kle_id = '||p_kle_id||' AND ');
2250: PRINT_TO_LOG('=***********> ilt_id = '||p_ilt_id||' AND ');

Line 2265: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');

2261: g_lln_tbl(n).ilt_id = p_ilt_id and
2262: g_lln_tbl(n).sequence_number = p_sequence_number
2263: then
2264: PRINT_TO_LOG( '====> Using SQL in check_line3 ');
2265: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');
2266: PRINT_TO_LOG('=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
2267: PRINT_TO_LOG('=***********> khr_id = '||p_khr_id||' AND ');
2268: PRINT_TO_LOG('=***********> kle_id is null AND ');
2269: PRINT_TO_LOG('=***********> ilt_id = '||p_ilt_id||' AND ');

Line 2280: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');

2276: g_lln_tbl(n).ilt_id = p_ilt_id and
2277: g_lln_tbl(n).sequence_number = p_sequence_number
2278: then
2279: PRINT_TO_LOG( '====> Using SQL in check_line4 ');
2280: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');
2281: PRINT_TO_LOG('=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
2282: PRINT_TO_LOG('=***********> ilt_id = '||p_ilt_id||' AND ');
2283: PRINT_TO_LOG('=***********> sequence_number = '||p_sequence_number||';');
2284: x_lln_id := g_lln_tbl(n).id;

Line 3125: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

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:
3129: l_kle_id NUMBER;

Line 4033: FROM okl_cnsld_ar_lines_v

4029: -- Billing performance fix
4030:
4031: CURSOR line_seq_csr(p_cnr_id NUMBER) IS
4032: SELECT *
4033: FROM okl_cnsld_ar_lines_v
4034: WHERE cnr_id = p_cnr_id
4035: ORDER BY sequence_number;
4036:
4037: l_cnr_id NUMBER;

Line 4169: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

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:
4173: -- fmiao - Bug#5232919 - Modified - Start