APPS.OKL_CASH_RULES_SUMRY_PVT dependencies on OKL_CASH_ALLCTN_RLS

Line 48: FROM OKL_CSH_ALLCTN_RL_HDR A, OKL_CASH_ALLCTN_RLS B

44: -- DECLARE Cursors
45: -------------------
46: CURSOR get_this_car_id( p_cat_id NUMBER ) IS
47: SELECT B.cau_id, A.NAME, B.DEFAULT_RULE
48: FROM OKL_CSH_ALLCTN_RL_HDR A, OKL_CASH_ALLCTN_RLS B
49: WHERE A.ID = B.CAU_ID
50: AND B.ID = p_cat_id;
51:
52: CURSOR get_last_cat_id ( p_car_id NUMBER ) IS

Line 54: FROM OKL_CASH_ALLCTN_RLS

50: AND B.ID = p_cat_id;
51:
52: CURSOR get_last_cat_id ( p_car_id NUMBER ) IS
53: SELECT ID
54: FROM OKL_CASH_ALLCTN_RLS
55: WHERE cau_ID = p_car_id AND
56: (end_date >= trunc(sysdate) OR end_date IS NULL)
57: ORDER BY START_DATE DESC;
58:

Line 64: l_default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE;

60: l_this_car_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;
61: l_last_cat_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;
62: l_this_car_name OKL_CSH_ALLCTN_RL_HDR.NAME%TYPE;
63:
64: l_default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE;
65:
66: BEGIN
67:
68: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 120: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls( p_api_version => p_api_version

116: -- Populate Record for Update
117: l_catv_rec.ID := p_cash_rl_tbl(i).ID;
118: l_catv_rec.END_DATE := (TRUNC(SYSDATE) - 1);
119:
120: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls( p_api_version => p_api_version
121: ,p_init_msg_list => p_init_msg_list
122: ,x_return_status => l_return_status
123: ,x_msg_count => l_msg_count
124: ,x_msg_data => l_msg_data

Line 162: -- update okl_cash_allctn_rls table

158: l_catv_tbl(i).END_DATE := (TRUNC(SYSDATE) - 1);
159:
160: END LOOP;
161:
162: -- update okl_cash_allctn_rls table
163:
164: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls( p_api_version => p_api_version
165: ,p_init_msg_list => p_init_msg_list
166: ,x_return_status => l_return_status

Line 164: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls( p_api_version => p_api_version

160: END LOOP;
161:
162: -- update okl_cash_allctn_rls table
163:
164: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls( p_api_version => p_api_version
165: ,p_init_msg_list => p_init_msg_list
166: ,x_return_status => l_return_status
167: ,x_msg_count => l_msg_count
168: ,x_msg_data => l_msg_data