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_PVT dependencies on GMD_SAMPLES

Line 1: PACKAGE BODY GMD_SAMPLES_PVT AS

1: PACKAGE BODY GMD_SAMPLES_PVT AS
2: /* $Header: GMDVSMPB.pls 120.2 2006/06/15 18:31:43 plowe noship $ */
3:
4: -- Start of comments
5: --+==========================================================================+

Line 11: --| Package Name : GMD_SAMPLES_PVT |

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

Line 45: p_samples IN GMD_SAMPLES%ROWTYPE

41: -- End of comments
42:
43:
44: FUNCTION insert_row (
45: p_samples IN GMD_SAMPLES%ROWTYPE
46: , x_samples OUT NOCOPY GMD_SAMPLES%ROWTYPE) RETURN BOOLEAN IS
47: BEGIN
48:
49: x_samples := p_samples;

Line 46: , x_samples OUT NOCOPY GMD_SAMPLES%ROWTYPE) RETURN BOOLEAN IS

42:
43:
44: FUNCTION insert_row (
45: p_samples IN GMD_SAMPLES%ROWTYPE
46: , x_samples OUT NOCOPY GMD_SAMPLES%ROWTYPE) RETURN BOOLEAN IS
47: BEGIN
48:
49: x_samples := p_samples;
50:

Line 51: INSERT INTO GMD_SAMPLES

47: BEGIN
48:
49: x_samples := p_samples;
50:
51: INSERT INTO GMD_SAMPLES
52: (
53: SAMPLE_ID
54: ,SAMPLE_NO
55: ,SAMPLE_DESC

Line 272: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'INSERT_ROW');

268: END IF;
269:
270: EXCEPTION
271: WHEN OTHERS THEN
272: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'INSERT_ROW');
273: RETURN FALSE;
274:
275: END insert_row;
276:

Line 297: FROM gmd_samples

293:
294: IF p_sample_id IS NOT NULL THEN
295: SELECT 1
296: INTO dummy
297: FROM gmd_samples
298: WHERE sample_id = p_sample_id
299: FOR UPDATE NOWAIT;
300:
301: UPDATE gmd_samples

Line 301: UPDATE gmd_samples

297: FROM gmd_samples
298: WHERE sample_id = p_sample_id
299: FOR UPDATE NOWAIT;
300:
301: UPDATE gmd_samples
302: SET delete_mark = 1,
303: last_updated_by = fnd_global.user_id,
304: last_update_date = SYSDATE
305: WHERE sample_id = p_sample_id

Line 311: FROM gmd_samples

307: ELSIF p_organization_id IS NOT NULL AND
308: p_sample_no IS NOT NULL THEN
309: SELECT 1
310: INTO dummy
311: FROM gmd_samples
312: WHERE organization_id = p_organization_id
313: AND sample_no = p_sample_no
314: FOR UPDATE NOWAIT;
315:

Line 316: UPDATE gmd_samples

312: WHERE organization_id = p_organization_id
313: AND sample_no = p_sample_no
314: FOR UPDATE NOWAIT;
315:
316: UPDATE gmd_samples
317: SET delete_mark = 1,
318: last_updated_by = fnd_global.user_id,
319: last_update_date = SYSDATE
320: WHERE organization_id = p_organization_id

Line 324: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');

320: WHERE organization_id = p_organization_id
321: AND sample_no = p_sample_no
322: ;
323: ELSE
324: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');
325: RETURN FALSE;
326: END IF;
327:
328: IF (SQL%FOUND) THEN

Line 331: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');

327:
328: IF (SQL%FOUND) THEN
329: RETURN TRUE;
330: ELSE
331: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');
332: RETURN FALSE;
333: END IF;
334:
335: EXCEPTION

Line 338: 'TABLE_NAME', 'GMD_SAMPLES',

334:
335: EXCEPTION
336: WHEN locked_by_other_user THEN
337: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
338: 'TABLE_NAME', 'GMD_SAMPLES',
339: 'RECORD','Sample',
340: 'KEY', p_organization_id || p_sample_no);
341: RETURN FALSE;
342:

Line 344: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'DELETE_ROW');

