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_BG_UPLOAD dependencies on HR_H2PI_ORGANIZATION_INFO

Line 41: FROM hr_h2pi_organization_info ogi

37: ,ogi.org_information17 ogi17
38: ,ogi.org_information18 ogi18
39: ,ogi.org_information19 ogi19
40: ,ogi.org_information20 ogi20
41: FROM hr_h2pi_organization_info ogi
42: WHERE ogi.org_information_id = p_org_information_id;
43:
44: l_seg_id VARCHAR2(100);
45: l_seg_value VARCHAR2(100);

Line 346: FROM hr_h2pi_organization_info

342: SELECT DISTINCT organization_id,
343: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 1) hr_org,
344: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 2) class,
345: hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 3) info
346: FROM hr_h2pi_organization_info
347: WHERE (status IS NULL OR status <> 'C')
348: AND client_id = p_bg_id
349: ORDER BY organization_id;
350:

Line 367: FROM hr_h2pi_organization_info

363: AND client_id = p_from_client_id;
364:
365: CURSOR csr_hr_org_info(p_org_id NUMBER) IS
366: SELECT DISTINCT *
367: FROM hr_h2pi_organization_info
368: WHERE organization_id = p_org_id
369: AND (status IS NULL OR status <> 'C')
370: AND client_id = p_from_client_id;
371:

Line 388: l_org_info1 hr_h2pi_organization_info.org_information1%TYPE;

384: l_org_info2 VARCHAR2(150);
385: l_ovn NUMBER(9);
386: l_session_date DATE;
387:
388: l_org_info1 hr_h2pi_organization_info.org_information1%TYPE;
389: l_org_info8 hr_h2pi_organization_info.org_information8%TYPE;
390: l_org_info9 hr_h2pi_organization_info.org_information9%TYPE;
391: l_org_info10 hr_h2pi_organization_info.org_information10%TYPE;
392: l_org_info12 hr_h2pi_organization_info.org_information12%TYPE;

Line 389: l_org_info8 hr_h2pi_organization_info.org_information8%TYPE;

385: l_ovn NUMBER(9);
386: l_session_date DATE;
387:
388: l_org_info1 hr_h2pi_organization_info.org_information1%TYPE;
389: l_org_info8 hr_h2pi_organization_info.org_information8%TYPE;
390: l_org_info9 hr_h2pi_organization_info.org_information9%TYPE;
391: l_org_info10 hr_h2pi_organization_info.org_information10%TYPE;
392: l_org_info12 hr_h2pi_organization_info.org_information12%TYPE;
393: l_org_info13 hr_h2pi_organization_info.org_information13%TYPE;

Line 390: l_org_info9 hr_h2pi_organization_info.org_information9%TYPE;

386: l_session_date DATE;
387:
388: l_org_info1 hr_h2pi_organization_info.org_information1%TYPE;
389: l_org_info8 hr_h2pi_organization_info.org_information8%TYPE;
390: l_org_info9 hr_h2pi_organization_info.org_information9%TYPE;
391: l_org_info10 hr_h2pi_organization_info.org_information10%TYPE;
392: l_org_info12 hr_h2pi_organization_info.org_information12%TYPE;
393: l_org_info13 hr_h2pi_organization_info.org_information13%TYPE;
394:

Line 391: l_org_info10 hr_h2pi_organization_info.org_information10%TYPE;

387:
388: l_org_info1 hr_h2pi_organization_info.org_information1%TYPE;
389: l_org_info8 hr_h2pi_organization_info.org_information8%TYPE;
390: l_org_info9 hr_h2pi_organization_info.org_information9%TYPE;
391: l_org_info10 hr_h2pi_organization_info.org_information10%TYPE;
392: l_org_info12 hr_h2pi_organization_info.org_information12%TYPE;
393: l_org_info13 hr_h2pi_organization_info.org_information13%TYPE;
394:
395: l_proc VARCHAR2(72) := g_package||'upload_hr_organization';

Line 392: l_org_info12 hr_h2pi_organization_info.org_information12%TYPE;

388: l_org_info1 hr_h2pi_organization_info.org_information1%TYPE;
389: l_org_info8 hr_h2pi_organization_info.org_information8%TYPE;
390: l_org_info9 hr_h2pi_organization_info.org_information9%TYPE;
391: l_org_info10 hr_h2pi_organization_info.org_information10%TYPE;
392: l_org_info12 hr_h2pi_organization_info.org_information12%TYPE;
393: l_org_info13 hr_h2pi_organization_info.org_information13%TYPE;
394:
395: l_proc VARCHAR2(72) := g_package||'upload_hr_organization';
396:

Line 393: l_org_info13 hr_h2pi_organization_info.org_information13%TYPE;

389: l_org_info8 hr_h2pi_organization_info.org_information8%TYPE;
390: l_org_info9 hr_h2pi_organization_info.org_information9%TYPE;
391: l_org_info10 hr_h2pi_organization_info.org_information10%TYPE;
392: l_org_info12 hr_h2pi_organization_info.org_information12%TYPE;
393: l_org_info13 hr_h2pi_organization_info.org_information13%TYPE;
394:
395: l_proc VARCHAR2(72) := g_package||'upload_hr_organization';
396:
397: BEGIN

Line 800: p_table_name => 'HR_H2PI_ORGANIZATION_INFO',

796: hr_utility.set_location(l_proc, 50);
797: ROLLBACK;
798: hr_h2pi_error.data_error
799: (p_from_id => l_hr_org_info_id,
800: p_table_name => 'HR_H2PI_ORGANIZATION_INFO',
801: p_message_level => 'FATAL',
802: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
803: RAISE MAPPING_ID_INVALID;
804: END;

Line 837: UPDATE hr_h2pi_organization_info

833: );
834: END IF;
835:
836:
837: UPDATE hr_h2pi_organization_info
838: SET status = 'C'
839: WHERE org_information_id = v_ud_hr_org_info.org_information_id
840: AND client_id = p_from_client_id;
841: hr_utility.set_location(l_proc, 240);

Line 849: p_table_name => 'HR_H2PI_ORGANIZATION_INFO',

845: hr_utility.set_location(l_proc, 250);
846: l_encoded_message := fnd_message.get_encoded;
847: hr_h2pi_error.data_error
848: (p_from_id => v_ud_hr_org_info.org_information_id,
849: p_table_name => 'HR_H2PI_ORGANIZATION_INFO',
850: p_message_level => 'FATAL',
851: p_message_text => l_encoded_message);
852: END;
853:

Line 987: FROM hr_h2pi_organization_info

983: AND (status IS NULL OR status <> 'C')
984: AND client_id = p_from_client_id;
985: CURSOR csr_info (p_id NUMBER) IS
986: SELECT 1
987: FROM hr_h2pi_organization_info
988: WHERE organization_id = p_id
989: AND (status IS NULL OR status <> 'C')
990: AND client_id = p_from_client_id;
991: