APPS.OKL_CONS_BILL dependencies on OKL_CNSLD_AR_LINES_B

Line 36: okl_cnsld_ar_lines_b lln,

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
40: lln.id = lsm.lln_id;

Line 44: FROM okl_cnsld_ar_lines_b lln,

40: lln.id = lsm.lln_id;
41:
42: CURSOR lln_amt_csr ( p_lln_id IN NUMBER ) IS
43: SELECT SUM(lsm.amount)
44: FROM okl_cnsld_ar_lines_b lln,
45: okl_cnsld_ar_strms_b lsm
46: WHERE lln.id = p_lln_id AND
47: lln.id = lsm.lln_id;
48:

Line 123: UPDATE okl_cnsld_ar_lines_b

119: OPEN lln_amt_csr( l_update_tbl(m).lln_id );
120: FETCH lln_amt_csr INTO l_lln_amount;
121: CLOSE lln_amt_csr;
122:
123: UPDATE okl_cnsld_ar_lines_b
124: SET amount = l_lln_amount,
125: last_update_date = sysdate,
126: last_updated_by = Fnd_Global.USER_ID,
127: last_update_login = Fnd_Global.LOGIN_ID

Line 234: DELETE FROM okl_cnsld_ar_lines_b

230:
231: END LOOP;
232:
233: FOR m in l_update_tbl.FIRST..l_update_tbl.LAST LOOP
234: DELETE FROM okl_cnsld_ar_lines_b
235: WHERE id = l_update_tbl(m).lln_id;
236:
237: DELETE FROM okl_cnsld_ar_lines_tl
238: WHERE id = l_update_tbl(m).lln_id;

Line 1097: okl_cnsld_ar_lines_b lln,

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
1101: lln.id = lsm.lln_id;

Line 1105: FROM okl_cnsld_ar_lines_b lln,

1101: lln.id = lsm.lln_id;
1102:
1103: CURSOR lln_amt_csr ( p_lln_id IN NUMBER ) IS
1104: SELECT SUM(lsm.amount)
1105: FROM okl_cnsld_ar_lines_b lln,
1106: okl_cnsld_ar_strms_b lsm
1107: WHERE lln.id = p_lln_id AND
1108: lln.id = lsm.lln_id;
1109:

Line 2098: okl_cnsld_ar_lines_b lln,

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
2102: lln.id = lsm.lln_id;

Line 2106: FROM okl_cnsld_ar_lines_b lln,

2102: lln.id = lsm.lln_id;
2103:
2104: CURSOR lln_amt_csr ( p_lln_id IN NUMBER ) IS
2105: SELECT SUM(lsm.amount)
2106: FROM okl_cnsld_ar_lines_b lln,
2107: okl_cnsld_ar_strms_b lsm
2108: WHERE lln.id = p_lln_id AND
2109: lln.id = lsm.lln_id;
2110:

Line 2893: UPDATE Okl_Cnsld_Ar_Lines_b

2889: u_llnv_rec.id := line_seq.id;
2890: u_llnv_rec.sequence_number := l_seq_num;
2891: u_llnv_rec.amount := l_line_amount;
2892:
2893: UPDATE Okl_Cnsld_Ar_Lines_b
2894: SET sequence_number = l_seq_num,
2895: amount = l_line_amount
2896: WHERE id = line_seq.id;
2897: