APPS.HR_H2PI_BG_UPLOAD dependencies on HR_H2PI_ORGANIZATION_CLASS

Line 338: FROM hr_h2pi_organization_class

334: SELECT DISTINCT organization_id,
335: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 1) hr_org,
336: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 2) class,
337: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 3) info
338: FROM hr_h2pi_organization_class
339: WHERE (status IS NULL OR status <> 'C')
340: AND client_id = p_bg_id
341: UNION
342: SELECT DISTINCT organization_id,

Line 360: FROM hr_h2pi_organization_class

356: AND client_id = p_from_client_id;
357:
358: CURSOR csr_hr_org_class(p_org_id NUMBER) IS
359: SELECT DISTINCT *
360: FROM hr_h2pi_organization_class
361: WHERE organization_id = p_org_id
362: AND (status IS NULL OR status <> 'C')
363: AND client_id = p_from_client_id;
364:

Line 492: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',

488: hr_utility.set_location(l_proc, 75);
489: ROLLBACK;
490: hr_h2pi_error.data_error
491: (p_from_id => l_hr_org_class_id,
492: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',
493: p_message_level => 'FATAL',
494: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
495: RAISE MAPPING_ID_INVALID;
496: END;

Line 589: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',

585: hr_utility.set_location(l_proc, 135);
586: ROLLBACK;
587: hr_h2pi_error.data_error
588: (p_from_id => l_hr_org_class_id,
589: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',
590: p_message_level => 'FATAL',
591: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
592: RAISE MAPPING_ID_INVALID;
593: END;

Line 616: UPDATE hr_h2pi_organization_class

612: ,p_object_version_number => l_ovn
613: );
614: END IF;
615:
616: UPDATE hr_h2pi_organization_class
617: SET status = 'C'
618: WHERE org_information_id = v_ud_hr_org_class.org_information_id
619: AND client_id = p_from_client_id;
620: hr_utility.set_location(l_proc, 170);

Line 628: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',

624: hr_utility.set_location(l_proc, 180);
625: l_encoded_message := fnd_message.get_encoded;
626: hr_h2pi_error.data_error
627: (p_from_id => v_ud_hr_org_class.org_information_id,
628: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',
629: p_message_level => 'FATAL',
630: p_message_text => l_encoded_message);
631: END;
632:

Line 981: FROM hr_h2pi_organization_class

977: AND (status IS NULL OR status <> 'C')
978: AND client_id = p_from_client_id;
979: CURSOR csr_class (p_id NUMBER) IS
980: SELECT 1
981: FROM hr_h2pi_organization_class
982: WHERE organization_id = p_id
983: AND (status IS NULL OR status <> 'C')
984: AND client_id = p_from_client_id;
985: CURSOR csr_info (p_id NUMBER) IS