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.BIS_RL_PKG dependencies on FND_RESPONSIBILITY

Line 81: -- | from fnd_responsibility |

77: -- | 09-AUG-04 mdamle Bug# 3816889 - Insert custom link for inst. lang|
78: -- | 09-AUG-04 mdamle Bug# 3813449 - New API to copy links to dup. rpt|
79: -- | 30-MAR-05 ankagarw Bug# 4251673 - Changed addRelatedlink_Wrapper |
80: -- | If customLevel is null then getting security group id |
81: -- | from fnd_responsibility |
82: -- | 06-APR-05 ankagarw Bug# 4284816 - Changed addRelatedlink_Wrapper |
83: -- | added NVL condition for the resp_id, |
84: -- | security group id, resp application id |
85: -- | 25-MAR-2005 ankagarw bug#4392370 - Removed SECURITY_GROUP_ID |

Line 487: from fnd_responsibility_vl

483: menu_id
484: into l_responsibility_name,
485: l_description,
486: l_menu_id
487: from fnd_responsibility_vl
488: where responsibility_id = p_object.responsibility_id
489: and application_id = p_object.resp_appl_id
490: -- remove version check to show all resp
491: --and version = 'W'

Line 1075: FROM fnd_responsibility

1071:
1072: CURSOR getDefaultVal (p_resp_id IN VARCHAR2)
1073: IS
1074: SELECT application_id
1075: FROM fnd_responsibility
1076: WHERE responsibility_id = p_resp_id;
1077:
1078:
1079: BEGIN

Line 1187: FROM fnd_responsibility_vl a,

1183: SELECT b.responsibility_application_id,
1184: b.security_group_id
1185: INTO l_resp_appl_id,
1186: l_security_group_id
1187: FROM fnd_responsibility_vl a,
1188: FND_USER_RESP_GROUPS b
1189: WHERE a.responsibility_id = p_resp_id
1190: AND b.user_id = p_user_id
1191: AND b.RESPONSIBILITY_id = a.responsibility_id

Line 1309: from fnd_responsibility_vl a,

1305: select b.responsibility_application_id,
1306: b.security_group_id
1307: into l_resp_appl_id,
1308: l_security_group_id
1309: from fnd_responsibility_vl a,
1310: FND_USER_RESP_GROUPS b
1311: where a.responsibility_id = p_resp_id
1312: and b.user_id = p_user_id
1313: and b.RESPONSIBILITY_id = a.responsibility_id

Line 1348: fnd_responsibility_vl a,

1344: b.responsibility_application_id,
1345: b.security_group_id,
1346: fsg.SECURITY_GROUP_NAME
1347: from FND_SECURITY_GROUPS_VL fsg,
1348: fnd_responsibility_vl a,
1349: FND_USER_RESP_GROUPS b
1350: where b.user_id = p_user_id
1351: and b.start_date <= sysdate
1352: and (b.end_date is null or b.end_date > sysdate)

Line 1393: p_resp_sql := 'select responsibility_id, responsibility_name from fnd_responsibility_vl where responsibility_id in ('

1389: end if;
1390: end loop;
1391:
1392: /*
1393: p_resp_sql := 'select responsibility_id, responsibility_name from fnd_responsibility_vl where responsibility_id in ('
1394: || l_resp_criteria || ') order by responsibility_name ';
1395: */
1396: --bugfix 3857066
1397: p_resp_sql := 'select a.responsibility_id, a.responsibility_name from fnd_responsibility_vl a, fnd_user_resp_groups b

Line 1397: p_resp_sql := 'select a.responsibility_id, a.responsibility_name from fnd_responsibility_vl a, fnd_user_resp_groups b

1393: p_resp_sql := 'select responsibility_id, responsibility_name from fnd_responsibility_vl where responsibility_id in ('
1394: || l_resp_criteria || ') order by responsibility_name ';
1395: */
1396: --bugfix 3857066
1397: p_resp_sql := 'select a.responsibility_id, a.responsibility_name from fnd_responsibility_vl a, fnd_user_resp_groups b
1398: where a.responsibility_id in ('|| l_resp_criteria || ')
1399: and b.user_id = '|| p_user_id ||' and b.RESPONSIBILITY_id = a.responsibility_id and b.responsibility_application_id = a.application_id order by responsibility_name ';
1400:
1401: end getRespSQLWrapper;

Line 2261: fnd_responsibility_vl a,

2257: l_object.resp_appl_id,
2258: l_object.security_group_id,
2259: l_menu_id
2260: from FND_SECURITY_GROUPS_VL fsg,
2261: fnd_responsibility_vl a,
2262: FND_USER_RESP_GROUPS b
2263: where a.responsibility_id = p_resp_id
2264: and b.user_id = p_user_id
2265: and b.start_date <= sysdate

Line 2460: fnd_responsibility_vl a,

2456: l_object.resp_appl_id,
2457: l_object.security_group_id,
2458: l_menu_id
2459: from FND_SECURITY_GROUPS_VL fsg,
2460: fnd_responsibility_vl a,
2461: FND_USER_RESP_GROUPS b
2462: where a.responsibility_id = l_id
2463: and b.user_id = p_user_id
2464: and b.start_date <= sysdate

Line 2678: fnd_responsibility_vl a,

2674: l_object.resp_appl_id,
2675: l_object.security_group_id,
2676: l_menu_id
2677: from FND_SECURITY_GROUPS_VL fsg,
2678: fnd_responsibility_vl a,
2679: FND_USER_RESP_GROUPS b
2680: where a.responsibility_id = p_resp_id
2681: and b.user_id = p_user_id
2682: and b.start_date <= sysdate

Line 2876: fnd_responsibility_vl a,

2872: l_object.resp_appl_id,
2873: l_object.security_group_id,
2874: l_menu_id
2875: from FND_SECURITY_GROUPS_VL fsg,
2876: fnd_responsibility_vl a,
2877: FND_USER_RESP_GROUPS b
2878: where a.responsibility_id = p_resp_id
2879: and b.user_id = p_user_id
2880: and b.start_date <= sysdate