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_PROCESS_ASSIGNMENT_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 58: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is

54:
55: -- bug 5032032
56: procedure get_asg_from_tt
57: (p_transaction_step_id in number
58: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is
59: l_proc varchar2(72) := g_package||'get_asg_from_tt';
60:
61: begin
62: --dbms_output.put_line(' ');

Line 2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2234: ,p_vendor_site_id in number default hr_api.g_number
2235: ,p_proj_asgn_end in date default g_canonical_date
2236:
2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;

Line 2239: l_person_id per_all_assignments_f.person_id%TYPE;

2235: ,p_proj_asgn_end in date default g_canonical_date
2236:
2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;
2243: l_effective_date date;

Line 2251: l_assignment_rec per_all_assignments_f%rowtype;

2247: l_result varchar2(100);
2248: l_transaction_step_id number;
2249: l_count number;
2250: l_trans_tbl hr_transaction_ss.transaction_table;
2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;
2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

Line 2252: l_old_assignment_rec per_all_assignments_f%rowtype;

2248: l_transaction_step_id number;
2249: l_count number;
2250: l_trans_tbl hr_transaction_ss.transaction_table;
2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;
2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
2256: l_trns_object_version_number number;

Line 2253: l_db_assignment_rec per_all_assignments_f%rowtype;

2249: l_count number;
2250: l_trans_tbl hr_transaction_ss.transaction_table;
2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;
2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
2256: l_trns_object_version_number number;
2257: l_datetrack_update_mode varchar2(30);

Line 2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;
2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
2256: l_trns_object_version_number number;
2257: l_datetrack_update_mode varchar2(30);
2258: l_last_change_date date;
2259: l_review_proc_call varchar2(4000);

Line 2323: (p_grade_ladder_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE ,

2319:
2320: -- cursor to find whether assigned grade ladder id updates
2321: -- the salary using Grade Step Progression
2322: CURSOR lc_sal_updateable_grade_ladder
2323: (p_grade_ladder_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE ,
2324: p_effective_date in date
2325: ) IS
2326: select pgm_id, update_salary_cd from ben_pgm_f
2327: where

Line 2351: -- per_all_assignments_f

2347: and effective_end_date;
2348:
2349: --
2350: -- cursor to get the applicant object_version_number from
2351: -- per_all_assignments_f
2352: cursor asg_applicant_rec(p_appl_assign_id in number,
2353: p_appl_effective_date in date) is
2354: select object_version_number,
2355: assignment_status_type_id

Line 2356: from per_all_assignments_f

2352: cursor asg_applicant_rec(p_appl_assign_id in number,
2353: p_appl_effective_date in date) is
2354: select object_version_number,
2355: assignment_status_type_id
2356: from per_all_assignments_f
2357: where assignment_id = p_appl_assign_id
2358: and p_appl_effective_date between effective_start_date
2359: and effective_end_date;
2360:

Line 2365: from per_all_assignments_f asf,

2361: --
2362:
2363: cursor last_change_date is
2364: select max(asf.effective_start_date)
2365: from per_all_assignments_f asf,
2366: per_assignment_status_types past
2367: where asf.assignment_id=l_assignment_id
2368: and asf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID;
2369: -- ns 10-May-03: Since termination is handled on the effective date page

Line 2377: from per_all_assignments_f asf,

2373:
2374: -- New cursor to see if any assignment record exist for the selected date
2375: cursor correction_date is
2376: select null
2377: from per_all_assignments_f asf,
2378: per_assignment_status_types past
2379: where asf.assignment_id = l_assignment_id
2380: and asf.assignment_status_type_id = past.assignment_status_type_id
2381: and asf.effective_start_date = l_effective_date;

Line 2408: from per_all_assignments_f

2404: where grade_id = p_id;
2405:
2406: cursor csr_assignment is
2407: select assignment_id
2408: from per_all_assignments_f
2409: where assignment_id = p_assignment_id;
2410:
2411: cursor process_order(l_item_type in varchar2,l_item_key in varchar2) is
2412: select processing_order from hr_api_transaction_steps where

Line 4305: -- per_all_assignments_f

4301: -- Need to use the latest object version number and also assginment_status_type_id
4302: -- before calling the update_assignment as the above api call will change the object
4303: -- version number and update the assignment record in correction mode
4304: -- first get the object_version_number for the applicant from
4305: -- per_all_assignments_f
4306: open asg_applicant_rec(l_assignment_id, l_effective_date);
4307: fetch asg_applicant_rec into l_object_version_number
4308: ,l_assignment_rec.assignment_status_type_id;
4309: close asg_applicant_rec;

Line 5754: from per_all_assignments_f

5750: ,p_login_person_id in number) is
5751:
5752: cursor csr_new_object_number(p_asg_id in number) is
5753: select object_version_number
5754: from per_all_assignments_f
5755: where assignment_id = p_asg_id
5756: and assignment_type = 'E'
5757: order by object_version_number desc;
5758:

Line 5801: l_assignment_rec per_all_assignments_f%rowtype;

5797: ,p_transaction_step_id in number
5798: ,p_effective_date in varchar2 default null
5799: ) is
5800:
5801: l_assignment_rec per_all_assignments_f%rowtype;
5802: l_effective_date date;
5803: l_datetrack_update_mode varchar2(30);
5804: --
5805: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

