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_ALL_ORGANIZATION_UNITS

Line 289: FROM hr_all_organization_units org

285: ,p_name IN VARCHAR2
286: )
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'

Line 290: ,hr_all_organization_units_tl otl

286: )
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'

Line 367: CURSOR C IS SELECT rowid FROM HR_ALL_ORGANIZATION_UNITS

363: X_Attribute18 VARCHAR2,
364: X_Attribute19 VARCHAR2,
365: X_Attribute20 VARCHAR2
366: ) IS
367: CURSOR C IS SELECT rowid FROM HR_ALL_ORGANIZATION_UNITS
368: WHERE organization_id = X_Organization_Id;
369:
370: CURSOR C2 IS SELECT hr_organization_units_s.nextval FROM sys.dual;
371:

Line 387: INSERT INTO HR_ALL_ORGANIZATION_UNITS(

383: OPEN C2;
384: FETCH C2 INTO X_Organization_Id;
385: CLOSE C2;
386: end if;
387: INSERT INTO HR_ALL_ORGANIZATION_UNITS(
388: organization_id,
389: business_group_id,
390: cost_allocation_keyflex_id,
391: location_id,

Line 458: insert into HR_ALL_ORGANIZATION_UNITS_TL (

454: X_Attribute20
455:
456: );
457: --
458: insert into HR_ALL_ORGANIZATION_UNITS_TL (
459: -- BUSINESS_GROUP_ID,
460: ORGANIZATION_ID,
461: NAME,
462: LANGUAGE,

Line 474: from HR_ALL_ORGANIZATION_UNITS_TL T

470: from FND_LANGUAGES L
471: where L.INSTALLED_FLAG in ('I', 'B')
472: and not exists
473: (select NULL
474: from HR_ALL_ORGANIZATION_UNITS_TL T
475: where
476: -- T.BUSINESS_GROUP_ID = X_Business_Group_Id
477: T.ORGANIZATION_ID = X_Organization_Id
478: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 539: FROM HR_ALL_ORGANIZATION_UNITS

535: ) IS
536:
537: /* CURSOR C IS
538: SELECT *
539: FROM HR_ALL_ORGANIZATION_UNITS
540: WHERE rowid = X_Rowid
541: FOR UPDATE of Organization_Id NOWAIT;
542: */
543: -- cursor is changed to fix the bug 2145187 (second part MLS)

Line 550: FROM HR_ALL_ORGANIZATION_UNITS ORU,

546: -- OR ( (Recinfo.name_tl IS NULL)
547: -- AND (X_Name IS NULL)))
548: CURSOR C IS
549: SELECT oru.*,orutl.name name_tl
550: FROM HR_ALL_ORGANIZATION_UNITS ORU,
551: HR_ALL_ORGANIZATION_UNITS_TL ORUTL
552: WHERE ORU.rowid = X_Rowid
553: AND ORU.organization_id = ORUTL.organization_id
554: AND ORUTL.language = userenv('LANG')

Line 551: HR_ALL_ORGANIZATION_UNITS_TL ORUTL

547: -- AND (X_Name IS NULL)))
548: CURSOR C IS
549: SELECT oru.*,orutl.name name_tl
550: FROM HR_ALL_ORGANIZATION_UNITS ORU,
551: HR_ALL_ORGANIZATION_UNITS_TL ORUTL
552: WHERE ORU.rowid = X_Rowid
553: AND ORU.organization_id = ORUTL.organization_id
554: AND ORUTL.language = userenv('LANG')
555: FOR UPDATE of ORU.Organization_Id NOWAIT;

Line 561: from HR_ALL_ORGANIZATION_UNITS_TL

557: --
558: cursor c1 is select
559: NAME,
560: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
561: from HR_ALL_ORGANIZATION_UNITS_TL
562: where
563: -- BUSINESS_GROUP_ID = X_Business_Group_Id
564: ORGANIZATION_ID = X_Organization_Id
565: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 774: UPDATE HR_ALL_ORGANIZATION_UNITS

770: (p_organization_id => X_Organization_Id
771: ,p_name => X_Name
772: );
773: --
774: UPDATE HR_ALL_ORGANIZATION_UNITS
775: SET
776:
777: organization_id = X_Organization_Id,
778: business_group_id = X_Business_Group_Id,

Line 822: update HR_ALL_ORGANIZATION_UNITS_TL set

818: hr_utility.set_message_token('STEP','1');
819: hr_utility.raise_error;
820: end if;
821: --
822: update HR_ALL_ORGANIZATION_UNITS_TL set
823: NAME = X_Name,
824: SOURCE_LANG = userenv('LANG')
825: where
826: -- BUSINESS_GROUP_ID = X_Business_Group_Id

Line 1024: delete from HR_ALL_ORGANIZATION_UNITS_TL

1020: Validate_delete(X_Organization_Id => X_Organization_Id,
1021: X_Business_Group_Id => X_Business_Group_Id);
1022:
1023: --
1024: delete from HR_ALL_ORGANIZATION_UNITS_TL
1025: where
1026: -- BUSINESS_GROUP_ID = X_Business_Group_Id
1027: ORGANIZATION_ID = X_Organization_Id;
1028:

Line 1041: DELETE FROM HR_ALL_ORGANIZATION_UNITS

