APPS.OKL_CONS_BILL dependencies on OKL_CNSLD_AR_HDRS_B

Line 35: FROM okl_cnsld_ar_hdrs_b cnr,

31: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
32:
33: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
34: SELECT SUM(lsm.amount)
35: FROM okl_cnsld_ar_hdrs_b cnr,
36: okl_cnsld_ar_lines_b lln,
37: okl_cnsld_ar_strms_b lsm
38: WHERE cnr.id = p_cnr_id AND
39: cnr.id = lln.cnr_id AND

Line 97: UPDATE okl_cnsld_ar_hdrs_b

93: OPEN cnr_amt_csr ( l_update_tbl(m).cnr_id );
94: FETCH cnr_amt_csr INTO l_cnr_amount;
95: CLOSE cnr_amt_csr;
96:
97: UPDATE okl_cnsld_ar_hdrs_b
98: SET trx_status_code = 'PROCESSED',
99: amount = l_cnr_amount,
100: last_update_date = sysdate,
101: last_updated_by = Fnd_Global.USER_ID,

Line 209: UPDATE okl_cnsld_ar_hdrs_b

205: l_old_cnr_id := -9;
206: FOR m in l_update_tbl.FIRST..l_update_tbl.LAST LOOP
207: IF l_update_tbl(m).cnr_id <> l_old_cnr_id THEN
208:
209: UPDATE okl_cnsld_ar_hdrs_b
210: SET trx_status_code = 'ERROR',
211: amount = l_cnr_amount,
212: last_update_date = sysdate,
213: last_updated_by = Fnd_Global.USER_ID,

Line 242: DELETE FROM okl_cnsld_ar_hdrs_b

238: WHERE id = l_update_tbl(m).lln_id;
239: END LOOP;
240:
241: FOR m in l_update_tbl.FIRST..l_update_tbl.LAST LOOP
242: DELETE FROM okl_cnsld_ar_hdrs_b
243: WHERE id = l_update_tbl(m).cnr_id;
244:
245: DELETE FROM okl_cnsld_ar_hdrs_tl
246: WHERE id = l_update_tbl(m).cnr_id;

Line 1086: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;

1082: AND ity.inf_id = inf.id
1083: AND ilt.ity_id = ity.id
1084: AND inf.ilt_id = ilt.id;
1085:
1086: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;
1087: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;
1088: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
1089:
1090: l_old_cnr_id NUMBER;

Line 1096: FROM okl_cnsld_ar_hdrs_b cnr,

1092: l_cnt NUMBER;
1093:
1094: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
1095: SELECT SUM(lsm.amount)
1096: FROM okl_cnsld_ar_hdrs_b cnr,
1097: okl_cnsld_ar_lines_b lln,
1098: okl_cnsld_ar_strms_b lsm
1099: WHERE cnr.id = p_cnr_id AND
1100: cnr.id = lln.cnr_id AND

Line 2097: FROM okl_cnsld_ar_hdrs_b cnr,

2093: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
2094:
2095: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
2096: SELECT SUM(lsm.amount)
2097: FROM okl_cnsld_ar_hdrs_b cnr,
2098: okl_cnsld_ar_lines_b lln,
2099: okl_cnsld_ar_strms_b lsm
2100: WHERE cnr.id = p_cnr_id AND
2101: cnr.id = lln.cnr_id AND

Line 2922: UPDATE Okl_Cnsld_Ar_Hdrs_b

2918: u_cnrv_rec.amount := l_consbill_amount;
2919: u_cnrv_rec.trx_status_code := 'PROCESSED';
2920: -- Start of wraper code generated automatically by Debug code generator for Okl_Cnsld_Ar_Hdrs_Pub.UPDATE_CNSLD_AR_HDRS
2921:
2922: UPDATE Okl_Cnsld_Ar_Hdrs_b
2923: SET amount = l_consbill_amount,
2924: trx_status_code = 'PROCESSED'
2925: WHERE id = l_cnr_id;
2926: