[Home] [Help]
PACKAGE: APPS.GMS_AWARDS_CONTACTS_PKG
Source
1 package GMS_AWARDS_CONTACTS_PKG AUTHID CURRENT_USER as
2 -- $Header: gmsawcts.pls 115.6 2002/11/26 00:23:22 jmuthuku ship $
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_AWARD_ID in NUMBER,
7 X_CONTACT_ID in NUMBER,
8 X_MODE in VARCHAR2 default 'R',
9 X_CUSTOMER_ID in NUMBER,
10 X_PRIMARY_FLAG in VARCHAR2 default 'N',
11 X_USAGE_CODE in VARCHAR2
12 );
13 procedure LOCK_ROW (
14 X_AWARD_ID in NUMBER,
15 X_CONTACT_ID in NUMBER,
16 X_CUSTOMER_ID in NUMBER,
17 X_PRIMARY_FLAG IN VARCHAR2,
18 X_USAGE_CODE in VARCHAR2,
19 X_ROWID in VARCHAR2
20 );
21 procedure UPDATE_ROW (
22 X_AWARD_ID in NUMBER,
23 X_CONTACT_ID in NUMBER,
24 X_MODE in VARCHAR2 default 'R',
25 X_CUSTOMER_ID in NUMBER,
26 X_PRIMARY_FLAG in VARCHAR2,
27 X_USAGE_CODE in VARCHAR2,
28 X_ROWID in VARCHAR2
29 );
30
31 procedure DELETE_ROW (
32 X_AWARD_ID in NUMBER,
33 X_CONTACT_ID in NUMBER,
34 X_CUSTOMER_ID in NUMBER,
35 X_ROWID in VARCHAR2
36 );
37 end GMS_AWARDS_CONTACTS_PKG;