DBA Data[Home] [Help]

PACKAGE: APPS.PA_PERF_CMTS_PKG

Source


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