391: FOR UPDATE NOWAIT;
392:
393: -- Row locked. Compare IN attributes to DB attributes.
394:
395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,
396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
393: -- Row locked. Compare IN attributes to DB attributes.
394:
395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,
396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,
396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
424: l_Wip_Entities_rec.wip_entity_name)
425: THEN
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
424: l_Wip_Entities_rec.wip_entity_name)
425: THEN
426:
427: -- Row has not changed. Set out parameter.