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 264: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'

260: --
261: exception
262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'
265: ) then
266: hr_utility.set_location(' Leaving:'|| l_proc, 60);
267: raise;
268: end if;

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

324: --
325: exception
326: when app_exception.application_exception then
327: if hr_multi_message.exception_add
328: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'
329: ) then
330: hr_utility.set_location(' Leaving:'|| l_proc, 60);
331: raise;
332: end if;

Line 364: irc_assignment_statuses.assignment_status_type_id%type

360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure chk_assignment_status_type_id
363: (p_asg_status_type_id in
364: irc_assignment_statuses.assignment_status_type_id%type
365: ) is
366: --
367: l_proc varchar2(72) := g_package || 'chk_assignment_status_type_id';
368: --

Line 369: l_asg_status_type_id irc_assignment_statuses.assignment_status_type_id%type;

365: ) is
366: --
367: l_proc varchar2(72) := g_package || 'chk_assignment_status_type_id';
368: --
369: l_asg_status_type_id irc_assignment_statuses.assignment_status_type_id%type;
370: --
371: cursor csr_exists is
372: select 1
373: from PER_ASSIGNMENT_STATUS_TYPES

Line 400: 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID'

396: exception
397: when app_exception.application_exception then
398: if hr_multi_message.exception_add
399: (p_associated_column1=>
400: 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID'
401: ) then
402: hr_utility.set_location(' Leaving:'|| l_proc, 50);
403: raise;
404: end if;