APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_CNSLD_AR_STRMS_B

Line 2756: insert into okl_cnsld_ar_strms_b

2752: BEGIN
2753: savepoint D1;
2754: forall x in g_lsm_tbl.first..g_lsm_tbl.last
2755: save exceptions
2756: insert into okl_cnsld_ar_strms_b
2757: values g_lsm_tbl(x);
2758:
2759: forall f in g_lsm_tl_tbl.first..g_lsm_tl_tbl.last
2760: save exceptions

Line 3092: OKL_CNSLD_AR_STRMS_B LSM

3088: OKC_LINE_STYLES_b SUB_LSE,
3089: OKC_K_ITEMS CIM,
3090: OKC_K_LINES_V FA,
3091: OKC_LINE_STYLES_B AST_LSE,
3092: OKL_CNSLD_AR_STRMS_B LSM
3093: WHERE
3094: CHR.ID = TOP_CLE.DNZ_CHR_ID AND
3095: TOP_CLE.LSE_ID = TOP_LSE.ID AND
3096: TOP_LSE.LTY_CODE IN('SOLD_SERVICE','FEE') AND

Line 4065: FROM okl_cnsld_ar_strms_b

4061: l_temp_khr_id NUMBER;
4062:
4063: CURSOR get_khr_id ( p_lsm_id NUMBER ) IS
4064: SELECT khr_id
4065: FROM okl_cnsld_ar_strms_b
4066: WHERE id = p_lsm_id;
4067:
4068:
4069: -- Variable to track commit record size

Line 4465: insert into okl_cnsld_ar_strms_b

4461: savepoint D2;
4462: PRINT_TO_LOG('Performing bulk insert for lsm, record count is '||g_lsm_tbl.count);
4463: forall x in g_lsm_tbl.first..g_lsm_tbl.last
4464: save exceptions
4465: insert into okl_cnsld_ar_strms_b
4466: values g_lsm_tbl(x);
4467:
4468: forall f in g_lsm_tl_tbl.first..g_lsm_tl_tbl.last
4469: save exceptions

Line 4971: insert into okl_cnsld_ar_strms_b

4967: savepoint D2;
4968: PRINT_TO_LOG('Performing final bulk insert for lsm, record count is '||g_lsm_tbl.count);
4969: forall x in g_lsm_tbl.first..g_lsm_tbl.last
4970: save exceptions
4971: insert into okl_cnsld_ar_strms_b
4972: values g_lsm_tbl(x);
4973:
4974: forall f in g_lsm_tl_tbl.first..g_lsm_tl_tbl.last
4975: save exceptions