APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_CROSS_REFERENCES_TL

Line 322: | mtl_cross_references_b and mtl_cross_references_tl

318: |
319: | Modified on 08-Aug-2005 Kiran Konada
320: | bug# 4539578
321: | In R12, mtl_cross_references datamodel has been changed to
322: | mtl_cross_references_b and mtl_cross_references_tl
323: |
324: | Modified on 15-Sep-2005 Renga Kannan
325: | Made Code changes for ATG Performance
326: | Project

Line 8016: INSERT INTO mtl_cross_references_tl (

8012: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_b'||sql%rowcount,2);
8013:
8014: END IF;
8015:
8016: INSERT INTO mtl_cross_references_tl (
8017: last_update_login
8018: ,description
8019: ,creation_date
8020: ,created_by

Line 8045: FROM mtl_cross_references_tl t

8041: AND mtl_cross.organization_id = mtl.organization_id
8042: AND l.language_code = mtl.language
8043: AND l.installed_flag in ('I', 'B')
8044: AND NOT EXISTS (SELECT null
8045: FROM mtl_cross_references_tl t
8046: WHERE t.cross_reference_id = mtl_cross.cross_reference_id
8047: AND t.language = l.language_code);
8048:
8049:

Line 8052: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_tl',2);

8048:
8049:
8050:
8051: IF PG_DEBUG <> 0 THEN
8052: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_tl',2);
8053: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_tl'||sql%rowcount,2);
8054:
8055: END IF;
8056:

Line 8053: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_tl'||sql%rowcount,2);

8049:
8050:
8051: IF PG_DEBUG <> 0 THEN
8052: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_tl',2);
8053: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_tl'||sql%rowcount,2);
8054:
8055: END IF;
8056:
8057: