APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 5222: FROM ahl_unit_config_headers

5218: IS
5219:
5220: CURSOR ahl_uc_headers_csr(p_unit_name IN VARCHAR2) IS
5221: SELECT unit_config_header_id
5222: FROM ahl_unit_config_headers
5223: WHERE name = p_unit_name;
5224:
5225: l_uc_header_id NUMBER;
5226: l_junk VARCHAR2(1);

Line 5303: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS

5299: FROM csi_item_instances
5300: WHERE instance_id = p_csi_item_instance_id;
5301:
5302: -- To validate unit.
5303: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS
5304: SELECT name, active_start_date, active_end_date, csi_item_instance_id
5305: FROM ahl_unit_config_headers
5306: WHERE unit_config_header_id = p_uc_header_id;
5307:

Line 5305: FROM ahl_unit_config_headers

5301:
5302: -- To validate unit.
5303: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS
5304: SELECT name, active_start_date, active_end_date, csi_item_instance_id
5305: FROM ahl_unit_config_headers
5306: WHERE unit_config_header_id = p_uc_header_id;
5307:
5308: -- JKJain, NR Analysis and Forecasting
5309: CURSOR ahl_simulation_plan_csr (c_simulation_plan_id NUMBER, c_unit_config_header_id NUMBER) IS

Line 5326: l_name ahl_unit_config_headers.name%TYPE;

5322: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5323: l_csi_item_instance_id NUMBER;
5324: l_active_end_date DATE;
5325: l_active_start_date DATE;
5326: l_name ahl_unit_config_headers.name%TYPE;
5327: l_instance_number csi_item_instances.instance_number%TYPE;
5328: l_dummy_var VARCHAR2(1);
5329:
5330: BEGIN

Line 5381: OPEN ahl_unit_config_headers_csr (p_unit_config_header_id);

5377: END IF;
5378:
5379: -- Validate unit config id.
5380: IF (p_unit_config_header_id IS NOT NULL) THEN
5381: OPEN ahl_unit_config_headers_csr (p_unit_config_header_id);
5382: FETCH ahl_unit_config_headers_csr INTO l_name, l_active_start_date,
5383: l_active_end_date, l_csi_item_instance_id;
5384: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
5385: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');

Line 5382: FETCH ahl_unit_config_headers_csr INTO l_name, l_active_start_date,

5378:
5379: -- Validate unit config id.
5380: IF (p_unit_config_header_id IS NOT NULL) THEN
5381: OPEN ahl_unit_config_headers_csr (p_unit_config_header_id);
5382: FETCH ahl_unit_config_headers_csr INTO l_name, l_active_start_date,
5383: l_active_end_date, l_csi_item_instance_id;
5384: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
5385: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
5386: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_header_id);

Line 5384: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN

5380: IF (p_unit_config_header_id IS NOT NULL) THEN
5381: OPEN ahl_unit_config_headers_csr (p_unit_config_header_id);
5382: FETCH ahl_unit_config_headers_csr INTO l_name, l_active_start_date,
5383: l_active_end_date, l_csi_item_instance_id;
5384: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
5385: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
5386: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_header_id);
5387: FND_MSG_PUB.ADD;
5388: --dbms_output.put_line('Unit not found');

Line 5389: CLOSE ahl_unit_config_headers_csr;

5385: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
5386: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_header_id);
5387: FND_MSG_PUB.ADD;
5388: --dbms_output.put_line('Unit not found');
5389: CLOSE ahl_unit_config_headers_csr;
5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5391:
5392: -- Dates obsoleted 11.5.10.
5393: -- ELSIF (trunc(l_active_start_date) > trunc(sysdate) OR