DBA Data[Home] [Help]

APPS.BOM_SUB_COMPONENT_UTIL dependencies on BOM_BO_PUB

Line 72: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }

68: /*#
69: * This method will convert the missing values of some attributes that the user wishes to NULL
70: * This can be used with ECO
71: * @param p_sub_component_rec the record that need to be converted
72: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
73: * @return the converted record
74: * @rep:scope private
75: * @rep:lifecycle active
76: * @rep:displayname Convert Miss To Null

Line 81: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

77: */
78:
79:
80: FUNCTION Convert_Miss_To_Null
81: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
82: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type;
83:
84: -- Function Query_Row
85:

Line 82: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type;

78:
79:
80: FUNCTION Convert_Miss_To_Null
81: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
82: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type;
83:
84: -- Function Query_Row
85:
86: /*#

Line 93: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }

89: * @param p_substitute_component_id The IN parameters form the Substitute Component primary key
90: * @param p_component_sequence_id componenet sequence id
91: * @param p_acd_type acd type
92: * @param x_Sub_Component_Rec Substitute Component Record of exposed colmuns
93: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
94: * @param x_Sub_Comp_Unexp_Rec Substitute Component record of unexposed columns
95: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
96: * @param x_return_status Indicating success or faliure
97: * @rep:scope private

Line 95: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }

91: * @param p_acd_type acd type
92: * @param x_Sub_Component_Rec Substitute Component Record of exposed colmuns
93: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
94: * @param x_Sub_Comp_Unexp_Rec Substitute Component record of unexposed columns
95: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
96: * @param x_return_status Indicating success or faliure
97: * @rep:scope private
98: * @rep:lifecycle active
99: * @rep:displayname Query Row

Line 106: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

102: PROCEDURE Query_Row
103: ( p_substitute_component_id IN NUMBER
104: , p_component_sequence_id IN NUMBER
105: , p_acd_type IN NUMBER
106: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
107: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
108: , x_return_status IN OUT NOCOPY VARCHAR2
109: );
110:

Line 107: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

103: ( p_substitute_component_id IN NUMBER
104: , p_component_sequence_id IN NUMBER
105: , p_acd_type IN NUMBER
106: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
107: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
108: , x_return_status IN OUT NOCOPY VARCHAR2
109: );
110:
111: -- Procedure lock_Row

Line 118: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }

114: /*#
115: * Locks the row
116: * @param x_return_status Indicating success or faliure
117: * @param p_sub_component_rec Substitute Component Record
118: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
119: * @param x_sub_component_rec Substitute Component Record
120: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
121: * @param x_err_text error text
122: * @rep:scope private

Line 120: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }

116: * @param x_return_status Indicating success or faliure
117: * @param p_sub_component_rec Substitute Component Record
118: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
119: * @param x_sub_component_rec Substitute Component Record
120: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
121: * @param x_err_text error text
122: * @rep:scope private
123: * @rep:lifecycle active
124: * @rep:displayname Lock Row

Line 131: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

127:
128:
129: PROCEDURE Lock_Row
130: ( x_return_status IN OUT NOCOPY VARCHAR2
131: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
132: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
133: , x_err_text IN OUT NOCOPY VARCHAR2
134: );
135:

Line 132: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

128:
129: PROCEDURE Lock_Row
130: ( x_return_status IN OUT NOCOPY VARCHAR2
131: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
132: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
133: , x_err_text IN OUT NOCOPY VARCHAR2
134: );
135:
136: /*#

Line 140: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }

136: /*#
137: * Perform Writes is the only exposed method that the user will have access to
138: * perform any insert/update/deletes to corresponding database tables.This can be used with ECO
139: * @param p_Sub_Component_Rec Substitute Component Record of exposed colmuns
140: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
141: * @param p_Sub_Comp_Unexp_Rec Substitute Component record of unexposed columns
142: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
143: * @param x_Mesg_Token_Tbl Message token table
144: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }

Line 142: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }

138: * perform any insert/update/deletes to corresponding database tables.This can be used with ECO
139: * @param p_Sub_Component_Rec Substitute Component Record of exposed colmuns
140: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
141: * @param p_Sub_Comp_Unexp_Rec Substitute Component record of unexposed columns
142: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
143: * @param x_Mesg_Token_Tbl Message token table
144: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
145: * @param x_Return_status Return Status
146: * @rep:scope private

Line 153: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

149: */
150:
151:
152: PROCEDURE Perform_Writes
153: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
154: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
155: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
156: , x_Return_Status IN OUT NOCOPY VARCHAR2
157: );

