APPS.GMD_QMSMC dependencies on GMD_SAMPLES

Line 408: gmd_Samples where

404:
405: /* Given a sampling event and a retain as, gets the sample numbers */
406: CURSOR get_sample_num (x_sampling_event_in number , x_retain_as_in varchar2) is
407: select sample_no from
408: gmd_Samples where
409: sampling_event_id = x_Sampling_event_in
410: and retain_as = x_retain_as_in ;
411: CURSOR get_reg_sample_num (x_sampling_event_in number , x_retain_as_in varchar2) is
412: select sample_no from

Line 413: gmd_Samples where

409: sampling_event_id = x_Sampling_event_in
410: and retain_as = x_retain_as_in ;
411: CURSOR get_reg_sample_num (x_sampling_event_in number , x_retain_as_in varchar2) is
412: select sample_no from
413: gmd_Samples where
414: sampling_event_id = x_Sampling_event_in
415: and retain_as is NULL ;
416:
417: CURSOR get_from_role is

Line 1035: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="' || l_sampling_events.sampling_event_id||'"';

1031: l_spec_vr_id,
1032: create_status );
1033:
1034: /* Sampling Event Successfully Created. Set Form Attribute to the sampling event */
1035: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="' || l_sampling_events.sampling_event_id||'"';
1036:
1037: /* If we created samples, show them */
1038: OPEN get_sample_num (l_sampling_events.sampling_event_id, 'R');
1039: FETCH get_sample_num into frsample_name ; /* Get the first */

Line 1415: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="'

1411:
1412:
1413: /* Sampling Event Successfully Created. Set Form Attribute
1414: to the sampling event */
1415: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="'
1416: || l_sampling_events.sampling_event_id||'"';
1417:
1418: /* If we created samples, show them */
1419: OPEN get_sample_num (l_sampling_events.sampling_event_id, 'R');

Line 2153: from gmd_Samples

2149:
2150: /* Given a sampling event and a retain as, gets the sample numbers */
2151: CURSOR get_sample_num (x_sampling_event_in number , x_retain_as varchar2) is
2152: select sample_no
2153: from gmd_Samples
2154: where sampling_event_id = x_Sampling_event_in
2155: and retain_as = x_retain_as ;
2156:
2157: CURSOR get_reg_sample_num (x_sampling_event_in number , x_retain_as_in varchar2) is

Line 2159: from gmd_Samples

2155: and retain_as = x_retain_as ;
2156:
2157: CURSOR get_reg_sample_num (x_sampling_event_in number , x_retain_as_in varchar2) is
2158: select sample_no
2159: from gmd_Samples
2160: where sampling_event_id = x_Sampling_event_in
2161: and retain_as is NULL ;
2162:
2163: CURSOR get_from_role is

Line 2451: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="'

2447: l_spec_vr_id,
2448: create_status );
2449: /* Sampling Event Successfully Created. Set Form Attribute
2450: to the sampling event */
2451: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="'
2452: || l_sampling_events.sampling_event_id||'"';
2453:
2454: /* If we created samples, show them */
2455: /* get the reserve sample names*/