DBA Data[Home] [Help]

APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_CNSLD_AR_STRMS_B

Line 2820: insert into okl_cnsld_ar_strms_b

2816: BEGIN
2817: savepoint D1;
2818: forall x in g_lsm_tbl.first..g_lsm_tbl.last
2819: save exceptions
2820: insert into okl_cnsld_ar_strms_b
2821: values g_lsm_tbl(x);
2822:
2823: forall f in g_lsm_tl_tbl.first..g_lsm_tl_tbl.last
2824: save exceptions

Line 3156: OKL_CNSLD_AR_STRMS_B LSM

3152: OKC_LINE_STYLES_b SUB_LSE,
3153: OKC_K_ITEMS CIM,
3154: OKC_K_LINES_V FA,
3155: OKC_LINE_STYLES_B AST_LSE,
3156: OKL_CNSLD_AR_STRMS_B LSM
3157: WHERE
3158: CHR.ID = TOP_CLE.DNZ_CHR_ID AND
3159: TOP_CLE.LSE_ID = TOP_LSE.ID AND
3160: TOP_LSE.LTY_CODE IN('SOLD_SERVICE','FEE') AND

Line 4129: FROM okl_cnsld_ar_strms_b

4125: l_temp_khr_id NUMBER;
4126:
4127: CURSOR get_khr_id ( p_lsm_id NUMBER ) IS
4128: SELECT khr_id
4129: FROM okl_cnsld_ar_strms_b
4130: WHERE id = p_lsm_id;
4131:
4132:
4133: -- Variable to track commit record size

Line 4529: insert into okl_cnsld_ar_strms_b

4525: savepoint D2;
4526: PRINT_TO_LOG('Performing bulk insert for lsm, record count is '||g_lsm_tbl.count);
4527: forall x in g_lsm_tbl.first..g_lsm_tbl.last
4528: save exceptions
4529: insert into okl_cnsld_ar_strms_b
4530: values g_lsm_tbl(x);
4531:
4532: forall f in g_lsm_tl_tbl.first..g_lsm_tl_tbl.last
4533: save exceptions

Line 5035: insert into okl_cnsld_ar_strms_b

5031: savepoint D2;
5032: PRINT_TO_LOG('Performing final bulk insert for lsm, record count is '||g_lsm_tbl.count);
5033: forall x in g_lsm_tbl.first..g_lsm_tbl.last
5034: save exceptions
5035: insert into okl_cnsld_ar_strms_b
5036: values g_lsm_tbl(x);
5037:
5038: forall f in g_lsm_tl_tbl.first..g_lsm_tl_tbl.last
5039: save exceptions