[Home] [Help]
PACKAGE: APPS.BOM_SUB_OP_RES_UTIL
Source
1 PACKAGE BOM_Sub_Op_Res_UTIL AUTHID CURRENT_USER AS
2 /* $Header: BOMUSORS.pls 120.6 2011/12/06 10:46:02 rambkond ship $ */
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_schedule_flag IN NUMBER /* Added for bug 13005178 */
66 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
67 , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
68 , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_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 /** ECO BO Query Row **/
74 /*#
75 * This method as used by ECO BO will query the database record, seperate the values into exposed columns
76 * and unexposed columns and return with those records.
77 * @param p_resource_id The IN parameters form the Resource Id
78 * @param p_substitute_group_number Substitute Group Number
79 * @param p_operation_sequence_id Operation Sequence Id
80 * @param p_acd_type acd type
81 * @param p_replacement_group_number Replacement Group Number
82 * @param p_basis_type Basis Type
83 * @param p_mesg_token_tbl Message Token Table
84 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
85 * @param x_rev_Sub_Resource_Rec Substitute Resource Record of exposed colmuns
86 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Sub_Resource_Rec_Type }
87 * @param x_rev_Sub_Res_Unexp_Rec Substitute Resource record of unexposed columns
88 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Sub_Res_Unexposed_Rec_Type }
89 * @param x_mesg_token_tbl Message Token Tablel
90 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
91 * @param x_return_status Indicating success or faliure
92 * @rep:scope private
93 * @rep:lifecycle active
94 * @rep:displayname Query Row
95 */
96
97 PROCEDURE Query_Row
98 ( p_resource_id IN NUMBER
99 , p_substitute_group_number IN NUMBER
100 , p_operation_sequence_id IN NUMBER
101 , p_acd_type IN NUMBER
102 , p_replacement_group_number IN NUMBER --bug 2489765
103 , p_basis_type IN NUMBER --bug 4689856
104 , p_schedule_flag IN NUMBER /* Added for bug 13005178 */
105 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
106 , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
107 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
108 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
109 , x_return_status IN OUT NOCOPY VARCHAR2
110 ) ;
111
112
113 /****************************************************************************
114 * PERFORM WRITE
115 *****************************************************************************/
116
117 /** Routing BO Perform Writes **/
118 PROCEDURE Perform_Writes
119 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
120 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_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 PROCEDURE Perform_Writes
127 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
128 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
129 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
130 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
131 , x_return_status IN OUT NOCOPY VARCHAR2
132 ) ;
133
134
135 /****************************************************************************
136 * OTHERS
137 *****************************************************************************/
138
139 /** Insert Operation **/
140 PROCEDURE Insert_Row
141 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
142 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
143 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
144 , x_return_status IN OUT NOCOPY VARCHAR2
145 ) ;
146
147 /** Update Operation **/
148 PROCEDURE Update_Row
149 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
150 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
151 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
152 , x_return_status IN OUT NOCOPY VARCHAR2
153 ) ;
154
155
156 /** Delete Operations **/
157 PROCEDURE Delete_Row
158 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
159 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_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 END BOM_Sub_Op_Res_UTIL;