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_IID_BUS dependencies on IRC_IID_SHD

Line 88: (p_rec in irc_iid_shd.g_rec_type

84: -- Internal Row Handler Use Only.
85: --
86: -- ----------------------------------------------------------------------------
87: procedure chk_ddf
88: (p_rec in irc_iid_shd.g_rec_type
89: ) is
90: --
91: l_proc varchar2(72) := g_package || 'chk_ddf';
92: --

Line 97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>

93: begin
94: hr_utility.set_location('Entering:'||l_proc,10);
95: --
96: if ((p_rec.interview_details_id is not null) and (
97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>

Line 99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>

95: --
96: if ((p_rec.interview_details_id is not null) and (
97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>

Line 101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>

97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>

Line 103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>

99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>

Line 105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>

101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>

Line 107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>

103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>

Line 109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>

105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>

Line 111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>

107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>

Line 113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>

109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>

Line 115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>

111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>

Line 117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>

113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>

Line 119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>

115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>

Line 121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>

117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>

Line 123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>

119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>

Line 125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>

121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>

Line 127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>

123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>

Line 129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>

125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>

Line 131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>

127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>

Line 133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>

129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>

Line 135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>

131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>
138: nvl(p_rec.iid_information20, hr_api.g_varchar2) ))
139: or (p_rec.event_id is null) then

Line 137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>

133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>
138: nvl(p_rec.iid_information20, hr_api.g_varchar2) ))
139: or (p_rec.event_id is null) then
140: --
141: -- Only execute the validation if absolutely necessary:

Line 225: ,p_rec in irc_iid_shd.g_rec_type

221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure chk_non_updateable_args
224: (p_effective_date in date
225: ,p_rec in irc_iid_shd.g_rec_type
226: ) IS
227: --
228: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
229: --

Line 237: IF NOT irc_iid_shd.api_updating

233: --
234: -- Only proceed with the validation if a row exists for the current
235: -- record in the HR Schema.
236: --
237: IF NOT irc_iid_shd.api_updating
238: (p_effective_date => p_effective_date
239: ,p_interview_details_id => p_rec.interview_details_id
240: ,p_object_version_number => p_rec.object_version_number
241: ) THEN

Line 251: if p_rec.event_id <> irc_iid_shd.g_old_rec.event_id

247: --
248: -- Add checks to ensure non-updateable args have
249: -- not been updated.
250: --
251: if p_rec.event_id <> irc_iid_shd.g_old_rec.event_id
252: then
253: hr_api.argument_changed_error
254: (p_api_name => l_proc
255: ,p_argument => 'EVENT_ID'

Line 256: ,p_base_table => irc_iid_shd.g_tab_name

252: then
253: hr_api.argument_changed_error
254: (p_api_name => l_proc
255: ,p_argument => 'EVENT_ID'
256: ,p_base_table => irc_iid_shd.g_tab_name
257: );
258: end if;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 441: (p_rec in irc_iid_shd.g_rec_type

437: -- ----------------------------------------------------------------------------
438: -- |---------------------------< chk_status >---------------------------------|
439: -- ----------------------------------------------------------------------------
440: Procedure chk_status
441: (p_rec in irc_iid_shd.g_rec_type
442: ,p_effective_date in date
443: ) is
444: --
445: l_proc varchar2(72) := g_package||'chk_status';

Line 469: (p_rec in irc_iid_shd.g_rec_type

465: -- ----------------------------------------------------------------------------
466: -- |---------------------------< chk_result >---------------------------------|
467: -- ----------------------------------------------------------------------------
468: Procedure chk_result
469: (p_rec in irc_iid_shd.g_rec_type
470: ,p_effective_date in date
471: ) is
472: --
473: l_proc varchar2(72) := g_package||'chk_result';

Line 497: (p_rec in irc_iid_shd.g_rec_type

493: ---- ----------------------------------------------------------------------------
494: -- |---------------------------< chk_completed >--------------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure chk_completed
497: (p_rec in irc_iid_shd.g_rec_type
498: ,p_effective_date in date
499: ) is
500: --
501: l_proc varchar2(72) := g_package||'chk_completed';

Line 600: (p_rec in irc_iid_shd.g_rec_type

596: -- ----------------------------------------------------------------------------
597: -- |---------------------------< chk_event_id >-------------------------------|
598: -- ----------------------------------------------------------------------------
599: Procedure chk_event_id
600: (p_rec in irc_iid_shd.g_rec_type
601: ) is
602: l_rec_exists number;
603: cursor csr_event_exists is
604: select 1

Line 623: (p_rec in irc_iid_shd.g_rec_type

619: -- ----------------------------------------------------------------------------
620: -- |---------------------------< insert_validate >----------------------------|
621: -- ----------------------------------------------------------------------------
622: Procedure insert_validate
623: (p_rec in irc_iid_shd.g_rec_type
624: ,p_effective_date in date
625: ,p_datetrack_mode in varchar2
626: ,p_validation_start_date in date
627: ,p_validation_end_date in date

Line 650: (p_rec in irc_iid_shd.g_rec_type

646: -- ----------------------------------------------------------------------------
647: -- |---------------------------< update_validate >----------------------------|
648: -- ----------------------------------------------------------------------------
649: Procedure update_validate
650: (p_rec in irc_iid_shd.g_rec_type
651: ,p_effective_date in date
652: ,p_datetrack_mode in varchar2
653: ,p_validation_start_date in date
654: ,p_validation_end_date in date