DBA Data[Home] [Help]

APPS.GMD_STABILITY_STUDIES_GRP dependencies on GMD_SS_TIME_POINTS

Line 141: FROM gmd_ss_time_points

137: END IF;
138:
139: SELECT SUM(samples_per_time_point) , SUM(DECODE(samples_per_time_point,NULL,0,1)) , SUM(1)
140: INTO l_tl_samples , l_tl_time_points_with_samples,l_tl_time_points
141: FROM gmd_ss_time_points
142: WHERE variant_id = cr_all_variants_rec.variant_id
143: AND delete_mark = 0 ;
144:
145: IF l_tl_time_points IS NULL THEN

Line 211: gmd_api_pub.log_message('GMD_SS_TIME_POINTS_NOT_DEF','VARIANT_NO',to_char(l_variant_no));

207: WHEN MISSING_TIME_POINTS THEN
208: IF cr_all_variants%ISOPEN THEN
209: CLOSE cr_all_variants;
210: END IF ;
211: gmd_api_pub.log_message('GMD_SS_TIME_POINTS_NOT_DEF','VARIANT_NO',to_char(l_variant_no));
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213:
214: WHEN MISSING_SAMPLE_TIME_POINT THEN
215: IF cr_all_variants%ISOPEN THEN