[Home] [Help]
9: p_sample GMD_SAMPLES%ROWTYPE;
10: x_sample GMD_SAMPLES%ROWTYPE;
11: p_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
12: x_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
13: p_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
14: x_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
15: smp_cnt binary_integer;
16: l_reserve_cnt_req number := 0;
17: l_archive_cnt_req number := 0;
10: x_sample GMD_SAMPLES%ROWTYPE;
11: p_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
12: x_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
13: p_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
14: x_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
15: smp_cnt binary_integer;
16: l_reserve_cnt_req number := 0;
17: l_archive_cnt_req number := 0;
18: l_sample_cnt_req number := 0;
268: p_sample_spec_disp.created_by := FND_GLOBAL.USER_ID;
269: p_sample_spec_disp.last_update_date := sysdate;
270: p_sample_spec_disp.last_updated_by := FND_GLOBAL.USER_ID;
271:
272: IF not GMD_SAMPLE_SPEC_DISP_PVT.insert_row (
273: p_sample_spec_disp ) THEN
274: raise fnd_api.g_exc_error;
275: END IF;
276: --gml_sf_log('creating sample');
353: p_sample_spec_disp.sample_id := x_sample.sample_id;
354: p_sample_spec_disp.event_spec_disp_id := x_event_spec_disp.event_spec_disp_id;
355: p_sample_spec_disp.disposition := '0PL';
356:
357: IF not GMD_SAMPLE_SPEC_DISP_PVT.insert_row (
358: p_sample_spec_disp ) THEN
359: raise fnd_api.g_exc_error;
360: END IF;
361: END LOOP;
437: p_sample_spec_disp.sample_id := x_sample.sample_id;
438: p_sample_spec_disp.event_spec_disp_id := x_event_spec_disp.event_spec_disp_id;
439: p_sample_spec_disp.disposition := '0PL';
440:
441: IF not GMD_SAMPLE_SPEC_DISP_PVT.insert_row (
442: p_sample_spec_disp ) THEN
443: raise fnd_api.g_exc_error;
444: END IF;
445: END LOOP;