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 BIS_CUSTOM_RELATED_LINKS_V

Line 1027: FROM bis_custom_related_links_v

1023:
1024: CURSOR displaySequence_site (p_site_id IN VARCHAR2, p_function_id IN VARCHAR2)
1025: IS
1026: SELECT max(NVL(display_sequence, 0)) + 1
1027: FROM bis_custom_related_links_v
1028: WHERE level_site_id = p_site_id
1029: AND function_id = p_function_id;
1030:
1031: CURSOR displaySequence_resp (p_resp_id IN VARCHAR2, p_function_id IN VARCHAR2)

Line 1034: FROM bis_custom_related_links_v

1030:
1031: CURSOR displaySequence_resp (p_resp_id IN VARCHAR2, p_function_id IN VARCHAR2)
1032: IS
1033: SELECT max(NVL(display_sequence, 0)) + 1
1034: FROM bis_custom_related_links_v
1035: WHERE level_responsibility_id = p_resp_id
1036: AND function_id = p_function_id;
1037:
1038: CURSOR displaySequence_app (p_app_id IN VARCHAR2, p_function_id IN VARCHAR2)

Line 1041: FROM bis_custom_related_links_v

1037:
1038: CURSOR displaySequence_app (p_app_id IN VARCHAR2, p_function_id IN VARCHAR2)
1039: IS
1040: SELECT max(NVL(display_sequence, 0)) + 1
1041: FROM bis_custom_related_links_v
1042: WHERE level_application_id = p_app_id
1043: AND function_id = p_function_id;
1044:
1045: CURSOR displaySequence_org (p_org_id IN VARCHAR2, p_function_id IN VARCHAR2)

Line 1048: FROM bis_custom_related_links_v

1044:
1045: CURSOR displaySequence_org (p_org_id IN VARCHAR2, p_function_id IN VARCHAR2)
1046: IS
1047: SELECT max(NVL(display_sequence, 0)) + 1
1048: FROM bis_custom_related_links_v
1049: WHERE level_org_id = p_org_id
1050: AND function_id = p_function_id;
1051:
1052: CURSOR displaySequence_function (p_level_function_id IN VARCHAR2, p_function_id IN VARCHAR2)

Line 1055: FROM bis_custom_related_links_v

1051:
1052: CURSOR displaySequence_function (p_level_function_id IN VARCHAR2, p_function_id IN VARCHAR2)
1053: IS
1054: SELECT max(NVL(display_sequence, 0)) + 1
1055: FROM bis_custom_related_links_v
1056: WHERE level_function_id = p_level_function_id
1057: AND function_id = p_function_id;
1058:
1059: CURSOR displaySequence_user (p_user_id IN VARCHAR2, p_function_id IN VARCHAR2)

Line 1062: FROM bis_custom_related_links_v

1058:
1059: CURSOR displaySequence_user (p_user_id IN VARCHAR2, p_function_id IN VARCHAR2)
1060: IS
1061: SELECT max(NVL(display_sequence, 0)) + 1
1062: FROM bis_custom_related_links_v
1063: WHERE level_user_id = p_user_id
1064: AND function_id = p_function_id;
1065:
1066: CURSOR displaySequence_seed (p_user_id IN VARCHAR2, p_function_id IN VARCHAR2, p_function_id2 IN VARCHAR2)

Line 1301: from bis_custom_related_links_v

1297:
1298: l_index := 0;
1299: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - custom table
1300: select max(NVL(display_sequence,0)) + 1 into l_index
1301: from bis_custom_related_links_v
1302: where level_user_id = p_user_id
1303: and function_id = p_function_id;
1304:
1305: select b.responsibility_application_id,

Line 1520: FROM bis_custom_related_links_v l

1516:
1517: cursor cr_sitelinks is
1518: SELECT l.display_sequence,l.user_link_name, l.function_id, l.responsibility_id, l.security_group_id,
1519: l.responsibility_application_id,l.linked_function_id, l.link_type,l.user_url
1520: FROM bis_custom_related_links_v l
1521: WHERE l.function_id = p_report_function_id
1522: AND l.level_site_id is not null;
1523:
1524: cursor cr_resplinks is

Line 1527: FROM bis_custom_related_links_v l

