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_MAILITEM_PUB dependencies on FND_PROFILE

Line 700: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

696: IF x_email_data.ih_interaction_id is not null then -- updating interaction with resource id
697: l_interaction_rec.interaction_id:=x_email_data.ih_interaction_id;
698: l_interaction_rec.resource_id:=p_resource_id;
699: JTF_IH_PUB.Update_Interaction( p_api_version => 1.0,
700: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
701: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
702: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
703: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
704: x_return_status => l_ret_status,

Line 701: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

697: l_interaction_rec.interaction_id:=x_email_data.ih_interaction_id;
698: l_interaction_rec.resource_id:=p_resource_id;
699: JTF_IH_PUB.Update_Interaction( p_api_version => 1.0,
700: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
701: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
702: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
703: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
704: x_return_status => l_ret_status,
705: x_msg_count => l_msg_count,

Line 702: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

698: l_interaction_rec.resource_id:=p_resource_id;
699: JTF_IH_PUB.Update_Interaction( p_api_version => 1.0,
700: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
701: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
702: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
703: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
704: x_return_status => l_ret_status,
705: x_msg_count => l_msg_count,
706: x_msg_data => l_msg_data,

Line 703: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

699: JTF_IH_PUB.Update_Interaction( p_api_version => 1.0,
700: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
701: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
702: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
703: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
704: x_return_status => l_ret_status,
705: x_msg_count => l_msg_count,
706: x_msg_data => l_msg_data,
707: p_interaction_rec => l_interaction_rec

Line 807: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

803: l_media_rec.media_data := l_media_data.media_data;
804: JTF_IH_PUB.Close_MediaItem( 1.0,
805: 'T',
806: 'F',
807: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
808: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
809: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
810: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
811: l_ret_status,

Line 808: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

804: JTF_IH_PUB.Close_MediaItem( 1.0,
805: 'T',
806: 'F',
807: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
808: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
809: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
810: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
811: l_ret_status,
812: l_msg_count,

Line 809: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

805: 'T',
806: 'F',
807: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
808: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
809: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
810: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
811: l_ret_status,
812: l_msg_count,
813: l_msg_data,

Line 810: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

806: 'F',
807: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
808: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
809: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
810: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
811: l_ret_status,
812: l_msg_count,
813: l_msg_data,
814: l_media_rec);

Line 962: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

958: x_msg_data OUT NOCOPY VARCHAR2) IS
959:
960: l_api_name VARCHAR2(255):='UpdateMailItem';
961: l_api_version_number NUMBER:=1.0;
962: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
963: l_LAST_UPDATE_DATE DATE:=SYSDATE;
964: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
965:
966: BEGIN

Line 964: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

960: l_api_name VARCHAR2(255):='UpdateMailItem';
961: l_api_version_number NUMBER:=1.0;
962: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
963: l_LAST_UPDATE_DATE DATE:=SYSDATE;
964: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
965:
966: BEGIN
967: -- Standard call to check for call compatibility.
968: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1467: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

1463: l_media_rec.media_data := l_media_data.media_data;
1464: JTF_IH_PUB.Close_MediaItem( 1.0,
1465: 'T',
1466: 'F',
1467: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
1468: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
1469: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
1470: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1471: l_ret_status,

Line 1468: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

1464: JTF_IH_PUB.Close_MediaItem( 1.0,
1465: 'T',
1466: 'F',
1467: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
1468: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
1469: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
1470: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1471: l_ret_status,
1472: l_msg_count,

Line 1469: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

1465: 'T',
1466: 'F',
1467: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
1468: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
1469: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
1470: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1471: l_ret_status,
1472: l_msg_count,
1473: l_msg_data,

Line 1470: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

1466: 'F',
1467: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
1468: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
1469: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
1470: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1471: l_ret_status,
1472: l_msg_count,
1473: l_msg_data,
1474: l_media_rec);