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.SR_UWQ_INTEG dependencies on CS_SR_UWQ_NODES_TL

Line 430: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

426: l_res_cat_enum_flag varchar2(1);
427:
428: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
429: data_source
430: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
431: where uwq_b.node_id = uwq_tl.node_id
432: and uwq_tl.language = userenv('LANG')
433: and parent_id = l_node_id
434: and node_query='CURSOR' and enabled_flag='Y';

Line 509: select node_label into l_node_label from cs_sr_uwq_nodes_tl

505:
506: l_node_counter := l_node_counter + 1;
507:
508: begin
509: select node_label into l_node_label from cs_sr_uwq_nodes_tl
510: where node_id=l_node_id and language=userenv('LANG');
511: exception
512: when NO_DATA_FOUND then
513: l_node_label:='Error: No Label ';

Line 562: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

558: select node_label,node_view,cursor_key_col,data_source,
559: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
560: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
561: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
562: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
563: where uwq_b.node_id = uwq_tl.node_id
564: and uwq_tl.language = userenv('LANG')
565: and parent_id = l_node_id and enabled_flag='Y'
566: and node_query = 'CURSOR' ;

Line 719: select node_label into l_node_label from cs_sr_uwq_nodes_tl

715:
716: l_node_counter := l_node_counter + 1;
717:
718: begin
719: select node_label into l_node_label from cs_sr_uwq_nodes_tl
720: where node_id=l_node_id and language=userenv('LANG');
721: exception
722: when NO_DATA_FOUND then
723: l_node_label:='Error: No Label ';

Line 754: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

750: , res_cat_enum_flag
751: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
752: l_node_query,l_cursor_sql,l_node_id
753: , l_res_cat_enum_flag
754: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
755: where uwq_b.node_id = uwq_tl.node_id
756: and uwq_tl.language = userenv('LANG')
757: and parent_id = l_node_id and enabled_flag='Y'
758: and node_query = 'CURSOR' ;

Line 1032: insert into cs_sr_uwq_nodes_tl

