APPS.PQH_CTL_SHD dependencies on PQH_TRANSACTION_CATEGORIES

Line 48: from pqh_transaction_categories_tl

44: transaction_category_id,
45: name,
46: language,
47: source_lang
48: from pqh_transaction_categories_tl
49: where transaction_category_id = p_transaction_category_id
50: and language = p_language;
51: --
52: l_proc varchar2(72) := g_package||'api_updating';

Line 119: from pqh_transaction_categories_tl

115: select transaction_category_id,
116: name,
117: language,
118: source_lang
119: from pqh_transaction_categories_tl
120: where transaction_category_id = p_transaction_category_id
121: and language = p_language
122: for update nowait;
123: --

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

Line 203: delete from PQH_TRANSACTION_CATEGORIES_TL T

199:
200: procedure ADD_LANGUAGE
201: is
202: begin
203: delete from PQH_TRANSACTION_CATEGORIES_TL T
204: where not exists
205: (select NULL
206: from PQH_TRANSACTION_CATEGORIES B
207: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID

Line 206: from PQH_TRANSACTION_CATEGORIES B

202: begin
203: delete from PQH_TRANSACTION_CATEGORIES_TL T
204: where not exists
205: (select NULL
206: from PQH_TRANSACTION_CATEGORIES B
207: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
208: );
209:
210: update PQH_TRANSACTION_CATEGORIES_TL T set (

Line 210: update PQH_TRANSACTION_CATEGORIES_TL T set (

206: from PQH_TRANSACTION_CATEGORIES B
207: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
208: );
209:
210: update PQH_TRANSACTION_CATEGORIES_TL T set (
211: NAME
212: ) = (select
213: B.NAME
214: from PQH_TRANSACTION_CATEGORIES_TL B

Line 214: from PQH_TRANSACTION_CATEGORIES_TL B

210: update PQH_TRANSACTION_CATEGORIES_TL T set (
211: NAME
212: ) = (select
213: B.NAME
214: from PQH_TRANSACTION_CATEGORIES_TL B
215: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
216: and B.LANGUAGE = T.SOURCE_LANG)
217: where (
218: T.TRANSACTION_CATEGORY_ID,

Line 223: from PQH_TRANSACTION_CATEGORIES_TL SUBB, PQH_TRANSACTION_CATEGORIES_TL SUBT

219: T.LANGUAGE
220: ) in (select
221: SUBT.TRANSACTION_CATEGORY_ID,
222: SUBT.LANGUAGE
223: from PQH_TRANSACTION_CATEGORIES_TL SUBB, PQH_TRANSACTION_CATEGORIES_TL SUBT
224: where SUBB.TRANSACTION_CATEGORY_ID = SUBT.TRANSACTION_CATEGORY_ID
225: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
226: and (SUBB.NAME <> SUBT.NAME
227: ));

Line 229: insert into PQH_TRANSACTION_CATEGORIES_TL (

225: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
226: and (SUBB.NAME <> SUBT.NAME
227: ));
228:
229: insert into PQH_TRANSACTION_CATEGORIES_TL (
230: TRANSACTION_CATEGORY_ID,
231: NAME,
232: LAST_UPDATE_DATE,
233: CREATION_DATE,

Line 249: from PQH_TRANSACTION_CATEGORIES_TL B, FND_LANGUAGES L

245: B.LAST_UPDATE_LOGIN,
246: B.LAST_UPDATED_BY,
247: L.LANGUAGE_CODE,
248: B.SOURCE_LANG
249: from PQH_TRANSACTION_CATEGORIES_TL B, FND_LANGUAGES L
250: where L.INSTALLED_FLAG in ('I', 'B')
251: and B.LANGUAGE = userenv('LANG')
252: and not exists
253: (select NULL

Line 254: from PQH_TRANSACTION_CATEGORIES_TL T

250: where L.INSTALLED_FLAG in ('I', 'B')
251: and B.LANGUAGE = userenv('LANG')
252: and not exists
253: (select NULL
254: from PQH_TRANSACTION_CATEGORIES_TL T
255: where T.TRANSACTION_CATEGORY_ID = B.TRANSACTION_CATEGORY_ID
256: and T.LANGUAGE = L.LANGUAGE_CODE);
257: --
258: end ADD_LANGUAGE;