APPS.HR_TPP_BUS dependencies on HR_TPP_SHD

Line 145: (p_rec in hr_tpp_shd.g_rec_type

141: -- Internal Row Handler Use Only.
142: --
143: -- ----------------------------------------------------------------------------
144: procedure chk_ddf
145: (p_rec in hr_tpp_shd.g_rec_type
146: ) is
147: --
148: l_proc varchar2(72) := g_package || 'chk_ddf';
149: --

Line 154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

150: begin
151: hr_utility.set_location('Entering:'||l_proc,10);
152: --
153: if ((p_rec.tab_page_property_id is not null) and (
154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

152: --
153: if ((p_rec.tab_page_property_id is not null) and (
154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
215: nvl(p_rec.information30, hr_api.g_varchar2) )
216: or (p_rec.tab_page_property_id is null) ) then

Line 214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
215: nvl(p_rec.information30, hr_api.g_varchar2) )
216: or (p_rec.tab_page_property_id is null) ) then
217: --
218: -- Only execute the validation if absolutely necessary:

Line 322: ,p_rec in hr_tpp_shd.g_rec_type

318: -- {End Of Comments}
319: -- ----------------------------------------------------------------------------
320: Procedure chk_non_updateable_args
321: (p_effective_date in date
322: ,p_rec in hr_tpp_shd.g_rec_type
323: ) IS
324: --
325: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
326: l_error EXCEPTION;

Line 334: IF NOT hr_tpp_shd.api_updating

330: --
331: -- Only proceed with the validation if a row exists for the current
332: -- record in the HR Schema.
333: --
334: IF NOT hr_tpp_shd.api_updating
335: (p_tab_page_property_id => p_rec.tab_page_property_id
336: ,p_object_version_number => p_rec.object_version_number
337: ) THEN
338: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 345: nvl(hr_tpp_shd.g_old_rec.form_tab_page_id,hr_api.g_number)

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

Line 352: nvl(hr_tpp_shd.g_old_rec.template_tab_page_id,hr_api.g_number)

348: RAISE l_error;
349: END IF;
350: --
351: IF (nvl(p_rec.template_tab_page_id,hr_api.g_number) <>
352: nvl(hr_tpp_shd.g_old_rec.template_tab_page_id,hr_api.g_number)
353: ) THEN
354: l_argument := 'template_tab_page_id';
355: RAISE l_error;
356: END IF;

Line 467: l_api_updating := hr_tpp_shd.api_updating

463: ,p_argument => 'effective_date'
464: ,p_argument_value => p_effective_date
465: );
466: --
467: l_api_updating := hr_tpp_shd.api_updating
468: (p_tab_page_property_id => p_tab_page_property_id
469: ,p_object_version_number => p_object_version_number
470: );
471: hr_utility.set_location(l_proc,20);

Line 476: and nvl(hr_tpp_shd.g_old_rec.navigation_direction,hr_api.g_varchar2) <>

472: --
473: -- Only proceed with SQL validation if absolutely necessary
474: --
475: if ( ( l_api_updating
476: and nvl(hr_tpp_shd.g_old_rec.navigation_direction,hr_api.g_varchar2) <>
477: nvl(p_navigation_direction,hr_api.g_varchar2))
478: or (NOT l_api_updating)) then
479: --
480: hr_utility.set_location(l_proc,30);

Line 531: l_api_updating := hr_tpp_shd.api_updating

527: ,p_argument => 'effective_date'
528: ,p_argument_value => p_effective_date
529: );
530: --
531: l_api_updating := hr_tpp_shd.api_updating
532: (p_tab_page_property_id => p_tab_page_property_id
533: ,p_object_version_number => p_object_version_number
534: );
535: hr_utility.set_location(l_proc,20);

Line 540: and nvl(hr_tpp_shd.g_old_rec.visible,hr_api.g_number) <>

536: --
537: -- Only proceed with SQL validation if absolutely necessary
538: --
539: if ( ( l_api_updating
540: and nvl(hr_tpp_shd.g_old_rec.visible,hr_api.g_number) <>
541: nvl(p_visible,hr_api.g_number))
542: or (NOT l_api_updating)) then
543: --
544: hr_utility.set_location(l_proc,30);

Line 575: (p_rec in hr_tpp_shd.g_rec_type

571: -- ----------------------------------------------------------------------------
572: -- |------------------------------< chk_delete >------------------------------|
573: -- ----------------------------------------------------------------------------
574: Procedure chk_delete
575: (p_rec in hr_tpp_shd.g_rec_type
576: ) is
577: --
578: l_proc varchar2(72) := g_package||'chk_delete';
579: --

Line 595: ,p_rec in hr_tpp_shd.g_rec_type

591: -- |---------------------------< insert_validate >----------------------------|
592: -- ----------------------------------------------------------------------------
593: Procedure insert_validate
594: (p_effective_date in date
595: ,p_rec in hr_tpp_shd.g_rec_type
596: ) is
597: --
598: l_proc varchar2(72) := g_package||'insert_validate';
599: --

Line 659: ,p_rec in hr_tpp_shd.g_rec_type

655: -- |---------------------------< update_validate >----------------------------|
656: -- ----------------------------------------------------------------------------
657: Procedure update_validate
658: (p_effective_date in date
659: ,p_rec in hr_tpp_shd.g_rec_type
660: ) is
661: --
662: l_proc varchar2(72) := g_package||'update_validate';
663: --

Line 727: (p_rec in hr_tpp_shd.g_rec_type

723: -- ----------------------------------------------------------------------------
724: -- |---------------------------< delete_validate >----------------------------|
725: -- ----------------------------------------------------------------------------
726: Procedure delete_validate
727: (p_rec in hr_tpp_shd.g_rec_type
728: ) is
729: --
730: l_proc varchar2(72) := g_package||'delete_validate';
731: --