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_PA_DATA_INTEGRITY dependencies on OKL_ACCOUNTING_UTIL

Line 108: (trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR

104: AND id <> cp_id
105: AND assoc_object_id = cp_object_id
106: AND (assoc_object_version = cp_object_version OR assoc_object_version IS NULL)
107: AND (
108: (trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR
109: (trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))
110: );
111:
112: CURSOR c_get_dup_obj_agr (cp_object_id okl_vp_associations.assoc_object_id%TYPE

Line 109: (trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))

105: AND assoc_object_id = cp_object_id
106: AND (assoc_object_version = cp_object_version OR assoc_object_version IS NULL)
107: AND (
108: (trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR
109: (trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))
110: );
111:
112: CURSOR c_get_dup_obj_agr (cp_object_id okl_vp_associations.assoc_object_id%TYPE
113: ,cp_chr_id okc_k_headers_b.id%TYPE

Line 127: (trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR

123: AND id <> cp_id
124: AND assoc_object_id = cp_object_id
125: AND (assoc_object_version = cp_object_version OR assoc_object_version IS NULL)
126: AND (
127: (trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR
128: (trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))
129: );
130:
131: l_return_value VARCHAR2(1) ;

Line 128: (trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))

124: AND assoc_object_id = cp_object_id
125: AND (assoc_object_version = cp_object_version OR assoc_object_version IS NULL)
126: AND (
127: (trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR
128: (trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))
129: );
130:
131: l_return_value VARCHAR2(1) ;
132: lv_dummy VARCHAR2(1);

Line 545: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR

541: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
542: AND vpa.id <> cp_id
543: AND vpa.assoc_object_id <> cp_object_id
544: AND (
545: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
546: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
547: )
548: UNION
549: SELECT lat.name

Line 546: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))

542: AND vpa.id <> cp_id
543: AND vpa.assoc_object_id <> cp_object_id
544: AND (
545: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
546: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
547: )
548: UNION
549: SELECT lat.name
550: FROM OKL_LEASEAPP_TMPLS lat,

Line 564: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR

560: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
561: AND vpa.id <> cp_id
562: AND vpa.assoc_object_id <> cp_object_id
563: AND (
564: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
565: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
566: )
567: AND chreq.status_code in ('PASSED','NEW','INCOMPLETE')
568: UNION

Line 565: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))

561: AND vpa.id <> cp_id
562: AND vpa.assoc_object_id <> cp_object_id
563: AND (
564: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
565: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
566: )
567: AND chreq.status_code in ('PASSED','NEW','INCOMPLETE')
568: UNION
569: SELECT lat.name

Line 585: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR

581: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
582: AND vpa.id <> cp_id
583: AND vpa.assoc_object_id <> cp_object_id
584: AND (
585: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
586: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
587: )
588: AND chreq.id = vpa.crs_id
589: AND chreq.status_code in ('PASSED','NEW','INCOMPLETE');

Line 586: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))

582: AND vpa.id <> cp_id
583: AND vpa.assoc_object_id <> cp_object_id
584: AND (
585: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
586: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
587: )
588: AND chreq.id = vpa.crs_id
589: AND chreq.status_code in ('PASSED','NEW','INCOMPLETE');
590:

Line 1058: IF((TRUNC(c_get_criteria_rec.effective_from_date) NOT BETWEEN TRUNC(l_start_date) AND TRUNC(NVL(l_end_date,okl_accounting_util.g_final_date))) OR

1054:
1055: -- sjalasut, added validations to check the effective dates of the criteria fall within the effective dates of the PA
1056: -- START of code changes
1057: FOR c_get_criteria_rec IN c_get_criteria_csr(cp_chr_id => p_chr_id) LOOP
1058: IF((TRUNC(c_get_criteria_rec.effective_from_date) NOT BETWEEN TRUNC(l_start_date) AND TRUNC(NVL(l_end_date,okl_accounting_util.g_final_date))) OR
1059: (TRUNC(NVL(c_get_criteria_rec.effective_to_date,okl_accounting_util.g_final_date)) NOT BETWEEN TRUNC(l_start_date) AND TRUNC(NVL(l_end_date,okl_accounting_util.g_final_date)))
1060: )THEN
1061: fnd_message.set_name(G_APP_NAME, 'OKL_ELIGIBILITY_CRIT_CAT');
1062: okl_api.set_message(p_app_name => G_APP_NAME

Line 1059: (TRUNC(NVL(c_get_criteria_rec.effective_to_date,okl_accounting_util.g_final_date)) NOT BETWEEN TRUNC(l_start_date) AND TRUNC(NVL(l_end_date,okl_accounting_util.g_final_date)))

1055: -- sjalasut, added validations to check the effective dates of the criteria fall within the effective dates of the PA
1056: -- START of code changes
1057: FOR c_get_criteria_rec IN c_get_criteria_csr(cp_chr_id => p_chr_id) LOOP
1058: IF((TRUNC(c_get_criteria_rec.effective_from_date) NOT BETWEEN TRUNC(l_start_date) AND TRUNC(NVL(l_end_date,okl_accounting_util.g_final_date))) OR
1059: (TRUNC(NVL(c_get_criteria_rec.effective_to_date,okl_accounting_util.g_final_date)) NOT BETWEEN TRUNC(l_start_date) AND TRUNC(NVL(l_end_date,okl_accounting_util.g_final_date)))
1060: )THEN
1061: fnd_message.set_name(G_APP_NAME, 'OKL_ELIGIBILITY_CRIT_CAT');
1062: okl_api.set_message(p_app_name => G_APP_NAME
1063: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_DATES'