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 DUAL

Line 735: select bis_related_links_s.nextval into l_related_link_id from dual;

731: IS
732: l_related_link_id number;
733: BEGIN
734:
735: select bis_related_links_s.nextval into l_related_link_id from dual;
736:
737:
738: insert into bis_custom_related_links
739: (related_link_id,

Line 840: select bis_related_links_s.nextval into l_related_link_id from dual;

836: IS
837: l_related_link_id number;
838: BEGIN
839:
840: select bis_related_links_s.nextval into l_related_link_id from dual;
841:
842: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - Changed to bis_custom_related_Links
843: insert into bis_related_links
844: (related_link_id,

Line 1620: select bis_related_links_s.nextval into l_related_link_id from dual;

1616: end if;
1617:
1618: if l_prev_level is null then
1619: for l in cr_seedlinks loop
1620: select bis_related_links_s.nextval into l_related_link_id from dual;
1621: insertCustomLinks( l_related_link_id, l.display_sequence, l_function_id, l.responsibility_id, l.security_group_id,
1622: l.responsibility_application_id, l.linked_function_id, l.link_type, l.user_url, l.user_link_name,
1623: l_level_site_id, l_level_resp_id, l_level_app_id, l_level_org_id, l_level_function_id, l_level_user_id, p_user_id);
1624: end loop;

Line 1628: select bis_related_links_s.nextval into l_related_link_id from dual;

1624: end loop;
1625: else
1626: if l_prev_level = CUSTOM_SITE_LEVEL then
1627: for l in cr_sitelinks loop
1628: select bis_related_links_s.nextval into l_related_link_id from dual;
1629: insertCustomLinks( l_related_link_id, l.display_sequence, l_function_id, l.responsibility_id, l.security_group_id,
1630: l.responsibility_application_id, l.linked_function_id, l.link_type, l.user_url, l.user_link_name,
1631: l_level_site_id, l_level_resp_id, l_level_app_id, l_level_org_id, l_level_function_id, l_level_user_id, p_user_id);
1632: end loop;

Line 1636: select bis_related_links_s.nextval into l_related_link_id from dual;

1632: end loop;
1633: else
1634: if l_prev_level = CUSTOM_RESP_LEVEL then
1635: for l in cr_resplinks loop
1636: select bis_related_links_s.nextval into l_related_link_id from dual;
1637: insertCustomLinks( l_related_link_id, l.display_sequence, l_function_id, l.responsibility_id, l.security_group_id,
1638: l.responsibility_application_id, l.linked_function_id, l.link_type, l.user_url, l.user_link_name,
1639: l_level_site_id, l_level_resp_id, l_level_app_id, l_level_org_id, l_level_function_id, l_level_user_id, p_user_id);
1640: end loop;

Line 1644: select bis_related_links_s.nextval into l_related_link_id from dual;

1640: end loop;
1641: else
1642: if l_prev_level = CUSTOM_ORG_LEVEL then
1643: for l in cr_orglinks loop
1644: select bis_related_links_s.nextval into l_related_link_id from dual;
1645: insertCustomLinks( l_related_link_id, l.display_sequence, l_function_id, l.responsibility_id, l.security_group_id,
1646: l.responsibility_application_id, l.linked_function_id, l.link_type, l.user_url, l.user_link_name,
1647: l_level_site_id, l_level_resp_id, l_level_app_id, l_level_org_id, l_level_function_id, l_level_user_id, p_user_id);
1648: end loop;

Line 1652: select bis_related_links_s.nextval into l_related_link_id from dual;

1648: end loop;
1649: else
1650: if l_prev_level = CUSTOM_APP_LEVEL then
1651: for l in cr_applinks loop
1652: select bis_related_links_s.nextval into l_related_link_id from dual;
1653: insertCustomLinks( l_related_link_id, l.display_sequence, l_function_id, l.responsibility_id, l.security_group_id,
1654: l.responsibility_application_id, l.linked_function_id, l.link_type, l.user_url, l.user_link_name,
1655: l_level_site_id, l_level_resp_id, l_level_app_id, l_level_org_id, l_level_function_id, l_level_user_id, p_user_id);
1656: end loop;

Line 1660: select bis_related_links_s.nextval into l_related_link_id from dual;

1656: end loop;
1657: else
1658: if l_prev_level = CUSTOM_FUNCTION_LEVEL then
1659: for l in cr_functionlinks loop
1660: select bis_related_links_s.nextval into l_related_link_id from dual;
1661: insertCustomLinks( l_related_link_id, l.display_sequence, l_function_id, l.responsibility_id, l.security_group_id,
1662: l.responsibility_application_id, l.linked_function_id, l.link_type,l.user_url,l.user_link_name,l_level_site_id,
1663: l_level_resp_id, l_level_app_id, l_level_org_id, l_level_function_id, l_level_user_id, p_user_id);
1664: end loop;

Line 2004: select bis_related_links_s.nextval into l_related_link_id from dual;

2000: l_related_link_id number;
2001:
2002: BEGIN
2003:
2004: select bis_related_links_s.nextval into l_related_link_id from dual;
2005: INSERT INTO BIS_RELATED_LINKS
2006: (RELATED_LINK_ID,
2007: CREATION_DATE,
2008: CREATED_BY,

Line 2037: FROM DUAL;

2033: p_resp_id,
2034: p_sec_grp_id,
2035: p_resp_app_id,
2036: p_display_sequence
2037: FROM DUAL;
2038:
2039: INSERT INTO bis_related_links_tl
2040: (related_link_id,
2041: user_link_name,