1523:
1524: cursor cr_resplinks is
1525: SELECT l.display_sequence,l.user_link_name, l.function_id, l.responsibility_id, l.security_group_id,
1526: l.responsibility_application_id,l.linked_function_id, l.link_type,l.user_url
1527: FROM bis_custom_related_links_v l
1528: WHERE l.function_id = p_report_function_id
1529: AND l.level_responsibility_id is not null;
1530:
1531: cursor cr_applinks is

Line 1534: FROM bis_custom_related_links_v l

1530:
1531: cursor cr_applinks is
1532: SELECT l.display_sequence,l.user_link_name, l.function_id, l.responsibility_id, l.security_group_id,
1533: l.responsibility_application_id,l.linked_function_id, l.link_type,l.user_url
1534: FROM bis_custom_related_links_v l
1535: WHERE l.function_id = p_report_function_id
1536: AND l.level_application_id is not null;
1537:
1538: cursor cr_orglinks is

Line 1541: FROM bis_custom_related_links_v l

1537:
1538: cursor cr_orglinks is
1539: SELECT l.display_sequence,l.user_link_name, l.function_id, l.responsibility_id, l.security_group_id,
1540: l.responsibility_application_id,l.linked_function_id, l.link_type,l.user_url
1541: FROM bis_custom_related_links_v l
1542: WHERE l.function_id = p_report_function_id
1543: AND l.level_org_id is not null;
1544:
1545: cursor cr_functionlinks is

Line 1548: FROM bis_custom_related_links_v l

1544:
1545: cursor cr_functionlinks is
1546: SELECT l.display_sequence,l.user_link_name, l.function_id, l.responsibility_id, l.security_group_id,
1547: l.responsibility_application_id,l.linked_function_id, l.link_type,l.user_url
1548: FROM bis_custom_related_links_v l
1549: WHERE l.function_id = p_report_function_id
1550: AND l.level_function_id is not null;
1551:
1552:

Line 1803: from bis_custom_related_links_vl

1799: BEGIN
1800:
1801: select sum(level_user_id), sum(level_function_id), sum(level_application_id), sum(level_org_id), sum(level_responsibility_id),sum(level_site_id)
1802: into l_user_level, l_function_level, l_app_level, l_org_level, l_resp_level, l_site_level
1803: from bis_custom_related_links_vl
1804: where function_id = p_function_id;
1805:
1806: if (p_custom_level = CUSTOM_USER_LEVEL) then
1807: if (l_function_level is not null) then

Line 2304: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - Changed to bis_custom_related_Links_v

2300: end if;
2301: end loop;
2302:
2303: --user_function_name should be used for the Prompt -ansingh
2304: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - Changed to bis_custom_related_Links_v
2305: p_funcn_sql := ' SELECT mev.function_id AS FunctionId,
2306: fff.user_function_name AS Prompt,
2307: nvl(fff.description, nvl(mev.description, mev.prompt)) AS Description,
2308: ''N'' as DummySelect,

Line 2341: from bis_custom_related_Links_v rl

2337: AND lower(fff.user_function_name) like lower(''' || p_search_criteria || '''';
2338: p_bind_string := p_bind_string || ',' || l_menu_criteria;
2339: p_funcn_sql := p_funcn_sql || ')
2340: AND mev.function_id in (select linked_function_id
2341: from bis_custom_related_Links_v rl
2342: where level_user_id = :' || l_bind_count;
2343: p_bind_string := p_bind_string || ',' || p_user_id;
2344: l_bind_count := l_bind_count + 1;
2345: p_funcn_sql := p_funcn_sql || ' and responsibility_id = :' || l_bind_count;

Line 2389: from bis_custom_related_Links_v rl

2385: AND lower(fff.user_function_name) like lower(''' || p_search_criteria || '''';
2386: p_bind_string := p_bind_string || ',' || l_menu_criteria;
2387: p_funcn_sql := p_funcn_sql || ')
2388: AND mev.function_id not in (select linked_function_id
2389: from bis_custom_related_Links_v rl
2390: where level_user_id = :' || l_bind_count;
2391: p_bind_string := p_bind_string || ',' || p_user_id;
2392: l_bind_count := l_bind_count + 1;
2393: p_funcn_sql := p_funcn_sql || ' and responsibility_id = :' || l_bind_count;

Line 2512: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - Changed to bis_custom_related_Links_v

2508:
2509: end loop;
2510:
2511: --user_function_name should be used for the Prompt -ansingh
2512: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - Changed to bis_custom_related_Links_v
2513: p_funcn_sql := ' select mev.function_id as FunctionId,
2514: fff.user_function_name AS Prompt,
2515: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2516: ''N'' as DummySelect,

Line 2548: from bis_custom_related_Links_v rl

2544: p_bind_string := p_bind_string || ',' || p_search_criteria;
2545: l_bind_count := l_bind_count + 1;
2546: p_funcn_sql := p_funcn_sql || ')
2547: and mev.function_id in (select linked_function_id
2548: from bis_custom_related_Links_v rl
2549: where level_user_id = :' || l_bind_count;
2550: p_bind_string := p_bind_string || ',' || p_user_id;
2551: l_bind_count := l_bind_count + 1;
2552: p_funcn_sql := p_funcn_sql || ' and responsibility_id in ( ';

Line 2604: from bis_custom_related_Links_v rl

2600: p_bind_string := p_bind_string || ',' || p_search_criteria;
2601: l_bind_count := l_bind_count + 1;
2602: p_funcn_sql := p_funcn_sql || ')
2603: and mev.function_id not in (select linked_function_id
2604: from bis_custom_related_Links_v rl
2605: where level_user_id = :' || l_bind_count;
2606: p_bind_string := p_bind_string || ',' || p_user_id;
2607: l_bind_count := l_bind_count + 1;
2608: p_funcn_sql := p_funcn_sql || ' and responsibility_id in ( ';

Line 2756: FROM BIS_CUSTOM_RELATED_LINKS_V rl

2752: AND LOWER(NVL(mev.prompt, fff.function_name)) LIKE LOWER(''' || p_search_criteria || '''';
2753: p_funcn_sql := p_funcn_sql || ')
2754: AND mev.function_id IN (
2755: SELECT linked_function_id
2756: FROM BIS_CUSTOM_RELATED_LINKS_V rl
2757: WHERE level_user_id = :';
2758: p_funcn_sql := p_funcn_sql || l_bind_count;
2759: l_bind_count := l_bind_count + 1;
2760: p_bind_string := p_bind_string || ',' || p_user_id;

Line 2809: FROM BIS_CUSTOM_RELATED_LINKS_V rl

2805: AND LOWER(NVL(mev.prompt, fff.function_name)) LIKE LOWER(''' || p_search_criteria || '''';
2806: p_funcn_sql := p_funcn_sql || ')
2807: AND mev.function_id NOT IN (
2808: SELECT linked_function_id
2809: FROM BIS_CUSTOM_RELATED_LINKS_V rl
2810: WHERE level_user_id = :';
2811: p_funcn_sql := p_funcn_sql || l_bind_count;
2812: l_bind_count := l_bind_count + 1;
2813: p_bind_string := p_bind_string || ',' || p_user_id;

Line 2957: from bis_custom_related_Links_v rl

2953: l_bind_count := l_bind_count + 1;
2954: p_bind_string := p_bind_string || ',' || p_search_criteria;
2955: p_funcn_sql := p_funcn_sql || ')
2956: and mev.function_id in (select linked_function_id
2957: from bis_custom_related_Links_v rl
2958: where level_user_id = :';
2959: p_funcn_sql := p_funcn_sql || l_bind_count;
2960: l_bind_count := l_bind_count + 1;
2961: p_bind_string := p_bind_string || ',' || p_user_id;

Line 3012: from bis_custom_related_Links_v rl

3008: l_bind_count := l_bind_count + 1;
3009: p_bind_string := p_bind_string || ',' || p_search_criteria;
3010: p_funcn_sql := p_funcn_sql || ')
3011: and mev.function_id not in (select linked_function_id
3012: from bis_custom_related_Links_v rl
3013: where level_user_id = :';
3014: p_funcn_sql := p_funcn_sql || l_bind_count;
3015: l_bind_count := l_bind_count + 1;
3016: p_bind_string := p_bind_string || ',' || p_user_id;