APPS.AHL_UC_VALIDATION_PUB dependencies on AHL_UNIT_CONFIG_HEADERS

Line 37: FROM ahl_unit_config_headers

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

Line 46: l_uc_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;

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

Line 162: UPDATE AHL_UNIT_CONFIG_HEADERS

158: CLOSE validate_uc_header_id_csr;
159:
160: IF (l_uc_status_code = 'INCOMPLETE' AND
161: l_error_table.COUNT = 0) THEN
162: UPDATE AHL_UNIT_CONFIG_HEADERS
163: SET UNIT_CONFIG_STATUS_CODE = 'COMPLETE',
164: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
165: LAST_UPDATE_DATE = sysdate,
166: LAST_UPDATED_BY = fnd_global.USER_ID,

Line 171: UPDATE AHL_UNIT_CONFIG_HEADERS

167: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
168: WHERE unit_config_header_id = p_unit_header_id;
169: ELSIF (l_error_table.COUNT >0 AND
170: l_uc_status_code = 'COMPLETE') THEN
171: UPDATE AHL_UNIT_CONFIG_HEADERS
172: SET UNIT_CONFIG_STATUS_CODE = 'INCOMPLETE',
173: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
174: LAST_UPDATE_DATE = sysdate,
175: LAST_UPDATED_BY = fnd_global.USER_ID,