APPS.IRC_IPC_SHD dependencies on IRC_POSTING_CONTENTS

Line 32: If (p_constraint_name = 'IRC_POSTING_CONTENTS_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'IRC_POSTING_CONTENTS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 133: from irc_posting_contents

129: ,recruiter_work_telephone
130: ,manager_full_name
131: ,manager_email
132: ,manager_work_telephone
133: from irc_posting_contents
134: where posting_content_id = p_posting_content_id;
135: --
136: l_fct_ret boolean;
137: --

Line 271: from irc_posting_contents

267: ,recruiter_work_telephone
268: ,manager_full_name
269: ,manager_email
270: ,manager_work_telephone
271: from irc_posting_contents
272: where posting_content_id = p_posting_content_id
273: for update nowait;
274: --
275: l_proc varchar2(72) := g_package||'lck';

Line 320: fnd_message.set_token('TABLE_NAME', 'irc_posting_contents');

316: -- The object is locked therefore we need to supply a meaningful
317: -- error message.
318: --
319: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
320: fnd_message.set_token('TABLE_NAME', 'irc_posting_contents');
321: fnd_message.raise_error;
322: End lck;
323: --
324: -- ----------------------------------------------------------------------------