APPS.PER_ASN_BUS dependencies on PER_ASSESSMENTS

Line 18: (p_assessment_id in per_assessments.assessment_id%TYPE

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

Line 19: ,p_assessment_type_id in per_assessments.assessment_type_id%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: );

Line 20: ,p_assessment_date in per_assessments.assessment_date%TYPE

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: -- ----------------------------------------------------------------------------

Line 21: ,p_business_group_id in per_assessments.business_group_id%TYPE

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 >---------------------------|

Line 22: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 36: (p_assessment_date in per_assessments.assessment_date%TYPE

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: -- ----------------------------------------------------------------------------

Line 37: ,p_assessment_id in per_assessments.assessment_id%TYPE

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 >---------------------------------|

Line 38: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 52: (p_assessment_id in per_assessments.assessment_id%TYPE

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

Line 53: ,p_person_id in per_assessments.person_id%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: );

Line 54: ,p_business_group_id in per_assessments.business_group_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 55: ,p_assessment_date in per_assessments.assessment_date%TYPE

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 >------------------------|

Line 56: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 70: (p_assessor_person_id in per_assessments.assessor_person_id%TYPE

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

Line 71: ,p_business_group_id in per_assessments.business_group_id%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: );

Line 72: ,p_assessment_date in per_assessments.assessment_date%TYPE

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: -- ----------------------------------------------------------------------------

Line 73: ,p_assessment_id in per_assessments.assessment_id%TYPE

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 >-----------------------------|

Line 74: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 88: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE

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: );

Line 89: ,p_group_date in per_assessments.group_date%TYPE

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: -- ----------------------------------------------------------------------------

Line 90: ,p_assessment_id in per_assessments.assessment_id%TYPE

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 >------------------------|

Line 91: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 105: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE

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

Line 106: ,p_business_group_id in per_assessments.business_group_id%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: );

Line 107: ,p_group_date in per_assessments.group_date%TYPE

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: -- ----------------------------------------------------------------------------

Line 108: ,p_assessment_id in per_assessments.assessment_id%TYPE

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 >------------------------------------|

Line 109: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 123: (p_status in per_assessments.status%TYPE

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: );

Line 125: ,p_assessment_id in per_assessments.assessment_id%TYPE

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 >-------------------------|

Line 126: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 140: (p_assessment_period_start_date in per_assessments.assessment_period_start_date%TYPE

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: );

Line 141: ,p_assessment_period_end_date in per_assessments.assessment_period_end_date%TYPE

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: -- ----------------------------------------------------------------------------

Line 142: ,p_assessment_id in per_assessments.assessment_id%TYPE

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 >------------------------|

Line 143: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 157: (p_assessment_id in per_assessments.assessment_id%TYPE

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

Line 158: ,p_assessment_type_id in per_assessments.assessment_type_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

Line 159: ,p_assessment_date in per_assessments.assessment_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

Line 160: ,p_person_id in per_assessments.person_id%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: );

Line 161: ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 162: ,p_group_date in per_assessments.group_date%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: -- ----------------------------------------------------------------------------
166: -- |------------------------< chk_assessment_group_id >-----------------------|

Line 163: ,p_object_version_number in per_assessments.object_version_number%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 >-----------------------|
167: -- ----------------------------------------------------------------------------

Line 177: (p_assessment_group_id in per_assessments.assessment_group_id%TYPE

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: );

Line 178: ,p_business_group_id in per_assessments.business_group_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 179: ,p_assessment_id in per_assessments.assessment_id%TYPE

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 >------------------------------|

Line 180: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 194: (p_appraisal_id in per_assessments.assessment_group_id%TYPE

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: );

Line 195: ,p_business_group_id in per_assessments.business_group_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 196: ,p_assessment_id in per_assessments.assessment_id%TYPE

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 >----------------------------|

Line 197: ,p_object_version_number in per_assessments.object_version_number%TYPE

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: -- ----------------------------------------------------------------------------

Line 318: -- the primary key of the table (per_assessments)

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: --