1616: END LOOP;
1617: END IF;
1618: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------');
1619:
1620: --Bugfix 6241681: Removing the reference of deactivated configs from bom_cto_order_lines
1621:
1622: IF (l_deactivated_items.count > 0) THEN
1623:
1624: fnd_file.put_line(fnd_file.log, 'Removing the reference of deactivated configs from bom_cto_order_lines..');
1620: --Bugfix 6241681: Removing the reference of deactivated configs from bom_cto_order_lines
1621:
1622: IF (l_deactivated_items.count > 0) THEN
1623:
1624: fnd_file.put_line(fnd_file.log, 'Removing the reference of deactivated configs from bom_cto_order_lines..');
1625: l_index := l_deactivated_items.FIRST;
1626: LOOP
1627: fnd_file.put_line(fnd_file.log, 'Removing reference of '||l_deactivated_items(l_index).cfg_item_id||'('||
1628: l_deactivated_items(l_index).cfg_item_name||'): ');
1625: l_index := l_deactivated_items.FIRST;
1626: LOOP
1627: fnd_file.put_line(fnd_file.log, 'Removing reference of '||l_deactivated_items(l_index).cfg_item_id||'('||
1628: l_deactivated_items(l_index).cfg_item_name||'): ');
1629: UPDATE bom_cto_order_lines
1630: SET config_item_id = null
1631: WHERE config_item_id = l_deactivated_items(l_index).cfg_item_id;
1632:
1633: EXIT WHEN l_index = l_deactivated_items.LAST;
1633: EXIT WHEN l_index = l_deactivated_items.LAST;
1634: l_index := l_deactivated_items.NEXT(l_index);
1635: END LOOP;
1636: END IF;
1637: --Bugfix 6241681: Removing the reference of deactivated configs from bom_cto_order_lines
1638:
1639: errbuf := 'Program completed succesfully';
1640:
1641: EXCEPTION