APPS.GMD_AUTO_SAMPLE_PKG dependencies on GMD_SAMPLING_EVENTS

Line 4: PROCEDURE create_samples (x_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE,

1: PACKAGE BODY GMD_AUTO_SAMPLE_PKG AS
2: /* $Header: GMDQMASB.pls 120.7.12020000.2 2012/07/17 10:09:59 mtou ship $ */
3:
4: PROCEDURE create_samples (x_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE,
5: L_spec_id number,
6: L_spec_vr_id number,
7: X_return_status OUT NOCOPY varchar2) IS
8:

Line 458: update gmd_sampling_events

454: END IF;
455: END LOOP;
456:
457: /* Update the sampling event samples taken */
458: update gmd_sampling_events
459: set SAMPLE_TAKEN_CNT = 0
460: where sampling_event_id = x_sampling_event.sampling_event_id ;
461:
462: update gmd_sampling_events

Line 462: update gmd_sampling_events

458: update gmd_sampling_events
459: set SAMPLE_TAKEN_CNT = 0
460: where sampling_event_id = x_sampling_event.sampling_event_id ;
461:
462: update gmd_sampling_events
463: set ARCHIVED_TAKEN = 0
464: where sampling_event_id = x_sampling_event.sampling_event_id ;
465:
466: update gmd_sampling_events

Line 466: update gmd_sampling_events

462: update gmd_sampling_events
463: set ARCHIVED_TAKEN = 0
464: where sampling_event_id = x_sampling_event.sampling_event_id ;
465:
466: update gmd_sampling_events
467: set RESERVED_TAKEN = 0
468: where sampling_event_id = x_sampling_event.sampling_event_id ;
469:
470: update gmd_sampling_events

Line 470: update gmd_sampling_events

466: update gmd_sampling_events
467: set RESERVED_TAKEN = 0
468: where sampling_event_id = x_sampling_event.sampling_event_id ;
469:
470: update gmd_sampling_events
471: set SAMPLE_REQ_CNT = l_sample_cnt_req
472: where sampling_event_id = x_sampling_event.sampling_event_id ;
473:
474: /* Update the sampling event disposition to Planned */

Line 475: update gmd_sampling_events

471: set SAMPLE_REQ_CNT = l_sample_cnt_req
472: where sampling_event_id = x_sampling_event.sampling_event_id ;
473:
474: /* Update the sampling event disposition to Planned */
475: update gmd_sampling_events
476: set disposition = '0PL'
477: where sampling_event_id = x_sampling_event.sampling_event_id ;
478: --gml_sf_log('return success - created samples');
479: