APPS.IRC_APA_SHD dependencies on IRC_APL_PROFILE_ACCESS

Line 21: If (p_constraint_name = 'IRC_APL_PROFILE_ACCESS_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_APL_PROFILE_ACCESS_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 52: from irc_apl_profile_access

48: select
49: apl_profile_access_id
50: ,person_id
51: ,object_version_number
52: from irc_apl_profile_access
53: where apl_profile_access_id = p_apl_profile_access_id;
54: --
55: l_fct_ret boolean;
56: --

Line 120: from irc_apl_profile_access

116: select
117: apl_profile_access_id
118: ,person_id
119: ,object_version_number
120: from irc_apl_profile_access
121: where apl_profile_access_id = p_apl_profile_access_id
122: for update nowait;
123: --
124: l_proc varchar2(72) := g_package||'lck';

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

165: -- The object is locked therefore we need to supply a meaningful
166: -- error message.
167: --
168: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
169: fnd_message.set_token('TABLE_NAME', 'irc_apl_profile_access');
170: fnd_message.raise_error;
171: End lck;
172: --
173: -- ----------------------------------------------------------------------------