APPS.GMD_DISP_PUB dependencies on GMD_SAMPLING_EVENTS

Line 624: FROM gmd_sampling_events gse,

620: WHERE sample_id = p_update_disp_rec.sample_id;
621:
622: CURSOR c_get_evt_org_id IS
623: SELECT organization_id
624: FROM gmd_sampling_events gse,
625: gmd_event_spec_disp gesd,
626: gmd_composite_spec_disp gcsd
627: WHERE gse.sampling_event_id = gesd.sampling_event_id
628: AND gesd.event_spec_disp_id = gcsd.event_spec_disp_id

Line 890: FROM gmd_sampling_events

886: INVALID_DISPOSITION EXCEPTION;
887:
888: CURSOR samples_for_event IS
889: SELECT sample_req_cnt, sample_active_cnt, sample_taken_cnt
890: FROM gmd_sampling_events
891: WHERE sampling_event_id = p_change_disp_rec.sampling_event_id;
892:
893: --Get sample id for single sample group if sampling event is passed
894: CURSOR get_sample_id IS

Line 1097: UPDATE GMD_SAMPLING_EVENTS

1093: SET parent_lot_number = p_change_disp_rec.parent_lot_number,
1094: lot_number = p_change_disp_rec.lot_number
1095: WHERE sample_id = l_update_disp_rec.sample_id ;
1096:
1097: UPDATE GMD_SAMPLING_EVENTS
1098: SET parent_lot_number = p_change_disp_rec.parent_lot_number,
1099: lot_number = p_change_disp_rec.lot_number
1100: WHERE sampling_event_id = (SELECT sampling_event_id FROM gmd_samples
1101: WHERE sample_id = l_update_disp_rec.sample_id );

Line 1147: UPDATE GMD_SAMPLING_EVENTS

1143: UPDATE GMD_SAMPLES
1144: SET lpn_id = l_lpn_id
1145: WHERE sample_id = l_update_disp_rec.sample_id ;
1146:
1147: UPDATE GMD_SAMPLING_EVENTS
1148: SET lpn_id = l_lpn_id
1149: WHERE sampling_event_id = (SELECT sampling_event_id FROM gmd_samples
1150: WHERE sample_id = l_update_disp_rec.sample_id );
1151:

Line 1169: gmd_sampling_events gse,

1165: l_sampling_event_date,l_subinventory,l_locator_id,l_locator,l_lpn_id,l_lpn,l_wms_enabled_flag,
1166: l_sample_type,l_source,l_spec_id,l_spec_vr_id,l_update_disp_rec.curr_disposition,l_spec_name,l_spec_vers
1167: FROM gmd_composite_spec_disp csd,
1168: gmd_event_spec_disp esd ,
1169: gmd_sampling_events gse,
1170: mtl_system_items_b msi,
1171: gmd_specifications_b gsb,
1172: mtl_item_locations_kfv mil,
1173: wms_license_plate_numbers wlpn,

Line 1220: UPDATE GMD_SAMPLING_EVENTS

1216: SET parent_lot_number = p_change_disp_rec.parent_lot_number,
1217: lot_number = p_change_disp_rec.lot_number
1218: WHERE sampling_event_id = l_update_disp_rec.sampling_event_id;
1219:
1220: UPDATE GMD_SAMPLING_EVENTS
1221: SET parent_lot_number = p_change_disp_rec.parent_lot_number,
1222: lot_number = p_change_disp_rec.lot_number
1223: WHERE sampling_event_id = l_update_disp_rec.sampling_event_id;
1224:

Line 1268: UPDATE GMD_SAMPLING_EVENTS

1264: UPDATE GMD_SAMPLES
1265: SET lpn_id = l_lpn_id
1266: WHERE sampling_event_id = l_update_disp_rec.sampling_event_id;
1267:
1268: UPDATE GMD_SAMPLING_EVENTS
1269: SET lpn_id = l_lpn_id
1270: WHERE sampling_event_id = l_update_disp_rec.sampling_event_id;
1271:
1272: END IF;