APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on WIP_SCHEDULING_EXCEPTIONS

Line 369: -- Purge the WIP_SCHEDULING_EXCEPTIONS table of error messages

365: --Bug3868292: Replaced top_level_object_id with l_top_level_object_id.
366:
367: IF (UPPER(p_exception_logging) <> 'N' ) THEN
368:
369: -- Purge the WIP_SCHEDULING_EXCEPTIONS table of error messages
370: -- from previous runs of Validate_Structure
371: delete from wip_scheduling_exceptions
372: where exception_type = 2
373: and sched_relationship_id in

Line 371: delete from wip_scheduling_exceptions

367: IF (UPPER(p_exception_logging) <> 'N' ) THEN
368:
369: -- Purge the WIP_SCHEDULING_EXCEPTIONS table of error messages
370: -- from previous runs of Validate_Structure
371: delete from wip_scheduling_exceptions
372: where exception_type = 2
373: and sched_relationship_id in
374: (select /*+ index (WIP_SCHED_RELATIONSHIPS WIP_SCHED_RELATIONSHIPS_N1)*/ sched_relationship_id from
375: wip_sched_relationships

Line 400: INSERT INTO WIP_SCHEDULING_EXCEPTIONS

396: if type_1.parent_job is not null then
397:
398: BEGIN
399:
400: INSERT INTO WIP_SCHEDULING_EXCEPTIONS
401: (
402: wip_entity_id,
403: organization_id,
404: mesg_sequence,

Line 481: INSERT INTO WIP_SCHEDULING_EXCEPTIONS

477: l_exception_msg := FND_MESSAGE.GET;
478:
479:
480: BEGIN
481: INSERT INTO WIP_SCHEDULING_EXCEPTIONS
482: (
483: wip_entity_id,
484: organization_id,
485: mesg_sequence,