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.

[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on FND_PROFILE

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

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

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

426: l_errm VARCHAR2(100);
427: l_msg VARCHAR2(250);
428:
429: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
430: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
431: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
432: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
433:
434: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349

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

427: l_msg VARCHAR2(250);
428:
429: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
430: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
431: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
432: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
433:
434: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
435: Select timezone_code

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

428:
429: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
430: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
431: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
432: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
433:
434: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
435: Select timezone_code
436: From fnd_timezones_b

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

740: AND FLP.lookup_code = JNB.note_status
741: AND JNB.source_object_code = 'SR'
742: AND JNB.source_object_id = x_incident_id
743: AND ((JNB.note_status <> 'P') OR
744: (JNB.note_status = 'P' and JNB.created_by = fnd_profile.value_wnps('USER_ID') ))
745: AND JNB.created_by = fnd1.user_id
746: AND ext_userb.user_id (+) = fnd1.user_id
747: AND ext_usert.language (+)= userenv('LANG')
748: AND ext_userb.resource_id = ext_usert.resource_id (+)

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

888: xmldoc CLOB;
889: pass BOOLEAN;
890: l_query VARCHAR2(32000) := null;
891: l_api_name VARCHAR2(40) := 'Generate_XML_Document';
892: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
893: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
894: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
895: --l_display_timezone_id VARCHAR2(15);
896: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';

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

889: pass BOOLEAN;
890: l_query VARCHAR2(32000) := null;
891: l_api_name VARCHAR2(40) := 'Generate_XML_Document';
892: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
893: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
894: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
895: --l_display_timezone_id VARCHAR2(15);
896: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
897: l_ext_rec_count NUMBER;

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

890: l_query VARCHAR2(32000) := null;
891: l_api_name VARCHAR2(40) := 'Generate_XML_Document';
892: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
893: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
894: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
895: --l_display_timezone_id VARCHAR2(15);
896: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
897: l_ext_rec_count NUMBER;
898:

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

892: l_server_timezone_id VARCHAR2(15) := fnd_profile.value('SERVER_TIMEZONE_ID');
893: l_client_timezone_id VARCHAR2(15) := fnd_profile.value('CLIENT_TIMEZONE_ID');
894: l_timezone_enabled VARCHAR2(2) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
895: --l_display_timezone_id VARCHAR2(15);
896: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
897: l_ext_rec_count NUMBER;
898:
899: --New Cursors and Vars
900:

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

2174: l_api_name VARCHAR2(240) := 'Post_Approval_Process';
2175: l_spl_excp VARCHAR2(3) := 'N';
2176: l_note_id NUMBER;
2177: l_note_err_msg VARCHAR2(240);
2178: l_validate_sr_close VARCHAR2(30) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
2179: -- l_close_sr_child VARCHAR2(3) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
2180: --Bug 9879799
2181: l_approver_code VARCHAR2(240);
2182: l_action_code VARCHAR2(240);

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

2175: l_spl_excp VARCHAR2(3) := 'N';
2176: l_note_id NUMBER;
2177: l_note_err_msg VARCHAR2(240);
2178: l_validate_sr_close VARCHAR2(30) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
2179: -- l_close_sr_child VARCHAR2(3) := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
2180: --Bug 9879799
2181: l_approver_code VARCHAR2(240);
2182: l_action_code VARCHAR2(240);
2183: l_comment_code VARCHAR2(240);

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: FOR i IN 1..l_signatures_tbl.COUNT
2395: LOOP

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: FOR i IN 1..l_signatures_tbl.COUNT
2395: LOOP
2396: -- Retrive the signer's comment from the signature details.

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

2481: l_note_title := FND_MESSAGE.GET;
2482:
2483: -- Get the note type and status from the profile option
2484:
2485: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);
2486: FND_PROFILE.Get('CS_SR_ERES_COMMENT_NOTE_TYPE',l_note_type);
2487:
2488: l_notes_table(q).NOTE := l_note_title||l_chr_newline ;
2489: l_notes_table(q).NOTE_DETAIL := l_note_title||l_chr_newline||l_sig_status ;

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

2482:
2483: -- Get the note type and status from the profile option
2484:
2485: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);
2486: FND_PROFILE.Get('CS_SR_ERES_COMMENT_NOTE_TYPE',l_note_type);
2487:
2488: l_notes_table(q).NOTE := l_note_title||l_chr_newline ;
2489: l_notes_table(q).NOTE_DETAIL := l_note_title||l_chr_newline||l_sig_status ;
2490: l_notes_table(q).NOTE_TYPE := l_note_type;