[Home] [Help]
PACKAGE: APPS.FUN_RULE_VALIDATE_PKG
Source
1 PACKAGE FUN_RULE_VALIDATE_PKG AUTHID CURRENT_USER AS
2 /*$Header: FUNXTMRULGENVLS.pls 120.1 2006/01/10 12:17:56 ammishra noship $ */
3 /*---------------------------------------------------------
4 -- Component for every entities in Rules module-
5 ---------------------------------------------------------*/
6 PROCEDURE check_existence_rules_object
7 -- Check if the user customizable object exists
8 (p_rule_object_name IN VARCHAR2,
9 p_application_id IN NUMBER,
10 x_return_status IN OUT NOCOPY VARCHAR2);
11
12 procedure check_err(
13 x_return_status IN VARCHAR2
14 );
15
16 PROCEDURE validate_rule_objects(
17 p_create_update_flag IN VARCHAR2,
18 p_rule_objects_rec IN FUN_RULE_OBJECTS_PUB.rule_objects_rec_type,
19 p_rowid IN ROWID ,
20 x_return_status IN OUT NOCOPY VARCHAR2
21 );
22
23 PROCEDURE validate_rule_object_instance(
24 p_create_update_flag IN VARCHAR2,
25 p_rule_object_instance_rec IN FUN_RULE_OBJECTS_PUB.rule_objects_rec_type,
26 p_rowid IN ROWID ,
27 x_return_status IN OUT NOCOPY VARCHAR2
28 );
29
30 PROCEDURE validate_rule_criteria_params(
31 p_create_update_flag IN VARCHAR2,
32 p_rule_crit_params_rec IN FUN_RULE_CRIT_PARAMS_PUB.rule_crit_params_rec_type,
33 p_rowid IN ROWID ,
34 x_return_status IN OUT NOCOPY VARCHAR2
35 );
36
37 PROCEDURE validate_rule_details(
38 p_create_update_flag IN VARCHAR2,
39 p_rule_details_rec IN FUN_RULE_DETAILS_PUB.rule_details_rec_type,
40 p_rowid IN ROWID ,
41 x_return_status IN OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE validate_rule_criteria(
45 p_create_update_flag IN VARCHAR2,
46 p_rule_criteria_rec IN FUN_RULE_CRITERIA_PUB.rule_criteria_rec_type,
47 p_rowid IN ROWID ,
48 x_return_status IN OUT NOCOPY VARCHAR2
49 );
50
51 /*
52 PROCEDURE validate_rich_messages(
53 p_create_update_flag IN VARCHAR2,
54 p_rich_messages_rec IN FUN_RICH_MESSAGES_PUB.rich_messages_rec_type,
55 p_rowid IN ROWID ,
56 x_return_status IN OUT NOCOPY VARCHAR2
57 );
58 */
59
60 PROCEDURE validate_mandatory (
61 p_create_update_flag IN VARCHAR2,
62 p_column IN VARCHAR2,
63 p_column_value IN DATE,
64 p_restricted IN VARCHAR2 DEFAULT 'N',
65 x_return_status IN OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE validate_mandatory (
69 p_create_update_flag IN VARCHAR2,
70 p_column IN VARCHAR2,
71 p_column_value IN NUMBER,
72 p_restricted IN VARCHAR2 DEFAULT 'N',
73 x_return_status IN OUT NOCOPY VARCHAR2
74 );
75
76 PROCEDURE validate_mandatory (
77 p_create_update_flag IN VARCHAR2,
78 p_column IN VARCHAR2,
79 p_column_value IN VARCHAR2,
80 p_restricted IN VARCHAR2 DEFAULT 'N',
81 x_return_status IN OUT NOCOPY VARCHAR2
82 );
83
84
85
86 PROCEDURE validate_nonupdateable (
87 p_column IN VARCHAR2,
88 p_column_value IN VARCHAR2,
89 p_old_column_value IN VARCHAR2,
90 p_restricted IN VARCHAR2 DEFAULT 'Y',
91 x_return_status IN OUT NOCOPY VARCHAR2,
92 p_raise_error IN VARCHAR2 := 'Y'
93 );
94
95 PROCEDURE validate_nonupdateable_atall (
96 p_column IN VARCHAR2,
97 p_column_value IN VARCHAR2,
98 p_old_column_value IN VARCHAR2,
99 p_restricted IN VARCHAR2 DEFAULT 'Y',
100 x_return_status IN OUT NOCOPY VARCHAR2,
101 p_raise_error IN VARCHAR2 := 'Y'
102 );
103
104 PROCEDURE validate_lookup (
105 p_column IN VARCHAR2,
106 p_lookup_table IN VARCHAR2 DEFAULT 'FND_LOOKUP_VALUES',
107 p_lookup_type IN VARCHAR2,
108 p_column_value IN VARCHAR2,
109 x_return_status IN OUT NOCOPY VARCHAR2
110 );
111
112
113
114 PROCEDURE validate_rich_messages(
115 p_create_update_flag IN VARCHAR2,
116 p_rich_messages_rec IN FUN_RICH_MESSAGES_PUB.rich_messages_rec_type,
117 p_rowid IN ROWID ,
118 x_return_status IN OUT NOCOPY VARCHAR2
119 );
120
121 FUNCTION isFlexFieldValid(p_FlexFieldName IN VARCHAR2,
122 p_FlexFieldAppShortName IN VARCHAR2) RETURN BOOLEAN;
123
124 FUNCTION validate_org_id (
125 p_org_id IN NUMBER) RETURN BOOLEAN;
126
127 FUNCTION validate_application_id (
128 p_application_id IN NUMBER) RETURN BOOLEAN;
129
130 FUNCTION validate_flex_value_set_id (
131 p_flex_value_set_id IN NUMBER) RETURN BOOLEAN;
132
133 END FUN_RULE_VALIDATE_PKG;