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.CS_ERES_INT_PKG dependencies on FND_PROFILE

Line 428: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');

424:
425: l_errm VARCHAR2(100);
426: l_msg VARCHAR2(250);
427:
428: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
429: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
430: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
431: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
432:

Line 429: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');

425: l_errm VARCHAR2(100);
426: l_msg VARCHAR2(250);
427:
428: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
429: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
430: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
431: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
432:
433:

Line 430: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');

426: l_msg VARCHAR2(250);
427:
428: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
429: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
430: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
431: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
432:
433:
434:

Line 431: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';

427:
428: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
429: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
430: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
431: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
432:
433:
434:
435: BEGIN

Line 722: (JNB.note_status = 'P' and JNB.created_by = fnd_profile.value_wnps('USER_ID') ))

718: AND FLP.lookup_code = JNB.note_status
719: AND JNB.source_object_code = 'SR'
720: AND JNB.source_object_id = x_incident_id
721: AND ((JNB.note_status <> 'P') OR
722: (JNB.note_status = 'P' and JNB.created_by = fnd_profile.value_wnps('USER_ID') ))
723: AND JNB.created_by = fnd1.user_id
724: AND ext_userb.user_id (+) = fnd1.user_id
725: AND ext_usert.language (+)= userenv('LANG')
726: AND ext_userb.resource_id = ext_usert.resource_id (+)

Line 834: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');

830: xmldoc CLOB;
831: pass BOOLEAN;
832: l_query VARCHAR2(32000) := null;
833: l_api_name VARCHAR2(40) := 'Generate_XML_Document';
834: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
835: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
836: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
837: --l_display_timezone_id VARCHAR2(15);
838: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';

Line 835: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');

831: pass BOOLEAN;
832: l_query VARCHAR2(32000) := null;
833: l_api_name VARCHAR2(40) := 'Generate_XML_Document';
834: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
835: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
836: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
837: --l_display_timezone_id VARCHAR2(15);
838: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
839: l_ext_rec_count NUMBER;

Line 836: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');

832: l_query VARCHAR2(32000) := null;
833: l_api_name VARCHAR2(40) := 'Generate_XML_Document';
834: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
835: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
836: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
837: --l_display_timezone_id VARCHAR2(15);
838: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
839: l_ext_rec_count NUMBER;
840:

Line 838: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';

834: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
835: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
836: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
837: --l_display_timezone_id VARCHAR2(15);
838: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
839: l_ext_rec_count NUMBER;
840:
841: --New Cursors and Vars
842:

Line 2093: l_validate_sr_close VARCHAR2(30) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');

2089: l_api_name VARCHAR2(240) := 'Post_Approval_Process';
2090: l_spl_excp VARCHAR2(3) := 'N';
2091: l_note_id NUMBER;
2092: l_note_err_msg VARCHAR2(240);
2093: l_validate_sr_close VARCHAR2(30) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
2094: -- l_close_sr_child VARCHAR2(3) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
2095:
2096:
2097: BEGIN

Line 2094: -- l_close_sr_child VARCHAR2(3) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');

2090: l_spl_excp VARCHAR2(3) := 'N';
2091: l_note_id NUMBER;
2092: l_note_err_msg VARCHAR2(240);
2093: l_validate_sr_close VARCHAR2(30) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
2094: -- l_close_sr_child VARCHAR2(3) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
2095:
2096:
2097: BEGIN
2098: -- Log the input parameters

Line 2302: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);

2298: l_note_title := FND_MESSAGE.GET;
2299:
2300: -- Get the note type and status from the profile option
2301:
2302: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);
2303: FND_PROFILE.Get('CS_SR_ERES_COMMENT_NOTE_TYPE',l_note_type);
2304:
2305: FOR i IN 1..l_signatures_tbl.COUNT
2306: LOOP

Line 2303: FND_PROFILE.Get('CS_SR_ERES_COMMENT_NOTE_TYPE',l_note_type);

2299:
2300: -- Get the note type and status from the profile option
2301:
2302: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);
2303: FND_PROFILE.Get('CS_SR_ERES_COMMENT_NOTE_TYPE',l_note_type);
2304:
2305: FOR i IN 1..l_signatures_tbl.COUNT
2306: LOOP
2307: -- Retrive the signer's comment from the signature details.

Line 2391: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);

2387: l_note_title := FND_MESSAGE.GET;
2388:
2389: -- Get the note type and status from the profile option
2390:
2391: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);
2392: FND_PROFILE.Get('CS_SR_ERES_COMMENT_NOTE_TYPE',l_note_type);
2393:
2394: l_notes_table(q).NOTE := l_note_title||l_chr_newline ;
2395: l_notes_table(q).NOTE_DETAIL := l_note_title||l_chr_newline||l_sig_status ;

Line 2392: FND_PROFILE.Get('CS_SR_ERES_COMMENT_NOTE_TYPE',l_note_type);

2388:
2389: -- Get the note type and status from the profile option
2390:
2391: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);
2392: FND_PROFILE.Get('CS_SR_ERES_COMMENT_NOTE_TYPE',l_note_type);
2393:
2394: l_notes_table(q).NOTE := l_note_title||l_chr_newline ;
2395: l_notes_table(q).NOTE_DETAIL := l_note_title||l_chr_newline||l_sig_status ;
2396: l_notes_table(q).NOTE_TYPE := l_note_type;