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.BOMPCMBM dependencies on BOMPCMBM

Line 1: PACKAGE BODY BOMPCMBM AS

1: PACKAGE BODY BOMPCMBM AS
2: /* $Header: BOMCMBMB.pls 120.27.12010000.2 2008/11/07 06:05:53 jewen ship $ */
3:
4: /*==========================================================================+
5: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |

Line 32: G_PKG_NAME VARCHAR2(30) := 'BOMPCMBM';

28: +==========================================================================*/
29:
30: -- ERES change begins :
31:
32: G_PKG_NAME VARCHAR2(30) := 'BOMPCMBM';
33:
34: PROCEDURE Event_Acknowledgement( p_event_name IN VARCHAR2
35: , p_event_key IN VARCHAR2
36: , p_event_status IN VARCHAR2)

Line 1088: , decode(comp_rec.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(comp_rec.component_item_revision_id, l_dest_org_id))

1084: , comp_rec.from_object_revision_id
1085: , comp_rec.from_minor_revision_id
1086: , comp_rec.component_sequence_id
1087: , comp_rec.basis_type
1088: , decode(comp_rec.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(comp_rec.component_item_revision_id, l_dest_org_id))
1089: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom
1090: WHERE comp_rec.bill_sequence_id = p_src_bill_sequence_id
1091: AND bom.bill_sequence_id = comp_rec.bill_sequence_id
1092: AND comp_rec.COMPONENT_ITEM_ID = item.inventory_item_id

Line 1335: IF NOT BOMPCMBM.Check_Op_Seq_In_Ref_Boms(p_src_bill_seq_id => p_src_bill_seq_id

1331: RETURN;
1332:
1333: END IF;
1334:
1335: IF NOT BOMPCMBM.Check_Op_Seq_In_Ref_Boms(p_src_bill_seq_id => p_src_bill_seq_id
1336: , p_op_seq => l_operation_seq_num)
1337: THEN
1338: Error_Handler.Add_Error_Token
1339: ( p_Message_Name => 'BOM_COMMON_OP_SEQ_INVALID'

Line 1561: , decode(src_comp_details.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(src_comp_details.component_item_revision_id, bill_rec.organization_id))

1557: ,src_comp_details.from_object_revision_id
1558: ,src_comp_details.from_minor_revision_id
1559: , src_comp_details.common_component_sequence_id
1560: , src_comp_details.basis_type
1561: , decode(src_comp_details.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(src_comp_details.component_item_revision_id, bill_rec.organization_id))
1562: --,l_comp_revision_id
1563: --,l_comp_minor_revision_id
1564: );
1565: BOMPCMBM.Resolve_Old_Comp_Attrs(p_dest_bill_seq_id => src_comp_details.bill_sequence_id

Line 1565: BOMPCMBM.Resolve_Old_Comp_Attrs(p_dest_bill_seq_id => src_comp_details.bill_sequence_id

1561: , decode(src_comp_details.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(src_comp_details.component_item_revision_id, bill_rec.organization_id))
1562: --,l_comp_revision_id
1563: --,l_comp_minor_revision_id
1564: );
1565: BOMPCMBM.Resolve_Old_Comp_Attrs(p_dest_bill_seq_id => src_comp_details.bill_sequence_id
1566: , p_orig_old_comp_seq => src_comp_details.old_component_sequence_id
1567: , x_old_comp_seq_id => src_comp_details.old_component_sequence_id
1568: , x_wip_supply_type => src_comp_details.wip_supply_type
1569: , x_wip_supply_subinv => src_comp_details.supply_subinventory

Line 1587: IF BOMPCMBM.Check_Component_Overlap(p_dest_bill_sequence_id => src_comp_details.bill_sequence_id

1583: WHERE COMPONENT_SEQUENCE_ID = src_comp_details.component_Sequence_id;
1584: END IF;
1585:
1586: --Check if the insert caused overlapping components in any of the editable comm bills
1587: IF BOMPCMBM.Check_Component_Overlap(p_dest_bill_sequence_id => src_comp_details.bill_sequence_id
1588: , p_dest_comp_seq_id => src_comp_details.component_sequence_id
1589: , p_comp_item_id => src_comp_details.component_item_id
1590: , p_op_seq_num => src_comp_details.operation_seq_num
1591: , p_change_notice => src_comp_details.change_notice

Line 1923: , COMPONENT_ITEM_REVISION_ID = decode(src_comp.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(src_comp.component_item_revision_id, dest_comp.pk2_value))

1919: , Vendor_Id = src_comp.Vendor_Id --- Deepu
1920: -- , Purchasing_Category_id = src_comp.purchasing_category_id --- Deepu
1921: , Unit_Price = src_comp.Unit_Price --- Deepu
1922: , Basis_type = src_comp.Basis_type
1923: , COMPONENT_ITEM_REVISION_ID = decode(src_comp.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(src_comp.component_item_revision_id, dest_comp.pk2_value))
1924: WHERE COMPONENT_SEQUENCE_ID = dest_comp.component_sequence_id
1925: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID
1926: ;
1927: --Check if the insert caused overlapping components in any of the editable comm bills

Line 1928: IF BOMPCMBM.Check_Component_Overlap(p_dest_bill_sequence_id => dest_comp.bill_sequence_id

1924: WHERE COMPONENT_SEQUENCE_ID = dest_comp.component_sequence_id
1925: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID
1926: ;
1927: --Check if the insert caused overlapping components in any of the editable comm bills
1928: IF BOMPCMBM.Check_Component_Overlap(p_dest_bill_sequence_id => dest_comp.bill_sequence_id
1929: , p_dest_comp_seq_id => dest_comp.component_sequence_id
1930: , p_comp_item_id => dest_comp.component_item_id
1931: , p_op_seq_num => dest_comp.operation_seq_num
1932: , p_change_notice => dest_comp.change_notice

Line 4459: BOMPCMBM.get_rev_id_for_local_org(l_component_rec.component_item_revision_id, p_organization_id))

4455: , l_component_rec.common_component_sequence_id
4456: , l_component_rec.basis_type
4457: , decode(l_component_rec.component_item_revision_id,
4458: NULL, NULL,
4459: BOMPCMBM.get_rev_id_for_local_org(l_component_rec.component_item_revision_id, p_organization_id))
4460: --, l_comp_revision_id
4461: --, l_comp_minor_revision_id
4462: );
4463: ELSE

Line 4565: END bompcmbm ;

4561: END LOOP;
4562: RETURN FND_API.G_RET_STS_SUCCESS;
4563: END;
4564:
4565: END bompcmbm ;