1 package PA_PERF_OBJECT_RULES_PKG as
2 /* $Header: PAPEORTS.pls 120.1 2005/08/19 16:39:10 mwasowic noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6 X_OBJECT_RULE_ID in NUMBER,
7 X_OBJECT_TYPE in VARCHAR2,
8 X_OBJECT_ID in NUMBER,
9 X_RULE_ID in NUMBER,
10 X_RECORD_VERSION_NUMBER in NUMBER DEFAULT 1,
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 LOCK_ROW (
19 X_OBJECT_RULE_ID in NUMBER,
20 X_RECORD_VERSION_NUMBER in NUMBER
21 );
22
23 procedure UPDATE_ROW (
24 X_OBJECT_RULE_ID in NUMBER,
25 X_OBJECT_TYPE in VARCHAR2,
26 X_OBJECT_ID in NUMBER,
27 X_RULE_ID in NUMBER,
28 X_RECORD_VERSION_NUMBER in NUMBER,
29 X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
30 X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
31 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
32 );
33
34 procedure DELETE_ROW (
35 X_OBJECT_RULE_ID in NUMBER
36 );
37
38 end PA_PERF_OBJECT_RULES_PKG;