DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT dependencies on FND_GLOBAL

Line 345: last_updated_by = FND_GLOBAL.user_id,

341: UPDATE AHL_UNIT_EFFECTIVITIES_B
342: SET qa_collection_id = p_collection_id,
343: object_version_number = object_version_number + 1,
344: last_update_date = SYSDATE,
345: last_updated_by = FND_GLOBAL.user_id,
346: last_update_login = FND_GLOBAL.login_id
347: WHERE unit_effectivity_id = l_unit_effectivity_id
348: AND object_version_number = l_object_version_number;
349:

Line 346: last_update_login = FND_GLOBAL.login_id

342: SET qa_collection_id = p_collection_id,
343: object_version_number = object_version_number + 1,
344: last_update_date = SYSDATE,
345: last_updated_by = FND_GLOBAL.user_id,
346: last_update_login = FND_GLOBAL.login_id
347: WHERE unit_effectivity_id = l_unit_effectivity_id
348: AND object_version_number = l_object_version_number;
349:
350: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 369: last_updated_by = FND_GLOBAL.user_id,

365: UPDATE AHL_WORKORDERS
366: SET collection_id = p_collection_id,
367: object_version_number = object_version_number + 1,
368: last_update_date = SYSDATE,
369: last_updated_by = FND_GLOBAL.user_id,
370: last_update_login = FND_GLOBAL.login_id
371: WHERE workorder_id = l_workorder_id
372: AND object_version_number = l_object_version_number;
373:

Line 370: last_update_login = FND_GLOBAL.login_id

366: SET collection_id = p_collection_id,
367: object_version_number = object_version_number + 1,
368: last_update_date = SYSDATE,
369: last_updated_by = FND_GLOBAL.user_id,
370: last_update_login = FND_GLOBAL.login_id
371: WHERE workorder_id = l_workorder_id
372: AND object_version_number = l_object_version_number;
373:
374: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 393: last_updated_by = FND_GLOBAL.user_id,

389: UPDATE AHL_WORKORDER_OPERATIONS
390: SET collection_id = p_collection_id,
391: object_version_number = object_version_number + 1,
392: last_update_date = SYSDATE,
393: last_updated_by = FND_GLOBAL.user_id,
394: last_update_login = FND_GLOBAL.login_id
395: WHERE workorder_operation_id = l_workorder_operation_id
396: AND object_version_number = l_object_version_number;
397:

Line 394: last_update_login = FND_GLOBAL.login_id

390: SET collection_id = p_collection_id,
391: object_version_number = object_version_number + 1,
392: last_update_date = SYSDATE,
393: last_updated_by = FND_GLOBAL.user_id,
394: last_update_login = FND_GLOBAL.login_id
395: WHERE workorder_operation_id = l_workorder_operation_id
396: AND object_version_number = l_object_version_number;
397:
398: IF ( SQL%ROWCOUNT = 0 ) THEN