APPS.PQH_ATL_SHD dependencies on PQH_ATTRIBUTES

Line 48: from pqh_attributes_tl

44: attribute_id,
45: attribute_name,
46: language,
47: source_lang
48: from pqh_attributes_tl
49: where attribute_id = p_attribute_id
50: and language = p_language;
51: --
52: l_proc varchar2(72) := g_package||'api_updating';

Line 119: from pqh_attributes_tl

115: select attribute_id,
116: attribute_name,
117: language,
118: source_lang
119: from pqh_attributes_tl
120: where attribute_id = p_attribute_id
121: and language = p_language
122: for update nowait;
123: --

Line 160: hr_utility.set_message_token('TABLE_NAME', 'pqh_attributes_tl');

156: -- The object is locked therefore we need to supply a meaningful
157: -- error message.
158: --
159: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
160: hr_utility.set_message_token('TABLE_NAME', 'pqh_attributes_tl');
161: hr_utility.raise_error;
162: End lck;
163: --
164: ----------------------- ADD LANGUAGE --------------------------------------

Line 169: delete from PQH_ATTRIBUTES_TL T

165: --
166: Procedure ADD_LANGUAGE
167: is
168: begin
169: delete from PQH_ATTRIBUTES_TL T
170: where not exists
171: (select NULL
172: from PQH_ATTRIBUTES B
173: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 172: from PQH_ATTRIBUTES B

168: begin
169: delete from PQH_ATTRIBUTES_TL T
170: where not exists
171: (select NULL
172: from PQH_ATTRIBUTES B
173: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
174: );
175:
176: update PQH_ATTRIBUTES_TL T set (

Line 176: update PQH_ATTRIBUTES_TL T set (

172: from PQH_ATTRIBUTES B
173: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
174: );
175:
176: update PQH_ATTRIBUTES_TL T set (
177: ATTRIBUTE_NAME
178: ) = (select
179: B.ATTRIBUTE_NAME
180: from PQH_ATTRIBUTES_TL B

Line 180: from PQH_ATTRIBUTES_TL B

176: update PQH_ATTRIBUTES_TL T set (
177: ATTRIBUTE_NAME
178: ) = (select
179: B.ATTRIBUTE_NAME
180: from PQH_ATTRIBUTES_TL B
181: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
182: and B.LANGUAGE = T.SOURCE_LANG)
183: where (
184: T.ATTRIBUTE_ID,

Line 189: from PQH_ATTRIBUTES_TL SUBB, PQH_ATTRIBUTES_TL SUBT

185: T.LANGUAGE
186: ) in (select
187: SUBT.ATTRIBUTE_ID,
188: SUBT.LANGUAGE
189: from PQH_ATTRIBUTES_TL SUBB, PQH_ATTRIBUTES_TL SUBT
190: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
191: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
192: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
193: ));

Line 195: insert into PQH_ATTRIBUTES_TL (

191: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
192: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
193: ));
194:
195: insert into PQH_ATTRIBUTES_TL (
196: ATTRIBUTE_ID,
197: ATTRIBUTE_NAME,
198: LAST_UPDATE_DATE,
199: CREATION_DATE,

Line 215: from PQH_ATTRIBUTES_TL B, FND_LANGUAGES L

211: B.LAST_UPDATE_LOGIN,
212: B.LAST_UPDATED_BY,
213: L.LANGUAGE_CODE,
214: B.SOURCE_LANG
215: from PQH_ATTRIBUTES_TL B, FND_LANGUAGES L
216: where L.INSTALLED_FLAG in ('I', 'B')
217: and B.LANGUAGE = userenv('LANG')
218: and not exists
219: (select NULL

Line 220: from PQH_ATTRIBUTES_TL T

216: where L.INSTALLED_FLAG in ('I', 'B')
217: and B.LANGUAGE = userenv('LANG')
218: and not exists
219: (select NULL
220: from PQH_ATTRIBUTES_TL T
221: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
222: and T.LANGUAGE = L.LANGUAGE_CODE);
223: end ADD_LANGUAGE;
224: --