APPS.AHL_UC_WF_APPR_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 14: FROM ahl_unit_config_headers

10:
11: CURSOR get_uc_header_det(c_uc_header_id in number)
12: IS
13: SELECT unit_config_header_id, name, object_version_number, unit_config_status_code, active_uc_status_code
14: FROM ahl_unit_config_headers
15: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
16: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
17: AND unit_config_header_id = c_uc_header_id;
18:

Line 1300: FROM ahl_unit_config_headers

1296:
1297: CURSOR check_uc_ovn(c_uc_header_id in number, c_object_version_number in number)
1298: IS
1299: SELECT unit_config_header_id, name, unit_config_status_code, active_uc_status_code
1300: FROM ahl_unit_config_headers
1301: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1302: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1303: AND unit_config_header_id = c_uc_header_id
1304: AND object_version_number = c_object_version_number;

Line 1542: FROM ahl_unit_config_headers

1538:
1539: CURSOR check_uc_ovn(c_uc_header_id in number, c_object_version_number in number)
1540: IS
1541: SELECT unit_config_header_id, name, unit_config_status_code, active_uc_status_code
1542: FROM ahl_unit_config_headers
1543: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1544: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1545: AND unit_config_header_id = c_uc_header_id
1546: AND object_version_number = c_object_version_number;

Line 1620: UPDATE ahl_unit_config_headers

1616:
1617:
1618: IF (l_check_uc_ovn.unit_config_status_code = 'APPROVAL_PENDING') THEN
1619:
1620: UPDATE ahl_unit_config_headers
1621: SET unit_config_status_code = l_next_status,
1622: object_version_number = l_object_version_number + 1,
1623: last_update_date = sysdate,
1624: last_updated_by = to_number(fnd_global.login_id),

Line 1630: UPDATE ahl_unit_config_headers

1626: WHERE unit_config_header_id = l_object_id;
1627:
1628: ELSIF (l_check_uc_ovn.active_uc_status_code = 'APPROVAL_PENDING') THEN
1629:
1630: UPDATE ahl_unit_config_headers
1631: SET active_uc_status_code = l_next_status,
1632: object_version_number = l_object_version_number + 1,
1633: last_update_date = sysdate,
1634: last_updated_by = to_number(fnd_global.login_id),