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_RA_NR_PROFILE_PVT dependencies on AHL_NR_PROFILE_HEADERS

Line 49: FROM ahl_mr_headers_b mrh, ahl_nr_profile_headers nph

45:
46: CURSOR get_profile_ident_seqs(c_mr_header_id NUMBER)
47: IS
48: SELECT nph.nr_profile_header_id, nph.ident_seq_third , nph.ident_seq_fourth
49: FROM ahl_mr_headers_b mrh, ahl_nr_profile_headers nph
50: WHERE mrh.title = nph.mr_title
51: AND mrh.mr_header_id = c_mr_header_id
52: AND nph.status_code = 'COMPLETE';
53:

Line 386: FROM ahl_mr_headers_b mrh, ahl_nr_profile_headers nph

382:
383: CURSOR get_profile_ident_seqs(c_mr_header_id NUMBER)
384: IS
385: SELECT nph.nr_profile_header_id, nph.ident_seq_third , nph.ident_seq_fourth
386: FROM ahl_mr_headers_b mrh, ahl_nr_profile_headers nph
387: WHERE mrh.title = nph.mr_title
388: AND mrh.mr_header_id = c_mr_header_id
389: AND nph.status_code = 'COMPLETE';
390:

Line 1687: UPDATE ahl_nr_profile_headers

1683:
1684: -- Update the Profile lastupdate Date if New Record added or updated/deleted existing Records
1685: IF(p_x_nr_prof_est_tbl(i).excluded_date IS NULL)
1686: THEN
1687: UPDATE ahl_nr_profile_headers
1688: SET last_update_date = SYSDATE,
1689: last_updated_by = FND_GLOBAL.user_id,
1690: last_update_login = FND_GLOBAL.login_id
1691: WHERE nr_profile_header_id = p_x_nr_prof_est_tbl(i).nr_profile_header_id;

Line 1766: AND mh.title NOT IN (SELECT mr_title FROM ahl_nr_profile_headers)

1762: IS
1763: SELECT DISTINCT mh.title
1764: FROM ahl_mr_headers_v mh
1765: WHERE SYSDATE BETWEEN mh.effective_from AND NVL(mh.effective_to,SYSDATE+1)
1766: AND mh.title NOT IN (SELECT mr_title FROM ahl_nr_profile_headers)
1767: AND mh.title = c_mr_title;
1768:
1769: CURSOR get_valid_mr_title(c_mr_title VARCHAR2)
1770: IS

Line 1779: FROM ahl_nr_profile_headers

1775:
1776: CURSOR check_duplicate(c_mr_title VARCHAR2)
1777: IS
1778: SELECT mr_title
1779: FROM ahl_nr_profile_headers
1780: WHERE mr_title = c_mr_title;
1781:
1782: CURSOR get_profile_status(c_nr_profile_header_id NUMBER)
1783: IS

Line 1785: FROM ahl_nr_profile_headers

1781:
1782: CURSOR get_profile_status(c_nr_profile_header_id NUMBER)
1783: IS
1784: SELECT status_code
1785: FROM ahl_nr_profile_headers
1786: WHERE nr_profile_header_id = c_nr_profile_header_id;
1787:
1788: CURSOR get_nr_profile_id(c_mr_title VARCHAR2)
1789: IS

Line 1791: FROM ahl_nr_profile_headers

1787:
1788: CURSOR get_nr_profile_id(c_mr_title VARCHAR2)
1789: IS
1790: SELECT nr_profile_header_id
1791: FROM ahl_nr_profile_headers
1792: WHERE mr_title = c_mr_title
1793: AND status_code <> 'DELETED';
1794:
1795: CURSOR get_nr_profile_title(c_nr_profile_header_id NUMBER)

Line 1798: FROM ahl_nr_profile_headers

1794:
1795: CURSOR get_nr_profile_title(c_nr_profile_header_id NUMBER)
1796: IS
1797: SELECT mr_title
1798: FROM ahl_nr_profile_headers
1799: WHERE nr_profile_header_id = c_nr_profile_header_id
1800: AND status_code <> 'DELETED';
1801:
1802: CURSOR get_object_version_number(c_nr_profile_header_id NUMBER,c_object_version_number NUMBER)

Line 1805: FROM ahl_nr_profile_headers

1801:
1802: CURSOR get_object_version_number(c_nr_profile_header_id NUMBER,c_object_version_number NUMBER)
1803: IS
1804: SELECT object_version_number
1805: FROM ahl_nr_profile_headers
1806: WHERE nr_profile_header_id = c_nr_profile_header_id
1807: AND object_version_number = c_object_version_number;
1808:
1809: CURSOR get_delete_mr_title(c_mr_title VARCHAR2)

Line 1984: p_x_nr_profile_header_rec.nr_profile_header_id := AHL_NR_PROFILE_HEADERS_S.NEXTVAL;

1980: THEN
1981:
1982: IF( p_x_nr_profile_header_rec.nr_profile_header_id IS NULL)
1983: THEN
1984: p_x_nr_profile_header_rec.nr_profile_header_id := AHL_NR_PROFILE_HEADERS_S.NEXTVAL;
1985: END IF;
1986:
1987: IF(p_x_nr_profile_header_rec.object_version_number IS NULL)
1988: THEN

Line 1992: INSERT INTO AHL_NR_PROFILE_HEADERS

1988: THEN
1989: p_x_nr_profile_header_rec.object_version_number := 1;
1990: END IF;
1991:
1992: INSERT INTO AHL_NR_PROFILE_HEADERS
1993: (
1994: NR_PROFILE_HEADER_ID,
1995: OBJECT_VERSION_NUMBER,
1996: LAST_UPDATE_DATE,

Line 2057: UPDATE ahl_nr_profile_headers

2053: ) RETURNING nr_profile_header_id INTO p_x_nr_profile_header_rec.nr_profile_header_id;
2054:
2055: ELSIF (p_x_nr_profile_header_rec.dml_operation = 'U')
2056: THEN
2057: UPDATE ahl_nr_profile_headers
2058: SET object_version_number = object_version_number +1,
2059: last_update_date = SYSDATE,
2060: last_updated_by = FND_GLOBAL.user_id,
2061: last_update_login = FND_GLOBAL.login_id,

Line 2136: DELETE FROM AHL_NR_PROFILE_HEADERS

2132: DELETE FROM AHL_NR_PROFILE_DETAILS
2133: WHERE NR_PROFILE_HEADER_ID = l_nr_profile_header_id;
2134:
2135: -- Delete Profile Header
2136: DELETE FROM AHL_NR_PROFILE_HEADERS
2137: WHERE NR_PROFILE_HEADER_ID = l_nr_profile_header_id;
2138:
2139: ELSE
2140:

Line 2141: UPDATE AHL_NR_PROFILE_HEADERS

2137: WHERE NR_PROFILE_HEADER_ID = l_nr_profile_header_id;
2138:
2139: ELSE
2140:
2141: UPDATE AHL_NR_PROFILE_HEADERS
2142: SET object_version_number = object_version_number +1,
2143: last_update_date = SYSDATE,
2144: last_updated_by = FND_GLOBAL.user_id,
2145: last_update_login = FND_GLOBAL.login_id,