[Home] [Help]
23:
24: -- To change the disposition of a sample if Sample_id is provided.
25: PROCEDURE update_sample_comp_disp
26: (
27: p_update_disp_rec IN Gmd_Samples_Grp.update_disp_rec
28: , p_to_disposition IN VARCHAR2
29: , x_return_status OUT NOCOPY VARCHAR2
30: , x_message_data OUT NOCOPY VARCHAR2
31: ) IS
35:
36:
37: BEGIN
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39: Gmd_Samples_Grp.update_sample_comp_disp
40: ( p_update_disp_rec => p_update_disp_rec
41: , p_to_disposition => p_to_disposition
42: , x_return_status => l_return_status
43: , x_message_data => l_message_data );
75: l_message_data VARCHAR2(2000);
76:
77: BEGIN
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: Gmd_Samples_Grp.update_lot_grade_batch(
80: p_sample_id => p_sample_id
81: , p_composite_spec_disp_id => p_composite_spec_disp_id
82: , p_to_lot_status_id => p_to_lot_status_id
83: , p_from_lot_status_id => p_from_lot_status_id