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: --Bug 8633025 - NIKSHAH

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: --Bug 8633025 - NIKSHAH
41: l_def_catv_tbl catv_tbl_type;

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

53: FROM OKL_CSH_ALLCTN_RL_HDR
54: WHERE name = cp_name;
55:
56:
57: CURSOR l_end_date_csr(cp_id IN OKL_CASH_ALLCTN_RLS.id%TYPE) IS
58: SELECT end_date
59: FROM OKL_CASH_ALLCTN_RLS
60: WHERE id = cp_id;
61:

Line 59: FROM OKL_CASH_ALLCTN_RLS

55:
56:
57: CURSOR l_end_date_csr(cp_id IN OKL_CASH_ALLCTN_RLS.id%TYPE) IS
58: SELECT end_date
59: FROM OKL_CASH_ALLCTN_RLS
60: WHERE id = cp_id;
61:
62: CURSOR l_prev_line_csr(cp_cau_id IN OKL_CASH_ALLCTN_RLS.cau_id%TYPE) IS
63: SELECT id

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

58: SELECT end_date
59: FROM OKL_CASH_ALLCTN_RLS
60: WHERE id = cp_id;
61:
62: CURSOR l_prev_line_csr(cp_cau_id IN OKL_CASH_ALLCTN_RLS.cau_id%TYPE) IS
63: SELECT id
64: , object_version_number
65: , start_date
66: , end_date

Line 67: FROM OKL_CASH_ALLCTN_RLS

63: SELECT id
64: , object_version_number
65: , start_date
66: , end_date
67: FROM OKL_CASH_ALLCTN_RLS
68: WHERE cau_id = cp_cau_id
69: ORDER BY id DESC;
70:
71: --Added below cursor for getting default rules of an active date

Line 75: FROM OKL_CASH_ALLCTN_RLS

71: --Added below cursor for getting default rules of an active date
72: --Bug 8633025 - NIKSHAH
73: CURSOR l_def_rule_csr IS
74: SELECT id
75: FROM OKL_CASH_ALLCTN_RLS
76: WHERE DEFAULT_RULE = 'YES'
77: AND TRUNC(NVL(END_DATE, SYSDATE)) >= TRUNC(SYSDATE);
78:
79: --Validate start and end dates

Line 99: FROM OKL_CASH_ALLCTN_RLS

95: ,cp_cau_id IN NUMBER
96: ,cp_start_date IN DATE
97: ,cp_end_date IN DATE) IS
98: SELECT start_date, end_date
99: FROM OKL_CASH_ALLCTN_RLS
100: WHERE cau_id = nvl(cp_cau_id, -99)
101: AND id <> nvl(cp_id, -99)
102: AND (trunc(cp_start_date) between trunc(start_date) and trunc(nvl(end_date, cp_start_date))
103: OR trunc(nvl(cp_end_date, cp_start_date)) between trunc(start_date) and trunc(end_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(end_date) < trunc(cp_start_date))
115: --OR (nvl(cp_end_date, cp_start_date) < start_date))

Line 124: FROM OKL_CASH_ALLCTN_RLS

120: ,cp_cau_id IN NUMBER
121: ,cp_start_date IN DATE
122: ,cp_end_date IN DATE) IS
123: SELECT start_date, end_date
124: FROM OKL_CASH_ALLCTN_RLS
125: WHERE cau_id = nvl(cp_cau_id, -99)
126: AND id <> nvl(cp_id, -99)
127: AND (trunc(nvl(cp_end_date, cp_start_date)) < trunc(start_date))
128: ORDER BY start_date asc;

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

202: --Commented by NIKSHAH, bug 8633025
203: /*
204: FUNCTION validate_default_rule(p_catv_rec IN catv_rec_type) RETURN NUMBER IS
205: l_catv_rec catv_rec_type := p_catv_rec;
206: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;
207:
208: CURSOR l_def_csr(cp_cau_id IN NUMBER) IS
209: SELECT cau_id
210: FROM OKL_CASH_ALLCTN_RLS

Line 210: FROM OKL_CASH_ALLCTN_RLS

206: l_default_cau_id OKL_CASH_ALLCTN_RLS.cau_id%type := NULL;
207:
208: CURSOR l_def_csr(cp_cau_id IN NUMBER) IS
209: SELECT cau_id
210: FROM OKL_CASH_ALLCTN_RLS
211: WHERE ((NVL(l_catv_rec.cau_id, okl_api.g_miss_num) = okl_api.g_miss_num) OR
212: (l_catv_rec.cau_id IS NOT NULL AND cau_id = cp_cau_id))
213: AND default_rule = 'YES';
214: BEGIN

Line 303: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls

299: l_counter := l_counter + 1;
300: END LOOP;
301:
302: IF l_counter > 1 THEN
303: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls
304: (p_api_version => p_api_version
305: ,p_init_msg_list => p_init_msg_list
306: ,x_return_status => l_return_status
307: ,x_msg_count => x_msg_count

Line 371: Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(

367: l_catv_rec.receipt_msmtch_allocation_code := 'A';
368: END IF;
369:
370: --create rule line
371: Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(
372: p_api_version => p_api_version
373: ,p_init_msg_list => p_init_msg_list
374: ,x_return_status => l_return_status
375: ,x_msg_count => x_msg_count

Line 416: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls

412: l_counter := l_counter + 1;
413: END LOOP;
414:
415: IF l_counter > 1 THEN
416: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls
417: (p_api_version => p_api_version
418: ,p_init_msg_list => p_init_msg_list
419: ,x_return_status => l_return_status
420: ,x_msg_count => x_msg_count

Line 466: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(

462: END IF;
463:
464:
465: --update rule line
466: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(
467: p_api_version => p_api_version
468: ,p_init_msg_list => p_init_msg_list
469: ,x_return_status => l_return_status
470: ,x_msg_count => x_msg_count

Line 526: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(

522: raise G_EXCEPTION_HALT_VALIDATION;
523: END IF;
524:
525: --update prev rule line
526: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(
527: p_api_version => p_api_version
528: ,p_init_msg_list => p_init_msg_list
529: ,x_return_status => l_return_status
530: ,x_msg_count => x_msg_count

Line 561: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls

557: l_counter := l_counter + 1;
558: END LOOP;
559:
560: IF l_counter > 1 THEN
561: Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls
562: (p_api_version => p_api_version
563: ,p_init_msg_list => p_init_msg_list
564: ,x_return_status => l_return_status
565: ,x_msg_count => x_msg_count

Line 610: Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(

606: END IF;
607:
608:
609: --create rule line
610: Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(
611: p_api_version => p_api_version
612: ,p_init_msg_list => p_init_msg_list
613: ,x_return_status => l_return_status
614: ,x_msg_count => x_msg_count