eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QC_MIG12 dependencies on GMD_SAMPLING_EVENTS

Line 158: p_param1 => 'gmd_sampling_events',

154: p_token2 => 'PRO',
155: p_token3 => 'UPD',
156: p_token4 => 'INS',
157: p_token5 => 'ERR',
158: p_param1 => 'gmd_sampling_events',
159: p_param2 => to_char(GMD_QC_MIG12.g_sample_event_pro_count),
160: p_param3 => to_char(GMD_QC_MIG12.g_sample_event_upd_count),
161: p_param4 => 0,
162: p_param5 => to_char(GMD_QC_MIG12.g_sample_event_err_count),

Line 2510: FROM gmd_sampling_events

2506: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
2507:
2508: CURSOR get_sampling_event IS
2509: SELECT sampling_event_id
2510: FROM gmd_sampling_events
2511: WHERE migrated_ind IS NULL;
2512: -- 12/09/2005
2513:
2514: -- Bug# 5261810

Line 3308: Log Start of gmd_sampling_events migration.

3304: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3305:
3306:
3307: /*==============================================
3308: Log Start of gmd_sampling_events migration.
3309: ==============================================*/
3310:
3311: GMA_COMMON_LOGGING.gma_migration_central_log (
3312: p_run_id => p_migration_run_id,

Line 3315: p_table_name => 'GMD_SAMPLING_EVENTS',

3311: GMA_COMMON_LOGGING.gma_migration_central_log (
3312: p_run_id => p_migration_run_id,
3313: p_log_level => FND_LOG.LEVEL_EVENT,
3314: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3315: p_table_name => 'GMD_SAMPLING_EVENTS',
3316: p_token1 => 'TABLE_NAME',
3317: p_param1 => 'GMD_SAMPLING_EVENTS',
3318: p_context => 'Quality Samples',
3319: p_app_short_name => 'GMA');

Line 3317: p_param1 => 'GMD_SAMPLING_EVENTS',

3313: p_log_level => FND_LOG.LEVEL_EVENT,
3314: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3315: p_table_name => 'GMD_SAMPLING_EVENTS',
3316: p_token1 => 'TABLE_NAME',
3317: p_param1 => 'GMD_SAMPLING_EVENTS',
3318: p_context => 'Quality Samples',
3319: p_app_short_name => 'GMA');
3320:
3321:

Line 3343: Update gmd_sampling_events.

3339: RAISE MIG_GET_SAMPLE_ERROR;
3340: END IF;
3341: CLOSE get_sample_data;
3342: /*===============================
3343: Update gmd_sampling_events.
3344: ===============================*/
3345: UPDATE gmd_sampling_events
3346: SET organization_id = l_samp_data.organization_id,
3347: inventory_item_id = l_samp_data.inventory_item_id,

Line 3345: UPDATE gmd_sampling_events

3341: CLOSE get_sample_data;
3342: /*===============================
3343: Update gmd_sampling_events.
3344: ===============================*/
3345: UPDATE gmd_sampling_events
3346: SET organization_id = l_samp_data.organization_id,
3347: inventory_item_id = l_samp_data.inventory_item_id,
3348: lot_number = l_samp_data.lot_number,
3349: subinventory = l_samp_data.subinventory,

Line 3368: -- Supress logging of the following message since there are lot of rows in gmd_sampling_events where there is no corresponding sample row.

3364: EXCEPTION
3365:
3366: WHEN MIG_GET_SAMPLE_ERROR THEN
3367: -- Bug# 5462876
3368: -- Supress logging of the following message since there are lot of rows in gmd_sampling_events where there is no corresponding sample row.
3369: /*GMA_COMMON_LOGGING.gma_migration_central_log (
3370: p_run_id => p_migration_run_id,
3371: p_log_level => FND_LOG.LEVEL_ERROR,
3372: p_message_token => 'GMD_MIG_GET_SAMPLE',

Line 3373: p_context => 'Quality Samples - gmd_sampling_events',

3369: /*GMA_COMMON_LOGGING.gma_migration_central_log (
3370: p_run_id => p_migration_run_id,
3371: p_log_level => FND_LOG.LEVEL_ERROR,
3372: p_message_token => 'GMD_MIG_GET_SAMPLE',
3373: p_context => 'Quality Samples - gmd_sampling_events',
3374: p_token1 => 'SAMPLEVT',
3375: p_param1 => to_char(v_samp_event.sampling_event_id),
3376: p_app_short_name => 'GMD'); */
3377: GMD_QC_MIG12.g_sample_event_err_count := GMD_QC_MIG12.g_sample_event_err_count + 1;

