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