APPS.IRC_IPD_BUS dependencies on HR_API

Line 37: hr_api.mandatory_arg_error

33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Ensure that all the mandatory parameter are not null
36: --
37: hr_api.mandatory_arg_error
38: (p_api_name => l_proc
39: ,p_argument => 'pending_data_id'
40: ,p_argument_value => p_pending_data_id
41: );

Line 68: hr_api.mandatory_arg_error

64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Ensure that all the mandatory parameter are not null
67: --
68: hr_api.mandatory_arg_error
69: (p_api_name => l_proc
70: ,p_argument => 'pending_data_id'
71: ,p_argument_value => p_pending_data_id
72: );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 307: hr_api.argument_changed_error

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'
310: ,p_base_table => irc_ipd_shd.g_tab_nam
311: );

Line 314: if nvl(p_rec.vacancy_id, hr_api.g_number) <>

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) <>
315: nvl(irc_ipd_shd.g_old_rec.vacancy_id
316: ,hr_api.g_number)
317: then
318: hr_api.argument_changed_error

Line 316: ,hr_api.g_number)

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
320: ,p_argument => 'VACANCY_ID'

Line 318: hr_api.argument_changed_error

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
320: ,p_argument => 'VACANCY_ID'
321: ,p_base_table => irc_ipd_shd.g_tab_nam
322: );

Line 327: hr_api.argument_changed_error

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'
330: ,p_base_table => irc_ipd_shd.g_tab_nam
331: );

Line 375: and nvl(date_to,hr_api.g_eot) >= p_creation_date

371: cursor csr_vacancy_id is
372: select 1
373: from per_all_vacancies
374: where vacancy_id = p_vacancy_id
375: and nvl(date_to,hr_api.g_eot) >= p_creation_date
376: and date_from <= p_creation_date;
377: --
378: Begin
379: --

Line 382: hr_api.mandatory_arg_error

378: Begin
379: --
380: hr_utility.set_location(' Entering:'||l_proc,10);
381: --
382: hr_api.mandatory_arg_error
383: (p_api_name => l_proc
384: ,p_argument => 'creation date'
385: ,p_argument_value => p_creation_date
386: );

Line 522: hr_api.mandatory_arg_error

518: --
519: Begin
520: hr_utility.set_location('Entering:'||l_proc,10);
521: --
522: hr_api.mandatory_arg_error
523: (p_api_name => l_proc
524: ,p_argument => 'creation date'
525: ,p_argument_value => p_creation_date
526: );

Line 535: if (l_api_updating and nvl(p_sex,hr_api.g_varchar2)

531: if hr_multi_message.no_exclusive_error(
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

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 546: if hr_api.not_exists_in_hr_lookups

542: hr_utility.set_location('Entering:'||l_proc,20);
543: --
544: --Check if the sex exists in hr_lookups
545: --
546: if hr_api.not_exists_in_hr_lookups
547: (p_effective_date => p_creation_date
548: ,p_lookup_type => 'SEX'
549: ,p_lookup_code => p_sex
550: ) then

Line 605: hr_api.mandatory_arg_error

601: Begin
602: --
603: hr_utility.set_location(' Entering:'||l_proc,10);
604: --
605: hr_api.mandatory_arg_error
606: (p_api_name => l_proc
607: ,p_argument => 'ALLOW_ACCESS'
608: ,p_argument_value => p_allow_access
609: );

Line 764: hr_api.mandatory_arg_error

760: --
761: -- Check the mandatory parameters
762: --
763: --
764: hr_api.mandatory_arg_error
765: (p_api_name => l_proc
766: ,p_argument => 'creation_date'
767: ,p_argument_value => p_creation_date
768: );

Line 782: if hr_api.not_exists_in_hr_lookups

778: -- Check that per information1 exists in hr_lookups for the
779: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
780: -- the person is active on creation date in hr_lookups.
781: --
782: if hr_api.not_exists_in_hr_lookups
783: (p_effective_date => p_creation_date
784: ,p_lookup_type => 'ETH_TYPE'
785: ,p_lookup_code => p_per_information1
786: )

Line 805: if hr_api.not_exists_in_hr_lookups

801: -- Check that per information2 exists in hr_lookups for the
802: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
803: -- the person is active on creation date in hr_lookups.
804: --
805: if hr_api.not_exists_in_hr_lookups
806: (p_effective_date => p_creation_date
807: ,p_lookup_type => 'YES_NO'
808: ,p_lookup_code => p_per_information2
809: )

Line 828: if hr_api.not_exists_in_hr_lookups

824: -- Check that per information4 exists in hr_lookups for the
825: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
826: -- the person is active on creation date in hr_lookups.
827: --
828: if hr_api.not_exists_in_hr_lookups
829: (p_effective_date => p_creation_date
830: ,p_lookup_type => 'YES_NO'
831: ,p_lookup_code => p_per_information4
832: )

Line 932: if hr_api.not_exists_in_hr_lookups

928: -- Check that per information9 exists in hr_lookups for the
929: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
930: -- the person is active on creation date in hr_lookups.
931: --
932: if hr_api.not_exists_in_hr_lookups
933: (p_effective_date => p_creation_date
934: ,p_lookup_type => 'YES_NO'
935: ,p_lookup_code => p_per_information9
936: )

Line 951: if hr_api.not_exists_in_hr_lookups

947: -- Check that per information10 exists in hr_lookups for the
948: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
949: -- the person is active on creation date in hr_lookups.
950: --
951: if hr_api.not_exists_in_hr_lookups
952: (p_effective_date => p_creation_date
953: ,p_lookup_type => 'YES_NO'
954: ,p_lookup_code => p_per_information10
955: )

Line 1242: hr_api.mandatory_arg_error

1238: hr_utility.set_location('Entering:'|| l_proc, 10);
1239: --
1240: -- Check the mandatory parameters
1241: --
1242: hr_api.mandatory_arg_error
1243: (p_api_name => l_proc
1244: ,p_argument => 'creation_date'
1245: ,p_argument_value => p_creation_date
1246: );

Line 1254: if (((nvl(p_per_information1,hr_api.g_varchar2)

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

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 1264: if hr_api.not_exists_in_hr_lookups

1260: -- Check that per information1 exists in hr_lookups for the
1261: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
1262: -- the person is active on creation date in hr_lookups.
1263: --
1264: if hr_api.not_exists_in_hr_lookups
1265: (p_effective_date => p_creation_date
1266: ,p_lookup_type => 'US_ETHNIC_GROUP'
1267: ,p_lookup_code => p_per_information1
1268: )

Line 1279: if (((nvl(p_per_information2,hr_api.g_varchar2) <>

1275: end if;
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)

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 1290: if hr_api.not_exists_in_hr_lookups

1286: -- Check that per information2 exists in hr_lookups for the
1287: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
1288: -- the person is active on creation date in hr_lookups.
1289: --
1290: if hr_api.not_exists_in_hr_lookups
1291: (p_effective_date => p_creation_date
1292: ,p_lookup_type => 'PER_US_I9_STATE'
1293: ,p_lookup_code => p_per_information2
1294: )

Line 1304: if (((nvl(p_per_information3,hr_api.g_varchar2) <>

1300: end if;
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)

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 1324: if (((nvl(p_per_information4,hr_api.g_varchar2) <>

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

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 1335: if hr_api.not_exists_in_hr_lookups

1331: -- Check that per information4 exists in hr_lookups for the
1332: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
1333: -- the person is active on creation date in hr_lookups.
1334: --
1335: if hr_api.not_exists_in_hr_lookups
1336: (p_effective_date => p_creation_date
1337: ,p_lookup_type => 'US_VISA_TYPE'
1338: ,p_lookup_code => p_per_information4
1339: )

Line 1351: if (((nvl(p_per_information5,hr_api.g_varchar2) <>

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

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 1362: if hr_api.not_exists_in_hr_lookups

1358: -- Check that per information5 exists in hr_lookups for the
1359: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
1360: -- the person is active on creation date in hr_lookups.
1361: --
1362: if hr_api.not_exists_in_hr_lookups
1363: (p_effective_date => p_creation_date
1364: ,p_lookup_type => 'US_VETERAN_STATUS'
1365: ,p_lookup_code => p_per_information5
1366: )

Line 1378: if (((nvl(p_per_information6,hr_api.g_varchar2) <>

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

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 1389: if hr_api.not_exists_in_hr_lookups

1385: -- Check that per information6 exists in hr_lookups for the
1386: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
1387: -- the person is active on creation date in hr_lookups.
1388: --
1389: if hr_api.not_exists_in_hr_lookups
1390: (p_effective_date => p_creation_date
1391: ,p_lookup_type => 'YES_NO'
1392: ,p_lookup_code => p_per_information6
1393: )

Line 1405: if (((nvl(p_per_information7,hr_api.g_varchar2) <>

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

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 1416: if hr_api.not_exists_in_hr_lookups

1412: -- Check that per information7 exists in hr_lookups for the
1413: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
1414: -- the person is active on creation date in hr_lookups.
1415: --
1416: if hr_api.not_exists_in_hr_lookups
1417: (p_effective_date => p_creation_date
1418: ,p_lookup_type => 'US_NEW_HIRE_STATUS'
1419: ,p_lookup_code => p_per_information7
1420: )

Line 1433: if (((nvl(p_per_information8,hr_api.g_varchar2) <>

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

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 1442: if nvl(p_per_information7,hr_api.g_varchar2) <> 'EXCL'

1438: then
1439: --
1440: -- Check if per information7 is 'EXCL'
1441: --
1442: if nvl(p_per_information7,hr_api.g_varchar2) <> 'EXCL'
1443: then
1444: --
1445: -- Error: Field must be null because per_info7 is not 'EXCL'
1446: --

Line 1455: if hr_api.not_exists_in_hr_lookups

1451: -- Check that per information7 exists in hr_lookups for the
1452: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
1453: -- the person is active on creation date in hr_lookups.
1454: --
1455: if hr_api.not_exists_in_hr_lookups
1456: (p_effective_date => p_creation_date
1457: ,p_lookup_type => 'US_NEW_HIRE_EXCEPTIONS'
1458: ,p_lookup_code => p_per_information8
1459: )

Line 1472: if (((nvl(p_per_information9,hr_api.g_varchar2) <>

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

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 1483: if hr_api.not_exists_in_hr_lookups

1479: -- Check that per information9 exists in hr_lookups for the
1480: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
1481: -- the person is active on creation date in hr_lookups.
1482: --
1483: if hr_api.not_exists_in_hr_lookups
1484: (p_effective_date => p_creation_date
1485: ,p_lookup_type => 'YES_NO'
1486: ,p_lookup_code => p_per_information9
1487: )

Line 1496: if (((nvl(p_per_information10,hr_api.g_varchar2) <>

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

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 1507: if hr_api.not_exists_in_hr_lookups

1503: -- Check that per information10 exists in hr_lookups for the
1504: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
1505: -- the person is active on creation date in hr_lookups.
1506: --
1507: if hr_api.not_exists_in_hr_lookups
1508: (p_effective_date => p_creation_date
1509: ,p_lookup_type => 'YES_NO'
1510: ,p_lookup_code => p_per_information10
1511: )

Line 1652: hr_api.g_varchar2)

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

Line 1653: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or

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

Line 1655: hr_api.g_varchar2)

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

Line 1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or

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

Line 1658: hr_api.g_varchar2)

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

Line 1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or

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

Line 1661: hr_api.g_varchar2)

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

Line 1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or

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

Line 1664: hr_api.g_varchar2)

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

Line 1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or

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

Line 1667: hr_api.g_varchar2)

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

Line 1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or

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

Line 1670: hr_api.g_varchar2)

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

Line 1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or

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

Line 1673: hr_api.g_varchar2)

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

Line 1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or

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

Line 1676: hr_api.g_varchar2)

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

Line 1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or

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

Line 1679: hr_api.g_varchar2)

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

Line 1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or

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

Line 1682: hr_api.g_varchar2)

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

Line 1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or

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

Line 1685: hr_api.g_varchar2)

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

Line 1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or

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

Line 1688: hr_api.g_varchar2)

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

Line 1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or

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

Line 1691: hr_api.g_varchar2)

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

Line 1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or

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

Line 1694: hr_api.g_varchar2)

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

Line 1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or

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

Line 1697: hr_api.g_varchar2)

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

Line 1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or

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

Line 1700: hr_api.g_varchar2)

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

Line 1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or

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

Line 1703: hr_api.g_varchar2)

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

Line 1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or

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

Line 1706: hr_api.g_varchar2)

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

Line 1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or

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

Line 1709: hr_api.g_varchar2)

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

Line 1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or

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

Line 1712: hr_api.g_varchar2)

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

Line 1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or

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

Line 1715: hr_api.g_varchar2)

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

Line 1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or

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

Line 1718: hr_api.g_varchar2)

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

Line 1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or

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

Line 1721: hr_api.g_varchar2)

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

Line 1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or

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

Line 1724: hr_api.g_varchar2)

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

Line 1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or

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

Line 1727: hr_api.g_varchar2)

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

Line 1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or

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

Line 1730: hr_api.g_varchar2)

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

Line 1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or

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

Line 1733: hr_api.g_varchar2)

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

Line 1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or

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

Line 1736: hr_api.g_varchar2)

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

Line 1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or

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

Line 1739: hr_api.g_varchar2)

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

Line 1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or

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)
1743: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
1744: (NOT l_api_updating))

Line 1742: hr_api.g_varchar2)

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
1746: -- Check if the per_information_category is 'GB' or 'US' calling

Line 1743: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or

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
1746: -- Check if the per_information_category is 'GB' or 'US' calling
1747: -- the appropriate validation routine or generating an error