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_VL

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