DBA Data[Home] [Help]

APPS.AHL_UC_VALIDATION_PUB dependencies on FND_GLOBAL

Line 166: LAST_UPDATED_BY = fnd_global.USER_ID,

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,
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

Line 167: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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,
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

Line 175: LAST_UPDATED_BY = fnd_global.USER_ID,

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,
176: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
177: WHERE unit_config_header_id = p_unit_header_id;
178: END IF;
179:

Line 176: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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,
176: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
177: WHERE unit_config_header_id = p_unit_header_id;
178: END IF;
179:
180: --Setting output parameters