APPS.PQH_TRL_SHD dependencies on PQH_TABLE_ROUTE

Line 48: from pqh_table_route_tl

44: table_route_id
45: ,display_name
46: ,language
47: ,source_lang
48: from pqh_table_route_tl
49: where table_route_id = p_table_route_id
50: and language = p_language;
51: --
52: l_fct_ret boolean;

Line 114: from pqh_table_route_tl

110: table_route_id
111: ,display_name
112: ,language
113: ,source_lang
114: from pqh_table_route_tl
115: where table_route_id = p_table_route_id
116: and language = p_language
117: for update nowait;
118: --

Line 160: fnd_message.set_token('TABLE_NAME', 'pqh_table_route_tl');

156: -- The object is locked therefore we need to supply a meaningful
157: -- error message.
158: --
159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
160: fnd_message.set_token('TABLE_NAME', 'pqh_table_route_tl');
161: fnd_message.raise_error;
162: End lck;
163: --
164: -- ----------------------------------------------------------------------------

Line 170: delete from PQH_TABLE_ROUTE_TL T

166: -- ----------------------------------------------------------------------------
167: procedure ADD_LANGUAGE
168: is
169: begin
170: delete from PQH_TABLE_ROUTE_TL T
171: where not exists
172: (select NULL
173: from PQH_TABLE_ROUTE B
174: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID

Line 173: from PQH_TABLE_ROUTE B

169: begin
170: delete from PQH_TABLE_ROUTE_TL T
171: where not exists
172: (select NULL
173: from PQH_TABLE_ROUTE B
174: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
175: );
176:
177: update PQH_TABLE_ROUTE_TL T set (

Line 177: update PQH_TABLE_ROUTE_TL T set (

173: from PQH_TABLE_ROUTE B
174: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
175: );
176:
177: update PQH_TABLE_ROUTE_TL T set (
178: DISPLAY_NAME
179: ) = (select
180: B.DISPLAY_NAME
181: from PQH_TABLE_ROUTE_TL B

Line 181: from PQH_TABLE_ROUTE_TL B

177: update PQH_TABLE_ROUTE_TL T set (
178: DISPLAY_NAME
179: ) = (select
180: B.DISPLAY_NAME
181: from PQH_TABLE_ROUTE_TL B
182: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
183: and B.LANGUAGE = T.SOURCE_LANG)
184: where (
185: T.TABLE_ROUTE_ID,

Line 190: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT

186: T.LANGUAGE
187: ) in (select
188: SUBT.TABLE_ROUTE_ID,
189: SUBT.LANGUAGE
190: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT
191: where SUBB.TABLE_ROUTE_ID = SUBT.TABLE_ROUTE_ID
192: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
193: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
194: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)

Line 198: insert into PQH_TABLE_ROUTE_TL (

194: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)
195: or (SUBB.DISPLAY_NAME is not null and SUBT.DISPLAY_NAME is null)
196: ));
197:
198: insert into PQH_TABLE_ROUTE_TL (
199: TABLE_ROUTE_ID,
200: DISPLAY_NAME,
201: LAST_UPDATE_DATE,
202: CREATION_DATE,

Line 218: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L

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

Line 223: from PQH_TABLE_ROUTE_TL T

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