APPS.INV_GMI_MIGRATION dependencies on GMI_ITEM_CONV_AUDIT_DETAILS

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 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;