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_BOM_COMPONENT_UTIL dependencies on BOM_BO_PUB

Line 62: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type

58: * Purpose : This procedure will convert the missing values of
59: * some attributes that the user wishes to NULL.
60: **********************************************************************/
61: PROCEDURE Convert_Miss_To_Null
62: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
63: , p_bom_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
64: , x_bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
65: , x_bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
66: )

Line 63: , p_bom_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

59: * some attributes that the user wishes to NULL.
60: **********************************************************************/
61: PROCEDURE Convert_Miss_To_Null
62: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
63: , p_bom_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
64: , x_bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
65: , x_bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
66: )
67: IS

Line 64: , x_bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type

60: **********************************************************************/
61: PROCEDURE Convert_Miss_To_Null
62: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
63: , p_bom_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
64: , x_bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
65: , x_bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
66: )
67: IS
68: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

Line 65: , x_bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

61: PROCEDURE Convert_Miss_To_Null
62: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
63: , p_bom_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
64: , x_bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
65: , x_bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
66: )
67: IS
68: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
69: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

Line 68: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

64: , x_bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
65: , x_bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
66: )
67: IS
68: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
69: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
70: BEGIN
71:
72: -- Convert the BOM Record to ECO Record

Line 69: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

65: , x_bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
66: )
67: IS
68: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
69: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
70: BEGIN
71:
72: -- Convert the BOM Record to ECO Record
73: Bom_Bo_Pub.Convert_BomComp_To_EcoComp

Line 73: Bom_Bo_Pub.Convert_BomComp_To_EcoComp

69: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
70: BEGIN
71:
72: -- Convert the BOM Record to ECO Record
73: Bom_Bo_Pub.Convert_BomComp_To_EcoComp
74: ( p_bom_component_rec => p_bom_component_rec
75: , p_bom_comp_unexp_rec => p_bom_comp_unexp_rec
76: , x_rev_component_rec => l_rev_component_rec
77: , x_rev_comp_unexp_rec => l_rev_comp_unexp_rec

Line 91: Bom_Bo_Pub.Convert_EcoComp_To_BomComp

87: );
88:
89: -- Convert the ECO Record back to BOM for return
90:
91: Bom_Bo_Pub.Convert_EcoComp_To_BomComp
92: ( p_rev_component_rec => l_rev_component_rec
93: , p_rev_comp_unexp_rec => l_rev_comp_unexp_rec
94: , x_bom_component_rec => x_bom_component_rec
95: , x_bom_comp_unexp_rec => x_bom_comp_unexp_rec

Line 117: , x_Bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type

113: , p_Operation_Sequence_Number IN NUMBER
114: , p_Effectivity_Date IN DATE
115: , p_Bill_Sequence_Id IN NUMBER
116: , p_from_end_item_number IN VARCHAR2 := NULL
117: , x_Bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
118: , x_Bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
119: , x_Return_Status IN OUT NOCOPY VARCHAR2
120: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type
121: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 118: , x_Bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

114: , p_Effectivity_Date IN DATE
115: , p_Bill_Sequence_Id IN NUMBER
116: , p_from_end_item_number IN VARCHAR2 := NULL
117: , x_Bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
118: , x_Bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
119: , x_Return_Status IN OUT NOCOPY VARCHAR2
120: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type
121: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
122:

Line 125: l_rev_component_rec Bom_Bo_Pub.Rev_component_Rec_Type;

121: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
122:
123: )
124: IS
125: l_rev_component_rec Bom_Bo_Pub.Rev_component_Rec_Type;
126: l_rev_comp_unexp_rec Bom_Bo_pub.Rev_Comp_unexposed_Rec_Type;
127:
128: BEGIN
129:

Line 126: l_rev_comp_unexp_rec Bom_Bo_pub.Rev_Comp_unexposed_Rec_Type;

122:
123: )
124: IS
125: l_rev_component_rec Bom_Bo_Pub.Rev_component_Rec_Type;
126: l_rev_comp_unexp_rec Bom_Bo_pub.Rev_Comp_unexposed_Rec_Type;
127:
128: BEGIN
129:
130: x_mesg_token_tbl := p_mesg_token_tbl;

Line 147: Bom_Bo_Pub.Convert_EcoComp_To_BomComp

143: );
144:
145: -- Convert the ECO record to BOM Record
146:
147: Bom_Bo_Pub.Convert_EcoComp_To_BomComp
148: ( p_rev_component_rec => l_rev_component_rec
149: , p_rev_comp_unexp_rec => l_rev_comp_unexp_rec
150: , x_bom_component_rec => x_bom_component_rec
151: , x_bom_comp_unexp_rec => x_bom_comp_unexp_rec

Line 168: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type

164: * user has to perform any insert/update/deletes to the
165: * Inventory Components table.
166: *********************************************************************/
167: PROCEDURE Perform_Writes
168: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
169: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
170: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
171: , x_Return_Status IN OUT NOCOPY VARCHAR2
172: )

