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_ENTRIES

Line 215: INSERT INTO hr_h2pi_element_entries

211: id_flex_num,summary_flag,enabled_flag
212: HAVING MAX(effective_end_date) <> g_eot;
213:
214: hr_utility.set_location(l_proc, 60);
215: INSERT INTO hr_h2pi_element_entries
216: (element_entry_id,
217: effective_start_date,
218: effective_end_date,
219: last_upd_date,

Line 238: FROM hr_h2pi_element_entries

234: -1,
235: -1,
236: 'x',
237: 'x'
238: FROM hr_h2pi_element_entries
239: WHERE client_id = p_from_client_id
240: AND creator_type <> 'UT'
241: GROUP BY person_id, element_entry_id,business_group_id
242: HAVING MAX(effective_end_date) <> g_eot;

Line 345: DELETE FROM hr_h2pi_element_entries

341: DELETE FROM hr_h2pi_element_names
342: WHERE client_id = p_from_client_id
343: AND status = 'C';
344:
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

Line 426: FROM hr_h2pi_element_entries

422: WHERE (status IS NULL OR status <> 'C')
423: AND client_id = p_bg_id
424: UNION
425: SELECT DISTINCT person_id
426: FROM hr_h2pi_element_entries
427: WHERE (status IS NULL OR status <> 'C')
428: AND client_id = p_bg_id
429: UNION
430: SELECT DISTINCT person_id

Line 539: FROM HR_H2PI_ELEMENT_ENTRIES

535: effective_start_date eff_date,
536: 9 ord,
537: 'upload_element_entry' fn_name,
538: DECODE(last_upd_date, g_eot, 1, 2) sub_order
539: FROM HR_H2PI_ELEMENT_ENTRIES
540: WHERE (status IS NULL OR status <> 'C')
541: AND creator_type <> 'UT'
542: AND person_id = p_per_id
543: AND client_id = p_from_client_id

Line 3384: FROM hr_h2pi_element_entries ele

3380:
3381: CURSOR csr_ud_element_entry (p_ele_id NUMBER,
3382: p_esd DATE) IS
3383: SELECT *
3384: FROM hr_h2pi_element_entries ele
3385: WHERE ele.element_entry_id = p_ele_id
3386: AND ele.client_id = p_from_client_id
3387: AND ele.effective_start_date = p_esd;
3388:

Line 3402: FROM hr_h2pi_element_entries_v ele

3398:
3399: CURSOR csr_ed_element_entry (p_ele_id NUMBER,
3400: p_esd DATE) IS
3401: SELECT *
3402: FROM hr_h2pi_element_entries_v ele
3403: WHERE ele.element_entry_id = p_ele_id
3404: AND p_esd BETWEEN ele.effective_start_date
3405: AND ele.effective_end_date;
3406:

Line 3423: v_ud_ele hr_h2pi_element_entries%ROWTYPE;

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);
3426: v_ed_ele hr_h2pi_element_entries_v%ROWTYPE;
3427:

