eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT_API dependencies on PER_APPLICATIONS

Line 225: from per_applications papp

221:
222:
223: cursor c1 is
224: select date_end ,date_received, application_id
225: from per_applications papp
226: where application_id =
227: ( select distinct (application_id)
228: from per_all_assignments_f
229: where assignment_id = p_assignment_id and

Line 379: PER_APPLICATIONS_PKG .cancel_chk_current_emp(p_person_id => p_person_id ,

375:
376: -- Person is currently an Ex-Applicant with any falvour of Person Type
377: -- Check if the person is currently hired as Emp with that Assignment if so raise an error
378:
379: PER_APPLICATIONS_PKG .cancel_chk_current_emp(p_person_id => p_person_id ,
380: p_business_group_id => p_business_group_id ,
381: p_date_end => l_date_end );
382:
383: hr_utility.set_location('Entering:'|| l_proc, 100);

Line 438: -- Make a call to the IRC packages to maintain the IRC Assignment Statuses hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 30);

434: );
435:
436: hr_utility.set_location('Entering:'|| l_proc, 160);
437:
438: -- Make a call to the IRC packages to maintain the IRC Assignment Statuses hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 30);
439:
440: irc_asg_status_api.create_irc_asg_status
441: (p_validate => FALSE,
442: p_assignment_id => p_assignment_id,

Line 467: UPDATE PER_APPLICATIONS

463:
464: per_app_asg_pkg.cleanup_letters
465: (p_assignment_id => p_assignment_id);
466:
467: UPDATE PER_APPLICATIONS
468: SET date_end =null
469: where APPLICATION_ID =l_application_id
470: and person_id= p_person_id ;
471:

Line 19098: l_application_id per_applications.application_id%TYPE;

19094: l_comment_id per_all_assignments_f.comment_id%TYPE;
19095: l_group_name pay_people_groups.group_name%TYPE;
19096: l_old_group_name pay_people_groups.group_name%TYPE;
19097: --
19098: l_application_id per_applications.application_id%TYPE;
19099: l_business_group_id per_business_groups.business_group_id%TYPE;
19100: l_legislation_code per_business_groups.legislation_code%TYPE;
19101: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
19102: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';

Line 19112: l_appl_date_end per_applications.date_end%TYPE;

19108: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19109: l_session_id number;
19110: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19111: l_cagr_concatenated_segments varchar2(2000);
19112: l_appl_date_end per_applications.date_end%TYPE;
19113: --
19114: -- bug 2230915 new variables to indicate whether key flex id parameters
19115: -- enter the program with a value.
19116: --

Line 19215: l_apl_object_version_number per_applications.object_version_number%TYPE;

19211: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
19212: l_appl_override_warning boolean;
19213: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
19214: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
19215: l_apl_object_version_number per_applications.object_version_number%TYPE;
19216: --
19217:
19218: cursor csr_get_derived_details is
19219: select bus.business_group_id

Line 19232: from per_applications apl

19228: --
19229: -- 3652025 >>
19230: cursor csr_get_application is
19231: select apl.application_id, apl.date_end
19232: from per_applications apl
19233: where apl.person_id = p_person_id
19234: and l_effective_date between apl.date_received
19235: and nvl(apl.date_end,hr_api.g_eot);
19236: -- <<

Line 20813: l_application_id per_applications.application_id%TYPE;

20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
20810: l_comment_id per_all_assignments_f.comment_id%TYPE;
20811: l_group_name pay_people_groups.group_name%TYPE;
20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
20813: l_application_id per_applications.application_id%TYPE;
20814: l_business_group_id per_business_groups.business_group_id%TYPE;
20815: l_legislation_code per_business_groups.legislation_code%TYPE;
20816: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
20817: l_proc varchar2(72);

Line 21506: l_new_application_id per_applications.application_id%TYPE;

21502: --
21503: l_assignment_status_id irc_assignment_statuses.assignment_status_id%type;
21504: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
21505: -- 3652025 >>
21506: l_new_application_id per_applications.application_id%TYPE;
21507: l_fut_asg_start_date date;
21508: l_fut_asg_end_date date;
21509: l_comment_id number;
21510: l_payroll_id_updated boolean;

Line 21563: from per_applications

21559: ORDER BY as2.effective_start_date, as2.assignment_id ASC;
21560: --
21561: CURSOR csr_appl_details(cp_application_id number) IS
21562: select *
21563: from per_applications
21564: where application_id = cp_application_id;
21565:
21566: -- <<
21567: l_assignment csr_assignments%ROWTYPE;

Line 21815: UPDATE per_applications

21811: -- terminate current application
21812: --
21813: hr_utility.trace(' terminate current application on '||to_char(l_effective_date));
21814: --
21815: UPDATE per_applications
21816: SET date_end = l_effective_date
21817: where application_id = l_fut_asg.application_id;
21818: --
21819: open csr_appl_details(l_fut_asg.application_id);

Line 21987: UPDATE per_applications

21983: -- terminate current application
21984: --
21985: hr_utility.trace(' terminate current application on '||to_char(l_mx_end_dated));
21986: --
21987: UPDATE per_applications
21988: SET date_end = l_mx_end_dated
21989: where application_id = l_assignment.application_id;
21990: --
21991: open csr_appl_details(l_assignment.application_id);