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.IRC_IPD_BUS dependencies on IRC_IPD_SHD

Line 107: (p_rec in irc_ipd_shd.g_rec_type

103: -- Internal Row Handler Use Only.
104: --
105: -- ----------------------------------------------------------------------------
106: procedure chk_ddf
107: (p_rec in irc_ipd_shd.g_rec_type
108: ) is
109: --
110: l_proc varchar2(72) := g_package || 'chk_ddf';
111: --

Line 116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>

112: begin
113: hr_utility.set_location('Entering:'||l_proc,10);
114: --
115: if ((p_rec.pending_data_id is not null) and (
116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>

Line 118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>

114: --
115: if ((p_rec.pending_data_id is not null) and (
116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>

Line 120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>

116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>

Line 122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>

118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>

Line 124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>

120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>

Line 126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>

122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>

Line 128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>

124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>

Line 130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>

126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>

Line 132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>

128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>

Line 134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>

130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>

Line 136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>

132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>

Line 138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>

134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>

Line 140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>

136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>

Line 142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>

138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>

Line 144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>

140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>

Line 146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>

142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>

Line 148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>

144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>

Line 150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>

146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>

Line 152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>

148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>

Line 154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>

150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>

Line 156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>

152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>

Line 158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>

154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>

Line 160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>

156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>

Line 162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>

158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>

Line 164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>

160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>

Line 166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>

162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>

Line 168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>

164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>

Line 170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>

166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>

Line 172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>

168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>

Line 174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>

170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
177: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
178: or (p_rec.pending_data_id is null) then

Line 176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>

172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
177: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
178: or (p_rec.pending_data_id is null) then
179: --
180: -- Only execute the validation if absolutely necessary:

Line 283: (p_rec in irc_ipd_shd.g_rec_type

279: --
280: -- {End Of Comments}
281: -- ----------------------------------------------------------------------------
282: Procedure chk_non_updateable_args
283: (p_rec in irc_ipd_shd.g_rec_type
284: ) IS
285: --
286: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
287: --

Line 293: IF NOT irc_ipd_shd.api_updating

289: --
290: -- Only proceed with the validation if a row exists for the current
291: -- record in the HR Schema.
292: --
293: IF NOT irc_ipd_shd.api_updating
294: (p_pending_data_id => p_rec.pending_data_id
295: ) THEN
296: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
297: fnd_message.set_token('PROCEDURE ', l_proc);

Line 305: if p_rec.pending_data_id <> irc_ipd_shd.g_old_rec.pending_data_id

301: --
302: --
303: -- Checks to ensure non-updateable args have
304: -- not been updated.
305: if p_rec.pending_data_id <> irc_ipd_shd.g_old_rec.pending_data_id
306: then
307: hr_api.argument_changed_error
308: (p_api_name => l_proc
309: ,p_argument => 'PENDING_DATA_ID'

Line 310: ,p_base_table => irc_ipd_shd.g_tab_nam

306: then
307: hr_api.argument_changed_error
308: (p_api_name => l_proc
309: ,p_argument => 'PENDING_DATA_ID'
310: ,p_base_table => irc_ipd_shd.g_tab_nam
311: );
312: end if;
313: --
314: if nvl(p_rec.vacancy_id, hr_api.g_number) <>

Line 315: nvl(irc_ipd_shd.g_old_rec.vacancy_id

311: );
312: end if;
313: --
314: if nvl(p_rec.vacancy_id, hr_api.g_number) <>
315: nvl(irc_ipd_shd.g_old_rec.vacancy_id
316: ,hr_api.g_number)
317: then
318: hr_api.argument_changed_error
319: (p_api_name => l_proc

Line 321: ,p_base_table => irc_ipd_shd.g_tab_nam

317: then
318: hr_api.argument_changed_error
319: (p_api_name => l_proc
320: ,p_argument => 'VACANCY_ID'
321: ,p_base_table => irc_ipd_shd.g_tab_nam
322: );
323: end if;
324: --
325: if p_rec.creation_date <> irc_ipd_shd.g_old_rec.creation_date

Line 325: if p_rec.creation_date <> irc_ipd_shd.g_old_rec.creation_date

321: ,p_base_table => irc_ipd_shd.g_tab_nam
322: );
323: end if;
324: --
325: if p_rec.creation_date <> irc_ipd_shd.g_old_rec.creation_date
326: then
327: hr_api.argument_changed_error
328: (p_api_name => l_proc
329: ,p_argument => 'CREATION_DATE'

Line 330: ,p_base_table => irc_ipd_shd.g_tab_nam

326: then
327: hr_api.argument_changed_error
328: (p_api_name => l_proc
329: ,p_argument => 'CREATION_DATE'
330: ,p_base_table => irc_ipd_shd.g_tab_nam
331: );
332: end if;
333: --
334: End chk_non_updateable_args;

Line 527: l_api_updating := irc_ipd_shd.api_updating

523: (p_api_name => l_proc
524: ,p_argument => 'creation date'
525: ,p_argument_value => p_creation_date
526: );
527: l_api_updating := irc_ipd_shd.api_updating
528: (p_pending_data_id => p_pending_data_id
529: );
530: --
531: if hr_multi_message.no_exclusive_error(

Line 536: <> nvl(irc_ipd_shd.g_old_rec.sex,hr_api.g_varchar2)

532: p_check_column1 => 'IRC_PENDING_DATA.VACANCY_ID'
533: ) then
534: --
535: if (l_api_updating and nvl(p_sex,hr_api.g_varchar2)
536: <> nvl(irc_ipd_shd.g_old_rec.sex,hr_api.g_varchar2)
537: or not l_api_updating) then
538: --
539: --Check if sex is set
540: --

Line 1255: <> nvl(irc_ipd_shd.g_old_rec.per_information1,hr_api.g_varchar2)

1251: -- Check if the value for per information1 is set on insert or has
1252: -- changed on update.
1253: --
1254: if (((nvl(p_per_information1,hr_api.g_varchar2)
1255: <> nvl(irc_ipd_shd.g_old_rec.per_information1,hr_api.g_varchar2)
1256: and p_api_updating)
1257: or (NOT p_api_updating))
1258: and p_per_information1 is not null)
1259: then

Line 1280: nvl(irc_ipd_shd.g_old_rec.per_information2,hr_api.g_varchar2)

1276: -- Check if the value for per information2 is set on insert or has
1277: -- changed on update.
1278: --
1279: if (((nvl(p_per_information2,hr_api.g_varchar2) <>
1280: nvl(irc_ipd_shd.g_old_rec.per_information2,hr_api.g_varchar2)
1281: and p_api_updating) or
1282: (NOT p_api_updating)) and
1283: p_per_information2 is not null)
1284: then

Line 1305: nvl(irc_ipd_shd.g_old_rec.per_information3,hr_api.g_varchar2)

1301: -- Check if the value for per information3 is set on insert or has
1302: -- changed on update.
1303: --
1304: if (((nvl(p_per_information3,hr_api.g_varchar2) <>
1305: nvl(irc_ipd_shd.g_old_rec.per_information3,hr_api.g_varchar2)
1306: and p_api_updating) or
1307: (NOT p_api_updating)) and
1308: p_per_information3 is not null)
1309: then

Line 1325: nvl(irc_ipd_shd.g_old_rec.per_information4,hr_api.g_varchar2)

1321: -- Check if the value for per information4 is set on insert or has
1322: -- changed on update.
1323: --
1324: if (((nvl(p_per_information4,hr_api.g_varchar2) <>
1325: nvl(irc_ipd_shd.g_old_rec.per_information4,hr_api.g_varchar2)
1326: and p_api_updating) or
1327: (NOT p_api_updating)) and
1328: p_per_information4 is not null)
1329: then

Line 1352: nvl(irc_ipd_shd.g_old_rec.per_information5,hr_api.g_varchar2)

1348: -- Check if the value for per information5 is set on insert or has
1349: -- changed on update.
1350: --
1351: if (((nvl(p_per_information5,hr_api.g_varchar2) <>
1352: nvl(irc_ipd_shd.g_old_rec.per_information5,hr_api.g_varchar2)
1353: and p_api_updating) or
1354: (NOT p_api_updating)) and
1355: p_per_information5 is not null)
1356: then

Line 1379: nvl(irc_ipd_shd.g_old_rec.per_information6,hr_api.g_varchar2)

1375: -- Check if the value for per information6 is set on insert or has
1376: -- changed on update.
1377: --
1378: if (((nvl(p_per_information6,hr_api.g_varchar2) <>
1379: nvl(irc_ipd_shd.g_old_rec.per_information6,hr_api.g_varchar2)
1380: and p_api_updating) or
1381: (NOT p_api_updating)) and
1382: p_per_information6 is not null)
1383: then

Line 1406: nvl(irc_ipd_shd.g_old_rec.per_information7,hr_api.g_varchar2)

1402: -- Check if the value for per information7 is set on insert or has
1403: -- changed on update.
1404: --
1405: if (((nvl(p_per_information7,hr_api.g_varchar2) <>
1406: nvl(irc_ipd_shd.g_old_rec.per_information7,hr_api.g_varchar2)
1407: and p_api_updating) or
1408: (NOT p_api_updating)) and
1409: p_per_information7 is not null)
1410: then

Line 1434: nvl(irc_ipd_shd.g_old_rec.per_information8,hr_api.g_varchar2)

1430: -- Check if the value for per information8 is set on insert or has
1431: -- changed on update.
1432: --
1433: if (((nvl(p_per_information8,hr_api.g_varchar2) <>
1434: nvl(irc_ipd_shd.g_old_rec.per_information8,hr_api.g_varchar2)
1435: and p_api_updating) or
1436: (NOT p_api_updating)) and
1437: p_per_information8 is not null)
1438: then

Line 1473: nvl(irc_ipd_shd.g_old_rec.per_information9,hr_api.g_varchar2)

1469: -- Check if the value for per information9 is set on insert or has
1470: -- changed on update.
1471: --
1472: if (((nvl(p_per_information9,hr_api.g_varchar2) <>
1473: nvl(irc_ipd_shd.g_old_rec.per_information9,hr_api.g_varchar2)
1474: and p_api_updating) or
1475: (NOT p_api_updating)) and
1476: p_per_information9 is not null)
1477: then

Line 1497: nvl(irc_ipd_shd.g_old_rec.per_information10,hr_api.g_varchar2)

1493: end if;
1494: end if;
1495: --
1496: if (((nvl(p_per_information10,hr_api.g_varchar2) <>
1497: nvl(irc_ipd_shd.g_old_rec.per_information10,hr_api.g_varchar2)
1498: and p_api_updating) or
1499: (NOT p_api_updating)) and
1500: p_per_information10 is not null)
1501: then

Line 1631: (p_rec in out nocopy irc_ipd_shd.g_rec_type

1627: -- Internal Table Handler Use Only.
1628: --
1629: -- ----------------------------------------------------------------------------
1630: Procedure chk_per_information
1631: (p_rec in out nocopy irc_ipd_shd.g_rec_type
1632: ) is
1633: --
1634: l_error exception;
1635: l_api_updating boolean;

Line 1648: l_api_updating := irc_ipd_shd.api_updating

1644: -- a) The current g_old_rec is current and
1645: -- b) Any of the per_information (developer descriptive flex) values have
1646: -- changed
1647: -- c) A record is being inserted
1648: l_api_updating := irc_ipd_shd.api_updating
1649: (p_pending_data_id => p_rec.pending_data_id
1650: );
1651: if ((l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information_category,
1652: hr_api.g_varchar2)

Line 1651: if ((l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information_category,

1647: -- c) A record is being inserted
1648: l_api_updating := irc_ipd_shd.api_updating
1649: (p_pending_data_id => p_rec.pending_data_id
1650: );
1651: if ((l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information_category,
1652: hr_api.g_varchar2)
1653: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,
1655: hr_api.g_varchar2)

Line 1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,

1650: );
1651: if ((l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information_category,
1652: hr_api.g_varchar2)
1653: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,
1655: hr_api.g_varchar2)
1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1658: hr_api.g_varchar2)

Line 1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,

1653: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,
1655: hr_api.g_varchar2)
1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1658: hr_api.g_varchar2)
1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1661: hr_api.g_varchar2)

Line 1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,

1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1658: hr_api.g_varchar2)
1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1661: hr_api.g_varchar2)
1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1664: hr_api.g_varchar2)

