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
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
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 (
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
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 (
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;
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:
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:
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:
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;
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;