APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_CMP_USR_ATTR_INTERFACE

Line 2548: -- bom_cmp_usr_attr_interface ?Bom JCP required batch_id so inserting that

2544: END IF;
2545:
2546: END IF; --end: IF (l_usr_attr_data_tbl(i).ATTR_DATATYPE_CODE = 'C') THEN
2547: --dikrishn Dont we need the structure type id to be inserted into
2548: -- bom_cmp_usr_attr_interface ?Bom JCP required batch_id so inserting that
2549: -- also
2550: SELECT structure_type_id
2551: INTO l_str_type_id
2552: FROM ego_import_option_sets

Line 2574: FROM BOM_CMP_USR_ATTR_INTERFACE

2570: --DPHILIP: we will need to populate the process_status to 1 or 0 here.. we cant let the user attrs pl/sql handle this
2571:
2572: -- Fixed bug 9918265
2573: SELECT COUNT(*) INTO l_comp_usr_attr_flag
2574: FROM BOM_CMP_USR_ATTR_INTERFACE
2575: WHERE DATA_SET_ID = l_usr_attr_data_tbl(i).DATA_SET_ID
2576: AND ROW_IDENTIFIER = l_usr_attr_data_tbl(i).ROW_IDENTIFIER
2577: AND ATTR_GROUP_INT_NAME = l_usr_attr_data_tbl(i).ATTR_GROUP_NAME
2578: AND ATTR_INT_NAME = l_usr_attr_data_tbl(i).ATTR_NAME

Line 2588: INSERT INTO BOM_CMP_USR_ATTR_INTERFACE

2584:
2585: Write_Debug('l_comp_usr_attr_flag [' || l_comp_usr_attr_flag || ']' );
2586:
2587: IF l_comp_usr_attr_flag = 0 THEN
2588: INSERT INTO BOM_CMP_USR_ATTR_INTERFACE
2589: (
2590: DATA_SET_ID ,
2591: TRANSACTION_ID ,
2592: BILL_SEQUENCE_ID ,

Line 2635: UPDATE BOM_CMP_USR_ATTR_INTERFACE

2631: l_usr_attr_data_tbl(i).PARENT_SOURCE_SYSTEM_REFERENCE,
2632: 70201 -- Added for PIMTELCO Bug-7645265 Hardcoded Value for COMPONENTS_LEVEL data level
2633: );
2634: ELSE
2635: UPDATE BOM_CMP_USR_ATTR_INTERFACE
2636: SET TRANSACTION_ID = l_usr_attr_data_tbl(i).TRANSACTION_ID,
2637: BILL_SEQUENCE_ID = l_usr_attr_data_tbl(i).BILL_SEQUENCE_ID,
2638: COMPONENT_SEQUENCE_ID = l_usr_attr_data_tbl(i).COMPONENT_SEQUENCE_ID,
2639: ATTR_DISP_VALUE = l_varchar_data,