DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_PKG dependencies on HR_ENTRY

Line 191: p_inp_val_id_tbl hr_entry.number_table,

187: p_end_date DATE,
188: p_assignment_id NUMBER,
189: p_element_type_id NUMBER,
190: p_num_ent_vals NUMBER,
191: p_inp_val_id_tbl hr_entry.number_table,
192: p_ent_val_tbl hr_entry.varchar2_table
193: ) IS
194: v_ele_link_id pay_element_links_f.element_link_id%TYPE;
195: v_new_ee_id pay_element_entries_f.element_entry_id%TYPE;

Line 192: p_ent_val_tbl hr_entry.varchar2_table

188: p_assignment_id NUMBER,
189: p_element_type_id NUMBER,
190: p_num_ent_vals NUMBER,
191: p_inp_val_id_tbl hr_entry.number_table,
192: p_ent_val_tbl hr_entry.varchar2_table
193: ) IS
194: v_ele_link_id pay_element_links_f.element_link_id%TYPE;
195: v_new_ee_id pay_element_entries_f.element_entry_id%TYPE;
196: v_start_date DATE;

Line 210: v_ele_link_id := hr_entry_api.get_link(p_assignment_id,p_element_type_id,p_start_date);

206: hr_utility.trace('The end date is '||to_char(p_end_date));
207:
208: v_start_date := p_start_date ;
209: /*v_end_date := p_end_date;*/
210: v_ele_link_id := hr_entry_api.get_link(p_assignment_id,p_element_type_id,p_start_date);
211:
212: /*to check the usage the insert api and see what are the dates to be passed to the api*/
213:
214: IF v_ele_link_id IS NOT NULL THEN

Line 216: hr_entry_api.insert_element_entry(

212: /*to check the usage the insert api and see what are the dates to be passed to the api*/
213:
214: IF v_ele_link_id IS NOT NULL THEN
215: hr_utility.trace('The element link id is link_id='||v_ele_link_id);
216: hr_entry_api.insert_element_entry(
217: p_effective_start_date => v_start_date,
218: p_effective_end_date => v_end_date,
219: p_element_entry_id => v_new_ee_id,
220: p_assignment_id => p_assignment_id,

Line 283: p_inp_val_id_tbl hr_entry.number_table,

279: p_end_date DATE,
280: p_assignment_id NUMBER,
281: p_element_type_id NUMBER,
282: p_num_ent_vals NUMBER,
283: p_inp_val_id_tbl hr_entry.number_table,
284: p_ent_val_tbl hr_entry.varchar2_table
285: ) IS
286: v_original_element pay_element_types_f.element_type_id%TYPE;
287: v_exists BOOLEAN;

Line 284: p_ent_val_tbl hr_entry.varchar2_table

280: p_assignment_id NUMBER,
281: p_element_type_id NUMBER,
282: p_num_ent_vals NUMBER,
283: p_inp_val_id_tbl hr_entry.number_table,
284: p_ent_val_tbl hr_entry.varchar2_table
285: ) IS
286: v_original_element pay_element_types_f.element_type_id%TYPE;
287: v_exists BOOLEAN;
288: lv_procedure_name VARCHAR2(100) := '.handle_multi_entry_case';

Line 318: hr_entry_api.delete_element_entry(

314: FOR ele_ent IN csr_orig_ent_del (p_assignment_id,v_original_element,p_start_date,p_end_date) LOOP
315:
316: hr_utility.trace('Deleting the element entry elem_ent_id='||ele_ent.element_entry_id);
317:
318: hr_entry_api.delete_element_entry(
319: p_dt_delete_mode => hr_api.g_zap,
320: p_session_date => ele_ent.effective_end_date,
321: p_element_entry_id => ele_ent.element_entry_id
322: );

Line 383: hr_entry_api.delete_element_entry(

379:
380: FOR ele_ent IN csr_retro_entries(p_assignment_id,p_start_date,p_end_date) LOOP
381:
382: hr_utility.trace('Retro entry to be deleted is ee_id='||ele_ent.element_entry_id);
383: hr_entry_api.delete_element_entry(
384: p_dt_delete_mode => hr_api.g_zap,
385: p_session_date => ele_ent.effective_end_date,
386: p_element_entry_id => ele_ent.element_entry_id
387: );

Line 430: hr_entry_api.delete_element_entry(

426:
427: FOR ele_ent IN csr_excl_entries(l_elemset_id,p_start_date,p_end_date) LOOP
428:
429: hr_utility.trace('Excluded entry to be deleted is ee_id='||ele_ent.element_entry_id);
430: hr_entry_api.delete_element_entry(
431: p_dt_delete_mode => hr_api.g_zap,
432: p_session_date => ele_ent.effective_end_date,
433: p_element_entry_id => ele_ent.element_entry_id
434: );

Line 471: hr_entry_api.delete_element_entry(

467:
468: FOR ele_ent IN csr_adj_add_entries(p_assignment_id,p_element_type_id,p_start_date,p_end_date) LOOP
469:
470: hr_utility.trace('Adjustment entry to be deleted is ee_id='||ele_ent.element_entry_id);
471: hr_entry_api.delete_element_entry(
472: p_dt_delete_mode => hr_api.g_zap,
473: p_session_date => ele_ent.effective_end_date,
474: p_element_entry_id => ele_ent.element_entry_id
475: );

Line 498: scr_valuetbl hr_entry.varchar2_table;

494: v_value VARCHAR2(40);
495: v_num_inp_val_mod NUMBER :=0; /*variable used to identify the number of input values modified*/
496: v_inp_val_id VARCHAR2(40);
497: v_exists BOOLEAN;
498: scr_valuetbl hr_entry.varchar2_table;
499: inp_value_id_tbl hr_entry.number_table;
500: v_legislation per_business_groups_perf.legislation_code%TYPE;
501:
502: v_sim_region3 VARCHAR2(30);

Line 499: inp_value_id_tbl hr_entry.number_table;

495: v_num_inp_val_mod NUMBER :=0; /*variable used to identify the number of input values modified*/
496: v_inp_val_id VARCHAR2(40);
497: v_exists BOOLEAN;
498: scr_valuetbl hr_entry.varchar2_table;
499: inp_value_id_tbl hr_entry.number_table;
500: v_legislation per_business_groups_perf.legislation_code%TYPE;
501:
502: v_sim_region3 VARCHAR2(30);
503: v_sim_region4 VARCHAR2(30);

Line 639: hr_entry_api.update_element_entry(

635: IF(v_exists) THEN
636: /*For all the entries existing in the current period will update each datetracked row with the correspodning simulated value*/
637: /*have to check if there are any adjustment entries present for the same period */
638: FOR ele_ent IN csr_element_entries(p_assignment_id,ele_type.element_type_id,p_period_start_date,p_period_end_date) LOOP
639: hr_entry_api.update_element_entry(
640: p_dt_update_mode => hr_api.g_correction,
641: p_session_date => ele_ent.effective_end_date,
642: p_element_entry_id => ele_ent.element_entry_id,
643: p_num_entry_values => v_num_inp_val_mod,