APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_COMPONENT_OPS_INTERFACE

Line 1696: BOM_COMPONENT_OPS_INTERFACE

1692: in the interface table
1693: REQUIRES
1694:
1695: MODIFIES
1696: BOM_COMPONENT_OPS_INTERFACE
1697: MTL_INTERFACE_ERRORS
1698: RETURNS
1699: 0 if successful
1700: SQLCODE if unsuccessful

Line 1729: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1725:
1726: stmt_num := 1;
1727: /* Resolve the Component_sequence_id for all the records */
1728:
1729: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1730: SET(bill_sequence_id, component_item_id, effectivity_date,
1731: operation_seq_num, from_end_item_unit_number)
1732: = (SELECT bill_sequence_id, component_item_id,
1733: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 1752: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1748:
1749: stmt_num := 2;
1750: /* Resolve the Bill sequence ids for updates and deletes */
1751:
1752: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1753: SET(assembly_item_id, organization_id, alternate_bom_designator)
1754: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1755: FROM bom_structures_b BBM1
1756: WHERE BBM1.bill_sequence_id = BCOI.bill_sequence_id)

Line 1774: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1770: stmt_num := 3;
1771: /* Update Organization Code using Organization_id
1772: this also needed if orgnaization_id is given and code is not given*/
1773:
1774: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1775: SET organization_code = (SELECT organization_code
1776: FROM MTL_PARAMETERS mp1
1777: WHERE mp1.organization_id = BCOI.organization_id)
1778: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1796: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1792: stmt_num := 4;
1793: /* Update Organization_ids if organization_code is given org id is null.
1794: Orgnaization_id information is needed in the next steps */
1795:
1796: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1797: SET organization_id = (SELECT organization_id
1798: FROM MTL_PARAMETERS mp1
1799: WHERE mp1.organization_code = BCOI.organization_code)
1800: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1815: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1811:
1812: stmt_num := 5;
1813: /* Update Assembly Item name */
1814:
1815: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1816: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1817: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1818: WHERE mvl1.inventory_item_id = BCOI.assembly_item_id
1819: and mvl1.organization_id = BCOI.organization_id)

Line 1838: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1834:
1835: stmt_num := 6;
1836: /* Update Component Item name */
1837:
1838: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1839: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1840: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1841: WHERE mvl1.inventory_item_id = BCOI.component_item_id
1842: and mvl1.organization_id = BCOI.organization_id)

Line 1861: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI

1857:
1858: stmt_num := 8;
1859: /* Assign transaction ids */
1860:
1861: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1862: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1863: transaction_type = upper(transaction_type)
1864: WHERE transaction_id is null
1865: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 1913: 'BOM_COMPONENT_OPS_INTERFACE',

1909: BCOI.transaction_id,
1910: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1911: Null,
1912: null,
1913: 'BOM_COMPONENT_OPS_INTERFACE',
1914: decode ( BCOI.Organization_code, null, msg_name1,msg_name2),
1915: decode ( BCOI.Organization_code, null, msg_text1,msg_text2),
1916: NVL(LAST_UPDATE_DATE, SYSDATE),
1917: NVL(LAST_UPDATED_BY, user_id),

Line 1925: from BOM_COMPONENT_OPS_INTERFACE BCOI

1921: req_id,
1922: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1923: NVL(PROGRAM_ID, prog_id),
1924: NVL(PROGRAM_UPDATE_DATE, sysdate)
1925: from BOM_COMPONENT_OPS_INTERFACE BCOI
1926: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1927: and transaction_id is not null
1928: and process_flag =1
1929: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id))

Line 1936: Update BOM_COMPONENT_OPS_INTERFACE

1932: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1933: OR ( p_batch_id = BCOI.batch_id )
1934: );
1935:
1936: Update BOM_COMPONENT_OPS_INTERFACE
1937: set process_flag = 3
1938: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1939: and transaction_id is not null
1940: and process_flag =1