DBA Data[Home] [Help]

PACKAGE: APPS.GMS_PROJECT_FUNDINGS_PKG

Source


1 package GMS_PROJECT_FUNDINGS_PKG AUTHID CURRENT_USER as
2 -- $Header: gmsawpfs.pls 115.4 2002/11/26 12:48:06 mmalhotr ship $
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_GMS_PROJECT_FUNDING_ID in NUMBER,
6   X_PROJECT_FUNDING_ID in NUMBER,
7   X_PROJECT_ID in NUMBER,
8   X_TASK_ID in NUMBER,
9   X_INSTALLMENT_ID in NUMBER,
10   X_FUNDING_AMOUNT in NUMBER,
11   X_DATE_ALLOCATED in DATE,
12   X_MODE in VARCHAR2 default 'R'
13   );
14 procedure LOCK_ROW (
15   X_GMS_PROJECT_FUNDING_ID in NUMBER,
16   X_PROJECT_FUNDING_ID in NUMBER,
17   X_PROJECT_ID in NUMBER,
18   X_TASK_ID in NUMBER,
19   X_INSTALLMENT_ID in NUMBER,
20   X_FUNDING_AMOUNT in NUMBER,
21   X_DATE_ALLOCATED in DATE
22 );
23 procedure UPDATE_ROW (
24   X_GMS_PROJECT_FUNDING_ID in NUMBER,
25   X_PROJECT_FUNDING_ID in NUMBER,
26   X_PROJECT_ID in NUMBER,
27   X_TASK_ID in NUMBER,
28   X_INSTALLMENT_ID in NUMBER,
29   X_FUNDING_AMOUNT in NUMBER,
30   X_DATE_ALLOCATED in DATE,
31   X_MODE in VARCHAR2 default 'R'
32   );
33 procedure ADD_ROW (
34   X_ROWID in out NOCOPY VARCHAR2,
35   X_GMS_PROJECT_FUNDING_ID in NUMBER,
36   X_PROJECT_FUNDING_ID in NUMBER,
37   X_PROJECT_ID in NUMBER,
38   X_TASK_ID in NUMBER,
39   X_INSTALLMENT_ID in NUMBER,
40   X_FUNDING_AMOUNT in NUMBER,
41   X_DATE_ALLOCATED in DATE,
42   X_MODE in VARCHAR2 default 'R'
43   );
44 procedure DELETE_ROW (
45   X_GMS_PROJECT_FUNDING_ID in NUMBER
46 );
47 end GMS_PROJECT_FUNDINGS_PKG;