DBA Data[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on HR_ENTRY

Line 38: l_inp_value_id_table hr_entry.number_table;

34: p_jurisdiction_code in varchar2,
35: p_percentage_time in number,
36: p_mode in varchar2) is
37:
38: l_inp_value_id_table hr_entry.number_table;
39: l_scr_value_table hr_entry.varchar2_table;
40:
41: l_element_type_id number :=0;
42: l_inp_name varchar2(80) :=null;

Line 39: l_scr_value_table hr_entry.varchar2_table;

35: p_percentage_time in number,
36: p_mode in varchar2) is
37:
38: l_inp_value_id_table hr_entry.number_table;
39: l_scr_value_table hr_entry.varchar2_table;
40:
41: l_element_type_id number :=0;
42: l_inp_name varchar2(80) :=null;
43: l_inp_val_id number :=0;

Line 152: l_element_link_id := hr_entry_api.get_link(

148: hr_utility.set_location('pay_us_emp_dt_tax_rules.maintain_element_entry'
149: ,3);
150:
151: /* Get element link */
152: l_element_link_id := hr_entry_api.get_link(
153: P_assignment_id => p_assignment_id,
154: P_element_type_id => l_element_type_id,
155: P_session_date => p_effective_start_date);
156:

Line 186: hr_entry_api.insert_element_entry( P_effective_start_date => l_effective_start_date,

182: /* Create the vertex element entry */
183:
184: hr_utility.set_location('pay_us_emp_dt_tax_rules.maintain_element_entry' ,5);
185:
186: hr_entry_api.insert_element_entry( P_effective_start_date => l_effective_start_date,
187: P_effective_end_date => l_effective_end_date,
188: P_element_entry_id => l_element_entry_id,
189: P_assignment_id => p_assignment_id,
190: P_element_link_id => l_element_link_id,

Line 272: hr_entry_api.delete_element_entry(

268:
269: if p_mode in ('ZAP','DELETE_NEXT_CHANGE','FUTURE_CHANGE')
270: and l_delete_flag = 'Y' then
271:
272: hr_entry_api.delete_element_entry(
273: p_dt_delete_mode => l_mode,
274: p_session_date => p_session_date,
275: p_element_entry_id => l_element_entry_id);
276:

Line 279: hr_entry_api.update_element_entry(

275: p_element_entry_id => l_element_entry_id);
276:
277: elsif p_mode in ('CORRECTION','UPDATE', 'UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE','INSERT_OLD') then
278:
279: hr_entry_api.update_element_entry(
280: p_dt_update_mode => l_mode,
281: p_session_date => p_session_date,
282: p_element_entry_id => l_element_entry_id,
283: p_num_entry_values => 3,

Line 326: l_inp_value_id_table hr_entry.number_table;

322: p_session_date in date,
323: p_jurisdiction_code in varchar2,
324: p_mode in varchar2) is
325:
326: l_inp_value_id_table hr_entry.number_table;
327: l_scr_value_table hr_entry.varchar2_table;
328:
329: l_element_type_id number :=0;
330: l_inp_name varchar2(80) :=null;

Line 327: l_scr_value_table hr_entry.varchar2_table;

323: p_jurisdiction_code in varchar2,
324: p_mode in varchar2) is
325:
326: l_inp_value_id_table hr_entry.number_table;
327: l_scr_value_table hr_entry.varchar2_table;
328:
329: l_element_type_id number :=0;
330: l_inp_name varchar2(80) :=null;
331: l_inp_val_id number :=0;

Line 422: l_element_link_id := hr_entry_api.get_link(

418: hr_utility.set_location('pay_us_emp_dt_tax_rules.maintain_wc_ele_entry'
419: ,3);
420:
421: /* Get element link */
422: l_element_link_id := hr_entry_api.get_link(
423: P_assignment_id => p_assignment_id,
424: P_element_type_id => l_element_type_id,
425: P_session_date => p_effective_start_date);
426:

Line 457: hr_entry_api.insert_element_entry(

453: /* Insert the worker's compensation element entry */
454:
455: hr_utility.set_location(
456: 'pay_us_emp_dt_tax_rules.maintain_wc_ele_entry' ,5);
457: hr_entry_api.insert_element_entry(
458: P_effective_start_date => l_effective_start_date,
459: P_effective_end_date => l_effective_end_date,
460: P_element_entry_id => l_element_entry_id,
461: P_assignment_id => p_assignment_id,

Line 511: hr_entry_api.delete_element_entry(

507: default tax rules criteria was met till the end of time. So, we should
508: get records for the state, county and city for the same effective start
509: date */
510:
511: hr_entry_api.delete_element_entry(
512: p_dt_delete_mode => l_mode,
513: p_session_date => p_session_date,
514: p_element_entry_id => l_element_entry_id);
515:

Line 518: hr_entry_api.update_element_entry(

514: p_element_entry_id => l_element_entry_id);
515:
516: elsif p_mode in ('CORRECTION','UPDATE', 'UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE') then
517:
518: hr_entry_api.update_element_entry(
519: p_dt_update_mode => l_mode,
520: p_session_date => p_session_date,
521: p_element_entry_id => l_element_entry_id,
522: p_num_entry_values => 2,

Line 7041: l_inp_value_id_table hr_entry.number_table;

7037: p_new_start_date in date,
7038: p_new_end_date in date,
7039: p_mode in varchar2) is
7040:
7041: l_inp_value_id_table hr_entry.number_table;
7042: l_scr_value_table hr_entry.varchar2_table;
7043:
7044: l_element_type_id number :=0;
7045: l_inp_name varchar2(80) :=null;

Line 7042: l_scr_value_table hr_entry.varchar2_table;

7038: p_new_end_date in date,
7039: p_mode in varchar2) is
7040:
7041: l_inp_value_id_table hr_entry.number_table;
7042: l_scr_value_table hr_entry.varchar2_table;
7043:
7044: l_element_type_id number :=0;
7045: l_inp_name varchar2(80) :=null;
7046: l_inp_val_id number :=0;

Line 7136: l_element_link_id := hr_entry_api.get_link(

7132: ,3);
7133:
7134: /* Get element link */
7135: l_step := 2;
7136: l_element_link_id := hr_entry_api.get_link(
7137: P_assignment_id => p_assignment_id,
7138: P_element_type_id => l_element_type_id,
7139: P_session_date => p_session_date);
7140:

Line 7478: l_element_link_id := hr_entry_api.get_link(

7474: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ,2);
7475:
7476: /* Get element link */
7477: l_step := 2;
7478: l_element_link_id := hr_entry_api.get_link(
7479: P_assignment_id => p_assignment_id,
7480: P_element_type_id => l_element_type_id,
7481: P_session_date => p_session_date);
7482:

Line 7876: l_element_link_id := hr_entry_api.get_link(

7872: end if;
7873: close csr_tax_element;
7874:
7875: /* Get element link */
7876: l_element_link_id := hr_entry_api.get_link(
7877: P_assignment_id => p_assignment_id,
7878: P_element_type_id => l_element_type_id,
7879: P_session_date => p_session_date);
7880:

Line 8222: l_element_link_id := hr_entry_api.get_link(

8218: close csr_tax_element;
8219:
8220: hr_utility.set_location('pay_us_emp_dt_tax_rules.correct_percentage',4);
8221: /* Get element link */
8222: l_element_link_id := hr_entry_api.get_link(
8223: P_assignment_id => p_assignment_id,
8224: P_element_type_id => l_element_type_id,
8225: P_session_date => p_session_date);
8226:

Line 9204: l_element_link_id := hr_entry_api.get_link(

9200: close csr_tax_element;
9201:
9202: /* Get element link */
9203:
9204: l_element_link_id := hr_entry_api.get_link(
9205: P_assignment_id => p_assignment_id,
9206: P_element_type_id => l_element_type_id,
9207: P_session_date => p_session_date);
9208: