[Home] [Help]
PACKAGE: APPS.BOM_OP_RES_UTIL
Source
1 PACKAGE BOM_Op_Res_UTIL AS
2 /* $Header: BOMURESS.pls 120.4 2006/02/28 03:50:39 grastogi noship $ */
3 /*#
4 * This API contains entity utility methods for the Bill of Materials Operation Resources
5 * @rep:scope private
6 * @rep:product BOM
7 * @rep:displayname BOM Sub Component Util Package
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
10 */
11 /****************************************************************************
12 --
13 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
14 -- All rights reserved.
15 --
16 -- FILENAME
17 --
18 -- BOMURESS.pls
19 --
20 -- DESCRIPTION
21 --
22 -- Spec of package BOM_Op_Res_UTIL
23 --
24 -- NOTES
25 --
26 -- HISTORY
27 -- 18-AUG-2000 Masanori Kimizuka Initial Creation
28 --
29 ****************************************************************************/
30
31
32 /****************************************************************************
33 * QUERY ROW
34 *****************************************************************************/
35 /*#
36 * This method will query the database record, seperate the values into exposed columns
37 * and unexposed columns and return with those records.
38 * @param p_resource_sequence_number Resource Sequence Number
39 * @param p_operation_sequence_id Operation Resource sequence id
40 * @param p_acd_type acd type
41 * @param p_Mesg_Token_Tbl Filled with any errors or warnings
42 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
43 * @param x_op_resource_Rec Operation Resource Record of exposed colmuns
44 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
45 * @param x_op_res_Unexp_Rec Operation Resource record of unexposed columns
46 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
47 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
48 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
49 * @param x_return_status Indicating success or faliure
50 * @rep:scope private
51 * @rep:lifecycle active
52 * @rep:displayname Query Row for Routing BO
53 */
54
55 /** RTG BO Query Row **/
56 PROCEDURE Query_Row
57 ( p_resource_sequence_number IN NUMBER
58 , p_operation_sequence_id IN NUMBER
59 , p_acd_type IN NUMBER
60 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
61 , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
62 , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
63 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
64 , x_return_status IN OUT NOCOPY VARCHAR2
65 ) ;
66
67 /** ECO BO Query Row **/
68 /*#
69 * This method will query the database record, seperate the values into exposed columns
70 * and unexposed columns and return with those records.
71 * @param p_resource_sequence_number Resource Sequence Number
72 * @param p_operation_sequence_id Operation Resource sequence id
73 * @param p_acd_type acd type
74 * @param p_Mesg_Token_Tbl Filled with any errors or warnings
75 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
76 * @param x_rev_op_resource_Rec Operation Resource Record of exposed colmuns
77 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
78 * @param x_rev_op_res_Unexp_Rec Operation Resource record of unexposed columns
79 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
80 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
81 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
82 * @param x_return_status Indicating success or faliure
83 * @rep:scope private
84 * @rep:lifecycle active
85 * @rep:displayname Query Row for ECO BO
86 */
87
88 PROCEDURE Query_Row
89 ( p_resource_sequence_number IN NUMBER
90 , p_operation_sequence_id IN NUMBER
91 , p_acd_type IN NUMBER
92 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
93 , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
94 , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
95 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
96 , x_return_status IN OUT NOCOPY VARCHAR2
97 ) ;
98
99
100 /****************************************************************************
101 * PERFORM WRITE
102 *****************************************************************************/
103 /*#
104 * Perform Writes is the only exposed method that the user will have access to perform any
105 * insert/update/deletes to corresponding database tables
106 * @param p_op_resource_rec Bom Operation Resource Record of exposed colmuns
107 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
108 * @param p_op_res_Unexp_Rec Bom Operation Resource record of unexposed columns
109 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
110 * @param x_Mesg_Token_Tbl Message token table
111 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
112 * @param x_Return_status Return Status
113 * @rep:scope private
114 * @rep:lifecycle active
115 * @rep:displayname Perform Writes for Routing BO
116 */
117 /** Routing BO Perform Writes **/
118 PROCEDURE Perform_Writes
119 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
120 , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
121 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
122 , x_return_status IN OUT NOCOPY VARCHAR2
123 ) ;
124
125 /** ECO BO Perform Writes **/
126 /*#
127 * Perform Writes is the only exposed method that the user will have access to perform any
128 * insert/update/deletes to corresponding database tables
129 * @param p_rev_op_resource_rec Bom Operation Resource Record of exposed colmuns
130 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
131 * @param p_rev_op_res_Unexp_Rec Bom Operation Resource record of unexposed columns
132 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
133 * @param p_control_rec Control Record
134 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Control_Rec_Type }
135 * @param x_Mesg_Token_Tbl Message token table
136 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
137 * @param x_Return_status Return Status
138 * @rep:scope private
139 * @rep:lifecycle active
140 * @rep:displayname Perform Writes for ECO BO
141 */
142
143 PROCEDURE Perform_Writes
144 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
145 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
146 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
147 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
148 , x_return_status IN OUT NOCOPY VARCHAR2
149 ) ;
150
151
152 /****************************************************************************
153 * OTHERS
154 *****************************************************************************/
155
156 /** Insert Operation **/
157 PROCEDURE Insert_Row
158 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
159 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
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 /** Update Operation **/
165 PROCEDURE Update_Row
166 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
167 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
168 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
169 , x_return_status IN OUT NOCOPY VARCHAR2
170 ) ;
171
172
173 /** Delete Operations **/
174 PROCEDURE Delete_Row
175 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
176 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
177 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
178 , x_return_status IN OUT NOCOPY VARCHAR2
179 ) ;
180
181 END BOM_Op_Res_UTIL;