APPS.HR_ORGANIZATION_UNITS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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 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 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 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 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 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