eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: --added for bug 7713832
85: FUNCTION Common_CompSeqIdSC( p_comp_seq_id NUMBER)

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: --added for bug 7713832
85: FUNCTION Common_CompSeqIdSC( p_comp_seq_id NUMBER)
86: RETURN NUMBER;

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

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

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

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

Line 110: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

106: PROCEDURE Query_Row
107: ( p_substitute_component_id IN NUMBER
108: , p_component_sequence_id IN NUMBER
109: , p_acd_type IN NUMBER
110: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
111: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
112: , x_return_status IN OUT NOCOPY VARCHAR2
113: );
114:

Line 111: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

107: ( p_substitute_component_id IN NUMBER
108: , p_component_sequence_id IN NUMBER
109: , p_acd_type IN NUMBER
110: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
111: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
112: , x_return_status IN OUT NOCOPY VARCHAR2
113: );
114:
115: -- Procedure lock_Row

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

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

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

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

Line 135: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

131:
132:
133: PROCEDURE Lock_Row
134: ( x_return_status IN OUT NOCOPY VARCHAR2
135: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
136: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
137: , x_err_text IN OUT NOCOPY VARCHAR2
138: );
139:

Line 136: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

132:
133: PROCEDURE Lock_Row
134: ( x_return_status IN OUT NOCOPY VARCHAR2
135: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
136: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
137: , x_err_text IN OUT NOCOPY VARCHAR2
138: );
139:
140: /*#

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

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

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

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

Line 157: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

153: */
154:
155:
156: PROCEDURE Perform_Writes
157: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
158: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
159: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
160: , x_Return_Status IN OUT NOCOPY VARCHAR2
161: );

Line 158: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

154:
155:
156: PROCEDURE Perform_Writes
157: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
158: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
159: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
160: , x_Return_Status IN OUT NOCOPY VARCHAR2
161: );
162:

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

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

Line 178: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

174: * @rep:displayname Convert Miss To Null
175: */
176:
177: FUNCTION Convert_Miss_To_Null
178: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
179: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
180:
181: -- Function Query_Row
182:

Line 179: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

175: */
176:
177: FUNCTION Convert_Miss_To_Null
178: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
179: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
180:
181: -- Function Query_Row
182:
183: /*#

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

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

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

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

Line 204: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

200: PROCEDURE Query_Row
201: ( p_substitute_component_id IN NUMBER
202: , p_component_sequence_id IN NUMBER
203: , p_acd_type IN NUMBER
204: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
205: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
206: , x_return_status IN OUT NOCOPY VARCHAR2
207: );
208:

Line 205: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

201: ( p_substitute_component_id IN NUMBER
202: , p_component_sequence_id IN NUMBER
203: , p_acd_type IN NUMBER
204: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
205: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
206: , x_return_status IN OUT NOCOPY VARCHAR2
207: );
208:
209: /*#

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

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

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

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

Line 226: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

222: */
223:
224:
225: PROCEDURE Perform_Writes
226: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
227: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
228: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229: , x_Return_Status IN OUT NOCOPY VARCHAR2
230: );

Line 227: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

223:
224:
225: PROCEDURE Perform_Writes
226: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
227: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
228: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229: , x_Return_Status IN OUT NOCOPY VARCHAR2
230: );
231: