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 1866: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,

1862: PROCEDURE validate_master_configuration
1863: (
1864: x_return_status OUT NOCOPY VARCHAR2,
1865: x_msg_data OUT NOCOPY VARCHAR2,
1866: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
1867: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
1868: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
1869: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1870: )

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

1863: (
1864: x_return_status OUT NOCOPY VARCHAR2,
1865: x_msg_data OUT NOCOPY VARCHAR2,
1866: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
1867: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
1868: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
1869: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1870: )
1871: IS

Line 1868: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,

1864: x_return_status OUT NOCOPY VARCHAR2,
1865: x_msg_data OUT NOCOPY VARCHAR2,
1866: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
1867: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
1868: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
1869: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1870: )
1871: IS
1872:

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

1865: x_msg_data OUT NOCOPY VARCHAR2,
1866: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
1867: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
1868: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
1869: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1870: )
1871: IS
1872:
1873: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;

Line 1873: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;

1869: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
1870: )
1871: IS
1872:
1873: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;
1874: l_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE;
1875:
1876: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )
1877: IS

Line 1874: l_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE;

1870: )
1871: IS
1872:
1873: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;
1874: l_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE;
1875:
1876: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )
1877: IS
1878: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance

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

1872:
1873: l_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE;
1874: l_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE;
1875:
1876: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )
1877: IS
1878: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1879: SELECT DISTINCT mc_id
1880: FROM AHL_MC_HEADERS_B

Line 1885: FROM AHL_MC_HEADERS_V

1881: WHERE upper(name) = upper(c_mc_name)
1882: AND CONFIG_STATUS_CODE='COMPLETE';
1883:
1884: /*SELECT DISTINCT mc_id
1885: FROM AHL_MC_HEADERS_V
1886: WHERE upper(name) = upper(c_mc_name)
1887: AND CONFIG_STATUS_CODE='COMPLETE';*/
1888:
1889: 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 1889: CURSOR get_rec_from_value1 ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE , c_mc_revision_number AHL_MC_HEADERS_V.REVISION%TYPE)

1885: FROM AHL_MC_HEADERS_V
1886: WHERE upper(name) = upper(c_mc_name)
1887: AND CONFIG_STATUS_CODE='COMPLETE';*/
1888:
1889: CURSOR get_rec_from_value1 ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE , c_mc_revision_number AHL_MC_HEADERS_V.REVISION%TYPE)
1890: IS
1891: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1892: SELECT DISTINCT mc_header_id, mc_id
1893: FROM AHL_MC_HEADERS_B

Line 1900: FROM AHL_MC_HEADERS_V

1896: AND CONFIG_STATUS_CODE='COMPLETE';
1897: /*
1898: SELECT DISTINCT mc_header_id,
1899: mc_id
1900: FROM AHL_MC_HEADERS_V
1901: WHERE upper(name) = upper(c_mc_name)
1902: AND upper(revision)=upper(c_mc_revision_number)
1903: AND CONFIG_STATUS_CODE='COMPLETE';*/
1904:

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

1902: AND upper(revision)=upper(c_mc_revision_number)
1903: AND CONFIG_STATUS_CODE='COMPLETE';*/
1904:
1905: /*
1906: CURSOR get_rec_from_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )
1907: IS
1908: SELECT DISTINCT mc_header_id
1909: FROM AHL_MC_HEADERS_V
1910: WHERE mc_header_id = c_mc_header_id

Line 1909: FROM AHL_MC_HEADERS_V

1905: /*
1906: CURSOR get_rec_from_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )
1907: IS
1908: SELECT DISTINCT mc_header_id
1909: FROM AHL_MC_HEADERS_V
1910: WHERE mc_header_id = c_mc_header_id
1911: AND CONFIG_STATUS_CODE='COMPLETE'
1912: ;
1913:

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

1910: WHERE mc_header_id = c_mc_header_id
1911: AND CONFIG_STATUS_CODE='COMPLETE'
1912: ;
1913:
1914: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )
1915: IS
1916: SELECT DISTINCT mc_id
1917: FROM AHL_MC_HEADERS_V
1918: WHERE mc_id = c_mc_id

Line 1917: FROM AHL_MC_HEADERS_V

1913:
1914: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )
1915: IS
1916: SELECT DISTINCT mc_id
1917: FROM AHL_MC_HEADERS_V
1918: WHERE mc_id = c_mc_id
1919: AND CONFIG_STATUS_CODE='COMPLETE'
1920: ;
1921: */

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

