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_SR_PVT dependencies on AHL_MR_HEADERS_B

Line 1140: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := NULL;

1136: and instance_id = c_mr_instance_id;
1137:
1138: l_dummy VARCHAR2(1);
1139: l_mr_header_id NUMBER := NULL;
1140: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := NULL;
1141: l_mr_version_number NUMBER := NULL;
1142: l_valid BOOLEAN;
1143: l_flag_sr_mr_inst VARCHAR2(1); --amsriniv ER 5883257
1144: l_temp_return_status VARCHAR2(1);

Line 1150: l_program_type_code AHL_MR_HEADERS_B.PROGRAM_TYPE_CODE%TYPE;

1146: l_temp_msg_data VARCHAR2(2000);
1147: l_applicable_mr_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;
1148: l_mr_applicable BOOLEAN;
1149:
1150: l_program_type_code AHL_MR_HEADERS_B.PROGRAM_TYPE_CODE%TYPE;
1151:
1152: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Association_Records';
1153:
1154: BEGIN

Line 1449: AHL_MR_HEADERS_B MRH

1445: Cursor Chk_UE_Init_Due (p_mr_header_id NUMBER, p_instance_id NUMBER)
1446: IS
1447: SELECT 'x'
1448: FROM AHL_UNIT_EFFECTIVITIES_B UE,
1449: AHL_MR_HEADERS_B MRH
1450: WHERE UE.mr_header_id = p_mr_header_id
1451: AND MRH.mr_header_id = UE.mr_header_id
1452: AND MRH.IMPLEMENT_STATUS_CODE IN ('MANDATORY','OPTIONAL_IMPLEMENT')
1453: AND UE.csi_item_instance_id = p_instance_id

Line 2002: AHL_MR_HEADERS_B MRH

1998: Cursor Chk_UE_Init_Due (p_mr_header_id NUMBER, p_instance_id NUMBER)
1999: IS
2000: SELECT 'x'
2001: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2002: AHL_MR_HEADERS_B MRH
2003: WHERE UE.mr_header_id = p_mr_header_id
2004: AND MRH.mr_header_id = UE.mr_header_id
2005: AND MRH.IMPLEMENT_STATUS_CODE IN ('MANDATORY','OPTIONAL_IMPLEMENT')
2006: AND UE.csi_item_instance_id = p_instance_id

Line 2010: l_dup_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;

2006: AND UE.csi_item_instance_id = p_instance_id
2007: AND UE.status_code = 'INIT-DUE';
2008:
2009: l_duplicate_mr_id NUMBER;
2010: l_dup_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
2011: l_curr_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
2012: l_duplicate_inst_id NUMBER;
2013: l_new_ue_id NUMBER;
2014: l_new_rel_id NUMBER;

Line 2011: l_curr_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;

2007: AND UE.status_code = 'INIT-DUE';
2008:
2009: l_duplicate_mr_id NUMBER;
2010: l_dup_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
2011: l_curr_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
2012: l_duplicate_inst_id NUMBER;
2013: l_new_ue_id NUMBER;
2014: l_new_rel_id NUMBER;
2015: l_temp_count NUMBER := 0;

Line 2024: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := NULL;

2020: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Process_Group_MR';
2021:
2022: --pdoki added for ER 9583373
2023: l_dummy VARCHAR2(1);
2024: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := NULL;
2025:
2026: BEGIN
2027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2028: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

Line 2125: FROM AHL_MR_HEADERS_B

2121: IF (Chk_UE_Init_Due%FOUND) THEN
2122: --pick the MR Title
2123: SELECT title
2124: INTO l_mr_title
2125: FROM AHL_MR_HEADERS_B
2126: WHERE mr_header_id = mr_rel_rec.RELATED_MR_HEADER_ID;
2127:
2128: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
2129: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);

Line 2190: FROM AHL_MR_HEADERS_B

2186: RETURN VARCHAR2 IS
2187:
2188: CURSOR get_mr_title_csr IS
2189: SELECT TITLE
2190: FROM AHL_MR_HEADERS_B
2191: WHERE MR_HEADER_ID = p_mr_header_id;
2192:
2193: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;
2194:

Line 2193: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;

2189: SELECT TITLE
2190: FROM AHL_MR_HEADERS_B
2191: WHERE MR_HEADER_ID = p_mr_header_id;
2192:
2193: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;
2194:
2195: BEGIN
2196: OPEN get_mr_title_csr;
2197: FETCH get_mr_title_csr INTO l_mr_title;

Line 2210: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE

2206: RETURN VARCHAR2 IS
2207:
2208: CURSOR get_mr_title_csr IS
2209: SELECT MR.TITLE
2210: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE
2211: WHERE UE.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id AND
2212: UE.MR_HEADER_ID = MR.MR_HEADER_ID;
2213:
2214: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;

Line 2214: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;

2210: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE
2211: WHERE UE.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id AND
2212: UE.MR_HEADER_ID = MR.MR_HEADER_ID;
2213:
2214: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;
2215:
2216: BEGIN
2217: OPEN get_mr_title_csr;
2218: FETCH get_mr_title_csr INTO l_mr_title;