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 2596: , per_all_assignments_f paa

2592: , p_legal_entity_id number) is
2593: select ppf.person_id
2594: , paa.assignment_id
2595: from per_all_people_f ppf
2596: , per_all_assignments_f paa
2597: , per_assignment_extra_info paei
2598: , pay_payroll_actions ppa_arch
2599: , per_periods_of_service pps
2600: where paa.business_group_id = g_bg_id

Line 2620: from per_all_assignments_f paa1

2616: and ppf1.effective_end_date >= g_atr_start_date
2617: )
2618: -- check if the asg is active within the training and plan year
2619: and paa.effective_start_date = ( select max(paa1.effective_start_date)
2620: from per_all_assignments_f paa1
2621: where paa1.assignment_id = paa.assignment_id
2622: and paa1.effective_start_date <= g_wsp_end_date
2623: and paa1.effective_end_date >= g_atr_start_date
2624: );

Line 2855: , p_person_id in per_all_assignments_f.person_id%type

2851: Name : archive_wsp_data2
2852: Description : Archive person level WSP related data.
2853: *****************************************************************************/
2854: procedure archive_wsp_data2( assactid in number
2855: , p_person_id in per_all_assignments_f.person_id%type
2856: , p_assignment_id in per_all_assignments_f.assignment_id%type
2857: , p_race in per_all_people_f.per_information4%type
2858: , p_sex in per_all_people_f.sex%type
2859: , p_ass_cat_name in hr_lookups.meaning%type

Line 2856: , p_assignment_id in per_all_assignments_f.assignment_id%type

2852: Description : Archive person level WSP related data.
2853: *****************************************************************************/
2854: procedure archive_wsp_data2( assactid in number
2855: , p_person_id in per_all_assignments_f.person_id%type
2856: , p_assignment_id in per_all_assignments_f.assignment_id%type
2857: , p_race in per_all_people_f.per_information4%type
2858: , p_sex in per_all_people_f.sex%type
2859: , p_ass_cat_name in hr_lookups.meaning%type
2860: , p_skills_pri_id in number

Line 2933: , p_person_id in per_all_assignments_f.person_id%type

2929: Name : archive_wsp_data
2930: Description : Archive person level WSP related data.
2931: *****************************************************************************/
2932: procedure archive_wsp_data( assactid in number
2933: , p_person_id in per_all_assignments_f.person_id%type
2934: , p_assignment_id in per_all_assignments_f.assignment_id%type
2935: , p_race in per_all_people_f.per_information4%type
2936: , p_sex in per_all_people_f.sex%type
2937: , p_ass_cat_name in hr_lookups.meaning%type

Line 2934: , p_assignment_id in per_all_assignments_f.assignment_id%type

2930: Description : Archive person level WSP related data.
2931: *****************************************************************************/
2932: procedure archive_wsp_data( assactid in number
2933: , p_person_id in per_all_assignments_f.person_id%type
2934: , p_assignment_id in per_all_assignments_f.assignment_id%type
2935: , p_race in per_all_people_f.per_information4%type
2936: , p_sex in per_all_people_f.sex%type
2937: , p_ass_cat_name in hr_lookups.meaning%type
2938: , p_legal_entity_id in number

Line 3470: , p_person_id in per_all_assignments_f.person_id%type

3466: Name : archive_atr_data2
3467: Description : Archive person level ATR related data.
3468: *****************************************************************************/
3469: procedure archive_atr_data2( assactid in number
3470: , p_person_id in per_all_assignments_f.person_id%type
3471: , p_assignment_id in per_all_assignments_f.assignment_id%type
3472: , p_race in per_all_people_f.per_information4%type
3473: , p_sex in per_all_people_f.sex%type
3474: , p_ass_cat_name in hr_lookups.meaning%type

Line 3471: , p_assignment_id in per_all_assignments_f.assignment_id%type

3467: Description : Archive person level ATR related data.
3468: *****************************************************************************/
3469: procedure archive_atr_data2( assactid in number
3470: , p_person_id in per_all_assignments_f.person_id%type
3471: , p_assignment_id in per_all_assignments_f.assignment_id%type
3472: , p_race in per_all_people_f.per_information4%type
3473: , p_sex in per_all_people_f.sex%type
3474: , p_ass_cat_name in hr_lookups.meaning%type
3475: , p_skills_pri_id in number

Line 3554: , p_person_id in per_all_assignments_f.person_id%type

3550: Description : Archive person level ATR related data. All learning intervention
3551: are archived with the status of completed
3552: *****************************************************************************/
3553: procedure archive_atr_data( assactid in number
3554: , p_person_id in per_all_assignments_f.person_id%type
3555: , p_assignment_id in per_all_assignments_f.assignment_id%type
3556: , p_race in per_all_people_f.per_information4%type
3557: , p_sex in per_all_people_f.sex%type
3558: , p_ass_cat_name in hr_lookups.meaning%type

Line 3555: , p_assignment_id in per_all_assignments_f.assignment_id%type

3551: are archived with the status of completed
3552: *****************************************************************************/
3553: procedure archive_atr_data( assactid in number
3554: , p_person_id in per_all_assignments_f.person_id%type
3555: , p_assignment_id in per_all_assignments_f.assignment_id%type
3556: , p_race in per_all_people_f.per_information4%type
3557: , p_sex in per_all_people_f.sex%type
3558: , p_ass_cat_name in hr_lookups.meaning%type
3559: , p_legal_entity_id in number

Line 3934: p_business_group_id in per_all_assignments_f.business_group_id%type

3930: -- This procedure caches the location of the occupational category and level data.
3931: procedure cache_occupational_location
3932: (
3933: p_report_date in date,
3934: p_business_group_id in per_all_assignments_f.business_group_id%type
3935: ) is
3936:
3937: l_user_table_id pay_user_tables.user_table_id%type;
3938: l_user_column_id_flex pay_user_columns.user_column_id%type;

Line 4031: p_job_id in per_all_assignments_f.job_id%type,

4027: (
4028: p_type in varchar2,
4029: p_flex in varchar2,
4030: p_segment in varchar2,
4031: p_job_id in per_all_assignments_f.job_id%type,
4032: p_grade_id in per_all_assignments_f.grade_id%type,
4033: p_position_id in per_all_assignments_f.position_id%type
4034: ) return varchar2 is
4035:

Line 4032: p_grade_id in per_all_assignments_f.grade_id%type,

4028: p_type in varchar2,
4029: p_flex in varchar2,
4030: p_segment in varchar2,
4031: p_job_id in per_all_assignments_f.job_id%type,
4032: p_grade_id in per_all_assignments_f.grade_id%type,
4033: p_position_id in per_all_assignments_f.position_id%type
4034: ) return varchar2 is
4035:
4036: l_sql varchar2(32767);

Line 4033: p_position_id in per_all_assignments_f.position_id%type

4029: p_flex in varchar2,
4030: p_segment in varchar2,
4031: p_job_id in per_all_assignments_f.job_id%type,
4032: p_grade_id in per_all_assignments_f.grade_id%type,
4033: p_position_id in per_all_assignments_f.position_id%type
4034: ) return varchar2 is
4035:
4036: l_sql varchar2(32767);
4037: l_name hr_lookups.meaning%type;

Line 4099: p_report_date in per_all_assignments_f.effective_end_date%type,

4095: --
4096: -- This function returns the occupational category from the common lookups table.
4097: function get_occupational_category
4098: (
4099: p_report_date in per_all_assignments_f.effective_end_date%type,
4100: p_assignment_id in per_all_assignments_f.assignment_id%type,
4101: p_job_id in per_all_assignments_f.job_id%type,
4102: p_grade_id in per_all_assignments_f.grade_id%type,
4103: p_position_id in per_all_assignments_f.position_id%type,

Line 4100: p_assignment_id in per_all_assignments_f.assignment_id%type,

4096: -- This function returns the occupational category from the common lookups table.
4097: function get_occupational_category
4098: (
4099: p_report_date in per_all_assignments_f.effective_end_date%type,
4100: p_assignment_id in per_all_assignments_f.assignment_id%type,
4101: p_job_id in per_all_assignments_f.job_id%type,
4102: p_grade_id in per_all_assignments_f.grade_id%type,
4103: p_position_id in per_all_assignments_f.position_id%type,
4104: p_business_group_id in per_all_assignments_f.business_group_id%type

Line 4101: p_job_id in per_all_assignments_f.job_id%type,

4097: function get_occupational_category
4098: (
4099: p_report_date in per_all_assignments_f.effective_end_date%type,
4100: p_assignment_id in per_all_assignments_f.assignment_id%type,
4101: p_job_id in per_all_assignments_f.job_id%type,
4102: p_grade_id in per_all_assignments_f.grade_id%type,
4103: p_position_id in per_all_assignments_f.position_id%type,
4104: p_business_group_id in per_all_assignments_f.business_group_id%type
4105: ) return varchar2 is

Line 4102: p_grade_id in per_all_assignments_f.grade_id%type,

4098: (
4099: p_report_date in per_all_assignments_f.effective_end_date%type,
4100: p_assignment_id in per_all_assignments_f.assignment_id%type,
4101: p_job_id in per_all_assignments_f.job_id%type,
4102: p_grade_id in per_all_assignments_f.grade_id%type,
4103: p_position_id in per_all_assignments_f.position_id%type,
4104: p_business_group_id in per_all_assignments_f.business_group_id%type
4105: ) return varchar2 is
4106: l_cat_name hr_lookups.meaning%type;

Line 4103: p_position_id in per_all_assignments_f.position_id%type,

4099: p_report_date in per_all_assignments_f.effective_end_date%type,
4100: p_assignment_id in per_all_assignments_f.assignment_id%type,
4101: p_job_id in per_all_assignments_f.job_id%type,
4102: p_grade_id in per_all_assignments_f.grade_id%type,
4103: p_position_id in per_all_assignments_f.position_id%type,
4104: p_business_group_id in per_all_assignments_f.business_group_id%type
4105: ) return varchar2 is
4106: l_cat_name hr_lookups.meaning%type;
4107: begin

Line 4104: p_business_group_id in per_all_assignments_f.business_group_id%type

4100: p_assignment_id in per_all_assignments_f.assignment_id%type,
4101: p_job_id in per_all_assignments_f.job_id%type,
4102: p_grade_id in per_all_assignments_f.grade_id%type,
4103: p_position_id in per_all_assignments_f.position_id%type,
4104: p_business_group_id in per_all_assignments_f.business_group_id%type
4105: ) return varchar2 is
4106: l_cat_name hr_lookups.meaning%type;
4107: begin
4108: -- Check whether we have cached the location of Occupational data

Line 4142: l_assignment_id per_all_assignments_f.assignment_id%type;

4138: , p_effective_date in date
4139: ) is
4140:
4141: l_proc varchar2(50);
4142: l_assignment_id per_all_assignments_f.assignment_id%type;
4143: l_person_id per_all_assignments_f.person_id%type;
4144: l_ass_cat_name hr_lookups.meaning%type;
4145: l_race per_all_people_f.per_information4%type;
4146: l_sex per_all_people_f.sex%type;

Line 4143: l_person_id per_all_assignments_f.person_id%type;

4139: ) is
4140:
4141: l_proc varchar2(50);
4142: l_assignment_id per_all_assignments_f.assignment_id%type;
4143: l_person_id per_all_assignments_f.person_id%type;
4144: l_ass_cat_name hr_lookups.meaning%type;
4145: l_race per_all_people_f.per_information4%type;
4146: l_sex per_all_people_f.sex%type;
4147: l_legal_entity_id number(30);

Line 4178: From per_all_assignments_f paaf

4174: , l_sex
4175: , l_disability
4176: , l_legal_entity_id
4177: , l_ass_cat_name
4178: From per_all_assignments_f paaf
4179: , pay_assignment_actions paa
4180: , per_all_people_f perf
4181: , per_assignment_extra_info paei
4182: Where paa.assignment_action_id = p_assactid