APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKL_ASSET_SUBSIDY_PVT

Line 262: lv_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => cv_susidy_rec.subsidy_id

258: FOR cv_susidy_rec IN c_subsidy_csr(cp_chr_id => p_khr_id) LOOP
259: lx_subsidy_pool_id := NULL;
260: lx_sub_pool_curr_code := NULL;
261: lv_subsidy_applic := 'N';
262: lv_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => cv_susidy_rec.subsidy_id
263: ,x_subsidy_pool_id => lx_subsidy_pool_id
264: ,x_sub_pool_curr_code => lx_sub_pool_curr_code);
265: IF(lv_subsidy_applic = 'Y')THEN
266: idx := idx + 1;

Line 659: l_sub_pool_applicable := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => c_subsidy_csr_rec.subsidy_id

655: -- check if the subsidy is associated with a subsidy pool
656: -- initialize for every iteration
657: l_sub_pool_applicable := 'N';
658: -- check if the subisdy is associated with a subsidy pool, process further only if subsidy pool exists.
659: l_sub_pool_applicable := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => c_subsidy_csr_rec.subsidy_id
660: ,x_subsidy_pool_id => lx_sub_pool_id
661: ,x_sub_pool_curr_code => lx_sub_pool_curr_code
662: );
663:

Line 1042: lv_orig_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => l_subelm_orig_rec.subsidy_id

1038: (l_subelm_orig_rec.subsidy_id <> l_subelm_rbk_rec.subsidy_id) OR
1039: (l_subelm_orig_rec.sty_id <> l_subelm_rbk_rec.sty_id) THEN
1040:
1041: lv_orig_subsidy_applic := 'N';
1042: lv_orig_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => l_subelm_orig_rec.subsidy_id
1043: ,x_subsidy_pool_id => lx_subsidy_pool_id
1044: ,x_sub_pool_curr_code => lx_sub_pool_curr_code);
1045: IF(lv_orig_subsidy_applic = 'Y')THEN
1046: idx := idx + 1;

Line 1076: lv_rbk_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => l_subelm_rbk_rec.subsidy_id

1072: lx_subsidy_pool_id := NULL;
1073: lx_sub_pool_curr_code := NULL;
1074: -- check to see if the subsidy on the rebook contract is associated with a subsidy pool, and if so then reduce the pool balance
1075: lv_rbk_subsidy_applic := 'N';
1076: lv_rbk_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => l_subelm_rbk_rec.subsidy_id
1077: ,x_subsidy_pool_id => lx_subsidy_pool_id
1078: ,x_sub_pool_curr_code => lx_sub_pool_curr_code);
1079: IF(lv_rbk_subsidy_applic = 'Y')THEN
1080: idx := idx + 1;

Line 1118: lv_rbk_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => lv_rec_del_sub_csr.subsidy

1114: FOR lv_rec_del_sub_csr IN l_del_sub_csr (p_orig_chr_id => p_orig_chr_id, p_rbk_chr_id => p_rbk_chr_id) LOOP
1115: lx_subsidy_pool_id := NULL;
1116: lx_sub_pool_curr_code := NULL;
1117: lv_rbk_subsidy_applic := 'N';
1118: lv_rbk_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => lv_rec_del_sub_csr.subsidy
1119: ,x_subsidy_pool_id => lx_subsidy_pool_id
1120: ,x_sub_pool_curr_code => lx_sub_pool_curr_code);
1121: IF(lv_rbk_subsidy_applic = 'Y')THEN
1122: idx := idx + 1;

Line 1157: lv_rbk_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => l_subelm_rbk_rec.subsidy_id

1153: lx_sub_pool_curr_code := NULL;
1154: -- check to see if the subsidy on the rebook contract is associated with a subsidy pool, and if so
1155: -- then reduce the pool balance
1156: lv_rbk_subsidy_applic := 'N';
1157: lv_rbk_subsidy_applic := okl_asset_subsidy_pvt.is_sub_assoc_with_pool(p_subsidy_id => l_subelm_rbk_rec.subsidy_id
1158: ,x_subsidy_pool_id => lx_subsidy_pool_id
1159: ,x_sub_pool_curr_code => lx_sub_pool_curr_code);
1160: IF(lv_rbk_subsidy_applic = 'Y')THEN
1161: idx := idx + 1;