DBA Data[Home] [Help]

APPS.PER_BPA_BUS dependencies on PER_BPA_SHD

Line 119: (p_rec in per_bpa_shd.g_rec_type

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

Line 128: nvl(per_bpa_shd.g_old_rec.bpa_attribute_category, hr_api.g_varchar2) <>

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

Line 130: nvl(per_bpa_shd.g_old_rec.bpa_attribute1, 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) <>

Line 132: nvl(per_bpa_shd.g_old_rec.bpa_attribute2, 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) <>

Line 134: nvl(per_bpa_shd.g_old_rec.bpa_attribute3, 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) <>

Line 136: nvl(per_bpa_shd.g_old_rec.bpa_attribute4, 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) <>

Line 138: nvl(per_bpa_shd.g_old_rec.bpa_attribute5, 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) <>

Line 140: nvl(per_bpa_shd.g_old_rec.bpa_attribute6, 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) <>

Line 142: nvl(per_bpa_shd.g_old_rec.bpa_attribute7, 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) <>

Line 144: nvl(per_bpa_shd.g_old_rec.bpa_attribute8, 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) <>

Line 146: nvl(per_bpa_shd.g_old_rec.bpa_attribute9, 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) <>

Line 148: nvl(per_bpa_shd.g_old_rec.bpa_attribute10, 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) <>

Line 150: nvl(per_bpa_shd.g_old_rec.bpa_attribute11, 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) <>

Line 152: nvl(per_bpa_shd.g_old_rec.bpa_attribute12, 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) <>

Line 154: nvl(per_bpa_shd.g_old_rec.bpa_attribute13, 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) <>

Line 156: nvl(per_bpa_shd.g_old_rec.bpa_attribute14, 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) <>

Line 158: nvl(per_bpa_shd.g_old_rec.bpa_attribute15, 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) <>

Line 160: nvl(per_bpa_shd.g_old_rec.bpa_attribute16, 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) <>

Line 162: nvl(per_bpa_shd.g_old_rec.bpa_attribute17, 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) <>

Line 164: nvl(per_bpa_shd.g_old_rec.bpa_attribute18, 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) <>

Line 166: nvl(per_bpa_shd.g_old_rec.bpa_attribute19, 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) <>

Line 168: nvl(per_bpa_shd.g_old_rec.bpa_attribute20, 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) <>

Line 170: nvl(per_bpa_shd.g_old_rec.bpa_attribute21, 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) <>

Line 172: nvl(per_bpa_shd.g_old_rec.bpa_attribute22, 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) <>

Line 174: nvl(per_bpa_shd.g_old_rec.bpa_attribute23, 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) <>

Line 176: nvl(per_bpa_shd.g_old_rec.bpa_attribute24, 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) <>

Line 178: nvl(per_bpa_shd.g_old_rec.bpa_attribute25, 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) <>

Line 180: nvl(per_bpa_shd.g_old_rec.bpa_attribute26, 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) <>

Line 182: nvl(per_bpa_shd.g_old_rec.bpa_attribute27, 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) <>

Line 184: nvl(per_bpa_shd.g_old_rec.bpa_attribute28, 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) <>

Line 186: nvl(per_bpa_shd.g_old_rec.bpa_attribute29, 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

Line 188: nvl(per_bpa_shd.g_old_rec.bpa_attribute30, hr_api.g_varchar2) <>

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:

Line 295: (p_rec in per_bpa_shd.g_rec_type

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;

Line 308: IF NOT per_bpa_shd.api_updating

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

Line 320: per_bpa_shd.g_old_rec.payroll_run_id then

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

Line 327: per_bpa_shd.g_old_rec.assignment_id then

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

Line 452: per_bpa_shd.constraint_error

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;

Line 567: per_bpa_shd.constraint_error('PER_BF_PROCESSED_ASSIGNS_BPAB');

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;

Line 576: per_bpa_shd.constraint_error('PER_BF_PROCESSED_ASSIGNS_BPAP');

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;

Line 622: per_bpa_shd.constraint_error('PER_BF_PROCESSED_ASSIGNS_UK1');

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

Line 635: ,p_rec in per_bpa_shd.g_rec_type

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

Line 682: ,p_rec in per_bpa_shd.g_rec_type

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

Line 711: (p_rec in per_bpa_shd.g_rec_type

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