1 PACKAGE XLE_ASSOC_VALIDATIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: xleassvs.pls 120.2 2005/07/27 09:17:12 ttran ship $ */
3
4 PROCEDURE Validate_Mandatory (
5 p_param_name IN VARCHAR2,
6 p_param_value IN VARCHAR2);
7
8 PROCEDURE Validate_Context (
9 p_context IN VARCHAR2);
10
11 PROCEDURE Validate_Object (
12 p_object_type IN VARCHAR2,
13 p_object_id IN NUMBER ,
14 p_param1_name IN VARCHAR2,
15 p_param2_name IN VARCHAR2,
16 x_OBJECT_type_id OUT NOCOPY NUMBER );
17
18 PROCEDURE Validate_Association_Id (
19 p_association_id IN NUMBER,
20 p_association_type_id OUT NOCOPY NUMBER,
21 p_subject_id OUT NOCOPY NUMBER,
22 p_object_id OUT NOCOPY NUMBER);
23
24 PROCEDURE Default_Association_Type (
25 p_context IN VARCHAR2,
26 p_subject_type IN NUMBER ,
27 p_object_type IN NUMBER ,
28 x_association_type_id OUT NOCOPY NUMBER );
29
30 PROCEDURE Default_Association_Type (
31 p_context IN VARCHAR2,
32 p_subject_type IN VARCHAR2,
33 p_object_type IN VARCHAR2,
34 x_association_type_id OUT NOCOPY NUMBER );
35
36 PROCEDURE Validate_Cardinality (
37 p_association_type_id IN NUMBER ,
38 p_subject_type IN VARCHAR2,
39 p_subject_id IN NUMBER ,
40 p_object_type IN VARCHAR2,
41 p_object_id IN NUMBER );
42
43 PROCEDURE Get_Effective_From_Date (
44 p_association_id IN NUMBER ,
45 p_effective_from OUT NOCOPY DATE );
46
47 FUNCTION Is_date_overlap (
48 start_date1 IN DATE ,
49 end_date1 IN DATE ,
50 start_date2 IN DATE ,
51 end_date2 IN DATE )
52 RETURN BOOLEAN;
53
54 PROCEDURE Validate_Effective_Dates (
55 p_association_type_id IN NUMBER ,
56 p_effective_from IN DATE ,
57 p_effective_to IN DATE := NULL);
58
59 PROCEDURE Validate_Overlap_Dates (
60 p_association_id IN NUMBER := NULL,
61 p_association_type_id IN NUMBER,
62 p_subject_id IN NUMBER ,
63 p_object_id IN NUMBER ,
64 p_effective_from IN DATE ,
65 p_effective_to IN DATE := NULL);
66
67 PROCEDURE Get_Parent_Id (
68 p_object_type IN VARCHAR2,
69 p_object_id IN NUMBER ,
70 x_object_parent_id OUT NOCOPY NUMBER );
71
72 PROCEDURE Validate_Parameter_Combination (
73 p_context IN VARCHAR2,
74 p_subject_type IN VARCHAR2,
75 p_subject_id IN NUMBER ,
76 p_object_type IN VARCHAR2,
77 p_object_id IN NUMBER ,
78 x_association_type_id OUT NOCOPY NUMBER );
79
80 PROCEDURE Get_Association_Id (
81 p_subject_id IN NUMBER,
82 p_object_id IN NUMBER,
83 p_association_type_id IN NUMBER,
84 x_association_id OUT NOCOPY NUMBER);
85
86 PROCEDURE Validate_Intercompany (
87 p_subject_id IN NUMBER,
88 p_object_id IN NUMBER);
89
90 PROCEDURE Validate_Create_Association (
91 p_context IN VARCHAR2,
92 p_subject_type IN VARCHAR2,
93 p_subject_id IN NUMBER ,
94 p_object_type IN VARCHAR2,
95 p_object_id IN NUMBER ,
96 p_effective_from IN DATE ,
97 p_assoc_information_context IN VARCHAR2,
98 p_assoc_information1 IN VARCHAR2,
99 p_assoc_information2 IN VARCHAR2,
100 p_assoc_information3 IN VARCHAR2,
101 p_assoc_information4 IN VARCHAR2,
102 p_assoc_information5 IN VARCHAR2,
103 p_assoc_information6 IN VARCHAR2,
104 p_assoc_information7 IN VARCHAR2,
105 p_assoc_information8 IN VARCHAR2,
106 p_assoc_information9 IN VARCHAR2,
107 p_assoc_information10 IN VARCHAR2,
108 p_assoc_information11 IN VARCHAR2,
109 p_assoc_information12 IN VARCHAR2,
110 p_assoc_information13 IN VARCHAR2,
111 p_assoc_information14 IN VARCHAR2,
112 p_assoc_information15 IN VARCHAR2,
113 p_assoc_information16 IN VARCHAR2,
114 p_assoc_information17 IN VARCHAR2,
115 p_assoc_information18 IN VARCHAR2,
116 p_assoc_information19 IN VARCHAR2,
117 p_assoc_information20 IN VARCHAR2,
118 x_association_type_id OUT NOCOPY NUMBER ,
119 x_subject_parent_id OUT NOCOPY NUMBER );
120
121 PROCEDURE Validate_Update_Association (
122 p_association_id IN OUT NOCOPY NUMBER,
123 p_context IN VARCHAR2,
124 p_subject_type IN VARCHAR2,
125 p_subject_id IN NUMBER ,
126 p_object_type IN VARCHAR2,
127 p_object_id IN NUMBER ,
128 p_effective_from IN DATE ,
129 p_effective_to IN DATE ,
130 p_assoc_information_context IN VARCHAR2,
131 p_assoc_information1 IN VARCHAR2,
132 p_assoc_information2 IN VARCHAR2,
133 p_assoc_information3 IN VARCHAR2,
134 p_assoc_information4 IN VARCHAR2,
135 p_assoc_information5 IN VARCHAR2,
136 p_assoc_information6 IN VARCHAR2,
137 p_assoc_information7 IN VARCHAR2,
138 p_assoc_information8 IN VARCHAR2,
139 p_assoc_information9 IN VARCHAR2,
140 p_assoc_information10 IN VARCHAR2,
141 p_assoc_information11 IN VARCHAR2,
142 p_assoc_information12 IN VARCHAR2,
143 p_assoc_information13 IN VARCHAR2,
144 p_assoc_information14 IN VARCHAR2,
145 p_assoc_information15 IN VARCHAR2,
146 p_assoc_information16 IN VARCHAR2,
147 p_assoc_information17 IN VARCHAR2,
148 p_assoc_information18 IN VARCHAR2,
149 p_assoc_information19 IN VARCHAR2,
150 p_assoc_information20 IN VARCHAR2);
151
152 END XLE_ASSOC_VALIDATIONS_PVT;
153