APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_CNSLD_AR_LINES_V

Line 1861: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

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

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

2114: p_msg_name => G_OTHERS);
2115: END create_new_invoice;
2116:
2117: --This function checks for the existence of an consolidated invoice line
2118: -- in okl_cnsld_ar_lines_v.This function is called when the
2119: -- group_by_assets flag is set to 'Y'
2120: PROCEDURE line_exist (p_cnr_id IN NUMBER,
2121: p_khr_id IN NUMBER,
2122: p_kle_id IN NUMBER,

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

2160: g_lln_tbl(n).ilt_id = p_ilt_id and
2161: g_lln_tbl(n).sequence_number = p_sequence_number
2162: then
2163: PRINT_TO_LOG( '====> Using SQL in check_line1 ');
2164: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');
2165: PRINT_TO_LOG('=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
2166: PRINT_TO_LOG('=***********> khr_id = '||p_khr_id||' AND ');
2167: PRINT_TO_LOG('=***********> ilt_id = '||p_ilt_id||' AND ');
2168: PRINT_TO_LOG('=***********> sequence_number = '||p_sequence_number||';');

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

2178: g_lln_tbl(n).ilt_id = p_ilt_id and
2179: g_lln_tbl(n).sequence_number = p_sequence_number
2180: then
2181: PRINT_TO_LOG( '====> Using SQL in check_line2 ');
2182: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');
2183: PRINT_TO_LOG('=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
2184: PRINT_TO_LOG('=***********> khr_id = '||p_khr_id||' AND ');
2185: PRINT_TO_LOG('=***********> kle_id = '||p_kle_id||' AND ');
2186: PRINT_TO_LOG('=***********> ilt_id = '||p_ilt_id||' AND ');

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

2197: g_lln_tbl(n).ilt_id = p_ilt_id and
2198: g_lln_tbl(n).sequence_number = p_sequence_number
2199: then
2200: PRINT_TO_LOG( '====> Using SQL in check_line3 ');
2201: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');
2202: PRINT_TO_LOG('=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
2203: PRINT_TO_LOG('=***********> khr_id = '||p_khr_id||' AND ');
2204: PRINT_TO_LOG('=***********> kle_id is null AND ');
2205: PRINT_TO_LOG('=***********> ilt_id = '||p_ilt_id||' AND ');

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

2212: g_lln_tbl(n).ilt_id = p_ilt_id and
2213: g_lln_tbl(n).sequence_number = p_sequence_number
2214: then
2215: PRINT_TO_LOG( '====> Using SQL in check_line4 ');
2216: PRINT_TO_LOG('=***********> SELECT id FROM okl_cnsld_ar_lines_v');
2217: PRINT_TO_LOG('=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
2218: PRINT_TO_LOG('=***********> ilt_id = '||p_ilt_id||' AND ');
2219: PRINT_TO_LOG('=***********> sequence_number = '||p_sequence_number||';');
2220: x_lln_id := g_lln_tbl(n).id;

Line 3061: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

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

Line 3969: FROM okl_cnsld_ar_lines_v

3965: -- Billing performance fix
3966:
3967: CURSOR line_seq_csr(p_cnr_id NUMBER) IS
3968: SELECT *
3969: FROM okl_cnsld_ar_lines_v
3970: WHERE cnr_id = p_cnr_id
3971: ORDER BY sequence_number;
3972:
3973: l_cnr_id NUMBER;

Line 4105: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

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