DBA Data[Home] [Help]

APPS.PER_APP_ASG_PKG dependencies on IRC_ASG_STATUS_API

Line 208: l_assignment_status_id number; -- discards output from irc_asg_status api

204: where assignment_id = P_ASSIGNMENT_ID
205: and effective_start_date = P_EFFECTIVE_START_DATE
206: and effective_end_date = P_EFFECTIVE_END_DATE;
207: --
208: l_assignment_status_id number; -- discards output from irc_asg_status api
209: l_object_version_number number; -- discards output from irc_asg_status api
210: --
211: begin
212: --

Line 209: l_object_version_number number; -- discards output from irc_asg_status api

205: and effective_start_date = P_EFFECTIVE_START_DATE
206: and effective_end_date = P_EFFECTIVE_END_DATE;
207: --
208: l_assignment_status_id number; -- discards output from irc_asg_status api
209: l_object_version_number number; -- discards output from irc_asg_status api
210: --
211: begin
212: --
213: -- PRE-INSERT CHECKS

Line 458: irc_asg_status_api.create_irc_asg_status

454: --
455: -- Insert record into iRec Asg Statuses. Otherwise the applications applied
456: -- through PUI, will not visible in iRec for applicants created through iRec
457: -- Bug# 2985747
458: irc_asg_status_api.create_irc_asg_status
459: ( p_validate => FALSE
460: , p_assignment_id => p_assignment_id
461: , p_assignment_status_type_id => p_assignment_status_type_id
462: , p_status_change_date => p_effective_start_date

Line 1122: l_assignment_status_id number; -- discards output from irc_asg_status api

1118: l_cost_warning boolean; -- used to catch the cost warning from tidy_up_ref_int
1119: -- but as Apl asg's can't have costing records no need
1120: -- to return to caller.
1121: l_previous_asg_status number; -- used to check if asg status changed
1122: l_assignment_status_id number; -- discards output from irc_asg_status api
1123: l_object_version_number number; -- ditto
1124: l_previous_vacancy_id number; -- Added for bug 3680947.
1125: -- Start of fix 3634447
1126: -- Cursor to get the current organization

Line 1335: IRC_ASG_STATUS_API.create_irc_asg_status

1331: -- 3652025: if terminated, client already performed this step
1332: -- when calling terminate_apl_asg API.
1333: --
1334: if p_per_system_status <> 'TERM_APL' then
1335: IRC_ASG_STATUS_API.create_irc_asg_status
1336: ( p_validate => FALSE
1337: , p_assignment_id => p_assignment_id
1338: , p_assignment_status_type_id => p_assignment_status_type_id
1339: , p_status_change_date => p_effective_start_date -- 2754362 p_effective_end_date