APPS.INV_GMI_MIGRATION dependencies on GMI_ITEM_CONV_AUDIT

Line 1584: CURSOR c_gmi_item_conv_audit

1580: nvl(m.migrated_ind,0) = 1 and
1581: m.conv_migrated_ind is NULL;
1582:
1583:
1584: CURSOR c_gmi_item_conv_audit
1585: (pconversion_id NUMBER) IS
1586: SELECT *
1587: FROM gmi_item_conv_audit
1588: WHERE conversion_id = pconversion_id;

Line 1587: FROM gmi_item_conv_audit

1583:
1584: CURSOR c_gmi_item_conv_audit
1585: (pconversion_id NUMBER) IS
1586: SELECT *
1587: FROM gmi_item_conv_audit
1588: WHERE conversion_id = pconversion_id;
1589:
1590: CURSOR c_gmi_item_conv_audit_details
1591: (pconv_audit_id NUMBER) IS

Line 1590: CURSOR c_gmi_item_conv_audit_details

1586: SELECT *
1587: FROM gmi_item_conv_audit
1588: WHERE conversion_id = pconversion_id;
1589:
1590: CURSOR c_gmi_item_conv_audit_details
1591: (pconv_audit_id NUMBER) IS
1592: SELECT *
1593: FROM gmi_item_conv_audit_details
1594: WHERE conv_audit_id = pconv_audit_id;

Line 1593: FROM gmi_item_conv_audit_details

1589:
1590: CURSOR c_gmi_item_conv_audit_details
1591: (pconv_audit_id NUMBER) IS
1592: SELECT *
1593: FROM gmi_item_conv_audit_details
1594: WHERE conv_audit_id = pconv_audit_id;
1595: BEGIN
1596: x_failure_count := 0;
1597: l_migrate_count := 0;

Line 1742: FOR cuadit in c_gmi_item_conv_audit(c.conversion_id) LOOP

1738: c.last_update_date,
1739: c.last_update_login
1740: );
1741:
1742: FOR cuadit in c_gmi_item_conv_audit(c.conversion_id) LOOP
1743:
1744: SELECT MTL_CONV_AUDIT_ID_S.NEXTVAL
1745: INTO l_conv_audit_id FROM DUAL;
1746:

Line 1788: FOR adetail in c_gmi_item_conv_audit_details (cuadit.conv_audit_id) LOOP

1784: cuadit.creation_date,
1785: cuadit.last_updated_by,
1786: cuadit.last_update_date);
1787:
1788: FOR adetail in c_gmi_item_conv_audit_details (cuadit.conv_audit_id) LOOP
1789:
1790: -- Get the organization / subinventory for the warehouse
1791: l_field_name := 'Organization/ Subinventory';
1792: l_field_value := 'Warehouse = '||adetail.whse_code;