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.PA_EXPENDITURES_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 8: G_Organization_Name hr_all_organization_units_tl.name%TYPE;

4: G_Organization_id NUMBER(15);
5: G_Organization_id_1 NUMBER(15);
6: /* Bug No. 2487147 ; Change done for UTF8:- Changed G_Organization_Name from VARCHAR2(60) to %TYPE */
7: /* G_Organization_Name VARCHAR2(60); */
8: G_Organization_Name hr_all_organization_units_tl.name%TYPE;
9: G_Organization_Name_1 hr_all_organization_units_tl.name%TYPE;
10: /* Bug 3637411 : Added the following variable for buffering the Organisation Name
11: in the Base Language */
12: G_Organization_Name_US hr_all_organization_units.name%TYPE;

Line 9: G_Organization_Name_1 hr_all_organization_units_tl.name%TYPE;

5: G_Organization_id_1 NUMBER(15);
6: /* Bug No. 2487147 ; Change done for UTF8:- Changed G_Organization_Name from VARCHAR2(60) to %TYPE */
7: /* G_Organization_Name VARCHAR2(60); */
8: G_Organization_Name hr_all_organization_units_tl.name%TYPE;
9: G_Organization_Name_1 hr_all_organization_units_tl.name%TYPE;
10: /* Bug 3637411 : Added the following variable for buffering the Organisation Name
11: in the Base Language */
12: G_Organization_Name_US hr_all_organization_units.name%TYPE;
13: G_Job_Id NUMBER(15);

Line 17: x_org hr_all_organization_units_tl.name%TYPE;

13: G_Job_Id NUMBER(15);
14: G_Job_Name VARCHAR2(240);
15:
16: FUNCTION GetOrgTlName ( P_Organization_Id IN NUMBER ) RETURN VARCHAR2 IS
17: x_org hr_all_organization_units_tl.name%TYPE;
18:
19: BEGIN
20: If P_Organization_Id is NULL THEN
21: RETURN ( NULL );

Line 29: hr_all_organization_units_tl tl

25: P_Organization_Id <> G_Organization_id Then
26: select tl.name
27: into G_Organization_Name
28: from hr_org_units_no_join o,
29: hr_all_organization_units_tl tl
30: where
31: o.organization_id(+) = P_Organization_Id
32: and o.organization_id = tl.organization_id(+)
33: and ( ( tl.organization_id is null and

Line 54: hr_all_organization_units_tl tl

50: If G_Organization_id IS NULL then
51: select tl.name
52: into G_Organization_Name
53: from hr_org_units_no_join o,
54: hr_all_organization_units_tl tl
55: where
56: o.organization_id(+) = P_Organization_Id
57: and o.organization_id = tl.organization_id(+)
58: and ( ( tl.organization_id is null and

Line 71: hr_all_organization_units_tl tl

67: if NVL(G_Organization_id_1, 0) <> P_Organization_Id then
68: select tl.name
69: into G_Organization_Name_1
70: from hr_org_units_no_join o,
71: hr_all_organization_units_tl tl
72: where
73: o.organization_id(+) = P_Organization_Id
74: and o.organization_id = tl.organization_id(+)
75: and ( ( tl.organization_id is null and

Line 135: X_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ;

131:
132: /* New function GET_ORG_NAME added for Bug 6450225 Start */
133: FUNCTION GET_ORG_NAME ( P_ORG_ID IN NUMBER , P_ORG_CTL IN VARCHAR ) RETURN VARCHAR2
134: IS
135: X_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ;
136:
137: BEGIN
138: IF P_ORG_ID = NULL THEN
139: RETURN(NULL);

Line 153: HR_ALL_ORGANIZATION_UNITS_TL TL

149: INTO
150: X_ORG_NAME
151: FROM
152: HR_ORG_UNITS_NO_JOIN O,
153: HR_ALL_ORGANIZATION_UNITS_TL TL
154: WHERE
155: O.ORGANIZATION_ID(+) = P_ORG_ID
156: AND
157: O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)

Line 176: HR_ALL_ORGANIZATION_UNITS_TL TL

172: INTO
173: X_ORG_NAME
174: FROM
175: HR_ORG_UNITS_NO_JOIN O,
176: HR_ALL_ORGANIZATION_UNITS_TL TL
177: WHERE
178: O.ORGANIZATION_ID(+) = P_ORG_ID
179: AND
180: O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)

Line 199: HR_ALL_ORGANIZATION_UNITS_TL TL

195: INTO
196: X_ORG_NAME
197: FROM
198: HR_ORG_UNITS_NO_JOIN O,
199: HR_ALL_ORGANIZATION_UNITS_TL TL
200: WHERE
201: O.ORGANIZATION_ID(+) = P_ORG_ID
202: AND
203: O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)

Line 222: HR_ALL_ORGANIZATION_UNITS_TL TL

218: INTO
219: X_ORG_NAME
220: FROM
221: HR_ORG_UNITS_NO_JOIN O,
222: HR_ALL_ORGANIZATION_UNITS_TL TL
223: WHERE
224: O.ORGANIZATION_ID(+) = P_ORG_ID
225: AND
226: O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)

Line 245: HR_ALL_ORGANIZATION_UNITS_TL TL

241: INTO
242: X_ORG_NAME
243: FROM
244: HR_ORG_UNITS_NO_JOIN O,
245: HR_ALL_ORGANIZATION_UNITS_TL TL
246: WHERE
247: O.ORGANIZATION_ID(+) = P_ORG_ID
248: AND
249: O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)

Line 1021: X_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ;

1017:
1018: /* New function GET_ORG_NAME_WOSEC added for Bug 9321568 Start */
1019: FUNCTION GET_ORG_NAME_WOSEC ( P_Org_ID IN NUMBER ) RETURN VARCHAR2
1020: IS
1021: X_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ;
1022:
1023: BEGIN
1024: IF P_ORG_ID IS NULL THEN
1025: RETURN(NULL);

Line 1033: HR_ALL_ORGANIZATION_UNITS_TL TL

1029: TL.NAME
1030: INTO
1031: X_ORG_NAME
1032: FROM
1033: HR_ALL_ORGANIZATION_UNITS_TL TL
1034: WHERE
1035: TL.ORGANIZATION_ID = P_ORG_ID
1036: AND TL.LANGUAGE = USERENV('LANG') ;
1037: