APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_WIP_SPEC_VRS

Line 3089: INSERT INTO gmd_wip_spec_vrs

3085: l_oprn_vers :=null;
3086: ENd IF;
3087:
3088: /* Create a production spec validity rule */
3089: INSERT INTO gmd_wip_spec_vrs
3090: (
3091: spec_vr_id,
3092: spec_id,
3093: orgn_code,

Line 6008: p_table_name => 'GMD_WIP_SPEC_VRS',

6004: l_max_date := trunc(fnd_date.canonical_to_date(nvl(fnd_profile.value('SY$MAX_DATE'),'2010/12/31') ));
6005:
6006: GMA_MIGRATION.gma_insert_message (
6007: p_run_id => p_migration_id,
6008: p_table_name => 'GMD_WIP_SPEC_VRS',
6009: p_DB_ERROR => '',
6010: p_param1 => 'Nulling out end date on wip vrs ',
6011: p_param2 => 'Where end date is SY$MAX_DATE ',
6012: p_param3 => '',

Line 6021: update gmd_wip_spec_vrs

6017: p_line_no => '',
6018: p_position => '',
6019: p_base_message => '');
6020:
6021: update gmd_wip_spec_vrs
6022: set end_date = NULL
6023: where trunc(end_date + 1) >= l_max_date
6024: and SPEC_VR_STATUS = 700;
6025: