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

Line 1: PACKAGE BODY GMD_SAMPLING_EVENTS_PVT AS

1: PACKAGE BODY GMD_SAMPLING_EVENTS_PVT AS
2: /* $Header: GMDVSEVB.pls 120.3 2006/06/26 12:55:06 ragsriva noship $ */
3:
4: -- Start of comments
5: --+==========================================================================+

Line 11: --| Package Name : GMD_SAMPLING_EVENTS_PVT |

7: --| Redwood Shores, CA, USA |
8: --| All rights reserved. |
9: --+==========================================================================+
10: --| File Name : GMDVSEVB.pls |
11: --| Package Name : GMD_SAMPLING_EVENTS_PVT |
12: --| Type : Private |
13: --| |
14: --| Notes |
15: --| This package contains private layer APIs for Sampling Events |

Line 27: p_sampling_events IN GMD_SAMPLING_EVENTS%ROWTYPE

23: -- End of comments
24:
25:
26: FUNCTION insert_row (
27: p_sampling_events IN GMD_SAMPLING_EVENTS%ROWTYPE
28: , x_sampling_events OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE) RETURN BOOLEAN IS
29: BEGIN
30:
31: x_sampling_events := p_sampling_events;

Line 28: , x_sampling_events OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE) RETURN BOOLEAN IS

24:
25:
26: FUNCTION insert_row (
27: p_sampling_events IN GMD_SAMPLING_EVENTS%ROWTYPE
28: , x_sampling_events OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE) RETURN BOOLEAN IS
29: BEGIN
30:
31: x_sampling_events := p_sampling_events;
32:

Line 33: INSERT INTO GMD_SAMPLING_EVENTS

29: BEGIN
30:
31: x_sampling_events := p_sampling_events;
32:
33: INSERT INTO GMD_SAMPLING_EVENTS
34: (
35: SAMPLING_EVENT_ID
36: ,ORIGINAL_SPEC_VR_ID
37: ,ORGANIZATION_ID

Line 164: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'INSERT_ROW');

160: END IF;
161:
162: EXCEPTION
163: WHEN OTHERS THEN
164: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'INSERT_ROW');
165: RETURN FALSE;
166: END insert_row;
167:
168:

Line 184: FROM gmd_sampling_events

180: BEGIN
181: IF p_sampling_event_id IS NOT NULL THEN
182: SELECT 1
183: INTO dummy
184: FROM gmd_sampling_events
185: WHERE sampling_event_id = p_sampling_event_id
186: FOR UPDATE NOWAIT;
187:
188: DELETE gmd_sampling_events

Line 188: DELETE gmd_sampling_events

184: FROM gmd_sampling_events
185: WHERE sampling_event_id = p_sampling_event_id
186: FOR UPDATE NOWAIT;
187:
188: DELETE gmd_sampling_events
189: WHERE sampling_event_id = p_sampling_event_id
190: ;
191: ELSE
192: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

Line 192: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

188: DELETE gmd_sampling_events
189: WHERE sampling_event_id = p_sampling_event_id
190: ;
191: ELSE
192: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
193: RETURN FALSE;
194: END IF;
195:
196: IF (SQL%FOUND) THEN

Line 199: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

195:
196: IF (SQL%FOUND) THEN
197: RETURN TRUE;
198: ELSE
199: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
200: RETURN FALSE;
201: END IF;
202:
203: EXCEPTION

Line 206: 'TABLE_NAME', 'GMD_SAMPLING_EVENTS',

202:
203: EXCEPTION
204: WHEN locked_by_other_user THEN
205: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
206: 'TABLE_NAME', 'GMD_SAMPLING_EVENTS',
207: 'RECORD','Sampling Event',
208: 'KEY', p_sampling_event_id);
209: RETURN FALSE;
210:

Line 212: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'DELETE_ROW');

208: 'KEY', p_sampling_event_id);
209: RETURN FALSE;
210:
211: WHEN OTHERS THEN
212: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'DELETE_ROW');
213: RETURN FALSE;
214:
215: END delete_row;
216:

Line 232: FROM gmd_sampling_events

228: BEGIN
229: IF p_sampling_event_id IS NOT NULL THEN
230: SELECT 1
231: INTO dummy
232: FROM gmd_sampling_events
233: WHERE sampling_event_id = p_sampling_event_id
234: FOR UPDATE NOWAIT;
235: ELSE
236: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

Line 236: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

232: FROM gmd_sampling_events
233: WHERE sampling_event_id = p_sampling_event_id
234: FOR UPDATE NOWAIT;
235: ELSE
236: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
237: RETURN FALSE;
238: END IF;
239:
240: RETURN TRUE;

Line 245: 'TABLE_NAME', 'GMD_SAMPLING_EVENTS',

241:
242: EXCEPTION
243: WHEN locked_by_other_user THEN
244: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
245: 'TABLE_NAME', 'GMD_SAMPLING_EVENTS',
246: 'RECORD','Sampling Event',
247: 'KEY', p_sampling_event_id);
248: RETURN FALSE;
249:

Line 251: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'DELETE_ROW');

247: 'KEY', p_sampling_event_id);
248: RETURN FALSE;
249:
250: WHEN OTHERS THEN
251: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'DELETE_ROW');
252: RETURN FALSE;
253:
254: END lock_row;
255:

Line 259: p_sampling_events IN gmd_sampling_events%ROWTYPE

255:
256:
257:
258: FUNCTION fetch_row (
259: p_sampling_events IN gmd_sampling_events%ROWTYPE
260: , x_sampling_events OUT NOCOPY gmd_sampling_events%ROWTYPE
261: )
262: RETURN BOOLEAN
263: IS

Line 260: , x_sampling_events OUT NOCOPY gmd_sampling_events%ROWTYPE

256:
257:
258: FUNCTION fetch_row (
259: p_sampling_events IN gmd_sampling_events%ROWTYPE
260: , x_sampling_events OUT NOCOPY gmd_sampling_events%ROWTYPE
261: )
262: RETURN BOOLEAN
263: IS
264: BEGIN

Line 269: FROM gmd_sampling_events

265:
266: IF (p_sampling_events.sampling_event_id IS NOT NULL) THEN
267: SELECT *
268: INTO x_sampling_events
269: FROM gmd_sampling_events
270: WHERE sampling_event_id = p_sampling_events.sampling_event_id
271: ;
272: RETURN TRUE;
273: ELSE

Line 274: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

270: WHERE sampling_event_id = p_sampling_events.sampling_event_id
271: ;
272: RETURN TRUE;
273: ELSE
274: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
275: RETURN FALSE;
276: END IF;
277:
278: EXCEPTION

Line 281: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

277:
278: EXCEPTION
279: WHEN NO_DATA_FOUND
280: THEN
281: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
282: RETURN FALSE;
283: WHEN OTHERS
284: THEN
285: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'FETCH_ROW');

Line 285: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'FETCH_ROW');

281: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
282: RETURN FALSE;
283: WHEN OTHERS
284: THEN
285: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'FETCH_ROW');
286: RETURN FALSE;
287:
288: END fetch_row;
289:

Line 290: END GMD_SAMPLING_EVENTS_PVT;

286: RETURN FALSE;
287:
288: END fetch_row;
289:
290: END GMD_SAMPLING_EVENTS_PVT;
291: