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_ORGANIZATION_UNITS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 10: ,p_org_information_context IN hr_organization_information.org_information_context%TYPE

6: g_legislation_code varchar2(150); -- For validating translation;
7: --------------------------------------------------------------------------------
8: PROCEDURE chk_repbody_seat_numbers
9: (p_organization_id IN hr_organization_units.organization_id%TYPE
10: ,p_org_information_context IN hr_organization_information.org_information_context%TYPE
11: ,p_org_information6 IN hr_organization_information.org_information6%TYPE
12: ,p_org_information2 IN hr_organization_information.org_information2%TYPE
13: ,p_rowid IN VARCHAR2) IS
14: --

Line 11: ,p_org_information6 IN hr_organization_information.org_information6%TYPE

7: --------------------------------------------------------------------------------
8: PROCEDURE chk_repbody_seat_numbers
9: (p_organization_id IN hr_organization_units.organization_id%TYPE
10: ,p_org_information_context IN hr_organization_information.org_information_context%TYPE
11: ,p_org_information6 IN hr_organization_information.org_information6%TYPE
12: ,p_org_information2 IN hr_organization_information.org_information2%TYPE
13: ,p_rowid IN VARCHAR2) IS
14: --
15: CURSOR repbody_max_seats IS

Line 12: ,p_org_information2 IN hr_organization_information.org_information2%TYPE

8: PROCEDURE chk_repbody_seat_numbers
9: (p_organization_id IN hr_organization_units.organization_id%TYPE
10: ,p_org_information_context IN hr_organization_information.org_information_context%TYPE
11: ,p_org_information6 IN hr_organization_information.org_information6%TYPE
12: ,p_org_information2 IN hr_organization_information.org_information2%TYPE
13: ,p_rowid IN VARCHAR2) IS
14: --
15: CURSOR repbody_max_seats IS
16: SELECT hoi.org_information6

Line 17: FROM hr_organization_information hoi

13: ,p_rowid IN VARCHAR2) IS
14: --
15: CURSOR repbody_max_seats IS
16: SELECT hoi.org_information6
17: FROM hr_organization_information hoi
18: WHERE hoi.organization_id = p_organization_id
19: AND hoi.org_information_context = 'Representative Body';
20: --
21: CURSOR constituency_total_seats1 IS

Line 23: FROM hr_organization_information hoi

19: AND hoi.org_information_context = 'Representative Body';
20: --
21: CURSOR constituency_total_seats1 IS
22: SELECT sum(hoi.org_information2)
23: FROM hr_organization_information hoi
24: WHERE hoi.organization_id = p_organization_id
25: AND hoi.org_information_context = 'RepBody_Constituencies'
26: AND rowid <> p_rowid;
27: --

Line 30: FROM hr_organization_information hoi

26: AND rowid <> p_rowid;
27: --
28: CURSOR constituency_total_seats2 IS
29: SELECT sum(hoi.org_information2)
30: FROM hr_organization_information hoi
31: WHERE hoi.organization_id = p_organization_id
32: AND hoi.org_information_context = 'RepBody_Constituencies';
33: --
34: l_proc VARCHAR2(72) := g_package||'chk_repbody_seat_numbers';

Line 236: from hr_organization_information hoi

232: procedure check_gre(p_org_id NUMBER) is
233: l_dummy varchar2(1);
234: cursor test_loc(p_type VARCHAR2) is
235: select 'Y'
236: from hr_organization_information hoi
237: where hoi.org_INFORMATION_CONTEXT = 'CLASS'
238: and hoi.org_information1 = p_type
239: and hoi.org_information2 = 'Y' -- Bug 3456540
240: and hoi.organization_id = p_org_id;

Line 276: FROM hr_organization_information ori

272: (p_organization_id IN NUMBER
273: )
274: IS
275: SELECT 0
276: FROM hr_organization_information ori
277: WHERE ori.org_information_context = 'CLASS'
278: AND ori.org_information1 = 'HR_BG'
279: AND ori.org_information2 = 'Y'
280: AND ori.organization_id = p_organization_id;

Line 291: ,hr_organization_information ori

287: IS
288: SELECT 0
289: FROM hr_all_organization_units org
290: ,hr_all_organization_units_tl otl
291: ,hr_organization_information ori
292: WHERE ori.org_information_context = 'CLASS'
293: AND ori.org_information1 = 'HR_BG'
294: AND ori.org_information2 = 'Y'
295: AND ori.organization_id = org.organization_id

Line 843: from HR_ORGANIZATION_INFORMATION

839: FUNCTION get_org_class (X_Organization_Id NUMBER, X_Organization_Class VARCHAR2) return boolean is
840:
841: cursor csr_org_class is
842: select '1'
843: from HR_ORGANIZATION_INFORMATION
844: where organization_id = X_Organization_Id
845: and org_information1 = X_Organization_Class
846: and org_information_context = 'CLASS';
847:

Line 1073: ||'from hr_organization_information hoi '

1069: ,'MRP_ORGANIZATION_PARAMETERS'
1070: ,'WIP_ORGANIZATION_PARAMETERS')
1071: then
1072: l_sql_text := 'select hoi.ORG_INFORMATION1 '
1073: ||'from hr_organization_information hoi '
1074: ||'where hoi.organization_id = '||to_char(X_ORGANIZATION_ID)||' '
1075: ||'and hoi.org_information_context = ''Accounting Information''';
1076: --
1077: -- Open Cursor for Processing Sql statment.