PACKAGE: APPS.GMS_PERSONNEL_PKG

Source

1 package  GMS_PERSONNEL_PKG as
2 -- $Header: gmsawpls.pls 120.1 2005/07/26 14:20:51 appldev ship $
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PERSONNEL_ID in NUMBER,
6   X_AWARD_ID in NUMBER,
7   X_PERSON_ID in NUMBER,
8   X_AWARD_ROLE in VARCHAR2,
9   X_START_DATE_ACTIVE in DATE,
10   X_END_DATE_ACTIVE in DATE,
11   X_REQUIRED_FLAG in VARCHAR2,
12   X_MODE in VARCHAR2 default 'R'
13   );
14 procedure LOCK_ROW (
15   X_PERSONNEL_ID in NUMBER,
16   X_AWARD_ID in NUMBER,
17   X_PERSON_ID in NUMBER,
18   X_AWARD_ROLE in VARCHAR2,
19   X_START_DATE_ACTIVE in DATE,
20   X_END_DATE_ACTIVE in DATE,
21   X_REQUIRED_FLAG in VARCHAR2
22 );
23 procedure UPDATE_ROW (
24   X_PERSONNEL_ID in NUMBER,
25   X_AWARD_ID in NUMBER,
26   X_PERSON_ID in NUMBER,
27   X_AWARD_ROLE in VARCHAR2,
28   X_START_DATE_ACTIVE in DATE,
29   X_END_DATE_ACTIVE in DATE,
30   X_REQUIRED_FLAG in VARCHAR2,
31   X_MODE in VARCHAR2 default 'R'
32   );
33 procedure ADD_ROW (
34   X_ROWID in out NOCOPY VARCHAR2,
35   X_PERSONNEL_ID in NUMBER,
36   X_AWARD_ID in NUMBER,
37   X_PERSON_ID in NUMBER,
38   X_AWARD_ROLE in VARCHAR2,
39   X_START_DATE_ACTIVE in DATE,
40   X_END_DATE_ACTIVE in DATE,
41   X_REQUIRED_FLAG in VARCHAR2,
42   X_MODE in VARCHAR2 default 'R'
43   );
44 procedure DELETE_ROW (
45   X_PERSONNEL_ID in NUMBER
46 );
47 end GMS_PERSONNEL_PKG;