APPS.PAY_REPORT_FORMAT_MAPPINGS_PKG dependencies on PAY_REPORT_FORMAT_MAPPINGS_TL

Line 70: insert into PAY_REPORT_FORMAT_MAPPINGS_TL (

66: X_UPDATABLE_FLAG,
67: X_DEINITIALIZATION_CODE
68: );
69:
70: insert into PAY_REPORT_FORMAT_MAPPINGS_TL (
71: REPORT_FORMAT_MAPPING_ID,
72: DISPLAY_NAME,
73: LANGUAGE,
74: SOURCE_LANG

Line 83: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_TL T

79: userenv('LANG')
80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_TL T
84: where T.REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: open c;

Line 143: from PAY_REPORT_FORMAT_MAPPINGS_TL

139: where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
140: for update of REPORT_FORMAT_MAPPING_ID nowait; recinfo c%rowtype;
141:
142: cursor c1 is select DISPLAY_NAME, decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
143: from PAY_REPORT_FORMAT_MAPPINGS_TL
144: where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
145: for update of REPORT_FORMAT_MAPPING_ID nowait;
146: begin
147: open c;

Line 251: update PAY_REPORT_FORMAT_MAPPINGS_TL set

247: if (sql%notfound) then
248: raise no_data_found;
249: end if;
250:
251: update PAY_REPORT_FORMAT_MAPPINGS_TL set
252: DISPLAY_NAME = X_DISPLAY_NAME,
253: SOURCE_LANG = userenv('LANG')
254: where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
255: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 266: delete from PAY_REPORT_FORMAT_MAPPINGS_TL

262: procedure DELETE_ROW (
263: X_REPORT_FORMAT_MAPPING_ID in NUMBER
264: ) is
265: begin
266: delete from PAY_REPORT_FORMAT_MAPPINGS_TL
267: where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID;
268:
269: if (sql%notfound) then
270: raise no_data_found;

Line 284: delete from PAY_REPORT_FORMAT_MAPPINGS_TL T

280:
281: procedure ADD_LANGUAGE
282: is
283: begin
284: delete from PAY_REPORT_FORMAT_MAPPINGS_TL T
285: where not exists
286: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_F B
287: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID );
288:

Line 289: update PAY_REPORT_FORMAT_MAPPINGS_TL T set (

285: where not exists
286: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_F B
287: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID );
288:
289: update PAY_REPORT_FORMAT_MAPPINGS_TL T set (
290: DISPLAY_NAME
291: ) = (select B.DISPLAY_NAME from PAY_REPORT_FORMAT_MAPPINGS_TL B
292: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID
293: and B.LANGUAGE = T.SOURCE_LANG)

Line 291: ) = (select B.DISPLAY_NAME from PAY_REPORT_FORMAT_MAPPINGS_TL B

287: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID );
288:
289: update PAY_REPORT_FORMAT_MAPPINGS_TL T set (
290: DISPLAY_NAME
291: ) = (select B.DISPLAY_NAME from PAY_REPORT_FORMAT_MAPPINGS_TL B
292: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID
293: and B.LANGUAGE = T.SOURCE_LANG)
294: where (
295: T.REPORT_FORMAT_MAPPING_ID,

Line 299: from PAY_REPORT_FORMAT_MAPPINGS_TL SUBB, PAY_REPORT_FORMAT_MAPPINGS_TL SUBT

295: T.REPORT_FORMAT_MAPPING_ID,
296: T.LANGUAGE
297: ) in (select
298: SUBT.REPORT_FORMAT_MAPPING_ID, SUBT.LANGUAGE
299: from PAY_REPORT_FORMAT_MAPPINGS_TL SUBB, PAY_REPORT_FORMAT_MAPPINGS_TL SUBT
300: where SUBB.REPORT_FORMAT_MAPPING_ID = SUBT.REPORT_FORMAT_MAPPING_ID
301: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
302: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME ));
303:

Line 304: insert into PAY_REPORT_FORMAT_MAPPINGS_TL (

300: where SUBB.REPORT_FORMAT_MAPPING_ID = SUBT.REPORT_FORMAT_MAPPING_ID
301: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
302: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME ));
303:
304: insert into PAY_REPORT_FORMAT_MAPPINGS_TL (
305: REPORT_FORMAT_MAPPING_ID,
306: DISPLAY_NAME,
307: LANGUAGE,
308: SOURCE_LANG

Line 312: L.LANGUAGE_CODE, B.SOURCE_LANG from PAY_REPORT_FORMAT_MAPPINGS_TL B, FND_LANGUAGES L

308: SOURCE_LANG
309: ) select /*+ ORDERED */
310: B.REPORT_FORMAT_MAPPING_ID,
311: B.DISPLAY_NAME,
312: L.LANGUAGE_CODE, B.SOURCE_LANG from PAY_REPORT_FORMAT_MAPPINGS_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 from PAY_REPORT_FORMAT_MAPPINGS_TL T

Line 316: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_TL T

312: L.LANGUAGE_CODE, B.SOURCE_LANG from PAY_REPORT_FORMAT_MAPPINGS_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 from PAY_REPORT_FORMAT_MAPPINGS_TL T
317: where T.REPORT_FORMAT_MAPPING_ID = B.REPORT_FORMAT_MAPPING_ID
318: and T.LANGUAGE = L.LANGUAGE_CODE);
319: end ADD_LANGUAGE;
320: