eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TMP_BUS dependencies on HR_API

Line 65: hr_api.mandatory_arg_error

61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Ensure that all the mandatory parameter are not null
64: --
65: hr_api.mandatory_arg_error
66: (p_api_name => l_proc
67: ,p_argument => 'form_template_id'
68: ,p_argument_value => p_form_template_id
69: );

Line 71: if ( nvl(hr_tmp_bus.g_form_template_id, hr_api.g_number)

67: ,p_argument => 'form_template_id'
68: ,p_argument_value => p_form_template_id
69: );
70: --
71: if ( nvl(hr_tmp_bus.g_form_template_id, hr_api.g_number)
72: = p_form_template_id) then
73: --
74: -- The legislation code has already been found with a previous
75: -- call to this function. Just return the value in the global

Line 147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

143: begin
144: hr_utility.set_location('Entering:'||l_proc,10);
145: --
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

144: hr_utility.set_location('Entering:'||l_proc,10);
145: --
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

145: --
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 150: nvl(p_rec.attribute1, hr_api.g_varchar2) or

146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 152: nvl(p_rec.attribute2, hr_api.g_varchar2) or

148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 154: nvl(p_rec.attribute3, hr_api.g_varchar2) or

150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 156: nvl(p_rec.attribute4, hr_api.g_varchar2) or

152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 158: nvl(p_rec.attribute5, hr_api.g_varchar2) or

154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 160: nvl(p_rec.attribute6, hr_api.g_varchar2) or

156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 162: nvl(p_rec.attribute7, hr_api.g_varchar2) or

158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 164: nvl(p_rec.attribute8, hr_api.g_varchar2) or

160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 166: nvl(p_rec.attribute9, hr_api.g_varchar2) or

162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 168: nvl(p_rec.attribute10, hr_api.g_varchar2) or

164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 170: nvl(p_rec.attribute11, hr_api.g_varchar2) or

166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 172: nvl(p_rec.attribute12, hr_api.g_varchar2) or

168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 174: nvl(p_rec.attribute13, hr_api.g_varchar2) or

170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 176: nvl(p_rec.attribute14, hr_api.g_varchar2) or

172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 178: nvl(p_rec.attribute15, hr_api.g_varchar2) or

174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 180: nvl(p_rec.attribute16, hr_api.g_varchar2) or

176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 182: nvl(p_rec.attribute17, hr_api.g_varchar2) or

178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 184: nvl(p_rec.attribute18, hr_api.g_varchar2) or

180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or

Line 185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 186: nvl(p_rec.attribute19, hr_api.g_varchar2) or

182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or

Line 187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 188: nvl(p_rec.attribute20, hr_api.g_varchar2) or

184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or

Line 189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 190: nvl(p_rec.attribute21, hr_api.g_varchar2) or

186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or

Line 191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 192: nvl(p_rec.attribute22, hr_api.g_varchar2) or

188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or

Line 193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 194: nvl(p_rec.attribute23, hr_api.g_varchar2) or

190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or

Line 195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 196: nvl(p_rec.attribute24, hr_api.g_varchar2) or

192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or

Line 197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 198: nvl(p_rec.attribute25, hr_api.g_varchar2) or

194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or

Line 199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 200: nvl(p_rec.attribute26, hr_api.g_varchar2) or

196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or

Line 201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 202: nvl(p_rec.attribute27, hr_api.g_varchar2) or

198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or

Line 203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 204: nvl(p_rec.attribute28, hr_api.g_varchar2) or

200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )

Line 205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then

Line 206: nvl(p_rec.attribute29, hr_api.g_varchar2) or

202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then
210: --

Line 207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then
210: --
211: -- Only execute the validation if absolutely necessary:

Line 208: nvl(p_rec.attribute30, hr_api.g_varchar2) )

204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then
210: --
211: -- Only execute the validation if absolutely necessary:
212: -- a) During update, the structure column value or any

Line 337: IF (nvl(p_rec.application_id,hr_api.g_number) <>

333: fnd_message.set_token('STEP ', '5');
334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
338: nvl(hr_tmp_shd.g_old_rec.application_id,hr_api.g_number)
339: ) THEN
340: l_argument := 'application_id';
341: RAISE l_error;

Line 338: nvl(hr_tmp_shd.g_old_rec.application_id,hr_api.g_number)

334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
338: nvl(hr_tmp_shd.g_old_rec.application_id,hr_api.g_number)
339: ) THEN
340: l_argument := 'application_id';
341: RAISE l_error;
342: END IF;

