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 151: , x_sampling_events_rec OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE

147: , p_user_name IN VARCHAR2
148: , p_find_matching_spec IN VARCHAR2
149: , p_grade IN VARCHAR2 DEFAULT NULL --3431884
150: , x_qc_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE
151: , x_sampling_events_rec OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE
152: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
153: , x_event_spec_disp_rec OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
154: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
155: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab

Line 171: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;

167: l_qc_samples_rec GMD_SAMPLES%ROWTYPE;
168: l_qc_samples_out_rec GMD_SAMPLES%ROWTYPE;
169: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
170: l_event_spec_disp_rec GMD_EVENT_SPEC_DISP%ROWTYPE;
171: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
172: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
173: l_results_tab GMD_API_PUB.gmd_results_tab;
174: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
175: l_user_id NUMBER(15);

Line 172: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;

168: l_qc_samples_out_rec GMD_SAMPLES%ROWTYPE;
169: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
170: l_event_spec_disp_rec GMD_EVENT_SPEC_DISP%ROWTYPE;
171: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
172: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
173: l_results_tab GMD_API_PUB.gmd_results_tab;
174: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
175: l_user_id NUMBER(15);
176: l_assign_type NUMBER;

Line 604: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (

600:
601:
602: --dbms_output.put_line('before insert se row ');
603:
604: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (
605: p_sampling_events => l_sampling_events,
606: x_sampling_events => l_sampling_events_out) THEN
607: RAISE FND_API.G_EXC_ERROR;
608: END IF;

Line 624: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row

620:
621: -- bug# 2995114
622: l_sampling_event_exist := 'Y' ;
623:
624: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row
625: (
626: p_sampling_event_id => l_sampling_events.sampling_event_id
627: ) THEN
628: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 629: 'l_table_name', 'GMD_SAMPLING_EVENTS',

625: (
626: p_sampling_event_id => l_sampling_events.sampling_event_id
627: ) THEN
628: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
629: 'l_table_name', 'GMD_SAMPLING_EVENTS',
630: 'l_column_name','SAMPLING_EVENT_ID',
631: 'l_key_value', l_sampling_events.sampling_event_id);
632: RAISE FND_API.G_EXC_ERROR;
633: ELSE

Line 651: UPDATE GMD_SAMPLING_EVENTS

647: END IF;
648:
649: -- Update the sampling events Table
650: -- Bug 3401377: added archived_taken, reserved_taken to sampling event
651: UPDATE GMD_SAMPLING_EVENTS
652: SET SAMPLE_TAKEN_CNT = sample_taken_cnt + 1,
653: SAMPLE_ACTIVE_CNT = sample_active_cnt + l_sample_active_cnt ,
654: ARCHIVED_TAKEN = NVL(ARCHIVED_TAKEN, 0) + l_sampling_events.archived_taken ,
655: RESERVED_TAKEN = NVL(RESERVED_TAKEN, 0) + l_sampling_events.reserved_taken ,

Line 660: IF NOT GMD_SAMPLING_EVENTS_PVT.fetch_row(

656: LAST_UPDATED_BY = l_user_id,
657: LAST_UPDATE_DATE = l_date
658: WHERE SAMPLING_EVENT_ID = l_sampling_events.sampling_event_id;
659:
660: IF NOT GMD_SAMPLING_EVENTS_PVT.fetch_row(
661: p_sampling_events => l_sampling_events,
662: x_sampling_events => l_sampling_events_out) THEN
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;

Line 669: FROM GMD_SAMPLING_EVENTS

665:
666: -- Bug 2987571: make sure sample instance is saved to new sample
667: -- Select from the sampling events Table
668: SELECT sample_taken_cnt INTO l_qc_samples_rec.sample_instance
669: FROM GMD_SAMPLING_EVENTS
670: WHERE SAMPLING_EVENT_ID = l_sampling_events.sampling_event_id;
671:
672: END IF;
673:

Line 1363: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row

1359:
1360: IF l_qc_samples_out_rec.sample_disposition NOT IN ('0RT','7CN') THEN
1361:
1362: -- Lock Sampling event row
1363: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row
1364: ( p_sampling_event_id => l_qc_samples_out_rec.sampling_event_id
1365: ) THEN
1366: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1367: 'l_table_name', 'GMD_SAMPLING_EVENTS',

Line 1367: 'l_table_name', 'GMD_SAMPLING_EVENTS',

1363: IF NOT GMD_SAMPLING_EVENTS_PVT.lock_row
1364: ( p_sampling_event_id => l_qc_samples_out_rec.sampling_event_id
1365: ) THEN
1366: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1367: 'l_table_name', 'GMD_SAMPLING_EVENTS',
1368: 'l_column_name','SAMPLING_EVENT_ID',
1369: 'l_key_value', l_qc_samples_out_rec.sampling_event_id);
1370: RAISE FND_API.G_EXC_ERROR;
1371: ELSE

Line 1374: UPDATE GMD_SAMPLING_EVENTS

1370: RAISE FND_API.G_EXC_ERROR;
1371: ELSE
1372:
1373: -- Update the sampling events Table
1374: UPDATE GMD_SAMPLING_EVENTS
1375: SET SAMPLE_ACTIVE_CNT = sample_active_cnt -1,
1376: LAST_UPDATED_BY = l_user_id,
1377: LAST_UPDATE_DATE = SYSDATE
1378: WHERE SAMPLING_EVENT_ID = l_qc_samples_out_rec.sampling_event_id;

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

1474:
1475: -- bug# 3447280
1476: -- get lot_id if lot/sublot is specified.
1477: -- if lot and sublot both are specified without lot id
1478: -- and if new sampling event is created , lot id goes as NULL in gmd_sampling_events.
1479:
1480: -- Bug 4165704: This cursor is no longer needed
1481: --CURSOR c_item_sublot IS
1482: --SELECT lot_id

Line 2662: FROM gmd_sampling_events

2658: --AND delete_mark = 0;
2659:
2660: CURSOR c_sampling_event(p_sampling_event_id NUMBER) IS
2661: SELECT 1
2662: FROM gmd_sampling_events
2663: WHERE sampling_event_id = p_sampling_event_id
2664: ;
2665:
2666: -- Bug 4165704: changed for inventory convergence