115: -- Internal Row Handler Use Only.
116: --
117: -- ----------------------------------------------------------------------------
118: procedure chk_df
119: (p_rec in per_bpa_shd.g_rec_type
120: ) is
121: --
122: l_proc varchar2(72) := g_package || 'chk_df';
123: --
124: begin
125: hr_utility.set_location('Entering:'||l_proc,10);
126: --
127: if ((p_rec.processed_assignment_id is not null) and (
128: nvl(per_bpa_shd.g_old_rec.bpa_attribute_category, hr_api.g_varchar2) <>
129: nvl(p_rec.bpa_attribute_category, hr_api.g_varchar2) or
130: nvl(per_bpa_shd.g_old_rec.bpa_attribute1, hr_api.g_varchar2) <>
131: nvl(p_rec.bpa_attribute1, hr_api.g_varchar2) or
132: nvl(per_bpa_shd.g_old_rec.bpa_attribute2, hr_api.g_varchar2) <>
126: --
127: if ((p_rec.processed_assignment_id is not null) and (
128: nvl(per_bpa_shd.g_old_rec.bpa_attribute_category, hr_api.g_varchar2) <>
129: nvl(p_rec.bpa_attribute_category, hr_api.g_varchar2) or
130: nvl(per_bpa_shd.g_old_rec.bpa_attribute1, hr_api.g_varchar2) <>
131: nvl(p_rec.bpa_attribute1, hr_api.g_varchar2) or
132: nvl(per_bpa_shd.g_old_rec.bpa_attribute2, hr_api.g_varchar2) <>
133: nvl(p_rec.bpa_attribute2, hr_api.g_varchar2) or
134: nvl(per_bpa_shd.g_old_rec.bpa_attribute3, hr_api.g_varchar2) <>
128: nvl(per_bpa_shd.g_old_rec.bpa_attribute_category, hr_api.g_varchar2) <>
129: nvl(p_rec.bpa_attribute_category, hr_api.g_varchar2) or
130: nvl(per_bpa_shd.g_old_rec.bpa_attribute1, hr_api.g_varchar2) <>
131: nvl(p_rec.bpa_attribute1, hr_api.g_varchar2) or
132: nvl(per_bpa_shd.g_old_rec.bpa_attribute2, hr_api.g_varchar2) <>
133: nvl(p_rec.bpa_attribute2, hr_api.g_varchar2) or
134: nvl(per_bpa_shd.g_old_rec.bpa_attribute3, hr_api.g_varchar2) <>
135: nvl(p_rec.bpa_attribute3, hr_api.g_varchar2) or
136: nvl(per_bpa_shd.g_old_rec.bpa_attribute4, hr_api.g_varchar2) <>
130: nvl(per_bpa_shd.g_old_rec.bpa_attribute1, hr_api.g_varchar2) <>
131: nvl(p_rec.bpa_attribute1, hr_api.g_varchar2) or
132: nvl(per_bpa_shd.g_old_rec.bpa_attribute2, hr_api.g_varchar2) <>
133: nvl(p_rec.bpa_attribute2, hr_api.g_varchar2) or
134: nvl(per_bpa_shd.g_old_rec.bpa_attribute3, hr_api.g_varchar2) <>
135: nvl(p_rec.bpa_attribute3, hr_api.g_varchar2) or
136: nvl(per_bpa_shd.g_old_rec.bpa_attribute4, hr_api.g_varchar2) <>
137: nvl(p_rec.bpa_attribute4, hr_api.g_varchar2) or
138: nvl(per_bpa_shd.g_old_rec.bpa_attribute5, hr_api.g_varchar2) <>
132: nvl(per_bpa_shd.g_old_rec.bpa_attribute2, hr_api.g_varchar2) <>
133: nvl(p_rec.bpa_attribute2, hr_api.g_varchar2) or
134: nvl(per_bpa_shd.g_old_rec.bpa_attribute3, hr_api.g_varchar2) <>
135: nvl(p_rec.bpa_attribute3, hr_api.g_varchar2) or
136: nvl(per_bpa_shd.g_old_rec.bpa_attribute4, hr_api.g_varchar2) <>
137: nvl(p_rec.bpa_attribute4, hr_api.g_varchar2) or
138: nvl(per_bpa_shd.g_old_rec.bpa_attribute5, hr_api.g_varchar2) <>
139: nvl(p_rec.bpa_attribute5, hr_api.g_varchar2) or
140: nvl(per_bpa_shd.g_old_rec.bpa_attribute6, hr_api.g_varchar2) <>
134: nvl(per_bpa_shd.g_old_rec.bpa_attribute3, hr_api.g_varchar2) <>
135: nvl(p_rec.bpa_attribute3, hr_api.g_varchar2) or
136: nvl(per_bpa_shd.g_old_rec.bpa_attribute4, hr_api.g_varchar2) <>
137: nvl(p_rec.bpa_attribute4, hr_api.g_varchar2) or
138: nvl(per_bpa_shd.g_old_rec.bpa_attribute5, hr_api.g_varchar2) <>
139: nvl(p_rec.bpa_attribute5, hr_api.g_varchar2) or
140: nvl(per_bpa_shd.g_old_rec.bpa_attribute6, hr_api.g_varchar2) <>
141: nvl(p_rec.bpa_attribute6, hr_api.g_varchar2) or
142: nvl(per_bpa_shd.g_old_rec.bpa_attribute7, hr_api.g_varchar2) <>
136: nvl(per_bpa_shd.g_old_rec.bpa_attribute4, hr_api.g_varchar2) <>
137: nvl(p_rec.bpa_attribute4, hr_api.g_varchar2) or
138: nvl(per_bpa_shd.g_old_rec.bpa_attribute5, hr_api.g_varchar2) <>
139: nvl(p_rec.bpa_attribute5, hr_api.g_varchar2) or
140: nvl(per_bpa_shd.g_old_rec.bpa_attribute6, hr_api.g_varchar2) <>
141: nvl(p_rec.bpa_attribute6, hr_api.g_varchar2) or
142: nvl(per_bpa_shd.g_old_rec.bpa_attribute7, hr_api.g_varchar2) <>
143: nvl(p_rec.bpa_attribute7, hr_api.g_varchar2) or
144: nvl(per_bpa_shd.g_old_rec.bpa_attribute8, hr_api.g_varchar2) <>
138: nvl(per_bpa_shd.g_old_rec.bpa_attribute5, hr_api.g_varchar2) <>
139: nvl(p_rec.bpa_attribute5, hr_api.g_varchar2) or
140: nvl(per_bpa_shd.g_old_rec.bpa_attribute6, hr_api.g_varchar2) <>
141: nvl(p_rec.bpa_attribute6, hr_api.g_varchar2) or
142: nvl(per_bpa_shd.g_old_rec.bpa_attribute7, hr_api.g_varchar2) <>
143: nvl(p_rec.bpa_attribute7, hr_api.g_varchar2) or
144: nvl(per_bpa_shd.g_old_rec.bpa_attribute8, hr_api.g_varchar2) <>
145: nvl(p_rec.bpa_attribute8, hr_api.g_varchar2) or
146: nvl(per_bpa_shd.g_old_rec.bpa_attribute9, hr_api.g_varchar2) <>
140: nvl(per_bpa_shd.g_old_rec.bpa_attribute6, hr_api.g_varchar2) <>
141: nvl(p_rec.bpa_attribute6, hr_api.g_varchar2) or
142: nvl(per_bpa_shd.g_old_rec.bpa_attribute7, hr_api.g_varchar2) <>
143: nvl(p_rec.bpa_attribute7, hr_api.g_varchar2) or
144: nvl(per_bpa_shd.g_old_rec.bpa_attribute8, hr_api.g_varchar2) <>
145: nvl(p_rec.bpa_attribute8, hr_api.g_varchar2) or
146: nvl(per_bpa_shd.g_old_rec.bpa_attribute9, hr_api.g_varchar2) <>
147: nvl(p_rec.bpa_attribute9, hr_api.g_varchar2) or
148: nvl(per_bpa_shd.g_old_rec.bpa_attribute10, hr_api.g_varchar2) <>
142: nvl(per_bpa_shd.g_old_rec.bpa_attribute7, hr_api.g_varchar2) <>
143: nvl(p_rec.bpa_attribute7, hr_api.g_varchar2) or
144: nvl(per_bpa_shd.g_old_rec.bpa_attribute8, hr_api.g_varchar2) <>
145: nvl(p_rec.bpa_attribute8, hr_api.g_varchar2) or
146: nvl(per_bpa_shd.g_old_rec.bpa_attribute9, hr_api.g_varchar2) <>
147: nvl(p_rec.bpa_attribute9, hr_api.g_varchar2) or
148: nvl(per_bpa_shd.g_old_rec.bpa_attribute10, hr_api.g_varchar2) <>
149: nvl(p_rec.bpa_attribute10, hr_api.g_varchar2) or
150: nvl(per_bpa_shd.g_old_rec.bpa_attribute11, hr_api.g_varchar2) <>
144: nvl(per_bpa_shd.g_old_rec.bpa_attribute8, hr_api.g_varchar2) <>
145: nvl(p_rec.bpa_attribute8, hr_api.g_varchar2) or
146: nvl(per_bpa_shd.g_old_rec.bpa_attribute9, hr_api.g_varchar2) <>
147: nvl(p_rec.bpa_attribute9, hr_api.g_varchar2) or
148: nvl(per_bpa_shd.g_old_rec.bpa_attribute10, hr_api.g_varchar2) <>
149: nvl(p_rec.bpa_attribute10, hr_api.g_varchar2) or
150: nvl(per_bpa_shd.g_old_rec.bpa_attribute11, hr_api.g_varchar2) <>
151: nvl(p_rec.bpa_attribute11, hr_api.g_varchar2) or
152: nvl(per_bpa_shd.g_old_rec.bpa_attribute12, hr_api.g_varchar2) <>
146: nvl(per_bpa_shd.g_old_rec.bpa_attribute9, hr_api.g_varchar2) <>
147: nvl(p_rec.bpa_attribute9, hr_api.g_varchar2) or
148: nvl(per_bpa_shd.g_old_rec.bpa_attribute10, hr_api.g_varchar2) <>
149: nvl(p_rec.bpa_attribute10, hr_api.g_varchar2) or
150: nvl(per_bpa_shd.g_old_rec.bpa_attribute11, hr_api.g_varchar2) <>
151: nvl(p_rec.bpa_attribute11, hr_api.g_varchar2) or
152: nvl(per_bpa_shd.g_old_rec.bpa_attribute12, hr_api.g_varchar2) <>
153: nvl(p_rec.bpa_attribute12, hr_api.g_varchar2) or
154: nvl(per_bpa_shd.g_old_rec.bpa_attribute13, hr_api.g_varchar2) <>
148: nvl(per_bpa_shd.g_old_rec.bpa_attribute10, hr_api.g_varchar2) <>
149: nvl(p_rec.bpa_attribute10, hr_api.g_varchar2) or
150: nvl(per_bpa_shd.g_old_rec.bpa_attribute11, hr_api.g_varchar2) <>
151: nvl(p_rec.bpa_attribute11, hr_api.g_varchar2) or
152: nvl(per_bpa_shd.g_old_rec.bpa_attribute12, hr_api.g_varchar2) <>
153: nvl(p_rec.bpa_attribute12, hr_api.g_varchar2) or
154: nvl(per_bpa_shd.g_old_rec.bpa_attribute13, hr_api.g_varchar2) <>
155: nvl(p_rec.bpa_attribute13, hr_api.g_varchar2) or
156: nvl(per_bpa_shd.g_old_rec.bpa_attribute14, hr_api.g_varchar2) <>
150: nvl(per_bpa_shd.g_old_rec.bpa_attribute11, hr_api.g_varchar2) <>
151: nvl(p_rec.bpa_attribute11, hr_api.g_varchar2) or
152: nvl(per_bpa_shd.g_old_rec.bpa_attribute12, hr_api.g_varchar2) <>
153: nvl(p_rec.bpa_attribute12, hr_api.g_varchar2) or
154: nvl(per_bpa_shd.g_old_rec.bpa_attribute13, hr_api.g_varchar2) <>
155: nvl(p_rec.bpa_attribute13, hr_api.g_varchar2) or
156: nvl(per_bpa_shd.g_old_rec.bpa_attribute14, hr_api.g_varchar2) <>
157: nvl(p_rec.bpa_attribute14, hr_api.g_varchar2) or
158: nvl(per_bpa_shd.g_old_rec.bpa_attribute15, hr_api.g_varchar2) <>
152: nvl(per_bpa_shd.g_old_rec.bpa_attribute12, hr_api.g_varchar2) <>
153: nvl(p_rec.bpa_attribute12, hr_api.g_varchar2) or
154: nvl(per_bpa_shd.g_old_rec.bpa_attribute13, hr_api.g_varchar2) <>
155: nvl(p_rec.bpa_attribute13, hr_api.g_varchar2) or
156: nvl(per_bpa_shd.g_old_rec.bpa_attribute14, hr_api.g_varchar2) <>
157: nvl(p_rec.bpa_attribute14, hr_api.g_varchar2) or
158: nvl(per_bpa_shd.g_old_rec.bpa_attribute15, hr_api.g_varchar2) <>
159: nvl(p_rec.bpa_attribute15, hr_api.g_varchar2) or
160: nvl(per_bpa_shd.g_old_rec.bpa_attribute16, hr_api.g_varchar2) <>
154: nvl(per_bpa_shd.g_old_rec.bpa_attribute13, hr_api.g_varchar2) <>
155: nvl(p_rec.bpa_attribute13, hr_api.g_varchar2) or
156: nvl(per_bpa_shd.g_old_rec.bpa_attribute14, hr_api.g_varchar2) <>
157: nvl(p_rec.bpa_attribute14, hr_api.g_varchar2) or
158: nvl(per_bpa_shd.g_old_rec.bpa_attribute15, hr_api.g_varchar2) <>
159: nvl(p_rec.bpa_attribute15, hr_api.g_varchar2) or
160: nvl(per_bpa_shd.g_old_rec.bpa_attribute16, hr_api.g_varchar2) <>
161: nvl(p_rec.bpa_attribute16, hr_api.g_varchar2) or
162: nvl(per_bpa_shd.g_old_rec.bpa_attribute17, hr_api.g_varchar2) <>
156: nvl(per_bpa_shd.g_old_rec.bpa_attribute14, hr_api.g_varchar2) <>
157: nvl(p_rec.bpa_attribute14, hr_api.g_varchar2) or
158: nvl(per_bpa_shd.g_old_rec.bpa_attribute15, hr_api.g_varchar2) <>
159: nvl(p_rec.bpa_attribute15, hr_api.g_varchar2) or
160: nvl(per_bpa_shd.g_old_rec.bpa_attribute16, hr_api.g_varchar2) <>
161: nvl(p_rec.bpa_attribute16, hr_api.g_varchar2) or
162: nvl(per_bpa_shd.g_old_rec.bpa_attribute17, hr_api.g_varchar2) <>
163: nvl(p_rec.bpa_attribute17, hr_api.g_varchar2) or
164: nvl(per_bpa_shd.g_old_rec.bpa_attribute18, hr_api.g_varchar2) <>
158: nvl(per_bpa_shd.g_old_rec.bpa_attribute15, hr_api.g_varchar2) <>
159: nvl(p_rec.bpa_attribute15, hr_api.g_varchar2) or
160: nvl(per_bpa_shd.g_old_rec.bpa_attribute16, hr_api.g_varchar2) <>
161: nvl(p_rec.bpa_attribute16, hr_api.g_varchar2) or
162: nvl(per_bpa_shd.g_old_rec.bpa_attribute17, hr_api.g_varchar2) <>
163: nvl(p_rec.bpa_attribute17, hr_api.g_varchar2) or
164: nvl(per_bpa_shd.g_old_rec.bpa_attribute18, hr_api.g_varchar2) <>
165: nvl(p_rec.bpa_attribute18, hr_api.g_varchar2) or
166: nvl(per_bpa_shd.g_old_rec.bpa_attribute19, hr_api.g_varchar2) <>
160: nvl(per_bpa_shd.g_old_rec.bpa_attribute16, hr_api.g_varchar2) <>
161: nvl(p_rec.bpa_attribute16, hr_api.g_varchar2) or
162: nvl(per_bpa_shd.g_old_rec.bpa_attribute17, hr_api.g_varchar2) <>
163: nvl(p_rec.bpa_attribute17, hr_api.g_varchar2) or
164: nvl(per_bpa_shd.g_old_rec.bpa_attribute18, hr_api.g_varchar2) <>
165: nvl(p_rec.bpa_attribute18, hr_api.g_varchar2) or
166: nvl(per_bpa_shd.g_old_rec.bpa_attribute19, hr_api.g_varchar2) <>
167: nvl(p_rec.bpa_attribute19, hr_api.g_varchar2) or
168: nvl(per_bpa_shd.g_old_rec.bpa_attribute20, hr_api.g_varchar2) <>
162: nvl(per_bpa_shd.g_old_rec.bpa_attribute17, hr_api.g_varchar2) <>
163: nvl(p_rec.bpa_attribute17, hr_api.g_varchar2) or
164: nvl(per_bpa_shd.g_old_rec.bpa_attribute18, hr_api.g_varchar2) <>
165: nvl(p_rec.bpa_attribute18, hr_api.g_varchar2) or
166: nvl(per_bpa_shd.g_old_rec.bpa_attribute19, hr_api.g_varchar2) <>
167: nvl(p_rec.bpa_attribute19, hr_api.g_varchar2) or
168: nvl(per_bpa_shd.g_old_rec.bpa_attribute20, hr_api.g_varchar2) <>
169: nvl(p_rec.bpa_attribute20, hr_api.g_varchar2) or
170: nvl(per_bpa_shd.g_old_rec.bpa_attribute21, hr_api.g_varchar2) <>
164: nvl(per_bpa_shd.g_old_rec.bpa_attribute18, hr_api.g_varchar2) <>
165: nvl(p_rec.bpa_attribute18, hr_api.g_varchar2) or
166: nvl(per_bpa_shd.g_old_rec.bpa_attribute19, hr_api.g_varchar2) <>
167: nvl(p_rec.bpa_attribute19, hr_api.g_varchar2) or
168: nvl(per_bpa_shd.g_old_rec.bpa_attribute20, hr_api.g_varchar2) <>
169: nvl(p_rec.bpa_attribute20, hr_api.g_varchar2) or
170: nvl(per_bpa_shd.g_old_rec.bpa_attribute21, hr_api.g_varchar2) <>
171: nvl(p_rec.bpa_attribute21, hr_api.g_varchar2) or
172: nvl(per_bpa_shd.g_old_rec.bpa_attribute22, hr_api.g_varchar2) <>
166: nvl(per_bpa_shd.g_old_rec.bpa_attribute19, hr_api.g_varchar2) <>
167: nvl(p_rec.bpa_attribute19, hr_api.g_varchar2) or
168: nvl(per_bpa_shd.g_old_rec.bpa_attribute20, hr_api.g_varchar2) <>
169: nvl(p_rec.bpa_attribute20, hr_api.g_varchar2) or
170: nvl(per_bpa_shd.g_old_rec.bpa_attribute21, hr_api.g_varchar2) <>
171: nvl(p_rec.bpa_attribute21, hr_api.g_varchar2) or
172: nvl(per_bpa_shd.g_old_rec.bpa_attribute22, hr_api.g_varchar2) <>
173: nvl(p_rec.bpa_attribute22, hr_api.g_varchar2) or
174: nvl(per_bpa_shd.g_old_rec.bpa_attribute23, hr_api.g_varchar2) <>
168: nvl(per_bpa_shd.g_old_rec.bpa_attribute20, hr_api.g_varchar2) <>
169: nvl(p_rec.bpa_attribute20, hr_api.g_varchar2) or
170: nvl(per_bpa_shd.g_old_rec.bpa_attribute21, hr_api.g_varchar2) <>
171: nvl(p_rec.bpa_attribute21, hr_api.g_varchar2) or
172: nvl(per_bpa_shd.g_old_rec.bpa_attribute22, hr_api.g_varchar2) <>
173: nvl(p_rec.bpa_attribute22, hr_api.g_varchar2) or
174: nvl(per_bpa_shd.g_old_rec.bpa_attribute23, hr_api.g_varchar2) <>
175: nvl(p_rec.bpa_attribute23, hr_api.g_varchar2) or
176: nvl(per_bpa_shd.g_old_rec.bpa_attribute24, hr_api.g_varchar2) <>
170: nvl(per_bpa_shd.g_old_rec.bpa_attribute21, hr_api.g_varchar2) <>
171: nvl(p_rec.bpa_attribute21, hr_api.g_varchar2) or
172: nvl(per_bpa_shd.g_old_rec.bpa_attribute22, hr_api.g_varchar2) <>
173: nvl(p_rec.bpa_attribute22, hr_api.g_varchar2) or
174: nvl(per_bpa_shd.g_old_rec.bpa_attribute23, hr_api.g_varchar2) <>
175: nvl(p_rec.bpa_attribute23, hr_api.g_varchar2) or
176: nvl(per_bpa_shd.g_old_rec.bpa_attribute24, hr_api.g_varchar2) <>
177: nvl(p_rec.bpa_attribute24, hr_api.g_varchar2) or
178: nvl(per_bpa_shd.g_old_rec.bpa_attribute25, hr_api.g_varchar2) <>
172: nvl(per_bpa_shd.g_old_rec.bpa_attribute22, hr_api.g_varchar2) <>
173: nvl(p_rec.bpa_attribute22, hr_api.g_varchar2) or
174: nvl(per_bpa_shd.g_old_rec.bpa_attribute23, hr_api.g_varchar2) <>
175: nvl(p_rec.bpa_attribute23, hr_api.g_varchar2) or
176: nvl(per_bpa_shd.g_old_rec.bpa_attribute24, hr_api.g_varchar2) <>
177: nvl(p_rec.bpa_attribute24, hr_api.g_varchar2) or
178: nvl(per_bpa_shd.g_old_rec.bpa_attribute25, hr_api.g_varchar2) <>
179: nvl(p_rec.bpa_attribute25, hr_api.g_varchar2) or
180: nvl(per_bpa_shd.g_old_rec.bpa_attribute26, hr_api.g_varchar2) <>
174: nvl(per_bpa_shd.g_old_rec.bpa_attribute23, hr_api.g_varchar2) <>
175: nvl(p_rec.bpa_attribute23, hr_api.g_varchar2) or
176: nvl(per_bpa_shd.g_old_rec.bpa_attribute24, hr_api.g_varchar2) <>
177: nvl(p_rec.bpa_attribute24, hr_api.g_varchar2) or
178: nvl(per_bpa_shd.g_old_rec.bpa_attribute25, hr_api.g_varchar2) <>
179: nvl(p_rec.bpa_attribute25, hr_api.g_varchar2) or
180: nvl(per_bpa_shd.g_old_rec.bpa_attribute26, hr_api.g_varchar2) <>
181: nvl(p_rec.bpa_attribute26, hr_api.g_varchar2) or
182: nvl(per_bpa_shd.g_old_rec.bpa_attribute27, hr_api.g_varchar2) <>
176: nvl(per_bpa_shd.g_old_rec.bpa_attribute24, hr_api.g_varchar2) <>
177: nvl(p_rec.bpa_attribute24, hr_api.g_varchar2) or
178: nvl(per_bpa_shd.g_old_rec.bpa_attribute25, hr_api.g_varchar2) <>
179: nvl(p_rec.bpa_attribute25, hr_api.g_varchar2) or
180: nvl(per_bpa_shd.g_old_rec.bpa_attribute26, hr_api.g_varchar2) <>
181: nvl(p_rec.bpa_attribute26, hr_api.g_varchar2) or
182: nvl(per_bpa_shd.g_old_rec.bpa_attribute27, hr_api.g_varchar2) <>
183: nvl(p_rec.bpa_attribute27, hr_api.g_varchar2) or
184: nvl(per_bpa_shd.g_old_rec.bpa_attribute28, hr_api.g_varchar2) <>
178: nvl(per_bpa_shd.g_old_rec.bpa_attribute25, hr_api.g_varchar2) <>
179: nvl(p_rec.bpa_attribute25, hr_api.g_varchar2) or
180: nvl(per_bpa_shd.g_old_rec.bpa_attribute26, hr_api.g_varchar2) <>
181: nvl(p_rec.bpa_attribute26, hr_api.g_varchar2) or
182: nvl(per_bpa_shd.g_old_rec.bpa_attribute27, hr_api.g_varchar2) <>
183: nvl(p_rec.bpa_attribute27, hr_api.g_varchar2) or
184: nvl(per_bpa_shd.g_old_rec.bpa_attribute28, hr_api.g_varchar2) <>
185: nvl(p_rec.bpa_attribute28, hr_api.g_varchar2) or
186: nvl(per_bpa_shd.g_old_rec.bpa_attribute29, hr_api.g_varchar2) <>
180: nvl(per_bpa_shd.g_old_rec.bpa_attribute26, hr_api.g_varchar2) <>
181: nvl(p_rec.bpa_attribute26, hr_api.g_varchar2) or
182: nvl(per_bpa_shd.g_old_rec.bpa_attribute27, hr_api.g_varchar2) <>
183: nvl(p_rec.bpa_attribute27, hr_api.g_varchar2) or
184: nvl(per_bpa_shd.g_old_rec.bpa_attribute28, hr_api.g_varchar2) <>
185: nvl(p_rec.bpa_attribute28, hr_api.g_varchar2) or
186: nvl(per_bpa_shd.g_old_rec.bpa_attribute29, hr_api.g_varchar2) <>
187: nvl(p_rec.bpa_attribute29, hr_api.g_varchar2) or
188: nvl(per_bpa_shd.g_old_rec.bpa_attribute30, hr_api.g_varchar2) <>
182: nvl(per_bpa_shd.g_old_rec.bpa_attribute27, hr_api.g_varchar2) <>
183: nvl(p_rec.bpa_attribute27, hr_api.g_varchar2) or
184: nvl(per_bpa_shd.g_old_rec.bpa_attribute28, hr_api.g_varchar2) <>
185: nvl(p_rec.bpa_attribute28, hr_api.g_varchar2) or
186: nvl(per_bpa_shd.g_old_rec.bpa_attribute29, hr_api.g_varchar2) <>
187: nvl(p_rec.bpa_attribute29, hr_api.g_varchar2) or
188: nvl(per_bpa_shd.g_old_rec.bpa_attribute30, hr_api.g_varchar2) <>
189: nvl(p_rec.bpa_attribute30, hr_api.g_varchar2) ))
190: or (p_rec.processed_assignment_id is null) then
184: nvl(per_bpa_shd.g_old_rec.bpa_attribute28, hr_api.g_varchar2) <>
185: nvl(p_rec.bpa_attribute28, hr_api.g_varchar2) or
186: nvl(per_bpa_shd.g_old_rec.bpa_attribute29, hr_api.g_varchar2) <>
187: nvl(p_rec.bpa_attribute29, hr_api.g_varchar2) or
188: nvl(per_bpa_shd.g_old_rec.bpa_attribute30, hr_api.g_varchar2) <>
189: nvl(p_rec.bpa_attribute30, hr_api.g_varchar2) ))
190: or (p_rec.processed_assignment_id is null) then
191: --
192: -- Only execute the validation if absolutely necessary:
291: --
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure chk_non_updateable_args
295: (p_rec in per_bpa_shd.g_rec_type
296: ) IS
297: --
298: l_proc varchar2(72) := g_package || 'check_non_updateable_args';
299: l_error EXCEPTION;
304: --
305: -- Only proceed with the validation if a row exists for the current
306: -- record in the HR Schema.
307: --
308: IF NOT per_bpa_shd.api_updating
309: (p_processed_assignment_id => p_rec.processed_assignment_id
310: ,p_object_version_number => p_rec.object_version_number
311: ) THEN
312: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
316: --
317: hr_utility.set_location(l_proc,10);
318: --
319: IF nvl(p_rec.payroll_run_id, hr_api.g_number) <>
320: per_bpa_shd.g_old_rec.payroll_run_id then
321: l_argument:='payroll_run_id';
322: raise l_error;
323: END IF;
324: hr_utility.set_location(l_proc,20);
323: END IF;
324: hr_utility.set_location(l_proc,20);
325: --
326: IF nvl(p_rec.assignment_id, hr_api.g_number) <>
327: per_bpa_shd.g_old_rec.assignment_id then
328: l_argument:='assigment_id';
329: raise l_error;
330: END IF;
331: hr_utility.set_location(l_proc,30);
448: --
449: -- The payroll_run_id doesn't exist in the run table
450: -- so error
451: --
452: per_bpa_shd.constraint_error
453: (p_constraint_name => 'PER_BF_PROCESSED_ASSIGNS_FK1');
454: --
455: END IF;
456: CLOSE csr_get_run_dates;
563: fetch csr_balance_amount into l_exists;
564: if csr_balance_amount%FOUND then
565: --child row exists - raise error by calling constraint error
566: close csr_balance_amount;
567: per_bpa_shd.constraint_error('PER_BF_PROCESSED_ASSIGNS_BPAB');
568: end if;
569: close csr_balance_amount;
570: --
571: open csr_payment_detail;
572: fetch csr_payment_detail into l_exists;
573: if csr_payment_detail%FOUND then
574: --child row exists - raise error by calling constraint error
575: close csr_payment_detail;
576: per_bpa_shd.constraint_error('PER_BF_PROCESSED_ASSIGNS_BPAP');
577: end if;
578: close csr_payment_detail;
579: --
580: end if;
618: fetch csr_id_unique into l_exists;
619: if csr_id_unique%FOUND then
620: -- -ids are not unique - raise error by calling contraint error
621: close csr_id_unique;
622: per_bpa_shd.constraint_error('PER_BF_PROCESSED_ASSIGNS_UK1');
623: end if;
624: close csr_id_unique;
625: --
626: hr_utility.set_location(' Leaving: '||l_proc, 50);
631: -- |---------------------------< insert_validate >----------------------------|
632: -- ----------------------------------------------------------------------------
633: Procedure insert_validate
634: (p_effective_date in date
635: ,p_rec in per_bpa_shd.g_rec_type
636: ) is
637: --
638: l_proc varchar2(72) := g_package||'insert_validate';
639: --
678: -- |---------------------------< update_validate >----------------------------|
679: -- ----------------------------------------------------------------------------
680: Procedure update_validate
681: (p_effective_date in date
682: ,p_rec in per_bpa_shd.g_rec_type
683: ) is
684: --
685: l_proc varchar2(72) := g_package||'update_validate';
686: --
707: -- ----------------------------------------------------------------------------
708: -- |---------------------------< delete_validate >----------------------------|
709: -- ----------------------------------------------------------------------------
710: Procedure delete_validate
711: (p_rec in per_bpa_shd.g_rec_type
712: ) is
713: --
714: l_proc varchar2(72) := g_package||'delete_validate';
715: --