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 229: delete from PQH_TABLE_ROUTE_TL

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

Line 247: delete from PQH_TABLE_ROUTE_TL T

243:
244: procedure ADD_LANGUAGE
245: is
246: begin
247: delete from PQH_TABLE_ROUTE_TL T
248: where not exists
249: (select NULL
250: from PQH_TABLE_ROUTE B
251: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID

Line 254: update PQH_TABLE_ROUTE_TL T set (

250: from PQH_TABLE_ROUTE B
251: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
252: );
253:
254: update PQH_TABLE_ROUTE_TL T set (
255: DISPLAY_NAME
256: ) = (select
257: B.DISPLAY_NAME
258: from PQH_TABLE_ROUTE_TL B

Line 258: from PQH_TABLE_ROUTE_TL B

254: update PQH_TABLE_ROUTE_TL T set (
255: DISPLAY_NAME
256: ) = (select
257: B.DISPLAY_NAME
258: from PQH_TABLE_ROUTE_TL B
259: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
260: and B.LANGUAGE = T.SOURCE_LANG)
261: where (
262: T.TABLE_ROUTE_ID,

Line 267: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT

263: T.LANGUAGE
264: ) in (select
265: SUBT.TABLE_ROUTE_ID,
266: SUBT.LANGUAGE
267: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT
268: where SUBB.TABLE_ROUTE_ID = SUBT.TABLE_ROUTE_ID
269: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
270: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
271: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)

Line 275: insert into PQH_TABLE_ROUTE_TL (

271: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)
272: or (SUBB.DISPLAY_NAME is not null and SUBT.DISPLAY_NAME is null)
273: ));
274:
275: insert into PQH_TABLE_ROUTE_TL (
276: TABLE_ROUTE_ID,
277: DISPLAY_NAME,
278: LAST_UPDATE_DATE,
279: CREATION_DATE,

Line 295: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L

291: B.LAST_UPDATE_LOGIN,
292: B.LAST_UPDATED_BY,
293: L.LANGUAGE_CODE,
294: B.SOURCE_LANG
295: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L
296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL

Line 300: from PQH_TABLE_ROUTE_TL T

296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL
300: from PQH_TABLE_ROUTE_TL T
301: where T.TABLE_ROUTE_ID = B.TABLE_ROUTE_ID
302: and T.LANGUAGE = L.LANGUAGE_CODE);
303: end ADD_LANGUAGE;
304:

Line 517: update pqh_table_route_tl

513: l_last_update_date := sysdate;
514: l_last_update_login := 0;
515: l_last_updated_by := fnd_load_util.owner_id(p_owner);
516:
517: update pqh_table_route_tl
518: set display_name = p_display_name ,
519: last_update_date = l_last_update_date,
520: last_updated_by = l_last_updated_by,
521: last_update_login = l_last_update_login,