DBA Data[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;