APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 4884: FROM ahl_unit_config_headers

4880: IS
4881:
4882: CURSOR ahl_uc_headers_csr(p_unit_name IN VARCHAR2) IS
4883: SELECT unit_config_header_id
4884: FROM ahl_unit_config_headers
4885: WHERE name = p_unit_name;
4886:
4887: l_uc_header_id NUMBER;
4888: l_junk VARCHAR2(1);

Line 4962: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS

4958: FROM csi_item_instances
4959: WHERE instance_id = p_csi_item_instance_id;
4960:
4961: -- To validate unit.
4962: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS
4963: SELECT name, active_start_date, active_end_date, csi_item_instance_id
4964: FROM ahl_unit_config_headers
4965: WHERE unit_config_header_id = p_uc_header_id;
4966:

Line 4964: FROM ahl_unit_config_headers

4960:
4961: -- To validate unit.
4962: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS
4963: SELECT name, active_start_date, active_end_date, csi_item_instance_id
4964: FROM ahl_unit_config_headers
4965: WHERE unit_config_header_id = p_uc_header_id;
4966:
4967: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
4968: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;

Line 4974: l_name ahl_unit_config_headers.name%TYPE;

4970: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
4971: l_csi_item_instance_id NUMBER;
4972: l_active_end_date DATE;
4973: l_active_start_date DATE;
4974: l_name ahl_unit_config_headers.name%TYPE;
4975: l_instance_number csi_item_instances.instance_number%TYPE;
4976:
4977: BEGIN
4978:

Line 5025: OPEN ahl_unit_config_headers_csr (p_unit_config_header_id);

5021: END IF;
5022:
5023: -- Validate unit config id.
5024: IF (p_unit_config_header_id IS NOT NULL) THEN
5025: OPEN ahl_unit_config_headers_csr (p_unit_config_header_id);
5026: FETCH ahl_unit_config_headers_csr INTO l_name, l_active_start_date,
5027: l_active_end_date, l_csi_item_instance_id;
5028: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
5029: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');

Line 5026: FETCH ahl_unit_config_headers_csr INTO l_name, l_active_start_date,

5022:
5023: -- Validate unit config id.
5024: IF (p_unit_config_header_id IS NOT NULL) THEN
5025: OPEN ahl_unit_config_headers_csr (p_unit_config_header_id);
5026: FETCH ahl_unit_config_headers_csr INTO l_name, l_active_start_date,
5027: l_active_end_date, l_csi_item_instance_id;
5028: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
5029: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
5030: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_header_id);

Line 5028: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN

5024: IF (p_unit_config_header_id IS NOT NULL) THEN
5025: OPEN ahl_unit_config_headers_csr (p_unit_config_header_id);
5026: FETCH ahl_unit_config_headers_csr INTO l_name, l_active_start_date,
5027: l_active_end_date, l_csi_item_instance_id;
5028: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
5029: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
5030: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_header_id);
5031: FND_MSG_PUB.ADD;
5032: --dbms_output.put_line('Unit not found');

Line 5033: CLOSE ahl_unit_config_headers_csr;

5029: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
5030: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_header_id);
5031: FND_MSG_PUB.ADD;
5032: --dbms_output.put_line('Unit not found');
5033: CLOSE ahl_unit_config_headers_csr;
5034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5035:
5036: -- Dates obsoleted 11.5.10.
5037: -- ELSIF (trunc(l_active_start_date) > trunc(sysdate) OR