APPS.OKL_LRT_PVT dependencies on OKL_LS_RT_FCTR_SETS_B

Line 760: ,p_token2_value => 'OKL_LS_RT_FCTR_SETS_B'

756: ,p_msg_name => 'OKC_NO_PARENT_RECORD'
757: ,p_token1 => okl_api.g_col_name_token
758: ,p_token1_value => 'END_OF_TERM_ID'
759: ,p_token2 => okl_api.g_child_table_token
760: ,p_token2_value => 'OKL_LS_RT_FCTR_SETS_B'
761: ,p_token3 => okl_api.g_parent_table_token
762: ,p_token3_value => 'OKL_FE_EO_TERMS_V');
763: RAISE okl_api.g_exception_error;
764: END IF;

Line 1125: INSERT INTO okl_ls_rt_fctr_sets_b

1121: l_lrt_rec lrt_rec_type := p_lrt_rec;
1122:
1123: BEGIN
1124:
1125: INSERT INTO okl_ls_rt_fctr_sets_b
1126: (id
1127: ,object_version_number
1128: ,name
1129: ,arrears_yn

Line 1452: FROM okl_ls_rt_fctr_sets_b

1448: PRAGMA exception_init(e_resource_busy, - 00054);
1449:
1450: CURSOR lock_csr(p_lrt_rec IN lrt_rec_type) IS
1451: SELECT object_version_number
1452: FROM okl_ls_rt_fctr_sets_b
1453: WHERE id = p_lrt_rec.id
1454: AND object_version_number = p_lrt_rec.object_version_number
1455: FOR UPDATE OF object_version_number NOWAIT;
1456:

Line 1459: FROM okl_ls_rt_fctr_sets_b

1455: FOR UPDATE OF object_version_number NOWAIT;
1456:
1457: CURSOR lchk_csr(p_lrt_rec IN lrt_rec_type) IS
1458: SELECT object_version_number
1459: FROM okl_ls_rt_fctr_sets_b
1460: WHERE id = p_lrt_rec.id;
1461: l_return_status varchar2(1) := g_ret_sts_success;
1462: l_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1463: lc_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;

Line 1462: l_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;

1458: SELECT object_version_number
1459: FROM okl_ls_rt_fctr_sets_b
1460: WHERE id = p_lrt_rec.id;
1461: l_return_status varchar2(1) := g_ret_sts_success;
1462: l_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1463: lc_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1464: l_row_notfound boolean := false;
1465: lc_row_notfound boolean := false;
1466:

Line 1463: lc_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;

1459: FROM okl_ls_rt_fctr_sets_b
1460: WHERE id = p_lrt_rec.id;
1461: l_return_status varchar2(1) := g_ret_sts_success;
1462: l_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1463: lc_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1464: l_row_notfound boolean := false;
1465: lc_row_notfound boolean := false;
1466:
1467: BEGIN

Line 1700: UPDATE okl_ls_rt_fctr_sets_b

1696: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'update_row (B)';
1697:
1698: BEGIN
1699:
1700: UPDATE okl_ls_rt_fctr_sets_b
1701: SET object_version_number = p_lrt_rec.object_version_number + 1
1702: ,name = p_lrt_rec.name
1703: ,arrears_yn = p_lrt_rec.arrears_yn
1704: ,start_date = p_lrt_rec.start_date

Line 2214: DELETE FROM okl_ls_rt_fctr_sets_b

2210:
2211: DELETE FROM okl_ls_rt_fctr_ents
2212: WHERE lrt_id = p_lrt_rec.id;
2213:
2214: DELETE FROM okl_ls_rt_fctr_sets_b
2215: WHERE id = p_lrt_rec.id;
2216: x_return_status := g_ret_sts_success;
2217: EXCEPTION
2218: WHEN okl_api.g_exception_error THEN