[Home] [Help]
42: | Kedar Bavadekar - 04/07/11 Bug 10405668 |
43: | Added procedure migrate_opm_items |
44: | Abhay Satpute 05/02/2011 Bug 12387835 Increase width of local vars |
45: | l_prim_unit_of_measure and l_sec_unit_of_measure |
46: | Srinivasulu Puri 03/14/2012 Modified to lock the ic_item_mst_B_mig |
47: | only when item is migrated by get_odm_item call. |
48: | Bug 13811730 |
49: | May Chen 05/16/2012 Bug 14013552, Modified to remove default logic for|
50: | BOM_ENABLED_FLAG in UPDATE mode, keep the original value |
957: language = d.language;
958: END LOOP;
959:
960: -- Bug 5489195 - Added migrated_ind in the update
961: UPDATE ic_item_mst_b_mig
962: SET
963: inventory_item_id = x_inventory_item_id,
964: migrated_ind = 1,
965: last_update_date = sysdate,
968: item_id = p_item_id AND
969: organization_id = p_organization_id;
970:
971: IF SQL%ROWCOUNT = 0 THEN
972: INSERT INTO ic_item_mst_b_mig(
973: item_id,
974: organization_id,
975: inventory_item_id,
976: migrated_ind,
1425: x_failure_count := x_failure_count + 1;
1426: RETURN;
1427: END IF;
1428:
1429: -- for GMI items check the value in ic_item_mst_b_mig table
1430: IF (p_item_source = 'GMI') THEN
1431: BEGIN
1432: g_item_id := p_item_id;
1433: g_organization_id := p_organization_id;
1437: -- Select and lock the row to avoid errors associated with running this routine in
1438: -- parallel from routines using AD parrallel update logic.
1439: SELECT inventory_item_id, migrated_ind
1440: INTO g_inventory_item_id, l_migrated_ind
1441: FROM ic_item_mst_b_mig
1442: WHERE
1443: item_id = g_item_id AND
1444: organization_id = g_organization_id;
1445: --FOR UPDATE; 13811730
1452:
1453: -- 13811730 Lock this row for the parrallel run of this routine.
1454: SELECT 1
1455: INTO dv
1456: FROM ic_item_mst_b_mig
1457: WHERE
1458: item_id = g_item_id AND
1459: organization_id = g_organization_id
1460: FOR UPDATE;
1462: END IF;
1463: EXCEPTION
1464: WHEN NO_DATA_FOUND THEN
1465: BEGIN
1466: INSERT INTO ic_item_mst_b_mig(
1467: item_id,
1468: organization_id,
1469: inventory_item_id,
1470: migrated_ind,
1491:
1492: -- Lock this row for the parrallel run of this routine.
1493: SELECT 1
1494: INTO dv
1495: FROM ic_item_mst_b_mig
1496: WHERE
1497: item_id = g_item_id AND
1498: organization_id = g_organization_id
1499: FOR UPDATE;
1514: -- Select and lock the row to avoid errors associated with running this routine in
1515: -- parallel from routines using AD parrallel update logic.
1516: SELECT i.migrated_ind
1517: INTO l_migrated_ind_m
1518: FROM ic_item_mst_b_mig i
1519: WHERE
1520: i.organization_id = l_master_organization_id and
1521: i.item_id = p_item_id
1522: FOR UPDATE;
1524: WHEN NO_DATA_FOUND THEN
1525: -- Jatinder - 11/30/06 - Use correct organization to lock migration records. 5690686.
1526: IF (p_item_source = 'GMI') THEN
1527: BEGIN
1528: INSERT INTO ic_item_mst_b_mig(
1529: item_id,
1530: organization_id,
1531: inventory_item_id,
1532: migrated_ind,
1553:
1554: -- Lock this row for the parrallel run of this routine.
1555: SELECT 1
1556: INTO dv
1557: FROM ic_item_mst_b_mig
1558: WHERE
1559: item_id = p_item_id AND
1560: organization_id = l_master_organization_id
1561: FOR UPDATE;
1740: CURSOR c_item IS
1741: SELECT m.organization_id, m.inventory_item_id, i.alt_itema,
1742: i.alt_itemb, i.match_type, i.upc_code, i.qcitem_id,
1743: i.qchold_res_code
1744: FROM ic_item_mst_b i, ic_item_mst_b_mig m
1745: WHERE
1746: i.item_id = m.item_id AND
1747: m.migrated_ind = 1;
1748:
2089: and b.process_enabled_flag = 'Y'
2090: and b.organization_code = p_organization_code
2091: and not exists (
2092: select 1
2093: from ic_item_mst_b_mig ic,
2094: mtl_parameters mp
2095: where ic.organization_id = mp.organization_id
2096: and mp.organization_code = p_organization_code
2097: and mp.process_enabled_flag = 'Y'