eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.BOM_OP_NETWORK_UTIL

Source


1 PACKAGE BOM_Op_Network_UTIL 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;