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 2007/10/24 04:40:21 smalluru 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 448: update gmd_sampling_events

444: END IF;
445: END LOOP;
446:
447: /* Update the sampling event samples taken */
448: update gmd_sampling_events
449: set SAMPLE_TAKEN_CNT = 0
450: where sampling_event_id = x_sampling_event.sampling_event_id ;
451:
452: update gmd_sampling_events

Line 452: update gmd_sampling_events

448: update gmd_sampling_events
449: set SAMPLE_TAKEN_CNT = 0
450: where sampling_event_id = x_sampling_event.sampling_event_id ;
451:
452: update gmd_sampling_events
453: set ARCHIVED_TAKEN = 0
454: where sampling_event_id = x_sampling_event.sampling_event_id ;
455:
456: update gmd_sampling_events

Line 456: update gmd_sampling_events

452: update gmd_sampling_events
453: set ARCHIVED_TAKEN = 0
454: where sampling_event_id = x_sampling_event.sampling_event_id ;
455:
456: update gmd_sampling_events
457: set RESERVED_TAKEN = 0
458: where sampling_event_id = x_sampling_event.sampling_event_id ;
459:
460: update gmd_sampling_events

Line 460: update gmd_sampling_events

456: update gmd_sampling_events
457: set RESERVED_TAKEN = 0
458: where sampling_event_id = x_sampling_event.sampling_event_id ;
459:
460: update gmd_sampling_events
461: set SAMPLE_REQ_CNT = l_sample_cnt_req
462: where sampling_event_id = x_sampling_event.sampling_event_id ;
463:
464: /* Update the sampling event disposition to Planned */

Line 465: update gmd_sampling_events

461: set SAMPLE_REQ_CNT = l_sample_cnt_req
462: where sampling_event_id = x_sampling_event.sampling_event_id ;
463:
464: /* Update the sampling event disposition to Planned */
465: update gmd_sampling_events
466: set disposition = '0PL'
467: where sampling_event_id = x_sampling_event.sampling_event_id ;
468: --gml_sf_log('return success - created samples');
469: