DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT dependencies on FND_GLOBAL

Line 335: last_updated_by = FND_GLOBAL.user_id,

331: UPDATE AHL_UNIT_EFFECTIVITIES_B
332: SET qa_collection_id = p_collection_id,
333: object_version_number = object_version_number + 1,
334: last_update_date = SYSDATE,
335: last_updated_by = FND_GLOBAL.user_id,
336: last_update_login = FND_GLOBAL.login_id
337: WHERE unit_effectivity_id = l_unit_effectivity_id
338: AND object_version_number = l_object_version_number;
339:

Line 336: last_update_login = FND_GLOBAL.login_id

332: SET qa_collection_id = p_collection_id,
333: object_version_number = object_version_number + 1,
334: last_update_date = SYSDATE,
335: last_updated_by = FND_GLOBAL.user_id,
336: last_update_login = FND_GLOBAL.login_id
337: WHERE unit_effectivity_id = l_unit_effectivity_id
338: AND object_version_number = l_object_version_number;
339:
340: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 359: last_updated_by = FND_GLOBAL.user_id,

355: UPDATE AHL_WORKORDERS
356: SET collection_id = p_collection_id,
357: object_version_number = object_version_number + 1,
358: last_update_date = SYSDATE,
359: last_updated_by = FND_GLOBAL.user_id,
360: last_update_login = FND_GLOBAL.login_id
361: WHERE workorder_id = l_workorder_id
362: AND object_version_number = l_object_version_number;
363:

Line 360: last_update_login = FND_GLOBAL.login_id

356: SET collection_id = p_collection_id,
357: object_version_number = object_version_number + 1,
358: last_update_date = SYSDATE,
359: last_updated_by = FND_GLOBAL.user_id,
360: last_update_login = FND_GLOBAL.login_id
361: WHERE workorder_id = l_workorder_id
362: AND object_version_number = l_object_version_number;
363:
364: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 383: last_updated_by = FND_GLOBAL.user_id,

379: UPDATE AHL_WORKORDER_OPERATIONS
380: SET collection_id = p_collection_id,
381: object_version_number = object_version_number + 1,
382: last_update_date = SYSDATE,
383: last_updated_by = FND_GLOBAL.user_id,
384: last_update_login = FND_GLOBAL.login_id
385: WHERE workorder_operation_id = l_workorder_operation_id
386: AND object_version_number = l_object_version_number;
387:

Line 384: last_update_login = FND_GLOBAL.login_id

380: SET collection_id = p_collection_id,
381: object_version_number = object_version_number + 1,
382: last_update_date = SYSDATE,
383: last_updated_by = FND_GLOBAL.user_id,
384: last_update_login = FND_GLOBAL.login_id
385: WHERE workorder_operation_id = l_workorder_operation_id
386: AND object_version_number = l_object_version_number;
387:
388: IF ( SQL%ROWCOUNT = 0 ) THEN