[Home] [Help]
65: AND source_system_name =
66: nvl(p_source_system_name,source_system_name));
67: CURSOR iea_intf_cur IS
68: SELECT ieav_interface_id
69: FROM csi_iea_value_interface a
70: WHERE a.attribute_level = 'ITEM'
71: AND a.inst_interface_id IN (SELECT inst_interface_id
72: FROM csi_instance_interface cii
73: WHERE cii.transaction_identifier IS NOT NULL
436: iea_intf_id_upd
437: LIMIT max_buffer_size;
438:
439: FORALL i1 in 1 .. iea_intf_id_upd.count
440: UPDATE csi_iea_value_interface a
441: SET a.inventory_item_id =
442: (SELECT inventory_item_id
443: FROM mtl_system_items_kfv
444: WHERE concatenated_segments =
448: AND a.inventory_item_id IS NULL
449: AND a.inv_concatenated_segments IS NOT NULL;
450:
451: FORALL i2 in 1 .. iea_intf_id_upd.count
452: UPDATE csi_iea_value_interface a
453: SET a.master_organization_id =
454: (SELECT organization_id
455: FROM hr_all_organization_units
456: WHERE name = master_organization_name)
463: END LOOP;
464: COMMIT;
465: CLOSE iea_intf_cur;
466:
467: UPDATE csi_iea_value_interface a
468: SET a.attribute_id=(SELECT attribute_id
469: FROM csi_i_extended_attribs
470: WHERE attribute_level = a.attribute_level
471: AND attribute_code = a.attribute_code)
482: AND a.attribute_id IS NULL
483: AND a.attribute_level IS NOT NULL
484: AND a.attribute_code IS NOT NULL;
485:
486: UPDATE csi_iea_value_interface a
487: SET a.attribute_id = (SELECT attribute_id
488: FROM csi_i_extended_attribs
489: WHERE attribute_level = a.attribute_level
490: AND attribute_code = a.attribute_code
592: AND parallel_worker_id = p_worker_id);
593:
594: CURSOR iea_intf_cur IS
595: SELECT ieav_interface_id
596: FROM csi_iea_value_interface a
597: WHERE a.attribute_level = 'ITEM'
598: AND a.inst_interface_id IN (SELECT inst_interface_Id
599: FROM csi_instance_interface
600: WHERE transaction_identifier IS NULL
959: iea_intf_id_upd
960: LIMIT max_buffer_size;
961:
962: FORALL i1 in 1 .. iea_intf_id_upd.count
963: UPDATE csi_iea_value_interface a
964: SET a.inventory_item_id =
965: (SELECT inventory_item_id
966: FROM mtl_system_items_kfv
967: WHERE concatenated_segments =
971: AND a.inventory_item_id IS NULL
972: AND a.inv_concatenated_segments IS NOT NULL;
973:
974: FORALL i2 in 1 .. iea_intf_id_upd.count
975: UPDATE csi_iea_value_interface a
976: SET a.master_organization_id =
977: (SELECT organization_id
978: FROM hr_all_organization_units
979: WHERE name = master_organization_name)
986: END LOOP;
987: COMMIT;
988: CLOSE iea_intf_cur;
989:
990: UPDATE csi_iea_value_interface a
991: SET a.attribute_id=(SELECT attribute_id
992: FROM csi_i_extended_attribs
993: WHERE attribute_level = a.attribute_level
994: AND attribute_code = a.attribute_code)
1005: AND a.attribute_id IS NULL
1006: AND a.attribute_level IS NOT NULL
1007: AND a.attribute_code IS NOT NULL;
1008:
1009: UPDATE csi_iea_value_interface a
1010: SET a.attribute_id=(SELECT attribute_id
1011: FROM csi_i_extended_attribs
1012: WHERE attribute_level = a.attribute_level
1013: AND attribute_code = a.attribute_code
1372: AND cii.source_system_name = p_source_system_name)
1373: AND acct3_relationship_type_code = 'OWNER'
1374: AND ip_account3_id IS NULL;
1375:
1376: UPDATE csi_iea_value_interface a
1377: SET attribute_id =(SELECT attribute_id
1378: FROM csi_i_extended_attribs
1379: WHERE attribute_level = a.attribute_level
1380: AND attribute_code = a.attribute_code)
1384: AND cii.source_system_name = p_source_system_name)
1385: AND attribute_level = 'GLOBAL'
1386: AND attribute_id IS NULL;
1387:
1388: UPDATE csi_iea_value_interface a
1389: SET attribute_id=(SELECT attribute_id
1390: FROM csi_i_extended_attribs
1391: WHERE attribute_level = a.attribute_level
1392: AND attribute_code = a.attribute_code
1400: AND cii.source_system_name = p_source_system_name)
1401: AND attribute_level = 'ITEM'
1402: AND attribute_id IS NULL;
1403:
1404: UPDATE csi_iea_value_interface a
1405: SET attribute_value_id = (SELECT attribute_value_id
1406: FROM csi_iea_values
1407: WHERE attribute_id = a.attribute_id
1408: AND attribute_value = a.attribute_value