eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_AUTO_SAMPLE_PKG dependencies on GMD_SAMPLES

Line 9: p_sample GMD_SAMPLES%ROWTYPE;

5: L_spec_id number,
6: L_spec_vr_id number,
7: X_return_status OUT NOCOPY varchar2) IS
8:
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;

Line 10: x_sample GMD_SAMPLES%ROWTYPE;

6: L_spec_vr_id number,
7: X_return_status OUT NOCOPY varchar2) IS
8:
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;

Line 33: --QZENG Bug 13089703: cut length of item_desc to 80 to support sample_desc Varchar2(80) in table GMD_SAMPLES

29: cursor get_item_desc (x_inventory_item_id number) is
30: --select nvl(item_desc1, '')
31: --from ic_item_mst
32: --where item_id = x_item_id_in ;
33: --QZENG Bug 13089703: cut length of item_desc to 80 to support sample_desc Varchar2(80) in table GMD_SAMPLES
34: SELECT substrb(nvl(description, ''),1,80)
35: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
36: --FROM mtl_system_items_b_kfv
37: FROM mtl_system_items_vl

Line 268: IF not GMD_SAMPLES_PVT.insert_row (

264: fetch get_item_desc into p_sample.sample_desc ;
265: close get_item_desc;
266:
267: p_sample.sample_instance := sample_instance;
268: IF not GMD_SAMPLES_PVT.insert_row (
269: p_sample, x_sample ) THEN
270: raise fnd_api.g_exc_error;
271: END IF;
272:

Line 358: IF not GMD_SAMPLES_PVT.insert_row (

354: p_sample.sample_instance := sample_instance;
355: p_sample.retain_as := 'A' ;
356: p_sample.sample_disposition := '0PL' ;
357:
358: IF not GMD_SAMPLES_PVT.insert_row (
359: p_sample, x_sample ) THEN
360: raise fnd_api.g_exc_error;
361: END IF;
362:

Line 442: IF not GMD_SAMPLES_PVT.insert_row (

438: p_sample.sample_instance := sample_instance;
439: p_sample.retain_as := 'R' ;
440: p_sample.sample_disposition := '0PL' ;
441:
442: IF not GMD_SAMPLES_PVT.insert_row (
443: p_sample, x_sample ) THEN
444: raise fnd_api.g_exc_error;
445: END IF;
446: