1 PACKAGE pa_perf_rules_pvt AUTHID CURRENT_USER AS
2 /* $Header: PAPERLVS.pls 120.1 2005/08/19 16:39:47 mwasowic noship $ */
3
4 /*==================================================================
5 PROCEDURE
6 create_rule
7 PURPOSE
8 This procedure inserts a row into the pa_perf_rules table.
9 ==================================================================*/
10
11
12 PROCEDURE create_rule(
13 P_RULE_ID IN NUMBER,
14 P_RULE_NAME IN VARCHAR2,
15 P_RULE_DESCRIPTION IN VARCHAR2,
16 P_RULE_TYPE IN VARCHAR2,
17 P_KPA_CODE IN VARCHAR2,
18 P_MEASURE_ID IN NUMBER,
19 P_MEASURE_FORMAT IN VARCHAR2,
20 P_CURRENCY_TYPE IN VARCHAR2,
21 P_PERIOD_TYPE IN VARCHAR2,
22 P_PRECISION IN NUMBER,
23 P_START_DATE_ACTIVE IN DATE,
24 P_END_DATE_ACTIVE IN DATE,
25 P_SCORE_METHOD IN VARCHAR2,
26 P_RECORD_VERSION_NUMBER IN NUMBER,
27 P_CREATION_DATE IN DATE DEFAULT SYSDATE,
28 P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
29 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
30 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
31 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
32 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
33 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
34 X_MSG_DATA OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
35
36
37 /*==================================================================
38 PROCEDURE
39 update_rule
40 PURPOSE
41 This procedure updates a row into the pa_perf_rules table.
42 ==================================================================*/
43
44 PROCEDURE update_rule(
45 P_RULE_ID IN NUMBER,
46 P_RULE_NAME IN VARCHAR2,
47 P_RULE_DESCRIPTION IN VARCHAR2,
48 P_RULE_TYPE IN VARCHAR2,
49 P_KPA_CODE IN VARCHAR2,
50 P_MEASURE_ID IN NUMBER,
51 P_MEASURE_FORMAT IN VARCHAR2,
52 P_CURRENCY_TYPE IN VARCHAR2,
53 P_PERIOD_TYPE IN VARCHAR2,
54 P_PRECISION IN NUMBER,
55 P_START_DATE_ACTIVE IN DATE,
56 P_END_DATE_ACTIVE IN DATE,
57 P_SCORE_METHOD IN VARCHAR2,
58 P_RECORD_VERSION_NUMBER IN NUMBER,
59 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
60 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
61 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
62 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
63 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
64 X_MSG_DATA OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
65
66 /*==================================================================
67 PROCEDURE
68 delete_rule
69 PURPOSE
70 This procedure deletes a row from the pa_perf_rules table.
71 ==================================================================*/
72 PROCEDURE delete_rule (
73 P_RULE_ID IN NUMBER,
74 P_RECORD_VERSION_NUMBER IN NUMBER,
75 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
76 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
77 X_MSG_DATA OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
78
79 /*==================================================================
80 PROCEDURE
81 validate_rule
82 PURPOSE
83 This procedure validates the performance rule to be inserted .
84 ==================================================================*/
85
86
87 PROCEDURE validate_rule(
88 P_RULE_ID IN NUMBER,
89 P_RULE_NAME IN VARCHAR2,
90 P_RULE_TYPE IN VARCHAR2,
91 P_PRECISION IN NUMBER,
92 P_START_DATE_ACTIVE IN DATE,
93 P_END_DATE_ACTIVE IN DATE,
94 P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
95 P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
96 P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
97 P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
98 P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
99 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
100 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
101 X_MSG_DATA OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
102 P_WEIGHTING IN SYSTEM.PA_NUM_TBL_TYPE );
103
104 END PA_PERF_RULES_PVT;