APPS.HR_ORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 34: insert into HR_ALL_ORGANIZATION_UNITS_TL (

30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: begin
33:
34: insert into HR_ALL_ORGANIZATION_UNITS_TL (
35: ORGANIZATION_ID,
36: NAME,
37: LAST_UPDATE_DATE,
38: LAST_UPDATED_BY,

Line 66: update HR_ALL_ORGANIZATION_UNITS_TL set

62: X_LAST_UPDATE_LOGIN in NUMBER
63: ) is
64: begin
65:
66: update HR_ALL_ORGANIZATION_UNITS_TL set
67: NAME = X_NAME,
68: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
69: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
70: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 84: delete from HR_ALL_ORGANIZATION_UNITS_TL

80: procedure DELETE_ROW (
81: X_ORGANIZATION_ID in NUMBER
82: ) is
83: begin
84: delete from HR_ALL_ORGANIZATION_UNITS_TL
85: where ORGANIZATION_ID = X_ORGANIZATION_ID;
86:
87: if (sql%notfound) then
88: raise no_data_found;

Line 96: delete from HR_ALL_ORGANIZATION_UNITS_TL T

92:
93: procedure ADD_LANGUAGE
94: is
95: begin
96: delete from HR_ALL_ORGANIZATION_UNITS_TL T
97: where not exists
98: (select NULL
99: from HR_ALL_ORGANIZATION_UNITS B
100: where B.ORGANIZATION_ID = T.ORGANIZATION_ID

Line 103: update HR_ALL_ORGANIZATION_UNITS_TL T set (

99: from HR_ALL_ORGANIZATION_UNITS B
100: where B.ORGANIZATION_ID = T.ORGANIZATION_ID
101: );
102:
103: update HR_ALL_ORGANIZATION_UNITS_TL T set (
104: NAME
105: ) = (select
106: B.NAME
107: from HR_ALL_ORGANIZATION_UNITS_TL B

Line 107: from HR_ALL_ORGANIZATION_UNITS_TL B

103: update HR_ALL_ORGANIZATION_UNITS_TL T set (
104: NAME
105: ) = (select
106: B.NAME
107: from HR_ALL_ORGANIZATION_UNITS_TL B
108: where B.ORGANIZATION_ID = T.ORGANIZATION_ID
109: and B.LANGUAGE = T.SOURCE_LANG)
110: where (
111: T.ORGANIZATION_ID,

Line 116: from HR_ALL_ORGANIZATION_UNITS_TL SUBB, HR_ALL_ORGANIZATION_UNITS_TL SUBT

112: T.LANGUAGE
113: ) in (select
114: SUBT.ORGANIZATION_ID,
115: SUBT.LANGUAGE
116: from HR_ALL_ORGANIZATION_UNITS_TL SUBB, HR_ALL_ORGANIZATION_UNITS_TL SUBT
117: where SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
118: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
119: and (SUBB.NAME <> SUBT.NAME
120: ));

Line 122: insert into HR_ALL_ORGANIZATION_UNITS_TL (

118: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
119: and (SUBB.NAME <> SUBT.NAME
120: ));
121:
122: insert into HR_ALL_ORGANIZATION_UNITS_TL (
123: ORGANIZATION_ID,
124: NAME,
125: LAST_UPDATE_DATE,
126: LAST_UPDATED_BY,

Line 142: from HR_ALL_ORGANIZATION_UNITS_TL B, FND_LANGUAGES L

138: B.CREATED_BY,
139: B.CREATION_DATE,
140: L.LANGUAGE_CODE,
141: B.SOURCE_LANG
142: from HR_ALL_ORGANIZATION_UNITS_TL B, FND_LANGUAGES L
143: where L.INSTALLED_FLAG in ('I', 'B')
144: and B.LANGUAGE = userenv('LANG')
145: and not exists
146: (select NULL

Line 147: from HR_ALL_ORGANIZATION_UNITS_TL T

143: where L.INSTALLED_FLAG in ('I', 'B')
144: and B.LANGUAGE = userenv('LANG')
145: and not exists
146: (select NULL
147: from HR_ALL_ORGANIZATION_UNITS_TL T
148: where T.ORGANIZATION_ID = B.ORGANIZATION_ID
149: and T.LANGUAGE = L.LANGUAGE_CODE);
150: end ADD_LANGUAGE;
151:

Line 220: update HR_ALL_ORGANIZATION_UNITS_TL set

216: X_LAST_UPDATED_BY,
217: X_LAST_UPDATE_LOGIN
218: );
219:
220: update HR_ALL_ORGANIZATION_UNITS_TL set
221: NAME = X_NAME,
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
224: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,