APPS.OKL_LRT_PVT dependencies on OKL_LS_RT_FCTR_SETS_B

Line 750: ,p_token2_value => 'OKL_LS_RT_FCTR_SETS_B'

746: ,p_msg_name => 'OKC_NO_PARENT_RECORD'
747: ,p_token1 => okl_api.g_col_name_token
748: ,p_token1_value => 'END_OF_TERM_ID'
749: ,p_token2 => okl_api.g_child_table_token
750: ,p_token2_value => 'OKL_LS_RT_FCTR_SETS_B'
751: ,p_token3 => okl_api.g_parent_table_token
752: ,p_token3_value => 'OKL_FE_EO_TERMS_V');
753: RAISE okl_api.g_exception_error;
754: END IF;

Line 1115: INSERT INTO okl_ls_rt_fctr_sets_b

1111: l_lrt_rec lrt_rec_type := p_lrt_rec;
1112:
1113: BEGIN
1114:
1115: INSERT INTO okl_ls_rt_fctr_sets_b
1116: (id
1117: ,object_version_number
1118: ,name
1119: ,arrears_yn

Line 1442: FROM okl_ls_rt_fctr_sets_b

1438: PRAGMA exception_init(e_resource_busy, - 00054);
1439:
1440: CURSOR lock_csr(p_lrt_rec IN lrt_rec_type) IS
1441: SELECT object_version_number
1442: FROM okl_ls_rt_fctr_sets_b
1443: WHERE id = p_lrt_rec.id
1444: AND object_version_number = p_lrt_rec.object_version_number
1445: FOR UPDATE OF object_version_number NOWAIT;
1446:

Line 1449: FROM okl_ls_rt_fctr_sets_b

1445: FOR UPDATE OF object_version_number NOWAIT;
1446:
1447: CURSOR lchk_csr(p_lrt_rec IN lrt_rec_type) IS
1448: SELECT object_version_number
1449: FROM okl_ls_rt_fctr_sets_b
1450: WHERE id = p_lrt_rec.id;
1451: l_return_status varchar2(1) := g_ret_sts_success;
1452: l_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1453: lc_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;

Line 1452: l_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;

1448: SELECT object_version_number
1449: FROM okl_ls_rt_fctr_sets_b
1450: WHERE id = p_lrt_rec.id;
1451: l_return_status varchar2(1) := g_ret_sts_success;
1452: l_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1453: lc_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1454: l_row_notfound boolean := false;
1455: lc_row_notfound boolean := false;
1456:

Line 1453: lc_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;

1449: FROM okl_ls_rt_fctr_sets_b
1450: WHERE id = p_lrt_rec.id;
1451: l_return_status varchar2(1) := g_ret_sts_success;
1452: l_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1453: lc_object_version_number okl_ls_rt_fctr_sets_b.object_version_number%TYPE;
1454: l_row_notfound boolean := false;
1455: lc_row_notfound boolean := false;
1456:
1457: BEGIN

Line 1690: UPDATE okl_ls_rt_fctr_sets_b

1686: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'update_row (B)';
1687:
1688: BEGIN
1689:
1690: UPDATE okl_ls_rt_fctr_sets_b
1691: SET object_version_number = p_lrt_rec.object_version_number + 1
1692: ,name = p_lrt_rec.name
1693: ,arrears_yn = p_lrt_rec.arrears_yn
1694: ,start_date = p_lrt_rec.start_date

Line 2204: DELETE FROM okl_ls_rt_fctr_sets_b

2200:
2201: DELETE FROM okl_ls_rt_fctr_ents
2202: WHERE lrt_id = p_lrt_rec.id;
2203:
2204: DELETE FROM okl_ls_rt_fctr_sets_b
2205: WHERE id = p_lrt_rec.id;
2206: x_return_status := g_ret_sts_success;
2207: EXCEPTION
2208: WHEN okl_api.g_exception_error THEN