APPS.PAY_RFT_SHD dependencies on PAY_REPORT_FORMAT_MAPPINGS_TL

Line 52: from pay_report_format_mappings_tl

48: report_format_mapping_id
49: ,language
50: ,source_lang
51: ,display_name
52: from pay_report_format_mappings_tl
53: where report_format_mapping_id = p_report_format_mapping_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from pay_report_format_mappings_tl

114: report_format_mapping_id
115: ,language
116: ,source_lang
117: ,display_name
118: from pay_report_format_mappings_tl
119: where report_format_mapping_id = p_report_format_mapping_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'pay_report_format_mappings_tl');

160: -- The object is locked therefore we need to supply a meaningful
161: -- error message.
162: --
163: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
164: fnd_message.set_token('TABLE_NAME', 'pay_report_format_mappings_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 174: delete from PAY_REPORT_FORMAT_MAPPINGS_TL T

170: -- ----------------------------------------------------------------------------
171: PROCEDURE add_language IS
172: Begin
173: --
174: delete from PAY_REPORT_FORMAT_MAPPINGS_TL T
175: where not exists
176: ( select NULL
177: from PAY_REPORT_FORMAT_MAPPINGS_F B
178: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID );

Line 180: update PAY_REPORT_FORMAT_MAPPINGS_TL T

176: ( select NULL
177: from PAY_REPORT_FORMAT_MAPPINGS_F B
178: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID );
179:
180: update PAY_REPORT_FORMAT_MAPPINGS_TL T
181: set ( DISPLAY_NAME ) =
182: ( select B.DISPLAY_NAME
183: from PAY_REPORT_FORMAT_MAPPINGS_TL B
184: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID

Line 183: from PAY_REPORT_FORMAT_MAPPINGS_TL B

179:
180: update PAY_REPORT_FORMAT_MAPPINGS_TL T
181: set ( DISPLAY_NAME ) =
182: ( select B.DISPLAY_NAME
183: from PAY_REPORT_FORMAT_MAPPINGS_TL B
184: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID
185: and B.LANGUAGE = T.SOURCE_LANG )
186: where (
187: T.REPORT_FORMAT_MAPPING_ID,

Line 193: from PAY_REPORT_FORMAT_MAPPINGS_TL SUBB,

189: ) in
190: ( select
191: SUBT.REPORT_FORMAT_MAPPING_ID,
192: SUBT.LANGUAGE
193: from PAY_REPORT_FORMAT_MAPPINGS_TL SUBB,
194: PAY_REPORT_FORMAT_MAPPINGS_TL SUBT
195: where SUBB.REPORT_FORMAT_MAPPING_ID = SUBT.REPORT_FORMAT_MAPPING_ID
196: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
197: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME )

Line 194: PAY_REPORT_FORMAT_MAPPINGS_TL SUBT

190: ( select
191: SUBT.REPORT_FORMAT_MAPPING_ID,
192: SUBT.LANGUAGE
193: from PAY_REPORT_FORMAT_MAPPINGS_TL SUBB,
194: PAY_REPORT_FORMAT_MAPPINGS_TL SUBT
195: where SUBB.REPORT_FORMAT_MAPPING_ID = SUBT.REPORT_FORMAT_MAPPING_ID
196: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
197: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME )
198: );

Line 200: insert into PAY_REPORT_FORMAT_MAPPINGS_TL

196: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
197: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME )
198: );
199:
200: insert into PAY_REPORT_FORMAT_MAPPINGS_TL
201: (
202: REPORT_FORMAT_MAPPING_ID,
203: DISPLAY_NAME,
204: LANGUAGE,

Line 212: from PAY_REPORT_FORMAT_MAPPINGS_TL B,

208: B.REPORT_FORMAT_MAPPING_ID,
209: B.DISPLAY_NAME,
210: L.LANGUAGE_CODE,
211: B.SOURCE_LANG
212: from PAY_REPORT_FORMAT_MAPPINGS_TL B,
213: FND_LANGUAGES L
214: where L.INSTALLED_FLAG in ('I', 'B')
215: and B.LANGUAGE = userenv('LANG')
216: and not exists

Line 218: from PAY_REPORT_FORMAT_MAPPINGS_TL T

214: where L.INSTALLED_FLAG in ('I', 'B')
215: and B.LANGUAGE = userenv('LANG')
216: and not exists
217: ( select NULL
218: from PAY_REPORT_FORMAT_MAPPINGS_TL T
219: where T.REPORT_FORMAT_MAPPING_ID = B.REPORT_FORMAT_MAPPING_ID
220: and T.LANGUAGE = L.LANGUAGE_CODE );
221: --
222: End add_language;