APPS.GMD_DISP_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

PROCEDURE update_sample_comp_disp
(
  p_update_disp_rec	        IN Gmd_Samples_Grp.update_disp_rec
, p_to_disposition		IN         VARCHAR2
, x_return_status 		OUT NOCOPY VARCHAR2
, x_message_data		OUT NOCOPY VARCHAR2
) IS

   l_return_status   	VARCHAR2(1);

Line: 39

    Gmd_Samples_Grp.update_sample_comp_disp
		( p_update_disp_rec => p_update_disp_rec
		, p_to_disposition =>  p_to_disposition
		, x_return_status  =>  l_return_status
		, x_message_data   =>  l_message_data );

Line: 59

PROCEDURE update_lot_grade_batch
(
  p_sample_id			IN         NUMBER DEFAULT NULL
, p_composite_spec_disp_id  	IN         NUMBER DEFAULT NULL
, p_to_lot_status_id	  	IN         NUMBER
, p_from_lot_status_id	  	IN         NUMBER
, p_to_grade_code		IN         VARCHAR2
, p_from_grade_code		IN         VARCHAR2 DEFAULT NULL
, p_to_qc_status		IN         NUMBER
, p_reason_id			IN         NUMBER
, p_hold_date                   IN         DATE DEFAULT SYSDATE
, x_return_status 		OUT NOCOPY VARCHAR2
, x_message_data		OUT NOCOPY VARCHAR2
) IS

   l_return_status   	VARCHAR2(1);

Line: 79

    Gmd_Samples_Grp.update_lot_grade_batch(
    	     p_sample_id              => p_sample_id
	   , p_composite_spec_disp_id => p_composite_spec_disp_id
	   , p_to_lot_status_id       => p_to_lot_status_id
	   , p_from_lot_status_id     => p_from_lot_status_id
	   , p_to_grade_code	      => p_to_grade_code
	   , p_from_grade_code	      => p_from_grade_code
	   , p_to_qc_status	      => p_to_qc_status
	   , p_reason_id	      => p_reason_id
	   , p_hold_date              => p_hold_date
	   , x_return_status 	      => l_return_status
	   , x_message_data	      => l_message_data );