Line 1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,

1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1661: hr_api.g_varchar2)
1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1664: hr_api.g_varchar2)
1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1667: hr_api.g_varchar2)

Line 1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,

1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1664: hr_api.g_varchar2)
1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1667: hr_api.g_varchar2)
1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1670: hr_api.g_varchar2)

Line 1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,

1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1667: hr_api.g_varchar2)
1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1670: hr_api.g_varchar2)
1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1673: hr_api.g_varchar2)

Line 1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,

1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1670: hr_api.g_varchar2)
1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1673: hr_api.g_varchar2)
1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1676: hr_api.g_varchar2)

Line 1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,

1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1673: hr_api.g_varchar2)
1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1676: hr_api.g_varchar2)
1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1679: hr_api.g_varchar2)

Line 1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,

1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1676: hr_api.g_varchar2)
1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1679: hr_api.g_varchar2)
1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1682: hr_api.g_varchar2)

Line 1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,

1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1679: hr_api.g_varchar2)
1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1682: hr_api.g_varchar2)
1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1685: hr_api.g_varchar2)

Line 1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,

1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1682: hr_api.g_varchar2)
1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1685: hr_api.g_varchar2)
1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1688: hr_api.g_varchar2)

Line 1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,

1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1685: hr_api.g_varchar2)
1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1688: hr_api.g_varchar2)
1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1691: hr_api.g_varchar2)