1028: p_last_updated_by,
1029: p_last_update_login,
1030: 1);
1031:
1032: insert into cs_sr_uwq_nodes_tl
1033: (node_id,
1034: node_label,
1035: creation_date,
1036: created_by,

Line 1116: update cs_sr_uwq_nodes_tl set

1112: last_update_login = p_last_update_login,
1113: object_version_number = p_object_version_number + 1
1114: where node_id = p_node_id;
1115:
1116: update cs_sr_uwq_nodes_tl set
1117: node_label = p_node_label,
1118: creation_date = p_creation_date,
1119: created_by = p_created_by,
1120: last_update_date = p_last_update_date,

Line 1948: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

1944: l_res_cat_enum_flag varchar2(1);
1945:
1946: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
1947: data_source
1948: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
1949: where uwq_b.node_id = uwq_tl.node_id
1950: and uwq_tl.language = userenv('LANG')
1951: and parent_id = l_node_id
1952: and node_query='CURSOR' and enabled_flag='Y';

Line 2028: select node_label into l_node_label from cs_sr_uwq_nodes_tl

2024:
2025: l_node_counter := l_node_counter + 1;
2026:
2027: begin
2028: select node_label into l_node_label from cs_sr_uwq_nodes_tl
2029: where node_id=l_node_id and language=userenv('LANG');
2030: exception
2031: when NO_DATA_FOUND then
2032: l_node_label:='Error: No Label ';

Line 2096: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2092: select node_label,node_view,cursor_key_col,data_source,
2093: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
2094: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
2095: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
2096: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2097: where uwq_b.node_id = uwq_tl.node_id
2098: and uwq_tl.language = userenv('LANG')
2099: and parent_id = l_node_id and enabled_flag='Y'
2100: and node_query = 'CURSOR' ;

Line 2285: select node_label into l_node_label from cs_sr_uwq_nodes_tl

2281:
2282: l_node_counter := l_node_counter + 1;
2283:
2284: begin
2285: select node_label into l_node_label from cs_sr_uwq_nodes_tl
2286: where node_id=l_node_id and language=userenv('LANG');
2287: exception
2288: when NO_DATA_FOUND then
2289: l_node_label:='Error: No Label ';

Line 2330: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2326: , res_cat_enum_flag
2327: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
2328: l_node_query,l_cursor_sql,l_node_id
2329: , l_res_cat_enum_flag
2330: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2331: where uwq_b.node_id = uwq_tl.node_id
2332: and uwq_tl.language = userenv('LANG')
2333: and parent_id = l_node_id and enabled_flag='Y'
2334: and node_query = 'CURSOR' ;

Line 2473: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2469: l_res_cat_enum_flag varchar2(1);
2470:
2471: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
2472: data_source
2473: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2474: where uwq_b.node_id = uwq_tl.node_id
2475: and uwq_tl.language = userenv('LANG')
2476: and parent_id = l_node_id
2477: and node_query='CURSOR' and enabled_flag='Y';

Line 2552: select node_label into l_node_label from cs_sr_uwq_nodes_tl

2548:
2549: l_node_counter := l_node_counter + 1;
2550:
2551: begin
2552: select node_label into l_node_label from cs_sr_uwq_nodes_tl
2553: where node_id=l_node_id and language=userenv('LANG');
2554: exception
2555: when NO_DATA_FOUND then
2556: l_node_label:='Error: No Label ';

Line 2617: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2613: select node_label,node_view,cursor_key_col,data_source,
2614: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
2615: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
2616: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
2617: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2618: where uwq_b.node_id = uwq_tl.node_id
2619: and uwq_tl.language = userenv('LANG')
2620: and parent_id = l_node_id and enabled_flag='Y'
2621: and node_query = 'CURSOR' ;

Line 2808: select node_label into l_node_label from cs_sr_uwq_nodes_tl

2804:
2805: l_node_counter := l_node_counter + 1;
2806:
2807: begin
2808: select node_label into l_node_label from cs_sr_uwq_nodes_tl
2809: where node_id=l_node_id and language=userenv('LANG');
2810: exception
2811: when NO_DATA_FOUND then
2812: l_node_label:='Error: No Label ';

Line 2854: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2850: , res_cat_enum_flag
2851: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
2852: l_node_query,l_cursor_sql,l_node_id
2853: , l_res_cat_enum_flag
2854: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2855: where uwq_b.node_id = uwq_tl.node_id
2856: and uwq_tl.language = userenv('LANG')
2857: and parent_id = l_node_id and enabled_flag='Y'
2858: and node_query = 'CURSOR' ;

Line 2998: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2994: l_res_cat_enum_flag varchar2(1);
2995:
2996: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
2997: data_source
2998: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2999: where uwq_b.node_id = uwq_tl.node_id
3000: and uwq_tl.language = userenv('LANG')
3001: and parent_id = l_node_id
3002: and node_query='CURSOR' and enabled_flag='Y';

Line 3078: select node_label into l_node_label from cs_sr_uwq_nodes_tl

3074:
3075: l_node_counter := l_node_counter + 1;
3076:
3077: begin
3078: select node_label into l_node_label from cs_sr_uwq_nodes_tl
3079: where node_id=l_node_id and language=userenv('LANG');
3080: exception
3081: when NO_DATA_FOUND then
3082: l_node_label:='Error: No Label ';

Line 3145: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

3141: select node_label,node_view,cursor_key_col,data_source,
3142: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
3143: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
3144: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
3145: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
3146: where uwq_b.node_id = uwq_tl.node_id
3147: and uwq_tl.language = userenv('LANG')
3148: and parent_id = l_node_id and enabled_flag='Y'
3149: and node_query = 'CURSOR' ;

Line 3334: select node_label into l_node_label from cs_sr_uwq_nodes_tl

3330:
3331: l_node_counter := l_node_counter + 1;
3332:
3333: begin
3334: select node_label into l_node_label from cs_sr_uwq_nodes_tl
3335: where node_id=l_node_id and language=userenv('LANG');
3336: exception
3337: when NO_DATA_FOUND then
3338: l_node_label:='Error: No Label ';

Line 3379: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

3375: , res_cat_enum_flag
3376: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
3377: l_node_query,l_cursor_sql,l_node_id
3378: , l_res_cat_enum_flag
3379: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
3380: where uwq_b.node_id = uwq_tl.node_id
3381: and uwq_tl.language = userenv('LANG')
3382: and parent_id = l_node_id and enabled_flag='Y'
3383: and node_query = 'CURSOR' ;