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_ASSIGNMENTS

Line 81: INSERT INTO hr_h2pi_assignments

77:
78: BEGIN
79: hr_utility.set_location('Entering:'|| l_proc, 10);
80:
81: INSERT INTO hr_h2pi_assignments
82: (assignment_id,
83: effective_start_date,
84: effective_end_date,
85: last_upd_date,

Line 102: FROM hr_h2pi_assignments asg2

98: -1,
99: asg.primary_flag
100: FROM (SELECT asg2.assignment_id,
101: MAX(asg2.effective_end_date) end_date
102: FROM hr_h2pi_assignments asg2
103: WHERE asg2.client_id = p_from_client_id
104: GROUP BY asg2.person_id, asg2.assignment_id
105: HAVING MAX(asg2.effective_end_date) <> g_eot) asg1,
106: hr_h2pi_assignments asg

Line 106: hr_h2pi_assignments asg

102: FROM hr_h2pi_assignments asg2
103: WHERE asg2.client_id = p_from_client_id
104: GROUP BY asg2.person_id, asg2.assignment_id
105: HAVING MAX(asg2.effective_end_date) <> g_eot) asg1,
106: hr_h2pi_assignments asg
107: WHERE asg.assignment_id = asg1.assignment_id
108: AND asg.client_id = p_from_client_id
109: AND asg.effective_end_date = asg1.end_date
110: AND asg.primary_flag = 'Y';

Line 111: INSERT INTO hr_h2pi_assignments

107: WHERE asg.assignment_id = asg1.assignment_id
108: AND asg.client_id = p_from_client_id
109: AND asg.effective_end_date = asg1.end_date
110: AND asg.primary_flag = 'Y';
111: INSERT INTO hr_h2pi_assignments
112: (assignment_id,
113: effective_start_date,
114: effective_end_date,
115: last_upd_date,

Line 132: FROM hr_h2pi_assignments asg2

128: -1,
129: asg.primary_flag
130: FROM (SELECT asg2.assignment_id,
131: MAX(asg2.effective_end_date) end_date
132: FROM hr_h2pi_assignments asg2
133: WHERE asg2.client_id = p_from_client_id
134: GROUP BY asg2.person_id, asg2.assignment_id
135: HAVING MAX(asg2.effective_end_date) <> g_eot) asg1,
136: hr_h2pi_assignments asg

Line 136: hr_h2pi_assignments asg

132: FROM hr_h2pi_assignments asg2
133: WHERE asg2.client_id = p_from_client_id
134: GROUP BY asg2.person_id, asg2.assignment_id
135: HAVING MAX(asg2.effective_end_date) <> g_eot) asg1,
136: hr_h2pi_assignments asg
137: WHERE asg.assignment_id = asg1.assignment_id
138: AND asg.client_id = p_from_client_id
139: AND asg.effective_end_date = asg1.end_date
140: AND asg.primary_flag = 'N'

Line 144: FROM hr_h2pi_assignments sasg2

140: AND asg.primary_flag = 'N'
141: AND NOT EXISTS (SELECT 1
142: FROM (SELECT sasg2.assignment_id,
143: MAX(sasg2.effective_end_date) end_date
144: FROM hr_h2pi_assignments sasg2
145: WHERE sasg2.client_id = p_from_client_id
146: GROUP BY sasg2.person_id, sasg2.assignment_id
147: HAVING MAX(sasg2.effective_end_date) = g_eot) sasg1,
148: hr_h2pi_assignments sasg

Line 148: hr_h2pi_assignments sasg

144: FROM hr_h2pi_assignments sasg2
145: WHERE sasg2.client_id = p_from_client_id
146: GROUP BY sasg2.person_id, sasg2.assignment_id
147: HAVING MAX(sasg2.effective_end_date) = g_eot) sasg1,
148: hr_h2pi_assignments sasg
149: WHERE sasg.assignment_id = sasg1.assignment_id
150: AND sasg.client_id = p_from_client_id
151: AND sasg.effective_end_date = sasg1.end_date
152: AND sasg.last_upd_date = g_eot

Line 261: DELETE FROM hr_h2pi_assignments

257: DELETE FROM hr_h2pi_addresses
258: WHERE client_id = p_from_client_id
259: AND status = 'C';
260:
261: DELETE FROM hr_h2pi_assignments
262: WHERE client_id = p_from_client_id
263: AND status = 'C';
264:
265: DELETE FROM hr_h2pi_periods_of_service

Line 401: FROM hr_h2pi_assignments

397: WHERE (status IS NULL OR status <> 'C')
398: AND client_id = p_bg_id
399: UNION
400: SELECT DISTINCT person_id
401: FROM hr_h2pi_assignments
402: WHERE (status IS NULL OR status <> 'C')
403: AND client_id = p_bg_id
404: UNION
405: SELECT DISTINCT person_id

Line 477: FROM HR_H2PI_ASSIGNMENTS

473: effective_start_date eff_date,
474: 3 ord,
475: 'upload_assignment' fn_name,
476: DECODE(last_upd_date, g_eot, 1, 2) sub_order
477: FROM HR_H2PI_ASSIGNMENTS
478: WHERE (status IS NULL OR status <> 'C')
479: AND primary_flag = 'Y'
480: AND person_id = p_per_id
481: AND client_id = p_from_client_id

Line 488: FROM HR_H2PI_ASSIGNMENTS

