APPS.GHR_MTO_INT dependencies on HR_ALL_POSITIONS_F

Line 2615: p_pos hr_all_positions_f%rowtype)

2611:
2612: procedure insert_position(p_transfer_name varchar2,
2613: p_person_id number,
2614: p_effective_date date,
2615: p_pos hr_all_positions_f%rowtype)
2616: is
2617:
2618: l_proc varchar2(72) := g_package||'insert_position';
2619: l_table_name constant varchar2(30) := 'PER_POSITIONS';

Line 2781: p_pos hr_all_positions_f%rowtype)

2777:
2778: procedure update_position(p_transfer_name varchar2,
2779: p_person_id number,
2780: p_effective_date date,
2781: p_pos hr_all_positions_f%rowtype)
2782: is
2783:
2784: l_proc varchar2(72) := g_package||'update_position';
2785: l_x varchar2(1);

Line 4041: l_position_status hr_all_positions_f.status%type;

4037:
4038: l_adj_basic_pay number;
4039: l_multi_error_flag boolean;
4040:
4041: l_position_status hr_all_positions_f.status%type;
4042: l_rc varchar2(30);
4043: l_inter_bg_transfer varchar2(1);
4044:
4045: ---------------

Line 4047: l_position_row hr_all_positions_f%rowtype;

4043: l_inter_bg_transfer varchar2(1);
4044:
4045: ---------------
4046: l_people_row per_all_people_f%rowtype;
4047: l_position_row hr_all_positions_f%rowtype;
4048: l_people_ei_row per_people_extra_info%rowtype;
4049: l_element ghr_mt_element_entries_v%rowtype;
4050: l_misc ghr_mt_misc_v%rowtype;
4051:

Line 4053: l_position_rec hr_all_positions_f%rowtype;

4049: l_element ghr_mt_element_entries_v%rowtype;
4050: l_misc ghr_mt_misc_v%rowtype;
4051:
4052: l_pos_defs per_position_definitions%rowtype;
4053: l_position_rec hr_all_positions_f%rowtype;
4054: l_result_code varchar2(10);
4055: /*
4056: cursor cur_pos_definitions(p_position_id number) is
4057: select pd.*

Line 4059: hr_all_positions_f p

4055: /*
4056: cursor cur_pos_definitions(p_position_id number) is
4057: select pd.*
4058: from per_position_definitions pd,
4059: hr_all_positions_f p
4060: where p.position_id = p_position_id
4061: and p.position_definition_id = pd.position_definition_id
4062: and trunc(l_effdate) between p.effective_start_date and
4063: nvl(effective_end_date,l_effdate+1);

Line 4091: l_positions_row hr_all_positions_f%rowtype;

4087: and person_id = p_person_id
4088: and trunc(l_effdate) between effective_start_date
4089: and effective_end_date;
4090:
4091: l_positions_row hr_all_positions_f%rowtype;
4092: l_position_ei_row per_position_extra_info%rowtype;
4093:
4094: l_contact_type varchar2(30);
4095: l_contact_name varchar2(240);