Line 1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,

1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1688: hr_api.g_varchar2)
1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1691: hr_api.g_varchar2)
1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1694: hr_api.g_varchar2)

Line 1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,

1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1691: hr_api.g_varchar2)
1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1694: hr_api.g_varchar2)
1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1697: hr_api.g_varchar2)

Line 1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,

1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1694: hr_api.g_varchar2)
1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1697: hr_api.g_varchar2)
1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1700: hr_api.g_varchar2)

Line 1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,

1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1697: hr_api.g_varchar2)
1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1700: hr_api.g_varchar2)
1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1703: hr_api.g_varchar2)

Line 1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,

1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1700: hr_api.g_varchar2)
1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1703: hr_api.g_varchar2)
1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1706: hr_api.g_varchar2)

Line 1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,

1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1703: hr_api.g_varchar2)
1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1706: hr_api.g_varchar2)
1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1709: hr_api.g_varchar2)

Line 1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,

1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1706: hr_api.g_varchar2)
1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1709: hr_api.g_varchar2)
1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1712: hr_api.g_varchar2)

Line 1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,

1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1709: hr_api.g_varchar2)
1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1712: hr_api.g_varchar2)
1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1715: hr_api.g_varchar2)

Line 1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,

1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1712: hr_api.g_varchar2)
1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1715: hr_api.g_varchar2)
1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1718: hr_api.g_varchar2)

Line 1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,

1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1715: hr_api.g_varchar2)
1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1718: hr_api.g_varchar2)
1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1721: hr_api.g_varchar2)

Line 1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,

1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1718: hr_api.g_varchar2)
1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1721: hr_api.g_varchar2)
1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1724: hr_api.g_varchar2)

Line 1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,

1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1721: hr_api.g_varchar2)
1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1724: hr_api.g_varchar2)
1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1727: hr_api.g_varchar2)

Line 1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,

1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1724: hr_api.g_varchar2)
1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1727: hr_api.g_varchar2)
1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1730: hr_api.g_varchar2)

Line 1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,

1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1727: hr_api.g_varchar2)
1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1730: hr_api.g_varchar2)
1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1733: hr_api.g_varchar2)

Line 1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,

1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1730: hr_api.g_varchar2)
1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1733: hr_api.g_varchar2)
1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1736: hr_api.g_varchar2)

Line 1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,

1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1733: hr_api.g_varchar2)
1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1736: hr_api.g_varchar2)
1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1739: hr_api.g_varchar2)

Line 1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,

1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1736: hr_api.g_varchar2)
1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1739: hr_api.g_varchar2)
1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
1741: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information30,
1742: hr_api.g_varchar2)

Line 1741: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information30,

1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1739: hr_api.g_varchar2)
1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
1741: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information30,
1742: hr_api.g_varchar2)
1743: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
1744: (NOT l_api_updating))
1745: then

Line 1847: (p_rec in out nocopy irc_ipd_shd.g_rec_type

1843: -- ----------------------------------------------------------------------------
1844: -- |---------------------------< insert_validate >----------------------------|
1845: -- ----------------------------------------------------------------------------
1846: Procedure insert_validate
1847: (p_rec in out nocopy irc_ipd_shd.g_rec_type
1848: ) is
1849: --
1850: l_proc varchar2(72) := g_package||'insert_validate';
1851: --

Line 1905: (p_rec in out nocopy irc_ipd_shd.g_rec_type

1901: -- ----------------------------------------------------------------------------
1902: -- |---------------------------< update_validate >----------------------------|
1903: -- ----------------------------------------------------------------------------
1904: Procedure update_validate
1905: (p_rec in out nocopy irc_ipd_shd.g_rec_type
1906: ) is
1907: --
1908: l_proc varchar2(72) := g_package||'update_validate';
1909: --

Line 1948: (p_rec in irc_ipd_shd.g_rec_type

1944: -- ----------------------------------------------------------------------------
1945: -- |---------------------------< delete_validate >----------------------------|
1946: -- ----------------------------------------------------------------------------
1947: Procedure delete_validate
1948: (p_rec in irc_ipd_shd.g_rec_type
1949: ) is
1950: --
1951: l_proc varchar2(72) := g_package||'delete_validate';
1952: --