Line 154: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

150:
151:
152: PROCEDURE Perform_Writes
153: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
154: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
155: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
156: , x_Return_Status IN OUT NOCOPY VARCHAR2
157: );
158:

Line 166: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }

162:
163: /*#
164: * This method will convert the missing values of some attributes that the user wishes to NULL
165: * @param p_bom_sub_component_rec the record that need to be converted
166: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
167: * @return the converted record
168: * @rep:scope private
169: * @rep:lifecycle active
170: * @rep:displayname Convert Miss To Null

Line 174: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

170: * @rep:displayname Convert Miss To Null
171: */
172:
173: FUNCTION Convert_Miss_To_Null
174: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
175: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
176:
177: -- Function Query_Row
178:

Line 175: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

171: */
172:
173: FUNCTION Convert_Miss_To_Null
174: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
175: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
176:
177: -- Function Query_Row
178:
179: /*#

Line 186: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }

182: * @param p_substitute_component_id The IN parameters form the Substitute Component primary key
183: * @param p_component_sequence_id componenet sequence id
184: * @param p_acd_type acd type
185: * @param x_bom_Sub_Component_Rec Bom Substitute Component Record of exposed colmuns
186: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
187: * @param x_bom_Sub_Comp_Unexp_Rec Bom Substitute Component record of unexposed columns
188: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }
189: * @param x_return_status Indicating success or faliure
190: * @rep:scope private

Line 188: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }

184: * @param p_acd_type acd type
185: * @param x_bom_Sub_Component_Rec Bom Substitute Component Record of exposed colmuns
186: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
187: * @param x_bom_Sub_Comp_Unexp_Rec Bom Substitute Component record of unexposed columns
188: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }
189: * @param x_return_status Indicating success or faliure
190: * @rep:scope private
191: * @rep:lifecycle active
192: * @rep:displayname Query Row

Line 200: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

196: PROCEDURE Query_Row
197: ( p_substitute_component_id IN NUMBER
198: , p_component_sequence_id IN NUMBER
199: , p_acd_type IN NUMBER
200: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
201: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
202: , x_return_status IN OUT NOCOPY VARCHAR2
203: );
204:

Line 201: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

197: ( p_substitute_component_id IN NUMBER
198: , p_component_sequence_id IN NUMBER
199: , p_acd_type IN NUMBER
200: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
201: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
202: , x_return_status IN OUT NOCOPY VARCHAR2
203: );
204:
205: /*#

Line 209: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }

205: /*#
206: * Perform Writes is the only exposed method that the user will have access to perform any
207: * insert/update/deletes to corresponding database tables
208: * @param p_bom_Sub_Component_Rec Bom Substitute Component Record of exposed colmuns
209: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
210: * @param p_bom_Sub_Comp_Unexp_Rec Bom Substitute Component record of unexposed columns
211: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }
212: * @param x_Mesg_Token_Tbl Message token table
213: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }

Line 211: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }

207: * insert/update/deletes to corresponding database tables
208: * @param p_bom_Sub_Component_Rec Bom Substitute Component Record of exposed colmuns
209: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
210: * @param p_bom_Sub_Comp_Unexp_Rec Bom Substitute Component record of unexposed columns
211: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }
212: * @param x_Mesg_Token_Tbl Message token table
213: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
214: * @param x_Return_status Return Status
215: * @rep:scope private

Line 222: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

218: */
219:
220:
221: PROCEDURE Perform_Writes
222: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
223: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
224: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
225: , x_Return_Status IN OUT NOCOPY VARCHAR2
226: );

Line 223: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

219:
220:
221: PROCEDURE Perform_Writes
222: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
223: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
224: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
225: , x_Return_Status IN OUT NOCOPY VARCHAR2
226: );
227: