[Home] [Help]
PACKAGE: APPS.PSP_EFFORT_MESSAGES_PKG
Source
1 package PSP_EFFORT_MESSAGES_PKG AUTHID CURRENT_USER as
2 /* $Header: PSPERMES.pls 115.5 2002/11/18 12:34:47 lveerubh ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_MESSAGE_ID in NUMBER,
6 X_EFFORT_REPORT_MESSAGE_TYPE in VARCHAR2,
7 X_TEXT in VARCHAR2,
8 X_MODE in VARCHAR2 default 'R'
9 );
10 procedure LOCK_ROW (
11 X_MESSAGE_ID in NUMBER,
12 X_EFFORT_REPORT_MESSAGE_TYPE in VARCHAR2,
13 X_TEXT in VARCHAR2
14 );
15 procedure UPDATE_ROW (
16 X_MESSAGE_ID in NUMBER,
17 X_EFFORT_REPORT_MESSAGE_TYPE in VARCHAR2,
18 X_TEXT in VARCHAR2,
19 X_MODE in VARCHAR2 default 'R'
20 );
21 procedure ADD_ROW (
22 X_ROWID in out NOCOPY VARCHAR2,
23 X_MESSAGE_ID in NUMBER,
24 X_EFFORT_REPORT_MESSAGE_TYPE in VARCHAR2,
25 X_TEXT in VARCHAR2,
26 X_MODE in VARCHAR2 default 'R'
27 );
28 procedure DELETE_ROW (
29 X_MESSAGE_ID in NUMBER
30 );
31 end PSP_EFFORT_MESSAGES_PKG;