Line 3426: v_ed_ele hr_h2pi_element_entries_v%ROWTYPE;

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);
3426: v_ed_ele hr_h2pi_element_entries_v%ROWTYPE;
3427:
3428: l_index NUMBER;
3429: a_input_value_id iv_array := iv_array(NULL,NULL,NULL,NULL,NULL,NULL,NULL,
3430: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

Line 3707: p_table_name => 'HR_H2PI_ELEMENT_ENTRIES',

3703: ROLLBACK;
3704: hr_utility.set_location(l_proc, 90);
3705: hr_h2pi_error.data_error
3706: (p_from_id => l_element_entry_id,
3707: p_table_name => 'HR_H2PI_ELEMENT_ENTRIES',
3708: p_message_level => 'FATAL',
3709: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
3710: COMMIT;
3711: RAISE MAPPING_ID_INVALID;

Line 3889: UPDATE hr_h2pi_element_entries ele

3885: END IF;
3886: END IF;
3887:
3888: hr_utility.set_location(l_proc, 170);
3889: UPDATE hr_h2pi_element_entries ele
3890: SET status = 'C'
3891: WHERE ele.element_entry_id = v_ud_ele.element_entry_id
3892: AND ele.client_id = p_from_client_id
3893: AND ele.effective_start_date = v_ud_ele.effective_start_date

Line 3914: p_table_name => 'HR_H2PI_ELEMENT_ENTRIES',

3910: hr_utility.set_location(l_proc, 190);
3911: l_encoded_message := fnd_message.get_encoded;
3912: hr_h2pi_error.data_error
3913: (p_from_id => v_ud_ele.element_entry_id,
3914: p_table_name => 'HR_H2PI_ELEMENT_ENTRIES',
3915: p_message_level => 'FATAL',
3916: p_message_text => l_encoded_message);
3917: COMMIT;
3918: RAISE;

Line 4970: hr_h2pi_element_entries_v to_ele,

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
4974: WHERE to_ele.element_entry_id = to_eev.element_entry_id

Line 4973: hr_h2pi_element_entries fr_ele

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
4977: AND fr_eev.input_value_id = p_ud_iv_id1

Line 4982: from hr_h2pi_element_entries_v to_ele_t

4978: AND fr_eev.client_id = p_from_client_id --
4979: AND fr_eev2.input_value_id = p_ud_iv_id2
4980: AND fr_eev2.client_id = p_from_client_id --
4981: AND to_ele.effective_start_date = (SELECT MAX(to_ele_t.effective_start_date)
4982: from hr_h2pi_element_entries_v to_ele_t
4983: WHERE to_ele_t.element_entry_id = to_ele.element_entry_id)
4984: AND to_eev.effective_start_date BETWEEN to_ele.effective_start_date
4985: AND to_ele.effective_end_date
4986: AND to_ele.element_entry_id = to_eev2.element_entry_id

Line 4993: from hr_h2pi_element_entries fr_ele_t

4989: AND to_ele.creator_type = 'UT'
4990: AND fr_ele.element_entry_id = fr_eev.element_entry_id
4991: AND fr_ele.client_id = p_from_client_id --
4992: AND fr_ele.effective_start_date = (SELECT MAX(fr_ele_t.effective_start_date)
4993: from hr_h2pi_element_entries fr_ele_t
4994: WHERE fr_ele_t.element_entry_id = fr_ele.element_entry_id
4995: AND fr_ele_t.client_id = p_from_client_id)
4996: AND fr_eev.effective_start_date BETWEEN fr_ele.effective_start_date
4997: AND fr_ele.effective_end_date

Line 5025: hr_h2pi_element_entries_v to_ele,

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
5029: WHERE to_ele.element_entry_id = to_eev.element_entry_id

Line 5028: hr_h2pi_element_entries fr_ele

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
5032: AND fr_eev.input_value_id = p_ud_iv_id1

Line 5037: from hr_h2pi_element_entries_v to_ele_t

5033: AND fr_eev.client_id = p_from_client_id --
5034: AND fr_eev2.input_value_id = p_ud_iv_id2
5035: AND fr_eev2.client_id = p_from_client_id --
5036: AND to_ele.effective_start_date = (SELECT MAX(to_ele_t.effective_start_date)
5037: from hr_h2pi_element_entries_v to_ele_t
5038: WHERE to_ele_t.element_entry_id = to_ele.element_entry_id)
5039: AND to_eev.effective_start_date BETWEEN to_ele.effective_start_date
5040: AND to_ele.effective_end_date
5041: AND to_ele.element_entry_id = to_eev2.element_entry_id

Line 5048: from hr_h2pi_element_entries fr_ele_t

5044: AND to_ele.creator_type = 'UT'
5045: AND fr_ele.element_entry_id = fr_eev.element_entry_id
5046: AND fr_ele.client_id = p_from_client_id --
5047: AND fr_ele.effective_start_date = (SELECT MAX(fr_ele_t.effective_start_date)
5048: from hr_h2pi_element_entries fr_ele_t
5049: WHERE fr_ele_t.element_entry_id = fr_ele.element_entry_id
5050: AND fr_ele_t.client_id = p_from_client_id)
5051: AND fr_eev.effective_start_date BETWEEN fr_ele.effective_start_date
5052: AND fr_ele.effective_end_date

Line 5078: hr_h2pi_element_entries_v to_ele,

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
5082: WHERE to_ele.element_entry_id = to_eev.element_entry_id

Line 5081: hr_h2pi_element_entries fr_ele

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
5085: AND fr_eev.input_value_id = p_ud_iv_id1

Line 5090: from hr_h2pi_element_entries_v to_ele_t

5086: AND fr_eev.client_id = p_from_client_id --
5087: AND fr_eev2.input_value_id = p_ud_iv_id2
5088: AND fr_eev2.client_id = p_from_client_id --
5089: AND to_ele.effective_start_date = (SELECT MAX(to_ele_t.effective_start_date)
5090: from hr_h2pi_element_entries_v to_ele_t
5091: WHERE to_ele_t.element_entry_id = to_ele.element_entry_id)
5092: AND to_eev.effective_start_date BETWEEN to_ele.effective_start_date
5093: AND to_ele.effective_end_date
5094: AND to_ele.element_entry_id = to_eev2.element_entry_id

Line 5101: from hr_h2pi_element_entries fr_ele_t

5097: AND to_ele.creator_type = 'UT'
5098: AND fr_ele.element_entry_id = fr_eev.element_entry_id
5099: AND fr_ele.client_id = p_from_client_id --
5100: AND fr_ele.effective_start_date = (SELECT MAX(fr_ele_t.effective_start_date)
5101: from hr_h2pi_element_entries fr_ele_t
5102: WHERE fr_ele_t.element_entry_id = fr_ele.element_entry_id
5103: AND fr_ele_t.client_id = p_from_client_id)
5104: AND fr_eev.effective_start_date BETWEEN fr_ele.effective_start_date
5105: AND fr_ele.effective_end_date

Line 5166: FROM hr_h2pi_element_entries

5162: p_report_error => TRUE);
5163:
5164: SELECT MAX(effective_end_date)
5165: INTO l_effective_date
5166: FROM hr_h2pi_element_entries
5167: WHERE assignment_id = l_ud_assignment_id;
5168:
5169: OPEN csr_ed_input_values;
5170: FETCH csr_ed_input_values INTO l_input_value_id1,

Line 5275: FROM hr_h2pi_element_entries ee

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
5277: AND ee.creator_type = 'UT'
5278: AND ee.client_id = p_from_client_id);
5279:

Line 5280: UPDATE hr_h2pi_element_entries ee

5276: WHERE ee.person_id = p_person_id
5277: AND ee.creator_type = 'UT'
5278: AND ee.client_id = p_from_client_id);
5279:
5280: UPDATE hr_h2pi_element_entries ee
5281: SET ee.status = 'C'
5282: WHERE ee.person_id = p_person_id
5283: AND ee.creator_type = 'UT'
5284: AND ee.client_id = p_from_client_id;