APPS.IRC_APA_INS dependencies on IRC_APL_PROFILE_ACCESS

Line 87: -- Insert the row into: irc_apl_profile_access

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: irc_apl_profile_access
88: --
89: insert into irc_apl_profile_access
90: (apl_profile_access_id
91: ,person_id

Line 89: insert into irc_apl_profile_access

85: --
86: --
87: -- Insert the row into: irc_apl_profile_access
88: --
89: insert into irc_apl_profile_access
90: (apl_profile_access_id
91: ,person_id
92: ,object_version_number
93: )

Line 165: Cursor C_Sel1 is select irc_apl_profile_access_s.nextval from sys.dual;

161: Procedure pre_insert
162: (p_rec in out nocopy irc_apa_shd.g_rec_type
163: ) is
164: --
165: Cursor C_Sel1 is select irc_apl_profile_access_s.nextval from sys.dual;
166: --
167: Cursor C_Sel2 is
168: Select null
169: from irc_apl_profile_access

Line 169: from irc_apl_profile_access

165: Cursor C_Sel1 is select irc_apl_profile_access_s.nextval from sys.dual;
166: --
167: Cursor C_Sel2 is
168: Select null
169: from irc_apl_profile_access
170: where apl_profile_access_id =
171: irc_apa_ins.g_apl_profile_access_id_i;
172: --
173: l_proc varchar2(72) := g_package||'pre_insert';

Line 191: fnd_message.set_token('TABLE_NAME','irc_apl_profile_access');

187: --
188: -- The primary key values are already in use.
189: --
190: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
191: fnd_message.set_token('TABLE_NAME','irc_apl_profile_access');
192: fnd_message.raise_error;
193: End If;
194: Close C_Sel2;
195: --

Line 272: (p_module_name => 'IRC_APL_PROFILE_ACCESS'

268: --
269: when hr_api.cannot_find_prog_unit then
270: --
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'IRC_APL_PROFILE_ACCESS'
273: ,p_hook_type => 'AI');
274: --
275: end;
276: --