APPS.PER_BPA_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error(p_api_name => l_proc

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error(p_api_name => l_proc
48: ,p_argument => 'PROCESSED_ASSIGNMENT_ID'
49: ,p_argument_value => p_processed_assignment_id);
50: --
51: if ( nvl(g_processed_assignment_id, hr_api.g_number)

Line 51: if ( nvl(g_processed_assignment_id, hr_api.g_number)

47: hr_api.mandatory_arg_error(p_api_name => l_proc
48: ,p_argument => 'PROCESSED_ASSIGNMENT_ID'
49: ,p_argument_value => p_processed_assignment_id);
50: --
51: if ( nvl(g_processed_assignment_id, hr_api.g_number)
52: = p_processed_assignment_id) then
53: --
54: -- The legislation code has already been found with a previous
55: -- call to this function. Just return the value in the global

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 129: nvl(p_rec.bpa_attribute_category, hr_api.g_varchar2) or

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) <>
133: nvl(p_rec.bpa_attribute2, hr_api.g_varchar2) or

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 131: nvl(p_rec.bpa_attribute1, hr_api.g_varchar2) or

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) <>
135: nvl(p_rec.bpa_attribute3, hr_api.g_varchar2) or

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 133: nvl(p_rec.bpa_attribute2, hr_api.g_varchar2) or

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) <>
137: nvl(p_rec.bpa_attribute4, hr_api.g_varchar2) or

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 135: nvl(p_rec.bpa_attribute3, hr_api.g_varchar2) or

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) <>
139: nvl(p_rec.bpa_attribute5, hr_api.g_varchar2) or

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 137: nvl(p_rec.bpa_attribute4, hr_api.g_varchar2) or

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) <>
141: nvl(p_rec.bpa_attribute6, hr_api.g_varchar2) or

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 139: nvl(p_rec.bpa_attribute5, hr_api.g_varchar2) or

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) <>
143: nvl(p_rec.bpa_attribute7, hr_api.g_varchar2) or

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 141: nvl(p_rec.bpa_attribute6, hr_api.g_varchar2) or

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) <>
145: nvl(p_rec.bpa_attribute8, hr_api.g_varchar2) or

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 143: nvl(p_rec.bpa_attribute7, hr_api.g_varchar2) or

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) <>
147: nvl(p_rec.bpa_attribute9, hr_api.g_varchar2) or

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 145: nvl(p_rec.bpa_attribute8, hr_api.g_varchar2) or

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) <>
149: nvl(p_rec.bpa_attribute10, hr_api.g_varchar2) or

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 147: nvl(p_rec.bpa_attribute9, hr_api.g_varchar2) or

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) <>
151: nvl(p_rec.bpa_attribute11, hr_api.g_varchar2) or

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 149: nvl(p_rec.bpa_attribute10, hr_api.g_varchar2) or

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) <>
153: nvl(p_rec.bpa_attribute12, hr_api.g_varchar2) or

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 151: nvl(p_rec.bpa_attribute11, hr_api.g_varchar2) or

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) <>
155: nvl(p_rec.bpa_attribute13, hr_api.g_varchar2) or

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 153: nvl(p_rec.bpa_attribute12, hr_api.g_varchar2) or

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) <>
157: nvl(p_rec.bpa_attribute14, hr_api.g_varchar2) or

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 155: nvl(p_rec.bpa_attribute13, hr_api.g_varchar2) or

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) <>
159: nvl(p_rec.bpa_attribute15, hr_api.g_varchar2) or

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 157: nvl(p_rec.bpa_attribute14, hr_api.g_varchar2) or

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) <>
161: nvl(p_rec.bpa_attribute16, hr_api.g_varchar2) or

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 159: nvl(p_rec.bpa_attribute15, hr_api.g_varchar2) or

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) <>
163: nvl(p_rec.bpa_attribute17, hr_api.g_varchar2) or

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 161: nvl(p_rec.bpa_attribute16, hr_api.g_varchar2) or

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) <>
165: nvl(p_rec.bpa_attribute18, hr_api.g_varchar2) or

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 163: nvl(p_rec.bpa_attribute17, hr_api.g_varchar2) or

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) <>
167: nvl(p_rec.bpa_attribute19, hr_api.g_varchar2) or

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 165: nvl(p_rec.bpa_attribute18, hr_api.g_varchar2) or

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) <>
169: nvl(p_rec.bpa_attribute20, hr_api.g_varchar2) or

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 167: nvl(p_rec.bpa_attribute19, hr_api.g_varchar2) or

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) <>
171: nvl(p_rec.bpa_attribute21, hr_api.g_varchar2) or

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 169: nvl(p_rec.bpa_attribute20, hr_api.g_varchar2) or

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) <>
173: nvl(p_rec.bpa_attribute22, hr_api.g_varchar2) or

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 171: nvl(p_rec.bpa_attribute21, hr_api.g_varchar2) or

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) <>
175: nvl(p_rec.bpa_attribute23, hr_api.g_varchar2) or

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 173: nvl(p_rec.bpa_attribute22, hr_api.g_varchar2) or

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) <>
177: nvl(p_rec.bpa_attribute24, hr_api.g_varchar2) or

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 175: nvl(p_rec.bpa_attribute23, hr_api.g_varchar2) or

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) <>
179: nvl(p_rec.bpa_attribute25, hr_api.g_varchar2) or

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 177: nvl(p_rec.bpa_attribute24, hr_api.g_varchar2) or

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) <>
181: nvl(p_rec.bpa_attribute26, hr_api.g_varchar2) or

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 179: nvl(p_rec.bpa_attribute25, hr_api.g_varchar2) or

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) <>
183: nvl(p_rec.bpa_attribute27, hr_api.g_varchar2) or

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 181: nvl(p_rec.bpa_attribute26, hr_api.g_varchar2) or

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) <>
185: nvl(p_rec.bpa_attribute28, hr_api.g_varchar2) or

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 183: nvl(p_rec.bpa_attribute27, hr_api.g_varchar2) or

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) <>
187: nvl(p_rec.bpa_attribute29, hr_api.g_varchar2) or

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 185: nvl(p_rec.bpa_attribute28, hr_api.g_varchar2) or

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) <>
189: nvl(p_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 187: nvl(p_rec.bpa_attribute29, hr_api.g_varchar2) or

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

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 189: nvl(p_rec.bpa_attribute30, 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:
193: -- a) During update, the structure column value or any

Line 319: IF nvl(p_rec.payroll_run_id, hr_api.g_number) <>

315: END IF;
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;

Line 326: IF nvl(p_rec.assignment_id, hr_api.g_number) <>

322: raise l_error;
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;

Line 336: hr_api.argument_changed_error

332: --
333: --
334: EXCEPTION
335: WHEN l_error THEN
336: hr_api.argument_changed_error
337: (p_api_name => l_proc
338: ,p_argument => l_argument);
339: WHEN OTHERS THEN
340: RAISE;

Line 609: hr_api.mandatory_arg_error(p_api_name => l_proc

605: --
606: BEGIN
607: hr_utility.set_location('Entering: '||l_proc, 10);
608: --
609: hr_api.mandatory_arg_error(p_api_name => l_proc
610: ,p_argument => 'ASSIGNMENT_ID'
611: ,p_argument_value => p_assignment_id);
612: --
613: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 613: hr_api.mandatory_arg_error(p_api_name => l_proc

609: hr_api.mandatory_arg_error(p_api_name => l_proc
610: ,p_argument => 'ASSIGNMENT_ID'
611: ,p_argument_value => p_assignment_id);
612: --
613: hr_api.mandatory_arg_error(p_api_name => l_proc
614: ,p_argument => 'PAYROLL_RUN_ID'
615: ,p_argument_value => p_payroll_run_id);
616: --
617: open csr_id_unique;