APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 269: FROM BOM_INVENTORY_COMPS_INTERFACE BICI

265: UPDATE EGO_BULKLOAD_INTF EBI
266: SET EBI.PROCESS_STATUS =
267: (
268: SELECT BICI.PROCESS_FLAG
269: FROM BOM_INVENTORY_COMPS_INTERFACE BICI
270: WHERE BICI.TRANSACTION_ID = EBI.TRANSACTION_ID
271: )
272: WHERE EXISTS
273: (

Line 275: FROM BOM_INVENTORY_COMPS_INTERFACE BICI

271: )
272: WHERE EXISTS
273: (
274: SELECT 'X'
275: FROM BOM_INVENTORY_COMPS_INTERFACE BICI
276: WHERE BICI.TRANSACTION_ID = EBI.TRANSACTION_ID
277: )
278: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
279:

Line 694: bcc.BOM_INTF_TABLE_NAME = 'BOM_INVENTORY_COMPS_INTERFACE'

690: bcc.Attribute_Code = erf.Attribute_Code
691: AND
692: bcc.OBJECT_TYPE = 'BOM_COMPONENTS'
693: AND
694: bcc.BOM_INTF_TABLE_NAME = 'BOM_INVENTORY_COMPS_INTERFACE'
695: AND
696: ( bcc.Parent_Entity IS NULL
697: OR BCC.Attribute_Code = 'ITEM_NUMBER'
698: OR BCC.Attribute_Code = 'PARENT_NAME')

Line 1294: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';

1290: /* Header complete */
1291: --poplulating to see see errors
1292: -- Process Components for UPDATE
1293: l_dyn_sql_insert := '';
1294: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';
1295: l_dyn_sql_insert := l_dyn_sql_insert || ' COMP_SOURCE_SYSTEM_REFERENCE, COMP_SOURCE_SYSTEM_REFER_DESC,';
1296: l_dyn_sql_insert := l_dyn_sql_insert || ' PARENT_SOURCE_SYSTEM_REFERENCE, REQUEST_ID, Transaction_Type,';
1297: l_dyn_sql_insert := l_dyn_sql_insert || ' Transaction_Id, Process_Flag, ';
1298: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, PARENT_REVISION_CODE, ';

Line 1387: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';

1383: Dbms_Sql.Close_Cursor(l_cursor_select);
1384: -- End of Creating Structure Header record if that is not available.
1385:
1386: l_dyn_sql_insert := '';
1387: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';
1388: l_dyn_sql_insert := l_dyn_sql_insert || ' COMP_SOURCE_SYSTEM_REFERENCE, COMP_SOURCE_SYSTEM_REFER_DESC,';
1389: l_dyn_sql_insert := l_dyn_sql_insert || ' PARENT_SOURCE_SYSTEM_REFERENCE, REQUEST_ID, Transaction_Type,';
1390: l_dyn_sql_insert := l_dyn_sql_insert || ' Transaction_Id, Process_Flag, ';
1391: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, PARENT_REVISION_CODE, ';

Line 1456: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';

1452: END IF;
1453:
1454: -- Start of process components for Delete
1455: l_dyn_sql_insert := '';
1456: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';
1457: l_dyn_sql_insert := l_dyn_sql_insert || ' COMP_SOURCE_SYSTEM_REFERENCE, COMP_SOURCE_SYSTEM_REFER_DESC,';
1458: l_dyn_sql_insert := l_dyn_sql_insert || ' PARENT_SOURCE_SYSTEM_REFERENCE, REQUEST_ID, Transaction_Type,';
1459: l_dyn_sql_insert := l_dyn_sql_insert || ' Transaction_Id, Process_Flag, ';
1460: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, ';

Line 1654: DELETE BOM_INVENTORY_COMPS_INTERFACE

1650:
1651: -- Delete the duplicate component rows, which are populated bcos of component user attributes (multi row)
1652: -- This will be done by checking the value of EffectivityDate, OperationSequence, Item Sequence.
1653: IF l_eff_date_col_name IS NOT NULL AND l_oper_seq_col_name IS NOT NULL AND l_item_seq_col_name IS NOT NULL THEN
1654: DELETE BOM_INVENTORY_COMPS_INTERFACE
1655: WHERE PROCESS_FLAG = 1
1656: AND batch_id = p_batch_id
1657: AND (OPERATION_SEQ_NUM IS NOT NULL OR NEW_OPERATION_SEQ_NUM IS NOT NULL)
1658: AND (EFFECTIVITY_DATE IS NOT NULL OR NEW_EFFECTIVITY_DATE IS NOT NULL)

Line 1754: FROM BOM_INVENTORY_COMPS_INTERFACE BIC1

1750: = (SELECT Decode(effectivity_date,NULL,new_effectivity_date,effectivity_date),
1751: Decode(operation_seq_num,NULL,new_operation_seq_num,operation_seq_num),
1752: Decode(from_end_item_unit_number,NULL,new_from_end_item_unit_number,from_end_item_unit_number),
1753: component_sequence_id, parent_revision_code
1754: FROM BOM_INVENTORY_COMPS_INTERFACE BIC1
1755: WHERE BIC1.TRANSACTION_ID = BRDI.TRANSACTION_ID )
1756: WHERE
1757: BRDI.batch_id = p_batch_id
1758: AND EXISTS( Select 'X' FROM BOM_INVENTORY_COMPS_INTERFACE BIC12

Line 1758: AND EXISTS( Select 'X' FROM BOM_INVENTORY_COMPS_INTERFACE BIC12

1754: FROM BOM_INVENTORY_COMPS_INTERFACE BIC1
1755: WHERE BIC1.TRANSACTION_ID = BRDI.TRANSACTION_ID )
1756: WHERE
1757: BRDI.batch_id = p_batch_id
1758: AND EXISTS( Select 'X' FROM BOM_INVENTORY_COMPS_INTERFACE BIC12
1759: WHERE BIC12.TRANSACTION_ID = BRDI.TRANSACTION_ID);
1760: -- Process Reference Designators Complete
1761:
1762:

Line 1860: FROM BOM_INVENTORY_COMPS_INTERFACE

1856:
1857: l_Component_Count := 0;
1858:
1859: SELECT COUNT(COMPONENT_ITEM_ID) INTO l_Component_Count
1860: FROM BOM_INVENTORY_COMPS_INTERFACE
1861: WHERE process_flag = 1
1862: AND UPPER(transaction_type) = G_TXN_UPDATE
1863: AND Request_Id = p_request_id
1864: AND (p_batch_id IS NULL OR batch_id = p_batch_id)

Line 1875: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

1871: BOMPCMBM.Dereference_Header( p_bill_sequence_id => l_Bill_Sequence_id);
1872: -- Dereference the components and others
1873: BOMPCMBM.Replicate_Components( p_src_bill_sequence_id => l_Common_Bill_Sequence_Id, p_dest_bill_sequence_id => l_Bill_Sequence_id);
1874: -- Update the components with new component sequence id
1875: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
1876: SET COMPONENT_SEQUENCE_ID
1877: = (SELECT COMPONENT_SEQUENCE_ID
1878: FROM BOM_INVENTORY_COMPONENTS BIC, bom_structures_b bsb
1879: WHERE BIC.bill_sequence_id = bsb.bill_Sequence_id