APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_CNSLD_AR_HDRS_B

Line 2589: insert into okl_cnsld_ar_hdrs_b

2585: -- check table count
2586: if g_cnr_tbl.count > 0 then
2587: forall x in g_cnr_tbl.first..g_cnr_tbl.last
2588: save exceptions
2589: insert into okl_cnsld_ar_hdrs_b
2590: values g_cnr_tbl(x);
2591:
2592: forall d in g_cnr_tl_tbl.first..g_cnr_tl_tbl.last
2593: save exceptions

Line 2701: delete from okl_cnsld_ar_hdrs_b

2697: -- check table count
2698: if g_lln_tbl.count > 0 then
2699:
2700: for e in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
2701: delete from okl_cnsld_ar_hdrs_b
2702: where id = g_lln_tbl(e).cnr_id;
2703: end loop;
2704:
2705: end if; -- check table count

Line 2786: delete from okl_cnsld_ar_hdrs_b

2782: -- check table count
2783: if g_lln_tbl.count > 0 then
2784:
2785: for f in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
2786: delete from okl_cnsld_ar_hdrs_b
2787: where id = g_lln_tbl(f).cnr_id;
2788: end loop;
2789:
2790: end if; -- check table count

Line 3152: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;

3148: AND ity.inf_id = inf.id
3149: AND ilt.ity_id = ity.id
3150: AND inf.ilt_id = ilt.id;
3151:
3152: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;
3153: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;
3154: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
3155:
3156: l_old_cnr_id NUMBER;

Line 4344: insert into okl_cnsld_ar_hdrs_b

4340: savepoint H2;
4341: PRINT_TO_LOG('Performing bulk insert for cnr, record count is '||g_cnr_tbl.count);
4342: forall x in g_cnr_tbl.first..g_cnr_tbl.last
4343: save exceptions
4344: insert into okl_cnsld_ar_hdrs_b
4345: values g_cnr_tbl(x);
4346:
4347: forall d in g_cnr_tl_tbl.first..g_cnr_tl_tbl.last
4348: save exceptions

Line 4424: delete from okl_cnsld_ar_hdrs_b

4420: g_xls_tbl.DELETE;
4421: g_xls_tl_tbl.DELETE;
4422:
4423: for e in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
4424: delete from okl_cnsld_ar_hdrs_b
4425: where id = g_lln_tbl(e).cnr_id;
4426: end loop;
4427: g_lln_tbl.DELETE;
4428: commit;

Line 4488: delete from okl_cnsld_ar_hdrs_b

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

Line 4852: insert into okl_cnsld_ar_hdrs_b

4848: savepoint H2;
4849: PRINT_TO_LOG('Performing final bulk insert for cnr, record count is '||g_cnr_tbl.count);
4850: forall x in g_cnr_tbl.first..g_cnr_tbl.last
4851: save exceptions
4852: insert into okl_cnsld_ar_hdrs_b
4853: values g_cnr_tbl(x);
4854:
4855: forall d in g_cnr_tl_tbl.first..g_cnr_tl_tbl.last
4856: save exceptions

Line 4931: delete from okl_cnsld_ar_hdrs_b

4927: g_xls_tbl.DELETE;
4928: g_xls_tl_tbl.DELETE;
4929:
4930: for e in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
4931: delete from okl_cnsld_ar_hdrs_b
4932: where id = g_lln_tbl(e).cnr_id;
4933: end loop;
4934: g_lln_tbl.DELETE;
4935: commit;

Line 4994: delete from okl_cnsld_ar_hdrs_b

4990: g_xls_tl_tbl.DELETE;
4991:
4992: for e in g_lsm_tbl.FIRST..g_lsm_tbl.LAST loop
4993: for f in g_lln_tbl.FIRST..g_lln_tbl.LAST loop
4994: delete from okl_cnsld_ar_hdrs_b
4995: where id = g_lln_tbl(f).cnr_id;
4996: end loop;
4997: delete from okl_cnsld_ar_lines_b
4998: where id = g_lsm_tbl(e).lln_id;