1919: AND CONFIG_STATUS_CODE='COMPLETE'
1920: ;
1921: */
1922: /*
1923: CURSOR get_rec_status_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )
1924: IS
1925: SELECT DISTINCT mc_id
1926: FROM AHL_MC_HEADERS_V
1927: WHERE mc_id = c_mc_id

Line 1926: FROM AHL_MC_HEADERS_V

1922: /*
1923: CURSOR get_rec_status_id ( c_mc_id AHL_MC_HEADERS_V.MC_ID%TYPE )
1924: IS
1925: SELECT DISTINCT mc_id
1926: FROM AHL_MC_HEADERS_V
1927: WHERE mc_id = c_mc_id
1928: AND CONFIG_STATUS_CODE='COMPLETE'
1929: ;
1930:

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

1927: WHERE mc_id = c_mc_id
1928: AND CONFIG_STATUS_CODE='COMPLETE'
1929: ;
1930:
1931: CURSOR get_rec_status_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )
1932: IS
1933: SELECT DISTINCT mc_header_id
1934: FROM AHL_MC_HEADERS_V
1935: WHERE mc_header_id = c_mc_header_id

Line 1934: FROM AHL_MC_HEADERS_V

1930:
1931: CURSOR get_rec_status_id1 ( c_mc_header_id AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE )
1932: IS
1933: SELECT DISTINCT mc_header_id
1934: FROM AHL_MC_HEADERS_V
1935: WHERE mc_header_id = c_mc_header_id
1936: AND CONFIG_STATUS_CODE='COMPLETE'
1937: ;
1938: */

Line 4274: p_mc_name IN AHL_MC_HEADERS_VL.name%TYPE,

4270: PROCEDURE Validate_Master_Config
4271: (
4272: x_return_status OUT NOCOPY VARCHAR2,
4273: x_msg_data OUT NOCOPY VARCHAR2,
4274: p_mc_name IN AHL_MC_HEADERS_VL.name%TYPE,
4275: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_VL.mc_id%TYPE
4276: )
4277: IS
4278: l_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE;

Line 4275: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_VL.mc_id%TYPE

4271: (
4272: x_return_status OUT NOCOPY VARCHAR2,
4273: x_msg_data OUT NOCOPY VARCHAR2,
4274: p_mc_name IN AHL_MC_HEADERS_VL.name%TYPE,
4275: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_VL.mc_id%TYPE
4276: )
4277: IS
4278: l_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE;
4279: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_VL.name%TYPE)

Line 4278: l_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE;

4274: p_mc_name IN AHL_MC_HEADERS_VL.name%TYPE,
4275: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_VL.mc_id%TYPE
4276: )
4277: IS
4278: l_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE;
4279: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_VL.name%TYPE)
4280: IS
4281: SELECT mc_id
4282: FROM AHL_MC_HEADERS_VL mc_header1

Line 4279: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_VL.name%TYPE)

4275: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_VL.mc_id%TYPE
4276: )
4277: IS
4278: l_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE;
4279: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_VL.name%TYPE)
4280: IS
4281: SELECT mc_id
4282: FROM AHL_MC_HEADERS_VL mc_header1
4283: where

Line 4282: FROM AHL_MC_HEADERS_VL mc_header1

4278: l_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE;
4279: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_VL.name%TYPE)
4280: IS
4281: SELECT mc_id
4282: FROM AHL_MC_HEADERS_VL mc_header1
4283: where
4284: mc_header1.name = c_mc_name and
4285: mc_header1.config_status_code = 'COMPLETE'
4286: AND rowid = (SELECT MIN(rowid) FROM AHL_MC_HEADERS_VL where config_status_code = 'COMPLETE' and name = mc_header1.name);

Line 4286: AND rowid = (SELECT MIN(rowid) FROM AHL_MC_HEADERS_VL where config_status_code = 'COMPLETE' and name = mc_header1.name);

4282: FROM AHL_MC_HEADERS_VL mc_header1
4283: where
4284: mc_header1.name = c_mc_name and
4285: mc_header1.config_status_code = 'COMPLETE'
4286: AND rowid = (SELECT MIN(rowid) FROM AHL_MC_HEADERS_VL where config_status_code = 'COMPLETE' and name = mc_header1.name);
4287: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE)
4288: IS
4289: SELECT mc_id
4290: FROM AHL_MC_HEADERS_VL mc_header1

Line 4287: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE)

