PACKAGE: APPS.GMA_GLOBAL_GRP

Source

1 PACKAGE GMA_GLOBAL_GRP AUTHID CURRENT_USER AS
2 -- $Header: GMAGGBLS.pls 115.8 2002/11/20 21:47:10 jbaird ship $
3 -- +=========================================================================+
4 -- |                Copyright (c) 1998 Oracle Corporation                    |
5 -- |                        TVP, Reading, England                            |
6 -- |                         All rights reserved                             |
7 -- +=========================================================================+
8 -- | FILENAME                                                                |
9 -- |     GMAGGBLS.pls                                                        |
10 -- |                                                                         |
11 -- | DESCRIPTION                                                             |
12 -- |     This package contains system-wide global functions and              |
13 -- |     procedures.                                                         |
14 -- |                                                                         |
15 -- | HISTORY                                                                 |
16 -- |     01-OCT-1998  M.Godfrey       Created                                |
17 -- |     15-FEB-1999  M.Godfrey       Upgrade to R11.                        |
18 -- |     21-Aug-1999  ppsriniv        Added the missing 'E' in 'REPLACE'.    |
19 -- |     02-Mar-2000  Liz Enstone     Bug 1196561 SY$MIN_DATE and SY$MAX_    |
20 -- |                                  DATE were hard-coded. Changed to call  |
21 -- |                                  to GMA_CORE_PKG.GET_DATE_CONSTANT      |
22 -- |     01-NOV-2002  RTARDIO         Added NOCOPY for bug 2650392           |
23 -- |     11-Nov-2002  Jeff Baird      Bug #2651809 Correct the format of the |
24 -- |                                  SY$MIN_DATE and SY$MAX_DATE profiles.  |
25 -- |     19-Nov-2002  Jeff Baird      Bug #2626977 Changed function name for |
26 -- |                                  the call to get the date constants.    |
27 -- +=========================================================================+
28 --  API Name  : GMA_GLOBAL_GRP
29 --  Type      : Group
30 --  Function  : This package contains system-wide global functions and
31 --              procedures
32 --  Pre-reqs  : N/A
33 --  Parameters: Per function
34 --
35 --  Current Vers  : 2.0
36 --
37 --  Previous Vers : 1.0
38 --
39 --  Initial Vers  : 1.0
40 --  Notes
41 --
42 
43 SY$MIN_DATE CONSTANT DATE := gma_core_pkg.get_date_constant_d('SY$MIN_DATE');
44 SY$MAX_DATE CONSTANT DATE := gma_core_pkg.get_date_constant_d('SY$MAX_DATE');
45 -- Bug #2651809 (JKB) Changed format above.
46 -- Bug #2626977 (JKB) Changed function name above.
47 
48 FUNCTION Get_doc_no
49 ( p_doc_type    IN sy_docs_seq.doc_type%TYPE
50 , p_orgn_code   IN sy_docs_seq.orgn_code%TYPE
51 )
52 RETURN VARCHAR2;
53 
54 PROCEDURE Get_Reason_Code
55 ( p_reason_code  IN sy_reas_cds.reason_code%TYPE
56 , x_sy_reas_cds  OUT NOCOPY sy_reas_cds%ROWTYPE
57 );
58 
59 PROCEDURE Get_Who
60 ( p_user_name    IN fnd_user.user_name%TYPE
61 , x_user_id      OUT NOCOPY fnd_user.user_id%TYPE
62 );
63 
64 END GMA_GLOBAL_GRP;