APPS.GHR_MTO_INT dependencies on HR_ALL_POSITIONS_F

Line 2616: p_pos hr_all_positions_f%rowtype)

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

Line 2782: p_pos hr_all_positions_f%rowtype)

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

Line 4042: l_position_status hr_all_positions_f.status%type;

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

Line 4048: l_position_row hr_all_positions_f%rowtype;

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

Line 4054: l_position_rec hr_all_positions_f%rowtype;

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

Line 4060: hr_all_positions_f p

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

Line 4092: l_positions_row hr_all_positions_f%rowtype;

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