DBA Data[Home] [Help]

APPS.AHL_UC_VALIDATION_PUB dependencies on FND_GLOBAL

Line 182: LAST_UPDATED_BY = fnd_global.USER_ID,

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

Line 183: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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

Line 191: LAST_UPDATED_BY = fnd_global.USER_ID,

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,
192: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
193: WHERE unit_config_header_id = p_unit_header_id;
194: END IF;
195:

Line 192: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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,
192: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
193: WHERE unit_config_header_id = p_unit_header_id;
194: END IF;
195:
196: --Setting output parameters