APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_ALL_ORGANIZATION_UNITS

Line 315: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',

311:
312: BEGIN
313: hr_utility.set_location('Entering:'|| l_proc, 10);
314: l_from_business_group_id := hr_h2pi_map.get_from_id
315: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
316: p_to_id => hr_h2pi_upload.g_to_business_group_id);
317: IF l_from_business_group_id = -1 THEN
318: hr_utility.set_location(l_proc, 20);
319: hr_h2pi_error.data_error

Line 388: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;

384:
385:
386: l_proc VARCHAR2(72) := g_package||'upload';
387:
388: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
389: l_from_client_id hr_all_organization_units.organization_id%TYPE;
390:
391: BEGIN
392: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 389: l_from_client_id hr_all_organization_units.organization_id%TYPE;

385:
386: l_proc VARCHAR2(72) := g_package||'upload';
387:
388: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
389: l_from_client_id hr_all_organization_units.organization_id%TYPE;
390:
391: BEGIN
392: hr_utility.set_location('Entering:'|| l_proc, 10);
393: hr_h2pi_upload.g_request_id := get_request_id('H2PI_UPLOAD');

Line 418: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;

414: p_business_group_id NUMBER) IS
415:
416: l_proc VARCHAR2(72) := g_package||'upload';
417:
418: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
419: l_from_client_id hr_all_organization_units.organization_id%TYPE;
420:
421: BEGIN
422: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 419: l_from_client_id hr_all_organization_units.organization_id%TYPE;

415:
416: l_proc VARCHAR2(72) := g_package||'upload';
417:
418: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
419: l_from_client_id hr_all_organization_units.organization_id%TYPE;
420:
421: BEGIN
422: hr_utility.set_location('Entering:'|| l_proc, 10);
423: