APPS.AHL_UC_VALIDATION_PUB dependencies on AHL_UNIT_CONFIG_HEADERS

Line 39: FROM ahl_unit_config_headers

35: IS
36: --
37: CURSOR validate_uc_header_id_csr (c_unit_header_id IN NUMBER) IS
38: SELECT unit_config_status_code
39: FROM ahl_unit_config_headers
40: WHERE unit_config_header_id = c_unit_header_id
41: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
42: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
43: FOR UPDATE OF unit_config_status_code NOWAIT;

Line 48: l_uc_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;

44: --
45: l_api_version CONSTANT NUMBER := 1.0;
46: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Completeness';
47:
48: l_uc_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
49: l_error_table Error_Tbl_Type;
50: l_evaluation_status VARCHAR2(1);
51: --
52: BEGIN

Line 178: UPDATE AHL_UNIT_CONFIG_HEADERS

174: CLOSE validate_uc_header_id_csr;
175:
176: IF (l_uc_status_code = 'INCOMPLETE' AND
177: l_error_table.COUNT = 0) THEN
178: UPDATE AHL_UNIT_CONFIG_HEADERS
179: SET UNIT_CONFIG_STATUS_CODE = 'COMPLETE',
180: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
181: LAST_UPDATE_DATE = sysdate,
182: LAST_UPDATED_BY = fnd_global.USER_ID,

Line 187: UPDATE AHL_UNIT_CONFIG_HEADERS

183: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
184: WHERE unit_config_header_id = p_unit_header_id;
185: ELSIF (l_error_table.COUNT >0 AND
186: l_uc_status_code = 'COMPLETE') THEN
187: UPDATE AHL_UNIT_CONFIG_HEADERS
188: SET UNIT_CONFIG_STATUS_CODE = 'INCOMPLETE',
189: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
190: LAST_UPDATE_DATE = sysdate,
191: LAST_UPDATED_BY = fnd_global.USER_ID,