1 package PA_PERF_CMTS_PKG as
2 /* $Header: PAPEECTS.pls 120.1 2005/08/19 16:38:28 mwasowic noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6 X_COMMENT_ID in NUMBER,
7 X_PERF_TXN_ID in NUMBER,
8 X_COMMENT_TEXT in VARCHAR2,
9 X_COMMENTED_BY in NUMBER,
10 X_COMMENT_DATE in DATE,
11 X_CREATION_DATE in DATE DEFAULT sysdate,
12 X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
13 X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
14 X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
15 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
16 );
17
18 procedure UPDATE_ROW (
19 X_COMMENT_ID in NUMBER,
20 X_PERF_TXN_ID in NUMBER,
21 X_COMMENT_TEXT in VARCHAR2,
22 X_COMMENTED_BY in NUMBER,
23 X_COMMENT_DATE in DATE,
24 X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
25 X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
26 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
27 );
28
29 procedure DELETE_ROW (
30 X_COMMENT_ID in NUMBER
31 );
32
33 end PA_PERF_CMTS_PKG;
34