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.BEN_CREATE_PTNL_LER_SS dependencies on PER_ALL_PEOPLE_F

Line 175: cursor csr_person is select person_id from per_all_people_f where person_id = p_person_id;

171: ,p_error_message out nocopy long
172: ) IS
173:
174: --declare a cursor to check if the person actually exists in the database
175: cursor csr_person is select person_id from per_all_people_f where person_id = p_person_id;
176:
177:
178: l_transaction_table hr_transaction_ss.transaction_table;
179: l_count INTEGER := 0;

Line 185: l_original_person_id per_all_people_f.person_id%type;

181: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
182: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;
183:
184: -- variable for the create person call
185: l_original_person_id per_all_people_f.person_id%type;
186: l_review_item_name varchar2(50);
187: l_result varchar2(100) default null;
188: l_person_id per_all_people_f.person_id%type := p_person_id;
189: l_object_version_number per_all_people_f.object_version_number%type ;

Line 188: l_person_id per_all_people_f.person_id%type := p_person_id;

184: -- variable for the create person call
185: l_original_person_id per_all_people_f.person_id%type;
186: l_review_item_name varchar2(50);
187: l_result varchar2(100) default null;
188: l_person_id per_all_people_f.person_id%type := p_person_id;
189: l_object_version_number per_all_people_f.object_version_number%type ;
190: l_effective_start_date date;
191: l_effective_end_date date ;
192: l_full_name per_all_people_f.full_name%type;

Line 189: l_object_version_number per_all_people_f.object_version_number%type ;

185: l_original_person_id per_all_people_f.person_id%type;
186: l_review_item_name varchar2(50);
187: l_result varchar2(100) default null;
188: l_person_id per_all_people_f.person_id%type := p_person_id;
189: l_object_version_number per_all_people_f.object_version_number%type ;
190: l_effective_start_date date;
191: l_effective_end_date date ;
192: l_full_name per_all_people_f.full_name%type;
193: l_comment_id number;

Line 192: l_full_name per_all_people_f.full_name%type;

188: l_person_id per_all_people_f.person_id%type := p_person_id;
189: l_object_version_number per_all_people_f.object_version_number%type ;
190: l_effective_start_date date;
191: l_effective_end_date date ;
192: l_full_name per_all_people_f.full_name%type;
193: l_comment_id number;
194: l_name_combination_warning boolean ;
195: l_orig_hire_warning boolean ;
196: l_proc varchar2(72) := g_package||'CREATE_PTNL_LER_FOR_PER';