Line 169: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

165: * Inventory Components table.
166: *********************************************************************/
167: PROCEDURE Perform_Writes
168: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
169: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
170: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
171: , x_Return_Status IN OUT NOCOPY VARCHAR2
172: )
173: IS

Line 174: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

170: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
171: , x_Return_Status IN OUT NOCOPY VARCHAR2
172: )
173: IS
174: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
175: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
176: BEGIN
177:
178: -- Convert the BOM Record to ECO Record

Line 175: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

171: , x_Return_Status IN OUT NOCOPY VARCHAR2
172: )
173: IS
174: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
175: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
176: BEGIN
177:
178: -- Convert the BOM Record to ECO Record
179: Bom_Bo_Pub.Convert_BomComp_To_EcoComp

Line 179: Bom_Bo_Pub.Convert_BomComp_To_EcoComp

175: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
176: BEGIN
177:
178: -- Convert the BOM Record to ECO Record
179: Bom_Bo_Pub.Convert_BomComp_To_EcoComp
180: ( p_bom_component_rec => p_bom_component_rec
181: , p_bom_comp_unexp_rec => p_bom_comp_unexp_rec
182: , x_rev_component_rec => l_rev_component_rec
183: , x_rev_comp_unexp_rec => l_rev_comp_unexp_rec

Line 211: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type

207: , p_Operation_Sequence_Number IN NUMBER
208: , p_Effectivity_Date IN DATE
209: , p_Bill_Sequence_Id IN NUMBER
210: , p_from_end_item_number IN VARCHAR2 := NULL
211: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
212: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
213: , x_Return_Status IN OUT NOCOPY VARCHAR2
214: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type
215: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 212: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

208: , p_Effectivity_Date IN DATE
209: , p_Bill_Sequence_Id IN NUMBER
210: , p_from_end_item_number IN VARCHAR2 := NULL
211: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
212: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
213: , x_Return_Status IN OUT NOCOPY VARCHAR2
214: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type
215: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
216:

Line 219: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

215: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
216:
217: )
218: IS
219: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
220: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
221: l_err_text VARCHAR2(2000);
222: BEGIN
223:

Line 220: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

216:
217: )
218: IS
219: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
220: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
221: l_err_text VARCHAR2(2000);
222: BEGIN
223:
224: -- dbms_output.put_line('Querying component record . . .');

Line 426: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

422: * the user given values. Any errors will be returned by filling
423: * the Mesg_Token_Tbl and setting the return_status.
424: ****************************************************************************/
425: PROCEDURE Update_Row
426: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
427: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
428: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
429: , x_Return_Status IN OUT NOCOPY VARCHAR2
430: )

Line 427: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

423: * the Mesg_Token_Tbl and setting the return_status.
424: ****************************************************************************/
425: PROCEDURE Update_Row
426: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
427: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
428: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
429: , x_Return_Status IN OUT NOCOPY VARCHAR2
430: )
431: IS

Line 434: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

430: )
431: IS
432: l_return_status varchar2(80);
433: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
434: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
435: l_err_text VARCHAR2(2000);
436: l_operation_leadtime NUMBER := NULL;
437: l_operation_seq_num NUMBER;
438: BEGIN

Line 587: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

583: * component table. Any errors will be filled in the Mesg_Token
584: * Tbl and returned with a return_status of U
585: *****************************************************************************/
586: PROCEDURE Insert_Row
587: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
588: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
589: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
590: , x_Return_Status IN OUT NOCOPY VARCHAR2
591: )

Line 588: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

584: * Tbl and returned with a return_status of U
585: *****************************************************************************/
586: PROCEDURE Insert_Row
587: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
588: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
589: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
590: , x_Return_Status IN OUT NOCOPY VARCHAR2
591: )
592: IS

Line 917: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

913: )
914: */
915:
916: PROCEDURE Delete_Row
917: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
918: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
919: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
920: , x_Return_Status IN OUT NOCOPY VARCHAR2
921: )

Line 918: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

914: */
915:
916: PROCEDURE Delete_Row
917: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
918: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
919: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
920: , x_Return_Status IN OUT NOCOPY VARCHAR2
921: )
922:

Line 938: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type ;

934: WHERE delete_group_name = p_rev_comp_unexp_rec.delete_group_name
935: AND organization_id = p_rev_comp_unexp_rec.organization_id;
936:
937: l_dg_sequence_id NUMBER;
938: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type ;
939: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type ;
940: l_assembly_type NUMBER;
941:
942:

Line 939: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type ;

935: AND organization_id = p_rev_comp_unexp_rec.organization_id;
936:
937: l_dg_sequence_id NUMBER;
938: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type ;
939: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type ;
940: l_assembly_type NUMBER;
941:
942:
943:

Line 1260: Bom_Bo_Pub.Rev_Component_Rec_Type

1256:
1257: END Cancel_Component;
1258:
1259: PROCEDURE Perform_Writes( p_rev_component_rec IN
1260: Bom_Bo_Pub.Rev_Component_Rec_Type
1261: , p_rev_comp_unexp_rec IN
1262: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1263: , p_control_rec IN
1264: Bom_Bo_Pub.Control_Rec_Type

Line 1262: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1258:
1259: PROCEDURE Perform_Writes( p_rev_component_rec IN
1260: Bom_Bo_Pub.Rev_Component_Rec_Type
1261: , p_rev_comp_unexp_rec IN
1262: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1263: , p_control_rec IN
1264: Bom_Bo_Pub.Control_Rec_Type
1265: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1266: , x_Mesg_Token_Tbl IN OUT NOCOPY

Line 1264: Bom_Bo_Pub.Control_Rec_Type

1260: Bom_Bo_Pub.Rev_Component_Rec_Type
1261: , p_rev_comp_unexp_rec IN
1262: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1263: , p_control_rec IN
1264: Bom_Bo_Pub.Control_Rec_Type
1265: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1266: , x_Mesg_Token_Tbl IN OUT NOCOPY
1267: Error_Handler.Mesg_Token_Tbl_Type
1268: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 1265: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC

1261: , p_rev_comp_unexp_rec IN
1262: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1263: , p_control_rec IN
1264: Bom_Bo_Pub.Control_Rec_Type
1265: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1266: , x_Mesg_Token_Tbl IN OUT NOCOPY
1267: Error_Handler.Mesg_Token_Tbl_Type
1268: , x_Return_Status IN OUT NOCOPY VARCHAR2
1269: )

Line 1272: l_Rev_component_Rec Bom_Bo_Pub.Rev_Component_rec_Type;

1268: , x_Return_Status IN OUT NOCOPY VARCHAR2
1269: )
1270: IS
1271: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1272: l_Rev_component_Rec Bom_Bo_Pub.Rev_Component_rec_Type;
1273: l_rev_comp_unexp_rec Bom_Bo_Pub.rev_comp_unexposed_rec_type;
1274: l_return_status VARCHAR2(1);
1275: l_assembly_type NUMBER;
1276: l_Comp_Seq_Id NUMBER;

Line 1273: l_rev_comp_unexp_rec Bom_Bo_Pub.rev_comp_unexposed_rec_type;

1269: )
1270: IS
1271: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1272: l_Rev_component_Rec Bom_Bo_Pub.Rev_Component_rec_Type;
1273: l_rev_comp_unexp_rec Bom_Bo_Pub.rev_comp_unexposed_rec_type;
1274: l_return_status VARCHAR2(1);
1275: l_assembly_type NUMBER;
1276: l_Comp_Seq_Id NUMBER;
1277: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- Added by MK on 11/13/00

Line 1748: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

1744: * Revised component unexposed column record.
1745: * Purpose : This procedure will convert all missing columns to NULL.
1746: ****************************************************************************/
1747: PROCEDURE Convert_Miss_To_Null
1748: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1749: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1750: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1751: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1752: )

Line 1749: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1745: * Purpose : This procedure will convert all missing columns to NULL.
1746: ****************************************************************************/
1747: PROCEDURE Convert_Miss_To_Null
1748: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1749: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1750: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1751: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1752: )
1753: IS

Line 1750: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type

1746: ****************************************************************************/
1747: PROCEDURE Convert_Miss_To_Null
1748: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1749: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1750: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1751: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1752: )
1753: IS
1754: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=

Line 1751: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1747: PROCEDURE Convert_Miss_To_Null
1748: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1749: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1750: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1751: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1752: )
1753: IS
1754: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=
1755: p_rev_component_rec;

Line 1754: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=

1750: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1751: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1752: )
1753: IS
1754: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=
1755: p_rev_component_rec;
1756: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
1757: p_Rev_Comp_Unexp_Rec;
1758: BEGIN

Line 1756: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=

1752: )
1753: IS
1754: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=
1755: p_rev_component_rec;
1756: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
1757: p_Rev_Comp_Unexp_Rec;
1758: BEGIN
1759:
1760: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN