APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_ITEM_REVISIONS_TL

Line 1111: In Patchset I, the table were changed to mtl_item_revisions_b and mtl_item_revisions_tl.

1107:
1108: /*-------------------------------------------+
1109: Insert Item revision information
1110: Till Patchset I, this information was inserted into mtl_item_revisions table.
1111: In Patchset I, the table were changed to mtl_item_revisions_b and mtl_item_revisions_tl.
1112: In Patchset I, we were constructing insert stmts dymanically to avoid BOM/INV odf dependency.
1113: In Patchset J, we are inserting into the new tables. Dependency will not be an issue because we are maintaining a separate branch for J and I.
1114: Cannot do bulk processing here, since a different revision_id needs to be generated for each config
1115: +-------------------------------------------*/

Line 1170: insert into mtl_item_revisions_tl (

1166: WriteToLog('Inserted rows into mtl_item_revisions_b:: '||sql%rowcount,2);
1167: --insert into _tl table so that item is visible in revisions form
1168: --for multi-lingual support
1169:
1170: insert into mtl_item_revisions_tl (
1171: inventory_item_id,
1172: organization_id,
1173: revision_id,
1174: language,

Line 1210: from mtl_item_revisions_tl t

1206: and mr.inventory_item_id = v_bcolu_cfg.config_item_id --3338108
1207: and mr.organization_id = bcso.organization_id --3338108
1208: and NOT EXISTS
1209: (select NULL
1210: from mtl_item_revisions_tl t
1211: where t.inventory_item_id = v_bcolu_cfg.config_item_id
1212: and t.organization_id = bcso.organization_id
1213: and t.revision_id = mr.revision_id --3338108
1214: and t.language = l.language_code );

Line 1216: WriteToLog('Inserted rows into mtl_item_revisions_tl:: '||sql%rowcount,2);

1212: and t.organization_id = bcso.organization_id
1213: and t.revision_id = mr.revision_id --3338108
1214: and t.language = l.language_code );
1215:
1216: WriteToLog('Inserted rows into mtl_item_revisions_tl:: '||sql%rowcount,2);
1217:
1218: END LOOP; /* c_bcolu_cfg */
1219:
1220: