1 PACKAGE BOM_Validate_Op_Network AS
2 /* $Header: BOMLONWS.pls 120.2 2006/02/21 04:32:38 grastogi noship $*/
3 /*#
4 * This API contains the methods to validate Operation Network.
5 * @rep:scope private
6 * @rep:product BOM
7 * @rep:displayname Validate BOM Operation Network Package
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
10 */
11 /****************************************************************************
12 --
13 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
14 -- All rights reserved.
15 --
16 -- FILENAME
17 --
18 -- BOMLONWS.pls
19 --
20 -- DESCRIPTION
21 --
22 -- Spec of package BOM_Validate_Op_Network
23 --
24 -- NOTES
25 --
26 -- HISTORY
27 -- 07-AUG-2000 Biao Zhang Initial Creation
28 --
29 ****************************************************************************/
30 /*#
31 * Check_Existence will perform a query using the primary key information and will return
32 * success if the operation is CREATE and the record EXISTS or will return an error if the operation
33 * is UPDATE and the record DOES NOT EXIST.In case of UPDATE if the record exists then the procedure
34 * will return the old record in the old entity parameters with a success status.
35 * @param p_op_network_rec Operation Network Record as given by the User
36 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
37 * @param p_op_network_Unexp_Rec Operation Network Unexposed Record
38 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
39 * @param x_old_op_network_rec Old Operation Network exposed column record
40 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
41 * @param x_old_op_network_unexp_rec Old Operation Network unexposed column record
42 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
43 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
44 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
45 * @param x_return_status Indicating success or faliure
46 * @rep:scope private
47 * @rep:lifecycle active
48 * @rep:displayname Check Existence
49 */
50 PROCEDURE Check_Existence
51 ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
52 , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
53 , x_old_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
54 , x_old_Op_Network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
55 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
56 , x_return_status IN OUT NOCOPY VARCHAR2
57 );
58 /*#
59 * Check Attributes convert the BOM Record and will validate individual
60 * attributes .Any errors will be populated in the x_Mesg_Token_Tbl and returned with a x_return_status
61 * @param x_return_status Indicating success or faliure
62 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
63 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
64 * @param p_op_Network_rec Bom Operation Network Record as given by the User
65 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
66 * @param p_op_network_unexp_rec Bom Operation Network Record as given by the User
67 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
68 * @param p_old_op_network_rec Bom Old Operation Network Record as given by the User
69 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
70 * @param p_old_op_network_unexp_rec Bom Old Operation Network Record as given by the User
71 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
72 * @rep:scope private
73 * @rep:lifecycle active
74 * @rep:displayname Check Attributes
75 */
76 PROCEDURE Check_Attributes
77 ( x_return_status IN OUT NOCOPY VARCHAR2
78 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
79 , p_Op_Network_Rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
80 , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
81 , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
82 , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
83 );
84 /*#
85 * This procedure will check if the user has access to
86 * the operations for Op Network.
87 * @param x_return_status Indicating success or faliure
88 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
89 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
90 * @param p_op_Network_rec Bom Operation Network Record as given by the User
91 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
92 * @param p_op_network_unexp_rec Bom Operation Network Record as given by the User
93 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
94 * @rep:scope private
95 * @rep:lifecycle active
96 * @rep:displayname Check Access
97 */
98 PROCEDURE Check_Access
99 ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
100 , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
101 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
102 , x_return_status IN OUT NOCOPY VARCHAR2
103 ) ;
104 /*#
105 * Check Entity will perform the business logic validation for the operation
106 * network Entity.It will perform any cross entity validations and make sure
107 * that the user is not entering values which may disturb the integrity of the data.
108 * @param x_return_status Indicating success or faliure
109 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
110 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
111 * @param p_op_network_rec Operation Network Record
112 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
113 * @param p_op_network_unexp_rec Operation Network Unexposed Record
114 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
115 * @param p_old_op_network_rec Old Operation Network Record
116 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
117 * @param p_old_op_network_unexp_rec Operation Resource Unexposed Record
118 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
119 * @rep:scope private
120 * @rep:lifecycle active
121 * @rep:displayname Check Entity1
122 */
123
124 PROCEDURE Check_Entity1
125 ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
126 , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
127 , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
128 , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
129 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
130 , x_return_status IN OUT NOCOPY VARCHAR2
131 );
132
133 PROCEDURE Check_Entity2
134 ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
135 , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
136 , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
137 , p_old_Op_Network_unexp_rec IN
138 Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
139 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
140 , x_return_status IN OUT NOCOPY VARCHAR2
141 );
142
143 /*#
144 * Procedure will varify that the routing start and
145 * end are unchanged.
146 * @param p_routing_sequence_id Routing Sequence Id
147 * @param p_prev_start_id Previous Start Id
148 * @param p_prev_end_id Previous End Id
149 * @param x_Mesg_Token_Tbl Message token table
150 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
151 * @param x_Return_status Return Status
152 * @rep:scope private
153 * @rep:lifecycle active
154 * @rep:displayname Check WSM Network Atttributes
155 */
156 PROCEDURE Check_WSM_Netowrk_Attribs
157 ( p_routing_sequence_id IN NUMBER
158 , p_prev_start_id IN NUMBER
159 , p_prev_end_id IN NUMBER
160 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
161 , x_Return_status IN OUT NOCOPY VARCHAR2
162 );
163
164 END BOM_Validate_Op_Network;
[Home] [Help]