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.PER_ZA_WSP_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 2602: , per_all_assignments_f paa

2598: , p_legal_entity_id number) is
2599: select ppf.person_id
2600: , paa.assignment_id
2601: from per_all_people_f ppf
2602: , per_all_assignments_f paa
2603: , per_assignment_extra_info paei
2604: , pay_payroll_actions ppa_arch
2605: , per_periods_of_service pps
2606: where paa.business_group_id = g_bg_id

Line 2626: from per_all_assignments_f paa1

2622: and ppf1.effective_end_date >= g_atr_start_date
2623: )
2624: -- check if the asg is active within the training and plan year
2625: and paa.effective_start_date = ( select max(paa1.effective_start_date)
2626: from per_all_assignments_f paa1
2627: where paa1.assignment_id = paa.assignment_id
2628: and paa1.effective_start_date <= g_wsp_end_date
2629: and paa1.effective_end_date >= g_atr_start_date
2630: );

Line 2861: , p_person_id in per_all_assignments_f.person_id%type

2857: Name : archive_wsp_data2
2858: Description : Archive person level WSP related data.
2859: *****************************************************************************/
2860: procedure archive_wsp_data2( assactid in number
2861: , p_person_id in per_all_assignments_f.person_id%type
2862: , p_assignment_id in per_all_assignments_f.assignment_id%type
2863: , p_race in per_all_people_f.per_information4%type
2864: , p_sex in per_all_people_f.sex%type
2865: , p_ass_cat_name in hr_lookups.meaning%type

Line 2862: , p_assignment_id in per_all_assignments_f.assignment_id%type

2858: Description : Archive person level WSP related data.
2859: *****************************************************************************/
2860: procedure archive_wsp_data2( assactid in number
2861: , p_person_id in per_all_assignments_f.person_id%type
2862: , p_assignment_id in per_all_assignments_f.assignment_id%type
2863: , p_race in per_all_people_f.per_information4%type
2864: , p_sex in per_all_people_f.sex%type
2865: , p_ass_cat_name in hr_lookups.meaning%type
2866: , p_skills_pri_id in number

Line 2939: , p_person_id in per_all_assignments_f.person_id%type

2935: Name : archive_wsp_data
2936: Description : Archive person level WSP related data.
2937: *****************************************************************************/
2938: procedure archive_wsp_data( assactid in number
2939: , p_person_id in per_all_assignments_f.person_id%type
2940: , p_assignment_id in per_all_assignments_f.assignment_id%type
2941: , p_race in per_all_people_f.per_information4%type
2942: , p_sex in per_all_people_f.sex%type
2943: , p_ass_cat_name in hr_lookups.meaning%type

Line 2940: , p_assignment_id in per_all_assignments_f.assignment_id%type

2936: Description : Archive person level WSP related data.
2937: *****************************************************************************/
2938: procedure archive_wsp_data( assactid in number
2939: , p_person_id in per_all_assignments_f.person_id%type
2940: , p_assignment_id in per_all_assignments_f.assignment_id%type
2941: , p_race in per_all_people_f.per_information4%type
2942: , p_sex in per_all_people_f.sex%type
2943: , p_ass_cat_name in hr_lookups.meaning%type
2944: , p_legal_entity_id in number

Line 3476: , p_person_id in per_all_assignments_f.person_id%type

3472: Name : archive_atr_data2
3473: Description : Archive person level ATR related data.
3474: *****************************************************************************/
3475: procedure archive_atr_data2( assactid in number
3476: , p_person_id in per_all_assignments_f.person_id%type
3477: , p_assignment_id in per_all_assignments_f.assignment_id%type
3478: , p_race in per_all_people_f.per_information4%type
3479: , p_sex in per_all_people_f.sex%type
3480: , p_ass_cat_name in hr_lookups.meaning%type

Line 3477: , p_assignment_id in per_all_assignments_f.assignment_id%type

3473: Description : Archive person level ATR related data.
3474: *****************************************************************************/
3475: procedure archive_atr_data2( assactid in number
3476: , p_person_id in per_all_assignments_f.person_id%type
3477: , p_assignment_id in per_all_assignments_f.assignment_id%type
3478: , p_race in per_all_people_f.per_information4%type
3479: , p_sex in per_all_people_f.sex%type
3480: , p_ass_cat_name in hr_lookups.meaning%type
3481: , p_skills_pri_id in number

Line 3560: , p_person_id in per_all_assignments_f.person_id%type

3556: Description : Archive person level ATR related data. All learning intervention
3557: are archived with the status of completed
3558: *****************************************************************************/
3559: procedure archive_atr_data( assactid in number
3560: , p_person_id in per_all_assignments_f.person_id%type
3561: , p_assignment_id in per_all_assignments_f.assignment_id%type
3562: , p_race in per_all_people_f.per_information4%type
3563: , p_sex in per_all_people_f.sex%type
3564: , p_ass_cat_name in hr_lookups.meaning%type

Line 3561: , p_assignment_id in per_all_assignments_f.assignment_id%type

3557: are archived with the status of completed
3558: *****************************************************************************/
3559: procedure archive_atr_data( assactid in number
3560: , p_person_id in per_all_assignments_f.person_id%type
3561: , p_assignment_id in per_all_assignments_f.assignment_id%type
3562: , p_race in per_all_people_f.per_information4%type
3563: , p_sex in per_all_people_f.sex%type
3564: , p_ass_cat_name in hr_lookups.meaning%type
3565: , p_legal_entity_id in number

Line 3940: p_business_group_id in per_all_assignments_f.business_group_id%type

3936: -- This procedure caches the location of the occupational category and level data.
3937: procedure cache_occupational_location
3938: (
3939: p_report_date in date,
3940: p_business_group_id in per_all_assignments_f.business_group_id%type
3941: ) is
3942:
3943: l_user_table_id pay_user_tables.user_table_id%type;
3944: l_user_column_id_flex pay_user_columns.user_column_id%type;

Line 4037: p_job_id in per_all_assignments_f.job_id%type,

4033: (
4034: p_type in varchar2,
4035: p_flex in varchar2,
4036: p_segment in varchar2,
4037: p_job_id in per_all_assignments_f.job_id%type,
4038: p_grade_id in per_all_assignments_f.grade_id%type,
4039: p_position_id in per_all_assignments_f.position_id%type
4040: ) return varchar2 is
4041:

Line 4038: p_grade_id in per_all_assignments_f.grade_id%type,

4034: p_type in varchar2,
4035: p_flex in varchar2,
4036: p_segment in varchar2,
4037: p_job_id in per_all_assignments_f.job_id%type,
4038: p_grade_id in per_all_assignments_f.grade_id%type,
4039: p_position_id in per_all_assignments_f.position_id%type
4040: ) return varchar2 is
4041:
4042: l_sql varchar2(32767);

Line 4039: p_position_id in per_all_assignments_f.position_id%type

4035: p_flex in varchar2,
4036: p_segment in varchar2,
4037: p_job_id in per_all_assignments_f.job_id%type,
4038: p_grade_id in per_all_assignments_f.grade_id%type,
4039: p_position_id in per_all_assignments_f.position_id%type
4040: ) return varchar2 is
4041:
4042: l_sql varchar2(32767);
4043: l_name hr_lookups.meaning%type;

Line 4105: p_report_date in per_all_assignments_f.effective_end_date%type,

4101: --
4102: -- This function returns the occupational category from the common lookups table.
4103: function get_occupational_category
4104: (
4105: p_report_date in per_all_assignments_f.effective_end_date%type,
4106: p_assignment_id in per_all_assignments_f.assignment_id%type,
4107: p_job_id in per_all_assignments_f.job_id%type,
4108: p_grade_id in per_all_assignments_f.grade_id%type,
4109: p_position_id in per_all_assignments_f.position_id%type,

Line 4106: p_assignment_id in per_all_assignments_f.assignment_id%type,

4102: -- This function returns the occupational category from the common lookups table.
4103: function get_occupational_category
4104: (
4105: p_report_date in per_all_assignments_f.effective_end_date%type,
4106: p_assignment_id in per_all_assignments_f.assignment_id%type,
4107: p_job_id in per_all_assignments_f.job_id%type,
4108: p_grade_id in per_all_assignments_f.grade_id%type,
4109: p_position_id in per_all_assignments_f.position_id%type,
4110: p_business_group_id in per_all_assignments_f.business_group_id%type

Line 4107: p_job_id in per_all_assignments_f.job_id%type,

4103: function get_occupational_category
4104: (
4105: p_report_date in per_all_assignments_f.effective_end_date%type,
4106: p_assignment_id in per_all_assignments_f.assignment_id%type,
4107: p_job_id in per_all_assignments_f.job_id%type,
4108: p_grade_id in per_all_assignments_f.grade_id%type,
4109: p_position_id in per_all_assignments_f.position_id%type,
4110: p_business_group_id in per_all_assignments_f.business_group_id%type
4111: ) return varchar2 is

Line 4108: p_grade_id in per_all_assignments_f.grade_id%type,

4104: (
4105: p_report_date in per_all_assignments_f.effective_end_date%type,
4106: p_assignment_id in per_all_assignments_f.assignment_id%type,
4107: p_job_id in per_all_assignments_f.job_id%type,
4108: p_grade_id in per_all_assignments_f.grade_id%type,
4109: p_position_id in per_all_assignments_f.position_id%type,
4110: p_business_group_id in per_all_assignments_f.business_group_id%type
4111: ) return varchar2 is
4112: l_cat_name hr_lookups.meaning%type;

Line 4109: p_position_id in per_all_assignments_f.position_id%type,

4105: p_report_date in per_all_assignments_f.effective_end_date%type,
4106: p_assignment_id in per_all_assignments_f.assignment_id%type,
4107: p_job_id in per_all_assignments_f.job_id%type,
4108: p_grade_id in per_all_assignments_f.grade_id%type,
4109: p_position_id in per_all_assignments_f.position_id%type,
4110: p_business_group_id in per_all_assignments_f.business_group_id%type
4111: ) return varchar2 is
4112: l_cat_name hr_lookups.meaning%type;
4113: begin

Line 4110: p_business_group_id in per_all_assignments_f.business_group_id%type

4106: p_assignment_id in per_all_assignments_f.assignment_id%type,
4107: p_job_id in per_all_assignments_f.job_id%type,
4108: p_grade_id in per_all_assignments_f.grade_id%type,
4109: p_position_id in per_all_assignments_f.position_id%type,
4110: p_business_group_id in per_all_assignments_f.business_group_id%type
4111: ) return varchar2 is
4112: l_cat_name hr_lookups.meaning%type;
4113: begin
4114: -- Check whether we have cached the location of Occupational data

Line 4148: l_assignment_id per_all_assignments_f.assignment_id%type;

4144: , p_effective_date in date
4145: ) is
4146:
4147: l_proc varchar2(50);
4148: l_assignment_id per_all_assignments_f.assignment_id%type;
4149: l_person_id per_all_assignments_f.person_id%type;
4150: l_ass_cat_name hr_lookups.meaning%type;
4151: l_race per_all_people_f.per_information4%type;
4152: l_sex per_all_people_f.sex%type;

Line 4149: l_person_id per_all_assignments_f.person_id%type;

4145: ) is
4146:
4147: l_proc varchar2(50);
4148: l_assignment_id per_all_assignments_f.assignment_id%type;
4149: l_person_id per_all_assignments_f.person_id%type;
4150: l_ass_cat_name hr_lookups.meaning%type;
4151: l_race per_all_people_f.per_information4%type;
4152: l_sex per_all_people_f.sex%type;
4153: l_legal_entity_id number(30);

Line 4184: From per_all_assignments_f paaf

4180: , l_sex
4181: , l_disability
4182: , l_legal_entity_id
4183: , l_ass_cat_name
4184: From per_all_assignments_f paaf
4185: , pay_assignment_actions paa
4186: , per_all_people_f perf
4187: , per_assignment_extra_info paei
4188: Where paa.assignment_action_id = p_assactid