APPS.GMD_QMSMC dependencies on GMD_SAMPLES

Line 502: from gmd_Samples

498:
499: /* Given a sampling event and a retain as, gets the sample numbers */
500: CURSOR get_sample_num(x_sampling_event_in number, x_retain_as_in varchar2) is
501: select sample_no
502: from gmd_Samples
503: where sampling_event_id = x_Sampling_event_in
504: and retain_as = x_retain_as_in;
505: CURSOR get_reg_sample_num(x_sampling_event_in number, x_retain_as_in varchar2) is
506: select sample_no

Line 507: from gmd_Samples

503: where sampling_event_id = x_Sampling_event_in
504: and retain_as = x_retain_as_in;
505: CURSOR get_reg_sample_num(x_sampling_event_in number, x_retain_as_in varchar2) is
506: select sample_no
507: from gmd_Samples
508: where sampling_event_id = x_Sampling_event_in
509: and retain_as is NULL;
510:
511: CURSOR get_from_role is

Line 1199: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="' ||

1195: l_spec_vr_id,
1196: create_status);
1197:
1198: /* Sampling Event Successfully Created. Set Form Attribute to the sampling event */
1199: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="' ||
1200: l_sampling_events.sampling_event_id || '"';
1201:
1202: /* If we created samples, show them */
1203: OPEN get_sample_num(l_sampling_events.sampling_event_id, 'R');

Line 1589: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="' ||

1585: END IF;
1586:
1587: /* Sampling Event Successfully Created. Set Form Attribute
1588: to the sampling event */
1589: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="' ||
1590: l_sampling_events.sampling_event_id || '"';
1591:
1592: /* If we created samples, show them */
1593: OPEN get_sample_num(l_sampling_events.sampling_event_id, 'R');

Line 2417: from gmd_Samples

2413:
2414: /* Given a sampling event and a retain as, gets the sample numbers */
2415: CURSOR get_sample_num(x_sampling_event_in number, x_retain_as varchar2) is
2416: select sample_no
2417: from gmd_Samples
2418: where sampling_event_id = x_Sampling_event_in
2419: and retain_as = x_retain_as;
2420:
2421: CURSOR get_reg_sample_num(x_sampling_event_in number, x_retain_as_in varchar2) is

Line 2423: from gmd_Samples

2419: and retain_as = x_retain_as;
2420:
2421: CURSOR get_reg_sample_num(x_sampling_event_in number, x_retain_as_in varchar2) is
2422: select sample_no
2423: from gmd_Samples
2424: where sampling_event_id = x_Sampling_event_in
2425: and retain_as is NULL;
2426:
2427: CURSOR get_from_role is

Line 2814: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="' ||

2810: l_spec_vr_id,
2811: create_status);
2812: /* Sampling Event Successfully Created. Set Form Attribute
2813: to the sampling event */
2814: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="' ||
2815: l_sampling_events.sampling_event_id || '"';
2816:
2817: /* If we created samples, show them */
2818: /* get the reserve sample names*/