APPS.BOM_RTG_OI_UTIL dependencies on BOM_OP_NETWORKS_INTERFACE

Line 1561: BOM_OP_NETWORKS_INTERFACE

1557: in the interface table
1558: REQUIRES
1559:
1560: MODIFIES
1561: BOM_OP_NETWORKS_INTERFACE
1562: MTL_INTERFACE_ERRORS
1563: RETURNS
1564: 0 if successful
1565: SQLCODE if unsuccessful

Line 1592: UPDATE BOM_OP_NETWORKS_INTERFACE BONI

1588: BEGIN
1589: stmt_num := 1;
1590: /* Resolve the from_op_seq_id and to_op_seq_id for all the records */
1591:
1592: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1593: SET(routing_sequence_id, from_op_seq_number, from_start_effective_date)
1594: = (SELECT routing_sequence_id, operation_seq_num, effectivity_date
1595: FROM BOM_OPERATION_SEQUENCES BOS1
1596: WHERE BOS1.operation_sequence_id = BONI.from_Op_seq_id)

Line 1609: UPDATE BOM_OP_NETWORKS_INTERFACE BONI

1605: AND exists (SELECT 'x'
1606: FROM BOM_OPERATION_SEQUENCES BOS2
1607: WHERE BOS2.OPERATION_SEQUENCE_ID = BONI.FROM_OP_SEQ_ID );
1608:
1609: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1610: SET(routing_sequence_id, to_op_seq_number, to_start_effective_date)
1611: = (SELECT routing_sequence_id, operation_seq_num, effectivity_date
1612: FROM BOM_OPERATION_SEQUENCES BOS1
1613: WHERE BOS1.operation_sequence_id = BONI.to_Op_seq_id)

Line 1630: UPDATE BOM_OP_NETWORKS_INTERFACE BONI

1626:
1627: stmt_num := 2;
1628: /* Resolve the routing sequence ids for updates and deletes */
1629:
1630: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1631: SET(assembly_item_id, organization_id, alternate_routing_designator)
1632: = (SELECT assembly_item_id, organization_id , alternate_routing_designator
1633: FROM BOM_OPERATIONAL_ROUTINGS BOR1
1634: WHERE BOR1.routing_sequence_id = BONI.routing_sequence_id)

Line 1652: UPDATE BOM_OP_NETWORKS_INTERFACE BONI

1648: stmt_num := 3;
1649: /* Update Organization Code using Organization_id
1650: this also needed if orgnaization_id is given and code is not given*/
1651:
1652: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1653: SET organization_code = (SELECT organization_code
1654: FROM MTL_PARAMETERS mp1
1655: WHERE mp1.organization_id = BONI.organization_id)
1656: WHERE process_flag = 1

Line 1674: UPDATE BOM_OP_NETWORKS_INTERFACE BONI

1670: stmt_num := 4;
1671: /* Update Organization_ids if organization_code is given org id is null.
1672: Orgnaization_id information is needed in the next steps */
1673:
1674: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1675: SET organization_id = (SELECT organization_id
1676: FROM MTL_PARAMETERS mp1
1677: WHERE mp1.organization_code = BONI.organization_code)
1678: WHERE process_flag = 1

Line 1693: UPDATE BOM_OP_NETWORKS_INTERFACE BONI

1689:
1690: stmt_num := 5;
1691: /* Update Assembly Item name */
1692:
1693: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1694: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1695: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1696: WHERE mvl1.inventory_item_id = BONI.assembly_item_id
1697: and mvl1.organization_id = BONI.organization_id)

Line 1715: UPDATE BOM_OP_NETWORKS_INTERFACE BONI

1711:
1712:
1713: stmt_num := 6;
1714: /* Assign transaction ids */
1715: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1716: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1717: WHERE transaction_id is null
1718: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1719: AND process_flag = 1

Line 1729: UPDATE BOM_OP_NETWORKS_INTERFACE BONI

1725: AND (all_org = 1
1726: OR
1727: (all_org = 2 AND organization_id = org_id));
1728:
1729: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1730: SET transaction_type = upper(transaction_type)
1731: WHERE upper(transaction_type) in (G_Create, G_Update, G_Delete)
1732: AND process_flag = 1
1733: AND

Line 1778: 'BOM_OP_NETWORKS_INTERFACE',

1774: BONI.transaction_id,
1775: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1776: Null,
1777: null,
1778: 'BOM_OP_NETWORKS_INTERFACE',
1779: decode ( BONI.Organization_code, null, msg_name1,msg_name2),
1780: decode ( BONI.Organization_code, null, msg_text1,msg_text2),
1781: NVL(LAST_UPDATE_DATE, SYSDATE),
1782: NVL(LAST_UPDATED_BY, user_id),

Line 1790: from BOM_OP_NETWORKS_INTERFACE BONI

1786: req_id,
1787: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1788: NVL(PROGRAM_ID, prog_id),
1789: NVL(PROGRAM_UPDATE_DATE, sysdate)
1790: from BOM_OP_NETWORKS_INTERFACE BONI
1791: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1792: and transaction_id is not null
1793: and process_flag =1
1794: and

Line 1801: Update BOM_OP_NETWORKS_INTERFACE

1797: OR ( p_batch_id = batch_id )
1798: )
1799: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id)) ;
1800:
1801: Update BOM_OP_NETWORKS_INTERFACE
1802: set process_flag = 3
1803: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1804: and transaction_id is not null
1805: and process_flag =1