PACKAGE: APPS.EAM_WO_NETWORK_VALIDATE_PVT

Source

1 PACKAGE EAM_WO_NETWORK_VALIDATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVWNVS.pls 120.0 2005/05/25 15:55:04 appldev noship $ */
3 /***************************************************************************
4 --
5 --  Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 --  All rights reserved.
7 --
8 --  FILENAME
9 --
10 --      EAMVWNVS.pls
11 --
12 --  DESCRIPTION
13 --
14 --      Spec of package EAM_WO_NETWORK_VALIDATE_PVT
15 --
16 --  NOTES
17 --
18 --  HISTORY
19 --
20 --  11-SEP-2003    Basanth Roy     Initial Creation
21 ***************************************************************************/
22 
23 
24 
25     PROCEDURE Validate_Structure
26         (
27         p_api_version                   IN      NUMBER,
28         p_init_msg_list                 IN      VARCHAR2 := FND_API.G_TRUE,
29         p_commit                        IN      VARCHAR2 := FND_API.G_FALSE,
30         p_validation_level              IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
31 
32         p_work_object_id                IN      NUMBER,
33         p_work_object_type_id           IN      NUMBER,
34         p_exception_logging             IN      VARCHAR2 := 'N',
35 
36 	p_validate_status		IN      VARCHAR2 := 'N',
37 	p_output_errors			IN      VARCHAR2 := 'N',
38 
39         x_return_status                 OUT NOCOPY  VARCHAR2,
40         x_msg_count                     OUT NOCOPY  NUMBER,
41         x_msg_data                      OUT NOCOPY  VARCHAR2,
42         x_wo_relationship_exc_tbl	OUT NOCOPY  EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type
43         );
44 
45 
46     PROCEDURE Check_Constrained_Children
47         (
48         p_api_version                   IN      NUMBER,
49         p_init_msg_list                 IN      VARCHAR2 := FND_API.G_FALSE,
50         p_commit                        IN      VARCHAR2 := FND_API.G_FALSE,
51         p_validation_level              IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
52 
53         p_parent_object_id                IN      NUMBER,
54         p_parent_object_type_id           IN      NUMBER,
55 
56 
57         x_return_status                 OUT NOCOPY  VARCHAR2,
58         x_msg_count                     OUT NOCOPY  NUMBER,
59         x_msg_data                      OUT NOCOPY  VARCHAR2
60         );
61 
62    --fix for 3433757.added procedure validate_status to validate the statuses of parent and child
63    PROCEDURE Validate_Status
64        (
65           p_work_object_id                IN      NUMBER,
66           p_work_object_type_id           IN      NUMBER,
67           x_return_status                 OUT NOCOPY  VARCHAR2
68        );
69 
70   -- Added for Detailed Scheduling
71   PROCEDURE Validate_Network_Status
72        (
73           p_work_object_id                IN      NUMBER,
74           p_work_object_type_id           IN      NUMBER,
75 	  p_wo_relationship_exc_tbl       IN OUT  NOCOPY EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type
76        );
77 
78 
79 END EAM_WO_NETWORK_VALIDATE_PVT;