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_REF_DESIGNATOR_UTIL dependencies on BOM_GLOBALS

Line 166: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;

162: l_return_status varchar2(80);
163: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
164: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
165: l_Token_Tbl Error_Handler.Token_Tbl_Type;
166: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
167: BEGIN
168: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
169: UPDATE BOM_REFERENCE_DESIGNATORS
170: SET COMPONENT_REFERENCE_DESIGNATOR =

Line 178: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id

174: p_ref_designator_rec.Reference_Designator_Name,
175: p_ref_designator_rec.new_reference_designator
176: )
177: , LAST_UPDATE_DATE = SYSDATE
178: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
179: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
180: , REF_DESIGNATOR_COMMENT =
181: DECODE( p_ref_designator_rec.ref_designator_comment
182: , FND_API.G_MISS_CHAR

Line 179: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id

175: p_ref_designator_rec.new_reference_designator
176: )
177: , LAST_UPDATE_DATE = SYSDATE
178: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
179: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
180: , REF_DESIGNATOR_COMMENT =
181: DECODE( p_ref_designator_rec.ref_designator_comment
182: , FND_API.G_MISS_CHAR
183: , NULL

Line 212: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND

208: WHERE COMPONENT_REFERENCE_DESIGNATOR =
209: p_ref_designator_rec.Reference_Designator_Name
210: AND COMPONENT_SEQUENCE_ID =
211: p_Ref_Desg_Unexp_Rec.component_sequence_id
212: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
213: ACD_TYPE = p_Ref_Designator_Rec.acd_type
214: ) OR
215: ( l_BO_Id = Bom_Globals.G_BOM_BO AND
216: (acd_type IS NULL or acd_type = 1)

Line 215: ( l_BO_Id = Bom_Globals.G_BOM_BO AND

211: p_Ref_Desg_Unexp_Rec.component_sequence_id
212: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
213: ACD_TYPE = p_Ref_Designator_Rec.acd_type
214: ) OR
215: ( l_BO_Id = Bom_Globals.G_BOM_BO AND
216: (acd_type IS NULL or acd_type = 1)
217: /* Bug 5726557; The code is modified to modify the refernce designators
218: when implemneted through an ECO */
219: )

Line 311: , Bom_Globals.Get_User_Id

307: )
308: VALUES
309: ( p_ref_designator_rec.Reference_Designator_Name
310: , SYSDATE
311: , Bom_Globals.Get_User_Id
312: , SYSDATE
313: , Bom_Globals.Get_User_Id
314: , Bom_Globals.Get_User_Id
315: , DECODE( p_ref_designator_rec.ref_designator_comment

Line 313: , Bom_Globals.Get_User_Id

309: ( p_ref_designator_rec.Reference_Designator_Name
310: , SYSDATE
311: , Bom_Globals.Get_User_Id
312: , SYSDATE
313: , Bom_Globals.Get_User_Id
314: , Bom_Globals.Get_User_Id
315: , DECODE( p_ref_designator_rec.ref_designator_comment
316: , FND_API.G_MISS_CHAR
317: , NULL

Line 314: , Bom_Globals.Get_User_Id

310: , SYSDATE
311: , Bom_Globals.Get_User_Id
312: , SYSDATE
313: , Bom_Globals.Get_User_Id
314: , Bom_Globals.Get_User_Id
315: , DECODE( p_ref_designator_rec.ref_designator_comment
316: , FND_API.G_MISS_CHAR
317: , NULL
318: , p_ref_designator_rec.ref_designator_comment )

Line 323: , Bom_Globals.Get_Prog_AppId

319: , p_ref_designator_rec.Eco_Name
320: , p_Ref_Desg_Unexp_Rec.component_sequence_id
321: , p_ref_designator_rec.acd_type
322: , Fnd_Global.Conc_Request_Id /* Request Id */
323: , Bom_Globals.Get_Prog_AppId
324: , Bom_Globals.Get_Prog_Id
325: , SYSDATE
326: , p_ref_designator_rec.attribute_category
327: , p_ref_designator_rec.attribute1

Line 324: , Bom_Globals.Get_Prog_Id

320: , p_Ref_Desg_Unexp_Rec.component_sequence_id
321: , p_ref_designator_rec.acd_type
322: , Fnd_Global.Conc_Request_Id /* Request Id */
323: , Bom_Globals.Get_Prog_AppId
324: , Bom_Globals.Get_Prog_Id
325: , SYSDATE
326: , p_ref_designator_rec.attribute_category
327: , p_ref_designator_rec.attribute1
328: , p_ref_designator_rec.attribute2

Line 367: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('ERROR in Insert Row (Ref Desgs)' || substr(SQLERRM, 1, 100) || ' ' || to_char(SQLCODE)); END IF;

363: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
364: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
365: );
366:
367: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('ERROR in Insert Row (Ref Desgs)' || substr(SQLERRM, 1, 100) || ' ' || to_char(SQLCODE)); END IF;
368:
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370:
371: END Insert_Row;

Line 394: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;

390: , x_Return_Status IN OUT NOCOPY VARCHAR2
391: )
392: IS
393: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
394: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
395:
396: BEGIN
397:
398: DELETE FROM BOM_REFERENCE_DESIGNATORS

Line 401: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND

397:
398: DELETE FROM BOM_REFERENCE_DESIGNATORS
399: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
400: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
401: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
402: ACD_TYPE = p_acd_type
403: ) OR
404: ( l_BO_Id = Bom_Globals.G_BOM_BO AND
405: acd_type IS NULL

Line 404: ( l_BO_Id = Bom_Globals.G_BOM_BO AND

400: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
401: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
402: ACD_TYPE = p_acd_type
403: ) OR
404: ( l_BO_Id = Bom_Globals.G_BOM_BO AND
405: acd_type IS NULL
406: )
407: );
408: BOMPCMBM.Delete_Related_Ref_Desg(p_src_comp_seq => p_component_sequence_id

Line 518: x_Return_Status := Bom_Globals.G_RECORD_FOUND;

514: ;
515:
516: x_Ref_Designator_Rec := l_ref_designator_rec;
517: x_Ref_Desg_Unexp_Rec := l_Ref_Desg_Unexp_Rec;
518: x_Return_Status := Bom_Globals.G_RECORD_FOUND;
519:
520: EXCEPTION
521:
522: WHEN NO_DATA_FOUND THEN

Line 523: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;

519:
520: EXCEPTION
521:
522: WHEN NO_DATA_FOUND THEN
523: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;
524:
525: WHEN OTHERS THEN
526: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
527:

Line 544: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE

540: l_return_status VARCHAR2(1);
541: BEGIN
542: l_return_status := FND_API.G_RET_STS_SUCCESS;
543:
544: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE
545: THEN
546: Insert_Row( p_ref_designator_rec =>
547: p_ref_designator_rec
548: , p_ref_desg_unexp_rec =>

Line 553: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

549: p_ref_desg_unexp_rec
550: , x_mesg_token_tbl => l_mesg_token_tbl
551: , x_return_status => l_return_status
552: );
553: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
554: THEN
555: Update_Row( p_ref_designator_rec =>
556: p_ref_designator_rec
557: , p_ref_desg_unexp_rec =>

Line 564: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_DELETE

560: l_mesg_token_tbl
561: , x_return_status =>
562: l_return_status
563: );
564: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_DELETE
565: THEN
566: Delete_Row
567: ( p_ref_designator =>
568: p_ref_designator_rec.reference_designator_name