[Home] [Help]
PACKAGE: APPS.GME_LAB_BATCH_LOTS_DBL
Source
1 PACKAGE GME_LAB_BATCH_LOTS_DBL AUTHID CURRENT_USER AS
2 /* $Header: GMEVGLBS.pls 120.0 2005/05/26 14:37:45 appldev noship $ */
3
4 /*============================================================================
5 | Copyright (c) 2001 Oracle Corporation
6 | TVP, Reading
7 | All rights reserved
8 =============================================================================
9 | FILENAME
10 | GMEVGLBS.pls
11 |
12 | DESCRIPTION
13 | This procedure is user to manipulate the GME_LAB_BATCH_LOTS table.
14 |
15 |
16 |
17 | NOTES
18 |
19 | HISTORY
20 | 12-MAR-01 Thomas Daniel Created
21 |
22 | - create_row
23 | - fetch_row
24 | - update_row
25 | - lock_row
26 |
27 |
28 =============================================================================
29 */
30
31
32 FUNCTION insert_row (
33 p_lab_batch_lots IN GME_LAB_BATCH_LOTS%ROWTYPE
34 , x_lab_batch_lots IN OUT NOCOPY GME_LAB_BATCH_LOTS%ROWTYPE) RETURN BOOLEAN;
35
36
37 FUNCTION fetch_row (
38 p_lab_batch_lots IN GME_LAB_BATCH_LOTS%ROWTYPE
39 , x_lab_batch_lots IN OUT NOCOPY GME_LAB_BATCH_LOTS%ROWTYPE) RETURN BOOLEAN;
40
41
42 FUNCTION delete_row (
43 p_lab_batch_lots IN GME_LAB_BATCH_LOTS%ROWTYPE) RETURN BOOLEAN;
44
45 FUNCTION update_row (
46 p_lab_batch_lots IN GME_LAB_BATCH_LOTS%ROWTYPE) RETURN BOOLEAN;
47
48 FUNCTION lock_row (
49 p_lab_batch_lots IN GME_LAB_BATCH_LOTS%ROWTYPE) RETURN BOOLEAN;
50
51 PROCEDURE delete_lab_lots (p_lab_batch_lots IN GME_LAB_BATCH_LOTS%ROWTYPE
52 ,x_return_status IN OUT NOCOPY VARCHAR2);
53
54 END GME_LAB_BATCH_LOTS_DBL;