DBA Data[Home] [Help]

APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_SUPPLIER_SPEC_VRS

Line 3515: INSERT INTO gmd_supplier_spec_vrs

3511: l_supplier_site_id := NULL;
3512: END IF;
3513:
3514: /* Create an supplier spec validity rule */
3515: INSERT INTO gmd_supplier_spec_vrs
3516: (
3517: spec_vr_id,
3518: spec_id,
3519: orgn_code,

Line 6069: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',

6065: and SPEC_VR_STATUS = 700;
6066:
6067: GMA_MIGRATION.gma_insert_message (
6068: p_run_id => p_migration_id,
6069: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',
6070: p_DB_ERROR => '',
6071: p_param1 => 'Nulling out end date on supplier vrs ',
6072: p_param2 => 'Where end date is SY$MAX_DATE ',
6073: p_param3 => '',

Line 6082: update gmd_supplier_spec_vrs

6078: p_line_no => '',
6079: p_position => '',
6080: p_base_message => '');
6081:
6082: update gmd_supplier_spec_vrs
6083: set end_date = NULL
6084: where trunc(end_date + 1) >= l_max_date
6085: and SPEC_VR_STATUS = 700;
6086: