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.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_ELEMENT_ENTRY_VALUES

Line 349: DELETE FROM hr_h2pi_element_entry_values

345: DELETE FROM hr_h2pi_element_entries
346: WHERE client_id = p_from_client_id
347: AND status = 'C';
348:
349: DELETE FROM hr_h2pi_element_entry_values
350: WHERE client_id = p_from_client_id
351: AND status = 'C';
352:
353:

Line 3392: FROM hr_h2pi_element_entry_values eev

3388:
3389: CURSOR csr_ud_element_entry_value (p_ele_id NUMBER,
3390: p_esd DATE) IS
3391: SELECT *
3392: FROM hr_h2pi_element_entry_values eev
3393: WHERE eev.element_entry_id = p_ele_id
3394: AND eev.screen_entry_value IS NOT NULL
3395: AND eev.client_id = p_from_client_id
3396: AND p_esd BETWEEN eev.effective_start_date

Line 3420: TYPE eev_array IS VARRAY(15) OF hr_h2pi_element_entry_values.screen_entry_value%TYPE;

3416:
3417: l_proc VARCHAR2(72) := g_package||'upload_element_entry';
3418:
3419:
3420: TYPE eev_array IS VARRAY(15) OF hr_h2pi_element_entry_values.screen_entry_value%TYPE;
3421: TYPE iv_array IS VARRAY(15) OF hr_h2pi_element_entry_values.input_value_id%TYPE;
3422:
3423: v_ud_ele hr_h2pi_element_entries%ROWTYPE;
3424: a_ud_sev eev_array := eev_array(NULL,NULL,NULL,NULL,NULL,NULL,NULL,

Line 3421: TYPE iv_array IS VARRAY(15) OF hr_h2pi_element_entry_values.input_value_id%TYPE;

3417: l_proc VARCHAR2(72) := g_package||'upload_element_entry';
3418:
3419:
3420: TYPE eev_array IS VARRAY(15) OF hr_h2pi_element_entry_values.screen_entry_value%TYPE;
3421: TYPE iv_array IS VARRAY(15) OF hr_h2pi_element_entry_values.input_value_id%TYPE;
3422:
3423: v_ud_ele hr_h2pi_element_entries%ROWTYPE;
3424: a_ud_sev eev_array := eev_array(NULL,NULL,NULL,NULL,NULL,NULL,NULL,
3425: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

Line 3518: p_table_name => 'HR_H2PI_ELEMENT_ENTRY_VALUES',

3514: ROLLBACK;
3515: hr_utility.set_location(l_proc, 35);
3516: hr_h2pi_error.data_error
3517: (p_from_id => a_input_value_id(l_index),
3518: p_table_name => 'HR_H2PI_ELEMENT_ENTRY_VALUES',
3519: p_message_level => 'FATAL',
3520: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
3521: COMMIT;
3522: RAISE MAPPING_ID_INVALID;

Line 3896: UPDATE hr_h2pi_element_entry_values eev

3892: AND ele.client_id = p_from_client_id
3893: AND ele.effective_start_date = v_ud_ele.effective_start_date
3894: AND ele.effective_end_date = v_ud_ele.effective_end_date;
3895:
3896: UPDATE hr_h2pi_element_entry_values eev
3897: SET status = 'C'
3898: WHERE eev.element_entry_id = v_ud_ele.element_entry_id
3899: AND eev.client_id = p_from_client_id
3900: AND eev.effective_start_date = v_ud_ele.effective_start_date

Line 4968: FROM hr_h2pi_element_entry_values_v to_eev,

4964: p_county VARCHAR2) IS
4965: SELECT SUBSTR(fr_eev.screen_entry_value, 8, 4) city_code,
4966: SUM (fr_eev2.screen_entry_value) percentage,
4967: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
4968: FROM hr_h2pi_element_entry_values_v to_eev,
4969: hr_h2pi_element_entry_values_v to_eev2,
4970: hr_h2pi_element_entries_v to_ele,
4971: hr_h2pi_element_entry_values fr_eev,
4972: hr_h2pi_element_entry_values fr_eev2,

Line 4969: hr_h2pi_element_entry_values_v to_eev2,

4965: SELECT SUBSTR(fr_eev.screen_entry_value, 8, 4) city_code,
4966: SUM (fr_eev2.screen_entry_value) percentage,
4967: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
4968: FROM hr_h2pi_element_entry_values_v to_eev,
4969: hr_h2pi_element_entry_values_v to_eev2,
4970: hr_h2pi_element_entries_v to_ele,
4971: hr_h2pi_element_entry_values fr_eev,
4972: hr_h2pi_element_entry_values fr_eev2,
4973: hr_h2pi_element_entries fr_ele

Line 4971: hr_h2pi_element_entry_values fr_eev,

4967: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
4968: FROM hr_h2pi_element_entry_values_v to_eev,
4969: hr_h2pi_element_entry_values_v to_eev2,
4970: hr_h2pi_element_entries_v to_ele,
4971: hr_h2pi_element_entry_values fr_eev,
4972: hr_h2pi_element_entry_values fr_eev2,
4973: hr_h2pi_element_entries fr_ele
4974: WHERE to_ele.element_entry_id = to_eev.element_entry_id
4975: AND to_eev.input_value_id = p_ed_iv_id1

Line 4972: hr_h2pi_element_entry_values fr_eev2,

4968: FROM hr_h2pi_element_entry_values_v to_eev,
4969: hr_h2pi_element_entry_values_v to_eev2,
4970: hr_h2pi_element_entries_v to_ele,
4971: hr_h2pi_element_entry_values fr_eev,
4972: hr_h2pi_element_entry_values fr_eev2,
4973: hr_h2pi_element_entries fr_ele
4974: WHERE to_ele.element_entry_id = to_eev.element_entry_id
4975: AND to_eev.input_value_id = p_ed_iv_id1
4976: AND to_eev2.input_value_id = p_ed_iv_id2

Line 5023: FROM hr_h2pi_element_entry_values_v to_eev,

5019: p_state VARCHAR2) IS
5020: SELECT SUBSTR(fr_eev.screen_entry_value,4,3) county_code,
5021: SUM (fr_eev2.screen_entry_value) percentage,
5022: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5023: FROM hr_h2pi_element_entry_values_v to_eev,
5024: hr_h2pi_element_entry_values_v to_eev2,
5025: hr_h2pi_element_entries_v to_ele,
5026: hr_h2pi_element_entry_values fr_eev,
5027: hr_h2pi_element_entry_values fr_eev2,

Line 5024: hr_h2pi_element_entry_values_v to_eev2,

5020: SELECT SUBSTR(fr_eev.screen_entry_value,4,3) county_code,
5021: SUM (fr_eev2.screen_entry_value) percentage,
5022: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5023: FROM hr_h2pi_element_entry_values_v to_eev,
5024: hr_h2pi_element_entry_values_v to_eev2,
5025: hr_h2pi_element_entries_v to_ele,
5026: hr_h2pi_element_entry_values fr_eev,
5027: hr_h2pi_element_entry_values fr_eev2,
5028: hr_h2pi_element_entries fr_ele

Line 5026: hr_h2pi_element_entry_values fr_eev,

5022: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5023: FROM hr_h2pi_element_entry_values_v to_eev,
5024: hr_h2pi_element_entry_values_v to_eev2,
5025: hr_h2pi_element_entries_v to_ele,
5026: hr_h2pi_element_entry_values fr_eev,
5027: hr_h2pi_element_entry_values fr_eev2,
5028: hr_h2pi_element_entries fr_ele
5029: WHERE to_ele.element_entry_id = to_eev.element_entry_id
5030: AND to_eev.input_value_id = p_ed_iv_id1

Line 5027: hr_h2pi_element_entry_values fr_eev2,

5023: FROM hr_h2pi_element_entry_values_v to_eev,
5024: hr_h2pi_element_entry_values_v to_eev2,
5025: hr_h2pi_element_entries_v to_ele,
5026: hr_h2pi_element_entry_values fr_eev,
5027: hr_h2pi_element_entry_values fr_eev2,
5028: hr_h2pi_element_entries fr_ele
5029: WHERE to_ele.element_entry_id = to_eev.element_entry_id
5030: AND to_eev.input_value_id = p_ed_iv_id1
5031: AND to_eev2.input_value_id = p_ed_iv_id2

Line 5076: FROM hr_h2pi_element_entry_values_v to_eev,

5072: p_ed_asg_id NUMBER) IS
5073: SELECT SUBSTR(fr_eev.screen_entry_value,1,2) state_code,
5074: SUM (fr_eev2.screen_entry_value) percentage,
5075: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5076: FROM hr_h2pi_element_entry_values_v to_eev,
5077: hr_h2pi_element_entry_values_v to_eev2,
5078: hr_h2pi_element_entries_v to_ele,
5079: hr_h2pi_element_entry_values fr_eev,
5080: hr_h2pi_element_entry_values fr_eev2,

