PACKAGE: APPS.PA_PERF_THRESHOLDS_PKG

Source

1 package PA_PERF_THRESHOLDS_PKG as
2 /* $Header: PAPETHTS.pls 120.1 2005/08/19 16:40:02 mwasowic noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6   X_THRESHOLD_ID in NUMBER,
7   X_RULE_TYPE in VARCHAR2,
8   X_THRES_OBJ_ID in NUMBER,
9   X_FROM_VALUE in NUMBER,
10   X_TO_VALUE in NUMBER,
11   X_INDICATOR_CODE in VARCHAR2,
12   X_EXCEPTION_FLAG in VARCHAR2,
13   X_WEIGHTING in NUMBER,
14   X_ACCESS_LIST_ID in NUMBER,
15   X_RECORD_VERSION_NUMBER in NUMBER DEFAULT 1,
16   X_CREATION_DATE in DATE DEFAULT sysdate ,
17   X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
18   X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
19   X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
20   X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
21 );
22 
23 procedure LOCK_ROW (
24   X_THRESHOLD_ID in NUMBER,
25   X_RECORD_VERSION_NUMBER in NUMBER
26 );
27 
28 procedure UPDATE_ROW (
29   X_THRESHOLD_ID in NUMBER,
30   X_RULE_TYPE in VARCHAR2,
31   X_THRES_OBJ_ID in NUMBER,
32   X_FROM_VALUE in NUMBER,
33   X_TO_VALUE in NUMBER,
34   X_INDICATOR_CODE in VARCHAR2,
35   X_EXCEPTION_FLAG in VARCHAR2,
36   X_WEIGHTING in NUMBER,
37   X_ACCESS_LIST_ID in NUMBER,
38   X_RECORD_VERSION_NUMBER in NUMBER,
39   X_LAST_UPDATE_DATE in DATE  DEFAULT sysdate,
40   X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
41   X_LAST_UPDATE_LOGIN in NUMBER  DEFAULT fnd_global.login_id
42 );
43 
44 procedure DELETE_ROW (
45   X_THRESHOLD_ID in NUMBER
46 );
47 
48 end PA_PERF_THRESHOLDS_PKG;