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.38 2011/05/11 11:58:05 rambkond 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 1293: , 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))

1289: , comp_rec.from_object_revision_id
1290: , comp_rec.from_minor_revision_id
1291: , comp_rec.component_sequence_id
1292: , comp_rec.basis_type
1293: , 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))
1294: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom
1295: WHERE comp_rec.bill_sequence_id = p_src_bill_sequence_id
1296: AND bom.bill_sequence_id = comp_rec.bill_sequence_id
1297: AND comp_rec.COMPONENT_ITEM_ID = item.inventory_item_id

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

1536: RETURN;
1537:
1538: END IF;
1539:
1540: IF NOT BOMPCMBM.Check_Op_Seq_In_Ref_Boms(p_src_bill_seq_id => p_src_bill_seq_id
1541: , p_op_seq => l_operation_seq_num)
1542: THEN
1543: Error_Handler.Add_Error_Token
1544: ( p_Message_Name => 'BOM_COMMON_OP_SEQ_INVALID'

Line 1766: , 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))

1762: ,src_comp_details.from_object_revision_id
1763: ,src_comp_details.from_minor_revision_id
1764: , src_comp_details.common_component_sequence_id
1765: , src_comp_details.basis_type
1766: , 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))
1767: --,l_comp_revision_id
1768: --,l_comp_minor_revision_id
1769: );
1770: BOMPCMBM.Resolve_Old_Comp_Attrs(p_dest_bill_seq_id => src_comp_details.bill_sequence_id

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

1766: , 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))
1767: --,l_comp_revision_id
1768: --,l_comp_minor_revision_id
1769: );
1770: BOMPCMBM.Resolve_Old_Comp_Attrs(p_dest_bill_seq_id => src_comp_details.bill_sequence_id
1771: , p_orig_old_comp_seq => src_comp_details.old_component_sequence_id
1772: , x_old_comp_seq_id => src_comp_details.old_component_sequence_id
1773: , x_wip_supply_type => src_comp_details.wip_supply_type
1774: , x_wip_supply_subinv => src_comp_details.supply_subinventory

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

1788: WHERE COMPONENT_SEQUENCE_ID = src_comp_details.component_Sequence_id;
1789: END IF;
1790:
1791: --Check if the insert caused overlapping components in any of the editable comm bills
1792: IF BOMPCMBM.Check_Component_Overlap(p_dest_bill_sequence_id => src_comp_details.bill_sequence_id
1793: , p_dest_comp_seq_id => src_comp_details.component_sequence_id
1794: , p_comp_item_id => src_comp_details.component_item_id
1795: , p_op_seq_num => src_comp_details.operation_seq_num
1796: , p_change_notice => src_comp_details.change_notice

Line 2215: , 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))

2211: , Vendor_Id = src_comp.Vendor_Id --- Deepu
2212: -- , Purchasing_Category_id = src_comp.purchasing_category_id --- Deepu
2213: , Unit_Price = src_comp.Unit_Price --- Deepu
2214: , Basis_type = src_comp.Basis_type
2215: , 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))
2216: WHERE COMPONENT_SEQUENCE_ID = dest_comp.component_sequence_id
2217: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID
2218: ;
2219: --Check if the insert caused overlapping components in any of the editable comm bills

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

2216: WHERE COMPONENT_SEQUENCE_ID = dest_comp.component_sequence_id
2217: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID
2218: ;
2219: --Check if the insert caused overlapping components in any of the editable comm bills
2220: IF BOMPCMBM.Check_Component_Overlap(p_dest_bill_sequence_id => dest_comp.bill_sequence_id
2221: , p_dest_comp_seq_id => dest_comp.component_sequence_id
2222: , p_comp_item_id => dest_comp.component_item_id
2223: , p_op_seq_num => dest_comp.operation_seq_num
2224: , p_change_notice => dest_comp.change_notice

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

4803: , l_component_rec.common_component_sequence_id
4804: , l_component_rec.basis_type
4805: , decode(l_component_rec.component_item_revision_id,
4806: NULL, NULL,
4807: BOMPCMBM.get_rev_id_for_local_org(l_component_rec.component_item_revision_id, p_organization_id))
4808: --, l_comp_revision_id
4809: --, l_comp_minor_revision_id
4810: );
4811: ELSE

Line 4913: END bompcmbm ;

4909: END LOOP;
4910: RETURN FND_API.G_RET_STS_SUCCESS;
4911: END;
4912:
4913: END bompcmbm ;