PACKAGE: APPS.IGW_PROP_PERSONS_PKG

Source

1 package IGW_PROP_PERSONS_PKG AUTHID CURRENT_USER as
2  /* $Header: igwpr40s.pls 115.10 2002/03/28 19:13:30 pkm ship      $ */
3 procedure INSERT_ROW (
4   X_ROWID in out VARCHAR2,
5   X_PROPOSAL_ID in NUMBER,
6   X_PERSON_ID in NUMBER,
7   X_PERSON_SEQUENCE in NUMBER,
8   X_PROPOSAL_ROLE_CODE in VARCHAR2,
9   X_PI_FLAG in VARCHAR2,
10   X_KEY_PERSON_FLAG in VARCHAR2,
11   X_PERCENT_EFFORT in NUMBER,
12   X_PERSON_ORGANIZATION_ID in NUMBER,
13   X_MODE in VARCHAR2 default 'R'
14   );
15 procedure LOCK_ROW (
16   X_ROWID in VARCHAR2,
17   X_PROPOSAL_ID in NUMBER,
18   X_PERSON_ID in NUMBER,
19   X_PERSON_SEQUENCE in NUMBER,
20   X_PROPOSAL_ROLE_CODE in VARCHAR2,
21   X_PI_FLAG in VARCHAR2,
22   X_KEY_PERSON_FLAG in VARCHAR2,
23   X_PERCENT_EFFORT in NUMBER,
24   X_PERSON_ORGANIZATION_ID in NUMBER
25 );
26 procedure UPDATE_ROW (
27   X_ROWID in VARCHAR2,
28   X_PROPOSAL_ID in NUMBER,
29   X_PERSON_ID in NUMBER,
30   X_PERSON_SEQUENCE in NUMBER,
31   X_PROPOSAL_ROLE_CODE in VARCHAR2,
32   X_PI_FLAG in VARCHAR2,
33   X_KEY_PERSON_FLAG in VARCHAR2,
34   X_PERCENT_EFFORT in NUMBER,
35   X_PERSON_ORGANIZATION_ID in NUMBER,
36   X_MODE in VARCHAR2 default 'R'
37   );
38 procedure ADD_ROW (
39   X_ROWID in out VARCHAR2,
40   X_PROPOSAL_ID in NUMBER,
41   X_PERSON_ID in NUMBER,
42   X_PERSON_SEQUENCE in NUMBER,
43   X_PROPOSAL_ROLE_CODE in VARCHAR2,
44   X_PI_FLAG in VARCHAR2,
45   X_KEY_PERSON_FLAG in VARCHAR2,
46   X_PERCENT_EFFORT in NUMBER,
47   X_PERSON_ORGANIZATION_ID in NUMBER,
48   X_MODE in VARCHAR2 default 'R'
49   );
50 procedure DELETE_ROW (
51   X_ROWID in VARCHAR2
52 );
53 end IGW_PROP_PERSONS_PKG;