DBA Data[Home] [Help]

APPS.WIP_WIP_ENTITIES_UTIL dependencies on WIP_GLOBALS

Line 395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,

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,

Line 397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,

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,

Line 399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,

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,

Line 401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,

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,

Line 403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,

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,

Line 405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,

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,

Line 407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,

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,

Line 409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_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,

Line 411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_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,

Line 413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_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,

Line 415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_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,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,

Line 417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,

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,

Line 419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_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,

Line 421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_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,
424: l_Wip_Entities_rec.wip_entity_name)
425: THEN

Line 423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,

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.