484: effective_start_date eff_date,
485: 4 ord,
486: 'upload_assignment' fn_name,
487: DECODE(last_upd_date, g_eot, 1, 2) sub_order
488: FROM HR_H2PI_ASSIGNMENTS
489: WHERE (status IS NULL OR status <> 'C')
490: AND primary_flag = 'N'
491: AND person_id = p_per_id
492: AND client_id = p_from_client_id

Line 863: FROM hr_h2pi_assignments asg

859: p_to_id => l_person_id);
860:
861: SELECT asg.assignment_id
862: INTO l_ud_assignment_id
863: FROM hr_h2pi_assignments asg
864: WHERE asg.person_id = v_ud_per.person_id
865: AND asg.client_id = p_from_client_id
866: AND asg.effective_start_date = v_ud_per.effective_start_date
867: AND asg.primary_flag = 'Y';

Line 1098: FROM hr_h2pi_assignments asg

1094:
1095: hr_utility.set_location(l_proc, 140);
1096: SELECT asg.assignment_id
1097: INTO l_ud_assignment_id
1098: FROM hr_h2pi_assignments asg
1099: WHERE asg.person_id = v_ud_per.person_id
1100: AND asg.client_id = p_from_client_id
1101: AND asg.effective_start_date = v_ud_per.effective_start_date
1102: AND asg.primary_flag = 'Y';

Line 1582: FROM hr_h2pi_assignments asg

1578:
1579: CURSOR csr_ud_assignment (p_asg_id NUMBER,
1580: p_esd DATE) IS
1581: SELECT *
1582: FROM hr_h2pi_assignments asg
1583: WHERE asg.assignment_id = p_asg_id
1584: AND asg.client_id = p_from_client_id
1585: AND asg.effective_start_date = p_esd;
1586:

Line 1590: FROM hr_h2pi_assignments_v asg

1586:
1587: CURSOR csr_ed_assignment (p_asg_id NUMBER,
1588: p_esd DATE) IS
1589: SELECT *
1590: FROM hr_h2pi_assignments_v asg
1591: WHERE asg.assignment_id = p_asg_id
1592: AND p_esd BETWEEN asg.effective_start_date
1593: AND asg.effective_end_date;
1594:

Line 1650: v_ud_asg hr_h2pi_assignments%ROWTYPE;

1646: l_encoded_message VARCHAR2(200);
1647:
1648: l_proc VARCHAR2(72) := g_package||'upload_assignment';
1649:
1650: v_ud_asg hr_h2pi_assignments%ROWTYPE;
1651: v_ed_asg hr_h2pi_assignments_v%ROWTYPE;
1652: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;
1653:
1654: l_person_id per_all_people_f.person_id%TYPE;

Line 1651: v_ed_asg hr_h2pi_assignments_v%ROWTYPE;

1647:
1648: l_proc VARCHAR2(72) := g_package||'upload_assignment';
1649:
1650: v_ud_asg hr_h2pi_assignments%ROWTYPE;
1651: v_ed_asg hr_h2pi_assignments_v%ROWTYPE;
1652: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;
1653:
1654: l_person_id per_all_people_f.person_id%TYPE;
1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 1966: p_table_name => 'HR_H2PI_ASSIGNMENTS',

1962: ROLLBACK;
1963: hr_utility.set_location(l_proc, 220);
1964: hr_h2pi_error.data_error
1965: (p_from_id => l_assignment_id,
1966: p_table_name => 'HR_H2PI_ASSIGNMENTS',
1967: p_message_level => 'FATAL',
1968: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
1969: COMMIT;
1970: RAISE MAPPING_ID_INVALID;

Line 2372: UPDATE hr_h2pi_assignments asg

2368: END LOOP;
2369: END IF;
2370:
2371: hr_utility.set_location(l_proc, 240);
2372: UPDATE hr_h2pi_assignments asg
2373: SET status = 'C'
2374: WHERE asg.assignment_id = v_ud_asg.assignment_id
2375: AND asg.client_id = p_from_client_id
2376: AND asg.effective_start_date = v_ud_asg.effective_start_date

Line 2390: p_table_name => 'HR_H2PI_ASSIGNMENTS',

2386: hr_utility.set_location(l_proc, 260);
2387: l_encoded_message := fnd_message.get_encoded;
2388: hr_h2pi_error.data_error
2389: (p_from_id => v_ud_asg.assignment_id,
2390: p_table_name => 'HR_H2PI_ASSIGNMENTS',
2391: p_message_level => 'FATAL',
2392: p_message_text => l_encoded_message);
2393: COMMIT;
2394: RAISE;

Line 4955: FROM hr_h2pi_assignments_v asg

4951: p_person_id NUMBER) IS
4952:
4953: CURSOR csr_ed_assignment (p_per_id NUMBER) IS
4954: SELECT DISTINCT asg.assignment_id
4955: FROM hr_h2pi_assignments_v asg
4956: WHERE asg.person_id = p_per_id;
4957:
4958: CURSOR csr_city_pct (p_ud_iv_id1 NUMBER,
4959: p_ud_iv_id2 NUMBER,

Line 5295: p_table_name => 'HR_H2PI_ASSIGNMENTS',

5291: hr_utility.set_location(l_proc, 140);
5292: l_encoded_message := fnd_message.get_encoded;
5293: hr_h2pi_error.data_error
5294: (p_from_id => l_ud_assignment_id,
5295: p_table_name => 'HR_H2PI_ASSIGNMENTS',
5296: p_message_level => 'FATAL',
5297: p_message_text => l_encoded_message);
5298: COMMIT;
5299: RAISE;