21: x_return_status OUT NOCOPY VARCHAR2)
22: IS
23: CURSOR get_uc_header_id IS
24: SELECT unit_config_header_id
25: FROM ahl_unit_config_headers
26: WHERE name = p_uc_name;
27: CURSOR check_uc_header_id IS
28: SELECT unit_config_header_id
29: FROM ahl_unit_config_headers
25: FROM ahl_unit_config_headers
26: WHERE name = p_uc_name;
27: CURSOR check_uc_header_id IS
28: SELECT unit_config_header_id
29: FROM ahl_unit_config_headers
30: WHERE unit_config_header_id = p_uc_header_id;
31:
32: BEGIN
33: x_return_status := FND_API.G_RET_STS_SUCCESS;