[Home] [Help]
24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- irc_communications 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
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_communications cmc
37: -- , EDIT_HERE table_name(s) 333
38: where cmc.communication_id = p_communication_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --
101: --
102: -- Declare cursor
103: --
104: -- EDIT_HERE In the following cursor statement add join(s) between
105: -- irc_communications 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
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_communications cmc
113: -- , EDIT_HERE table_name(s) 333
114: where cmc.communication_id = p_communication_id;
115: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
116: --
274: -- None.
275: --
276: -- In Parameters:
277: -- status varchar2(50) communication status
278: -- communication_id number(15) PK of irc_communications
279: -- effective_date date date record effective
280: -- object_version_number number(9) version of row
281: --
282: -- Post Success:
351: --
352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure chk_object_id
355: (p_object_id in irc_communications.object_id%TYPE,
356: p_object_type in irc_communications.object_type%TYPE
357: ) IS
358: --
359: l_proc varchar2(72) := g_package || 'chk_object_id';
352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure chk_object_id
355: (p_object_id in irc_communications.object_id%TYPE,
356: p_object_type in irc_communications.object_type%TYPE
357: ) IS
358: --
359: l_proc varchar2(72) := g_package || 'chk_object_id';
360: l_object_id varchar2(1);
367: and assignment_type = 'A';
368: --
369: cursor csr_object_type is
370: select null
371: from irc_communications ic
372: where ic.object_id = p_object_id
373: and ic.object_type = p_object_type;
374: --
375: begin
416: exception
417: when app_exception.application_exception then
418: if hr_multi_message.exception_add
419: (p_associated_column1 =>
420: 'IRC_COMMUNICATIONS.OBJECT_ID'
421: ) then
422: hr_utility.set_location(' Leaving:'||l_proc,60);
423: raise;
424: end if;
449: --
450: -- {End Of Comments}
451: -- ----------------------------------------------------------------------------
452: Procedure chk_object_type
453: (p_object_type in irc_communications.object_type%TYPE
454: ) IS
455: --
456: l_proc varchar2(72) := g_package || 'chk_object_type';
457: --
472: exception
473: when app_exception.application_exception then
474: if hr_multi_message.exception_add
475: (p_associated_column1 =>
476: 'IRC_COMMUNICATIONS.OBJECT_TYPE'
477: ) then
478: hr_utility.set_location(' Leaving:'||l_proc,30);
479: raise;
480: end if;
494: -- Pre Conditions:
495: -- None.
496: --
497: -- In Parameters:
498: -- communication_id number(15) PK of irc_communications
499: -- start_date date start date of communication
500: -- end_date date end date of communication
501: -- object_version_number number(9) version of row
502: --