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

Line 66: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

62: ) IS
63:
64: l_api_name VARCHAR2(255):='createOutboxMessage';
65: l_api_version_number NUMBER:=1.0;
66: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
67: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
68: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
69:
70: l_return_status VARCHAR2(300);

Line 67: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

63:
64: l_api_name VARCHAR2(255):='createOutboxMessage';
65: l_api_version_number NUMBER:=1.0;
66: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
67: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
68: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
69:
70: l_return_status VARCHAR2(300);
71: l_msg_count NUMBER;

Line 68: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

64: l_api_name VARCHAR2(255):='createOutboxMessage';
65: l_api_version_number NUMBER:=1.0;
66: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
67: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
68: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
69:
70: l_return_status VARCHAR2(300);
71: l_msg_count NUMBER;
72: l_msg_data VARCHAR2(300);

Line 282: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

278: ) IS
279:
280: l_api_name VARCHAR2(255):='cancelOutboxMessage';
281: l_api_version_number NUMBER:=1.0;
282: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
283: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
284:
285: l_return_status VARCHAR2(300);
286: l_msg_count NUMBER;

Line 283: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

279:
280: l_api_name VARCHAR2(255):='cancelOutboxMessage';
281: l_api_version_number NUMBER:=1.0;
282: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
283: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
284:
285: l_return_status VARCHAR2(300);
286: l_msg_count NUMBER;
287: l_msg_data VARCHAR2(300);

Line 377: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

373: ) IS
374:
375: l_api_name VARCHAR2(255):='submitOutboxMessage';
376: l_api_version_number NUMBER:=1.0;
377: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
378: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
379:
380: l_return_status VARCHAR2(300);
381: l_msg_count NUMBER;

Line 378: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

374:
375: l_api_name VARCHAR2(255):='submitOutboxMessage';
376: l_api_version_number NUMBER:=1.0;
377: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
378: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
379:
380: l_return_status VARCHAR2(300);
381: l_msg_count NUMBER;
382: l_msg_data VARCHAR2(300);

Line 510: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

506: ) IS
507:
508: l_api_name VARCHAR2(255):='writeOutboxError';
509: l_api_version_number NUMBER:=1.0;
510: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
511: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
512:
513: l_error_id NUMBER;
514: l_return_status VARCHAR2(300);

Line 511: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

507:
508: l_api_name VARCHAR2(255):='writeOutboxError';
509: l_api_version_number NUMBER:=1.0;
510: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
511: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
512:
513: l_error_id NUMBER;
514: l_return_status VARCHAR2(300);
515: l_msg_count NUMBER;

Line 614: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

610: x_msg_data OUT NOCOPY VARCHAR2
611: ) IS
612: l_api_name VARCHAR2(255):='createAutoReply';
613: l_api_version_number NUMBER:=1.0;
614: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
615: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
616: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
617:
618: l_return_status VARCHAR2(300);

Line 615: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

611: ) IS
612: l_api_name VARCHAR2(255):='createAutoReply';
613: l_api_version_number NUMBER:=1.0;
614: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
615: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
616: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
617:
618: l_return_status VARCHAR2(300);
619: l_msg_count NUMBER;

Line 616: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

612: l_api_name VARCHAR2(255):='createAutoReply';
613: l_api_version_number NUMBER:=1.0;
614: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
615: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
616: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
617:
618: l_return_status VARCHAR2(300);
619: l_msg_count NUMBER;
620: l_msg_data VARCHAR2(300);

Line 1282: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1278: ) IS
1279:
1280: l_api_name VARCHAR2(255):='getAccountList';
1281: l_api_version_number NUMBER:=1.0;
1282: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1283: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1284:
1285: l_return_status VARCHAR2(300);
1286: l_msg_count NUMBER;

Line 1283: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

1279:
1280: l_api_name VARCHAR2(255):='getAccountList';
1281: l_api_version_number NUMBER:=1.0;
1282: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1283: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1284:
1285: l_return_status VARCHAR2(300);
1286: l_msg_count NUMBER;
1287: l_msg_data VARCHAR2(300);

Line 1388: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1384: ) IS
1385:
1386: l_api_name VARCHAR2(255):='redirectMessage';
1387: l_api_version_number NUMBER:=1.0;
1388: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1389: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1390: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1391:
1392: IEM_NO_DATA EXCEPTION;

Line 1389: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1385:
1386: l_api_name VARCHAR2(255):='redirectMessage';
1387: l_api_version_number NUMBER:=1.0;
1388: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1389: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1390: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1391:
1392: IEM_NO_DATA EXCEPTION;
1393: l_email_acct_id NUMBER;

Line 1390: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

1386: l_api_name VARCHAR2(255):='redirectMessage';
1387: l_api_version_number NUMBER:=1.0;
1388: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1389: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1390: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1391:
1392: IEM_NO_DATA EXCEPTION;
1393: l_email_acct_id NUMBER;
1394: l_classification_id NUMBER;

Line 1555: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1551: )
1552: IS
1553: l_api_name VARCHAR2(255):='autoForward';
1554: l_api_version_number NUMBER:=1.0;
1555: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1556: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1557: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1558:
1559: l_return_status VARCHAR2(300);

Line 1556: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1552: IS
1553: l_api_name VARCHAR2(255):='autoForward';
1554: l_api_version_number NUMBER:=1.0;
1555: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1556: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1557: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1558:
1559: l_return_status VARCHAR2(300);
1560: l_msg_count NUMBER;

Line 1557: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

1553: l_api_name VARCHAR2(255):='autoForward';
1554: l_api_version_number NUMBER:=1.0;
1555: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1556: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1557: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1558:
1559: l_return_status VARCHAR2(300);
1560: l_msg_count NUMBER;
1561: l_msg_data VARCHAR2(300);

Line 1866: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1862: x_msg_data OUT NOCOPY VARCHAR2
1863: ) IS
1864: l_api_name VARCHAR2(255):='createSRAutoNotification';
1865: l_api_version_number NUMBER:=1.0;
1866: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1867: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1868: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1869:
1870: l_return_status VARCHAR2(300);

Line 1867: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1863: ) IS
1864: l_api_name VARCHAR2(255):='createSRAutoNotification';
1865: l_api_version_number NUMBER:=1.0;
1866: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1867: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1868: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1869:
1870: l_return_status VARCHAR2(300);
1871: l_msg_count NUMBER;

Line 1868: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

1864: l_api_name VARCHAR2(255):='createSRAutoNotification';
1865: l_api_version_number NUMBER:=1.0;
1866: l_created_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1867: l_last_updated_by NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1868: l_last_update_login NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1869:
1870: l_return_status VARCHAR2(300);
1871: l_msg_count NUMBER;
1872: l_msg_data VARCHAR2(300);