APPS.AP_AUTOSELECT_PKG dependencies on FND_PROFILE

Line 4792: decode( nvl( fnd_profile.value('DISPLAY_INVERSE_RATE'),'N'),

4788: update ap_selected_invoices_all asi
4789: set (payment_exchange_rate_type, payment_exchange_rate) =
4790: (select 'User', /* exchange_rate Commented for bug#12660492 */
4791: /* Added for bug#12660492 Start */
4792: decode( nvl( fnd_profile.value('DISPLAY_INVERSE_RATE'),'N'),
4793: 'N',exchange_rate,
4794: 'Y', 1/exchange_rate
4795: )
4796: /* Added for bug#12660492 End */

Line 4949: AND nvl( fnd_profile.value('AP_GATHER_PPR_TABLE_STATS'), 'N') = 'Y'

4945: /* Code Added for bug#8461050 Start */
4946: /* Need to gather table stat for ap_selected_invoices_all Since all insert/ update has
4947: already been done on the table */
4948: IF ( FND_INSTALLATION.GET_APP_INFO('SQLAP', l_status, l_industry, l_schema)
4949: AND nvl( fnd_profile.value('AP_GATHER_PPR_TABLE_STATS'), 'N') = 'Y'
4950: )
4951: THEN
4952: IF l_schema IS NOT NULL THEN
4953: FND_STATS.GATHER_TABLE_STATS(l_schema, 'AP_SELECTED_INVOICES_ALL');

Line 5212: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);

5208: output_format => l_output_format /* Bug#12917747 */
5209: );
5210:
5211: --below code added for bug#7435751 as we need to set the current nls character setting
5212: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
5213: l_return_status:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
5214:
5215: --submit the selected payment schedules report
5216: l_req_id := FND_REQUEST.SUBMIT_REQUEST(

Line 5585: decode( nvl( fnd_profile.value('DISPLAY_INVERSE_RATE'),'N'),

5581: update ap_selected_invoices_all asi
5582: set (payment_exchange_rate_type, payment_exchange_rate) =
5583: (select 'User', /* exchange_rate Commented for bug#12660492 */
5584: /* Added for bug#12660492 Start */
5585: decode( nvl( fnd_profile.value('DISPLAY_INVERSE_RATE'),'N'),
5586: 'N',exchange_rate,
5587: 'Y', 1/exchange_rate
5588: )
5589: /* Added for bug#12660492 End */

Line 6051: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);

6047: output_format => l_output_format /* Bug#12917747 */
6048: );
6049:
6050: --below code added for bug#7435751 as we need to set the current nls character setting
6051: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
6052: l_return_status:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
6053:
6054: --submit the selected payment schedules report
6055: l_req_id := FND_REQUEST.SUBMIT_REQUEST(