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 }
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
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: ) ;
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:
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 }
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
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: ) ;
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:
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 }
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
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: ) ;
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:
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 }
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 }
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
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
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: ) ;
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:
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: ) ;
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:
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: ) ;
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:
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: ) ;
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: