[Home] [Help]
63: Procedure correct_perana_row( p_perana_data in out nocopy per_person_analyses%rowtype);
64:
65: Procedure Correct_posnei_row (p_posnei_data in out nocopy per_position_extra_info%rowtype);
66:
67: Procedure Correct_posn_row (p_posn_data in out nocopy hr_all_positions_f%rowtype);
68:
69: Procedure Correct_asgnei_row (
70: p_asgnei_data in out nocopy per_assignment_extra_info%rowtype);
71:
1382: Procedure Cascade_posn (
1383: p_post_record in ghr_pa_history%rowtype) is
1384:
1385: l_hist_posn_data ghr_pa_history%rowtype;
1386: l_posn_data hr_all_positions_f%rowtype;
1387: l_result_code varchar2(30);
1388: l_proc varchar2(30):='Cascade_posn';
1389:
1390: Begin
1424: -- ---------------------------------------------------------------------------
1425: -- {Start Of Comments}
1426: --
1427: -- Description:
1428: -- This procedure cascades data changes in hr_all_positions_f core application table. If the
1429: -- current action made changes to hr_all_positions_f and there were changes following it, this procedure
1430: -- will correctly 'cascade' those changes to all following records. This procedure can
1431: -- be called in either 'retroactive' (p_post_record values will be cascaded) or 'cancel'
1432: -- (p_pre_record values will be cascaded) mode.
1425: -- {Start Of Comments}
1426: --
1427: -- Description:
1428: -- This procedure cascades data changes in hr_all_positions_f core application table. If the
1429: -- current action made changes to hr_all_positions_f and there were changes following it, this procedure
1430: -- will correctly 'cascade' those changes to all following records. This procedure can
1431: -- be called in either 'retroactive' (p_post_record values will be cascaded) or 'cancel'
1432: -- (p_pre_record values will be cascaded) mode.
1433: --
1467: p_hist_data_as_of_date in ghr_pa_history%rowtype
1468: ) is
1469:
1470: l_true_false ghr_history_cascade.condition_rg_type;
1471: l_posn_data hr_all_positions_f%rowtype;
1472: l_hist_posn_data ghr_pa_history%rowtype;
1473: l_stop Boolean;
1474: l_proc varchar2(30):='Cascade_posn';
1475:
1475:
1476: -- this cursor is meant to retrieve all following records in per_assignments_f table.
1477: Cursor c_posn( c_date_Effective in date, c_posn_id in number) is
1478: Select *
1479: from hr_all_positions_f
1480: where effective_start_date >= c_date_effective and
1481: position_id = c_posn_id;
1482:
1483: Begin
2519: --
2520: -- {End Of Comments}
2521: -- ---------------------------------------------------------------------------
2522: -- Procedure Correct_posn_row will update the Per_positions row in correct mode
2523: Procedure Correct_posn_row (p_posn_data in out nocopy hr_all_positions_f%rowtype) is
2524:
2525: -- this cursor gets the object_version_number from core table, so the core
2526: -- table can be updated.
2527: cursor c_posn_getovn( cp_position_id number
2527: cursor c_posn_getovn( cp_position_id number
2528: ,cp_eff_st_dt date
2529: ,cp_eff_end_dt date) is
2530: select object_version_number
2531: from hr_all_positions_f
2532: where position_id = cp_position_id
2533: and effective_start_date = cp_eff_st_dt;
2534:
2535: l_posn_data hr_all_positions_f%rowtype;
2531: from hr_all_positions_f
2532: where position_id = cp_position_id
2533: and effective_start_date = cp_eff_st_dt;
2534:
2535: l_posn_data hr_all_positions_f%rowtype;
2536: l_position_data_rec ghr_sf52_pos_update.position_data_rec_type;
2537: l_proc varchar2(30):='Correct_posn_Row';
2538: l_datetrack_mode varchar2(30):=hr_api.g_correction;
2539: l_date2 hr_all_positions_f.effective_start_date%type;
2535: l_posn_data hr_all_positions_f%rowtype;
2536: l_position_data_rec ghr_sf52_pos_update.position_data_rec_type;
2537: l_proc varchar2(30):='Correct_posn_Row';
2538: l_datetrack_mode varchar2(30):=hr_api.g_correction;
2539: l_date2 hr_all_positions_f.effective_start_date%type;
2540:
2541: Begin
2542: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2543: --Initialise Local Variables