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.AHL_UMP_UTIL_PKG dependencies on AHL_MR_HEADERS_B

Line 301: FROM ahl_mr_headers_b

297:
298: -- cursor to get mr title, version and copy accomplishment.
299: CURSOR ahl_mr_headers_csr (p_mr_header_id IN NUMBER) IS
300: SELECT title mr_title, version_number, copy_accomplishment_flag
301: FROM ahl_mr_headers_b
302: WHERE mr_header_id = p_mr_header_id;
303:
304: -- cursor to get mr title, version and copy accomplishment.
305: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,

Line 308: FROM ahl_mr_headers_b

304: -- cursor to get mr title, version and copy accomplishment.
305: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,
306: p_version_number IN NUMBER) IS
307: SELECT version_number, copy_accomplishment_flag, mr_header_id
308: FROM ahl_mr_headers_b
309: WHERE title = p_mr_title AND
310: version_number = p_version_number;
311:
312: -- cursor to get accomplishments for current version.

Line 336: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;

332: l_accomplish_found BOOLEAN := FALSE;
333: l_mr_header_id NUMBER := p_mr_header_id;
334: l_unit_effectivity_id NUMBER;
335: l_accomplishment_date DATE;
336: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
337: l_mr_title ahl_mr_headers_b.title%TYPE;
338: l_version_number NUMBER;
339: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
340:

Line 337: l_mr_title ahl_mr_headers_b.title%TYPE;

333: l_mr_header_id NUMBER := p_mr_header_id;
334: l_unit_effectivity_id NUMBER;
335: l_accomplishment_date DATE;
336: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
337: l_mr_title ahl_mr_headers_b.title%TYPE;
338: l_version_number NUMBER;
339: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
340:
341: -- Added for deferral functionality.

Line 772: FROM AHL_MR_HEADERS_B b1, AHL_MR_HEADERS_B b2

