14: --
15: -- {End of Comments}
16: -- ----------------------------------------------------------------------------
17: Procedure chk_assessment_type_id
18: (p_assessment_id in per_assessments.assessment_id%TYPE
19: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
20: ,p_assessment_date in per_assessments.assessment_date%TYPE
21: ,p_business_group_id in per_assessments.business_group_id%TYPE
22: ,p_object_version_number in per_assessments.object_version_number%TYPE
15: -- {End of Comments}
16: -- ----------------------------------------------------------------------------
17: Procedure chk_assessment_type_id
18: (p_assessment_id in per_assessments.assessment_id%TYPE
19: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
20: ,p_assessment_date in per_assessments.assessment_date%TYPE
21: ,p_business_group_id in per_assessments.business_group_id%TYPE
22: ,p_object_version_number in per_assessments.object_version_number%TYPE
23: );
16: -- ----------------------------------------------------------------------------
17: Procedure chk_assessment_type_id
18: (p_assessment_id in per_assessments.assessment_id%TYPE
19: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
20: ,p_assessment_date in per_assessments.assessment_date%TYPE
21: ,p_business_group_id in per_assessments.business_group_id%TYPE
22: ,p_object_version_number in per_assessments.object_version_number%TYPE
23: );
24: -- ----------------------------------------------------------------------------
17: Procedure chk_assessment_type_id
18: (p_assessment_id in per_assessments.assessment_id%TYPE
19: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
20: ,p_assessment_date in per_assessments.assessment_date%TYPE
21: ,p_business_group_id in per_assessments.business_group_id%TYPE
22: ,p_object_version_number in per_assessments.object_version_number%TYPE
23: );
24: -- ----------------------------------------------------------------------------
25: -- |------------------------< chk_assessment_date >---------------------------|
18: (p_assessment_id in per_assessments.assessment_id%TYPE
19: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
20: ,p_assessment_date in per_assessments.assessment_date%TYPE
21: ,p_business_group_id in per_assessments.business_group_id%TYPE
22: ,p_object_version_number in per_assessments.object_version_number%TYPE
23: );
24: -- ----------------------------------------------------------------------------
25: -- |------------------------< chk_assessment_date >---------------------------|
26: -- ----------------------------------------------------------------------------
32: --
33: -- {End of Comments}
34: -- ----------------------------------------------------------------------------
35: Procedure chk_assessment_date
36: (p_assessment_date in per_assessments.assessment_date%TYPE
37: ,p_assessment_id in per_assessments.assessment_id%TYPE
38: ,p_object_version_number in per_assessments.object_version_number%TYPE
39: );
40: -- ----------------------------------------------------------------------------
33: -- {End of Comments}
34: -- ----------------------------------------------------------------------------
35: Procedure chk_assessment_date
36: (p_assessment_date in per_assessments.assessment_date%TYPE
37: ,p_assessment_id in per_assessments.assessment_id%TYPE
38: ,p_object_version_number in per_assessments.object_version_number%TYPE
39: );
40: -- ----------------------------------------------------------------------------
41: -- |------------------------< chk_person_id >---------------------------------|
34: -- ----------------------------------------------------------------------------
35: Procedure chk_assessment_date
36: (p_assessment_date in per_assessments.assessment_date%TYPE
37: ,p_assessment_id in per_assessments.assessment_id%TYPE
38: ,p_object_version_number in per_assessments.object_version_number%TYPE
39: );
40: -- ----------------------------------------------------------------------------
41: -- |------------------------< chk_person_id >---------------------------------|
42: -- ----------------------------------------------------------------------------
48: --
49: -- {End of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure chk_person_id
52: (p_assessment_id in per_assessments.assessment_id%TYPE
53: ,p_person_id in per_assessments.person_id%TYPE
54: ,p_business_group_id in per_assessments.business_group_id%TYPE
55: ,p_assessment_date in per_assessments.assessment_date%TYPE
56: ,p_object_version_number in per_assessments.object_version_number%TYPE
49: -- {End of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure chk_person_id
52: (p_assessment_id in per_assessments.assessment_id%TYPE
53: ,p_person_id in per_assessments.person_id%TYPE
54: ,p_business_group_id in per_assessments.business_group_id%TYPE
55: ,p_assessment_date in per_assessments.assessment_date%TYPE
56: ,p_object_version_number in per_assessments.object_version_number%TYPE
57: );
50: -- ----------------------------------------------------------------------------
51: Procedure chk_person_id
52: (p_assessment_id in per_assessments.assessment_id%TYPE
53: ,p_person_id in per_assessments.person_id%TYPE
54: ,p_business_group_id in per_assessments.business_group_id%TYPE
55: ,p_assessment_date in per_assessments.assessment_date%TYPE
56: ,p_object_version_number in per_assessments.object_version_number%TYPE
57: );
58: -- ----------------------------------------------------------------------------
51: Procedure chk_person_id
52: (p_assessment_id in per_assessments.assessment_id%TYPE
53: ,p_person_id in per_assessments.person_id%TYPE
54: ,p_business_group_id in per_assessments.business_group_id%TYPE
55: ,p_assessment_date in per_assessments.assessment_date%TYPE
56: ,p_object_version_number in per_assessments.object_version_number%TYPE
57: );
58: -- ----------------------------------------------------------------------------
59: -- |------------------------< chk_assessor_person_id >------------------------|
52: (p_assessment_id in per_assessments.assessment_id%TYPE
53: ,p_person_id in per_assessments.person_id%TYPE
54: ,p_business_group_id in per_assessments.business_group_id%TYPE
55: ,p_assessment_date in per_assessments.assessment_date%TYPE
56: ,p_object_version_number in per_assessments.object_version_number%TYPE
57: );
58: -- ----------------------------------------------------------------------------
59: -- |------------------------< chk_assessor_person_id >------------------------|
60: -- ----------------------------------------------------------------------------
66: --
67: -- {End of Comments}
68: -- ----------------------------------------------------------------------------
69: Procedure chk_assessor_person_id
70: (p_assessor_person_id in per_assessments.assessor_person_id%TYPE
71: ,p_business_group_id in per_assessments.business_group_id%TYPE
72: ,p_assessment_date in per_assessments.assessment_date%TYPE
73: ,p_assessment_id in per_assessments.assessment_id%TYPE
74: ,p_object_version_number in per_assessments.object_version_number%TYPE
67: -- {End of Comments}
68: -- ----------------------------------------------------------------------------
69: Procedure chk_assessor_person_id
70: (p_assessor_person_id in per_assessments.assessor_person_id%TYPE
71: ,p_business_group_id in per_assessments.business_group_id%TYPE
72: ,p_assessment_date in per_assessments.assessment_date%TYPE
73: ,p_assessment_id in per_assessments.assessment_id%TYPE
74: ,p_object_version_number in per_assessments.object_version_number%TYPE
75: );
68: -- ----------------------------------------------------------------------------
69: Procedure chk_assessor_person_id
70: (p_assessor_person_id in per_assessments.assessor_person_id%TYPE
71: ,p_business_group_id in per_assessments.business_group_id%TYPE
72: ,p_assessment_date in per_assessments.assessment_date%TYPE
73: ,p_assessment_id in per_assessments.assessment_id%TYPE
74: ,p_object_version_number in per_assessments.object_version_number%TYPE
75: );
76: -- ----------------------------------------------------------------------------
69: Procedure chk_assessor_person_id
70: (p_assessor_person_id in per_assessments.assessor_person_id%TYPE
71: ,p_business_group_id in per_assessments.business_group_id%TYPE
72: ,p_assessment_date in per_assessments.assessment_date%TYPE
73: ,p_assessment_id in per_assessments.assessment_id%TYPE
74: ,p_object_version_number in per_assessments.object_version_number%TYPE
75: );
76: -- ----------------------------------------------------------------------------
77: -- |------------------------< chk_group_date_id >-----------------------------|
70: (p_assessor_person_id in per_assessments.assessor_person_id%TYPE
71: ,p_business_group_id in per_assessments.business_group_id%TYPE
72: ,p_assessment_date in per_assessments.assessment_date%TYPE
73: ,p_assessment_id in per_assessments.assessment_id%TYPE
74: ,p_object_version_number in per_assessments.object_version_number%TYPE
75: );
76: -- ----------------------------------------------------------------------------
77: -- |------------------------< chk_group_date_id >-----------------------------|
78: -- ----------------------------------------------------------------------------
84: --
85: -- {End of Comments}
86: -- ----------------------------------------------------------------------------
87: Procedure chk_group_date_id
88: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
89: ,p_group_date in per_assessments.group_date%TYPE
90: ,p_assessment_id in per_assessments.assessment_id%TYPE
91: ,p_object_version_number in per_assessments.object_version_number%TYPE
92: );
85: -- {End of Comments}
86: -- ----------------------------------------------------------------------------
87: Procedure chk_group_date_id
88: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
89: ,p_group_date in per_assessments.group_date%TYPE
90: ,p_assessment_id in per_assessments.assessment_id%TYPE
91: ,p_object_version_number in per_assessments.object_version_number%TYPE
92: );
93: -- ----------------------------------------------------------------------------
86: -- ----------------------------------------------------------------------------
87: Procedure chk_group_date_id
88: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
89: ,p_group_date in per_assessments.group_date%TYPE
90: ,p_assessment_id in per_assessments.assessment_id%TYPE
91: ,p_object_version_number in per_assessments.object_version_number%TYPE
92: );
93: -- ----------------------------------------------------------------------------
94: -- |------------------------< chk_group_initiator_id >------------------------|
87: Procedure chk_group_date_id
88: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
89: ,p_group_date in per_assessments.group_date%TYPE
90: ,p_assessment_id in per_assessments.assessment_id%TYPE
91: ,p_object_version_number in per_assessments.object_version_number%TYPE
92: );
93: -- ----------------------------------------------------------------------------
94: -- |------------------------< chk_group_initiator_id >------------------------|
95: -- ----------------------------------------------------------------------------
101: --
102: -- {End of Comments}
103: -- ----------------------------------------------------------------------------
104: Procedure chk_group_initiator_id
105: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
106: ,p_business_group_id in per_assessments.business_group_id%TYPE
107: ,p_group_date in per_assessments.group_date%TYPE
108: ,p_assessment_id in per_assessments.assessment_id%TYPE
109: ,p_object_version_number in per_assessments.object_version_number%TYPE
102: -- {End of Comments}
103: -- ----------------------------------------------------------------------------
104: Procedure chk_group_initiator_id
105: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
106: ,p_business_group_id in per_assessments.business_group_id%TYPE
107: ,p_group_date in per_assessments.group_date%TYPE
108: ,p_assessment_id in per_assessments.assessment_id%TYPE
109: ,p_object_version_number in per_assessments.object_version_number%TYPE
110: );
103: -- ----------------------------------------------------------------------------
104: Procedure chk_group_initiator_id
105: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
106: ,p_business_group_id in per_assessments.business_group_id%TYPE
107: ,p_group_date in per_assessments.group_date%TYPE
108: ,p_assessment_id in per_assessments.assessment_id%TYPE
109: ,p_object_version_number in per_assessments.object_version_number%TYPE
110: );
111: -- ----------------------------------------------------------------------------
104: Procedure chk_group_initiator_id
105: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
106: ,p_business_group_id in per_assessments.business_group_id%TYPE
107: ,p_group_date in per_assessments.group_date%TYPE
108: ,p_assessment_id in per_assessments.assessment_id%TYPE
109: ,p_object_version_number in per_assessments.object_version_number%TYPE
110: );
111: -- ----------------------------------------------------------------------------
112: -- |------------------------< chk_status >------------------------------------|
105: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
106: ,p_business_group_id in per_assessments.business_group_id%TYPE
107: ,p_group_date in per_assessments.group_date%TYPE
108: ,p_assessment_id in per_assessments.assessment_id%TYPE
109: ,p_object_version_number in per_assessments.object_version_number%TYPE
110: );
111: -- ----------------------------------------------------------------------------
112: -- |------------------------< chk_status >------------------------------------|
113: -- ----------------------------------------------------------------------------
119: --
120: -- {End of Comments}
121: -- ----------------------------------------------------------------------------
122: Procedure chk_status
123: (p_status in per_assessments.status%TYPE
124: ,p_effective_date in date
125: ,p_assessment_id in per_assessments.assessment_id%TYPE
126: ,p_object_version_number in per_assessments.object_version_number%TYPE
127: );
121: -- ----------------------------------------------------------------------------
122: Procedure chk_status
123: (p_status in per_assessments.status%TYPE
124: ,p_effective_date in date
125: ,p_assessment_id in per_assessments.assessment_id%TYPE
126: ,p_object_version_number in per_assessments.object_version_number%TYPE
127: );
128: -- ----------------------------------------------------------------------------
129: -- |------------------------< chk_assessment_period >-------------------------|
122: Procedure chk_status
123: (p_status in per_assessments.status%TYPE
124: ,p_effective_date in date
125: ,p_assessment_id in per_assessments.assessment_id%TYPE
126: ,p_object_version_number in per_assessments.object_version_number%TYPE
127: );
128: -- ----------------------------------------------------------------------------
129: -- |------------------------< chk_assessment_period >-------------------------|
130: -- ----------------------------------------------------------------------------
136: --
137: -- {End of Comments}
138: -- ----------------------------------------------------------------------------
139: Procedure chk_assessment_period
140: (p_assessment_period_start_date in per_assessments.assessment_period_start_date%TYPE
141: ,p_assessment_period_end_date in per_assessments.assessment_period_end_date%TYPE
142: ,p_assessment_id in per_assessments.assessment_id%TYPE
143: ,p_object_version_number in per_assessments.object_version_number%TYPE
144: );
137: -- {End of Comments}
138: -- ----------------------------------------------------------------------------
139: Procedure chk_assessment_period
140: (p_assessment_period_start_date in per_assessments.assessment_period_start_date%TYPE
141: ,p_assessment_period_end_date in per_assessments.assessment_period_end_date%TYPE
142: ,p_assessment_id in per_assessments.assessment_id%TYPE
143: ,p_object_version_number in per_assessments.object_version_number%TYPE
144: );
145: -- ----------------------------------------------------------------------------
138: -- ----------------------------------------------------------------------------
139: Procedure chk_assessment_period
140: (p_assessment_period_start_date in per_assessments.assessment_period_start_date%TYPE
141: ,p_assessment_period_end_date in per_assessments.assessment_period_end_date%TYPE
142: ,p_assessment_id in per_assessments.assessment_id%TYPE
143: ,p_object_version_number in per_assessments.object_version_number%TYPE
144: );
145: -- ----------------------------------------------------------------------------
146: -- |------------------------< chk_unique_combination >------------------------|
139: Procedure chk_assessment_period
140: (p_assessment_period_start_date in per_assessments.assessment_period_start_date%TYPE
141: ,p_assessment_period_end_date in per_assessments.assessment_period_end_date%TYPE
142: ,p_assessment_id in per_assessments.assessment_id%TYPE
143: ,p_object_version_number in per_assessments.object_version_number%TYPE
144: );
145: -- ----------------------------------------------------------------------------
146: -- |------------------------< chk_unique_combination >------------------------|
147: -- ----------------------------------------------------------------------------
153: --
154: -- {End of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure chk_unique_combination
157: (p_assessment_id in per_assessments.assessment_id%TYPE
158: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
159: ,p_assessment_date in per_assessments.assessment_date%TYPE
160: ,p_person_id in per_assessments.person_id%TYPE
161: ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE
154: -- {End of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure chk_unique_combination
157: (p_assessment_id in per_assessments.assessment_id%TYPE
158: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
159: ,p_assessment_date in per_assessments.assessment_date%TYPE
160: ,p_person_id in per_assessments.person_id%TYPE
161: ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE
162: ,p_group_date in per_assessments.group_date%TYPE
155: -- ----------------------------------------------------------------------------
156: Procedure chk_unique_combination
157: (p_assessment_id in per_assessments.assessment_id%TYPE
158: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
159: ,p_assessment_date in per_assessments.assessment_date%TYPE
160: ,p_person_id in per_assessments.person_id%TYPE
161: ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE
162: ,p_group_date in per_assessments.group_date%TYPE
163: ,p_object_version_number in per_assessments.object_version_number%TYPE
156: Procedure chk_unique_combination
157: (p_assessment_id in per_assessments.assessment_id%TYPE
158: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
159: ,p_assessment_date in per_assessments.assessment_date%TYPE
160: ,p_person_id in per_assessments.person_id%TYPE
161: ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE
162: ,p_group_date in per_assessments.group_date%TYPE
163: ,p_object_version_number in per_assessments.object_version_number%TYPE
164: );
157: (p_assessment_id in per_assessments.assessment_id%TYPE
158: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
159: ,p_assessment_date in per_assessments.assessment_date%TYPE
160: ,p_person_id in per_assessments.person_id%TYPE
161: ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE
162: ,p_group_date in per_assessments.group_date%TYPE
163: ,p_object_version_number in per_assessments.object_version_number%TYPE
164: );
165: -- ----------------------------------------------------------------------------
158: ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
159: ,p_assessment_date in per_assessments.assessment_date%TYPE
160: ,p_person_id in per_assessments.person_id%TYPE
161: ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE
162: ,p_group_date in per_assessments.group_date%TYPE
163: ,p_object_version_number in per_assessments.object_version_number%TYPE
164: );
165: -- ----------------------------------------------------------------------------
166: -- |------------------------< chk_assessment_group_id >-----------------------|
159: ,p_assessment_date in per_assessments.assessment_date%TYPE
160: ,p_person_id in per_assessments.person_id%TYPE
161: ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE
162: ,p_group_date in per_assessments.group_date%TYPE
163: ,p_object_version_number in per_assessments.object_version_number%TYPE
164: );
165: -- ----------------------------------------------------------------------------
166: -- |------------------------< chk_assessment_group_id >-----------------------|
167: -- ----------------------------------------------------------------------------
173: --
174: -- {End of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure chk_assessment_group_id
177: (p_assessment_group_id in per_assessments.assessment_group_id%TYPE
178: ,p_business_group_id in per_assessments.business_group_id%TYPE
179: ,p_assessment_id in per_assessments.assessment_id%TYPE
180: ,p_object_version_number in per_assessments.object_version_number%TYPE
181: );
174: -- {End of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure chk_assessment_group_id
177: (p_assessment_group_id in per_assessments.assessment_group_id%TYPE
178: ,p_business_group_id in per_assessments.business_group_id%TYPE
179: ,p_assessment_id in per_assessments.assessment_id%TYPE
180: ,p_object_version_number in per_assessments.object_version_number%TYPE
181: );
182: -- ----------------------------------------------------------------------------
175: -- ----------------------------------------------------------------------------
176: Procedure chk_assessment_group_id
177: (p_assessment_group_id in per_assessments.assessment_group_id%TYPE
178: ,p_business_group_id in per_assessments.business_group_id%TYPE
179: ,p_assessment_id in per_assessments.assessment_id%TYPE
180: ,p_object_version_number in per_assessments.object_version_number%TYPE
181: );
182: -- ----------------------------------------------------------------------------
183: -- |------------------------< chk_appraisal_id >------------------------------|
176: Procedure chk_assessment_group_id
177: (p_assessment_group_id in per_assessments.assessment_group_id%TYPE
178: ,p_business_group_id in per_assessments.business_group_id%TYPE
179: ,p_assessment_id in per_assessments.assessment_id%TYPE
180: ,p_object_version_number in per_assessments.object_version_number%TYPE
181: );
182: -- ----------------------------------------------------------------------------
183: -- |------------------------< chk_appraisal_id >------------------------------|
184: -- ----------------------------------------------------------------------------
190: --
191: -- {End of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure chk_appraisal_id
194: (p_appraisal_id in per_assessments.assessment_group_id%TYPE
195: ,p_business_group_id in per_assessments.business_group_id%TYPE
196: ,p_assessment_id in per_assessments.assessment_id%TYPE
197: ,p_object_version_number in per_assessments.object_version_number%TYPE
198: );
191: -- {End of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure chk_appraisal_id
194: (p_appraisal_id in per_assessments.assessment_group_id%TYPE
195: ,p_business_group_id in per_assessments.business_group_id%TYPE
196: ,p_assessment_id in per_assessments.assessment_id%TYPE
197: ,p_object_version_number in per_assessments.object_version_number%TYPE
198: );
199: -- ----------------------------------------------------------------------------
192: -- ----------------------------------------------------------------------------
193: Procedure chk_appraisal_id
194: (p_appraisal_id in per_assessments.assessment_group_id%TYPE
195: ,p_business_group_id in per_assessments.business_group_id%TYPE
196: ,p_assessment_id in per_assessments.assessment_id%TYPE
197: ,p_object_version_number in per_assessments.object_version_number%TYPE
198: );
199: -- ----------------------------------------------------------------------------
200: -- |---------------------------< insert_validate >----------------------------|
193: Procedure chk_appraisal_id
194: (p_appraisal_id in per_assessments.assessment_group_id%TYPE
195: ,p_business_group_id in per_assessments.business_group_id%TYPE
196: ,p_assessment_id in per_assessments.assessment_id%TYPE
197: ,p_object_version_number in per_assessments.object_version_number%TYPE
198: );
199: -- ----------------------------------------------------------------------------
200: -- |---------------------------< insert_validate >----------------------------|
201: -- ----------------------------------------------------------------------------
314: -- Pre Conditions:
315: -- This private procedure will be called from the user hook procedures.
316: --
317: -- In Parameters:
318: -- the primary key of the table (per_assessments)
319: --
320: -- Post Success:
321: -- Processing continues.
322: --