DBA Data[Home] [Help]

APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on BOM_CTO_ORDER_LINES

Line 1620: --Bugfix 6241681: Removing the reference of deactivated configs from bom_cto_order_lines

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..');

Line 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||'): ');

Line 1629: UPDATE 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||'): ');
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;

Line 1637: --Bugfix 6241681: Removing the reference of deactivated configs from bom_cto_order_lines

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