[Home] [Help]
PACKAGE: APPS.PA_PERF_THRESHOLDS_PUB
Source
1 PACKAGE PA_PERF_THRESHOLDS_PUB AS
2 /* $Header: PAPETHPS.pls 120.1 2005/08/19 16:39:55 mwasowic noship $ */
3
4 /*==================================================================
5 PROCEDURE
6 create_rule_det
7 PURPOSE
8 This procedure inserts a row into the pa_perf_thersholds table.
9 ==================================================================*/
10
11
12 PROCEDURE create_rule_det(
13 P_THRESHOLD_ID IN NUMBER,
14 P_RULE_TYPE IN VARCHAR2,
15 P_THRES_OBJ_ID IN NUMBER,
16 P_FROM_VALUE IN NUMBER,
17 P_TO_VALUE IN NUMBER,
18 P_INDICATOR_CODE IN VARCHAR2,
19 P_EXCEPTION_FLAG IN VARCHAR2,
20 P_WEIGHTING IN NUMBER,
21 P_ACCESS_LIST_ID IN NUMBER,
22 P_RECORD_VERSION_NUMBER IN NUMBER,
23 P_CREATION_DATE IN DATE DEFAULT SYSDATE,
24 P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
25 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
26 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
27 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
28 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30 X_MSG_DATA OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
31
32
33 /*==================================================================
34 PROCEDURE
35 update_rule_det
36 PURPOSE
37 This procedure updates a row into the pa_perf_thersholds table.
38 ==================================================================*/
39
40 PROCEDURE update_rule_det(
41 P_THRESHOLD_ID IN NUMBER,
42 P_RULE_TYPE IN VARCHAR2,
43 P_THRES_OBJ_ID IN NUMBER,
44 P_FROM_VALUE IN NUMBER,
45 P_TO_VALUE IN NUMBER,
46 P_INDICATOR_CODE IN VARCHAR2,
47 P_EXCEPTION_FLAG IN VARCHAR2,
48 P_WEIGHTING IN NUMBER,
49 P_ACCESS_LIST_ID IN NUMBER,
50 P_RECORD_VERSION_NUMBER IN NUMBER,
51 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
52 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
53 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
54 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56 X_MSG_DATA OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
57
58 /*==================================================================
59 PROCEDURE
60 delete_rule_det
61 PURPOSE
62 This procedure deletes a row from the pa_perf_thersholds table.
63 ==================================================================*/
64 PROCEDURE delete_rule_det (
65 P_THRESHOLD_ID IN NUMBER,
66 P_RECORD_VERSION_NUMBER IN NUMBER,
67 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69 X_MSG_DATA OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
70
71 END PA_PERF_THRESHOLDS_PUB;