[Home] [Help]
PACKAGE: APPS.BOM_SUB_OP_RES_UTIL
Source
1 PACKAGE BOM_Sub_Op_Res_UTIL AS
2 /* $Header: BOMUSORS.pls 120.5 2006/02/21 05:17:22 grastogi noship $ */
3 /*#
4 * This API contains entity utility methods for the Bill of Materials Sub Operation Resource
5 * @rep:scope private
6 * @rep:product BOM
7 * @rep:displayname BOM Sub Operation Resource 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 -- BOMUSORS.pls
19 --
20 -- DESCRIPTION
21 --
22 -- Spec of package BOM_Sub_Op_Res_UTIL
23 --
24 -- NOTES
25 --
26 -- HISTORY
27 -- 22-AUG-2000 Masanori Kimizuka Initial Creation
28 --
29 ****************************************************************************/
30
31 /****************************************************************************
32 * QUERY ROW
33 *****************************************************************************/
34
35 /** RTG BO Query Row **/
36 /*#
37 * This method as used by routing BO will query the database record, seperate the values into exposed columns
38 * and unexposed columns and return with those records.
39 * @param p_resource_id The IN parameters form the Resource Id
40 * @param p_substitute_group_number Substitute Group Number
41 * @param p_operation_sequence_id Operation Sequence Id
42 * @param p_acd_type acd type
43 * @param p_replacement_group_number Replacement Group Number
44 * @param p_basis_type Basis Type
45 * @param p_mesg_token_tbl Message Token Table
46 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
47 * @param x_Sub_Resource_Rec Substitute Resource Record of exposed colmuns
48 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Resource_Rec_Type }
49 * @param x_Sub_Res_Unexp_Rec Substitute Resource record of unexposed columns
50 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Res_Unexposed_Rec_Type }
51 * @param x_mesg_token_tbl Message Token Table
52 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
53 * @param x_return_status Indicating success or faliure
54 * @rep:scope private
55 * @rep:lifecycle active
56 * @rep:displayname Query Row
57 */
58 PROCEDURE Query_Row
59 ( p_resource_id IN NUMBER
60 , p_substitute_group_number IN NUMBER
61 , p_operation_sequence_id IN NUMBER
62 , p_acd_type IN NUMBER
63 , p_replacement_group_number IN NUMBER --bug 2489765
64 , p_basis_type IN NUMBER --bug 4689856
65 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
66 , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
67 , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
68 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69 , x_return_status IN OUT NOCOPY VARCHAR2
70 ) ;
71
72 /** ECO BO Query Row **/
73 /*#
74 * This method as used by ECO BO will query the database record, seperate the values into exposed columns
75 * and unexposed columns and return with those records.
76 * @param p_resource_id The IN parameters form the Resource Id
77 * @param p_substitute_group_number Substitute Group Number
78 * @param p_operation_sequence_id Operation Sequence Id
79 * @param p_acd_type acd type
80 * @param p_replacement_group_number Replacement Group Number
81 * @param p_basis_type Basis Type
82 * @param p_mesg_token_tbl Message Token Table
83 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
84 * @param x_rev_Sub_Resource_Rec Substitute Resource Record of exposed colmuns
85 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Sub_Resource_Rec_Type }
86 * @param x_rev_Sub_Res_Unexp_Rec Substitute Resource record of unexposed columns
87 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Sub_Res_Unexposed_Rec_Type }
88 * @param x_mesg_token_tbl Message Token Tablel
89 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
90 * @param x_return_status Indicating success or faliure
91 * @rep:scope private
92 * @rep:lifecycle active
93 * @rep:displayname Query Row
94 */
95
96 PROCEDURE Query_Row
97 ( p_resource_id IN NUMBER
98 , p_substitute_group_number IN NUMBER
99 , p_operation_sequence_id IN NUMBER
100 , p_acd_type IN NUMBER
101 , p_replacement_group_number IN NUMBER --bug 2489765
102 , p_basis_type IN NUMBER --bug 4689856
103 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
104 , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
105 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
106 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
107 , x_return_status IN OUT NOCOPY VARCHAR2
108 ) ;
109
110
111 /****************************************************************************
112 * PERFORM WRITE
113 *****************************************************************************/
114
115 /** Routing BO Perform Writes **/
116 PROCEDURE Perform_Writes
117 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
118 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
119 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
120 , x_return_status IN OUT NOCOPY VARCHAR2
121 ) ;
122
123 /** ECO BO Perform Writes **/
124 PROCEDURE Perform_Writes
125 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
126 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
127 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
128 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
129 , x_return_status IN OUT NOCOPY VARCHAR2
130 ) ;
131
132
133 /****************************************************************************
134 * OTHERS
135 *****************************************************************************/
136
137 /** Insert Operation **/
138 PROCEDURE Insert_Row
139 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
140 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
141 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
142 , x_return_status IN OUT NOCOPY VARCHAR2
143 ) ;
144
145 /** Update Operation **/
146 PROCEDURE Update_Row
147 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
148 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
149 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
150 , x_return_status IN OUT NOCOPY VARCHAR2
151 ) ;
152
153
154 /** Delete Operations **/
155 PROCEDURE Delete_Row
156 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
157 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
158 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
159 , x_return_status IN OUT NOCOPY VARCHAR2
160 ) ;
161
162 END BOM_Sub_Op_Res_UTIL;