APPS.IRC_IAS_BUS dependencies on IRC_ASSIGNMENT_STATUSES

Line 89: , irc_assignment_statuses ias

85: cursor csr_leg_code is
86: select pbg.legislation_code
87: from per_business_groups_perf pbg
88: , per_all_assignments_f asg
89: , irc_assignment_statuses ias
90: where pbg.business_group_id = asg.business_group_id
91: and asg.assignment_id = ias.assignment_id
92: and ias.assignment_status_id = p_assignment_status_id ;
93: --

Line 220: irc_assignment_statuses.assignment_id%type

216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure chk_assignment_id
219: (p_assignment_id in
220: irc_assignment_statuses.assignment_id%type
221: ) is
222: --
223: l_proc varchar2(72) := g_package || 'chk_assignment_id';
224: --

Line 225: l_assignment_id irc_assignment_statuses.assignment_id%type ;

221: ) is
222: --
223: l_proc varchar2(72) := g_package || 'chk_assignment_id';
224: --
225: l_assignment_id irc_assignment_statuses.assignment_id%type ;
226: --
227: cursor csr_applicant_assignment is
228: select 1
229: from per_all_assignments_f

Line 284: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'

280: --
281: exception
282: when app_exception.application_exception then
283: if hr_multi_message.exception_add
284: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'
285: ) then
286: hr_utility.set_location(' Leaving:'|| l_proc, 60);
287: raise;
288: end if;

Line 318: irc_assignment_statuses.assignment_status_type_id%type

314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure chk_assignment_status_type_id
317: (p_asg_status_type_id in
318: irc_assignment_statuses.assignment_status_type_id%type
319: ) is
320: --
321: l_proc varchar2(72) := g_package || 'chk_assignment_status_type_id';
322: --

Line 323: l_asg_status_type_id irc_assignment_statuses.assignment_status_type_id%type;

319: ) is
320: --
321: l_proc varchar2(72) := g_package || 'chk_assignment_status_type_id';
322: --
323: l_asg_status_type_id irc_assignment_statuses.assignment_status_type_id%type;
324: --
325: cursor csr_exists is
326: select 1
327: from PER_ASSIGNMENT_STATUS_TYPES

Line 354: 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID'

350: exception
351: when app_exception.application_exception then
352: if hr_multi_message.exception_add
353: (p_associated_column1=>
354: 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID'
355: ) then
356: hr_utility.set_location(' Leaving:'|| l_proc, 50);
357: raise;
358: end if;