42: */
43:
44: PROCEDURE CREATE_SAMPLES
45: ( p_api_version IN NUMBER
46: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
47: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
48: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49: , p_qc_samples_rec IN GMD_SAMPLES%ROWTYPE
50: , p_user_name IN VARCHAR2
43:
44: PROCEDURE CREATE_SAMPLES
45: ( p_api_version IN NUMBER
46: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
47: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
48: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49: , p_qc_samples_rec IN GMD_SAMPLES%ROWTYPE
50: , p_user_name IN VARCHAR2
51: , p_find_matching_spec IN VARCHAR2 DEFAULT 'N'
44: PROCEDURE CREATE_SAMPLES
45: ( p_api_version IN NUMBER
46: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
47: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
48: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49: , p_qc_samples_rec IN GMD_SAMPLES%ROWTYPE
50: , p_user_name IN VARCHAR2
51: , p_find_matching_spec IN VARCHAR2 DEFAULT 'N'
52: , p_grade IN VARCHAR2 DEFAULT NULL --3431884
107: */
108:
109: PROCEDURE DELETE_SAMPLES
110: ( p_api_version IN NUMBER
111: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
112: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
113: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
114: , p_qc_samples_rec IN GMD_SAMPLES%ROWTYPE
115: , p_user_name IN VARCHAR2
108:
109: PROCEDURE DELETE_SAMPLES
110: ( p_api_version IN NUMBER
111: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
112: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
113: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
114: , p_qc_samples_rec IN GMD_SAMPLES%ROWTYPE
115: , p_user_name IN VARCHAR2
116: , x_return_status OUT NOCOPY VARCHAR2
109: PROCEDURE DELETE_SAMPLES
110: ( p_api_version IN NUMBER
111: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
112: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
113: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
114: , p_qc_samples_rec IN GMD_SAMPLES%ROWTYPE
115: , p_user_name IN VARCHAR2
116: , x_return_status OUT NOCOPY VARCHAR2
117: , x_msg_count OUT NOCOPY NUMBER