Line 3386: p_context => 'Quality Samples - gmd_sampling_events',

3382: GMA_COMMON_LOGGING.gma_migration_central_log (
3383: p_run_id => p_migration_run_id,
3384: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3385: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3386: p_context => 'Quality Samples - gmd_sampling_events',
3387: p_db_error => SQLERRM,
3388: p_app_short_name => 'GMA');
3389: x_exception_count := x_exception_count + 1;
3390:

Line 3775: l_sample_orgn_code gmd_sampling_events.orgn_code%TYPE;

3771: /*====================================================
3772: Cursor to check if gmd_inventory_spec_vrs exists.
3773: ====================================================*/
3774:
3775: l_sample_orgn_code gmd_sampling_events.orgn_code%TYPE;
3776:
3777: -- Bug# 5482253
3778: -- Commented the following cursor definition and added it with the new where clause.
3779:

Line 3818: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

3814: =======================================*/
3815:
3816: CURSOR get_sample_org (v_spec_id gmd_inventory_spec_vrs.spec_vr_id%TYPE) IS
3817: SELECT DISTINCT gse.orgn_code, gse.organization_id
3818: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3819: gmd_inventory_spec_vrs gisv
3820: WHERE gse.sampling_event_id = gesd.sampling_event_id
3821: AND gesd.spec_vr_id = gisv.spec_vr_id
3822: AND gisv.spec_vr_id = v_spec_id;

Line 3824: l_sample_organization_id gmd_sampling_events.organization_id%TYPE;

3820: WHERE gse.sampling_event_id = gesd.sampling_event_id
3821: AND gesd.spec_vr_id = gisv.spec_vr_id
3822: AND gisv.spec_vr_id = v_spec_id;
3823:
3824: l_sample_organization_id gmd_sampling_events.organization_id%TYPE;
3825:
3826:
3827: /*=======================================
3828: Cursor for gmd_wip_spec.

Line 3849: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

3845: =======================================*/
3846:
3847: CURSOR get_wip_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3848: SELECT DISTINCT gse.orgn_code, gse.organization_id
3849: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3850: gmd_wip_spec_vrs gwsv
3851: WHERE gse.sampling_event_id = gesd.sampling_event_id
3852: AND gesd.spec_vr_id = gwsv.spec_vr_id
3853: AND gwsv.spec_vr_id = v_spec_id;

Line 3928: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

3924: =======================================*/
3925:
3926: CURSOR get_cust_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3927: SELECT DISTINCT gse.orgn_code, gse.organization_id
3928: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3929: gmd_customer_spec_vrs gcsv
3930: WHERE gse.sampling_event_id = gesd.sampling_event_id
3931: AND gesd.spec_vr_id = gcsv.spec_vr_id
3932: AND gcsv.spec_vr_id = v_spec_id;

Line 3990: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

3986: =======================================*/
3987:
3988: CURSOR get_supl_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3989: SELECT DISTINCT gse.orgn_code, gse.organization_id
3990: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3991: gmd_supplier_spec_vrs gssv
3992: WHERE gse.sampling_event_id = gesd.sampling_event_id
3993: AND gesd.spec_vr_id = gssv.spec_vr_id
3994: AND gssv.spec_vr_id = v_spec_id;

Line 4050: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4046: ==========================================*/
4047:
4048: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS
4049: SELECT DISTINCT gse.orgn_code, gse.organization_id
4050: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4051: gmd_monitoring_spec_vrs gmsv
4052: WHERE gse.sampling_event_id = gesd.sampling_event_id
4053: AND gesd.spec_vr_id = gmsv.spec_vr_id
4054: AND gmsv.spec_vr_id = v_spec_id;