DBA Data[Home] [Help]

APPS.BOM_BOM_REVISION_UTIL dependencies on BOM_GLOBALS

Line 82: Bom_Globals.Get_User_Id,

78: --* Added Nvl condition for Bug #3573457
79: Nvl(p_bom_revision_rec.Revision_label,p_bom_revision_rec.Revision),
80: p_bom_revision_rec.Revision_reason,
81: SYSDATE,
82: Bom_Globals.Get_User_Id,
83: SYSDATE,
84: Bom_Globals.Get_User_Id,
85: Bom_Globals.Get_User_Id,
86: NVL(p_bom_revision_rec.start_effective_date,sysdate),/*impl date*/--bug:4242412 Replace NULL effectivity date by SYSDATE

Line 84: Bom_Globals.Get_User_Id,

80: p_bom_revision_rec.Revision_reason,
81: SYSDATE,
82: Bom_Globals.Get_User_Id,
83: SYSDATE,
84: Bom_Globals.Get_User_Id,
85: Bom_Globals.Get_User_Id,
86: NVL(p_bom_revision_rec.start_effective_date,sysdate),/*impl date*/--bug:4242412 Replace NULL effectivity date by SYSDATE
87: NVL(p_bom_revision_rec.start_effective_date,sysdate),/*eff. date*/--bug:4242412 Replace NULL effectivity date by SYSDATE
88: p_bom_revision_rec.Attribute_Category,

Line 85: Bom_Globals.Get_User_Id,

81: SYSDATE,
82: Bom_Globals.Get_User_Id,
83: SYSDATE,
84: Bom_Globals.Get_User_Id,
85: Bom_Globals.Get_User_Id,
86: NVL(p_bom_revision_rec.start_effective_date,sysdate),/*impl date*/--bug:4242412 Replace NULL effectivity date by SYSDATE
87: NVL(p_bom_revision_rec.start_effective_date,sysdate),/*eff. date*/--bug:4242412 Replace NULL effectivity date by SYSDATE
88: p_bom_revision_rec.Attribute_Category,
89: p_bom_revision_rec.Attribute1,

Line 190: last_update_login = Bom_Globals.Get_User_Id,

186: effectivity_date = NVL(p_bom_revision_rec.start_effective_date,sysdate),--bug:4242412 Replace NULL effectivity date by SYSDATE
187: revision_label= p_bom_revision_rec.revision_label,
188: revision_reason= p_bom_revision_rec.revision_reason,
189: last_update_date = SYSDATE,
190: last_update_login = Bom_Globals.Get_User_Id,
191: last_updated_by = Bom_Globals.Get_User_Id,
192: Attribute_Category = p_bom_revision_rec.Attribute_Category,
193: Attribute1 = p_bom_revision_rec.Attribute1,
194: Attribute2 = p_bom_revision_rec.Attribute2,

Line 191: last_updated_by = Bom_Globals.Get_User_Id,

187: revision_label= p_bom_revision_rec.revision_label,
188: revision_reason= p_bom_revision_rec.revision_reason,
189: last_update_date = SYSDATE,
190: last_update_login = Bom_Globals.Get_User_Id,
191: last_updated_by = Bom_Globals.Get_User_Id,
192: Attribute_Category = p_bom_revision_rec.Attribute_Category,
193: Attribute1 = p_bom_revision_rec.Attribute1,
194: Attribute2 = p_bom_revision_rec.Attribute2,
195: Attribute3 = p_bom_revision_rec.Attribute3,

Line 269: IF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE

265: IS
266: l_return_status VARCHAR2(1);
267: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
268: BEGIN
269: IF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
270: THEN
271: Insert_Row
272: ( p_bom_revision_rec => p_bom_revision_rec
273: , p_bom_rev_unexp_rec => p_bom_rev_unexp_rec

Line 278: ELSIF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

274: , x_return_status => l_return_Status
275: , x_mesg_token_tbl => l_mesg_token_tbl
276: );
277:
278: ELSIF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
279: THEN
280: Update_Row
281: ( p_bom_revision_rec => p_bom_revision_rec
282: , p_bom_rev_unexp_rec => p_bom_rev_unexp_rec

Line 357: x_return_status := Bom_Globals.G_RECORD_FOUND;

353: WHERE revision = p_revision
354: AND inventory_item_id = p_assembly_item_id
355: AND organization_id = p_organization_id;
356:
357: x_return_status := Bom_Globals.G_RECORD_FOUND;
358:
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

Line 361: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

357: x_return_status := Bom_Globals.G_RECORD_FOUND;
358:
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
362: WHEN OTHERS THEN
363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364: END Query_Row;
365: