[Home] [Help]
PACKAGE: APPS.PA_PERF_OBJECT_RULES_PVT
Source
1 PACKAGE PA_PERF_OBJECT_RULES_PVT AUTHID CURRENT_USER AS
2 /* $Header: PAPEORVS.pls 120.1 2005/08/19 16:39:18 mwasowic noship $ */
3
4 /*==================================================================
5 PROCEDURE
6 create_rule_object
7 PURPOSE
8 This procedure inserts a row into the pa_perf_object_rules table.
9 ==================================================================*/
10
11
12 PROCEDURE create_rule_object(
13 P_OBJECT_RULE_ID IN NUMBER,
14 P_OBJECT_TYPE IN VARCHAR2,
15 P_OBJECT_ID IN NUMBER,
16 P_RULE_ID IN NUMBER,
17 P_RECORD_VERSION_NUMBER IN NUMBER,
18 P_CREATION_DATE IN DATE DEFAULT SYSDATE,
19 P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
20 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
21 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
22 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
23 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25 X_MSG_DATA OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
26
27 /*==================================================================
28 PROCEDURE
29 update_rule_object
30 PURPOSE
31 This procedure updates a row in the pa_perf_object_rules table.
32 ==================================================================*/
33
34
35 PROCEDURE update_rule_object(
36 P_OBJECT_RULE_ID IN NUMBER,
37 P_OBJECT_TYPE IN VARCHAR2,
38 P_OBJECT_ID IN NUMBER,
39 P_RULE_ID IN NUMBER,
40 P_RECORD_VERSION_NUMBER IN NUMBER,
41 P_CREATION_DATE IN DATE DEFAULT SYSDATE,
42 P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
43 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
44 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
45 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
46 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
48 X_MSG_DATA OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
49
50 /*==================================================================
51 PROCEDURE
52 delete_rule_object
53 PURPOSE
54 This procedure deletes a row from the pa_perf_object_rules table.
55 ==================================================================*/
56 PROCEDURE delete_rule_object (
57 P_OBJECT_RULE_ID IN NUMBER,
58 P_RECORD_VERSION_NUMBER IN NUMBER,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
61 X_MSG_DATA OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62 X_RULE_NAME OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
63
64 /*==================================================================
65 PROCEDURE
66 validate_rule_object
67 PURPOSE
68 This procedure Checks the rules associated with a project .
69 ==================================================================*/
70 PROCEDURE validate_rule_object
71 (P_OBJECT_ID IN NUMBER,
72 P_OBJECT_TYPE IN VARCHAR2,
73 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
75 X_MSG_DATA OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
76
77 END PA_PERF_OBJECT_RULES_PVT;