1 PACKAGE gmo_preferences_pvt AS
2 /* $Header: GMOVPRFS.pls 120.1 2007/06/21 06:16:00 rvsingh noship $ */
3
4 /* This procedure is called from GMO preferences java static utility to fetch
5 * the GMO prefernces defined/set by administrattor*/
6 PROCEDURE GET_APPLICABLE_PREFERENCE(P_RESPONSIBILITY_ID IN NUMBER,
7 P_USER_ID IN NUMBER,
8 P_ORGANIZATION_ID IN NUMBER,
9 P_MODULE_NAME IN VARCHAR2,
10 X_TIME_RANGE OUT NOCOPY VARCHAR2,
11 X_NO_OF_DAYS OUT NOCOPY NUMBER,
12 X_ROLLING_FLAG OUT NOCOPY VARCHAR2,
13 X_ENFORCE_CERTIFICATE_FLAG OUT NOCOPY VARCHAR2,
14 X_DISPENSE_AREA OUT NOCOPY VARCHAR2,
15 X_DISPENSE_ORGANIZATION OUT NOCOPY NUMBER,
16 X_DISPENSE_BOOTH OUT NOCOPY VARCHAR2,
17 X_DISPENSE_MODE OUT NOCOPY VARCHAR2,
18 X_PRINT_PALLET_LABEL_FLAG OUT NOCOPY VARCHAR2,
19 X_PRINT_MTL_LABEL_FLAG OUT NOCOPY VARCHAR2,
20 X_PRINT_DSP_LABEL_FLAG OUT NOCOPY VARCHAR2,
21 X_DEFAULT_DEVICE OUT NOCOPY NUMBER,
22 X_DEFAULT_SOURCE_DEVICE OUT NOCOPY NUMBER,
23 X_DEFAULT_TARGET_DEVICE OUT NOCOPY NUMBER,
24 X_DEFAULT_RESOURCE OUT NOCOPY VARCHAR2
25 );
26
27 end gmo_preferences_pvt;