PACKAGE: APPS.GME_LAB_BATCH_LOTS_DBL

Source

1 PACKAGE GME_LAB_BATCH_LOTS_DBL 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;