APPS.IRC_CMT_BUS dependencies on IRC_COMM_TOPICS

Line 28: -- irc_comm_topics and PER_BUSINESS_GROUPS_PERF

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- irc_comm_topics and PER_BUSINESS_GROUPS_PERF
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 36: , irc_comm_topics cmt

32: cursor csr_sec_grp is
33: select pbg.security_group_id,
34: pbg.legislation_code
35: from per_business_groups_perf pbg
36: , irc_comm_topics cmt
37: -- , EDIT_HERE table_name(s) 333
38: where cmt.communication_topic_id = p_communication_topic_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --

Line 105: -- irc_comm_topics and PER_BUSINESS_GROUPS_PERF

101: --
102: -- Declare cursor
103: --
104: -- EDIT_HERE In the following cursor statement add join(s) between
105: -- irc_comm_topics and PER_BUSINESS_GROUPS_PERF
106: -- so that the legislation_code for
107: -- the current business group context can be derived.
108: -- Remove this comment when the edit has been completed.
109: cursor csr_leg_code is

Line 112: , irc_comm_topics cmt

108: -- Remove this comment when the edit has been completed.
109: cursor csr_leg_code is
110: select pbg.legislation_code
111: from per_business_groups_perf pbg
112: , irc_comm_topics cmt
113: -- , EDIT_HERE table_name(s) 333
114: where cmt.communication_topic_id = p_communication_topic_id;
115: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
116: --

Line 258: (p_communication_id in irc_comm_topics.communication_id%type

254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure chk_communication_id
258: (p_communication_id in irc_comm_topics.communication_id%type
259: ) is
260: --
261: l_proc varchar2(72) := g_package||'chk_communication_id';
262: l_status irc_comm_topics.status%type;

Line 262: l_status irc_comm_topics.status%type;

258: (p_communication_id in irc_comm_topics.communication_id%type
259: ) is
260: --
261: l_proc varchar2(72) := g_package||'chk_communication_id';
262: l_status irc_comm_topics.status%type;
263: cursor csr_comm(p_comm_id in number) is
264: select status from irc_communications where
265: communication_id = p_comm_id;
266: --

Line 291: (p_associated_column1 => 'IRC_COMM_TOPICS.COMMUNICATION_ID'

287: --
288: exception
289: when app_exception.application_exception then
290: if hr_multi_message.exception_add
291: (p_associated_column1 => 'IRC_COMM_TOPICS.COMMUNICATION_ID'
292: ) then
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,30);
295: --

Line 319: (p_subject in irc_comm_topics.subject%type

315: --
316: -- {End Of Comments}
317: -- ----------------------------------------------------------------------------
318: Procedure chk_subject
319: (p_subject in irc_comm_topics.subject%type
320: ) is
321: --
322: l_proc varchar2(72) := g_package||'chk_subject';
323: --

Line 344: (p_associated_column1 => 'IRC_COMM_TOPICS.SUBJECT'

340: --
341: exception
342: when app_exception.application_exception then
343: if hr_multi_message.exception_add
344: (p_associated_column1 => 'IRC_COMM_TOPICS.SUBJECT'
345: ) then
346: --
347: hr_utility.set_location(' Leaving:'||l_proc,30);
348: --

Line 372: (p_status in irc_comm_topics.status%type

368: --
369: -- {End Of Comments}
370: -- ----------------------------------------------------------------------------
371: Procedure chk_status
372: (p_status in irc_comm_topics.status%type
373: ,p_effective_date in date
374: ) is
375: --
376: l_proc varchar2(72) := g_package||'chk_status';

Line 405: (p_associated_column1 => 'IRC_COMM_TOPICS.STATUS'

401: --
402: exception
403: when app_exception.application_exception then
404: if hr_multi_message.exception_add
405: (p_associated_column1 => 'IRC_COMM_TOPICS.STATUS'
406: ) then
407: --
408: hr_utility.set_location(' Leaving:'||l_proc,40);
409: --