Line 5805: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

5801: l_assignment_rec per_all_assignments_f%rowtype;
5802: l_effective_date date;
5803: l_datetrack_update_mode varchar2(30);
5804: --
5805: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
5806: l_effective_start_date date;
5807: l_effective_end_date date;
5808: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5809: l_group_name VARCHAR2(2000);

Line 5808: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

5804: --
5805: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
5806: l_effective_start_date date;
5807: l_effective_end_date date;
5808: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5809: l_group_name VARCHAR2(2000);
5810: l_org_now_no_manager_warning boolean;
5811: l_other_manager_warning boolean;
5812: l_spp_delete_warning boolean;

Line 5815: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

5811: l_other_manager_warning boolean;
5812: l_spp_delete_warning boolean;
5813: l_entries_changed_warning VARCHAR2(30);
5814: l_tax_district_changed_warning boolean;
5815: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
5816: l_comment_id per_all_assignments_f.comment_id%TYPE;
5817: l_concatenated_segments VARCHAR2(2000);
5818: l_element_changed VARCHAR2(1) default 'W';
5819:

Line 5816: l_comment_id per_all_assignments_f.comment_id%TYPE;

5812: l_spp_delete_warning boolean;
5813: l_entries_changed_warning VARCHAR2(30);
5814: l_tax_district_changed_warning boolean;
5815: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
5816: l_comment_id per_all_assignments_f.comment_id%TYPE;
5817: l_concatenated_segments VARCHAR2(2000);
5818: l_element_changed VARCHAR2(1) default 'W';
5819:
5820: l_page_error varchar2(2000);

Line 5838: l_appl_assignment_type per_all_assignments_f.assignment_type%type;

5834: l_location_error varchar2(2000);
5835: l_location_error_msg varchar2(2000);
5836:
5837: -- variables and cursors for applicant_hire
5838: l_appl_assignment_type per_all_assignments_f.assignment_type%type;
5839: l_new_hire_appl_hire varchar2(10);
5840: l_login_person_id number;
5841:
5842: -- GSP

Line 5849: -- per_all_assignments_f

5845: l_proc varchar2(72) := g_package||'process_api';
5846: -- End of GSP
5847:
5848: -- cursor to get the applicant object_version_number from
5849: -- per_all_assignments_f
5850: cursor asg_applicant_rec(p_appl_assign_id in number,
5851: p_appl_effective_date in date) is
5852: select object_version_number,
5853: assignment_type,

Line 5855: from per_all_assignments_f

5851: p_appl_effective_date in date) is
5852: select object_version_number,
5853: assignment_type,
5854: assignment_status_type_id
5855: from per_all_assignments_f
5856: where assignment_id = p_appl_assign_id
5857: and p_appl_effective_date between effective_start_date
5858: and effective_end_date;
5859:

Line 6247: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

6243: ,p_job_post_source_name in varchar2 default null
6244: ,p_perf_review_period in number default null
6245: ,p_perf_review_period_frequency in varchar2 default null
6246: ,p_internal_address_line in varchar2 default null
6247: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
6248: -- GSP change
6249: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6250: -- GSP change
6251: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

Line 6249: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE

6245: ,p_perf_review_period_frequency in varchar2 default null
6246: ,p_internal_address_line in varchar2 default null
6247: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
6248: -- GSP change
6249: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6250: -- GSP change
6251: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6252: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6253: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 6251: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

6247: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
6248: -- GSP change
6249: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6250: -- GSP change
6251: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6252: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6253: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6254: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6255: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

Line 6252: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE

6248: -- GSP change
6249: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6250: -- GSP change
6251: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6252: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6253: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6254: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6255: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6256: ,p_person_id in per_all_assignments_f.person_id%TYPE

Line 6253: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