768: SELECT distinct r.mr_header_id, r.related_mr_header_id,
769: r.relationship_code
770: FROM ahl_mr_relationships r
771: WHERE EXISTS (SELECT 'x'
772: FROM AHL_MR_HEADERS_B b1, AHL_MR_HEADERS_B b2
773: WHERE b1.mr_header_id = r.mr_header_id
774: AND b2.mr_header_id = r.related_mr_header_id
775: AND b1.mr_status_code = 'COMPLETE'
776: AND b2.mr_status_code = 'COMPLETE'

Line 792: AND exists (select /+ push_subq no_unnest / 'x' from ahl_mr_headers_b mr1

788: r.relationship_code
789: FROM ahl_mr_relationships r
790: START WITH r.mr_header_id = p_mr_id
791: AND r.relationship_code = 'PARENT'
792: AND exists (select /*+ push_subq no_unnest */ 'x' from ahl_mr_headers_b mr1
793: where mr1.mr_header_id = r.related_mr_header_id
794: and mr1.version_number = (select max(mr2.version_number)
795: from ahl_mr_headers_b mr2
796: where mr2.title = mr1.title

Line 795: from ahl_mr_headers_b mr2

791: AND r.relationship_code = 'PARENT'
792: AND exists (select /*+ push_subq no_unnest */ 'x' from ahl_mr_headers_b mr1
793: where mr1.mr_header_id = r.related_mr_header_id
794: and mr1.version_number = (select max(mr2.version_number)
795: from ahl_mr_headers_b mr2
796: where mr2.title = mr1.title
797: and mr2.mr_status_code = 'COMPLETE'
798: and SYSDATE between trunc(mr2.effective_from)
799: and trunc(nvl(mr2.effective_to,SYSDATE+1))

Line 804: AND exists (select /+ push_subq no_unnest / 'x' from ahl_mr_headers_b mr1

800: )
801: )
802: CONNECT BY r.mr_header_id = PRIOR r.related_mr_header_id
803: AND r.relationship_code = 'PARENT'
804: AND exists (select /*+ push_subq no_unnest */ 'x' from ahl_mr_headers_b mr1
805: where mr1.mr_header_id = r.related_mr_header_id
806: and mr1.version_number = (select max(mr2.version_number)
807: from ahl_mr_headers_b mr2
808: where mr2.title = mr1.title

Line 807: from ahl_mr_headers_b mr2

803: AND r.relationship_code = 'PARENT'
804: AND exists (select /*+ push_subq no_unnest */ 'x' from ahl_mr_headers_b mr1
805: where mr1.mr_header_id = r.related_mr_header_id
806: and mr1.version_number = (select max(mr2.version_number)
807: from ahl_mr_headers_b mr2
808: where mr2.title = mr1.title
809: and mr2.mr_status_code = 'COMPLETE'
810: and SYSDATE between trunc(mr2.effective_from)
811: and trunc(nvl(mr2.effective_to,SYSDATE+1))

Line 1228: FROM ahl_mr_headers_b

1224:
1225: -- cursor to get mr title, version and copy accomplishment.
1226: CURSOR ahl_mr_headers_csr (p_mr_header_id IN NUMBER) IS
1227: SELECT title mr_title, version_number, copy_accomplishment_flag
1228: FROM ahl_mr_headers_b
1229: WHERE mr_header_id = p_mr_header_id;
1230:
1231: -- cursor to get mr title, version and copy accomplishment.
1232: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,

Line 1235: FROM ahl_mr_headers_b

1231: -- cursor to get mr title, version and copy accomplishment.
1232: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,
1233: p_version_number IN NUMBER) IS
1234: SELECT version_number, copy_accomplishment_flag, mr_header_id
1235: FROM ahl_mr_headers_b
1236: WHERE title = p_mr_title AND
1237: version_number = p_version_number;
1238:
1239: -- cursor to get accomplishments for current version.

Line 1258: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;

1254: l_accomplish_found BOOLEAN := FALSE;
1255: l_mr_header_id NUMBER := p_mr_header_id;
1256: l_unit_effectivity_id NUMBER;
1257: l_accomplishment_date DATE;
1258: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
1259: l_mr_title ahl_mr_headers_b.title%TYPE;
1260: l_version_number NUMBER;
1261: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
1262:

Line 1259: l_mr_title ahl_mr_headers_b.title%TYPE;

1255: l_mr_header_id NUMBER := p_mr_header_id;
1256: l_unit_effectivity_id NUMBER;
1257: l_accomplishment_date DATE;
1258: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
1259: l_mr_title ahl_mr_headers_b.title%TYPE;
1260: l_version_number NUMBER;
1261: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
1262:
1263: -- Added for deferral functionality.

Line 1461: FROM ahl_mr_headers_b

1457:
1458: -- cursor to get mr title, version and copy accomplishment.
1459: CURSOR ahl_mr_headers_csr (p_mr_header_id IN NUMBER) IS
1460: SELECT title mr_title, version_number, copy_accomplishment_flag
1461: FROM ahl_mr_headers_b
1462: WHERE mr_header_id = p_mr_header_id;
1463:
1464: -- cursor to get mr title, version and copy accomplishment.
1465: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,

Line 1468: FROM ahl_mr_headers_b

1464: -- cursor to get mr title, version and copy accomplishment.
1465: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,
1466: p_version_number IN NUMBER) IS
1467: SELECT version_number, copy_accomplishment_flag, mr_header_id
1468: FROM ahl_mr_headers_b
1469: WHERE title = p_mr_title AND
1470: version_number = p_version_number;
1471:
1472: -- cursor to get accomplishments for current version.

Line 1496: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;

1492: l_accomplish_found BOOLEAN := FALSE;
1493: l_mr_header_id NUMBER := p_mr_header_id;
1494: l_unit_effectivity_id NUMBER;
1495: l_accomplishment_date DATE;
1496: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
1497: l_mr_title ahl_mr_headers_b.title%TYPE;
1498: l_version_number NUMBER;
1499: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
1500:

Line 1497: l_mr_title ahl_mr_headers_b.title%TYPE;

1493: l_mr_header_id NUMBER := p_mr_header_id;
1494: l_unit_effectivity_id NUMBER;
1495: l_accomplishment_date DATE;
1496: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
1497: l_mr_title ahl_mr_headers_b.title%TYPE;
1498: l_version_number NUMBER;
1499: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
1500:
1501: -- Added for deferral functionality.