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_AGENT_ACT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 257: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

253: l_api_version_number NUMBER:=1.0;
254: l_return_status varchar2(10);
255: l_msg_count number;
256: l_msg_data varchar2(255);
257: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
258: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
259: l_res_name varchar2(720);
260: l_resource_param_value_id NUMBER;
261: l_agent_account_count NUMBER;

Line 258: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

254: l_return_status varchar2(10);
255: l_msg_count number;
256: l_msg_data varchar2(255);
257: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
258: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
259: l_res_name varchar2(720);
260: l_resource_param_value_id NUMBER;
261: l_agent_account_count NUMBER;
262: l_error_agent_count NUMBER:=0;

Line 290: FROM JTF_RS_RESOURCE_EXTNS

286: FOR i in 1..p_in_resource_tbl.count() LOOP
287:
288: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
289: INTO l_user_id, l_user_name, l_res_name
290: FROM JTF_RS_RESOURCE_EXTNS
291: WHERE RESOURCE_ID = p_in_resource_tbl(i);
292:
293:
294: -- Check if the agent account already exist. If exist, skip and fetch next resource id in the loop

Line 444: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

440: l_api_version_number NUMBER:=1.0;
441: l_return_status varchar2(10);
442: l_msg_count number;
443: l_msg_data varchar2(255);
444: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
445: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
446: l_agntacct varchar2(160);
447: l_res_name varchar2(720);
448: l_error_username varchar2(32000);

Line 445: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

441: l_return_status varchar2(10);
442: l_msg_count number;
443: l_msg_data varchar2(255);
444: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
445: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
446: l_agntacct varchar2(160);
447: l_res_name varchar2(720);
448: l_error_username varchar2(32000);
449: l_error_username1 varchar2(32000);

Line 491: FROM JTF_RS_RESOURCE_EXTNS

487: FOR i in 1..p_out_resource_tbl.count() LOOP
488:
489: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
490: INTO l_user_id, l_user_name, l_res_name
491: FROM JTF_RS_RESOURCE_EXTNS
492: WHERE RESOURCE_ID = p_out_resource_tbl(i);
493:
494:
495: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop

Line 818: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

814: l_return_status varchar2(10);
815: l_msg_count number;
816: l_msg_data varchar2(255);
817: l_email_user IEM_MSTEMAIL_ACCOUNTS.USER_NAME%TYPE;
818: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
819: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
820: l_agntacct varchar2(160);
821: l_res_name varchar2(720);
822: l_resource_param_value_id NUMBER;

Line 819: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

815: l_msg_count number;
816: l_msg_data varchar2(255);
817: l_email_user IEM_MSTEMAIL_ACCOUNTS.USER_NAME%TYPE;
818: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
819: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
820: l_agntacct varchar2(160);
821: l_res_name varchar2(720);
822: l_resource_param_value_id NUMBER;
823: l_agent_account_count NUMBER;

Line 854: FROM JTF_RS_RESOURCE_EXTNS

850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851:
852: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
853: INTO l_user_id, l_user_name, l_res_name
854: FROM JTF_RS_RESOURCE_EXTNS
855: WHERE RESOURCE_ID = p_resource_id;
856:
857: if (l_user_name is null or l_user_name = '') then
858: raise USER_NULL_ERROR;

Line 862: FROM jtf_rs_resource_extns

858: raise USER_NULL_ERROR;
859: end if;
860:
861: SELECT count(*) into l_count
862: FROM jtf_rs_resource_extns
863: WHERE resource_id = p_resource_id
864: AND ( end_date_active is null OR
865: trunc(end_date_active) >= trunc(sysdate) );
866:

Line 1046: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

1042: l_return_status varchar2(10);
1043: l_msg_count number;
1044: l_msg_data varchar2(255);
1045: l_email_user IEM_MSTEMAIL_ACCOUNTS.USER_NAME%TYPE;
1046: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
1047: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
1048: l_agntacct varchar2(160);
1049: l_res_name varchar2(720);
1050: l_error_email_user varchar2(32000);

Line 1047: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

1043: l_msg_count number;
1044: l_msg_data varchar2(255);
1045: l_email_user IEM_MSTEMAIL_ACCOUNTS.USER_NAME%TYPE;
1046: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
1047: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
1048: l_agntacct varchar2(160);
1049: l_res_name varchar2(720);
1050: l_error_email_user varchar2(32000);
1051: l_error_email_user1 varchar2(32000);

Line 1089: FROM JTF_RS_RESOURCE_EXTNS

1085: x_return_status := FND_API.G_RET_STS_SUCCESS;
1086:
1087: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
1088: INTO l_user_id, l_user_name, l_res_name
1089: FROM JTF_RS_RESOURCE_EXTNS
1090: WHERE RESOURCE_ID = p_resource_id;
1091:
1092: FOR i in 1..p_out_email_account_tbl.count() LOOP
1093:

Line 1429: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

1425: l_api_version_number NUMBER:=1.0;
1426: l_return_status varchar2(10);
1427: l_msg_count number;
1428: l_msg_data varchar2(255);
1429: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
1430: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
1431: l_agntacct varchar2(160);
1432: l_res_name varchar2(720);
1433: l_error_username varchar2(32000);

Line 1430: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

1426: l_return_status varchar2(10);
1427: l_msg_count number;
1428: l_msg_data varchar2(255);
1429: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
1430: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
1431: l_agntacct varchar2(160);
1432: l_res_name varchar2(720);
1433: l_error_username varchar2(32000);
1434: l_error_username1 varchar2(32000);

Line 1476: FROM JTF_RS_RESOURCE_EXTNS

1472: FOR i in 1..p_in_cherrypick_tbl.count() LOOP
1473:
1474: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
1475: INTO l_user_id, l_user_name, l_res_name
1476: FROM JTF_RS_RESOURCE_EXTNS
1477: WHERE RESOURCE_ID = p_in_cherrypick_tbl(i);
1478:
1479:
1480: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop

Line 1518: FROM JTF_RS_RESOURCE_EXTNS

1514: FOR i in 1..p_out_cherrypick_tbl.count() LOOP
1515:
1516: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
1517: INTO l_user_id, l_user_name, l_res_name
1518: FROM JTF_RS_RESOURCE_EXTNS
1519: WHERE RESOURCE_ID = p_out_cherrypick_tbl(i);
1520:
1521:
1522: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop

Line 1616: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

1612: l_api_version_number NUMBER:=1.0;
1613: l_return_status varchar2(10);
1614: l_msg_count number;
1615: l_msg_data varchar2(255);
1616: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
1617: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
1618: l_agntacct varchar2(160);
1619: l_res_name varchar2(720);
1620: l_error_username varchar2(32000);

Line 1617: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

1613: l_return_status varchar2(10);
1614: l_msg_count number;
1615: l_msg_data varchar2(255);
1616: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
1617: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
1618: l_agntacct varchar2(160);
1619: l_res_name varchar2(720);
1620: l_error_username varchar2(32000);
1621: l_error_username1 varchar2(32000);

Line 1663: FROM JTF_RS_RESOURCE_EXTNS

1659: FOR i in 1..p_in_acct_chrypick_tbl.count() LOOP
1660:
1661: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
1662: INTO l_user_id, l_user_name, l_res_name
1663: FROM JTF_RS_RESOURCE_EXTNS
1664: WHERE RESOURCE_ID = p_resource_id;
1665:
1666:
1667: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop

Line 1705: FROM JTF_RS_RESOURCE_EXTNS

1701: FOR i in 1..p_out_acct_chrypick_tbl.count() LOOP
1702:
1703: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
1704: INTO l_user_id, l_user_name, l_res_name
1705: FROM JTF_RS_RESOURCE_EXTNS
1706: WHERE RESOURCE_ID = p_resource_id;
1707:
1708:
1709: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop