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 1106: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := NULL;

1102: and instance_id = c_mr_instance_id;
1103:
1104: l_dummy VARCHAR2(1);
1105: l_mr_header_id NUMBER := NULL;
1106: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := NULL;
1107: l_mr_version_number NUMBER := NULL;
1108: l_valid BOOLEAN;
1109: l_flag_sr_mr_inst VARCHAR2(1); --amsriniv ER 5883257
1110: l_temp_return_status VARCHAR2(1);

Line 1116: l_program_type_code AHL_MR_HEADERS_B.PROGRAM_TYPE_CODE%TYPE;

1112: l_temp_msg_data VARCHAR2(2000);
1113: l_applicable_mr_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;
1114: l_mr_applicable BOOLEAN;
1115:
1116: l_program_type_code AHL_MR_HEADERS_B.PROGRAM_TYPE_CODE%TYPE;
1117:
1118: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Association_Records';
1119:
1120: BEGIN

Line 1918: l_dup_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;

1914: SELECT count(*) from AHL_APPLICABLE_MR_RELNS;*/
1915:
1916:
1917: l_duplicate_mr_id NUMBER;
1918: l_dup_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
1919: l_curr_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
1920: l_duplicate_inst_id NUMBER;
1921: l_new_ue_id NUMBER;
1922: l_new_rel_id NUMBER;

Line 1919: l_curr_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;

1915:
1916:
1917: l_duplicate_mr_id NUMBER;
1918: l_dup_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
1919: l_curr_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
1920: l_duplicate_inst_id NUMBER;
1921: l_new_ue_id NUMBER;
1922: l_new_rel_id NUMBER;
1923: l_temp_count NUMBER := 0;

Line 2073: FROM AHL_MR_HEADERS_B

2069: RETURN VARCHAR2 IS
2070:
2071: CURSOR get_mr_title_csr IS
2072: SELECT TITLE
2073: FROM AHL_MR_HEADERS_B
2074: WHERE MR_HEADER_ID = p_mr_header_id;
2075:
2076: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;
2077:

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

2072: SELECT TITLE
2073: FROM AHL_MR_HEADERS_B
2074: WHERE MR_HEADER_ID = p_mr_header_id;
2075:
2076: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;
2077:
2078: BEGIN
2079: OPEN get_mr_title_csr;
2080: FETCH get_mr_title_csr INTO l_mr_title;

Line 2093: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE

2089: RETURN VARCHAR2 IS
2090:
2091: CURSOR get_mr_title_csr IS
2092: SELECT MR.TITLE
2093: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE
2094: WHERE UE.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id AND
2095: UE.MR_HEADER_ID = MR.MR_HEADER_ID;
2096:
2097: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;

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

2093: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE
2094: WHERE UE.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id AND
2095: UE.MR_HEADER_ID = MR.MR_HEADER_ID;
2096:
2097: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;
2098:
2099: BEGIN
2100: OPEN get_mr_title_csr;
2101: FETCH get_mr_title_csr INTO l_mr_title;