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_SAMPLES_PUB dependencies on GMD_SAMPLING_EVENTS

Line 160: , x_sampling_events_rec OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE

156: , p_grade IN VARCHAR2 DEFAULT NULL --3431884
157: , p_lpn IN VARCHAR2 DEFAULT NULL -- 7027149
158: , p_create_new_sample_group IN VARCHAR2 -- 12846165
159: , x_qc_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE
160: , x_sampling_events_rec OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE
161: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
162: , x_event_spec_disp_rec OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
163: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
164: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab

Line 180: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;

176: l_qc_samples_rec GMD_SAMPLES%ROWTYPE;
177: l_qc_samples_out_rec GMD_SAMPLES%ROWTYPE;
178: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
179: l_event_spec_disp_rec GMD_EVENT_SPEC_DISP%ROWTYPE;
180: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
181: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
182: l_results_tab GMD_API_PUB.gmd_results_tab;
183: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
184: l_user_id NUMBER(15);

Line 181: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;

177: l_qc_samples_out_rec GMD_SAMPLES%ROWTYPE;
178: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
179: l_event_spec_disp_rec GMD_EVENT_SPEC_DISP%ROWTYPE;
180: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
181: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
182: l_results_tab GMD_API_PUB.gmd_results_tab;
183: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
184: l_user_id NUMBER(15);
185: l_assign_type NUMBER;

Line 688: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (

684:
685:
686: --dbms_output.put_line('before insert se row ');
687:
688: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (
689: p_sampling_events => l_sampling_events,
690: x_sampling_events => l_sampling_events_out) THEN
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;

Line 708: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row

704:
705: -- bug# 2995114
706: l_sampling_event_exist := 'Y' ;
707:
708: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row
709: (
710: p_sampling_event_id => l_sampling_events.sampling_event_id
711: ) THEN
712: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 713: 'l_table_name', 'GMD_SAMPLING_EVENTS',

709: (
710: p_sampling_event_id => l_sampling_events.sampling_event_id
711: ) THEN
712: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
713: 'l_table_name', 'GMD_SAMPLING_EVENTS',
714: 'l_column_name','SAMPLING_EVENT_ID',
715: 'l_key_value', l_sampling_events.sampling_event_id);
716: RAISE FND_API.G_EXC_ERROR;
717: ELSE

Line 735: UPDATE GMD_SAMPLING_EVENTS

731: END IF;
732:
733: -- Update the sampling events Table
734: -- Bug 3401377: added archived_taken, reserved_taken to sampling event
735: UPDATE GMD_SAMPLING_EVENTS
736: SET SAMPLE_TAKEN_CNT = sample_taken_cnt + 1,
737: SAMPLE_ACTIVE_CNT = sample_active_cnt + l_sample_active_cnt ,
738: ARCHIVED_TAKEN = NVL(ARCHIVED_TAKEN, 0) + l_sampling_events.archived_taken ,
739: RESERVED_TAKEN = NVL(RESERVED_TAKEN, 0) + l_sampling_events.reserved_taken ,

Line 744: IF NOT GMD_SAMPLING_EVENTS_PVT.fetch_row(

740: LAST_UPDATED_BY = l_user_id,
741: LAST_UPDATE_DATE = l_date
742: WHERE SAMPLING_EVENT_ID = l_sampling_events.sampling_event_id;
743:
744: IF NOT GMD_SAMPLING_EVENTS_PVT.fetch_row(
745: p_sampling_events => l_sampling_events,
746: x_sampling_events => l_sampling_events_out) THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;

Line 753: FROM GMD_SAMPLING_EVENTS

749:
750: -- Bug 2987571: make sure sample instance is saved to new sample
751: -- Select from the sampling events Table
752: SELECT sample_taken_cnt INTO l_qc_samples_rec.sample_instance
753: FROM GMD_SAMPLING_EVENTS
754: WHERE SAMPLING_EVENT_ID = l_sampling_events.sampling_event_id;
755:
756: END IF;
757:

Line 1447: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row

1443:
1444: IF l_qc_samples_out_rec.sample_disposition NOT IN ('0RT','7CN') THEN
1445:
1446: -- Lock Sampling event row
1447: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row
1448: ( p_sampling_event_id => l_qc_samples_out_rec.sampling_event_id
1449: ) THEN
1450: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1451: 'l_table_name', 'GMD_SAMPLING_EVENTS',

Line 1451: 'l_table_name', 'GMD_SAMPLING_EVENTS',

1447: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row
1448: ( p_sampling_event_id => l_qc_samples_out_rec.sampling_event_id
1449: ) THEN
1450: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1451: 'l_table_name', 'GMD_SAMPLING_EVENTS',
1452: 'l_column_name','SAMPLING_EVENT_ID',
1453: 'l_key_value', l_qc_samples_out_rec.sampling_event_id);
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSE

Line 1458: UPDATE GMD_SAMPLING_EVENTS

1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSE
1456:
1457: -- Update the sampling events Table
1458: UPDATE GMD_SAMPLING_EVENTS
1459: SET SAMPLE_ACTIVE_CNT = sample_active_cnt -1,
1460: LAST_UPDATED_BY = l_user_id,
1461: LAST_UPDATE_DATE = SYSDATE
1462: WHERE SAMPLING_EVENT_ID = l_qc_samples_out_rec.sampling_event_id;

Line 1562: -- and if new sampling event is created , lot id goes as NULL in gmd_sampling_events.

1558:
1559: -- bug# 3447280
1560: -- get lot_id if lot/sublot is specified.
1561: -- if lot and sublot both are specified without lot id
1562: -- and if new sampling event is created , lot id goes as NULL in gmd_sampling_events.
1563:
1564: -- Bug 4165704: This cursor is no longer needed
1565: --CURSOR c_item_sublot IS
1566: --SELECT lot_id

Line 2792: FROM gmd_sampling_events

2788: --AND delete_mark = 0;
2789:
2790: CURSOR c_sampling_event(p_sampling_event_id NUMBER) IS
2791: SELECT 1
2792: FROM gmd_sampling_events
2793: WHERE sampling_event_id = p_sampling_event_id
2794: ;
2795:
2796: -- Bug 4165704: changed for inventory convergence