PACKAGE: APPS.GMO_UTILITIES

Source

1 PACKAGE GMO_UTILITIES AUTHID CURRENT_USER AS
2 /* $Header: GMOUTILS.pls 120.1 2005/11/09 02:33 bchopra noship $ */
3 
4 PROCEDURE GET_WHO_COLUMNS
5 (
6          x_creation_date     out nocopy date,
7          x_created_by        out nocopy number,
8          x_last_update_date  out nocopy date,
9          x_last_updated_by   out nocopy number,
10          x_last_update_login out nocopy number
11 );
12 
13 function GET_USER_DISPLAY_NAME (P_USER_NAME IN VARCHAR2) RETURN VARCHAR2;
14 
15 function GET_USER_DISPLAY_NAME (P_USER_ID IN NUMBER) RETURN VARCHAR2;
16 
17 PROCEDURE GET_USER_DISPLAY_NAME (P_USER_ID IN NUMBER, P_USER_DISPLAY_NAME OUT nocopy VARCHAR2);
18 
19 PROCEDURE GET_MFG_LOOKUP
20 (
21 	P_LOOKUP_TYPE IN VARCHAR2,
22         P_LOOKUP_CODE IN VARCHAR2,
23         P_MEANING     OUT NOCOPY VARCHAR2
24 );
25 
26 function GET_LOOKUP_MEANING (P_LOOKUP_TYPE IN VARCHAR2, P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2;
27 
28 PROCEDURE GET_LOOKUP
29 (
30         P_LOOKUP_TYPE IN VARCHAR2,
31         P_LOOKUP_CODE IN VARCHAR2,
32         X_MEANING     OUT NOCOPY VARCHAR2
33 );
34 
35 procedure get_organization (P_BATCH_ID IN NUMBER,
36                             X_ORG_ID OUT NOCOPY NUMBER,
37                             X_ORG_CODE OUT NOCOPY VARCHAR2,
38                             X_ORG_NAME OUT NOCOPY VARCHAR2);
39 
40 procedure get_organization (P_ORG_ID IN NUMBER,
41                             X_ORG_CODE OUT NOCOPY VARCHAR2,
42                             X_ORG_NAME OUT NOCOPY VARCHAR2);
43 
44 END GMO_UTILITIES;