APPS.PA_RES_FORMATS_PVT dependencies on PA_RES_FORMATS_TL

Line 90: insert into pa_res_formats_tl (

86: P_LAST_UPDATED_BY ,
87: P_LAST_UPDATE_LOGIN
88: );
89:
90: insert into pa_res_formats_tl (
91: LAST_UPDATE_LOGIN,
92: CREATION_DATE,
93: CREATED_BY,
94: LAST_UPDATE_DATE,

Line 116: from pa_res_formats_tl T

112: from FND_LANGUAGES L
113: where L.INSTALLED_FLAG in ('I', 'B')
114: and not exists
115: (select NULL
116: from pa_res_formats_tl T
117: where T.RES_FORMAT_ID = L_RES_FORMAT_ID
118: and T.LANGUAGE = L.LANGUAGE_CODE);
119:
120: open c;

Line 159: from pa_res_formats_tl

155: cursor c1 is select
156: NAME,
157: DESCRIPTION,
158: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
159: from pa_res_formats_tl
160: where RES_FORMAT_ID = P_RES_FORMAT_ID
161: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
162: for update of RES_FORMAT_ID nowait;
163: begin

Line 229: update pa_res_formats_tl set

225: if (sql%notfound) then
226: raise no_data_found;
227: end if;
228:
229: update pa_res_formats_tl set
230: NAME = P_NAME,
231: DESCRIPTION = P_DESCRIPTION,
232: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
233: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 248: delete from pa_res_formats_tl

244: procedure DELETE_ROW (
245: P_RES_FORMAT_ID in NUMBER
246: ) is
247: begin
248: delete from pa_res_formats_tl
249: where RES_FORMAT_ID = P_RES_FORMAT_ID;
250:
251: if (sql%notfound) then
252: raise no_data_found;

Line 266: delete from pa_res_formats_tl T

262:
263: procedure ADD_LANGUAGE
264: is
265: begin
266: delete from pa_res_formats_tl T
267: where not exists
268: (select NULL
269: from PA_RES_FORMATS_B B
270: where B.RES_FORMAT_ID = T.res_format_id

Line 273: update pa_res_formats_tl T set (

269: from PA_RES_FORMATS_B B
270: where B.RES_FORMAT_ID = T.res_format_id
271: );
272:
273: update pa_res_formats_tl T set (
274: NAME,
275: DESCRIPTION
276: ) = (select
277: B.NAME,

Line 279: from pa_res_formats_tl B

275: DESCRIPTION
276: ) = (select
277: B.NAME,
278: B.DESCRIPTION
279: from pa_res_formats_tl B
280: where B.RES_FORMAT_ID = T.RES_FORMAT_ID
281: and B.LANGUAGE = T.SOURCE_LANG)
282: where (
283: T.RES_FORMAT_ID,

Line 288: from pa_res_formats_tl SUBB, pa_res_formats_tl SUBT

284: T.LANGUAGE
285: ) in (select
286: SUBT.RES_FORMAT_ID,
287: SUBT.LANGUAGE
288: from pa_res_formats_tl SUBB, pa_res_formats_tl SUBT
289: where SUBB.RES_FORMAT_ID = SUBT.RES_FORMAT_ID
290: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
291: and (SUBB.NAME <> SUBT.NAME
292: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 297: insert into pa_res_formats_tl (

293: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
294: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
295: ));
296:
297: insert into pa_res_formats_tl (
298: LAST_UPDATE_LOGIN,
299: CREATION_DATE,
300: CREATED_BY,
301: LAST_UPDATE_DATE,

Line 319: from pa_res_formats_tl B, FND_LANGUAGES L

315: B.NAME,
316: B.DESCRIPTION,
317: L.LANGUAGE_CODE,
318: B.SOURCE_LANG
319: from pa_res_formats_tl B, FND_LANGUAGES L
320: where L.INSTALLED_FLAG in ('I', 'B')
321: and B.LANGUAGE = userenv('LANG')
322: and not exists
323: (select NULL

Line 324: from pa_res_formats_tl T

320: where L.INSTALLED_FLAG in ('I', 'B')
321: and B.LANGUAGE = userenv('LANG')
322: and not exists
323: (select NULL
324: from pa_res_formats_tl T
325: where T.RES_FORMAT_ID = B.RES_FORMAT_ID
326: and T.LANGUAGE = L.LANGUAGE_CODE);
327: end ADD_LANGUAGE;
328:

Line 337: update pa_res_formats_tl set

333: P_DESCRIPTION in VARCHAR2
334: ) is
335: begin
336:
337: update pa_res_formats_tl set
338: NAME = P_NAME,
339: DESCRIPTION = P_DESCRIPTION,
340: LAST_UPDATE_DATE = sysdate,
341: LAST_UPDATED_BY = decode(P_OWNER, 'SEED', 1, 0),