DBA Data[Home] [Help]

APPS.ENG_REF_DESIGNATOR_UTIL dependencies on BOM_GLOBALS

Line 153: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id

149: BEGIN
150:
151: UPDATE BOM_REFERENCE_DESIGNATORS
152: SET LAST_UPDATE_DATE = SYSDATE
153: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
154: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
155: , REF_DESIGNATOR_COMMENT =
156: p_ref_designator_rec.ref_designator_comment
157: , ATTRIBUTE_CATEGORY = p_ref_designator_rec.attribute_category

Line 154: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id

150:
151: UPDATE BOM_REFERENCE_DESIGNATORS
152: SET LAST_UPDATE_DATE = SYSDATE
153: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
154: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
155: , REF_DESIGNATOR_COMMENT =
156: p_ref_designator_rec.ref_designator_comment
157: , ATTRIBUTE_CATEGORY = p_ref_designator_rec.attribute_category
158: , ATTRIBUTE1 = p_ref_designator_rec.attribute1

Line 257: , Bom_Globals.Get_User_Id

253: )
254: VALUES
255: ( p_ref_designator_rec.Reference_Designator_Name
256: , SYSDATE
257: , Bom_Globals.Get_User_Id
258: , SYSDATE
259: , Bom_Globals.Get_User_Id
260: , Bom_Globals.Get_User_Id
261: , p_ref_designator_rec.ref_designator_comment

Line 259: , Bom_Globals.Get_User_Id

255: ( p_ref_designator_rec.Reference_Designator_Name
256: , SYSDATE
257: , Bom_Globals.Get_User_Id
258: , SYSDATE
259: , Bom_Globals.Get_User_Id
260: , Bom_Globals.Get_User_Id
261: , p_ref_designator_rec.ref_designator_comment
262: , p_ref_designator_rec.Eco_Name
263: , p_Ref_Desg_Unexp_Rec.component_sequence_id

Line 260: , Bom_Globals.Get_User_Id

256: , SYSDATE
257: , Bom_Globals.Get_User_Id
258: , SYSDATE
259: , Bom_Globals.Get_User_Id
260: , Bom_Globals.Get_User_Id
261: , p_ref_designator_rec.ref_designator_comment
262: , p_ref_designator_rec.Eco_Name
263: , p_Ref_Desg_Unexp_Rec.component_sequence_id
264: , p_ref_designator_rec.acd_type

Line 266: , Bom_Globals.Get_Prog_AppId

262: , p_ref_designator_rec.Eco_Name
263: , p_Ref_Desg_Unexp_Rec.component_sequence_id
264: , p_ref_designator_rec.acd_type
265: , NULL /* Request Id */
266: , Bom_Globals.Get_Prog_AppId
267: , Bom_Globals.Get_Prog_Id
268: , SYSDATE
269: , p_ref_designator_rec.attribute_category
270: , p_ref_designator_rec.attribute1

Line 267: , Bom_Globals.Get_Prog_Id

263: , p_Ref_Desg_Unexp_Rec.component_sequence_id
264: , p_ref_designator_rec.acd_type
265: , NULL /* Request Id */
266: , Bom_Globals.Get_Prog_AppId
267: , Bom_Globals.Get_Prog_Id
268: , SYSDATE
269: , p_ref_designator_rec.attribute_category
270: , p_ref_designator_rec.attribute1
271: , p_ref_designator_rec.attribute2

Line 436: x_Return_Status := Bom_Globals.G_RECORD_FOUND;

432: ;
433:
434: x_Ref_Designator_Rec := l_ref_designator_rec;
435: x_Ref_Desg_Unexp_Rec := l_Ref_Desg_Unexp_Rec;
436: x_Return_Status := Bom_Globals.G_RECORD_FOUND;
437:
438: EXCEPTION
439:
440: WHEN NO_DATA_FOUND THEN

Line 441: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;

437:
438: EXCEPTION
439:
440: WHEN NO_DATA_FOUND THEN
441: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;
442:
443: WHEN OTHERS THEN
444: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
445:

Line 460: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE

456: l_return_status VARCHAR2(1);
457: BEGIN
458: l_return_status := FND_API.G_RET_STS_SUCCESS;
459:
460: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE
461: THEN
462: Insert_Row( p_ref_designator_rec =>
463: p_ref_designator_rec
464: , p_ref_desg_unexp_rec =>

Line 469: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

465: p_ref_desg_unexp_rec
466: , x_mesg_token_tbl => l_mesg_token_tbl
467: , x_return_status => l_return_status
468: );
469: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
470: THEN
471: Update_Row( p_ref_designator_rec =>
472: p_ref_designator_rec
473: , p_ref_desg_unexp_rec =>

Line 480: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_DELETE

476: l_mesg_token_tbl
477: , x_return_status =>
478: l_return_status
479: );
480: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_DELETE
481: THEN
482: Delete_Row
483: ( p_ref_designator =>
484: p_ref_designator_rec.reference_designator_name