APPS.PQH_TABLE_ROUTE_PKG dependencies on PQH_TABLE_ROUTE_TL

Line 64: insert into PQH_TABLE_ROUTE_TL (

60: X_LAST_UPDATED_BY,
61: X_LAST_UPDATE_LOGIN
62: );
63:
64: insert into PQH_TABLE_ROUTE_TL (
65: TABLE_ROUTE_ID,
66: DISPLAY_NAME,
67: LAST_UPDATE_DATE,
68: CREATION_DATE,

Line 88: from PQH_TABLE_ROUTE_TL T

84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from PQH_TABLE_ROUTE_TL T
89: where T.TABLE_ROUTE_ID = X_TABLE_ROUTE_ID
90: and T.LANGUAGE = L.LANGUAGE_CODE);
91:
92: open c;

Line 128: from PQH_TABLE_ROUTE_TL

124:
125: cursor c1 is select
126: DISPLAY_NAME,
127: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
128: from PQH_TABLE_ROUTE_TL
129: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID
130: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
131: for update of TABLE_ROUTE_ID nowait;
132: begin

Line 211: update PQH_TABLE_ROUTE_TL set

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: update PQH_TABLE_ROUTE_TL set
212: DISPLAY_NAME = X_DISPLAY_NAME,
213: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 230: delete from PQH_TABLE_ROUTE_TL

226: X_TABLE_ROUTE_ID in NUMBER
227: ) is
228: begin
229:
230: delete from PQH_TABLE_ROUTE_TL
231: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 243: p_ref_entity=>'PQH_TABLE_ROUTE_TL',

239: -- Code Starts Here.
240: --
241: per_ric_pkg.Chk_integrity(
242: p_entity_name=>'PQH_TABLE_ROUTE',
243: p_ref_entity=>'PQH_TABLE_ROUTE_TL',
244: p_ref_column_name=> 'TABLE_ROUTE_ID',
245: p_ref_col_value_number=>X_TABLE_ROUTE_ID,
246: p_ref_col_value_varchar=>NULL,
247: p_ref_col_value_date=>NULL,

Line 264: delete from PQH_TABLE_ROUTE_TL T

260:
261: procedure ADD_LANGUAGE
262: is
263: begin
264: delete from PQH_TABLE_ROUTE_TL T
265: where not exists
266: (select NULL
267: from PQH_TABLE_ROUTE B
268: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID

Line 271: update PQH_TABLE_ROUTE_TL T set (

267: from PQH_TABLE_ROUTE B
268: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
269: );
270:
271: update PQH_TABLE_ROUTE_TL T set (
272: DISPLAY_NAME
273: ) = (select
274: B.DISPLAY_NAME
275: from PQH_TABLE_ROUTE_TL B

Line 275: from PQH_TABLE_ROUTE_TL B

271: update PQH_TABLE_ROUTE_TL T set (
272: DISPLAY_NAME
273: ) = (select
274: B.DISPLAY_NAME
275: from PQH_TABLE_ROUTE_TL B
276: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
277: and B.LANGUAGE = T.SOURCE_LANG)
278: where (
279: T.TABLE_ROUTE_ID,

Line 284: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT

280: T.LANGUAGE
281: ) in (select
282: SUBT.TABLE_ROUTE_ID,
283: SUBT.LANGUAGE
284: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT
285: where SUBB.TABLE_ROUTE_ID = SUBT.TABLE_ROUTE_ID
286: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
287: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
288: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)

Line 292: insert into PQH_TABLE_ROUTE_TL (

288: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)
289: or (SUBB.DISPLAY_NAME is not null and SUBT.DISPLAY_NAME is null)
290: ));
291:
292: insert into PQH_TABLE_ROUTE_TL (
293: TABLE_ROUTE_ID,
294: DISPLAY_NAME,
295: LAST_UPDATE_DATE,
296: CREATION_DATE,

Line 312: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L

308: B.LAST_UPDATE_LOGIN,
309: B.LAST_UPDATED_BY,
310: L.LANGUAGE_CODE,
311: B.SOURCE_LANG
312: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L
313: where L.INSTALLED_FLAG in ('I', 'B')
314: and B.LANGUAGE = userenv('LANG')
315: and not exists
316: (select NULL

Line 317: from PQH_TABLE_ROUTE_TL T

313: where L.INSTALLED_FLAG in ('I', 'B')
314: and B.LANGUAGE = userenv('LANG')
315: and not exists
316: (select NULL
317: from PQH_TABLE_ROUTE_TL T
318: where T.TABLE_ROUTE_ID = B.TABLE_ROUTE_ID
319: and T.LANGUAGE = L.LANGUAGE_CODE);
320: end ADD_LANGUAGE;
321:

Line 534: update pqh_table_route_tl

530: l_last_update_date := sysdate;
531: l_last_update_login := 0;
532: l_last_updated_by := fnd_load_util.owner_id(p_owner);
533:
534: update pqh_table_route_tl
535: set display_name = p_display_name ,
536: last_update_date = l_last_update_date,
537: last_updated_by = l_last_updated_by,
538: last_update_login = l_last_update_login,