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 624: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

620: * component table. Any errors will be filled in the Mesg_Token
621: * Tbl and returned with a return_status of U
622: *****************************************************************************/
623: PROCEDURE Insert_Row
624: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
625: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
626: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
627: , x_Return_Status IN OUT NOCOPY VARCHAR2
628: )

Line 625: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

621: * Tbl and returned with a return_status of U
622: *****************************************************************************/
623: PROCEDURE Insert_Row
624: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
625: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
626: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
627: , x_Return_Status IN OUT NOCOPY VARCHAR2
628: )
629: IS

Line 1019: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

1015: )
1016: */
1017:
1018: PROCEDURE Delete_Row
1019: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1020: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1021: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1022: , x_Return_Status IN OUT NOCOPY VARCHAR2
1023: )

Line 1020: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1016: */
1017:
1018: PROCEDURE Delete_Row
1019: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1020: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1021: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1022: , x_Return_Status IN OUT NOCOPY VARCHAR2
1023: )
1024:

Line 1040: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type ;

1036: WHERE delete_group_name = p_rev_comp_unexp_rec.delete_group_name
1037: AND organization_id = p_rev_comp_unexp_rec.organization_id;
1038:
1039: l_dg_sequence_id NUMBER;
1040: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type ;
1041: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type ;
1042: l_assembly_type NUMBER;
1043:
1044:

Line 1041: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type ;

1037: AND organization_id = p_rev_comp_unexp_rec.organization_id;
1038:
1039: l_dg_sequence_id NUMBER;
1040: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type ;
1041: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type ;
1042: l_assembly_type NUMBER;
1043:
1044:
1045:

Line 1367: Bom_Bo_Pub.Rev_Component_Rec_Type

1363:
1364: END Cancel_Component;
1365:
1366: PROCEDURE Perform_Writes( p_rev_component_rec IN
1367: Bom_Bo_Pub.Rev_Component_Rec_Type
1368: , p_rev_comp_unexp_rec IN
1369: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1370: , p_control_rec IN
1371: Bom_Bo_Pub.Control_Rec_Type

Line 1369: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1365:
1366: PROCEDURE Perform_Writes( p_rev_component_rec IN
1367: Bom_Bo_Pub.Rev_Component_Rec_Type
1368: , p_rev_comp_unexp_rec IN
1369: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1370: , p_control_rec IN
1371: Bom_Bo_Pub.Control_Rec_Type
1372: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1373: , x_Mesg_Token_Tbl IN OUT NOCOPY

Line 1371: Bom_Bo_Pub.Control_Rec_Type

1367: Bom_Bo_Pub.Rev_Component_Rec_Type
1368: , p_rev_comp_unexp_rec IN
1369: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1370: , p_control_rec IN
1371: Bom_Bo_Pub.Control_Rec_Type
1372: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1373: , x_Mesg_Token_Tbl IN OUT NOCOPY
1374: Error_Handler.Mesg_Token_Tbl_Type
1375: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 1372: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC

1368: , p_rev_comp_unexp_rec IN
1369: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1370: , p_control_rec IN
1371: Bom_Bo_Pub.Control_Rec_Type
1372: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1373: , x_Mesg_Token_Tbl IN OUT NOCOPY
1374: Error_Handler.Mesg_Token_Tbl_Type
1375: , x_Return_Status IN OUT NOCOPY VARCHAR2
1376: )

Line 1379: l_Rev_component_Rec Bom_Bo_Pub.Rev_Component_rec_Type;

1375: , x_Return_Status IN OUT NOCOPY VARCHAR2
1376: )
1377: IS
1378: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1379: l_Rev_component_Rec Bom_Bo_Pub.Rev_Component_rec_Type;
1380: l_rev_comp_unexp_rec Bom_Bo_Pub.rev_comp_unexposed_rec_type;
1381: l_return_status VARCHAR2(1);
1382: l_assembly_type NUMBER;
1383: l_Comp_Seq_Id NUMBER;

Line 1380: l_rev_comp_unexp_rec Bom_Bo_Pub.rev_comp_unexposed_rec_type;

1376: )
1377: IS
1378: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1379: l_Rev_component_Rec Bom_Bo_Pub.Rev_Component_rec_Type;
1380: l_rev_comp_unexp_rec Bom_Bo_Pub.rev_comp_unexposed_rec_type;
1381: l_return_status VARCHAR2(1);
1382: l_assembly_type NUMBER;
1383: l_Comp_Seq_Id NUMBER;
1384: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- Added by MK on 11/13/00

Line 1856: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

1852: * Revised component unexposed column record.
1853: * Purpose : This procedure will convert all missing columns to NULL.
1854: ****************************************************************************/
1855: PROCEDURE Convert_Miss_To_Null
1856: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1857: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1858: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1859: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1860: )

Line 1857: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1853: * Purpose : This procedure will convert all missing columns to NULL.
1854: ****************************************************************************/
1855: PROCEDURE Convert_Miss_To_Null
1856: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1857: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1858: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1859: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1860: )
1861: IS

Line 1858: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type

1854: ****************************************************************************/
1855: PROCEDURE Convert_Miss_To_Null
1856: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1857: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1858: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1859: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1860: )
1861: IS
1862: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=

Line 1859: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1855: PROCEDURE Convert_Miss_To_Null
1856: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1857: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1858: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1859: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1860: )
1861: IS
1862: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=
1863: p_rev_component_rec;

Line 1862: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=

1858: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
1859: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1860: )
1861: IS
1862: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=
1863: p_rev_component_rec;
1864: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
1865: p_Rev_Comp_Unexp_Rec;
1866: BEGIN

Line 1864: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=

1860: )
1861: IS
1862: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type :=
1863: p_rev_component_rec;
1864: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
1865: p_Rev_Comp_Unexp_Rec;
1866: BEGIN
1867:
1868: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN