APPS.HR_ORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 40: p_entity_name => 'HR_ALL_ORGANIZATION_UNITS_TL',

36: --
37:
38: BEGIN
39: PER_RIC_PKG.chk_integrity (
40: p_entity_name => 'HR_ALL_ORGANIZATION_UNITS_TL',
41: p_ref_entity => 'HR_ALL_ORGANIZATION_UNITS',
42: p_ref_column_name => 'ORGANIZATION_ID',
43: p_ref_col_value_number => X_ORGANIZATION_ID,
44: p_ref_col_value_varchar => NULL,

Line 52: insert into HR_ALL_ORGANIZATION_UNITS_TL (

48: END;
49: --
50: -- Code Ends Here.
51: --
52: insert into HR_ALL_ORGANIZATION_UNITS_TL (
53: ORGANIZATION_ID,
54: NAME,
55: LAST_UPDATE_DATE,
56: LAST_UPDATED_BY,

Line 84: update HR_ALL_ORGANIZATION_UNITS_TL set

80: X_LAST_UPDATE_LOGIN in NUMBER
81: ) is
82: begin
83:
84: update HR_ALL_ORGANIZATION_UNITS_TL set
85: NAME = X_NAME,
86: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
87: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
88: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 102: delete from HR_ALL_ORGANIZATION_UNITS_TL

98: procedure DELETE_ROW (
99: X_ORGANIZATION_ID in NUMBER
100: ) is
101: begin
102: delete from HR_ALL_ORGANIZATION_UNITS_TL
103: where ORGANIZATION_ID = X_ORGANIZATION_ID;
104:
105: if (sql%notfound) then
106: raise no_data_found;

Line 114: delete from HR_ALL_ORGANIZATION_UNITS_TL T

110:
111: procedure ADD_LANGUAGE
112: is
113: begin
114: delete from HR_ALL_ORGANIZATION_UNITS_TL T
115: where not exists
116: (select NULL
117: from HR_ALL_ORGANIZATION_UNITS B
118: where B.ORGANIZATION_ID = T.ORGANIZATION_ID

Line 121: update HR_ALL_ORGANIZATION_UNITS_TL T set (

117: from HR_ALL_ORGANIZATION_UNITS B
118: where B.ORGANIZATION_ID = T.ORGANIZATION_ID
119: );
120:
121: update HR_ALL_ORGANIZATION_UNITS_TL T set (
122: NAME
123: ) = (select
124: B.NAME
125: from HR_ALL_ORGANIZATION_UNITS_TL B

Line 125: from HR_ALL_ORGANIZATION_UNITS_TL B

121: update HR_ALL_ORGANIZATION_UNITS_TL T set (
122: NAME
123: ) = (select
124: B.NAME
125: from HR_ALL_ORGANIZATION_UNITS_TL B
126: where B.ORGANIZATION_ID = T.ORGANIZATION_ID
127: and B.LANGUAGE = T.SOURCE_LANG)
128: where (
129: T.ORGANIZATION_ID,

Line 134: from HR_ALL_ORGANIZATION_UNITS_TL SUBB, HR_ALL_ORGANIZATION_UNITS_TL SUBT

130: T.LANGUAGE
131: ) in (select
132: SUBT.ORGANIZATION_ID,
133: SUBT.LANGUAGE
134: from HR_ALL_ORGANIZATION_UNITS_TL SUBB, HR_ALL_ORGANIZATION_UNITS_TL SUBT
135: where SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
136: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
137: and (SUBB.NAME <> SUBT.NAME
138: ));

Line 140: insert into HR_ALL_ORGANIZATION_UNITS_TL (

136: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
137: and (SUBB.NAME <> SUBT.NAME
138: ));
139:
140: insert into HR_ALL_ORGANIZATION_UNITS_TL (
141: ORGANIZATION_ID,
142: NAME,
143: LAST_UPDATE_DATE,
144: LAST_UPDATED_BY,

Line 160: from HR_ALL_ORGANIZATION_UNITS_TL B, FND_LANGUAGES L

156: B.CREATED_BY,
157: B.CREATION_DATE,
158: L.LANGUAGE_CODE,
159: B.SOURCE_LANG
160: from HR_ALL_ORGANIZATION_UNITS_TL B, FND_LANGUAGES L
161: where L.INSTALLED_FLAG in ('I', 'B')
162: and B.LANGUAGE = userenv('LANG')
163: and not exists
164: (select NULL

Line 165: from HR_ALL_ORGANIZATION_UNITS_TL T

161: where L.INSTALLED_FLAG in ('I', 'B')
162: and B.LANGUAGE = userenv('LANG')
163: and not exists
164: (select NULL
165: from HR_ALL_ORGANIZATION_UNITS_TL T
166: where T.ORGANIZATION_ID = B.ORGANIZATION_ID
167: and T.LANGUAGE = L.LANGUAGE_CODE);
168: end ADD_LANGUAGE;
169:

Line 238: update HR_ALL_ORGANIZATION_UNITS_TL set

234: X_LAST_UPDATED_BY,
235: X_LAST_UPDATE_LOGIN
236: );
237:
238: update HR_ALL_ORGANIZATION_UNITS_TL set
239: NAME = X_NAME,
240: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
241: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
242: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,