APPS.HR_H2PI_BG_UPLOAD dependencies on HR_H2PI_HR_ORGANIZATIONS

Line 330: FROM hr_h2pi_hr_organizations

326: SELECT DISTINCT organization_id,
327: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 1) hr_org,
328: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 2) class,
329: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 3) info
330: FROM hr_h2pi_hr_organizations
331: WHERE (status IS NULL OR status <> 'C')
332: AND client_id = p_bg_id
333: UNION
334: SELECT DISTINCT organization_id,

Line 353: FROM hr_h2pi_hr_organizations

349: ORDER BY organization_id;
350:
351: CURSOR csr_hr_org(p_org_id NUMBER) IS
352: SELECT DISTINCT *
353: FROM hr_h2pi_hr_organizations
354: WHERE organization_id = p_org_id
355: AND (status IS NULL OR status <> 'C')
356: AND client_id = p_from_client_id;
357:

Line 378: v_ud_hr_org hr_h2pi_hr_organizations%ROWTYPE;

374: SELECT effective_date
375: FROM fnd_sessions
376: WHERE session_id = userenv('sessionid');
377: --
378: v_ud_hr_org hr_h2pi_hr_organizations%ROWTYPE;
379: l_hr_org_id hr_all_organization_units.organization_id%TYPE := NULL;
380: l_hr_org_class_id hr_organization_information.org_information_id%TYPE := NULL;
381: l_hr_org_info_id hr_organization_information.org_information_id%TYPE := NULL;
382: l_location_id hr_all_organization_units.location_id%TYPE;

Line 532: UPDATE hr_h2pi_hr_organizations

528:
529: END IF;
530:
531: hr_utility.set_location(l_proc, 90);
532: UPDATE hr_h2pi_hr_organizations
533: SET status = 'C'
534: WHERE organization_id = v_ud_hr_org.organization_id
535: AND client_id = p_from_client_id;
536:

Line 872: p_table_name => 'HR_H2PI_HR_ORGANIZATIONS',

868: hr_utility.set_location(l_proc, 290);
869: l_encoded_message := fnd_message.get_encoded;
870: hr_h2pi_error.data_error
871: (p_from_id => v_ud_hr_org.organization_id,
872: p_table_name => 'HR_H2PI_HR_ORGANIZATIONS',
873: p_message_level => 'FATAL',
874: p_message_text => l_encoded_message);
875: END;
876:

Line 975: FROM hr_h2pi_hr_organizations

971: l_proc VARCHAR2(72) := g_package||'org_exists';
972:
973: CURSOR csr_hr_org (p_id NUMBER) IS
974: SELECT 1
975: FROM hr_h2pi_hr_organizations
976: WHERE organization_id = p_id
977: AND (status IS NULL OR status <> 'C')
978: AND client_id = p_from_client_id;
979: CURSOR csr_class (p_id NUMBER) IS