APPS.IRC_APS_SHD dependencies on IRC_APL_PROFILE_SNAPSHOTS

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_APL_PROFILE_SNAPSHOTS_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_snapshots

48: select
49: profile_snapshot_id
50: ,person_id
51: ,object_version_number
52: from irc_apl_profile_snapshots
53: where profile_snapshot_id = p_profile_snapshot_id;
54: --
55: l_fct_ret boolean;
56: --

Line 120: from irc_apl_profile_snapshots

116: select
117: profile_snapshot_id
118: ,person_id
119: ,object_version_number
120: from irc_apl_profile_snapshots
121: where profile_snapshot_id = p_profile_snapshot_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_snapshots');

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_snapshots');
170: fnd_message.raise_error;
171: End lck;
172: --
173: -- ----------------------------------------------------------------------------