Line 344: IF (nvl(p_rec.form_id,hr_api.g_number) <>

340: l_argument := 'application_id';
341: RAISE l_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_id,hr_api.g_number) <>
345: nvl(hr_tmp_shd.g_old_rec.form_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_id';
348: RAISE l_error;

Line 345: nvl(hr_tmp_shd.g_old_rec.form_id,hr_api.g_number)

341: RAISE l_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_id,hr_api.g_number) <>
345: nvl(hr_tmp_shd.g_old_rec.form_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_id';
348: RAISE l_error;
349: END IF;

Line 353: hr_api.argument_changed_error

349: END IF;
350: --
351: EXCEPTION
352: WHEN l_error THEN
353: hr_api.argument_changed_error
354: (p_api_name => l_proc
355: ,p_argument => l_argument);
356: WHEN OTHERS THEN
357: RAISE;

Line 385: hr_api.mandatory_arg_error

381: hr_utility.set_location('Entering:'||l_proc, 10);
382: --
383: -- Check value has been passed
384: --
385: hr_api.mandatory_arg_error
386: (p_api_name => l_proc
387: ,p_argument => 'application_id'
388: ,p_argument_value => p_application_id
389: );

Line 432: hr_api.mandatory_arg_error

428: hr_utility.set_location('Entering:'||l_proc, 10);
429: --
430: -- Check value has been passed
431: --
432: hr_api.mandatory_arg_error
433: (p_api_name => l_proc
434: ,p_argument => 'form_id'
435: ,p_argument_value => p_form_id
436: );

Line 514: hr_api.mandatory_arg_error

510: hr_utility.set_location('Entering:'||l_proc, 10);
511: --
512: -- Check value has been passed
513: --
514: hr_api.mandatory_arg_error
515: (p_api_name => l_proc
516: ,p_argument => 'template_name'
517: ,p_argument_value => p_template_name
518: );

Line 550: hr_api.mandatory_arg_error

546: hr_utility.set_location('Entering:'||l_proc, 10);
547: --
548: -- Check mandatory arguments have been set
549: --
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc
552: ,p_argument => 'effective_date'
553: ,p_argument_value => p_effective_date
554: );

Line 565: and nvl(hr_tmp_shd.g_old_rec.enabled_flag,hr_api.g_varchar2) <>

561: --
562: -- Only proceed with SQL validation if absolutely necessary
563: --
564: if ( ( l_api_updating
565: and nvl(hr_tmp_shd.g_old_rec.enabled_flag,hr_api.g_varchar2) <>
566: nvl(p_enabled_flag,hr_api.g_varchar2))
567: or (NOT l_api_updating)) then
568: --
569: hr_utility.set_location(l_proc,30);

Line 566: nvl(p_enabled_flag,hr_api.g_varchar2))

562: -- Only proceed with SQL validation if absolutely necessary
563: --
564: if ( ( l_api_updating
565: and nvl(hr_tmp_shd.g_old_rec.enabled_flag,hr_api.g_varchar2) <>
566: nvl(p_enabled_flag,hr_api.g_varchar2))
567: or (NOT l_api_updating)) then
568: --
569: hr_utility.set_location(l_proc,30);
570: --

Line 573: hr_api.mandatory_arg_error

569: hr_utility.set_location(l_proc,30);
570: --
571: -- Check value has been passed
572: --
573: hr_api.mandatory_arg_error
574: (p_api_name => l_proc
575: ,p_argument => 'enabled_flag'
576: ,p_argument_value => p_enabled_flag
577: );

Line 581: if hr_api.not_exists_in_hrstanlookups

577: );
578: --
579: -- Must exist in hr_standard_lookups where lookup_type is YES_NO
580: --
581: if hr_api.not_exists_in_hrstanlookups
582: (p_effective_date => p_effective_date
583: ,p_lookup_type => 'YES_NO'
584: ,p_lookup_code => p_enabled_flag
585: ) then

Line 631: hr_api.mandatory_arg_error

627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: -- Check mandatory arguments have been set
630: --
631: hr_api.mandatory_arg_error
632: (p_api_name => l_proc
633: ,p_argument => 'effective_date'
634: ,p_argument_value => p_effective_date
635: );

Line 698: hr_api.mandatory_arg_error

694: hr_utility.set_location('Entering:'||l_proc, 5);
695: --
696: -- Check mandatory arguments have been set
697: --
698: hr_api.mandatory_arg_error
699: (p_api_name => l_proc
700: ,p_argument => 'effective_date'
701: ,p_argument_value => p_effective_date
702: );