APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_COMPONENT_OPS_INTERFACE

Line 1658: BOM_COMPONENT_OPS_INTERFACE

1654: in the interface table
1655: REQUIRES
1656:
1657: MODIFIES
1658: BOM_COMPONENT_OPS_INTERFACE
1659: MTL_INTERFACE_ERRORS
1660: RETURNS
1661: 0 if successful
1662: SQLCODE if unsuccessful

Line 1691: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1687:
1688: stmt_num := 1;
1689: /* Resolve the Component_sequence_id for all the records */
1690:
1691: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1692: SET(bill_sequence_id, component_item_id, effectivity_date,
1693: operation_seq_num, from_end_item_unit_number)
1694: = (SELECT bill_sequence_id, component_item_id,
1695: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 1714: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1710:
1711: stmt_num := 2;
1712: /* Resolve the Bill sequence ids for updates and deletes */
1713:
1714: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1715: SET(assembly_item_id, organization_id, alternate_bom_designator)
1716: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1717: FROM bom_structures_b BBM1
1718: WHERE BBM1.bill_sequence_id = BCOI.bill_sequence_id)

Line 1736: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1732: stmt_num := 3;
1733: /* Update Organization Code using Organization_id
1734: this also needed if orgnaization_id is given and code is not given*/
1735:
1736: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1737: SET organization_code = (SELECT organization_code
1738: FROM MTL_PARAMETERS mp1
1739: WHERE mp1.organization_id = BCOI.organization_id)
1740: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1758: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1754: stmt_num := 4;
1755: /* Update Organization_ids if organization_code is given org id is null.
1756: Orgnaization_id information is needed in the next steps */
1757:
1758: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1759: SET organization_id = (SELECT organization_id
1760: FROM MTL_PARAMETERS mp1
1761: WHERE mp1.organization_code = BCOI.organization_code)
1762: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1777: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1773:
1774: stmt_num := 5;
1775: /* Update Assembly Item name */
1776:
1777: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1778: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1779: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1780: WHERE mvl1.inventory_item_id = BCOI.assembly_item_id
1781: and mvl1.organization_id = BCOI.organization_id)

Line 1800: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1796:
1797: stmt_num := 6;
1798: /* Update Component Item name */
1799:
1800: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1801: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1802: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1803: WHERE mvl1.inventory_item_id = BCOI.component_item_id
1804: and mvl1.organization_id = BCOI.organization_id)

Line 1823: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1819:
1820: stmt_num := 8;
1821: /* Assign transaction ids */
1822:
1823: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1824: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1825: transaction_type = upper(transaction_type)
1826: WHERE transaction_id is null
1827: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 1875: 'BOM_COMPONENT_OPS_INTERFACE',

1871: BCOI.transaction_id,
1872: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1873: Null,
1874: null,
1875: 'BOM_COMPONENT_OPS_INTERFACE',
1876: decode ( BCOI.Organization_code, null, msg_name1,msg_name2),
1877: decode ( BCOI.Organization_code, null, msg_text1,msg_text2),
1878: NVL(LAST_UPDATE_DATE, SYSDATE),
1879: NVL(LAST_UPDATED_BY, user_id),

Line 1887: from BOM_COMPONENT_OPS_INTERFACE BCOI

1883: req_id,
1884: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1885: NVL(PROGRAM_ID, prog_id),
1886: NVL(PROGRAM_UPDATE_DATE, sysdate)
1887: from BOM_COMPONENT_OPS_INTERFACE BCOI
1888: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1889: and transaction_id is not null
1890: and process_flag =1
1891: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id))

Line 1898: Update BOM_COMPONENT_OPS_INTERFACE

1894: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1895: OR ( p_batch_id = BCOI.batch_id )
1896: );
1897:
1898: Update BOM_COMPONENT_OPS_INTERFACE
1899: set process_flag = 3
1900: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1901: and transaction_id is not null
1902: and process_flag =1