DBA Data[Home] [Help]

APPS.PER_APP_ASG_PKG dependencies on IRC_ASG_STATUS_API

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

211: where assignment_id = P_ASSIGNMENT_ID
212: and effective_start_date = P_EFFECTIVE_START_DATE
213: and effective_end_date = P_EFFECTIVE_END_DATE;
214: --
215: l_assignment_status_id number; -- discards output from irc_asg_status api
216: l_object_version_number number; -- discards output from irc_asg_status api
217: --
218: begin
219: --

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

212: and effective_start_date = P_EFFECTIVE_START_DATE
213: and effective_end_date = P_EFFECTIVE_END_DATE;
214: --
215: l_assignment_status_id number; -- discards output from irc_asg_status api
216: l_object_version_number number; -- discards output from irc_asg_status api
217: --
218: begin
219: --
220: -- PRE-INSERT CHECKS

Line 467: irc_asg_status_api.create_irc_asg_status

463: -- through PUI, will not visible in iRec for applicants created through iRec
464: -- Bug# 2985747
465: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 10 ) ;
466:
467: irc_asg_status_api.create_irc_asg_status
468: ( p_validate => FALSE
469: , p_assignment_id => p_assignment_id
470: , p_assignment_status_type_id => p_assignment_status_type_id
471: , p_status_change_date => p_effective_start_date

Line 654: irc_asg_status_api.dt_delete_irc_asg_status(

650: fetch csr_asg_data into l_irc_asg_type;
651:
652: if csr_asg_data%FOUND then
653: close csr_asg_data;
654: irc_asg_status_api.dt_delete_irc_asg_status(
655: p_validate => false
656: ,p_assignment_status_id => l_irc_asg_type
657: ,p_object_version_number => l_irc_asg_ovn
658: ,p_effective_date => p_effective_end_date

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

1217: l_cost_warning boolean; -- used to catch the cost warning from tidy_up_ref_int
1218: -- but as Apl asg's can't have costing records no need
1219: -- to return to caller.
1220: l_previous_asg_status number; -- used to check if asg status changed
1221: l_assignment_status_id number; -- discards output from irc_asg_status api
1222: l_object_version_number number; -- ditto
1223: l_previous_vacancy_id number; -- Added for bug 3680947.
1224: -- Start of fix 3634447
1225: -- Cursor to get the current organization

Line 1515: IRC_ASG_STATUS_API.create_irc_asg_status

1511: -- 3652025: if terminated, client already performed this step
1512: -- when calling terminate_apl_asg API.
1513: --
1514: if p_per_system_status <> 'TERM_APL' then
1515: IRC_ASG_STATUS_API.create_irc_asg_status
1516: ( p_validate => FALSE
1517: , p_assignment_id => p_assignment_id
1518: , p_assignment_status_type_id => p_assignment_status_type_id
1519: , p_status_change_date => p_effective_start_date -- 2754362 p_effective_end_date