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_VALIDATE dependencies on HR_H2PI_BG_AND_GRE

Line 18: SELECT * FROM hr_h2pi_bg_and_gre

14:
15: bg_and_gre_tab bg_and_gre_tab_type;
16:
17: CURSOR csr_bg_and_gre IS
18: SELECT * FROM hr_h2pi_bg_and_gre
19: WHERE client_id = p_from_client_id;
20:
21: CURSOR csr_pay_bg_and_gre IS
22: SELECT organization_id

Line 23: FROM hr_h2pi_bg_and_gre_v

19: WHERE client_id = p_from_client_id;
20:
21: CURSOR csr_pay_bg_and_gre IS
22: SELECT organization_id
23: FROM hr_h2pi_bg_and_gre_v
24: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
25:
26: CURSOR csr_hr_data_removed (p_organization_id NUMBER) IS
27: SELECT organization_id

Line 28: FROM hr_h2pi_bg_and_gre_v bg

24: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
25:
26: CURSOR csr_hr_data_removed (p_organization_id NUMBER) IS
27: SELECT organization_id
28: FROM hr_h2pi_bg_and_gre_v bg
29: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_Id
30: AND bg.organization_id = p_organization_id
31: AND NOT EXISTS (SELECT 'X'
32: FROM hr_h2pi_id_mapping him,

Line 33: hr_h2pi_bg_and_gre bg1

29: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_Id
30: AND bg.organization_id = p_organization_id
31: AND NOT EXISTS (SELECT 'X'
32: FROM hr_h2pi_id_mapping him,
33: hr_h2pi_bg_and_gre bg1
34: WHERE him.to_id = bg.organization_id
35: AND bg1.organization_id = him.from_id
36: AND him.table_name = 'HR_ALL_ORGANIZATION_UNITS'
37: AND him.to_business_group_id = bg.business_group_id);

Line 41: FROM hr_h2pi_bg_and_gre_v bg

37: AND him.to_business_group_id = bg.business_group_id);
38:
39: CURSOR csr_payroll_data_added(p_organization_id NUMBER) IS
40: SELECT organization_id
41: FROM hr_h2pi_bg_and_gre_v bg
42: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_id
43: AND bg.organization_id = p_organization_id
44: AND NOT EXISTS (SELECT 'X'
45: FROM hr_h2pi_id_mapping him

Line 51: l_ed_rec hr_h2pi_bg_and_gre_v%ROWTYPE;

47: AND him.table_name = 'HR_ALL_ORGANIZATION_UNITS'
48: AND him.to_business_group_id =
49: hr_h2pi_upload.g_to_business_group_id);
50:
51: l_ed_rec hr_h2pi_bg_and_gre_v%ROWTYPE;
52: l_organization_to_id hr_h2pi_bg_and_gre.organization_id%TYPe;
53: l_counter BINARY_INTEGER ;
54: l_organization_id hr_h2pi_bg_and_gre.organization_id%TYPE;
55: l_location_id hr_h2pi_bg_and_gre.location_id%TYPE;

Line 52: l_organization_to_id hr_h2pi_bg_and_gre.organization_id%TYPe;

48: AND him.to_business_group_id =
49: hr_h2pi_upload.g_to_business_group_id);
50:
51: l_ed_rec hr_h2pi_bg_and_gre_v%ROWTYPE;
52: l_organization_to_id hr_h2pi_bg_and_gre.organization_id%TYPe;
53: l_counter BINARY_INTEGER ;
54: l_organization_id hr_h2pi_bg_and_gre.organization_id%TYPE;
55: l_location_id hr_h2pi_bg_and_gre.location_id%TYPE;
56: l_record_ok BOOLEAN;

Line 54: l_organization_id hr_h2pi_bg_and_gre.organization_id%TYPE;

50:
51: l_ed_rec hr_h2pi_bg_and_gre_v%ROWTYPE;
52: l_organization_to_id hr_h2pi_bg_and_gre.organization_id%TYPe;
53: l_counter BINARY_INTEGER ;
54: l_organization_id hr_h2pi_bg_and_gre.organization_id%TYPE;
55: l_location_id hr_h2pi_bg_and_gre.location_id%TYPE;
56: l_record_ok BOOLEAN;
57:
58: l_proc VARCHAR2(72) := g_package||'validate_bg_and_gre';

