1 PACKAGE Oe_PC_Constraints_Admin_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OEXVPCAS.pls 120.1 2006/03/29 16:51:23 spooruli noship $ */
3
4 -- Start of Comments
5 -- API name Make_Validation_Pkg
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 --------------------------------------------------------------
21 PROCEDURE Make_Validation_Pkg
22 --------------------------------------------------------------
23 (
24 p_entity_id in number,
25 p_entity_short_name in varchar2,
26 p_db_object_name in varchar2,
27 p_validation_entity_id in number,
28 p_validation_entity_short_name in varchar2,
29 p_validation_db_object_name in varchar2,
30 p_validation_tmplt_id in number,
31 p_validation_tmplt_short_name in varchar2,
32 p_record_set_id in number,
33 p_record_set_short_name in varchar2,
34 p_global_record_name in varchar2,
35 x_pkg_name out nocopy varchar2,
36
37 x_pkg_spec out nocopy long,
38
39 x_pkg_body out nocopy long,
40
41 x_control_tbl_sql out nocopy varchar2,
42
43 x_return_status out nocopy varchar2,
44
45 x_msg_data out nocopy varchar2,
46
47 x_msg_count out nocopy number
48
49 );
50
51 -- Bug 1755817: function introduced to check if any
52 -- attribute-specific constraints with check_on_insert_flag = 'Y'
53 -- exist for this entity
54 --------------------------------------------------------------
55 FUNCTION Check_On_Insert_Exists
56 --------------------------------------------------------------
57 (
58 p_entity_id in number
59 ,p_responsibility_id in number
60 ,p_application_id in number default NULL --added for bug3631547
61 )
62 RETURN BOOLEAN;
63
64 -- Bug 1755817: procedure to clear cached results
65 -- if validation_entity_id is passed, only results with that
66 -- validation_entity are cleared else entire cache is cleared
67 --------------------------------------------------------------
68 PROCEDURE Clear_Cached_Results
69 --------------------------------------------------------------
70 (
71 p_validation_entity_id in number default null
72 );
73
74 -- Bug 1755817: introduced p_use_cached_results parameter to
75 -- indicate whether constraints should use cached results
76 -- for condition where validation entity is not the same as
77 -- constrained entity.
78 --------------------------------------------------------------
79 PROCEDURE Validate_Constraint
80 --------------------------------------------------------------
81 ( p_constraint_id in number
82 ,p_use_cached_results in varchar2 default 'N'
83 ,x_condition_count out nocopy number
84
85 ,x_valid_condition_group out nocopy number
86
87 ,x_result out nocopy number
88
89 );
90
91 --------------------------------------------------------------
92 FUNCTION Is_Op_Constrained
93 --------------------------------------------------------------
94 (
95 p_responsibility_id in number
96 ,p_application_id in number default NULL --added for bug3631547
97 ,p_operation in varchar2
98 ,p_entity_id in number
99 ,p_qualifier_attribute in varchar2 default NULL
100 ,p_column_name in varchar2 default NULL
101 ,p_check_all_cols_constraint in varchar2 default 'Y'
102 ,p_is_caller_defaulting in varchar2 default 'N'
103 ,p_use_cached_results in varchar2 default 'N'
104 ,x_constraint_id out nocopy number
105
106 ,x_constraining_conditions_grp out nocopy number
107
108 ,x_on_operation_action out nocopy number
109
110 )
111 RETURN NUMBER;
112
113 END Oe_PC_Constraints_Admin_Pvt;