APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on FND_PROFILE

Line 263: g_created_by := NVL(fnd_profile.value('USER_ID'),1);

259: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
260: G_PKG_NAME||': '||l_api_name||'()+');
261: END IF;
262:
263: g_created_by := NVL(fnd_profile.value('USER_ID'),1);
264: g_creation_date := sysdate;
265: g_last_updated_by := NVL(fnd_profile.value('USER_ID'),1);
266: g_last_update_date := sysdate;
267: g_last_update_login := 1;

Line 265: g_last_updated_by := NVL(fnd_profile.value('USER_ID'),1);

261: END IF;
262:
263: g_created_by := NVL(fnd_profile.value('USER_ID'),1);
264: g_creation_date := sysdate;
265: g_last_updated_by := NVL(fnd_profile.value('USER_ID'),1);
266: g_last_update_date := sysdate;
267: g_last_update_login := 1;
268: g_concurrent_request_id := NVL(fnd_profile.value('CONC_REQUEST_ID'),1);
269:

Line 268: g_concurrent_request_id := NVL(fnd_profile.value('CONC_REQUEST_ID'),1);

264: g_creation_date := sysdate;
265: g_last_updated_by := NVL(fnd_profile.value('USER_ID'),1);
266: g_last_update_date := sysdate;
267: g_last_update_login := 1;
268: g_concurrent_request_id := NVL(fnd_profile.value('CONC_REQUEST_ID'),1);
269:
270:
271: IF UPPER(p_accounting_type) = 'DECENTRALIZED' AND p_establishment_id IS NULL THEN
272: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_DECEN_ESTB_REQ');

Line 519: l_icx_format_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'RRRR/MM/DD');

515: ELSE -- If special situation indicator not null.
516:
517: BEGIN
518:
519: l_icx_format_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'RRRR/MM/DD');
520: FND_FILE.PUT_LINE(FND_FILE.LOG,'ICX Date Format Mask : '||l_icx_format_mask);
521: g_start_date := to_date(p_start_date,l_icx_format_mask);
522: g_end_date := to_date(p_end_date,l_icx_format_mask);
523:

Line 5941: l_icx_num_format := NVL(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),',.');

5937: INTO l_row_set_id
5938: FROM rg_reports
5939: WHERE report_id =g_balance_statement_report_id;
5940:
5941: l_icx_num_format := NVL(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),',.');
5942:
5943: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5944: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5945: G_PKG_NAME||': ' ||l_api_name||'(): ICX Numeric Format: '||l_icx_num_format);

Line 6221: l_icx_num_format :=fnd_profile.value('ICX_NUMERIC_CHARACTERS');

6217: INTO l_row_set_id
6218: FROM rg_reports
6219: WHERE report_id =g_income_statement_report_id;
6220:
6221: l_icx_num_format :=fnd_profile.value('ICX_NUMERIC_CHARACTERS');
6222:
6223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
6225: G_PKG_NAME||': ' ||l_api_name||'(): ICX Numeric Format: '||l_icx_num_format);