[Home] [Help]
53: Procedure correct_people_row (
54: p_people_data in out nocopy per_all_people_f%rowtype);
55:
56: Procedure correct_asgn_row (
57: p_asgn_data in out nocopy per_all_assignments_f%rowtype);
58:
59: Procedure correct_peopleei_row ( p_peopleei_data in out nocopy per_people_extra_info%rowtype);
60:
61: Procedure correct_addresses_row( p_addr_data in out nocopy per_addresses%rowtype);
1022: p_hist_data_as_of_date in ghr_pa_history%rowtype
1023: ) is
1024:
1025: l_true_false ghr_history_cascade.condition_rg_type;
1026: l_asgn_data per_all_assignments_f%rowtype;
1027: l_hist_asgn_data ghr_pa_history%rowtype;
1028: l_stop Boolean;
1029: l_proc varchar2(30):='Cascade_asgn';
1030:
1030:
1031: -- this cursor is meant to retrieve all following records in per_assignments_f table.
1032: Cursor c_asgn( c_date_Effective in date, c_asgn_id in number) is
1033: Select *
1034: from per_all_assignments_f
1035: where effective_start_date >= c_date_effective and
1036: assignment_id = c_asgn_id;
1037:
1038: Begin
1952: --
1953: -- {End Of Comments}
1954: -- ---------------------------------------------------------------------------
1955: Procedure Correct_asgn_row (
1956: p_asgn_data in out nocopy per_all_assignments_f%rowtype) is
1957:
1958: -- this cursor gets the object_version_number from core table, so the core
1959: -- table can be updated.
1960: cursor c_asgn_getovn( cp_assignment_id number,
1960: cursor c_asgn_getovn( cp_assignment_id number,
1961: cp_eff_st_dt date
1962: ,cp_eff_end_dt date) is
1963: select object_version_number
1964: from per_all_assignments_f
1965: where assignment_id = cp_assignment_id
1966: and effective_start_date = cp_eff_st_dt;
1967:
1968: -- and effective_end_date = cp_eff_end_dt;
1966: and effective_start_date = cp_eff_st_dt;
1967:
1968: -- and effective_end_date = cp_eff_end_dt;
1969:
1970: l_asgn_data per_all_assignments_f%rowtype;
1971: l_payroll_id_updated boolean;
1972: l_other_manager_warning boolean;
1973: l_no_managers_warning boolean;
1974: l_hourly_salaried_warning boolean;