APPS.QPR_TRANSF_HEADERS_PKG dependencies on QPR_TRANSF_HEADERS_TL

Line 73: insert into QPR_TRANSF_HEADERS_TL (

69: X_LAST_UPDATED_BY,
70: X_LAST_UPDATE_LOGIN
71: );
72:
73: insert into QPR_TRANSF_HEADERS_TL (
74: TRANSF_HEADER_ID,
75: NAME,
76: DESCRIPTION,
77: CREATION_DATE,

Line 107: from QPR_TRANSF_HEADERS_TL T

103: from FND_LANGUAGES L
104: where L.INSTALLED_FLAG in ('I', 'B')
105: and not exists
106: (select NULL
107: from QPR_TRANSF_HEADERS_TL T
108: where T.TRANSF_HEADER_ID = X_TRANSF_HEADER_ID
109: and T.LANGUAGE = L.LANGUAGE_CODE);
110:
111: open c;

Line 162: from QPR_TRANSF_HEADERS_TL

158: cursor c1 is select
159: NAME,
160: DESCRIPTION,
161: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
162: from QPR_TRANSF_HEADERS_TL
163: where TRANSF_HEADER_ID = X_TRANSF_HEADER_ID
164: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
165: for update of TRANSF_HEADER_ID nowait;
166: begin

Line 268: update QPR_TRANSF_HEADERS_TL set

264: if (sql%notfound) then
265: raise no_data_found;
266: end if;
267:
268: update QPR_TRANSF_HEADERS_TL set
269: NAME = X_NAME,
270: DESCRIPTION = X_DESCRIPTION,
271: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
272: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 287: delete from QPR_TRANSF_HEADERS_TL

283: procedure DELETE_ROW (
284: X_TRANSF_HEADER_ID in NUMBER
285: ) is
286: begin
287: delete from QPR_TRANSF_HEADERS_TL
288: where TRANSF_HEADER_ID = X_TRANSF_HEADER_ID;
289:
290: if (sql%notfound) then
291: raise no_data_found;

Line 305: delete from QPR_TRANSF_HEADERS_TL T

301:
302: procedure ADD_LANGUAGE
303: is
304: begin
305: delete from QPR_TRANSF_HEADERS_TL T
306: where not exists
307: (select NULL
308: from QPR_TRANSF_HEADERS_B B
309: where B.TRANSF_HEADER_ID = T.TRANSF_HEADER_ID

Line 312: update QPR_TRANSF_HEADERS_TL T set (

308: from QPR_TRANSF_HEADERS_B B
309: where B.TRANSF_HEADER_ID = T.TRANSF_HEADER_ID
310: );
311:
312: update QPR_TRANSF_HEADERS_TL T set (
313: NAME,
314: DESCRIPTION
315: ) = (select
316: B.NAME,

Line 318: from QPR_TRANSF_HEADERS_TL B

314: DESCRIPTION
315: ) = (select
316: B.NAME,
317: B.DESCRIPTION
318: from QPR_TRANSF_HEADERS_TL B
319: where B.TRANSF_HEADER_ID = T.TRANSF_HEADER_ID
320: and B.LANGUAGE = T.SOURCE_LANG)
321: where (
322: T.TRANSF_HEADER_ID,

Line 327: from QPR_TRANSF_HEADERS_TL SUBB, QPR_TRANSF_HEADERS_TL SUBT

323: T.LANGUAGE
324: ) in (select
325: SUBT.TRANSF_HEADER_ID,
326: SUBT.LANGUAGE
327: from QPR_TRANSF_HEADERS_TL SUBB, QPR_TRANSF_HEADERS_TL SUBT
328: where SUBB.TRANSF_HEADER_ID = SUBT.TRANSF_HEADER_ID
329: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
330: and (SUBB.NAME <> SUBT.NAME
331: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 336: insert into QPR_TRANSF_HEADERS_TL (

332: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
333: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
334: ));
335:
336: insert into QPR_TRANSF_HEADERS_TL (
337: TRANSF_HEADER_ID,
338: NAME,
339: DESCRIPTION,
340: CREATION_DATE,

Line 366: from QPR_TRANSF_HEADERS_TL B, FND_LANGUAGES L

362: B.PROGRAM_APPLICATION_ID,
363: B.REQUEST_ID,
364: L.LANGUAGE_CODE,
365: B.SOURCE_LANG
366: from QPR_TRANSF_HEADERS_TL B, FND_LANGUAGES L
367: where L.INSTALLED_FLAG in ('I', 'B')
368: and B.LANGUAGE = userenv('LANG')
369: and not exists
370: (select NULL

Line 371: from QPR_TRANSF_HEADERS_TL T

367: where L.INSTALLED_FLAG in ('I', 'B')
368: and B.LANGUAGE = userenv('LANG')
369: and not exists
370: (select NULL
371: from QPR_TRANSF_HEADERS_TL T
372: where T.TRANSF_HEADER_ID = B.TRANSF_HEADER_ID
373: and T.LANGUAGE = L.LANGUAGE_CODE);
374: end ADD_LANGUAGE;
375: