1 PACKAGE HZ_DSS_VALIDATE_PKG AS
2 /* $Header: ARHPDSVS.pls 120.2 2005/10/30 04:22:01 appldev noship $ */
3
4 --------------------------------------------
5 -- return_no_of_dss_groups
6 --------------------------------------------
7
8
9 FUNCTION return_no_of_dss_groups
10 -- Return number of rows in hz_dss_groups
11 RETURN NUMBER;
12
13 --------------------------------------------
14 -- get_object_id_entities
15 --------------------------------------------
16
17
18 FUNCTION get_object_id_entities
19 -- Return object_id from hz_dss_entities, based on the given entity id
20 (p_entity_id NUMBER)
21 RETURN NUMBER;
22
23 --------------------------------------------
24 -- get_instance_set_id_entities
25 --------------------------------------------
26 FUNCTION get_instance_set_id_entities
27 -- Return instance_set_id from hz_dss_entities, based on the given entity id
28 (p_entity_id NUMBER)
29 RETURN NUMBER;
30
31 --------------------------------------------
32 -- get_object_id_fnd_ins_sets
33 --------------------------------------------
34
35 FUNCTION get_object_id_fnd_ins_sets
36 -- Return object_id from fnd_grants based on the passed in instance_set_id
37 (p_instance_set_id NUMBER)
38 RETURN NUMBER;
39
40 --------------------------------------------
41 -- exist_in_dss_groups_b
42 --------------------------------------------
43
44 FUNCTION exist_in_dss_groups_b
45 -- Return Y if the group code exists in hz_dss_groups
46 -- N otherwise
47 (p_dss_group_code VARCHAR2 )
48 RETURN VARCHAR2;
49
50 --------------------------------------------
51 -- exist_in_dss_groups_vl
52 --------------------------------------------
53
54 FUNCTION exist_in_dss_groups_vl
55 -- Return Y if the object id exists in hz_dss_groups_vl
56 -- N otherwise
57 (p_dss_group_name VARCHAR2 )
58 RETURN VARCHAR2;
59
60 FUNCTION exist_in_dss_groups_vl
61 -- Return Y if the object name exists in hz_dss_groups_vl, for a row whose
62 -- primary key <> passed in primary key value
63 -- N otherwise
64 (p_dss_group_name VARCHAR2, p_dss_group_code VARCHAR2 )
65 RETURN VARCHAR2;
66
67
68 --------------------------------------------
69 -- exist_in_hz_class_categories
70 --------------------------------------------
71
72 FUNCTION exist_in_hz_class_categories
73 -- Return Y if the class code exists in hz_class_categories
74 -- N otherwise
75 (p_class_category VARCHAR2 )
76 RETURN VARCHAR2;
77
78 --------------------------------------------
79 -- exist_in_hz_relationship_types
80 --------------------------------------------
81
82 FUNCTION exist_in_hz_relationship_types
83 -- Return Y if the class code exists in hz_relationship_types
84 -- N otherwise
85 (p_relationship_type_id NUMBER )
86 RETURN VARCHAR2;
87
88
89 --------------------------------------------
90 -- exist_in_dss_entities
91 --------------------------------------------
92
93 FUNCTION exist_in_dss_entities
94 -- Return Y if the assignment exists in hz_dss_entities
95 -- N otherwise
96 (p_database_object_name VARCHAR2 )
97 RETURN VARCHAR2;
98
99
100 FUNCTION exist_in_dss_entities
101 -- Return Y if the assignment exists in hz_dss_entities
102 -- N otherwise
103 (p_entity_id NUMBER )
104 RETURN VARCHAR2;
105
106
107
108 FUNCTION is_an_obj_id_in_dss_entities
109 -- Return Y if the passed in entity id corresponds to an object in hz_dss_entities
110 -- N otherwise
111 (p_entity_id NUMBER )
112 RETURN VARCHAR2;
113
114
115 --------------------------------------------
116 -- exist_in_dss_assignments
117 --------------------------------------------
118
119 FUNCTION exist_in_dss_assignments
120 -- Return Y if the assignment code exists in hz_dss_assignments
121 -- N otherwise
122 (p_assignment_id VARCHAR2 )
123 RETURN VARCHAR2;
124
125
126 --------------------------------------
127 -- exist_in_ar_lookups
128 --------------------------------------
129 FUNCTION exist_in_ar_lookups
130 -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS
131 -- N otherwise
132 (p_lookup_code VARCHAR2, p_lookup_type VARCHAR2 )
133 RETURN VARCHAR2;
134
135 --------------------------------------
136 -- exist_in_ar_lookups_gl
137 --------------------------------------
138 FUNCTION exist_in_ar_lookups_gl
139 -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS
140 -- N otherwise
141 (p_lookup_code VARCHAR2, p_lookup_type VARCHAR2 )
142 RETURN VARCHAR2;
143
144 --------------------------------------
145 -- exist_in_fnd_lookups
146 --------------------------------------
147 FUNCTION exist_in_fnd_lookups
148 -- Return Y if lookup_code and lookup_type are found in FND_LOOKUP_VALUES
149 -- N otherwise
150 (p_lookup_code VARCHAR2, p_lookup_type VARCHAR2 )
151 RETURN VARCHAR2;
152
153 --------------------------------------------
154 -- exist_fnd_object_id
155 --------------------------------------------
156
157 FUNCTION exist_fnd_object_id
158 -- Return Y if the object id exists in FND
159 -- N otherwise
160 (p_object_id NUMBER )
161 RETURN VARCHAR2;
162
163 --------------------------------------------
164 -- exist_fnd_instance_set_id
165 --------------------------------------------
166
167
168 FUNCTION exist_fnd_instance_set_id
169 -- Return Y if the instance set id exists in FND
170 -- N otherwise
171 (p_instance_set_id NUMBER )
172 RETURN VARCHAR2;
173
174 --------------------------------------------
175 -- exist_entity_id
176 --------------------------------------------
177 FUNCTION exist_entity_id
178 -- Return Y if the entity id exists in HZ_DSS_ENTITIES
179 -- N otherwise
180 (p_entity_id NUMBER )
181 RETURN VARCHAR2;
182
183 --------------------------------------------
184 -- exist_function_id
185 --------------------------------------------
186 FUNCTION exist_function_id
187 -- Return Y if function id exists in fnd_form_functions
188 -- N otherwise
189 (p_function_id NUMBER )
190 RETURN VARCHAR2;
191
192 END HZ_DSS_VALIDATE_PKG ;
[Home] [Help]