APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_MR_HEADERS_B

Line 1225: FROM AHL_MR_HEADERS_B

1221:
1222: CURSOR l_get_mr_id_csr(p_mr_title IN VARCHAR2,
1223: p_mr_version_number IN NUMBER) IS
1224: SELECT MR_HEADER_ID
1225: FROM AHL_MR_HEADERS_B
1226: WHERE TITLE = p_mr_title AND
1227: VERSION_NUMBER = p_mr_version_number;
1228:
1229: CURSOR l_get_item_instance_id_csr(p_instance_number IN VARCHAR2) IS

Line 1552: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,

1548:
1549: -- For bug# 4172783.
1550: CURSOR l_ue_err_details_csr (p_ue_id IN NUMBER) IS
1551: SELECT CSI.instance_number, UE.due_date, MR.title
1552: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,
1553: csi_item_instances CSI
1554: WHERE UE.unit_effectivity_id = p_ue_id
1555: AND UE.mr_header_id = MR.mr_header_id
1556: AND UE.csi_item_instance_id = CSI.instance_id;

Line 1577: FROM ahl_mr_headers_b

1573:
1574: -- get mr title
1575: CURSOR get_title_csr(p_mr_id IN NUMBER) IS
1576: SELECT title
1577: FROM ahl_mr_headers_b
1578: WHERE mr_header_id = p_mr_id;
1579:
1580: -- SALOGAN added the following for Complex Mx - Begin
1581: CURSOR is_NR_UE(p_ue_id IN NUMBER) IS

Line 1607: l_err_title ahl_mr_headers_b.title%TYPE;

1603: l_prior_ue_status VARCHAR2(20);
1604:
1605: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;
1606: l_err_due_date DATE;
1607: l_err_title ahl_mr_headers_b.title%TYPE;
1608: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;
1609: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;
1610: -- added to validate visit status.
1611: l_visit_status VARCHAR2(100);

Line 4129: SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_B

4125:
4126:
4127:
4128: CURSOR l_get_mr_header_id(p_mr_title IN VARCHAR2, p_version_number IN NUMBER) IS
4129: SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_B
4130: WHERE TITLE = p_mr_title AND VERSION_NUMBER = p_version_number;
4131:
4132: CURSOR l_get_effective_to_date(p_mr_header_id IN NUMBER) IS
4133: SELECT EFFECTIVE_TO, application_usg_code FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;

Line 4318: l_application_usg_code ahl_mr_headers_b.application_usg_code%TYPE;

4314: CONNECT BY ue_id = PRIOR related_ue_id
4315: AND relationship_code = 'PARENT';
4316:
4317: l_ue_descendent_rec l_ue_descendent_csr%ROWTYPE;
4318: l_application_usg_code ahl_mr_headers_b.application_usg_code%TYPE;
4319: l_junk varchar2(1);
4320: --l_req_id number;
4321:
4322: CURSOR get_mr_copy_dtls_csr(p_mr_header_id IN NUMBER) IS

Line 4930: UPDATE AHL_MR_HEADERS_B

4926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4927: END IF;
4928:
4929: IF(l_new_mr_header_id IS NOT NULL)THEN
4930: UPDATE AHL_MR_HEADERS_B
4931: SET TERMINATION_REQUIRED_FLAG = 'N'
4932: WHERE MR_HEADER_ID=l_old_mr_header_id;
4933:
4934: OPEN get_mr_copy_dtls_csr(l_new_mr_header_id);

Line 5840: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,

5836: AND status = 'COMPLETE';
5837:
5838: CURSOR get_mr_for_pc_csr (c_pc_header_id NUMBER) IS
5839: SELECT mrh.mr_header_id, mre.mr_effectivity_id
5840: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,
5841: ahl_pc_nodes_b pcn
5842: WHERE mrh.mr_header_id = mre.mr_header_id
5843: AND mre.pc_node_id = pcn.pc_node_id
5844: AND pcn.pc_header_id = c_pc_header_id

Line 6086: AHL_MR_HEADERS_B

6082: version_number,
6083: effective_to,
6084: application_usg_code
6085: FROM
6086: AHL_MR_HEADERS_B
6087: WHERE
6088: TRUNC(effective_to) <= TRUNC(SYSDATE)
6089: AND MR_STATUS_CODE = 'COMPLETE'
6090: AND TERMINATION_REQUIRED_FLAG = 'Y'

Line 6097: FROM AHL_MR_HEADERS_B

6093: CURSOR GetNewMR_csr(C_TITLE VARCHAR2,C_VERSION_NUMBER NUMBER,C_APP_CODE VARCHAR2,c_effective_from DATE)
6094: IS
6095: SELECT mr_header_id,
6096: version_number
6097: FROM AHL_MR_HEADERS_B
6098: WHERE TITLE=C_TITLE
6099: AND VERSION_NUMBER = C_VERSION_NUMBER+1
6100: AND APPLICATION_USG_CODE=C_APP_CODE
6101: AND MR_STATUS_CODE = 'COMPLETE'