1037: if X_View_All_Orgs <> 'Y' then
1038: hr_security.delete_org_from_list(X_Organization_Id);
1039: end if;
1040: --
1041: DELETE FROM HR_ALL_ORGANIZATION_UNITS
1042: WHERE BUSINESS_GROUP_ID = X_Business_Group_Id
1043: AND ORGANIZATION_ID = X_Organization_Id;
1044: --
1045: if (SQL%NOTFOUND) then

Line 1193: delete from HR_ALL_ORGANIZATION_UNITS_TL T

1189: --
1190: procedure ADD_LANGUAGE
1191: is
1192: begin
1193: delete from HR_ALL_ORGANIZATION_UNITS_TL T
1194: where not exists
1195: (select NULL
1196: from HR_ALL_ORGANIZATION_UNITS B
1197: where B.ORGANIZATION_ID = T.ORGANIZATION_ID

Line 1196: from HR_ALL_ORGANIZATION_UNITS B

1192: begin
1193: delete from HR_ALL_ORGANIZATION_UNITS_TL T
1194: where not exists
1195: (select NULL
1196: from HR_ALL_ORGANIZATION_UNITS B
1197: where B.ORGANIZATION_ID = T.ORGANIZATION_ID
1198: );
1199:
1200: update HR_ALL_ORGANIZATION_UNITS_TL T set (

Line 1200: update HR_ALL_ORGANIZATION_UNITS_TL T set (

1196: from HR_ALL_ORGANIZATION_UNITS B
1197: where B.ORGANIZATION_ID = T.ORGANIZATION_ID
1198: );
1199:
1200: update HR_ALL_ORGANIZATION_UNITS_TL T set (
1201: NAME
1202: ) = (select
1203: B.NAME
1204: from HR_ALL_ORGANIZATION_UNITS_TL B

Line 1204: from HR_ALL_ORGANIZATION_UNITS_TL B

1200: update HR_ALL_ORGANIZATION_UNITS_TL T set (
1201: NAME
1202: ) = (select
1203: B.NAME
1204: from HR_ALL_ORGANIZATION_UNITS_TL B
1205: where B.ORGANIZATION_ID = T.ORGANIZATION_ID
1206: and B.LANGUAGE = T.SOURCE_LANG)
1207: where (
1208: T.ORGANIZATION_ID,

Line 1213: from HR_ALL_ORGANIZATION_UNITS_TL SUBB, HR_ALL_ORGANIZATION_UNITS_TL SUBT

1209: T.LANGUAGE
1210: ) in (select
1211: SUBT.ORGANIZATION_ID,
1212: SUBT.LANGUAGE
1213: from HR_ALL_ORGANIZATION_UNITS_TL SUBB, HR_ALL_ORGANIZATION_UNITS_TL SUBT
1214: where SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
1215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1216: and (SUBB.NAME <> SUBT.NAME
1217: ));

Line 1219: insert into HR_ALL_ORGANIZATION_UNITS_TL (

1215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1216: and (SUBB.NAME <> SUBT.NAME
1217: ));
1218:
1219: insert into HR_ALL_ORGANIZATION_UNITS_TL (
1220: ORGANIZATION_ID,
1221: NAME,
1222: LAST_UPDATE_DATE,
1223: LAST_UPDATED_BY,

Line 1239: from HR_ALL_ORGANIZATION_UNITS_TL B, FND_LANGUAGES L

1235: B.CREATED_BY,
1236: B.CREATION_DATE,
1237: L.LANGUAGE_CODE,
1238: B.SOURCE_LANG
1239: from HR_ALL_ORGANIZATION_UNITS_TL B, FND_LANGUAGES L
1240: where L.INSTALLED_FLAG in ('I', 'B')
1241: and B.LANGUAGE = userenv('LANG')
1242: and not exists
1243: (select NULL

Line 1244: from HR_ALL_ORGANIZATION_UNITS_TL T

1240: where L.INSTALLED_FLAG in ('I', 'B')
1241: and B.LANGUAGE = userenv('LANG')
1242: and not exists
1243: (select NULL
1244: from HR_ALL_ORGANIZATION_UNITS_TL T
1245: where T.ORGANIZATION_ID = B.ORGANIZATION_ID
1246: and T.LANGUAGE = L.LANGUAGE_CODE);
1247: end ADD_LANGUAGE;
1248: --

Line 1283: FROM hr_all_organization_units_tl orgt,

1279: p_org_id IN NUMBER,
1280: p_bus_grp_id IN NUMBER)
1281: IS
1282: SELECT 1
1283: FROM hr_all_organization_units_tl orgt,
1284: hr_all_organization_units org
1285: WHERE upper(orgt.name)=upper(p_org_name)
1286: AND orgt.organization_id = org.organization_id
1287: AND orgt.language = p_language

Line 1284: hr_all_organization_units org

1280: p_bus_grp_id IN NUMBER)
1281: IS
1282: SELECT 1
1283: FROM hr_all_organization_units_tl orgt,
1284: hr_all_organization_units org
1285: WHERE upper(orgt.name)=upper(p_org_name)
1286: AND orgt.organization_id = org.organization_id
1287: AND orgt.language = p_language
1288: AND (org.organization_id <> p_org_id OR p_org_id IS NULL)