4283: where
4284: mc_header1.name = c_mc_name and
4285: mc_header1.config_status_code = 'COMPLETE'
4286: AND rowid = (SELECT MIN(rowid) FROM AHL_MC_HEADERS_VL where config_status_code = 'COMPLETE' and name = mc_header1.name);
4287: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE)
4288: IS
4289: SELECT mc_id
4290: FROM AHL_MC_HEADERS_VL mc_header1
4291: where

Line 4290: FROM AHL_MC_HEADERS_VL mc_header1

4286: AND rowid = (SELECT MIN(rowid) FROM AHL_MC_HEADERS_VL where config_status_code = 'COMPLETE' and name = mc_header1.name);
4287: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE)
4288: IS
4289: SELECT mc_id
4290: FROM AHL_MC_HEADERS_VL mc_header1
4291: where
4292: mc_header1.mc_id = c_mc_id and
4293: mc_header1.config_status_code = 'COMPLETE'
4294: AND rowid = (SELECT MIN(rowid) FROM AHL_MC_HEADERS_VL where config_status_code = 'COMPLETE' and mc_id = mc_header1.mc_id);

Line 4294: AND rowid = (SELECT MIN(rowid) FROM AHL_MC_HEADERS_VL where config_status_code = 'COMPLETE' and mc_id = mc_header1.mc_id);

4290: FROM AHL_MC_HEADERS_VL mc_header1
4291: where
4292: mc_header1.mc_id = c_mc_id and
4293: mc_header1.config_status_code = 'COMPLETE'
4294: AND rowid = (SELECT MIN(rowid) FROM AHL_MC_HEADERS_VL where config_status_code = 'COMPLETE' and mc_id = mc_header1.mc_id);
4295: BEGIN
4296: x_return_status := FND_API.G_RET_STS_SUCCESS;
4297: IF ( ( p_mc_name IS NULL OR
4298: p_mc_name = FND_API.G_MISS_CHAR ) AND

Line 4349: p_mc_id IN AHL_MC_HEADERS_VL.mc_id%TYPE,

4345: PROCEDURE Validate_Mc_Position
4346: (
4347: x_return_status OUT NOCOPY VARCHAR2,
4348: x_msg_data OUT NOCOPY VARCHAR2,
4349: p_mc_id IN AHL_MC_HEADERS_VL.mc_id%TYPE,
4350: p_mc_position IN FND_LOOKUP_VALUES_VL.meaning%TYPE,
4351: p_x_mc_position_key IN OUT NOCOPY AHL_MC_RELATIONSHIPS.position_key%TYPE
4352: )
4353: IS

Line 4356: CURSOR get_rec_from_value ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position FND_LOOKUP_VALUES_VL.meaning%TYPE)

4352: )
4353: IS
4354: l_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE;
4355:
4356: CURSOR get_rec_from_value ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position FND_LOOKUP_VALUES_VL.meaning%TYPE)
4357: IS
4358: SELECT DISTINCT amr.position_key
4359: FROM
4360: AHL_MC_RELATIONSHIPS amr,

Line 4362: AHL_MC_HEADERS_VL amh

4358: SELECT DISTINCT amr.position_key
4359: FROM
4360: AHL_MC_RELATIONSHIPS amr,
4361: FND_LOOKUP_VALUES_VL flv,
4362: AHL_MC_HEADERS_VL amh
4363: WHERE
4364: amr.mc_header_id = amh.mc_header_id AND
4365: amh.mc_id = NVL(c_mc_id,-1) AND
4366: amh.config_status_code = 'COMPLETE' AND

Line 4389: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE )

4385: nvl(mcrule.active_end_date,SYSDATE +1) > SYSDATE and
4386: amh2.config_status_code = 'COMPLETE' and
4387: nvl(rel.active_end_date, SYSDATE + 1) > SYSDATE);
4388:
4389: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE )
4390: IS
4391: SELECT DISTINCT amr.position_key
4392: FROM
4393: AHL_MC_RELATIONSHIPS amr,

Line 4394: AHL_MC_HEADERS_VL amh

4390: IS
4391: SELECT DISTINCT amr.position_key
4392: FROM
4393: AHL_MC_RELATIONSHIPS amr,
4394: AHL_MC_HEADERS_VL amh
4395: WHERE
4396: amr.mc_header_id = amh.mc_header_id and
4397: amh.mc_id = NVL(c_mc_id,-1) and
4398: amh.config_status_code = 'COMPLETE' AND