DBA Data[Home] [Help]

APPS.GMD_SS_WFLOW_GRP dependencies on GMD_SAMPLING_EVENTS

Line 90: p_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

86: p_spec_id IN number,
87: x_sampling_event_id OUT NOCOPY number,
88: x_return_status OUT NOCOPY varchar2)
89: IS
90: p_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
91: x_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
92: p_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
93: x_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
94:

Line 91: x_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

87: x_sampling_event_id OUT NOCOPY number,
88: x_return_status OUT NOCOPY varchar2)
89: IS
90: p_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
91: x_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
92: p_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
93: x_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
94:
95: CURSOR c_get_variant IS

Line 163: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (

159: p_event_spec_disp.creation_date := sysdate;
160: p_event_spec_disp.created_by := ss_rec.created_by;
161: p_event_spec_disp.last_update_date := sysdate;
162: p_event_spec_disp.last_updated_by := ss_rec.created_by;
163: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (
164: p_sampling_event,
165: x_sampling_event ) THEN
166: raise fnd_api.g_exc_error;
167: END IF;

Line 216: p_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

212: l_spec_vr_id number;
213: l_msg varchar2(100);
214: p_sample GMD_SAMPLES%ROWTYPE;
215: x_sample GMD_SAMPLES%ROWTYPE;
216: p_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
217: x_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
218: p_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
219: x_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
220: p_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;

Line 217: x_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

213: l_msg varchar2(100);
214: p_sample GMD_SAMPLES%ROWTYPE;
215: x_sample GMD_SAMPLES%ROWTYPE;
216: p_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
217: x_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
218: p_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
219: x_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
220: p_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
221: x_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;

Line 280: ( select 'x' from gmd_sampling_events gse

276: CURSOR cr_sampling_event_created IS
277: SELECT 'X' FROM gmd_ss_variants gsv
278: where gsv.ss_id = p_ss_id
279: and exists
280: ( select 'x' from gmd_sampling_events gse
281: where gse.variant_id = gsv.variant_id ) ;
282:
283: l_temp VARCHAR2(1);
284:

Line 438: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (

434: p_sampling_event.sample_req_cnt :=
435: var_rec.retained_samples;
436: --p_sampling_event.sample_active_cnt := var_rec.retained_samples;
437: p_sampling_event.sample_active_cnt := 0;
438: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (
439: p_sampling_event,
440: x_sampling_event ) THEN
441: raise fnd_api.g_exc_error;
442: END IF;

Line 533: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (

529: p_sampling_event.time_point_id :=
530: tp_rec.time_point_id;
531: p_sample.time_point_id := tp_rec.time_point_id;
532:
533: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (
534: p_sampling_event,
535: x_sampling_event ) THEN
536: raise fnd_api.g_exc_error;
537: END IF;

Line 631: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (

627:
628: --Bug#3583257
629: p_sampling_event.time_point_id := NULL;
630:
631: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (
632: p_sampling_event,
633: x_sampling_event ) THEN
634: raise fnd_api.g_exc_error;
635: END IF;