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_RM_ROUTE_UTIL dependencies on AHL_MC_HEADERS_V

Line 1734: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,

1730: PROCEDURE validate_master_configuration
1731: (
1732: x_return_status OUT NOCOPY VARCHAR2,
1733: x_msg_data OUT NOCOPY VARCHAR2,
1734: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
1735: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
1736: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
1737: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1738: )

Line 1735: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,

1731: (
1732: x_return_status OUT NOCOPY VARCHAR2,
1733: x_msg_data OUT NOCOPY VARCHAR2,
1734: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
1735: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
1736: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
1737: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1738: )
1739: IS

Line 1736: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,

1732: x_return_status OUT NOCOPY VARCHAR2,
1733: x_msg_data OUT NOCOPY VARCHAR2,
1734: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
1735: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
1736: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
1737: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1738: )
1739: IS
1740:

Line 1737: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE

1733: x_msg_data OUT NOCOPY VARCHAR2,
1734: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
1735: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
1736: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
1737: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1738: )
1739: IS
1740:
1741: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;

Line 1741: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;

1737: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1738: )
1739: IS
1740:
1741: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;
1742: l_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE;
1743:
1744: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )
1745: IS

Line 1742: l_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE;

1738: )
1739: IS
1740:
1741: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;
1742: l_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE;
1743:
1744: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )
1745: IS
1746: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance

Line 1744: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )

1740:
1741: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;
1742: l_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE;
1743:
1744: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )
1745: IS
1746: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1747: SELECT DISTINCT mc_id
1748: FROM AHL_MC_HEADERS_B

Line 1753: FROM AHL_MC_HEADERS_V

1749: WHERE upper(name) = upper(c_mc_name)
1750: AND CONFIG_STATUS_CODE='COMPLETE';
1751:
1752: /*SELECT DISTINCT mc_id
1753: FROM AHL_MC_HEADERS_V
1754: WHERE upper(name) = upper(c_mc_name)
1755: AND CONFIG_STATUS_CODE='COMPLETE';*/
1756:
1757: CURSOR get_rec_from_value1 ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE , c_mc_revision_number AHL_MC_HEADERS_V.REVISION%TYPE)

Line 1757: CURSOR get_rec_from_value1 ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE , c_mc_revision_number AHL_MC_HEADERS_V.REVISION%TYPE)

1753: FROM AHL_MC_HEADERS_V
1754: WHERE upper(name) = upper(c_mc_name)
1755: AND CONFIG_STATUS_CODE='COMPLETE';*/
1756:
1757: CURSOR get_rec_from_value1 ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE , c_mc_revision_number AHL_MC_HEADERS_V.REVISION%TYPE)
1758: IS
1759: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1760: SELECT DISTINCT mc_header_id, mc_id
1761: FROM AHL_MC_HEADERS_B

Line 1768: FROM AHL_MC_HEADERS_V

1764: AND CONFIG_STATUS_CODE='COMPLETE';
1765: /*
1766: SELECT DISTINCT mc_header_id,
1767: mc_id
1768: FROM AHL_MC_HEADERS_V
1769: WHERE upper(name) = upper(c_mc_name)
1770: AND upper(revision)=upper(c_mc_revision_number)
1771: AND CONFIG_STATUS_CODE='COMPLETE';*/
1772:

Line 1774: CURSOR get_rec_from_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )

1770: AND upper(revision)=upper(c_mc_revision_number)
1771: AND CONFIG_STATUS_CODE='COMPLETE';*/
1772:
1773: /*
1774: CURSOR get_rec_from_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )
1775: IS
1776: SELECT DISTINCT mc_header_id
1777: FROM AHL_MC_HEADERS_V
1778: WHERE mc_header_id = c_mc_header_id

Line 1777: FROM AHL_MC_HEADERS_V

1773: /*
1774: CURSOR get_rec_from_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )
1775: IS
1776: SELECT DISTINCT mc_header_id
1777: FROM AHL_MC_HEADERS_V
1778: WHERE mc_header_id = c_mc_header_id
1779: AND CONFIG_STATUS_CODE='COMPLETE'
1780: ;
1781:

Line 1782: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )

1778: WHERE mc_header_id = c_mc_header_id
1779: AND CONFIG_STATUS_CODE='COMPLETE'
1780: ;
1781:
1782: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )
1783: IS
1784: SELECT DISTINCT mc_id
1785: FROM AHL_MC_HEADERS_V
1786: WHERE mc_id = c_mc_id

Line 1785: FROM AHL_MC_HEADERS_V

1781:
1782: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )
1783: IS
1784: SELECT DISTINCT mc_id
1785: FROM AHL_MC_HEADERS_V
1786: WHERE mc_id = c_mc_id
1787: AND CONFIG_STATUS_CODE='COMPLETE'
1788: ;
1789: */

Line 1791: CURSOR get_rec_status_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )

1787: AND CONFIG_STATUS_CODE='COMPLETE'
1788: ;
1789: */
1790: /*
1791: CURSOR get_rec_status_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )
1792: IS
1793: SELECT DISTINCT mc_id
1794: FROM AHL_MC_HEADERS_V
1795: WHERE mc_id = c_mc_id

Line 1794: FROM AHL_MC_HEADERS_V

1790: /*
1791: CURSOR get_rec_status_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )
1792: IS
1793: SELECT DISTINCT mc_id
1794: FROM AHL_MC_HEADERS_V
1795: WHERE mc_id = c_mc_id
1796: AND CONFIG_STATUS_CODE='COMPLETE'
1797: ;
1798:

Line 1799: CURSOR get_rec_status_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )

1795: WHERE mc_id = c_mc_id
1796: AND CONFIG_STATUS_CODE='COMPLETE'
1797: ;
1798:
1799: CURSOR get_rec_status_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )
1800: IS
1801: SELECT DISTINCT mc_header_id
1802: FROM AHL_MC_HEADERS_V
1803: WHERE mc_header_id = c_mc_header_id

Line 1802: FROM AHL_MC_HEADERS_V

1798:
1799: CURSOR get_rec_status_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )
1800: IS
1801: SELECT DISTINCT mc_header_id
1802: FROM AHL_MC_HEADERS_V
1803: WHERE mc_header_id = c_mc_header_id
1804: AND CONFIG_STATUS_CODE='COMPLETE'
1805: ;
1806: */