APPS.INV_GMI_MIGRATION dependencies on GMI_ITEM_CONV_AUDIT

Line 1676: CURSOR c_gmi_item_conv_audit

1672: nvl(m.migrated_ind,0) = 1 and
1673: m.conv_migrated_ind is NULL;
1674:
1675:
1676: CURSOR c_gmi_item_conv_audit
1677: (pconversion_id NUMBER) IS
1678: SELECT *
1679: FROM gmi_item_conv_audit
1680: WHERE conversion_id = pconversion_id;

Line 1679: FROM gmi_item_conv_audit

1675:
1676: CURSOR c_gmi_item_conv_audit
1677: (pconversion_id NUMBER) IS
1678: SELECT *
1679: FROM gmi_item_conv_audit
1680: WHERE conversion_id = pconversion_id;
1681:
1682: CURSOR c_gmi_item_conv_audit_details
1683: (pconv_audit_id NUMBER) IS

Line 1682: CURSOR c_gmi_item_conv_audit_details

1678: SELECT *
1679: FROM gmi_item_conv_audit
1680: WHERE conversion_id = pconversion_id;
1681:
1682: CURSOR c_gmi_item_conv_audit_details
1683: (pconv_audit_id NUMBER) IS
1684: SELECT *
1685: FROM gmi_item_conv_audit_details
1686: WHERE conv_audit_id = pconv_audit_id;

Line 1685: FROM gmi_item_conv_audit_details

1681:
1682: CURSOR c_gmi_item_conv_audit_details
1683: (pconv_audit_id NUMBER) IS
1684: SELECT *
1685: FROM gmi_item_conv_audit_details
1686: WHERE conv_audit_id = pconv_audit_id;
1687: BEGIN
1688: x_failure_count := 0;
1689: l_migrate_count := 0;

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

1830: c.last_update_date,
1831: c.last_update_login
1832: );
1833:
1834: FOR cuadit in c_gmi_item_conv_audit(c.conversion_id) LOOP
1835:
1836: SELECT MTL_CONV_AUDIT_ID_S.NEXTVAL
1837: INTO l_conv_audit_id FROM DUAL;
1838:

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

1876: cuadit.creation_date,
1877: cuadit.last_updated_by,
1878: cuadit.last_update_date);
1879:
1880: FOR adetail in c_gmi_item_conv_audit_details (cuadit.conv_audit_id) LOOP
1881:
1882: -- Get the organization / subinventory for the warehouse
1883: l_field_name := 'Organization/ Subinventory';
1884: l_field_value := 'Warehouse = '||adetail.whse_code;