eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DISC_PKG dependencies on ICX_SEC

Line 1386: /* Bug No # 4315875 : Replaced AP_WEB_INFRASTRUCTURE_PKG.getDateFormat with icx_sec.g_date_format

1382: BEGIN
1383: debug_info := 'converting to date';
1384: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
1385: BEGIN
1386: /* Bug No # 4315875 : Replaced AP_WEB_INFRASTRUCTURE_PKG.getDateFormat with icx_sec.g_date_format
1387: so that preference changes made by user would be reflected without logging out
1388: */
1389: l_tempDate := to_date( l_date_temp,nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')) );
1390: EXCEPTION

Line 1389: l_tempDate := to_date( l_date_temp,nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')) );

1385: BEGIN
1386: /* Bug No # 4315875 : Replaced AP_WEB_INFRASTRUCTURE_PKG.getDateFormat with icx_sec.g_date_format
1387: so that preference changes made by user would be reflected without logging out
1388: */
1389: l_tempDate := to_date( l_date_temp,nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')) );
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: -- chiho: handle the date value not in default date format:
1393: IF ( SQLCODE = -1843 ) THEN

Line 1402: nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'))); */

1398: END;
1399:
1400: IF ( l_prompt_code = 'AP_WEB_STARTDATE' ) THEN
1401: /*p_receipts(rec_count).start_date := to_char( l_tempDate,
1402: nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'))); */
1403: --Bug 5029676
1404: p_receipts(rec_count).start_date := l_tempDate;
1405:
1406: ELSIF ( l_prompt_code = 'AP_WEB_ENDDATE' ) THEN

Line 1408: nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));*/

1404: p_receipts(rec_count).start_date := l_tempDate;
1405:
1406: ELSIF ( l_prompt_code = 'AP_WEB_ENDDATE' ) THEN
1407: /*p_receipts(rec_count).end_date := to_char( l_tempDate,
1408: nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));*/
1409: --Bug 5029676
1410: p_receipts(rec_count).end_date := l_tempDate;
1411: END IF;
1412:

Line 1420: fnd_message.set_token( 'format', nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));

1416: fnd_message.set_name( 'SQLAP', 'AP_WEB_DISCON_INVALID_FULLYEAR');
1417: fnd_message.set_token ( 'DATE', l_prompt_text);
1418: ELSE
1419: fnd_message.set_name('SQLAP','AP_WEB_INVALID_DATE');
1420: fnd_message.set_token( 'format', nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));
1421: END IF;
1422:
1423: IF ( l_prompt_code = 'AP_WEB_START_DATE' ) THEN
1424: AP_WEB_UTILITIES_PKG.AddMessage(

Line 2033: V_DateFormat := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));

2029: -- We need to retrieve currency and exchange rate information
2030: -- before calling PATC.
2031:
2032: -- For PATC: Used when doing projects verification
2033: V_DateFormat := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));
2034:
2035: -- For PATC: Determine the time-wise last receipt to use as the
2036: -- exchange rate date
2037: -- Assumes has at least one receipt

Line 2217: to_char(ExpReportLineInfo(i).start_date,nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'))) ||

2213:
2214: debug_info := 'Receipts';
2215: for i in 1 .. l_recCount loop
2216: l_line := l_line ||
2217: to_char(ExpReportLineInfo(i).start_date,nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'))) ||
2218: l_delim;
2219: if (ExpReportLineInfo(i).end_date IS NULL) then
2220: l_line := l_line || l_delim;
2221: else

Line 2223: to_char(ExpReportLineInfo(i).end_date, nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'))) ||

2219: if (ExpReportLineInfo(i).end_date IS NULL) then
2220: l_line := l_line || l_delim;
2221: else
2222: l_line := l_line ||
2223: to_char(ExpReportLineInfo(i).end_date, nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'))) ||
2224: l_delim;
2225: end if;
2226: l_line := l_line || ExpReportLineInfo(i).days || l_delim;
2227: if (ExpReportLineInfo(i).daily_amount IS NULL) then

Line 2819: l_last_receipt_date := to_char(p_report_lines_info(1).start_date, nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));

2815:
2816:
2817: l_receipt_count := TO_NUMBER(p_report_header_info.receipt_count);
2818: IF (l_receipt_count > 0) THEN
2819: l_last_receipt_date := to_char(p_report_lines_info(1).start_date, nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));
2820: l_dateformat := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));
2821: debug_info := 'Populate core fields and empty custom fields';
2822: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
2823: FOR I IN 1..l_receipt_count LOOP

Line 2820: l_dateformat := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));

2816:
2817: l_receipt_count := TO_NUMBER(p_report_header_info.receipt_count);
2818: IF (l_receipt_count > 0) THEN
2819: l_last_receipt_date := to_char(p_report_lines_info(1).start_date, nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));
2820: l_dateformat := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));
2821: debug_info := 'Populate core fields and empty custom fields';
2822: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
2823: FOR I IN 1..l_receipt_count LOOP
2824:

Line 3482: l_date_format := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));

3478: BEGIN
3479: -- Get reimbursement currency
3480: l_reimbursement_currency_code := p_report_header_info.reimbursement_currency_code;
3481: l_receipt_count := TO_NUMBER(p_report_header_info.receipt_count);
3482: l_date_format := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));
3483:
3484: --Bug 3068461
3485: -- Get policy rate options
3486: AP_WEB_OA_DISC_PKG.GetPolicyRateOptions(l_policyRateOptions);