eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CASH_APPLN_RULE_PVT dependencies on OKL_CASH_ALLCTN_RLS

Line 35: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;

31:
32: l_cauv_rec cauv_rec_type;
33: lx_cauv_rec cauv_rec_type;
34:
35: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;
36: l_end_date OKL_CASH_ALLCTN_RLS.end_date%type := NULL;
37: l_rule_name OKL_CASH_ALLCTN_RLS.name%type := NULL;
38: l_req_field_miss BOOLEAN := FALSE;
39:

Line 36: l_end_date OKL_CASH_ALLCTN_RLS.end_date%type := NULL;

32: l_cauv_rec cauv_rec_type;
33: lx_cauv_rec cauv_rec_type;
34:
35: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;
36: l_end_date OKL_CASH_ALLCTN_RLS.end_date%type := NULL;
37: l_rule_name OKL_CASH_ALLCTN_RLS.name%type := NULL;
38: l_req_field_miss BOOLEAN := FALSE;
39:
40: CURSOR l_cau_obj_ver_csr(cp_id IN l_cauv_rec.id%TYPE) IS

Line 37: l_rule_name OKL_CASH_ALLCTN_RLS.name%type := NULL;

33: lx_cauv_rec cauv_rec_type;
34:
35: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;
36: l_end_date OKL_CASH_ALLCTN_RLS.end_date%type := NULL;
37: l_rule_name OKL_CASH_ALLCTN_RLS.name%type := NULL;
38: l_req_field_miss BOOLEAN := FALSE;
39:
40: CURSOR l_cau_obj_ver_csr(cp_id IN l_cauv_rec.id%TYPE) IS
41: SELECT object_version_number

Line 52: CURSOR l_end_date_csr(cp_id IN OKL_CASH_ALLCTN_RLS.id%TYPE) IS

48: FROM OKL_CSH_ALLCTN_RL_HDR
49: WHERE name = cp_name;
50:
51:
52: CURSOR l_end_date_csr(cp_id IN OKL_CASH_ALLCTN_RLS.id%TYPE) IS
53: SELECT end_date
54: FROM OKL_CASH_ALLCTN_RLS
55: WHERE id = cp_id;
56:

Line 54: FROM OKL_CASH_ALLCTN_RLS

50:
51:
52: CURSOR l_end_date_csr(cp_id IN OKL_CASH_ALLCTN_RLS.id%TYPE) IS
53: SELECT end_date
54: FROM OKL_CASH_ALLCTN_RLS
55: WHERE id = cp_id;
56:
57: CURSOR l_prev_line_csr(cp_cau_id IN OKL_CASH_ALLCTN_RLS.cau_id%TYPE) IS
58: SELECT id

Line 57: CURSOR l_prev_line_csr(cp_cau_id IN OKL_CASH_ALLCTN_RLS.cau_id%TYPE) IS

53: SELECT end_date
54: FROM OKL_CASH_ALLCTN_RLS
55: WHERE id = cp_id;
56:
57: CURSOR l_prev_line_csr(cp_cau_id IN OKL_CASH_ALLCTN_RLS.cau_id%TYPE) IS
58: SELECT id
59: , object_version_number
60: , start_date
61: , end_date

Line 62: FROM OKL_CASH_ALLCTN_RLS

58: SELECT id
59: , object_version_number
60: , start_date
61: , end_date
62: FROM OKL_CASH_ALLCTN_RLS
63: WHERE cau_id = cp_cau_id
64: ORDER BY id DESC;
65:
66: --Validate start and end dates

Line 86: FROM OKL_CASH_ALLCTN_RLS

82: ,cp_cau_id IN NUMBER
83: ,cp_start_date IN DATE
84: ,cp_end_date IN DATE) IS
85: SELECT start_date, end_date
86: FROM OKL_CASH_ALLCTN_RLS
87: WHERE cau_id = nvl(cp_cau_id, -99)
88: AND id <> nvl(cp_id, -99)
89: AND (trunc(cp_start_date) between trunc(start_date) and trunc(nvl(end_date, cp_start_date))
90: OR trunc(nvl(cp_end_date, cp_start_date)) between trunc(start_date) and trunc(end_date));

Line 98: FROM OKL_CASH_ALLCTN_RLS

94: ,cp_cau_id IN NUMBER
95: ,cp_start_date IN DATE
96: ,cp_end_date IN DATE) IS
97: SELECT start_date, end_date
98: FROM OKL_CASH_ALLCTN_RLS
99: WHERE cau_id = nvl(cp_cau_id, -99)
100: AND id <> nvl(cp_id, -99)
101: AND (trunc(end_date) < trunc(cp_start_date))
102: --OR (nvl(cp_end_date, cp_start_date) < start_date))

Line 111: FROM OKL_CASH_ALLCTN_RLS

107: ,cp_cau_id IN NUMBER
108: ,cp_start_date IN DATE
109: ,cp_end_date IN DATE) IS
110: SELECT start_date, end_date
111: FROM OKL_CASH_ALLCTN_RLS
112: WHERE cau_id = nvl(cp_cau_id, -99)
113: AND id <> nvl(cp_id, -99)
114: AND (trunc(nvl(cp_end_date, cp_start_date)) < trunc(start_date))
115: ORDER BY start_date asc;

Line 191: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;

187: --Validate default rule
188: --if a default rule exists, cau_id of the default rule is returned
189: FUNCTION validate_default_rule(p_catv_rec IN catv_rec_type) RETURN NUMBER IS
190: l_catv_rec catv_rec_type := p_catv_rec;
191: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;
192:
193: CURSOR l_def_csr(cp_cau_id IN NUMBER) IS
194: SELECT cau_id
195: FROM OKL_CASH_ALLCTN_RLS

Line 195: FROM OKL_CASH_ALLCTN_RLS

191: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;
192:
193: CURSOR l_def_csr(cp_cau_id IN NUMBER) IS
194: SELECT cau_id
195: FROM OKL_CASH_ALLCTN_RLS
196: WHERE ((NVL(l_catv_rec.cau_id, okl_api.g_miss_num) = okl_api.g_miss_num) OR
197: (l_catv_rec.cau_id IS NOT NULL AND cau_id = cp_cau_id))
198: AND default_rule = 'YES';
199: BEGIN

Line 325: Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(

321: l_catv_rec.receipt_msmtch_allocation_code := 'A';
322: END IF;
323:
324: --create rule line
325: Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(
326: p_api_version => p_api_version
327: ,p_init_msg_list => p_init_msg_list
328: ,x_return_status => l_return_status
329: ,x_msg_count => x_msg_count

Line 391: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(

387: END IF;
388:
389:
390: --update rule line
391: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(
392: p_api_version => p_api_version
393: ,p_init_msg_list => p_init_msg_list
394: ,x_return_status => l_return_status
395: ,x_msg_count => x_msg_count

Line 451: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(

447: raise G_EXCEPTION_HALT_VALIDATION;
448: END IF;
449:
450: --update prev rule line
451: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(
452: p_api_version => p_api_version
453: ,p_init_msg_list => p_init_msg_list
454: ,x_return_status => l_return_status
455: ,x_msg_count => x_msg_count

Line 506: Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(

502: END IF;
503:
504:
505: --create rule line
506: Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(
507: p_api_version => p_api_version
508: ,p_init_msg_list => p_init_msg_list
509: ,x_return_status => l_return_status
510: ,x_msg_count => x_msg_count