PACKAGE: APPS.PA_PERF_RULES_PKG

Source

1 package PA_PERF_RULES_PKG as
2 /* $Header: PAPERLTS.pls 120.1 2005/08/19 16:39:38 mwasowic noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6   X_RULE_ID in NUMBER,
7   X_RULE_NAME in VARCHAR2,
8   X_RULE_DESCRIPTION in VARCHAR2,
9   X_RULE_TYPE in VARCHAR2,
10   X_KPA_CODE in VARCHAR2,
11   X_MEASURE_ID in NUMBER,
12   X_MEASURE_FORMAT in VARCHAR2,
13   X_CURRENCY_TYPE in VARCHAR2,
14   X_PERIOD_TYPE in VARCHAR2,
15   X_PRECISION in NUMBER,
16   X_START_DATE_ACTIVE in DATE,
17   X_END_DATE_ACTIVE in DATE,
18   X_SCORE_METHOD in VARCHAR2,
19   X_RECORD_VERSION_NUMBER in NUMBER DEFAULT 1,
20   X_CREATION_DATE in DATE DEFAULT sysdate ,
21   X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
22   X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
23   X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
24   X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
25 );
26 
27 
28 procedure LOCK_ROW (
29   X_RULE_ID in NUMBER,
30   X_RECORD_VERSION_NUMBER in NUMBER
31 );
32 
33 
34 procedure UPDATE_ROW (
35   X_RULE_ID in NUMBER,
36   X_RULE_NAME in VARCHAR2,
37   X_RULE_DESCRIPTION in VARCHAR2,
38   X_RULE_TYPE in VARCHAR2,
39   X_KPA_CODE in VARCHAR2,
40   X_MEASURE_ID in NUMBER,
41   X_MEASURE_FORMAT in VARCHAR2,
42   X_CURRENCY_TYPE in VARCHAR2,
43   X_PERIOD_TYPE in VARCHAR2,
44   X_PRECISION in NUMBER,
45   X_START_DATE_ACTIVE in DATE,
46   X_END_DATE_ACTIVE in DATE,
47   X_SCORE_METHOD in VARCHAR2,
48   X_RECORD_VERSION_NUMBER in NUMBER,
49   X_LAST_UPDATE_DATE in DATE  DEFAULT sysdate,
50   X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
51   X_LAST_UPDATE_LOGIN in NUMBER  DEFAULT fnd_global.login_id
52 );
53 
54 
55 procedure DELETE_ROW (
56   X_RULE_ID in NUMBER
57 );
58 
59 end PA_PERF_RULES_PKG;