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 175: last_update_login = Bom_Globals.Get_User_Id,

171: effectivity_date = NVL(p_bom_revision_rec.start_effective_date,sysdate),--bug:4242412 Replace NULL effectivity date by SYSDATE
172: revision_label= p_bom_revision_rec.revision_label,
173: revision_reason= p_bom_revision_rec.revision_reason,
174: last_update_date = SYSDATE,
175: last_update_login = Bom_Globals.Get_User_Id,
176: last_updated_by = Bom_Globals.Get_User_Id,
177: Attribute_Category = p_bom_revision_rec.Attribute_Category,
178: Attribute1 = p_bom_revision_rec.Attribute1,
179: Attribute2 = p_bom_revision_rec.Attribute2,

Line 176: last_updated_by = Bom_Globals.Get_User_Id,

172: revision_label= p_bom_revision_rec.revision_label,
173: revision_reason= p_bom_revision_rec.revision_reason,
174: last_update_date = SYSDATE,
175: last_update_login = Bom_Globals.Get_User_Id,
176: last_updated_by = Bom_Globals.Get_User_Id,
177: Attribute_Category = p_bom_revision_rec.Attribute_Category,
178: Attribute1 = p_bom_revision_rec.Attribute1,
179: Attribute2 = p_bom_revision_rec.Attribute2,
180: Attribute3 = p_bom_revision_rec.Attribute3,

Line 239: IF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE

235: IS
236: l_return_status VARCHAR2(1);
237: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
238: BEGIN
239: IF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
240: THEN
241: Insert_Row
242: ( p_bom_revision_rec => p_bom_revision_rec
243: , p_bom_rev_unexp_rec => p_bom_rev_unexp_rec

Line 248: ELSIF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

244: , x_return_status => l_return_Status
245: , x_mesg_token_tbl => l_mesg_token_tbl
246: );
247:
248: ELSIF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
249: THEN
250: Update_Row
251: ( p_bom_revision_rec => p_bom_revision_rec
252: , p_bom_rev_unexp_rec => p_bom_rev_unexp_rec

Line 327: x_return_status := Bom_Globals.G_RECORD_FOUND;

323: WHERE revision = p_revision
324: AND inventory_item_id = p_assembly_item_id
325: AND organization_id = p_organization_id;
326:
327: x_return_status := Bom_Globals.G_RECORD_FOUND;
328:
329: EXCEPTION
330: WHEN NO_DATA_FOUND THEN
331: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

Line 331: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

327: x_return_status := Bom_Globals.G_RECORD_FOUND;
328:
329: EXCEPTION
330: WHEN NO_DATA_FOUND THEN
331: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
332: WHEN OTHERS THEN
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: END Query_Row;
335: