DBA Data[Home] [Help]

PACKAGE: APPS.GME_MATERIAL_DETAILS_DBL

Source


1 PACKAGE gme_material_details_dbl AUTHID CURRENT_USER AS
2 /*  $Header: GMEVGMDS.pls 120.1.12010000.2 2009/02/27 20:17:53 gmurator ship $    */
3 /* ===========================================================================
4  |                Copyright (c) 2001 Oracle Corporation                    |
5  |                        TVP, Reading, England                            |
6  |                         All rights reserved                             |
7  ===========================================================================
8  |  FILENAME                                                               |
9  |      GMEVBHMS.pls                                                       |
10  |                                                                         |
11  |  DESCRIPTION                                                            |
12  |                                                                         |
13  |      Spec of package gme_material_details_dbl                           |
14  |                                                                         |
15  |  NOTES                                                                  |
16  |                                                                         |
17  |  HISTORY                                                                |
18  |                                                                         |
19  |  13-Feb-01 Created                                                      |
20  |                                                                         |
21  |             - create_row                                                |
22  |             - fetch_row                                                 |
23  |             - delete_row                                                |
24  |             - update_row                                                |
25  |             - fetch_tab                                                 |
26  |                                                                         |
27  |                                                                         |
28  |                                                                         |
29     G. Muratore   26-Feb-2009  Bug 7710435
30        Added Called by parameter to avoid timestamp failures during
31        batch creation. FUNCTION: update_row
32  ===========================================================================
33 */
34    FUNCTION insert_row (
35       p_material_detail   IN              gme_material_details%ROWTYPE
36      ,x_material_detail   IN OUT NOCOPY   gme_material_details%ROWTYPE)
37       RETURN BOOLEAN;
38 
39    FUNCTION fetch_row (
40       p_material_detail   IN              gme_material_details%ROWTYPE
41      ,x_material_detail   IN OUT NOCOPY   gme_material_details%ROWTYPE)
42       RETURN BOOLEAN;
43 
44    FUNCTION delete_row (p_material_detail IN gme_material_details%ROWTYPE)
45       RETURN BOOLEAN;
46 
47    FUNCTION update_row (p_material_detail IN gme_material_details%ROWTYPE
48                        ,p_called_by IN VARCHAR2 DEFAULT 'U')
49       RETURN BOOLEAN;
50 
51    FUNCTION fetch_tab (
52       p_material_detail   IN              gme_material_details%ROWTYPE
53      ,x_material_detail   IN OUT NOCOPY   gme_common_pvt.material_details_tab)
54       RETURN BOOLEAN;
55 END;