APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 281: FROM BOM_INVENTORY_COMPS_INTERFACE BICI

277: UPDATE EGO_BULKLOAD_INTF EBI
278: SET EBI.PROCESS_STATUS =
279: (
280: SELECT BICI.PROCESS_FLAG
281: FROM BOM_INVENTORY_COMPS_INTERFACE BICI
282: WHERE BICI.TRANSACTION_ID = EBI.TRANSACTION_ID
283: )
284: WHERE EXISTS
285: (

Line 287: FROM BOM_INVENTORY_COMPS_INTERFACE BICI

283: )
284: WHERE EXISTS
285: (
286: SELECT 'X'
287: FROM BOM_INVENTORY_COMPS_INTERFACE BICI
288: WHERE BICI.TRANSACTION_ID = EBI.TRANSACTION_ID
289: )
290: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
291:

Line 708: bcc.BOM_INTF_TABLE_NAME = 'BOM_INVENTORY_COMPS_INTERFACE'

704: bcc.Attribute_Code = erf.Attribute_Code
705: AND
706: bcc.OBJECT_TYPE = 'BOM_COMPONENTS'
707: AND
708: bcc.BOM_INTF_TABLE_NAME = 'BOM_INVENTORY_COMPS_INTERFACE'
709: AND
710: ( bcc.Parent_Entity IS NULL
711: OR BCC.Attribute_Code = 'ITEM_NUMBER'
712: OR BCC.Attribute_Code = 'PARENT_NAME')

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

1329: /* Header complete */
1330: --poplulating to see see errors
1331: -- Process Components for UPDATE
1332: l_dyn_sql_insert := '';
1333: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';
1334: l_dyn_sql_insert := l_dyn_sql_insert || ' COMP_SOURCE_SYSTEM_REFERENCE, COMP_SOURCE_SYSTEM_REFER_DESC,';
1335: l_dyn_sql_insert := l_dyn_sql_insert || ' PARENT_SOURCE_SYSTEM_REFERENCE, REQUEST_ID, Transaction_Type,';
1336: l_dyn_sql_insert := l_dyn_sql_insert || ' Transaction_Id, Process_Flag, ';
1337: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, PARENT_REVISION_CODE, ';

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

1432: Dbms_Sql.Close_Cursor(l_cursor_select);
1433: -- End of Creating Structure Header record if that is not available.
1434:
1435: l_dyn_sql_insert := '';
1436: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';
1437: l_dyn_sql_insert := l_dyn_sql_insert || ' COMP_SOURCE_SYSTEM_REFERENCE, COMP_SOURCE_SYSTEM_REFER_DESC,';
1438: l_dyn_sql_insert := l_dyn_sql_insert || ' PARENT_SOURCE_SYSTEM_REFERENCE, REQUEST_ID, Transaction_Type,';
1439: l_dyn_sql_insert := l_dyn_sql_insert || ' Transaction_Id, Process_Flag, ';
1440: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, PARENT_REVISION_CODE, ';

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

1509: END IF;
1510:
1511: -- Start of process components for Delete
1512: l_dyn_sql_insert := '';
1513: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( BATCH_ID, ';
1514: l_dyn_sql_insert := l_dyn_sql_insert || ' COMP_SOURCE_SYSTEM_REFERENCE, COMP_SOURCE_SYSTEM_REFER_DESC,';
1515: l_dyn_sql_insert := l_dyn_sql_insert || ' PARENT_SOURCE_SYSTEM_REFERENCE, REQUEST_ID, Transaction_Type,';
1516: l_dyn_sql_insert := l_dyn_sql_insert || ' Transaction_Id, Process_Flag, ';
1517: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, ';

Line 1711: DELETE BOM_INVENTORY_COMPS_INTERFACE

1707:
1708: -- Delete the duplicate component rows, which are populated bcos of component user attributes (multi row)
1709: -- This will be done by checking the value of EffectivityDate, OperationSequence, Item Sequence.
1710: 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
1711: DELETE BOM_INVENTORY_COMPS_INTERFACE
1712: WHERE PROCESS_FLAG = 1
1713: AND batch_id = p_batch_id
1714: AND (OPERATION_SEQ_NUM IS NOT NULL OR NEW_OPERATION_SEQ_NUM IS NOT NULL)
1715: AND (EFFECTIVITY_DATE IS NOT NULL OR NEW_EFFECTIVITY_DATE IS NOT NULL)

Line 1811: FROM BOM_INVENTORY_COMPS_INTERFACE BIC1

1807: = (SELECT Decode(effectivity_date,NULL,new_effectivity_date,effectivity_date),
1808: Decode(operation_seq_num,NULL,new_operation_seq_num,operation_seq_num),
1809: Decode(from_end_item_unit_number,NULL,new_from_end_item_unit_number,from_end_item_unit_number),
1810: component_sequence_id, parent_revision_code
1811: FROM BOM_INVENTORY_COMPS_INTERFACE BIC1
1812: WHERE BIC1.TRANSACTION_ID = BRDI.TRANSACTION_ID )
1813: WHERE
1814: BRDI.batch_id = p_batch_id
1815: AND EXISTS( Select 'X' FROM BOM_INVENTORY_COMPS_INTERFACE BIC12

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

1811: FROM BOM_INVENTORY_COMPS_INTERFACE BIC1
1812: WHERE BIC1.TRANSACTION_ID = BRDI.TRANSACTION_ID )
1813: WHERE
1814: BRDI.batch_id = p_batch_id
1815: AND EXISTS( Select 'X' FROM BOM_INVENTORY_COMPS_INTERFACE BIC12
1816: WHERE BIC12.TRANSACTION_ID = BRDI.TRANSACTION_ID);
1817: -- Process Reference Designators Complete
1818:
1819:

Line 1950: FROM BOM_INVENTORY_COMPS_INTERFACE

1946:
1947: l_Component_Count := 0;
1948:
1949: SELECT COUNT(COMPONENT_ITEM_ID) INTO l_Component_Count
1950: FROM BOM_INVENTORY_COMPS_INTERFACE
1951: WHERE process_flag = 1
1952: AND UPPER(transaction_type) = G_TXN_UPDATE
1953: AND Request_Id = p_request_id
1954: AND (p_batch_id IS NULL OR batch_id = p_batch_id)

Line 1965: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

1961: BOMPCMBM.Dereference_Header( p_bill_sequence_id => l_Bill_Sequence_id);
1962: -- Dereference the components and others
1963: BOMPCMBM.Replicate_Components( p_src_bill_sequence_id => l_Common_Bill_Sequence_Id, p_dest_bill_sequence_id => l_Bill_Sequence_id);
1964: -- Update the components with new component sequence id
1965: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
1966: SET COMPONENT_SEQUENCE_ID
1967: = (SELECT COMPONENT_SEQUENCE_ID
1968: FROM BOM_INVENTORY_COMPONENTS BIC, bom_structures_b bsb
1969: WHERE BIC.bill_sequence_id = bsb.bill_Sequence_id