340: 'KEY', p_organization_id || p_sample_no);
341: RETURN FALSE;
342:
343: WHEN OTHERS THEN
344: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'DELETE_ROW');
345: RETURN FALSE;
346:
347: END delete_row;
348:

Line 367: FROM gmd_samples

363: BEGIN
364: IF p_sample_id IS NOT NULL THEN
365: SELECT 1
366: INTO dummy
367: FROM gmd_samples
368: WHERE sample_id = p_sample_id
369: FOR UPDATE NOWAIT;
370: ELSIF p_organization_id IS NOT NULL AND
371: p_sample_no IS NOT NULL THEN

Line 374: FROM gmd_samples

370: ELSIF p_organization_id IS NOT NULL AND
371: p_sample_no IS NOT NULL THEN
372: SELECT 1
373: INTO dummy
374: FROM gmd_samples
375: WHERE organization_id = p_organization_id
376: AND sample_no = p_sample_no
377: FOR UPDATE NOWAIT;
378: ELSE

Line 379: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');

375: WHERE organization_id = p_organization_id
376: AND sample_no = p_sample_no
377: FOR UPDATE NOWAIT;
378: ELSE
379: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');
380: RETURN FALSE;
381: END IF;
382:
383: RETURN TRUE;

Line 388: 'TABLE_NAME', 'GMD_SAMPLES',

384:
385: EXCEPTION
386: WHEN locked_by_other_user THEN
387: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
388: 'TABLE_NAME', 'GMD_SAMPLES',
389: 'RECORD','Sampling Event',
390: 'KEY', p_organization_id || p_sample_no);
391: RETURN FALSE;
392:

Line 394: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'DELETE_ROW');

390: 'KEY', p_organization_id || p_sample_no);
391: RETURN FALSE;
392:
393: WHEN OTHERS THEN
394: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'DELETE_ROW');
395: RETURN FALSE;
396:
397: END lock_row;
398:

Line 402: p_samples IN gmd_samples%ROWTYPE

398:
399:
400:
401: FUNCTION fetch_row (
402: p_samples IN gmd_samples%ROWTYPE
403: , x_samples OUT NOCOPY gmd_samples%ROWTYPE
404: )
405: RETURN BOOLEAN
406: IS

Line 403: , x_samples OUT NOCOPY gmd_samples%ROWTYPE

399:
400:
401: FUNCTION fetch_row (
402: p_samples IN gmd_samples%ROWTYPE
403: , x_samples OUT NOCOPY gmd_samples%ROWTYPE
404: )
405: RETURN BOOLEAN
406: IS
407: BEGIN

Line 412: FROM gmd_samples

408:
409: IF (p_samples.sample_id IS NOT NULL) THEN
410: SELECT *
411: INTO x_samples
412: FROM gmd_samples
413: WHERE sample_id = p_samples.sample_id
414: ;
415: RETURN TRUE;
416:

Line 421: FROM gmd_samples

417: ELSIF (p_samples.organization_id IS NOT NULL AND
418: p_samples.sample_no IS NOT NULL) THEN
419: SELECT *
420: INTO x_samples
421: FROM gmd_samples
422: WHERE organization_id = p_samples.organization_id
423: AND sample_no = p_samples.sample_no
424: ;
425: RETURN TRUE;

Line 427: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');

423: AND sample_no = p_samples.sample_no
424: ;
425: RETURN TRUE;
426: ELSE
427: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');
428: RETURN FALSE;
429: END IF;
430:
431: RETURN FALSE;

Line 436: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');

432:
433: EXCEPTION
434: WHEN NO_DATA_FOUND
435: THEN
436: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');
437: RETURN FALSE;
438: WHEN OTHERS
439: THEN
440: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'FETCH_ROW');

Line 440: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'FETCH_ROW');

436: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');
437: RETURN FALSE;
438: WHEN OTHERS
439: THEN
440: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'FETCH_ROW');
441: RETURN FALSE;
442:
443: END fetch_row;
444:

Line 445: END GMD_SAMPLES_PVT;

441: RETURN FALSE;
442:
443: END fetch_row;
444:
445: END GMD_SAMPLES_PVT;