APPS.PQH_TTL_SHD dependencies on PQH_TEMPLATES

Line 48: from pqh_templates_tl

44: template_id,
45: template_name,
46: language,
47: source_lang
48: from pqh_templates_tl
49: where template_id = p_template_id
50: and language = p_language;
51: --
52: l_proc varchar2(72) := g_package||'api_updating';

Line 119: from pqh_templates_tl

115: select template_id,
116: template_name,
117: language,
118: source_lang
119: from pqh_templates_tl
120: where template_id = p_template_id
121: and language = p_language
122: for update nowait;
123: --

Line 160: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates_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_templates_tl');
161: hr_utility.raise_error;
162: End lck;
163: --
164: --

Line 171: delete from PQH_TEMPLATES_TL T

167:
168: procedure ADD_LANGUAGE
169: is
170: begin
171: delete from PQH_TEMPLATES_TL T
172: where not exists
173: (select NULL
174: from PQH_TEMPLATES B
175: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 174: from PQH_TEMPLATES B

170: begin
171: delete from PQH_TEMPLATES_TL T
172: where not exists
173: (select NULL
174: from PQH_TEMPLATES B
175: where B.TEMPLATE_ID = T.TEMPLATE_ID
176: );
177:
178: update PQH_TEMPLATES_TL T set (

Line 178: update PQH_TEMPLATES_TL T set (

174: from PQH_TEMPLATES B
175: where B.TEMPLATE_ID = T.TEMPLATE_ID
176: );
177:
178: update PQH_TEMPLATES_TL T set (
179: TEMPLATE_NAME
180: ) = (select
181: B.TEMPLATE_NAME
182: from PQH_TEMPLATES_TL B

Line 182: from PQH_TEMPLATES_TL B

178: update PQH_TEMPLATES_TL T set (
179: TEMPLATE_NAME
180: ) = (select
181: B.TEMPLATE_NAME
182: from PQH_TEMPLATES_TL B
183: where B.TEMPLATE_ID = T.TEMPLATE_ID
184: and B.LANGUAGE = T.SOURCE_LANG)
185: where (
186: T.TEMPLATE_ID,

Line 191: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT

187: T.LANGUAGE
188: ) in (select
189: SUBT.TEMPLATE_ID,
190: SUBT.LANGUAGE
191: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT
192: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
193: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
194: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
195: ));

Line 197: insert into PQH_TEMPLATES_TL (

193: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
194: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
195: ));
196:
197: insert into PQH_TEMPLATES_TL (
198: TEMPLATE_ID,
199: TEMPLATE_NAME,
200: LAST_UPDATE_DATE,
201: CREATION_DATE,

Line 217: from PQH_TEMPLATES_TL B, FND_LANGUAGES L

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

Line 222: from PQH_TEMPLATES_TL T

218: where L.INSTALLED_FLAG in ('I', 'B')
219: and B.LANGUAGE = userenv('LANG')
220: and not exists
221: (select NULL
222: from PQH_TEMPLATES_TL T
223: where T.TEMPLATE_ID = B.TEMPLATE_ID
224: and T.LANGUAGE = L.LANGUAGE_CODE);
225: end ADD_LANGUAGE;
226: