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 }
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
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
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 **/
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 }
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
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
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:
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:
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 **/
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;