DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_GLOBALS

Line 392: IF (Bom_globals.Get_Caller_Type <> BOM_GLOBALS.G_MASS_CHANGE) THEN -- added for bug 3534567

388: l_curr_rev_id NUMBER;
389:
390:
391: BEGIN
392: IF (Bom_globals.Get_Caller_Type <> BOM_GLOBALS.G_MASS_CHANGE) THEN -- added for bug 3534567
393: insert into MTL_ITEM_REVISIONS_B (
394: inventory_item_id,
395: organization_id,
396: revision,

Line 617: last_updated_by = BOM_Globals.Get_User_Id, --Bug 9240045 fix

613: update BOM_INVENTORY_COMPONENTS
614: set effectivity_date = x_scheduled_date,
615: from_end_item_unit_number = x_from_end_item_unit_number,
616: last_update_date = sysdate, --Bug 9240045 fix
617: last_updated_by = BOM_Globals.Get_User_Id, --Bug 9240045 fix
618: last_update_login = BOM_Globals.Get_User_Id --Bug 9240045 fix
619: where change_notice = x_change_notice
620: and bill_sequence_id = x_bill_sequence_id
621: and revised_item_sequence_id = x_revised_item_sequence_id

Line 618: last_update_login = BOM_Globals.Get_User_Id --Bug 9240045 fix

614: set effectivity_date = x_scheduled_date,
615: from_end_item_unit_number = x_from_end_item_unit_number,
616: last_update_date = sysdate, --Bug 9240045 fix
617: last_updated_by = BOM_Globals.Get_User_Id, --Bug 9240045 fix
618: last_update_login = BOM_Globals.Get_User_Id --Bug 9240045 fix
619: where change_notice = x_change_notice
620: and bill_sequence_id = x_bill_sequence_id
621: and revised_item_sequence_id = x_revised_item_sequence_id
622: AND (common_component_sequence_id IS NULL

Line 644: last_updated_by = BOM_Globals.Get_User_Id,

640: update BOM_INVENTORY_COMPONENTS
641: set effectivity_date = x_scheduled_date,
642: from_end_item_unit_number = x_from_end_item_unit_number,
643: last_update_date = sysdate,
644: last_updated_by = BOM_Globals.Get_User_Id,
645: last_update_login = BOM_Globals.Get_User_Id
646: where change_notice = x_change_notice
647: and bill_sequence_id = x_bill_sequence_id
648: and revised_item_sequence_id = x_revised_item_sequence_id

Line 645: last_update_login = BOM_Globals.Get_User_Id

641: set effectivity_date = x_scheduled_date,
642: from_end_item_unit_number = x_from_end_item_unit_number,
643: last_update_date = sysdate,
644: last_updated_by = BOM_Globals.Get_User_Id,
645: last_update_login = BOM_Globals.Get_User_Id
646: where change_notice = x_change_notice
647: and bill_sequence_id = x_bill_sequence_id
648: and revised_item_sequence_id = x_revised_item_sequence_id
649: AND common_component_sequence_id is not NULL