Line 5077: hr_h2pi_element_entry_values_v to_eev2,

5073: SELECT SUBSTR(fr_eev.screen_entry_value,1,2) state_code,
5074: SUM (fr_eev2.screen_entry_value) percentage,
5075: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5076: FROM hr_h2pi_element_entry_values_v to_eev,
5077: hr_h2pi_element_entry_values_v to_eev2,
5078: hr_h2pi_element_entries_v to_ele,
5079: hr_h2pi_element_entry_values fr_eev,
5080: hr_h2pi_element_entry_values fr_eev2,
5081: hr_h2pi_element_entries fr_ele

Line 5079: hr_h2pi_element_entry_values fr_eev,

5075: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5076: FROM hr_h2pi_element_entry_values_v to_eev,
5077: hr_h2pi_element_entry_values_v to_eev2,
5078: hr_h2pi_element_entries_v to_ele,
5079: hr_h2pi_element_entry_values fr_eev,
5080: hr_h2pi_element_entry_values fr_eev2,
5081: hr_h2pi_element_entries fr_ele
5082: WHERE to_ele.element_entry_id = to_eev.element_entry_id
5083: AND to_eev.input_value_id = p_ed_iv_id1

Line 5080: hr_h2pi_element_entry_values fr_eev2,

5076: FROM hr_h2pi_element_entry_values_v to_eev,
5077: hr_h2pi_element_entry_values_v to_eev2,
5078: hr_h2pi_element_entries_v to_ele,
5079: hr_h2pi_element_entry_values fr_eev,
5080: hr_h2pi_element_entry_values fr_eev2,
5081: hr_h2pi_element_entries fr_ele
5082: WHERE to_ele.element_entry_id = to_eev.element_entry_id
5083: AND to_eev.input_value_id = p_ed_iv_id1
5084: AND to_eev2.input_value_id = p_ed_iv_id2

Line 5272: UPDATE hr_h2pi_element_entry_values eev

5268:
5269: END LOOP;
5270:
5271: hr_utility.set_location(l_proc, 125);
5272: UPDATE hr_h2pi_element_entry_values eev
5273: SET eev.status = 'C'
5274: WHERE eev.element_entry_id IN (SELECT ee.element_entry_id
5275: FROM hr_h2pi_element_entries ee
5276: WHERE ee.person_id = p_person_id