[Home] [Help]
PACKAGE: APPS.BOM_OP_NETWORK_UTIL
Source
1 PACKAGE BOM_Op_Network_UTIL AUTHID CURRENT_USER AS
2 /* $Header: BOMUONWS.pls 120.2 2006/03/09 21:48:44 bbpatel noship $*/
3 /*#
4 * This API contains entity utility methods for the Bill of Materials Operation Network
5 * @rep:scope private
6 * @rep:product BOM
7 * @rep:displayname BOM Operation Network Util 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 -- BOMUONWS.pls
19 --
20 -- DESCRIPTION
21 --
22 -- Spec of package BOM_Op_Network_UTIL
23 --
24 -- NOTES
25 --
26 -- HISTORY
27 -- 07-AUG-2000 Biao Zhang Initial Creation
28 --
29 ****************************************************************************/
30 /*#
31 * This method will query the database record, seperate the values into exposed columns
32 * and unexposed columns and return with those records.
33 * @param p_from_op_seq_id Source Operation Sequence Id
34 * @param p_to_op_seq_id Target Operation Sequence Id
35 * @param x_op_network_Rec Operation Network Record of exposed colmuns
36 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Op_Network_Rec_Type }
37 * @param x_op_network_Unexp_Rec Operation Network record of unexposed columns
38 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Op_Network_Unexposed_Rec_Type }
39 * @param x_return_status Indicating success or faliure
40 * @rep:scope private
41 * @rep:lifecycle active
42 * @rep:displayname Query Row
43 */
44 PROCEDURE Query_Row
45 ( p_from_op_seq_id IN NUMBER
46 , p_to_op_seq_id IN NUMBER
47 , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
48 , x_Op_Network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_unexposed_Rec_Type
49 , x_Return_status IN OUT NOCOPY VARCHAR2
50 );
51
52 /*#
53 * Perform Writes is the only exposed method that the user will have access to
54 * perform any insert/update/deletes to corresponding database tables.
55 * @param p_op_network_Rec Operation Network Record of exposed colmuns
56 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Op_Network_Rec_Type }
57 * @param p_op_Network_Unexp_Rec Operation Network record of unexposed columns
58 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
59 * @param x_Mesg_Token_Tbl Message token table
60 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
61 * @param x_Return_status Return Status
62 * @rep:scope private
63 * @rep:lifecycle active
64 * @rep:displayname Perform Writes
65 */
66 PROCEDURE Perform_Writes
67 ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
68 , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
69 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
70 , x_return_status IN OUT NOCOPY VARCHAR2
71 );
72
73 /*#
74 * Procedure will query start and end operation of the
75 * entire routing and return those.
76 * @param p_routing_sequence_id Routing Sequence Id
77 * @param x_prev_start_id Previous Start Id
78 * @param x_prev_end_id Previous End Id
79 * @param x_Mesg_Token_Tbl Message token table
80 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
81 * @param x_Return_status Return Status
82 * @rep:scope private
83 * @rep:lifecycle active
84 * @rep:displayname Get WSM Network Atttributes
85 */
86 PROCEDURE Get_WSM_Netowrk_Attribs
87 ( p_routing_sequence_id IN NUMBER
88 , x_prev_start_id IN OUT NOCOPY NUMBER
89 , x_prev_end_id IN OUT NOCOPY NUMBER
90 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
91 , x_Return_status IN OUT NOCOPY VARCHAR2
92 );
93 /*#
94 * Procedure checks and then sets the sub inventory and
95 * locator for the OSFM routing.
96 * @param p_routing_sequence_id Routing Sequence Id
97 * @param p_end_id End Id
98 * @param x_Mesg_Token_Tbl Message token table
99 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
100 * @param x_Return_status Return Status
101 * @rep:scope private
102 * @rep:lifecycle active
103 * @rep:displayname Set WSM Network Substitute Locator
104 */
105
106 PROCEDURE Set_WSM_Network_Sub_Loc
107 ( p_routing_sequence_id IN NUMBER
108 , p_end_id IN NUMBER
109 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
110 , x_Return_status IN OUT NOCOPY VARCHAR2
111 );
112
113 /*#
114 * Procedure to copy the disabled first or last operation of the network.
115 * @param p_routing_sequence_id Routing Sequence Id
116 * @param x_Mesg_Token_Tbl Message Token Table
117 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
118 * @param x_Return_status Return Status
119 * @rep:scope private
120 * @rep:lifecycle active
121 * @rep:displayname Copy First Last Disabled Operation
122 */
123 PROCEDURE Copy_First_Last_Dis_Op
124 ( p_routing_sequence_id IN NUMBER
125 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
126 , x_return_status IN OUT NOCOPY VARCHAR2
127 );
128
129 /*#
130 * Procedure to copy the operation with new effectivity date as (disable date + 1 sec)
131 * Also copy resources and alternate resources.
132 *
133 * @param p_operation_sequence_id Operation Sequence Id
134 * @rep:scope private
135 * @rep:lifecycle active
136 * @rep:displayname Copy Operation
137 */
138 PROCEDURE Copy_Operation ( p_operation_sequence_id IN NUMBER );
139
140 END BOM_Op_Network_UTIL;