APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_CNSLD_AR_HDRS_B

Line 2653: insert into okl_cnsld_ar_hdrs_b

2649: -- check table count
2650: if g_cnr_tbl.count > 0 then
2651: forall x in g_cnr_tbl.first..g_cnr_tbl.last
2652: save exceptions
2653: insert into okl_cnsld_ar_hdrs_b
2654: values g_cnr_tbl(x);
2655:
2656: forall d in g_cnr_tl_tbl.first..g_cnr_tl_tbl.last
2657: save exceptions

Line 2765: delete from okl_cnsld_ar_hdrs_b

2761: -- check table count
2762: if g_lln_tbl.count > 0 then
2763:
2764: for e in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
2765: delete from okl_cnsld_ar_hdrs_b
2766: where id = g_lln_tbl(e).cnr_id;
2767: end loop;
2768:
2769: end if; -- check table count

Line 2850: delete from okl_cnsld_ar_hdrs_b

2846: -- check table count
2847: if g_lln_tbl.count > 0 then
2848:
2849: for f in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
2850: delete from okl_cnsld_ar_hdrs_b
2851: where id = g_lln_tbl(f).cnr_id;
2852: end loop;
2853:
2854: end if; -- check table count

Line 3216: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;

3212: AND ity.inf_id = inf.id
3213: AND ilt.ity_id = ity.id
3214: AND inf.ilt_id = ilt.id;
3215:
3216: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;
3217: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;
3218: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
3219:
3220: l_old_cnr_id NUMBER;

Line 4408: insert into okl_cnsld_ar_hdrs_b

4404: savepoint H2;
4405: PRINT_TO_LOG('Performing bulk insert for cnr, record count is '||g_cnr_tbl.count);
4406: forall x in g_cnr_tbl.first..g_cnr_tbl.last
4407: save exceptions
4408: insert into okl_cnsld_ar_hdrs_b
4409: values g_cnr_tbl(x);
4410:
4411: forall d in g_cnr_tl_tbl.first..g_cnr_tl_tbl.last
4412: save exceptions

Line 4488: delete from okl_cnsld_ar_hdrs_b

4484: g_xls_tbl.DELETE;
4485: g_xls_tl_tbl.DELETE;
4486:
4487: for e in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
4488: delete from okl_cnsld_ar_hdrs_b
4489: where id = g_lln_tbl(e).cnr_id;
4490: end loop;
4491: g_lln_tbl.DELETE;
4492: commit;

Line 4552: delete from okl_cnsld_ar_hdrs_b

4548: g_xls_tl_tbl.DELETE;
4549:
4550: for e in g_lsm_tbl.FIRST..g_lsm_tbl.LAST loop
4551: for f in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
4552: delete from okl_cnsld_ar_hdrs_b
4553: where id = g_lln_tbl(f).cnr_id;
4554: end loop;
4555: delete from okl_cnsld_ar_lines_b
4556: where id = g_lsm_tbl(e).lln_id;

Line 4916: insert into okl_cnsld_ar_hdrs_b

4912: savepoint H2;
4913: PRINT_TO_LOG('Performing final bulk insert for cnr, record count is '||g_cnr_tbl.count);
4914: forall x in g_cnr_tbl.first..g_cnr_tbl.last
4915: save exceptions
4916: insert into okl_cnsld_ar_hdrs_b
4917: values g_cnr_tbl(x);
4918:
4919: forall d in g_cnr_tl_tbl.first..g_cnr_tl_tbl.last
4920: save exceptions

Line 4995: delete from okl_cnsld_ar_hdrs_b

4991: g_xls_tbl.DELETE;
4992: g_xls_tl_tbl.DELETE;
4993:
4994: for e in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
4995: delete from okl_cnsld_ar_hdrs_b
4996: where id = g_lln_tbl(e).cnr_id;
4997: end loop;
4998: g_lln_tbl.DELETE;
4999: commit;

Line 5058: delete from okl_cnsld_ar_hdrs_b

5054: g_xls_tl_tbl.DELETE;
5055:
5056: for e in g_lsm_tbl.FIRST..g_lsm_tbl.LAST loop
5057: for f in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
5058: delete from okl_cnsld_ar_hdrs_b
5059: where id = g_lln_tbl(f).cnr_id;
5060: end loop;
5061: delete from okl_cnsld_ar_lines_b
5062: where id = g_lsm_tbl(e).lln_id;