APPS.GMD_DISP_PUB dependencies on GMD_SAMPLES

Line 92: p_update_disp_rec IN GMD_SAMPLES_GRP.update_disp_rec

88: ,x_msg_data OUT NOCOPY VARCHAR2
89: );
90:
91: PROCEDURE Validate_disp (
92: p_update_disp_rec IN GMD_SAMPLES_GRP.update_disp_rec
93: ,p_to_disposition IN VARCHAR2
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER
96: ,x_msg_data OUT NOCOPY VARCHAR2

Line 116: FROM gmd_samples gs, gmd_event_spec_disp ge

112:
113: -- Cursors
114: CURSOR c_event_disp_sm(p_sample_id NUMBER) IS
115: SELECT event_spec_disp_id
116: FROM gmd_samples gs, gmd_event_spec_disp ge
117: WHERE gs.sampling_event_id = ge.sampling_event_id
118: AND ge.spec_used_for_lot_attrib_ind = 'Y'
119: AND gs.sample_id = p_id
120: AND ge.delete_mark = 0

Line 125: FROM gmd_samples gs, gmd_event_spec_disp ge

121: ;
122:
123: CURSOR c_event_disp_se(p_sample_id NUMBER) IS
124: SELECT DISTINCT event_spec_disp_id
125: FROM gmd_samples gs, gmd_event_spec_disp ge
126: WHERE gs.sampling_event_id = ge.sampling_event_id
127: AND gs.sampling_event_id = p_id
128: AND ge.spec_used_for_lot_attrib_ind = 'Y'
129: AND ge.delete_mark = 0

Line 472: p_update_disp_rec IN GMD_SAMPLES_GRP.update_disp_rec

468: /*=============================================================================
469: Procedure to validate the to_disposition of the sample
470: =============================================================================*/
471: PROCEDURE Validate_disp (
472: p_update_disp_rec IN GMD_SAMPLES_GRP.update_disp_rec
473: ,p_to_disposition IN VARCHAR2
474: ,x_return_status OUT NOCOPY VARCHAR2
475: ,x_msg_count OUT NOCOPY NUMBER
476: ,x_msg_data OUT NOCOPY VARCHAR2

Line 619: FROM gmd_samples

615: AND sr.delete_mark = 0;
616:
617: CURSOR c_get_smpl_org_id IS
618: SELECT organization_id
619: FROM gmd_samples
620: WHERE sample_id = p_update_disp_rec.sample_id;
621:
622: CURSOR c_get_evt_org_id IS
623: SELECT organization_id

Line 829: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

825: l_msg_count NUMBER :=0;
826: l_message_data VARCHAR2(2000);
827: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
828: l_pos VARCHAR2(5);
829: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;
830: l_change_rec GMD_SAMPLES_GRP.update_change_disp_rec;
831: l_sample_req_cnt NUMBER;
832: l_sample_active_cnt NUMBER;
833: l_sample_taken_cnt NUMBER;

Line 830: l_change_rec GMD_SAMPLES_GRP.update_change_disp_rec;

826: l_message_data VARCHAR2(2000);
827: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
828: l_pos VARCHAR2(5);
829: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;
830: l_change_rec GMD_SAMPLES_GRP.update_change_disp_rec;
831: l_sample_req_cnt NUMBER;
832: l_sample_active_cnt NUMBER;
833: l_sample_taken_cnt NUMBER;
834:

Line 896: FROM gmd_samples

892:
893: --Get sample id for single sample group if sampling event is passed
894: CURSOR get_sample_id IS
895: SELECT sample_id
896: FROM gmd_samples
897: WHERE sampling_event_id = p_change_disp_rec.sampling_event_id;
898:
899: CURSOR composite_spec_disp(l_event_spec_disp_id NUMBER) IS
900: SELECT composite_spec_disp_id

Line 1025: FROM gmd_samples a,

1021: SELECT a.organization_id,b.lot_control_code,b.grade_control_flag,b.child_lot_flag,b.lot_status_enabled,a.sample_type,a.source,
1022: a.inventory_item_id,a.parent_lot_number,a.lot_number,a.lpn_id,a.subinventory,a.locator_id,c.concatenated_segments,a.lpn_id,d.license_plate_number,e.wms_enabled_flag
1023: INTO l_organization_id,l_lot_control_code,l_grade_control_flag,l_child_lot_flag,l_lot_status_enabled,l_sample_type,l_source,
1024: l_inventory_item_id,l_parent_lot_number,l_lot_number,l_lpn_id,l_subinventory,l_locator_id,l_locator,l_lpn_id,l_lpn,l_wms_enabled_flag
1025: FROM gmd_samples a,
1026: mtl_system_items_b b,
1027: mtl_item_locations_kfv c,
1028: wms_license_plate_numbers d,
1029: mtl_parameters e

Line 1092: UPDATE GMD_SAMPLES

1088: gmd_debug.put_line('Entered Lot/Sublot is not Valid ');
1089: END IF;
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSE
1092: UPDATE GMD_SAMPLES
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:

Line 1100: WHERE sampling_event_id = (SELECT sampling_event_id FROM gmd_samples

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 );
1102:
1103: l_parent_lot_number := p_change_disp_rec.parent_lot_number;
1104: l_lot_number := p_change_disp_rec.lot_number;

Line 1143: UPDATE GMD_SAMPLES

1139: gmd_debug.put_line('Entered LPN is not Valid ');
1140: END IF;
1141: RAISE FND_API.G_EXC_ERROR;
1142: ELSE
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

Line 1149: WHERE sampling_event_id = (SELECT sampling_event_id FROM gmd_samples

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:
1152: END IF;
1153: END IF;

Line 1215: UPDATE GMD_SAMPLES

1211: gmd_debug.put_line('Entered Lot/Sublot is not Valid ');
1212: END IF;
1213: RAISE FND_API.G_EXC_ERROR;
1214: ELSE
1215: UPDATE GMD_SAMPLES
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:

Line 1264: UPDATE GMD_SAMPLES

1260: gmd_debug.put_line('Entered LPN is not Valid ');
1261: END IF;
1262: RAISE FND_API.G_EXC_ERROR;
1263: ELSE
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