1 package IGW_PROP_LOCATIONS_TBH AUTHID CURRENT_USER as
2 --$Header: igwtplcs.pls 115.4 2002/11/15 00:38:00 ashkumar ship $
3 procedure INSERT_ROW (
4 X_ROWID out NOCOPY ROWID,
5 X_PROPOSAL_ID in NUMBER,
6 X_PERFORMING_ORGANIZATION_ID in NUMBER,
7 X_PARTY_ID in NUMBER,
8 X_MODE in VARCHAR2 default 'R',
9 X_RETURN_STATUS out NOCOPY VARCHAR2
10 );
11
12 procedure UPDATE_ROW (
13 X_ROWID IN ROWID,
14 X_PROPOSAL_ID in NUMBER,
15 X_PERFORMING_ORGANIZATION_ID in NUMBER,
16 X_PARTY_ID in NUMBER,
17 X_RECORD_VERSION_NUMBER IN NUMBER,
18 X_MODE in VARCHAR2 default 'R',
19 X_RETURN_STATUS OUT NOCOPY VARCHAR2
20 );
21
22 procedure DELETE_ROW (
23 X_ROWID IN ROWID
24 ,X_PROPOSAL_ID IN NUMBER
25 ,X_PERFORMING_ORGANIZATION_ID IN NUMBER
26 ,X_PARTY_ID IN NUMBER
27 ,X_RECORD_VERSION_NUMBER IN NUMBER
28 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
29 );
30
31 end IGW_PROP_LOCATIONS_TBH;