6249: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6250: -- GSP change
6251: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6252: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6253: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6254: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6255: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6256: ,p_person_id in per_all_assignments_f.person_id%TYPE
6257: ,p_effective_start_date out nocopy date

Line 6254: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE

6250: -- GSP change
6251: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6252: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6253: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6254: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6255: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6256: ,p_person_id in per_all_assignments_f.person_id%TYPE
6257: ,p_effective_start_date out nocopy date
6258: ,p_effective_end_date out nocopy date

Line 6255: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

6251: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6252: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6253: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6254: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6255: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6256: ,p_person_id in per_all_assignments_f.person_id%TYPE
6257: ,p_effective_start_date out nocopy date
6258: ,p_effective_end_date out nocopy date
6259: ,p_element_warning in boolean

Line 6256: ,p_person_id in per_all_assignments_f.person_id%TYPE

6252: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6253: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6254: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6255: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6256: ,p_person_id in per_all_assignments_f.person_id%TYPE
6257: ,p_effective_start_date out nocopy date
6258: ,p_effective_end_date out nocopy date
6259: ,p_element_warning in boolean
6260: ,p_element_changed in out nocopy varchar2

Line 6299: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

6295: ) is
6296: --
6297:
6298: l_effective_date date;
6299: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
6300: l_effective_start_date date;
6301: l_effective_end_date date;
6302: -- Fix for 3633612 to pass new people group flx ccid to hr_assignment_api, so that these
6303: -- hr_assignment_api's won't validate the old segment values.

Line 6304: l_people_group_id per_all_assignments_f.people_group_id%TYPE

6300: l_effective_start_date date;
6301: l_effective_end_date date;
6302: -- Fix for 3633612 to pass new people group flx ccid to hr_assignment_api, so that these
6303: -- hr_assignment_api's won't validate the old segment values.
6304: l_people_group_id per_all_assignments_f.people_group_id%TYPE
6305: := p_people_group_id;
6306: l_group_name VARCHAR2(2000);
6307: l_org_now_no_manager_warning boolean;
6308: l_other_manager_warning boolean;

Line 6312: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

6308: l_other_manager_warning boolean;
6309: l_spp_delete_warning boolean;
6310: l_entries_changed_warning VARCHAR2(30);
6311: l_tax_district_changed_warning boolean;
6312: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6313: l_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
6314: l_cagr_concatenated_segments varchar2(2000);
6315: l_comment_id per_all_assignments_f.comment_id%TYPE;
6316: l_concatenated_segments VARCHAR2(2000);

Line 6313: l_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;

6309: l_spp_delete_warning boolean;
6310: l_entries_changed_warning VARCHAR2(30);
6311: l_tax_district_changed_warning boolean;
6312: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6313: l_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
6314: l_cagr_concatenated_segments varchar2(2000);
6315: l_comment_id per_all_assignments_f.comment_id%TYPE;
6316: l_concatenated_segments VARCHAR2(2000);
6317: l_hourly_salaried_warning boolean default false;

Line 6315: l_comment_id per_all_assignments_f.comment_id%TYPE;

6311: l_tax_district_changed_warning boolean;
6312: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6313: l_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
6314: l_cagr_concatenated_segments varchar2(2000);
6315: l_comment_id per_all_assignments_f.comment_id%TYPE;
6316: l_concatenated_segments VARCHAR2(2000);
6317: l_hourly_salaried_warning boolean default false;
6318: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
6319: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

Line 6344: from per_all_assignments_f

6340: l_proc varchar2(72) := g_package||'update_assignment';
6341: --
6342: cursor current_job_id is
6343: select job_id
6344: from per_all_assignments_f
6345: where assignment_id=p_assignment_id
6346: and l_effective_date between effective_start_date and effective_end_date;
6347:
6348: --

Line 6408: per_all_assignments_f asg

6404:
6405: cursor csr_default_gre is
6406: select scl.segment1
6407: from hr_soft_coding_keyflex scl,
6408: per_all_assignments_f asg
6409: where asg.person_id = p_login_person_id
6410: and asg.business_group_id = p_business_group_id --the new hire business group
6411: and asg.primary_flag = 'Y'
6412: and trunc(sysdate) between asg.effective_start_date

Line 6860: from per_all_assignments_f

6856: -- bug 5547271
6857: if (hr_process_person_ss.g_is_applicant) then
6858: begin
6859: select PAYROLL_ID into l_old_payroll_id
6860: from per_all_assignments_f
6861: where assignment_id = p_assignment_id and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
6862: end;
6863: hrentmnt.maintain_entries_asg
6864: (p_assignment_id => p_assignment_id