Line 55: l_location_id hr_h2pi_bg_and_gre.location_id%TYPE;

51: l_ed_rec hr_h2pi_bg_and_gre_v%ROWTYPE;
52: l_organization_to_id hr_h2pi_bg_and_gre.organization_id%TYPe;
53: l_counter BINARY_INTEGER ;
54: l_organization_id hr_h2pi_bg_and_gre.organization_id%TYPE;
55: l_location_id hr_h2pi_bg_and_gre.location_id%TYPE;
56: l_record_ok BOOLEAN;
57:
58: l_proc VARCHAR2(72) := g_package||'validate_bg_and_gre';
59:

Line 70: p_table_name => 'HR_H2PI_BG_AND_GRE',

66: FROM per_business_groups
67: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
68: IF l_method_of_gen_emp_num <> 'M' THEN
69: hr_h2pi_error.data_error(p_from_id => p_from_client_id,
70: p_table_name => 'HR_H2PI_BG_AND_GRE',
71: p_message_level => 'FATAL',
72: p_message_name => 'HR_289292_EMP_NUM_GEN_MANUAL');
73: END IF;
74: EXCEPTION

Line 92: p_table_name => 'HR_H2PI_BG_AND_GRE',

88:
89: IF l_organization_to_id = -1 THEN
90: hr_utility.set_location(l_proc, 30);
91: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,
92: p_table_name => 'HR_H2PI_BG_AND_GRE',
93: p_message_level => 'FATAL',
94: p_message_name => 'HR_289260_UD_DATA_ADDED');
95: ELSE
96: hr_utility.set_location(l_proc, 40);

Line 100: FROM hr_h2pi_bg_and_gre_v

96: hr_utility.set_location(l_proc, 40);
97: BEGIN
98: SELECT DISTINCT *
99: INTO l_ed_rec
100: FROM hr_h2pi_bg_and_gre_v
101: WHERE organization_id = l_organization_to_id;
102:
103: l_counter := l_counter + 1 ;
104: bg_and_gre_tab(l_counter) := l_organization_to_id;

Line 115: p_table_name => 'HR_H2PI_BG_AND_GRE',

111: l_ed_rec.date_to <> v_ud_rec.date_to OR
112: NVL(l_ed_rec.location_id, -1) <> NVL(l_location_id, -1) THEN
113: hr_utility.set_location(l_proc, 50);
114: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,
115: p_table_name => 'HR_H2PI_BG_AND_GRE',
116: p_message_level => 'FATAL',
117: p_message_name => 'HR_289237_DATA_MISMATCH');
118: END IF;
119:

Line 124: p_table_name => 'HR_H2PI_BG_AND_GRE',

120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: hr_utility.set_location(l_proc, 60);
123: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,
124: p_table_name => 'HR_H2PI_BG_AND_GRE',
125: p_message_level=> 'FATAL',
126: p_message_name => 'HR_289235_ED_DATA_REMOVED');
127: WHEN MAPPING_ID_MISSING THEN
128: hr_utility.set_location(l_proc, 70);

Line 156: p_table_name => 'HR_H2PI_BG_AND_GRE',

152: IF csr_payroll_data_added%FOUND then
153: hr_utility.set_location(l_proc, 110);
154:
155: hr_h2pi_error.data_error(p_from_id => l_organization_id,
156: p_table_name => 'HR_H2PI_BG_AND_GRE',
157: p_message_level => 'FATAL',
158: p_message_name => 'HR_289259_ED_DATA_ADDED');
159: CLOSE csr_payroll_data_added;
160:

Line 171: p_table_name => 'HR_H2PI_BG_AND_GRE',

167: IF csr_hr_data_removed%FOUND then
168: hr_utility.set_location(l_proc, 120);
169: --HR Data removed
170: hr_h2pi_error.data_error(p_from_id => l_organization_id,
171: p_table_name => 'HR_H2PI_BG_AND_GRE',
172: p_message_level => 'FATAL',
173: p_message_name => 'HR_289236_UD_DATA_REMOVED');
174: END IF;
175: CLOSE csr_hr_data_removed;