APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on WIP_SCHEDULING_EXCEPTIONS

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

352: --Bug3868292: Replaced top_level_object_id with l_top_level_object_id.
353:
354: IF (UPPER(p_exception_logging) <> 'N' ) THEN
355:
356: -- Purge the WIP_SCHEDULING_EXCEPTIONS table of error messages
357: -- from previous runs of Validate_Structure
358: delete from wip_scheduling_exceptions
359: where exception_type = 2
360: and sched_relationship_id in

Line 358: delete from wip_scheduling_exceptions

354: IF (UPPER(p_exception_logging) <> 'N' ) THEN
355:
356: -- Purge the WIP_SCHEDULING_EXCEPTIONS table of error messages
357: -- from previous runs of Validate_Structure
358: delete from wip_scheduling_exceptions
359: where exception_type = 2
360: and sched_relationship_id in
361: (select sched_relationship_id from
362: wip_sched_relationships

Line 387: INSERT INTO WIP_SCHEDULING_EXCEPTIONS

383: if type_1.parent_job is not null then
384:
385: BEGIN
386:
387: INSERT INTO WIP_SCHEDULING_EXCEPTIONS
388: (
389: wip_entity_id,
390: organization_id,
391: mesg_sequence,

Line 468: INSERT INTO WIP_SCHEDULING_EXCEPTIONS

464: l_exception_msg := FND_MESSAGE.GET;
465:
466:
467: BEGIN
468: INSERT INTO WIP_SCHEDULING_EXCEPTIONS
469: (
470: wip_entity_id,
471: organization_id,
472: mesg_sequence,