DBA Data[Home] [Help]

PACKAGE: APPS.GMS_REFERENCE_NUMBERS_PKG

Source


1 package  GMS_REFERENCE_NUMBERS_PKG as
2 -- $Header: gmsawrfs.pls 120.1 2005/07/26 14:20:55 appldev ship $
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_AWARD_ID in NUMBER,
6   X_TYPE in VARCHAR2,
7   X_VALUE in VARCHAR2,
8   X_REQUIRED_FLAG in VARCHAR2,
9   X_MODE in VARCHAR2 default 'R'
10   );
11 procedure LOCK_ROW (
12   X_AWARD_ID in NUMBER,
13   X_TYPE in VARCHAR2,
14   X_VALUE in VARCHAR2,
15   X_REQUIRED_FLAG in VARCHAR2,
16   X_ROWID in VARCHAR2  -- Bug 2652987, Added
17 );
18 procedure UPDATE_ROW (
19   X_ROW_ID in VARCHAR2,
20   X_AWARD_ID in NUMBER,
21   X_TYPE in VARCHAR2,
22   X_VALUE in VARCHAR2,
23   X_REQUIRED_FLAG in VARCHAR2,
24   X_MODE in VARCHAR2 default 'R'
25   );
26 procedure ADD_ROW (
27   X_ROWID in out NOCOPY VARCHAR2,
28   X_AWARD_ID in NUMBER,
29   X_TYPE in VARCHAR2,
30   X_VALUE in VARCHAR2,
31   X_REQUIRED_FLAG in VARCHAR2,
32   X_MODE in VARCHAR2 default 'R'
33   );
34 procedure DELETE_ROW (
35   X_AWARD_ID in NUMBER,
36   X_TYPE in VARCHAR2,
37   X_VALUE in VARCHAR2, -- Bug 2652987, Added
38   X_ROWID in VARCHAR2 -- Bug 2652987, Added
39  );
40 end GMS_REFERENCE_NUMBERS_PKG;